Thanks!
I've test for ROW_FORMAT=DYNAMIC, and it will not fix this issue:
130513 20:15:50 [ERROR] Slave SQL: Could not execute Write_rows event on table t.tag_raw; Duplicate entry '0-65-17-中文測試' for key 'PRIMARY', Error_code: 1062; handler error HA_ERR_FOUND_DUPP_KEY; the event's master log FIRST, end_log_pos 114, Error_code: 1062 130513 20:15:50 [Warning] WSREP: RBR event 2 Write_rows apply warning: 121, 259584 130513 20:15:50 [ERROR] WSREP: Failed to apply trx: source: 6aaa649a-a85b-11e2-0800-08cc46d2f954 version: 2 local: 0 state: APPLYING flags: 1 conn_id: 29646 trx_id: 6885 90 seqnos (l: 3068, g: 259584, s: 259583, d: 259455, ts: 1368447350638588082) 130513 20:15:50 [ERROR] WSREP: Failed to apply app buffer: seqno: 259584, status: WSREP_FATAL at galera/src/replicator_smm.cpp:apply_wscoll():52 at galera/src/replicator_smm.cpp:apply_trx_ws():118 130513 20:15:50 [ERROR] WSREP: Node consistency compromized, aborting... 130513 20:15:50 [Note] WSREP: Closing send monitor... 130513 20:15:50 [Note] WSREP: Closed send monitor. 130513 20:15:50 [Note] WSREP: gcomm: terminating thread 130513 20:15:50 [Note] WSREP: gcomm: joining thread 130513 20:15:50 [Note] WSREP: gcomm: closing backend 130513 20:15:50 [Note] WSREP: view(view_id(NON_PRIM,6aaa649a-a85b-11e2-0800-08cc46d2f954,13) memb { a524b69a-bbc6-11e2-0800-b438b8bdfa95, } joined { } left { } partitioned { 6aaa649a-a85b-11e2-0800-08cc46d2f954, 986d80ee-a85f-11e2-0800-fa13f167bc00, }) 130513 20:15:50 [Note] WSREP: New COMPONENT: primary = no, bootstrap = no, my_idx = 0, memb_num = 1 130513 20:15:50 [Note] WSREP: view((empty))
> SHOW CREATE TABLE tag_raw \G *************************** 1. row *************************** Table: tag_raw Create Table: CREATE TABLE `tag_raw` ( `obj_type` varchar(16) NOT NULL DEFAULT '' COMMENT 'obj_type', `obj_id` varchar(20) NOT NULL COMMENT 'obj_type編號', `tag` varchar(255) NOT NULL, `msno` bigint(20) NOT NULL DEFAULT '0' COMMENT 'user id', `terr_id` int(11) NOT NULL COMMENT '地區編號', PRIMARY KEY (`obj_type`,`obj_id`,`msno`,`tag`), KEY `obj_id` (`obj_id`), KEY `tag` (`tag`), KEY `msno` (`msno`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC 1 row in set (0.00 sec)
Thanks!
I've test for ROW_FORMAT=DYNAMIC, and it will not fix this issue:
130513 20:15:50 [ERROR] Slave SQL: Could not execute Write_rows event on table t.tag_raw; Duplicate entry '0-65-17-中文測試' for key 'PRIMARY', Error_code: 1062; handler FOUND_DUPP_ KEY; the event's master log FIRST, end_log_pos 114, Error_code: 1062 a85b-11e2- 0800-08cc46d2f9 54 version: 2 local: 0 state: APPLYING flags: 1 conn_id: 29646 trx_id: 6885 8082) src/replicator_ smm.cpp: apply_wscoll( ):52 src/replicator_ smm.cpp: apply_trx_ ws():118 id(NON_ PRIM,6aaa649a- a85b-11e2- 0800-08cc46d2f9 54,13) memb {
a524b69a- bbc6-11e2- 0800-b438b8bdfa 95,
6aaa649a- a85b-11e2- 0800-08cc46d2f9 54,
986d80ee- a85f-11e2- 0800-fa13f167bc 00,
error HA_ERR_
130513 20:15:50 [Warning] WSREP: RBR event 2 Write_rows apply warning: 121, 259584
130513 20:15:50 [ERROR] WSREP: Failed to apply trx: source: 6aaa649a-
90 seqnos (l: 3068, g: 259584, s: 259583, d: 259455, ts: 136844735063858
130513 20:15:50 [ERROR] WSREP: Failed to apply app buffer: seqno: 259584, status: WSREP_FATAL
at galera/
at galera/
130513 20:15:50 [ERROR] WSREP: Node consistency compromized, aborting...
130513 20:15:50 [Note] WSREP: Closing send monitor...
130513 20:15:50 [Note] WSREP: Closed send monitor.
130513 20:15:50 [Note] WSREP: gcomm: terminating thread
130513 20:15:50 [Note] WSREP: gcomm: joining thread
130513 20:15:50 [Note] WSREP: gcomm: closing backend
130513 20:15:50 [Note] WSREP: view(view_
} joined {
} left {
} partitioned {
})
130513 20:15:50 [Note] WSREP: New COMPONENT: primary = no, bootstrap = no, my_idx = 0, memb_num = 1
130513 20:15:50 [Note] WSREP: view((empty))
> SHOW CREATE TABLE tag_raw \G ******* ******* ****** 1. row ******* ******* ******* ****** ,`obj_id` ,`msno` ,`tag`) ,
*******
Table: tag_raw
Create Table: CREATE TABLE `tag_raw` (
`obj_type` varchar(16) NOT NULL DEFAULT '' COMMENT 'obj_type',
`obj_id` varchar(20) NOT NULL COMMENT 'obj_type編號',
`tag` varchar(255) NOT NULL,
`msno` bigint(20) NOT NULL DEFAULT '0' COMMENT 'user id',
`terr_id` int(11) NOT NULL COMMENT '地區編號',
PRIMARY KEY (`obj_type`
KEY `obj_id` (`obj_id`),
KEY `tag` (`tag`),
KEY `msno` (`msno`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC
1 row in set (0.00 sec)