sql/table_cache.h:527: void Table_cache::release_table(THD*, TABLE*): Assertion `! table->s->has_old_version()' failed. | sig6 abort() in Table_cache::release_table

[Roel Van de Paar]

==================== Error log
2014-08-29 15:25:35 26942 [Note] /sda/Percona-Server-5.6.20-rel68.0-654.Linux.x86_64-debug/bin/mysqld: ready for connections.
Version: '5.6.20-68.0-debug-log' socket: '/sda/511362/current1_1/tmp/master.sock' port: 13000 Percona Server (GPL), Release 68.0, Revision 654, DEBUG BINARY
mysqld: /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.20-68.0/sql/table_cache.h:527: void Table_cache::release_table(THD*, TABLE*): Assertion `! table->s->has_old_version()' failed.
12:26:55 UTC - mysqld got signal 6 ;
[...]
Query (7f86939c0010): INSERT INTO l ( `c40` ) VALUES ( 1 )

==================== Stack
Thread 1 (LWP 27563):
+bt
#0 0x00007f8711a0b771 in pthread_kill () from /lib64/libpthread.so.0
#1 0x0000000000ab09a2 in my_write_core (sig=6) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.20-68.0/mysys/stacktrace.c:422
#2 0x000000000072ca03 in handle_fatal_signal (sig=6) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.20-68.0/sql/signal_handler.cc:236
#3 <signal handler called>
#4 0x00007f871060f989 in raise () from /lib64/libc.so.6
#5 0x00007f8710611098 in abort () from /lib64/libc.so.6
#6 0x00007f87106088f6 in __assert_fail_base () from /lib64/libc.so.6
#7 0x00007f87106089a2 in __assert_fail () from /lib64/libc.so.6
#8 0x000000000077def7 in Table_cache::release_table (this=0x1889720 <table_cache_manager>, thd=0x7f86dac38000, table=0x7f869391a200) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.20-68.0/sql/table_cache.h:527
#9 0x000000000076e31a in open_table (thd=0x7f86dac38000, table_list=0x7f86940a5800, ot_ctx=0x7f871014d660) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.20-68.0/sql/sql_base.cc:3256
#10 0x0000000000770892 in open_and_process_table (thd=0x7f86dac38000, lex=0x7f86dac3a540, tables=0x7f86940a5800, counter=0x7f86dac3a600, flags=0, prelocking_strategy=0x7f871014d760, has_prelocking_list=false, ot_ctx=0x7f871014d660) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.20-68.0/sql/sql_base.cc:4699
#11 0x0000000000771797 in open_tables (thd=0x7f86dac38000, start=0x7f871014d720, counter=0x7f86dac3a600, flags=0, prelocking_strategy=0x7f871014d760) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.20-68.0/sql/sql_base.cc:5213
#12 0x0000000000772926 in open_normal_and_derived_tables (thd=0x7f86dac38000, tables=0x7f86939c0110, flags=0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.20-68.0/sql/sql_base.cc:5913
#13 0x00000000007be286 in mysql_insert (thd=0x7f86dac38000, table_list=0x7f86939c0110, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_ERROR, ignore=false) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.20-68.0/sql/sql_insert.cc:750
#14 0x00000000007e21f3 in mysql_execute_command (thd=0x7f86dac38000) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.20-68.0/sql/sql_parse.cc:3846
#15 0x00000000007ea051 in mysql_parse (thd=0x7f86dac38000, rawbuf=0x7f86939c0010 "INSERT INTO l ( `c40` ) VALUES ( 1 )", length=36, parser_state=0x7f871014ed10) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.20-68.0/sql/sql_parse.cc:6744
#16 0x00000000007dc5ec in dispatch_command (command=COM_QUERY, thd=0x7f86dac38000, packet=0x7f86dac3c001 " INSERT INTO l ( `c40` ) VALUES ( 1 )", packet_length=37) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.20-68.0/sql/sql_parse.cc:1432
#17 0x00000000007db518 in do_command (thd=0x7f86dac38000) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.20-68.0/sql/sql_parse.cc:1049
#18 0x00000000008bf984 in threadpool_process_request (thd=0x7f86dac38000) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.20-68.0/sql/threadpool_common.cc:311
#19 0x00000000008c22c6 in handle_event (connection=0x7f86dabf4d30) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.20-68.0/sql/threadpool_unix.cc:1553
#20 0x00000000008c24f6 in worker_main (param=0x188d200 <all_groups+2560>) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.20-68.0/sql/threadpool_unix.cc:1606
#21 0x0000000000dbdbb8 in pfs_spawn_thread (arg=0x7f8693a69020) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.20-68.0/storage/perfschema/pfs.cc:1860
#22 0x00007f8711a06df3 in start_thread () from /lib64/libpthread.so.0
#23 0x00007f87106d03dd in clone () from /lib64/libc.so.6

[Roel Van de Paar (roel11)]

Tried creating a testcase, but did not succeed. Issue is sporadic and seen on various queries:

[roel@localhost 511362]$ cat vardir1_42/log/master.err | grep "Query"
Query (7eff6823b010): INSERT IGNORE INTO `table100_tokudb` ( `c43` , `c19` , `c37` ) VALUES ( '01:52:31.062707' , 5931522184223653888 , -519168 )
[roel@localhost 511362]$ cat vardir1_69/log/master.err | grep "Query"
Query (7ff020c42010): DROP PROCEDURE IF EXISTS k

[Roel Van de Paar (roel11)]

https://bugs.launchpad.net/bugs/1385035 is dup

[Ramesh Sivaraman (rameshvs02)]

***** Testcase

DROP DATABASE test;CREATE DATABASE test;USE test;
CREATE EVENT e2 ON SCHEDULE EVERY 1 SECOND DO DROP DATABASE BUG52792;
LOCK TABLES FOR BACKUP;
select sleep(1.1);
flush table;

[Roel Van de Paar (roel11)]

--event-scheduler=ON ?

[Ramesh Sivaraman (rameshvs02)]

Yes, server started with --event-scheduler=ON

[Shahriyar Rzayev (rzayev-sehriyar)]

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