Comment 6 for bug 1208937

Revision history for this message
Raghavendra D Prabhu (raghavendra-prabhu) wrote : Re: Diagnostics_area::set_error_status(THD*, uint, const char*, const char*): Assertion `! is_set() || can_overwrite_status' failed | CTAS-based | Possible lp:1052002 regression

I can still reproduce this:

(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