(gdb) bt
#0 0x00007f131288d0b1 in pthread_kill () from /usr/lib/libpthread.so.0
#1 0x0000000000815ba8 in my_write_core (sig=6) at /media/Tintin/Work/code/percona-xtradb-cluster/trunk/Percona-Server/mysys/stacktrace.c:433
#2 0x00000000006d5946 in handle_fatal_signal (sig=6) at /media/Tintin/Work/code/percona-xtradb-cluster/trunk/Percona-Server/sql/signal_handler.cc:250
#3 <signal handler called>
#4 0x00007f131103b3d9 in raise () from /usr/lib/libc.so.6
#5 0x00007f131103c7d8 in abort () from /usr/lib/libc.so.6
#6 0x00007f1311034506 in __assert_fail_base () from /usr/lib/libc.so.6
#7 0x00007f13110345b2 in __assert_fail () from /usr/lib/libc.so.6
#8 0x0000000000582e1f in Diagnostics_area::set_error_status (this=0x2eec9f0, thd=thd@entry=0x2ee9970, sql_errno_arg=sql_errno_arg@entry=1213,
message_arg=message_arg@entry=0x7f12e3166610 "Deadlock found when trying to get lock; try restarting transaction", sqlstate=sqlstate@entry=0xaddd27 "40001")
at /media/Tintin/Work/code/percona-xtradb-cluster/trunk/Percona-Server/sql/sql_error.cc:422
#9 0x0000000000572319 in THD::raise_condition (this=this@entry=0x2ee9970, sql_errno=sql_errno@entry=1213, sqlstate=0xaddd27 "40001", sqlstate@entry=0x0, level=<optimized out>,
level@entry=MYSQL_ERROR::WARN_LEVEL_ERROR, msg=msg@entry=0x7f12e3166610 "Deadlock found when trying to get lock; try restarting transaction")
at /media/Tintin/Work/code/percona-xtradb-cluster/trunk/Percona-Server/sql/sql_class.cc:1434
#10 0x0000000000516658 in my_message_sql (error=1213, str=<optimized out>, MyFlags=0) at /media/Tintin/Work/code/percona-xtradb-cluster/trunk/Percona-Server/sql/mysqld.cc:2965
#11 0x000000000080c1a8 in my_error (nr=1213, MyFlags=0) at /media/Tintin/Work/code/percona-xtradb-cluster/trunk/Percona-Server/mysys/my_error.c:96
#12 0x00000000006d9377 in ha_commit_trans (thd=thd@entry=0x2ee9970, all=all@entry=false) at /media/Tintin/Work/code/percona-xtradb-cluster/trunk/Percona-Server/sql/handler.cc:1393
#13 0x000000000066a450 in trans_commit_stmt (thd=0x2ee9970) at /media/Tintin/Work/code/percona-xtradb-cluster/trunk/Percona-Server/sql/transaction.cc:380
#14 0x0000000000588064 in select_create::send_eof (this=0x7f1290005b08) at /media/Tintin/Work/code/percona-xtradb-cluster/trunk/Percona-Server/sql/sql_insert.cc:4128
#15 0x00000000005d822e in do_select (join=join@entry=0x7f1290030ac0, fields=fields@entry=0x2eebf40, table=table@entry=0x0, procedure=0x0)
at /media/Tintin/Work/code/percona-xtradb-cluster/trunk/Percona-Server/sql/sql_select.cc:11663
#16 0x00000000005ec091 in JOIN::exec (this=this@entry=0x7f1290030ac0) at /media/Tintin/Work/code/percona-xtradb-cluster/trunk/Percona-Server/sql/sql_select.cc:2428
#17 0x00000000005e6286 in mysql_select (thd=thd@entry=0x2ee9970, rref_pointer_array=rref_pointer_array@entry=0x2eec018, tables=0x7f1290005410, wild_num=1, fields=..., conds=<optimized out>, og_num=0, order=0x0,
group=0x0, having=0x0, proc_param=0x0, select_options=select_options@entry=2416184064, result=result@entry=0x7f1290005b08, unit=unit@entry=0x2eeb810, select_lex=select_lex@entry=0x2eebe30)
at /media/Tintin/Work/code/percona-xtradb-cluster/trunk/Percona-Server/sql/sql_select.cc:2647
#18 0x00000000005e64c4 in handle_select (thd=thd@entry=0x2ee9970, lex=lex@entry=0x2eeb750, result=result@entry=0x7f1290005b08, setup_tables_done_option=setup_tables_done_option@entry=0)
at /media/Tintin/Work/code/percona-xtradb-cluster/trunk/Percona-Server/sql/sql_select.cc:315
#19 0x00000000005a13b2 in mysql_execute_command (thd=thd@entry=0x2ee9970) at /media/Tintin/Work/code/percona-xtradb-cluster/trunk/Percona-Server/sql/sql_parse.cc:3078
#20 0x00000000005a8c73 in mysql_parse (thd=thd@entry=0x2ee9970, rawbuf=rawbuf@entry=0x7f1290004c10 "CREATE TABLE g AS SELECT * FROM `table100_innodb_key_pk_parts_2_int_autoinc`", length=length@entry=77,
parser_state=parser_state@entry=0x7f12e31685e0) at /media/Tintin/Work/code/percona-xtradb-cluster/trunk/Percona-Server/sql/sql_parse.cc:6527
#21 0x00000000005a98e3 in wsrep_mysql_parse (thd=thd@entry=0x2ee9970, rawbuf=0x7f1290004c10 "CREATE TABLE g AS SELECT * FROM `table100_innodb_key_pk_parts_2_int_autoinc`", length=77,
parser_state=parser_state@entry=0x7f12e31685e0) at /media/Tintin/Work/code/percona-xtradb-cluster/trunk/Percona-Server/sql/sql_parse.cc:6332
#22 0x00000000005aaee6 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x2ee9970,
packet=packet@entry=0x2eeccc1 " CREATE TABLE g AS SELECT * FROM `table100_innodb_key_pk_parts_2_int_autoinc`", packet_length=packet_length@entry=78)
at /media/Tintin/Work/code/percona-xtradb-cluster/trunk/Percona-Server/sql/sql_parse.cc:1256
#23 0x00000000005ad2f4 in do_command (thd=0x2ee9970) at /media/Tintin/Work/code/percona-xtradb-cluster/trunk/Percona-Server/sql/sql_parse.cc:885
#24 0x000000000065b2a7 in do_handle_one_connection (thd_arg=thd_arg@entry=0x2ee9970) at /media/Tintin/Work/code/percona-xtradb-cluster/trunk/Percona-Server/sql/sql_connect.cc:1526
#25 0x000000000065b4dd in handle_one_connection (arg=0x2ee9970) at /media/Tintin/Work/code/percona-xtradb-cluster/trunk/Percona-Server/sql/sql_connect.cc:1434
#26 0x00007f13128880a2 in start_thread () from /usr/lib/libpthread.so.0
#27 0x00007f13110eb43d in clone () from /usr/lib/libc.so.6
I can still reproduce this:
(gdb) bt libpthread. so.0 Tintin/ Work/code/ percona- xtradb- cluster/ trunk/Percona- Server/ mysys/stacktrac e.c:433 Tintin/ Work/code/ percona- xtradb- cluster/ trunk/Percona- Server/ sql/signal_ handler. cc:250 area::set_ error_status (this=0x2eec9f0, thd=thd@ entry=0x2ee9970 , sql_errno_ arg=sql_ errno_arg@ entry=1213, arg=message_ arg@entry= 0x7f12e3166610 "Deadlock found when trying to get lock; try restarting transaction", sqlstate= sqlstate@ entry=0xaddd27 "40001") Tintin/ Work/code/ percona- xtradb- cluster/ trunk/Percona- Server/ sql/sql_ error.cc: 422 condition (this=this@ entry=0x2ee9970 , sql_errno= sql_errno@ entry=1213, sqlstate=0xaddd27 "40001", sqlstate@entry=0x0, level=<optimized out>, entry=MYSQL_ ERROR:: WARN_LEVEL_ ERROR, msg=msg@ entry=0x7f12e31 66610 "Deadlock found when trying to get lock; try restarting transaction") Tintin/ Work/code/ percona- xtradb- cluster/ trunk/Percona- Server/ sql/sql_ class.cc: 1434 Tintin/ Work/code/ percona- xtradb- cluster/ trunk/Percona- Server/ sql/mysqld. cc:2965 Tintin/ Work/code/ percona- xtradb- cluster/ trunk/Percona- Server/ mysys/my_ error.c: 96 entry=0x2ee9970 , all=all@ entry=false) at /media/ Tintin/ Work/code/ percona- xtradb- cluster/ trunk/Percona- Server/ sql/handler. cc:1393 Tintin/ Work/code/ percona- xtradb- cluster/ trunk/Percona- Server/ sql/transaction .cc:380 create: :send_eof (this=0x7f12900 05b08) at /media/ Tintin/ Work/code/ percona- xtradb- cluster/ trunk/Percona- Server/ sql/sql_ insert. cc:4128 entry=0x7f12900 30ac0, fields= fields@ entry=0x2eebf40 , table=table@ entry=0x0, procedure=0x0) Tintin/ Work/code/ percona- xtradb- cluster/ trunk/Percona- Server/ sql/sql_ select. cc:11663 entry=0x7f12900 30ac0) at /media/ Tintin/ Work/code/ percona- xtradb- cluster/ trunk/Percona- Server/ sql/sql_ select. cc:2428 entry=0x2ee9970 , rref_pointer_ array=rref_ pointer_ array@entry= 0x2eec018, tables= 0x7f1290005410, wild_num=1, fields=..., conds=<optimized out>, og_num=0, order=0x0, options= select_ options@ entry=241618406 4, result= result@ entry=0x7f12900 05b08, unit=unit@ entry=0x2eeb810 , select_ lex=select_ lex@entry= 0x2eebe30) Tintin/ Work/code/ percona- xtradb- cluster/ trunk/Percona- Server/ sql/sql_ select. cc:2647 entry=0x2ee9970 , lex=lex@ entry=0x2eeb750 , result= result@ entry=0x7f12900 05b08, setup_tables_ done_option= setup_tables_ done_option@ entry=0) Tintin/ Work/code/ percona- xtradb- cluster/ trunk/Percona- Server/ sql/sql_ select. cc:315 command (thd=thd@ entry=0x2ee9970 ) at /media/ Tintin/ Work/code/ percona- xtradb- cluster/ trunk/Percona- Server/ sql/sql_ parse.cc: 3078 entry=0x2ee9970 , rawbuf= rawbuf@ entry=0x7f12900 04c10 "CREATE TABLE g AS SELECT * FROM `table100_ innodb_ key_pk_ parts_2_ int_autoinc` ", length= length@ entry=77, state=parser_ state@entry= 0x7f12e31685e0) at /media/ Tintin/ Work/code/ percona- xtradb- cluster/ trunk/Percona- Server/ sql/sql_ parse.cc: 6527 entry=0x2ee9970 , rawbuf= 0x7f1290004c10 "CREATE TABLE g AS SELECT * FROM `table100_ innodb_ key_pk_ parts_2_ int_autoinc` ", length=77, state=parser_ state@entry= 0x7f12e31685e0) at /media/ Tintin/ Work/code/ percona- xtradb- cluster/ trunk/Percona- Server/ sql/sql_ parse.cc: 6332 command@ entry=COM_ QUERY, thd=thd@ entry=0x2ee9970 , packet@ entry=0x2eeccc1 " CREATE TABLE g AS SELECT * FROM `table100_ innodb_ key_pk_ parts_2_ int_autoinc` ", packet_ length= packet_ length@ entry=78) Tintin/ Work/code/ percona- xtradb- cluster/ trunk/Percona- Server/ sql/sql_ parse.cc: 1256 Tintin/ Work/code/ percona- xtradb- cluster/ trunk/Percona- Server/ sql/sql_ parse.cc: 885 one_connection (thd_arg= thd_arg@ entry=0x2ee9970 ) at /media/ Tintin/ Work/code/ percona- xtradb- cluster/ trunk/Percona- Server/ sql/sql_ connect. cc:1526 one_connection (arg=0x2ee9970) at /media/ Tintin/ Work/code/ percona- xtradb- cluster/ trunk/Percona- Server/ sql/sql_ connect. cc:1434 libpthread. so.0
#0 0x00007f131288d0b1 in pthread_kill () from /usr/lib/
#1 0x0000000000815ba8 in my_write_core (sig=6) at /media/
#2 0x00000000006d5946 in handle_fatal_signal (sig=6) at /media/
#3 <signal handler called>
#4 0x00007f131103b3d9 in raise () from /usr/lib/libc.so.6
#5 0x00007f131103c7d8 in abort () from /usr/lib/libc.so.6
#6 0x00007f1311034506 in __assert_fail_base () from /usr/lib/libc.so.6
#7 0x00007f13110345b2 in __assert_fail () from /usr/lib/libc.so.6
#8 0x0000000000582e1f in Diagnostics_
message_
at /media/
#9 0x0000000000572319 in THD::raise_
level@
at /media/
#10 0x0000000000516658 in my_message_sql (error=1213, str=<optimized out>, MyFlags=0) at /media/
#11 0x000000000080c1a8 in my_error (nr=1213, MyFlags=0) at /media/
#12 0x00000000006d9377 in ha_commit_trans (thd=thd@
#13 0x000000000066a450 in trans_commit_stmt (thd=0x2ee9970) at /media/
#14 0x0000000000588064 in select_
#15 0x00000000005d822e in do_select (join=join@
at /media/
#16 0x00000000005ec091 in JOIN::exec (this=this@
#17 0x00000000005e6286 in mysql_select (thd=thd@
group=0x0, having=0x0, proc_param=0x0, select_
at /media/
#18 0x00000000005e64c4 in handle_select (thd=thd@
at /media/
#19 0x00000000005a13b2 in mysql_execute_
#20 0x00000000005a8c73 in mysql_parse (thd=thd@
parser_
#21 0x00000000005a98e3 in wsrep_mysql_parse (thd=thd@
parser_
#22 0x00000000005aaee6 in dispatch_command (command=
packet=
at /media/
#23 0x00000000005ad2f4 in do_command (thd=0x2ee9970) at /media/
#24 0x000000000065b2a7 in do_handle_
#25 0x000000000065b4dd in handle_
#26 0x00007f13128880a2 in start_thread () from /usr/lib/
#27 0x00007f13110eb43d in clone () from /usr/lib/libc.so.6