Adding another type of occurrence (different stack):
Thread 1 (LWP 8032): +bt #0 0x000000340cc0c69c in pthread_kill () from /lib64/libpthread.so.0 #1 0x0000000000686ffe in handle_fatal_signal (sig=6) at /bzr/5.6-QA_dbg/Percona-Server-5.6.12-rc60.4/sql/signal_handler.cc:251 #2 <signal handler called> #3 0x000000340c4328a5 in raise () from /lib64/libc.so.6 #4 0x000000340c434085 in abort () from /lib64/libc.so.6 #5 0x0000000000bcb23a in fil_rename_tablespace (old_name_in=0x7f3cb0009c68 "query18053/#sql2-1e24-50", id=42, new_name=0x7f3d006ed0c0 "query18053/t1", new_path_in=0x0) at /bzr/5.6-QA_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/fil/fil0fil.cc:3111 #6 0x0000000000ba1a50 in dict_table_rename_in_cache (table=0x7f3c7c00e4b8, new_name=0x7f3d006ed0c0 "query18053/t1", rename_also_foreigns=1) at /bzr/5.6-QA_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/dict/dict0dict.cc:1514 #7 0x0000000000acf154 in row_rename_table_for_mysql (old_name=<optimized out>, new_name=<optimized out>, trx=0x7f3cb006c0e8, commit=<optimized out>) at /bzr/5.6-QA_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/row/row0mysql.cc:5029 #8 0x0000000000a09cb0 in innobase_rename_table (to=0x7f3d006ed9b0 "./query18053/t1", from=0x7f3d006edbc0 "./query18053/#sql2-1e24-50", trx=0x7f3cb006c0e8) at /bzr/5.6-QA_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/handler/ha_innodb.cc:10560 #9 ha_innobase::rename_table (this=<optimized out>, from=0x7f3d006edbc0 "./query18053/#sql2-1e24-50", to=0x7f3d006ed9b0 "./query18053/t1") at /bzr/5.6-QA_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/handler/ha_innodb.cc:10678 #10 0x0000000000775537 in mysql_rename_table (base=<optimized out>, old_db=0x7f3cb00059f8 "query18053", old_name=0x7f3d006ef9e0 "#sql2-1e24-50", new_db=0x7f3cb00059f8 "query18053", new_name=0x7f3cb0005a10 "t1", flags=65) at /bzr/5.6-QA_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_table.cc:5169 #11 0x00000000007844b5 in mysql_alter_table (thd=<optimized out>, new_db=0x7f3d006ef820 "", new_name=0x7f3cb000bde0 "`\003\001\260<\177", create_info=<optimized out>, table_list=0x7f3cb0005a48, alter_info=0x7f3d006f0110, order_num=0, order=0x0, ignore=false) at /bzr/5.6-QA_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_table.cc:8677 #12 0x0000000000894217 in Sql_cmd_alter_table::execute (this=<optimized out>, thd=0x1f39c20) at /bzr/5.6-QA_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_alter.cc:317 #13 0x00000000007218eb in mysql_execute_command (thd=0x1f39c20) at /bzr/5.6-QA_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:5157 #14 0x00000000007280d8 in mysql_parse (thd=0x1f39c20, rawbuf=0x1f3bfe0 "P\303\067\001", length=<optimized out>, parser_state=<optimized out>) at /bzr/5.6-QA_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:6477 #15 0x000000000072923c in dispatch_command (command=COM_QUERY, thd=0x1f39c20, packet=0x7f3d006f1910 " \234\363\001", packet_length=46) at /bzr/5.6-QA_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1355 #16 0x000000000072a437 in do_command (thd=0x1f39c20) at /bzr/5.6-QA_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1049 #17 0x00000000007d7817 in threadpool_process_request (thd=0x1f39c20) at /bzr/5.6-QA_dbg/Percona-Server-5.6.12-rc60.4/sql/threadpool_common.cc:312 #18 0x00000000007da4f8 in handle_event (connection=0x1eccd90) at /bzr/5.6-QA_dbg/Percona-Server-5.6.12-rc60.4/sql/threadpool_unix.cc:1466 #19 worker_main (param=0x150cc00 <all_groups>) at /bzr/5.6-QA_dbg/Percona-Server-5.6.12-rc60.4/sql/threadpool_unix.cc:1519 #20 0x00000000009dfc3a in pfs_spawn_thread (arg=0x1fa5320) at /bzr/5.6-QA_dbg/Percona-Server-5.6.12-rc60.4/storage/perfschema/pfs.cc:1858 #21 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #22 0x000000340c4e890d in clone () from /lib64/libc.so.6
Version: '5.6.13-rc60.4-debug-log' socket: '/sde/062075/current1_8/tmp/master.sock' port: 13140 Percona Server with XtraDB (GPL), Release rc60.4, Revision 410-debug InnoDB: Error: 'query18053/t1' is already in tablespace memory cache <---------------------------------- (!!!) 2013-08-17 18:50:24 7f3d006f2700 InnoDB: Assertion failure in thread 139899977017088 in file fil0fil.cc line 3111 InnoDB: Failing assertion: strcmp(space->name, old_name) == 0
For the InnoDB Error, also see bug 1213885
Adding another type of occurrence (different stack):
Thread 1 (LWP 8032): libpthread. so.0 6-QA_dbg/ Percona- Server- 5.6.12- rc60.4/ sql/signal_ handler. cc:251 tablespace (old_name_ in=0x7f3cb0009c 68 "query18053/ #sql2-1e24- 50", id=42, new_name= 0x7f3d006ed0c0 "query18053/t1", new_path_in=0x0) at /bzr/5. 6-QA_dbg/ Percona- Server- 5.6.12- rc60.4/ storage/ innobase/ fil/fil0fil. cc:3111 rename_ in_cache (table= 0x7f3c7c00e4b8, new_name= 0x7f3d006ed0c0 "query18053/t1", rename_ also_foreigns= 1) at /bzr/5. 6-QA_dbg/ Percona- Server- 5.6.12- rc60.4/ storage/ innobase/ dict/dict0dict. cc:1514 table_for_ mysql (old_name= <optimized out>, new_name=<optimized out>, trx=0x7f3cb006c0e8, commit=<optimized out>) at /bzr/5. 6-QA_dbg/ Percona- Server- 5.6.12- rc60.4/ storage/ innobase/ row/row0mysql. cc:5029 rename_ table (to=0x7f3d006ed9b0 "./query18053/t1", from=0x7f3d006edbc0 "./query18053/ #sql2-1e24- 50", trx=0x7f3cb006c0e8) at /bzr/5. 6-QA_dbg/ Percona- Server- 5.6.12- rc60.4/ storage/ innobase/ handler/ ha_innodb. cc:10560 :rename_ table (this=<optimized out>, from=0x7f3d006edbc0 "./query18053/ #sql2-1e24- 50", to=0x7f3d006ed9b0 "./query18053/t1") at /bzr/5. 6-QA_dbg/ Percona- Server- 5.6.12- rc60.4/ storage/ innobase/ handler/ ha_innodb. cc:10678 0x7f3cb00059f8 "query18053", old_name= 0x7f3d006ef9e0 "#sql2-1e24-50", new_db= 0x7f3cb00059f8 "query18053", new_name= 0x7f3cb0005a10 "t1", flags=65) at /bzr/5. 6-QA_dbg/ Percona- Server- 5.6.12- rc60.4/ sql/sql_ table.cc: 5169 0x7f3d006ef820 "", new_name= 0x7f3cb000bde0 "`\003\ 001\260< \177", create_ info=<optimized out>, table_list= 0x7f3cb0005a48, alter_info= 0x7f3d006f0110, order_num=0, order=0x0, ignore=false) at /bzr/5. 6-QA_dbg/ Percona- Server- 5.6.12- rc60.4/ sql/sql_ table.cc: 8677 alter_table: :execute (this=<optimized out>, thd=0x1f39c20) at /bzr/5. 6-QA_dbg/ Percona- Server- 5.6.12- rc60.4/ sql/sql_ alter.cc: 317 command (thd=0x1f39c20) at /bzr/5. 6-QA_dbg/ Percona- Server- 5.6.12- rc60.4/ sql/sql_ parse.cc: 5157 state=< optimized out>) at /bzr/5. 6-QA_dbg/ Percona- Server- 5.6.12- rc60.4/ sql/sql_ parse.cc: 6477 0x7f3d006f1910 " \234\363\001", packet_length=46) at /bzr/5. 6-QA_dbg/ Percona- Server- 5.6.12- rc60.4/ sql/sql_ parse.cc: 1355 6-QA_dbg/ Percona- Server- 5.6.12- rc60.4/ sql/sql_ parse.cc: 1049 process_ request (thd=0x1f39c20) at /bzr/5. 6-QA_dbg/ Percona- Server- 5.6.12- rc60.4/ sql/threadpool_ common. cc:312 0x1eccd90) at /bzr/5. 6-QA_dbg/ Percona- Server- 5.6.12- rc60.4/ sql/threadpool_ unix.cc: 1466 6-QA_dbg/ Percona- Server- 5.6.12- rc60.4/ sql/threadpool_ unix.cc: 1519 6-QA_dbg/ Percona- Server- 5.6.12- rc60.4/ storage/ perfschema/ pfs.cc: 1858 libpthread. so.0
+bt
#0 0x000000340cc0c69c in pthread_kill () from /lib64/
#1 0x0000000000686ffe in handle_fatal_signal (sig=6) at /bzr/5.
#2 <signal handler called>
#3 0x000000340c4328a5 in raise () from /lib64/libc.so.6
#4 0x000000340c434085 in abort () from /lib64/libc.so.6
#5 0x0000000000bcb23a in fil_rename_
#6 0x0000000000ba1a50 in dict_table_
#7 0x0000000000acf154 in row_rename_
#8 0x0000000000a09cb0 in innobase_
#9 ha_innobase:
#10 0x0000000000775537 in mysql_rename_table (base=<optimized out>, old_db=
#11 0x00000000007844b5 in mysql_alter_table (thd=<optimized out>, new_db=
#12 0x0000000000894217 in Sql_cmd_
#13 0x00000000007218eb in mysql_execute_
#14 0x00000000007280d8 in mysql_parse (thd=0x1f39c20, rawbuf=0x1f3bfe0 "P\303\067\001", length=<optimized out>, parser_
#15 0x000000000072923c in dispatch_command (command=COM_QUERY, thd=0x1f39c20, packet=
#16 0x000000000072a437 in do_command (thd=0x1f39c20) at /bzr/5.
#17 0x00000000007d7817 in threadpool_
#18 0x00000000007da4f8 in handle_event (connection=
#19 worker_main (param=0x150cc00 <all_groups>) at /bzr/5.
#20 0x00000000009dfc3a in pfs_spawn_thread (arg=0x1fa5320) at /bzr/5.
#21 0x000000340cc07851 in start_thread () from /lib64/
#22 0x000000340c4e890d in clone () from /lib64/libc.so.6
Version: '5.6.13- rc60.4- debug-log' socket: '/sde/062075/ current1_ 8/tmp/master. sock' port: 13140 Percona Server with XtraDB (GPL), Release rc60.4, Revision 410-debug ------- ------- ------- ------- (!!!)
InnoDB: Error: 'query18053/t1' is already in tablespace memory cache <------
2013-08-17 18:50:24 7f3d006f2700 InnoDB: Assertion failure in thread 139899977017088 in file fil0fil.cc line 3111
InnoDB: Failing assertion: strcmp(space->name, old_name) == 0
For the InnoDB Error, also see bug 1213885