Comment 22 for bug 1123233

Revision history for this message
Raghavendra D Prabhu (raghavendra-prabhu) wrote :

To gather more info, tried running it with general_log enabled.

However, in that case, node0 doesn't crash and node1 dies with:

========================================
InnoDB: There was a problem in converting'table100_innodb_key_pk_parts_2_int#P#p0' in charset filename to charset utf8_general_ciInnoDB: There was a problem in converting'table100_innodb_key_pk_parts_2_int#P#p1' in charset filename to charset utf8_general_ci130812 4:36:04 [ERROR] Slave SQL: Error 'Table 'test.table100_innodb_int_autoinc' doesn't exist' on query. Default database: 'test'. Query: 'CREATE TABLE r LIKE `table100_innodb_int_autoinc`', Error_code: 1146
130812 4:36:04 [Warning] WSREP: RBR event 1 Query apply warning: 1, 496
130812 4:36:04 [Warning] WSREP: Ignoring error for TO isolated action: source: 9c997c31-0308-11e3-b4e2-1f1ac96f6f57 version: 2 local: 0 state: APPLYING flags: 65 conn_id: 18 trx_id: -1 seqnos (l: 507, g: 496, s: 493, d: 495, ts: 1376282164810854701)
InnoDB: DEBUG: update_statistics for test/#sql-1a20_2#P#p0.
InnoDB: DEBUG: update_statistics for test/#sql-1a20_2#P#p1.
InnoDB: DEBUG: update_statistics for test/#sql-1a20_2#P#p0.
InnoDB: DEBUG: update_statistics for test/#sql-1a20_2#P#p1.
InnoDB: There was a problem in converting'table0_innodb_key_pk_parts_2_int_autoinc#P#p0' in charset filename to charset utf8_general_ciInnoDB: There was a problem in converting'table0_innodb_key_pk_parts_2_int_autoinc#P#p1' in charset filename to charset utf8_general_ci130812 4:36:04 [ERROR] Slave SQL: Error 'Table 'test.table1_innodb_int_autoinc' doesn't exist' on query. Default database: 'test'. Query: 'ALTER TABLE `table1_innodb_int_autoinc` MODIFY `col_int` BIT FIRST', Error_code: 1146
130812 4:36:04 [Warning] WSREP: RBR event 1 Query apply warning: 1, 498
130812 4:36:04 [Warning] WSREP: Ignoring error for TO isolated action: source: 9c997c31-0308-11e3-b4e2-1f1ac96f6f57 version: 2 local: 0 state: APPLYING flags: 65 conn_id: 11 trx_id: -1 seqnos (l: 509, g: 498, s: 495, d: 497, ts: 1376282164863088550)
130812 4:36:04 [Warning] WSREP: BF applier failed to open_and_lock_tables: 1146, fatal: 0 wsrep = (exec_mode: 1 conflict_state: 0 seqno: 501)
130812 4:36:04 [ERROR] Slave SQL: Error executing row event: 'Table 'test.r' doesn't exist', Error_code: 1146
130812 4:36:04 [Warning] WSREP: RBR event 2 Write_rows apply warning: 1146, 501
130812 4:36:04 [ERROR] WSREP: Failed to apply trx: source: 9c997c31-0308-11e3-b4e2-1f1ac96f6f57 version: 2 local: 0 state: APPLYING flags: 129 conn_id: 18 trx_id: 2630 seqnos (l: 512, g: 501, s: 496, d: 500, ts: 1376282164870997033)
130812 4:36:04 [ERROR] WSREP: Failed to apply app buffer: seqno: 501, status: WSREP_FATAL
  at galera/src/replicator_smm.cpp:apply_wscoll():52
  at galera/src/replicator_smm.cpp:apply_trx_ws():118
130812 4:36:04 [ERROR] WSREP: Node consistency compromized, aborting...
130812 4:36:04 [Note] WSREP: Closing send monitor...
130812 4:36:04 [Note] WSREP: Closed send monitor.
130812 4:36:04 [Note] WSREP: gcomm: terminating thread
130812 4:36:04 [Note] WSREP: gcomm: joining thread
130812 4:36:04 [Note] WSREP: gcomm: closing backend
130812 4:36:05 [Note] WSREP: view(view_id(NON_PRIM,9c997c31-0308-11e3-b4e2-1f1ac96f6f57,2) memb {
 9dded69f-0308-11e3-9fad-0b149f00f5a1,
} joined {
} left {
} partitioned {
 9c997c31-0308-11e3-b4e2-1f1ac96f6f57,
})

==================================================