Menu
▾
▴
cubridcluster-devs — CUBRID Cluster Developers
You can subscribe to this list here.
| 2010 |
Jan
|
Feb
|
Mar
|
Apr
|
May
(36) |
Jun
(144) |
Jul
(125) |
Aug
(283) |
Sep
(130) |
Oct
(115) |
Nov
(119) |
Dec
(120) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2011 |
Jan
(126) |
Feb
(5) |
Mar
|
Apr
(27) |
May
(15) |
Jun
(8) |
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
|
From: cubridcluster <no...@so...> - 2011-02-23 08:28:06
|
#451: [TASK] CUBRID Cluster Performance Turning
--------------------------+-------------------------------------------------
Reporter: wzcsoft | Owner: cubridcluster-triage
Type: defect | Status: new
Priority: major | Milestone: M3 - load balancing
Component: cubrid (all) | Version: Cluster 2010 R1
Severity: unclear | Keywords: Performance Turning
--------------------------+-------------------------------------------------
Comment(by wzcsoft):
callgrind result:
[https://cubridcluster.svn.sourceforge.net/svnroot/cubridcluster/wiki/trac/htdocs/performance/performance.tar.gz]
--
Ticket URL: <http://sourceforge.net/apps/trac/cubridcluster/ticket/451#comment:1>
cubridcluster <http://sourceforge.net/projects/cubridcluster/>
SF-project cubridcluster
|
|
From: cubridcluster <no...@so...> - 2011-02-23 08:21:30
|
#451: [TASK] CUBRID Cluster Performance Turning
--------------------------+-------------------------------------------------
Reporter: wzcsoft | Owner: cubridcluster-triage
Type: defect | Status: new
Priority: major | Milestone: M3 - load balancing
Component: cubrid (all) | Version: Cluster 2010 R1
Severity: unclear | Keywords: Performance Turning
--------------------------+-------------------------------------------------
I tested and compared the performance of create/drop local partition table
and global partition table. Here's some conclusion about it:
1. gethostbyname() This function affects too much performance. It is
called by ccf_get_node_ip(). It takes about 15% of execution times.
2. tf_class_size() It takes 2.2% of execution times. The schema of real
and proxy table are the same, so maybe we can reduce the called time of
this function.
3. Client sending requests to remote server is by forwarding, send
directly, is better for performance.
The attach file is the result generated by callgrind.
--
Ticket URL: <http://sourceforge.net/apps/trac/cubridcluster/ticket/451>
cubridcluster <http://sourceforge.net/projects/cubridcluster/>
SF-project cubridcluster
|
|
From: SourceForge.net <no...@so...> - 2011-02-18 10:12:09
|
The following forum message was posted by iamyaw at http://sourceforge.net/projects/cubridcluster/forums/forum/1129811/topic/4374702: How does the CUBRID process multiple row update with unique constraints? [code] create table tb (id int unique); insert into tb values (1); insert into tb values (2); insert into tb values (3); update tb set id = id + 1; [/code] The CUBRID uses B+tree to check uniqueness. Execution of UPDATE query contains two operations on B+tree. Deleting the old key and then inserting the new key. (See the btree_update() function.) When the new key is inserted (btree_insert() function), if the B+tree is unique index, the function can return NULL with unique violation error. Then, how is the above scenario possible? If the value of the record is changed from 1 to 2, then the old key value 1 will be deleted from the B+tree and the new key value 2 will be inserted into. But, the key value 2 exists already in the B+tree. It looks unique violation. How to cope this situation? You can find the parameter 'op_type' of the function 'btree_insert()'. According to the function comment, we can see that there are five operation types including SINGLE_ROW_INSERT, SINGLE_ROW_UPDATE, SINGLE_ROW_MODIFY, MUlTI_ROW_INSERT, and MULTI_ROW_UPDATE. Also, you can find code blocks of 'do_unique_check = false' if 'op_type == MULTI_ROW_UPDATE'. The parameter 'unique_stat_info' of the 'btree_insert()' function is used to check unique violation lately. The 'unique_stat_info' structure has fields 'num_nulls', 'num_keys', and 'num_oids'. After finishing whole multiple row update operations, the 'unique_stat_info->num_nulls' + 'num_keys' should be same with the 'num_oids'. If not, the uniqueness is violated. |
|
From: cubridcluster <no...@so...> - 2011-02-14 07:54:40
|
#387: [BUG] cub_cas crash at xts_reserve_location_in_stream
--------------------------+-------------------------------------------------
Reporter: wzcsoft | Owner: xiaoshan78
Type: defect | Status: closed
Priority: major | Milestone: M2 - distributed partition
Component: cubrid (all) | Version: Cluster 2010 R1
Severity: unclear | Resolution: fixed
Keywords: bug |
--------------------------+-------------------------------------------------
Changes (by xiaoshan78):
* status: assigned => closed
* resolution: => fixed
* milestone: M3 - load balancing => M2 - distributed partition
Comment:
This bug is resolved in M2
--
Ticket URL: <http://sourceforge.net/apps/trac/cubridcluster/ticket/387#comment:11>
cubridcluster <http://sourceforge.net/projects/cubridcluster/>
SF-project cubridcluster
|
|
From: cubridcluster <no...@so...> - 2011-02-01 06:51:20
|
#221: [FR]Global serial
--------------------------------+-------------------------------------------
Reporter: miaoyu | Owner: wzcsoft
Type: task | Status: closed
Priority: major | Milestone: M2 - distributed partition
Component: cubrid (all) | Version: Cluster 2010 R1
Severity: unclear | Resolution: fixed
Keywords: #221 Global serial |
--------------------------------+-------------------------------------------
Changes (by xiaoshan78):
* status: assigned => closed
* resolution: => fixed
--
Ticket URL: <http://sourceforge.net/apps/trac/cubridcluster/ticket/221#comment:4>
cubridcluster <http://sourceforge.net/projects/cubridcluster/>
SF-project cubridcluster
|
|
From: cubridcluster <no...@so...> - 2011-01-31 09:04:40
|
#407: [bug]static declaration of 'qexec_next_merge_block' follows non-static
declaration
--------------------------+-------------------------------------------------
Reporter: miaoyu | Owner: xiaoshan78
Type: defect | Status: closed
Priority: major | Milestone: M2 - distributed partition
Component: cubrid (all) | Version: Cluster 2010 R1
Severity: system crash | Resolution: fixed
Keywords: bug |
--------------------------+-------------------------------------------------
Changes (by xiaoshan78):
* status: assigned => closed
* resolution: => fixed
Comment:
No comments, I will close it.
--
Ticket URL: <http://sourceforge.net/apps/trac/cubridcluster/ticket/407#comment:3>
cubridcluster <http://sourceforge.net/projects/cubridcluster/>
SF-project cubridcluster
|
|
From: cubridcluster <no...@so...> - 2011-01-31 09:04:17
|
#174: [PR] Some source code files contain the absolute path information
--------------------------+-------------------------------------------------
Reporter: wzcsoft | Owner: xiaoshan78
Type: defect | Status: closed
Priority: major | Milestone: M1 - global schema
Component: cubrid (all) | Version: R3.0 cluster
Severity: unclear | Resolution: fixed
Keywords: |
--------------------------+-------------------------------------------------
Changes (by xiaoshan78):
* status: assigned => closed
* resolution: => fixed
Comment:
No comments, I will close it.
--
Ticket URL: <http://sourceforge.net/apps/trac/cubridcluster/ticket/174#comment:7>
cubridcluster <http://sourceforge.net/projects/cubridcluster/>
SF-project cubridcluster
|
|
From: cubridcluster <no...@so...> - 2011-01-31 04:27:06
|
#174: [PR] Some source code files contain the absolute path information
--------------------------+-------------------------------------------------
Reporter: wzcsoft | Owner: xiaoshan78
Type: defect | Status: assigned
Priority: major | Milestone: M1 - global schema
Component: cubrid (all) | Version: R3.0 cluster
Severity: unclear | Keywords:
--------------------------+-------------------------------------------------
Changes (by miaoyu):
* owner: miaoyu => xiaoshan78
Comment:
The two souce code is generated by flex 2.5.35.
It's ok to me.
Thanks.
--
Ticket URL: <http://sourceforge.net/apps/trac/cubridcluster/ticket/174#comment:6>
cubridcluster <http://sourceforge.net/projects/cubridcluster/>
SF-project cubridcluster
|
|
From: cubridcluster <no...@so...> - 2011-01-31 03:31:53
|
#174: [PR] Some source code files contain the absolute path information
--------------------------+-------------------------------------------------
Reporter: wzcsoft | Owner: miaoyu
Type: defect | Status: assigned
Priority: major | Milestone: M1 - global schema
Component: cubrid (all) | Version: R3.0 cluster
Severity: unclear | Keywords:
--------------------------+-------------------------------------------------
Changes (by dong1):
* owner: wzcsoft => miaoyu
Comment:
Ok, I have install the flex 2.5.35
and regenerate the two files, please review:
https://cubridcluster.svn.sourceforge.net/svnroot/cubridcluster/cv/ticket%23174source_code_contain_absolute_path.creview
thanks,
--
Ticket URL: <http://sourceforge.net/apps/trac/cubridcluster/ticket/174#comment:5>
cubridcluster <http://sourceforge.net/projects/cubridcluster/>
SF-project cubridcluster
|
|
From: cubridcluster <no...@so...> - 2011-01-31 02:52:29
|
#215: [FR]Global schema of partitioned table (by hash)
--------------------------------------------------------------+-------------
Reporter: miaoyu | Owner: cubridcluster-triage
Type: task | Status: closed
Priority: major | Milestone: M2 - distributed partition
Component: cubrid (all) | Version: Cluster 2010 R1
Severity: unclear | Resolution: fixed
Keywords: #215 Global schema of partitioned table(by hash) |
--------------------------------------------------------------+-------------
Changes (by xiaoshan78):
* status: assigned => closed
* resolution: => fixed
--
Ticket URL: <http://sourceforge.net/apps/trac/cubridcluster/ticket/215#comment:6>
cubridcluster <http://sourceforge.net/projects/cubridcluster/>
SF-project cubridcluster
|
|
From: cubridcluster <no...@so...> - 2011-01-31 02:52:26
|
#216: [FR]Schema of constraint -- index/reverse index
------------------------------------------------------------------+---------
Reporter: miaoyu | Owner: cubridcluster-triage
Type: task | Status: closed
Priority: major | Milestone: M2 - distributed partition
Component: cubrid (all) | Version: Cluster 2010 R1
Severity: unclear | Resolution: fixed
Keywords: #216 [FR]Schema of constraint -- index/reverse index |
------------------------------------------------------------------+---------
Changes (by xiaoshan78):
* status: assigned => closed
* resolution: => fixed
--
Ticket URL: <http://sourceforge.net/apps/trac/cubridcluster/ticket/216#comment:5>
cubridcluster <http://sourceforge.net/projects/cubridcluster/>
SF-project cubridcluster
|
|
From: cubridcluster <no...@so...> - 2011-01-30 02:43:06
|
#216: [FR]Schema of constraint -- index/reverse index
--------------------------+-------------------------------------------------
Reporter: miaoyu | Owner: cubridcluster-triage
Type: task | Status: assigned
Priority: major | Milestone: M2 - distributed partition
Component: cubrid (all) | Version: Cluster 2010 R1
Severity: unclear | Keywords: #216 [FR]Schema of constraint -- index/reverse index
--------------------------+-------------------------------------------------
Changes (by miaoyu):
* owner: miaoyu => cubridcluster-triage
Comment:
This feature has been implemented and it could be closed.
--
Ticket URL: <http://sourceforge.net/apps/trac/cubridcluster/ticket/216#comment:4>
cubridcluster <http://sourceforge.net/projects/cubridcluster/>
SF-project cubridcluster
|
|
From: cubridcluster <no...@so...> - 2011-01-30 02:40:36
|
#215: [FR]Global schema of partitioned table (by hash)
--------------------------+-------------------------------------------------
Reporter: miaoyu | Owner: cubridcluster-triage
Type: task | Status: assigned
Priority: major | Milestone: M2 - distributed partition
Component: cubrid (all) | Version: Cluster 2010 R1
Severity: unclear | Keywords: #215 Global schema of partitioned table(by hash)
--------------------------+-------------------------------------------------
Changes (by miaoyu):
* owner: miaoyu => cubridcluster-triage
Comment:
This task is finished.
It could be closed.
--
Ticket URL: <http://sourceforge.net/apps/trac/cubridcluster/ticket/215#comment:5>
cubridcluster <http://sourceforge.net/projects/cubridcluster/>
SF-project cubridcluster
|
|
From: cubridcluster <no...@so...> - 2011-01-30 02:17:06
|
#330: [FR]Unique/Reverse Unique/Primare Key on partition table
-----------------------------------------------------------------------+----
Reporter: miaoyu | Owner: cubridcluster-triage
Type: task | Status: closed
Priority: major | Milestone: M2 - distributed partition
Component: cubrid (all) | Version: Cluster 2010 R1
Severity: unclear | Resolution: fixed
Keywords: #330 Unique/Reverse Unique/Primare Key on partition table |
-----------------------------------------------------------------------+----
Changes (by wzcsoft):
* status: assigned => closed
* resolution: => fixed
--
Ticket URL: <http://sourceforge.net/apps/trac/cubridcluster/ticket/330#comment:4>
cubridcluster <http://sourceforge.net/projects/cubridcluster/>
SF-project cubridcluster
|
|
From: cubridcluster <no...@so...> - 2011-01-30 02:16:47
|
#330: [FR]Unique/Reverse Unique/Primare Key on partition table
--------------------------+-------------------------------------------------
Reporter: miaoyu | Owner: cubridcluster-triage
Type: task | Status: assigned
Priority: major | Milestone: M2 - distributed partition
Component: cubrid (all) | Version: Cluster 2010 R1
Severity: unclear | Keywords: #330 Unique/Reverse Unique/Primare Key on partition table
--------------------------+-------------------------------------------------
Changes (by wzcsoft):
* owner: wzcsoft => cubridcluster-triage
Comment:
This part is finished.
--
Ticket URL: <http://sourceforge.net/apps/trac/cubridcluster/ticket/330#comment:3>
cubridcluster <http://sourceforge.net/projects/cubridcluster/>
SF-project cubridcluster
|
|
From: cubridcluster <no...@so...> - 2011-01-29 08:41:40
|
#389: [BUG] Create global index may crash cub_server
--------------------------+-------------------------------------------------
Reporter: wzcsoft | Owner: xiaoshan78
Type: defect | Status: closed
Priority: major | Milestone: M2 - distributed partition
Component: cubrid (all) | Version: Cluster 2010 R1
Severity: unclear | Resolution: fixed
Keywords: bug |
--------------------------+-------------------------------------------------
Changes (by xiaoshan78):
* status: assigned => closed
* resolution: => fixed
--
Ticket URL: <http://sourceforge.net/apps/trac/cubridcluster/ticket/389#comment:4>
cubridcluster <http://sourceforge.net/projects/cubridcluster/>
SF-project cubridcluster
|
|
From: cubridcluster <no...@so...> - 2011-01-29 08:34:20
|
#366: [bug]server side insert cause creating a heapfile for global superclass
--------------------------+-------------------------------------------------
Reporter: miaoyu | Owner: xiaoshan78
Type: defect | Status: closed
Priority: major | Milestone: M2 - distributed partition
Component: cubrid (all) | Version: Cluster 2010 R1
Severity: unclear | Resolution: fixed
Keywords: bug |
--------------------------+-------------------------------------------------
Changes (by xiaoshan78):
* status: assigned => closed
* resolution: => fixed
Comment:
OK, no problem.
I will close it.
--
Ticket URL: <http://sourceforge.net/apps/trac/cubridcluster/ticket/366#comment:7>
cubridcluster <http://sourceforge.net/projects/cubridcluster/>
SF-project cubridcluster
|
|
From: cubridcluster <no...@so...> - 2011-01-28 10:26:26
|
#407: [bug]static declaration of 'qexec_next_merge_block' follows non-static
declaration
--------------------------+-------------------------------------------------
Reporter: miaoyu | Owner: xiaoshan78
Type: defect | Status: assigned
Priority: major | Milestone: M2 - distributed partition
Component: cubrid (all) | Version: Cluster 2010 R1
Severity: system crash | Keywords: bug
--------------------------+-------------------------------------------------
Changes (by miaoyu):
* owner: miaoyu => xiaoshan78
Comment:
It's OK to me.
Thanks.
--
Ticket URL: <http://sourceforge.net/apps/trac/cubridcluster/ticket/407#comment:2>
cubridcluster <http://sourceforge.net/projects/cubridcluster/>
SF-project cubridcluster
|
|
From: cubridcluster <no...@so...> - 2011-01-28 02:10:43
|
#407: [bug]static declaration of 'qexec_next_merge_block' follows non-static
declaration
--------------------------+-------------------------------------------------
Reporter: miaoyu | Owner: miaoyu
Type: defect | Status: assigned
Priority: major | Milestone: M2 - distributed partition
Component: cubrid (all) | Version: Cluster 2010 R1
Severity: system crash | Keywords: bug
--------------------------+-------------------------------------------------
Changes (by dong1):
* owner: piaosongmei => miaoyu
* status: new => assigned
Comment:
Ok, I have fixed in:
https://cubridcluster.svn.sourceforge.net/svnroot/cubridcluster/cv/ticket%23407_bug_declaration_failed.creview
please review it.
Thanks a lot,
--
Ticket URL: <http://sourceforge.net/apps/trac/cubridcluster/ticket/407#comment:1>
cubridcluster <http://sourceforge.net/projects/cubridcluster/>
SF-project cubridcluster
|
|
From: cubridcluster <no...@so...> - 2011-01-28 01:38:34
|
#407: [bug]static declaration of 'qexec_next_merge_block' follows non-static
declaration
--------------------------+-------------------------------------------------
Reporter: miaoyu | Owner: piaosongmei
Type: defect | Status: new
Priority: major | Milestone: M2 - distributed partition
Component: cubrid (all) | Version: Cluster 2010 R1
Severity: system crash | Keywords: bug
--------------------------+-------------------------------------------------
Revision: r692
Build block:
static declaration of 'qexec_next_merge_block' follows non-static
declaration.
In query_executor.c:5317, qexec_next_merge_block() is defined as
static.But in query/query_executor.h:811, it is declaration as external.
--
Ticket URL: <http://sourceforge.net/apps/trac/cubridcluster/ticket/407>
cubridcluster <http://sourceforge.net/projects/cubridcluster/>
SF-project cubridcluster
|
|
From: cubridcluster <no...@so...> - 2011-01-25 11:20:18
|
#387: [BUG] cub_cas crash at xts_reserve_location_in_stream
--------------------------+-------------------------------------------------
Reporter: wzcsoft | Owner: xiaoshan78
Type: defect | Status: assigned
Priority: major | Milestone: M3 - load balancing
Component: cubrid (all) | Version: Cluster 2010 R1
Severity: unclear | Keywords: bug
--------------------------+-------------------------------------------------
Changes (by miaoyu):
* owner: miaoyu => xiaoshan78
Comment:
The code is OK to me.
Thanks.
--
Ticket URL: <http://sourceforge.net/apps/trac/cubridcluster/ticket/387#comment:10>
cubridcluster <http://sourceforge.net/projects/cubridcluster/>
SF-project cubridcluster
|
|
From: cubridcluster <no...@so...> - 2011-01-25 10:41:01
|
#402: [bug]Use void when a function has no parameter.
--------------------------+-------------------------------------------------
Reporter: miaoyu | Owner: miaoyu
Type: defect | Status: closed
Priority: major | Milestone: M2 - distributed partition
Component: cubrid (all) | Version: Cluster 2010 R1
Severity: unclear | Resolution: fixed
Keywords: bug |
--------------------------+-------------------------------------------------
Changes (by miaoyu):
* status: accepted => closed
* resolution: => fixed
--
Ticket URL: <http://sourceforge.net/apps/trac/cubridcluster/ticket/402#comment:3>
cubridcluster <http://sourceforge.net/projects/cubridcluster/>
SF-project cubridcluster
|
|
From: cubridcluster <no...@so...> - 2011-01-25 10:40:11
|
#402: [bug]Use void when a function has no parameter.
--------------------------+-------------------------------------------------
Reporter: miaoyu | Owner: miaoyu
Type: defect | Status: accepted
Priority: major | Milestone: M2 - distributed partition
Component: cubrid (all) | Version: Cluster 2010 R1
Severity: unclear | Keywords: bug
--------------------------+-------------------------------------------------
Comment(by miaoyu):
This has been fixed.
Code changeing:
extern unsigned int get_my_host_id ();
-->
extern unsigned int get_my_host_id (void);
revision: 672
--
Ticket URL: <http://sourceforge.net/apps/trac/cubridcluster/ticket/402#comment:2>
cubridcluster <http://sourceforge.net/projects/cubridcluster/>
SF-project cubridcluster
|
|
From: cubridcluster <no...@so...> - 2011-01-25 10:35:18
|
#402: [bug]Use void when a function has no parameter.
--------------------------+-------------------------------------------------
Reporter: miaoyu | Owner: miaoyu
Type: defect | Status: accepted
Priority: major | Milestone: M2 - distributed partition
Component: cubrid (all) | Version: Cluster 2010 R1
Severity: unclear | Keywords: bug
--------------------------+-------------------------------------------------
Changes (by miaoyu):
* status: new => accepted
--
Ticket URL: <http://sourceforge.net/apps/trac/cubridcluster/ticket/402#comment:1>
cubridcluster <http://sourceforge.net/projects/cubridcluster/>
SF-project cubridcluster
|
|
From: cubridcluster <no...@so...> - 2011-01-25 10:25:43
|
#402: [bug]Use void when a function has no parameter.
--------------------------+-------------------------------------------------
Reporter: miaoyu | Owner: miaoyu
Type: defect | Status: new
Priority: major | Milestone: M2 - distributed partition
Component: cubrid (all) | Version: Cluster 2010 R1
Severity: unclear | Keywords: bug
--------------------------+-------------------------------------------------
In base/porting.h:
the function prototype of get_my_host_id is wrong.
When a function has no parameter, we should use key word "void" to
represent this feature. Fox example:
{{{
/* good example */
int foo (void);
/* bad example */
int foo ();
}}}
The reason is that in C foo() means foo could have any number of
parameters, but foo(void) means foo doesn't have any parameter.
--
Ticket URL: <http://sourceforge.net/apps/trac/cubridcluster/ticket/402>
cubridcluster <http://sourceforge.net/projects/cubridcluster/>
SF-project cubridcluster
|
