Percona XtraDB Cluster moved to https://jira.percona.com/projects/PXC

Assertion during abort: signal 11

Bug #1261028 reported by Raghavendra D Prabhu on 2013-12-14

This bug affects 1 person

	Status	Importance	Assigned to
Percona XtraDB Cluster moved to https://jira.percona.com/projects/PXC	Status tracked in 5.6
5.5	Fix Released	High	Unassigned
5.6	Fix Released	High	Unassigned

Bug Description

During abort (due to other galera issues), the mysqld crashes
with assertions in:

wsrep_prepare:

DBUG_ASSERT(thd->wsrep_trx_meta.gtid.seqno ==
WSREP_SEQNO_UNDEFINED);

wsrep_to_isolation_begin:

DBUG_ASSERT(thd->wsrep_trx_meta.gtid.seqno ==
WSREP_SEQNO_UNDEFINED);

This may be due to shutdown not being checked in those functions
(at least in wsrep_to_isolation_begin).

Seeing this only in 5.6

Full log: http://paste.wnohang.net/03031d

See original description

Revision history for this message

Raghavendra D Prabhu (raghavendra-prabhu) wrote on 2013-12-14:

Download full text (50.0 KiB)

Here is the backtrace:

stack_bottom = 7f227c133d68 thread_stack 0x40000
/mnt/workspace/PXC-5.6-mrandgen/BTYPE/release/Host/centos6-64/Percona-XtraDB-Cluster-5.6.15-25.1.613.Linux.x86_64/bin/mysqld(my_print_stacktrace+0x35)[0x901055]
/mnt/workspace/PXC-5.6-mrandgen/BTYPE/release/Host/centos6-64/Percona-XtraDB-Cluster-5.6.15-25.1.613.Linux.x86_64/bin/mysqld(handle_fatal_signal+0x4c4)[0x67f154]
/lib64/libpthread.so.0[0x35ea60f710]
/lib64/libc.so.6[0x35e9a79532]
/lib64/libc.so.6(__libc_malloc+0x71)[0x35e9a7a991]
/usr/lib64/libstdc++.so.6(_ZnwmRKSt9nothrow_t+0x1b)[0x35ec6bd13b]
/mnt/workspace/PXC-5.6-mrandgen/BTYPE/release/Host/centos6-64/Percona-XtraDB-Cluster-5.6.15-25.1.613.Linux.x86_64/bin/mysqld(_ZN10MDL_ticket6createEP11MDL_context13enum_mdl_type+0x27)[0x670947]
/mnt/workspace/PXC-5.6-mrandgen/BTYPE/release/Host/centos6-64/Percona-XtraDB-Cluster-5.6.15-25.1.613.Linux.x86_64/bin/mysqld(_ZN11MDL_context21try_acquire_lock_implEP11MDL_requestPP10MDL_ticket+0xa2)[0x673192]
/mnt/workspace/PXC-5.6-mrandgen/BTYPE/release/Host/centos6-64/Percona-XtraDB-Cluster-5.6.15-25.1.613.Linux.x86_64/bin/mysqld(_ZN11MDL_context12acquire_lockEP11MDL_requestm+0xa9)[0x6732f9]
/mnt/workspace/PXC-5.6-mrandgen/BTYPE/release/Host/centos6-64/Percona-XtraDB-Cluster-5.6.15-25.1.613.Linux.x86_64/bin/mysqld[0x6aeb27]
/mnt/workspace/PXC-5.6-mrandgen/BTYPE/release/Host/centos6-64/Percona-XtraDB-Cluster-5.6.15-25.1.613.Linux.x86_64/bin/mysqld(_Z10open_tableP3THDP10TABLE_LISTP18Open_table_context+0x5ec)[0x6b828c]
/mnt/workspace/PXC-5.6-mrandgen/BTYPE/release/Host/centos6-64/Percona-XtraDB-Cluster-5.6.15-25.1.613.Linux.x86_64/bin/mysqld(_Z11open_tablesP3THDPP10TABLE_LISTPjjP19Prelocking_strategy+0xdd5)[0x6ba6c5]
/mnt/workspace/PXC-5.6-mrandgen/BTYPE/release/Host/centos6-64/Percona-XtraDB-Cluster-5.6.15-25.1.613.Linux.x86_64/bin/mysqld(_Z30open_normal_and_derived_tablesP3THDP10TABLE_LISTj+0x4f)[0x6ba7ef]
/mnt/workspace/PXC-5.6-mrandgen/BTYPE/release/Host/centos6-64/Percona-XtraDB-Cluster-5.6.15-25.1.613.Linux.x86_64/bin/mysqld(_Z12mysql_insertP3THDP10TABLE_LISTR4ListI4ItemERS3_IS5_ES6_S6_15enum_duplicatesb+0x21f)[0x6ec85f]
/mnt/workspace/PXC-5.6-mrandgen/BTYPE/release/Host/centos6-64/Percona-XtraDB-Cluster-5.6.15-25.1.613.Linux.x86_64/bin/mysqld(_Z21mysql_execute_commandP3THD+0x1068)[0x701638]
/mnt/workspace/PXC-5.6-mrandgen/BTYPE/release/Host/centos6-64/Percona-XtraDB-Cluster-5.6.15-25.1.613.Linux.x86_64/bin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_state+0x608)[0x706888]
/mnt/workspace/PXC-5.6-mrandgen/BTYPE/release/Host/centos6-64/Percona-XtraDB-Cluster-5.6.15-25.1.613.Linux.x86_64/bin/mysqld[0x7069b1]
/mnt/workspace/PXC-5.6-mrandgen/BTYPE/release/Host/centos6-64/Percona-XtraDB-Cluster-5.6.15-25.1.613.Linux.x86_64/bin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0x1ad4)[0x708c34]
/mnt/workspace/PXC-5.6-mrandgen/BTYPE/release/Host/centos6-64/Percona-XtraDB-Cluster-5.6.15-25.1.613.Linux.x86_64/bin/mysqld(_Z10do_commandP3THD+0x1e3)[0x70a003]
/mnt/workspace/PXC-5.6-mrandgen/BTYPE/release/Host/centos6-64/Percona-XtraDB-Cluster-5.6.15-25.1.613.Linux.x86_64/bin/mysqld(_Z24do_handle_one_connectionP3THD+0x17f)[0x6d389f]
/mnt/workspace/PXC-5.6-mrandgen/BTYPE/release/Host/cent...

Here is the backtrace:

However, this backtrace may due to abort being called.

Full log: http://paste.wnohang.net/03031d

Relevant part:
=====================

2013-12-11 16:08:06 25095 [ERROR] Slave SQL: Could not execute Delete_rows event on table test.table100_innodb_int; Cannot delete or update a parent row: a foreign key constraint fails (`test`.`u`, CONSTRAINT `u_ibfk_1` FOREIGN KEY (`col_char_12_key`) REFERENCES `table100_innodb_int` (`col_char_12_key`) ON DELETE NO ACTION), Error_code: 1451; handler error HA_ERR_ROW_IS_REFERENCED; the event's master log FIRST, end_log_pos 234, Error_code: 1451
2013-12-11 16:08:06 25095 [Warning] WSREP: RBR event 3 Delete_rows apply warning: 152, 101
2013-12-11 16:08:06 25095 [Warning] WSREP: Failed to apply app buffer: seqno: 101, status: 1
	 at galera/src/trx_handle.cpp:apply():340
Retrying 2th time
2013-12-11 16:08:06 25095 [ERROR] Slave SQL: Could not execute Delete_rows event on table test.table100_innodb_int; Cannot delete or update a parent row: a foreign key constraint fails (`test`.`u`, CONSTRAINT `u_ibfk_1` FOREIGN KEY (`col_char_12_key`) REFERENCES `table100_innodb_int` (`col_char_12_key`) ON DELETE NO ACTION), Error_code: 1451; handler error HA_ERR_ROW_IS_REFERENCED; the event's master log FIRST, end_log_pos 234, Error_code: 1451
2013-12-11 16:08:06 25095 [Warning] WSREP: RBR event 3 Delete_rows apply warning: 152, 101
2013-12-11 16:08:06 25095 [Warning] WSREP: Failed to apply app buffer: seqno: 101, status: 1
	 at galera/src/trx_handle.cpp:apply():340
Retrying 3th time
2013-12-11 16:08:06 25095 [ERROR] Slave SQL: Could not execute Delete_rows event on table test.table100_innodb_int; Cannot delete or update a parent row: a foreign key constraint fails (`test`.`u`, CONSTRAINT `u_ibfk_1` FOREIGN KEY (`col_char_12_key`) REFERENCES `table100_innodb_int` (`col_char_12_key`) ON DELETE NO ACTION), Error_code: 1451; handler error HA_ERR_ROW_IS_REFERENCED; the event's master log FIRST, end_log_pos 234, Error_code: 1451
2013-12-11 16:08:06 25095 [Warning] WSREP: RBR event 3 Delete_rows apply warning: 152, 101
2013-12-11 16:08:06 25095 [Warning] WSREP: Failed to apply app buffer: seqno: 101, status: 1
	 at galera/src/trx_handle.cpp:apply():340
Retrying 4th time
2013-12-11 16:08:06 25095 [ERROR] Slave SQL: Could not execute Delete_rows event on table test.table100_innodb_int; Cannot delete or update a parent row: a foreign key constraint fails (`test`.`u`, CONSTRAINT `u_ibfk_1` FOREIGN KEY (`col_char_12_key`) REFERENCES `table100_innodb_int` (`col_char_12_key`) ON DELETE NO ACTION), Error_code: 1451; handler error HA_ERR_ROW_IS_REFERENCED; the event's master log FIRST, end_log_pos 234, Error_code: 1451
2013-12-11 16:08:06 25095 [Warning] WSREP: RBR event 3 Delete_rows apply warning: 152, 101
2013-12-11 16:08:06 25095 [Warning] WSREP: failed to replay trx: source: 1f04d2aa-627e-11e3-9356-fbdcfc53c70d version: 3 local: 1 state: REPLAYING flags: 129 conn_id: 13 trx_id: 2373 seqnos (l: 110, g: 101, s: 97, d: 100, ts: 16968201220275789)
2013-12-11 16:08:06 25095 [Warning] WSREP: Failed to apply trx 101 4 times
2013-12-11 16:08:06 25095 [ERROR] WSREP: trx_replay failed for: 6, query: void
2013-12-11 16:08:06 25095 [ERROR] Aborting

2013-12-11 16:08:08 25095 [Note] WSREP: Node 1f04d2aa-627e-11e3-9356-fbdcfc53c70d state prim
2013-12-11 16:08:08 25095 [Note] WSREP: view(view_id(PRIM,1f04d2aa-627e-11e3-9356-fbdcfc53c70d,3) memb {
	1f04d2aa-627e-11e3-9356-fbdcfc53c70d,0
} joined {
} left {
} partitioned {
	1fbd6807-627e-11e3-b5a8-bf0ff3a0efc2,0
})
2013-12-11 16:08:08 25095 [Note] WSREP: forgetting 1fbd6807-627e-11e3-b5a8-bf0ff3a0efc2 (tcp://127.0.0.1:4814)
2013-12-11 16:08:08 25095 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 1
2013-12-11 16:08:08 25095 [Note] WSREP: STATE_EXCHANGE: sent state UUID: 6cb87b80-627e-11e3-87d2-5e0713078708
2013-12-11 16:08:08 25095 [Note] WSREP: STATE EXCHANGE: sent state msg: 6cb87b80-627e-11e3-87d2-5e0713078708
2013-12-11 16:08:08 25095 [Note] WSREP: STATE EXCHANGE: got state msg: 6cb87b80-627e-11e3-87d2-5e0713078708 from 0 (jhc-new-3-centos6-64)
2013-12-11 16:08:08 25095 [Note] WSREP: Quorum results:
	version    = 3,
	component  = PRIMARY,
	conf_id    = 2,
	members    = 1/1 (joined/total),
	act_id     = 104,
	last_appl. = 67,
	protocols  = 0/5/2 (gcs/repl/appl),
	group UUID = 1f06bdde-627e-11e3-8a06-ce019d8cb117
2013-12-11 16:08:08 25095 [Note] WSREP: Flow-control interval: [16, 16]
2013-12-11 16:08:08 25095 [Note] WSREP: killing local connection: 3
2013-12-11 16:08:08 25095 [Note] WSREP: killing local connection: 23
2013-12-11 16:08:08 25095 [Note] WSREP: killing local connection: 15
2013-12-11 16:08:08 25095 [Note] WSREP: killing local connection: 19
2013-12-11 16:08:08 25095 [Note] WSREP: killing local connection: 24
2013-12-11 16:08:08 25095 [Note] WSREP: killing local connection: 11
2013-12-11 16:08:08 25095 [Note] WSREP: killing local connection: 26
2013-12-11 16:08:08 25095 [Note] WSREP: killing local connection: 18
2013-12-11 16:08:08 25095 [Note] WSREP: killing local connection: 22
2013-12-11 16:08:08 25095 [Note] WSREP: killing local connection: 21
2013-12-11 16:08:08 25095 [Note] WSREP: killing local connection: 17
2013-12-11 16:08:08 25095 [Note] WSREP: killing local connection: 25
2013-12-11 16:08:08 25095 [Note] WSREP: killing local connection: 14
2013-12-11 16:08:08 25095 [Note] WSREP: killing local connection: 16
2013-12-11 16:08:08 25095 [Note] WSREP: killing local connection: 12
2013-12-11 16:08:08 25095 [Note] WSREP: killing local connection: 20
2013-12-11 16:08:08 25095 [Note] WSREP: Closing send monitor...
2013-12-11 16:08:08 25095 [Note] WSREP: Closed send monitor.
2013-12-11 16:08:08 25095 [Note] WSREP: gcomm: terminating thread
2013-12-11 16:08:08 25095 [Note] WSREP: gcomm: joining thread
2013-12-11 16:08:08 25095 [Note] WSREP: gcomm: closing backend
2013-12-11 16:08:08 25095 [Note] WSREP: view((empty))
2013-12-11 16:08:08 25095 [Note] WSREP: Received self-leave message.
2013-12-11 16:08:08 25095 [Note] WSREP: gcomm: closed
2013-12-11 16:08:08 25095 [Note] WSREP: Flow-control interval: [0, 0]
2013-12-11 16:08:08 25095 [Note] WSREP: Received SELF-LEAVE. Closing connection.
2013-12-11 16:08:08 25095 [Note] WSREP: Shifting SYNCED -> CLOSED (TO: 113)
2013-12-11 16:08:08 25095 [Note] WSREP: RECV thread exiting 0: Success
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: CREATE TABLE d LIKE `table1_innodb_key_pk_parts_2_int`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: CREATE TABLE v LIKE `table1_innodb_int_autoinc`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Note] WSREP: recv_thread() joined.
2013-12-11 16:08:09 25095 [Note] WSREP: Closing replication queue.
2013-12-11 16:08:09 25095 [Note] WSREP: Closing slave action queue.
2013-12-11 16:08:09 25095 [Note] WSREP: Service disconnected.
2013-12-11 16:08:09 25095 [Note] WSREP: rollbacker thread exiting
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: ALTER TABLE c ADD CONSTRAINT FOREIGN KEY (`col_int_key`) REFERENCES `table100_innodb_key_pk_parts_2_int` (`col_char_12_key`) ON DELETE RESTRICT. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: ALTER TABLE isolation failure
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: CREATE TABLE w LIKE `table100_innodb_key_pk_parts_2_int`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: DROP TABLE IF EXISTS a. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: DROP TABLE `table100_innodb_key_pk_parts_2_int`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: CREATE TABLE a LIKE `table1000_innodb_key_pk_parts_2_int`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: ALTER TABLE c RENAME `table100_innodb_key_pk_parts_2_int`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: ALTER TABLE isolation failure
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: DROP TABLE `table1000_innodb_key_pk_parts_2_int`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: ALTER TABLE d ADD CONSTRAINT FOREIGN KEY (`col_int_key`) REFERENCES `table1_innodb_key_pk_parts_2_int` (`col_int_key`) ON DELETE RESTRICT ON UPDATE SET NULL. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: ALTER TABLE isolation failure
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: CREATE TABLE d LIKE `table1000_innodb_key_pk_parts_2_int_autoinc`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: ALTER TABLE a RENAME `table1000_innodb_key_pk_parts_2_int`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: ALTER TABLE isolation failure
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: DROP TABLE `table1_innodb_key_pk_parts_2_int`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: DROP TABLE `table100_innodb_key_pk_parts_2_int`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: ALTER TABLE h ADD CONSTRAINT FOREIGN KEY (`col_char_12_key`) REFERENCES `table1_innodb_key_pk_parts_2_int_autoinc` (`col_int_key`) ON DELETE CASCADE. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: ALTER TABLE isolation failure
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: DROP TABLE IF EXISTS o. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: DROP TABLE `table1_innodb_key_pk_parts_2_int_autoinc`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: CREATE TABLE o LIKE `table100_innodb_int_autoinc`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: ALTER TABLE d RENAME `table1_innodb_key_pk_parts_2_int`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: ALTER TABLE isolation failure
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: ALTER TABLE h RENAME `table1_innodb_key_pk_parts_2_int_autoinc`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: ALTER TABLE isolation failure
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: ALTER TABLE o ADD CONSTRAINT FOREIGN KEY (`col_char_12_key`) REFERENCES `table100_innodb_int_autoinc` (`col_char_12_key`) ON DELETE RESTRICT. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: ALTER TABLE isolation failure
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: DROP TABLE `table1_innodb_key_pk_parts_2_int_autoinc`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: DROP TABLE `table100_innodb_int_autoinc`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: ALTER TABLE o RENAME `table100_innodb_int_autoinc`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: ALTER TABLE isolation failure
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: DROP TABLE `table100_innodb_int_autoinc`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: DROP TABLE IF EXISTS l. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: CREATE TABLE l LIKE `table100_innodb_int`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: DROP TABLE IF EXISTS w. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: DROP TABLE IF EXISTS c. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: CREATE TABLE w LIKE `table1000_innodb_int_autoinc`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: DROP TABLE `table1_innodb_key_pk_parts_2_int`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: DROP TABLE IF EXISTS q. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: ALTER TABLE w ADD CONSTRAINT FOREIGN KEY (`col_int_key`) REFERENCES `table1000_innodb_int_autoinc` (`col_char_12_key`) ON UPDATE RESTRICT. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: ALTER TABLE isolation failure
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: CREATE TABLE c LIKE `table100_innodb_int`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: DROP TABLE IF EXISTS i. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: CREATE TABLE q LIKE `table100_innodb_int_autoinc`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: DROP TABLE `table1000_innodb_int_autoinc`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: CREATE TABLE i LIKE `table100_innodb_int_autoinc`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: ALTER TABLE q ADD CONSTRAINT FOREIGN KEY (`col_char_12_key`) REFERENCES `table100_innodb_int_autoinc` (`col_char_12_key`) ON DELETE RESTRICT. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: ALTER TABLE isolation failure
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: ALTER TABLE w RENAME `table1000_innodb_int_autoinc`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: ALTER TABLE isolation failure
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: DROP TABLE `table100_innodb_int_autoinc`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: DROP TABLE `table100_innodb_int_autoinc`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: ALTER TABLE q RENAME `table100_innodb_int_autoinc`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: ALTER TABLE isolation failure
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: DROP TABLE `table1000_innodb_int_autoinc`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: DROP TABLE `table100_innodb_int_autoinc`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: CREATE TABLE n LIKE `table1_innodb_key_pk_parts_2_int`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: DROP TABLE IF EXISTS g. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: DROP TABLE IF EXISTS v. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: ALTER TABLE n ADD CONSTRAINT FOREIGN KEY (`col_int_key`) REFERENCES `table1_innodb_key_pk_parts_2_int` (`col_int_key`) ON DELETE NO ACTION ON UPDATE SET NULL. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: ALTER TABLE isolation failure
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: CREATE TABLE g LIKE `table1_innodb_key_pk_parts_2_int_autoinc`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: DROP TABLE `table1_innodb_key_pk_parts_2_int`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: CREATE TABLE v LIKE `table1000_innodb_key_pk_parts_2_int`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: ALTER TABLE n RENAME `table1_innodb_key_pk_parts_2_int`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: ALTER TABLE isolation failure
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: DROP TABLE `table1_innodb_key_pk_parts_2_int`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: ALTER TABLE c ADD CONSTRAINT FOREIGN KEY (`col_char_12_key`) REFERENCES `table100_innodb_int` (`col_int_key`) ON DELETE NO ACTION. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: ALTER TABLE isolation failure
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: ALTER TABLE v ADD CONSTRAINT FOREIGN KEY (`col_int_key`) REFERENCES `table1000_innodb_key_pk_parts_2_int` (`col_char_12_key`) ON UPDATE CASCADE. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: ALTER TABLE isolation failure
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: DROP TABLE `table100_innodb_int`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: CREATE TABLE k LIKE `table100_innodb_int_autoinc`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: DROP TABLE IF EXISTS h. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: ALTER TABLE c RENAME `table100_innodb_int`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: ALTER TABLE isolation failure
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: CREATE TABLE h LIKE `table1000_innodb_int`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: DROP TABLE `table100_innodb_int`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: ALTER TABLE h ADD CONSTRAINT FOREIGN KEY (`col_char_12_key`) REFERENCES `table1000_innodb_int` (`col_int_key`) ON UPDATE CASCADE ON DELETE NO ACTION. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: ALTER TABLE isolation failure
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: DROP TABLE IF EXISTS t. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: DROP TABLE `table1000_innodb_int`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: ALTER TABLE k ADD CONSTRAINT FOREIGN KEY (`col_char_12_key`) REFERENCES `table100_innodb_int_autoinc` (`col_char_12_key`) ON UPDATE NO ACTION. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: ALTER TABLE isolation failure
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: CREATE TABLE t LIKE `table100_innodb_int_autoinc`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: ALTER TABLE h RENAME `table1000_innodb_int`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: ALTER TABLE isolation failure
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: DROP TABLE `table100_innodb_int_autoinc`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: CREATE TABLE j LIKE `table1_innodb_int_autoinc`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: ALTER TABLE k RENAME `table100_innodb_int_autoinc`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: ALTER TABLE isolation failure
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: DROP TABLE `table1000_innodb_int`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: DROP TABLE `table100_innodb_int_autoinc`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: ALTER TABLE t ADD CONSTRAINT FOREIGN KEY (`col_char_12_key`) REFERENCES `table100_innodb_int_autoinc` (`col_int_key`) ON DELETE SET NULL ON UPDATE NO ACTION. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: ALTER TABLE isolation failure
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: ALTER TABLE i RENAME `table100_innodb_int_autoinc`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: ALTER TABLE isolation failure
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: DROP TABLE IF EXISTS f. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: CREATE TABLE q LIKE `table100_innodb_key_pk_parts_2_int_autoinc`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: DROP TABLE IF EXISTS e. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: ALTER TABLE d ADD CONSTRAINT FOREIGN KEY (`col_char_12_key`) REFERENCES `table1000_innodb_key_pk_parts_2_int_autoinc` (`col_char_12_key`) ON UPDATE CASCADE. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: ALTER TABLE isolation failure
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: CREATE TABLE e LIKE `table1000_innodb_key_pk_parts_2_int_autoinc`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: ALTER TABLE q ADD CONSTRAINT FOREIGN KEY (`col_int_key`) REFERENCES `table100_innodb_key_pk_parts_2_int_autoinc` (`col_int_key`) ON DELETE SET NULL. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: ALTER TABLE isolation failure
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: DROP TABLE `table1000_innodb_key_pk_parts_2_int`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: DROP TABLE `table100_innodb_key_pk_parts_2_int_autoinc`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: ALTER TABLE e ADD CONSTRAINT FOREIGN KEY (`col_char_12_key`) REFERENCES `table1000_innodb_key_pk_parts_2_int_autoinc` (`col_int_key`) ON DELETE CASCADE. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: ALTER TABLE isolation failure
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: ALTER TABLE q RENAME `table100_innodb_key_pk_parts_2_int_autoinc`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: ALTER TABLE v RENAME `table1000_innodb_key_pk_parts_2_int`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: ALTER TABLE isolation failure
2013-12-11 16:08:09 25095 [Warning] WSREP: ALTER TABLE isolation failure
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: DROP TABLE `table1000_innodb_key_pk_parts_2_int_autoinc`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: DROP TABLE `table100_innodb_key_pk_parts_2_int_autoinc`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: DROP TABLE `table1000_innodb_key_pk_parts_2_int`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: ALTER TABLE e RENAME `table1000_innodb_key_pk_parts_2_int_autoinc`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: ALTER TABLE isolation failure
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: DROP TABLE `table1000_innodb_key_pk_parts_2_int_autoinc`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: ALTER TABLE j ADD CONSTRAINT FOREIGN KEY (`col_char_12_key`) REFERENCES `table1_innodb_int_autoinc` (`col_int_key`) ON DELETE RESTRICT. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: DROP TABLE IF EXISTS e. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: ALTER TABLE isolation failure
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: CREATE TABLE e LIKE `table1000_innodb_int`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: DROP TABLE `table1_innodb_int_autoinc`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: ALTER TABLE u RENAME `table100_innodb_int`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: ALTER TABLE isolation failure
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: ALTER TABLE j RENAME `table1_innodb_int_autoinc`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: ALTER TABLE isolation failure
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: DROP TABLE `table1_innodb_int_autoinc`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: DROP TABLE `table1000_innodb_key_pk_parts_2_int_autoinc`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: DROP TABLE IF EXISTS h. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: CREATE TABLE s LIKE `table100_innodb_key_pk_parts_2_int`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: ALTER TABLE d RENAME `table1000_innodb_key_pk_parts_2_int_autoinc`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: ALTER TABLE isolation failure
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: CREATE TABLE h LIKE `table100_innodb_int`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: DROP TABLE `table1000_innodb_key_pk_parts_2_int_autoinc`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: ALTER TABLE h ADD CONSTRAINT FOREIGN KEY (`col_char_12_key`) REFERENCES `table100_innodb_int` (`col_char_12_key`) ON DELETE SET NULL ON UPDATE NO ACTION. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: ALTER TABLE isolation failure
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: CREATE TABLE f LIKE `table100_innodb_key_pk_parts_2_int_autoinc`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: DROP TABLE `table100_innodb_int`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: DROP TABLE IF EXISTS v. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: ALTER TABLE h RENAME `table100_innodb_int`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: ALTER TABLE isolation failure
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: DROP TABLE IF EXISTS y. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: ALTER TABLE s ADD CONSTRAINT FOREIGN KEY (`col_int_key`) REFERENCES `table100_innodb_key_pk_parts_2_int` (`col_int_key`). Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: ALTER TABLE isolation failure
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: DROP TABLE `table100_innodb_int`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: CREATE TABLE y LIKE `table1000_innodb_int`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: ALTER TABLE f ADD CONSTRAINT FOREIGN KEY (`col_int_key`) REFERENCES `table100_innodb_key_pk_parts_2_int_autoinc` (`col_char_12_key`). Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: ALTER TABLE isolation failure
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: DROP TABLE `table100_innodb_key_pk_parts_2_int`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: DROP TABLE `table100_innodb_key_pk_parts_2_int_autoinc`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: DROP TABLE `table100_innodb_int`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: ALTER TABLE y ADD CONSTRAINT FOREIGN KEY (`col_char_12_key`) REFERENCES `table1000_innodb_int` (`col_char_12_key`) ON DELETE CASCADE. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: ALTER TABLE isolation failure
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: ALTER TABLE f RENAME `table100_innodb_key_pk_parts_2_int_autoinc`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: ALTER TABLE isolation failure
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: DROP TABLE `table1000_innodb_int`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: DROP TABLE IF EXISTS m. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: DROP TABLE `table100_innodb_key_pk_parts_2_int_autoinc`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: ALTER TABLE y RENAME `table1000_innodb_int`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: ALTER TABLE isolation failure
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: DROP TABLE `table1000_innodb_int`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: ALTER TABLE e ADD CONSTRAINT FOREIGN KEY (`col_int_key`) REFERENCES `table1000_innodb_int` (`col_int_key`) ON UPDATE CASCADE. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: ALTER TABLE isolation failure
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: DROP TABLE IF EXISTS x. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: ALTER TABLE s RENAME `table100_innodb_key_pk_parts_2_int`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: ALTER TABLE isolation failure
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: ALTER TABLE l ADD CONSTRAINT FOREIGN KEY (`col_char_12_key`) REFERENCES `table100_innodb_int` (`col_char_12_key`) ON UPDATE NO ACTION ON DELETE RESTRICT. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: ALTER TABLE isolation failure
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: CREATE TABLE x LIKE `table100_innodb_key_pk_parts_2_int_autoinc`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: DROP TABLE `table100_innodb_key_pk_parts_2_int`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: DROP TABLE `table1000_innodb_int`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: CREATE TABLE m LIKE `table1000_innodb_key_pk_parts_2_int_autoinc`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: ALTER TABLE x ADD CONSTRAINT FOREIGN KEY (`col_int_key`) REFERENCES `table100_innodb_key_pk_parts_2_int_autoinc` (`col_char_12_key`) ON UPDATE CASCADE ON DELETE NO ACTION. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: DROP TABLE `table100_innodb_int`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: ALTER TABLE isolation failure
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: ALTER TABLE l RENAME `table100_innodb_int`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: ALTER TABLE isolation failure
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: DROP TABLE `table100_innodb_key_pk_parts_2_int_autoinc`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: DROP TABLE `table100_innodb_int`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: ALTER TABLE x RENAME `table100_innodb_key_pk_parts_2_int_autoinc`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: ALTER TABLE isolation failure
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: DROP TABLE `table100_innodb_int_autoinc`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: DROP TABLE `table100_innodb_key_pk_parts_2_int_autoinc`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: CREATE TABLE v LIKE `table1_innodb_key_pk_parts_2_int`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: ALTER TABLE m ADD CONSTRAINT FOREIGN KEY (`col_int_key`) REFERENCES `table1000_innodb_key_pk_parts_2_int_autoinc` (`col_char_12_key`) ON DELETE CASCADE. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: ALTER TABLE isolation failure
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: DROP TABLE `table1000_innodb_key_pk_parts_2_int_autoinc`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: ALTER TABLE e RENAME `table1000_innodb_int`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: ALTER TABLE isolation failure
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: DROP TABLE IF EXISTS w. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: ALTER TABLE m RENAME `table1000_innodb_key_pk_parts_2_int_autoinc`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: ALTER TABLE isolation failure
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: DROP TABLE `table1000_innodb_int`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: CREATE TABLE w LIKE `table1_innodb_key_pk_parts_2_int`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: DROP TABLE `table1000_innodb_key_pk_parts_2_int_autoinc`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: DROP TABLE IF EXISTS q. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: ALTER TABLE t RENAME `table100_innodb_int_autoinc`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: ALTER TABLE isolation failure
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: CREATE TABLE q LIKE `table1000_innodb_int`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: DROP TABLE `table100_innodb_int_autoinc`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: ALTER TABLE v ADD CONSTRAINT FOREIGN KEY (`col_char_12_key`) REFERENCES `table1_innodb_key_pk_parts_2_int` (`col_int_key`) ON UPDATE NO ACTION ON DELETE CASCADE. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: ALTER TABLE isolation failure
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: DROP TABLE IF EXISTS u. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: DROP TABLE `table1_innodb_key_pk_parts_2_int`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: ALTER TABLE v RENAME `table1_innodb_key_pk_parts_2_int`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: ALTER TABLE isolation failure
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: DROP TABLE `table1_innodb_key_pk_parts_2_int`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: DROP TABLE IF EXISTS p. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: DROP TABLE IF EXISTS m. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: CREATE TABLE p LIKE `table1_innodb_int_autoinc`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: CREATE TABLE m LIKE `table1_innodb_key_pk_parts_2_int_autoinc`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: CREATE TABLE u LIKE `table100_innodb_int_autoinc`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: DROP TABLE IF EXISTS a. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: CREATE TABLE a LIKE `table1000_innodb_key_pk_parts_2_int_autoinc`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: DROP TABLE IF EXISTS c. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: ALTER TABLE w ADD CONSTRAINT FOREIGN KEY (`col_char_12_key`) REFERENCES `table1_innodb_key_pk_parts_2_int` (`col_char_12_key`) ON UPDATE CASCADE ON DELETE RESTRICT. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: ALTER TABLE isolation failure
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: ALTER TABLE a ADD CONSTRAINT FOREIGN KEY (`col_char_12_key`) REFERENCES `table1000_innodb_key_pk_parts_2_int_autoinc` (`col_int_key`) ON DELETE NO ACTION ON UPDATE CASCADE. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: ALTER TABLE isolation failure
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: CREATE TABLE c LIKE `table1000_innodb_key_pk_parts_2_int`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: DROP TABLE `table1000_innodb_key_pk_parts_2_int_autoinc`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: ALTER TABLE a RENAME `table1000_innodb_key_pk_parts_2_int_autoinc`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: ALTER TABLE isolation failure
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: DROP TABLE `table1000_innodb_key_pk_parts_2_int_autoinc`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: DROP TABLE IF EXISTS h. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: ALTER TABLE c ADD CONSTRAINT FOREIGN KEY (`col_char_12_key`) REFERENCES `table1000_innodb_key_pk_parts_2_int` (`col_char_12_key`) ON UPDATE SET NULL ON DELETE NO ACTION. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: ALTER TABLE isolation failure
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: CREATE TABLE h LIKE `table1000_innodb_int_autoinc`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: DROP TABLE `table1000_innodb_key_pk_parts_2_int`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: ALTER TABLE c RENAME `table1000_innodb_key_pk_parts_2_int`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: ALTER TABLE isolation failure
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: ALTER TABLE h ADD CONSTRAINT FOREIGN KEY (`col_int_key`) REFERENCES `table1000_innodb_int_autoinc` (`col_char_12_key`). Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: ALTER TABLE isolation failure
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: DROP TABLE `table1000_innodb_key_pk_parts_2_int`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: DROP TABLE `table1000_innodb_int_autoinc`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: ALTER TABLE h RENAME `table1000_innodb_int_autoinc`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: ALTER TABLE isolation failure
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: DROP TABLE IF EXISTS i. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: DROP TABLE `table1000_innodb_int_autoinc`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: CREATE TABLE i LIKE `table100_innodb_key_pk_parts_2_int_autoinc`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: DROP TABLE IF EXISTS c. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: CREATE TABLE c LIKE `table1000_innodb_key_pk_parts_2_int_autoinc`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: DROP TABLE IF EXISTS n. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: DROP TABLE IF EXISTS m. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: CREATE TABLE n LIKE `table1_innodb_key_pk_parts_2_int`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: ALTER TABLE c ADD CONSTRAINT FOREIGN KEY (`col_char_12_key`) REFERENCES `table1000_innodb_key_pk_parts_2_int_autoinc` (`col_int_key`). Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: ALTER TABLE isolation failure
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: CREATE TABLE m LIKE `table1000_innodb_key_pk_parts_2_int_autoinc`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: DROP TABLE `table1000_innodb_key_pk_parts_2_int_autoinc`. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: TO isolation failed for: 3, sql: ALTER TABLE n ADD CONSTRAINT FOREIGN KEY (`col_char_12_key`) REFERENCES `table1_innodb_key_pk_parts_2_int` (`col_char_12_key`) ON DELETE CASCADE ON UPDATE SET NULL. Check wsrep connection state and retry the query.
2013-12-11 16:08:09 25095 [Warning] WSREP: ALTER TABLE isolation failure

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

It goes "Check wsrep connection state and retry the query." even after abort is called for a few hundred queries. TOI shouldn't be attempted during shutdown.

summary:

- Assertion during abort
+ Assertion during abort: signal 11

Raghavendra D Prabhu (raghavendra-prabhu) on 2013-12-14

description:

updated

Revision history for this message

Krunal Bauskar (krunal-bauskar) wrote on 2015-11-17:

Haven't seen this for a while.
Looks like it got fixed in due-course.

Revision history for this message

Shahriyar Rzayev (rzayev-sehriyar) wrote on 2018-01-18:

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PXC-987

Report a bug

This report contains Public information

Everyone can see this information.

You are

Subscribing...

Edit bug mail

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.