Comment 7 for bug 1188525

Revision history for this message
Roel Van de Paar (roel11) wrote :

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