Comment 2 for bug 1179361

Revision history for this message
Gea-Suan Lin (gslin) wrote :

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)