mysqld: Incorrect information in file: './test/t1.frm' > handle_fatal_signal (sig=11) in Field::has_associated_compression_dictionary

[Roel Van de Paar]

+bt
#0 0x00007f56d4845741 in __pthread_kill (threadid=<optimized out>, signo=11) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:61
#1 0x0000000000ac0dea in my_write_core (sig=11) at /git/compression1_dbg/mysys/stacktrace.c:422
#2 0x00000000007360ef in handle_fatal_signal (sig=11) at /git/compression1_dbg/sql/signal_handler.cc:236
#3 <signal handler called>
#4 0x000000000084981c in Field::has_associated_compression_dictionary (this=0x8f8f8f8f8f8f8f8f) at /git/compression1_dbg/sql/field.h:912
#5 0x00000000008ae655 in TABLE_SHARE::destroy (this=0x7f568489a810) at /git/compression1_dbg/sql/table.cc:457
#6 0x00000000008aea2d in free_table_share (share=0x7f568489a810) at /git/compression1_dbg/sql/table.cc:536
#7 0x0000000000772460 in table_def_free_entry (share=0x7f568489a810) at /git/compression1_dbg/sql/sql_base.cc:351
#8 0x0000000000aa1b67 in my_hash_delete (hash=0x17990a0 <table_def_cache>, record=0x7f568489a810 "\002") at /git/compression1_dbg/mysys/hash.c:603
#9 0x00000000007727e7 in get_table_share (thd=0x7f56aa355000, table_list=0x7f568481f160, key=0x7f568481f525 "test", key_length=8, db_flags=8192, error=0x7f56d4e30f74, hash_value=1096967734) at /git/compression1_dbg/sql/sql_base.cc:506
#10 0x0000000000772b38 in get_table_share_with_discover (thd=0x7f56aa355000, table_list=0x7f568481f160, key=0x7f568481f525 "test", key_length=8, db_flags=8192, error=0x7f56d4e30f74, hash_value=1096967734) at /git/compression1_dbg/sql/sql_base.cc:583
#11 0x00000000007779bc in open_table (thd=0x7f56aa355000, table_list=0x7f568481f160, ot_ctx=0x7f56d4e31140) at /git/compression1_dbg/sql/sql_base.cc:3073
#12 0x000000000077a7ba in open_and_process_table (thd=0x7f56aa355000, lex=0x7f56aa3571c0, tables=0x7f568481f160, counter=0x7f56d4e31298, flags=0, prelocking_strategy=0x7f56d4e31210, has_prelocking_list=false, ot_ctx=0x7f56d4e31140) at /git/compression1_dbg/sql/sql_base.cc:4806
#13 0x000000000077b63c in open_tables (thd=0x7f56aa355000, start=0x7f56aa3571d0, counter=0x7f56d4e31298, flags=0, prelocking_strategy=0x7f56d4e31210) at /git/compression1_dbg/sql/sql_base.cc:5313
#14 0x00000000007c60c9 in open_tables (thd=0x7f56aa355000, tables=0x7f56aa3571d0, counter=0x7f56d4e31298, flags=0) at /git/compression1_dbg/sql/sql_base.h:457
#15 0x000000000085be96 in mysql_create_table (thd=0x7f56aa355000, create_table=0x7f568481f160, create_info=0x7f56d4e31920, alter_info=0x7f56d4e313c0) at /git/compression1_dbg/sql/sql_table.cc:5318
#16 0x00000000007eb512 in mysql_execute_command (thd=0x7f56aa355000) at /git/compression1_dbg/sql/sql_parse.cc:3527
#17 0x00000000007f4aa1 in mysql_parse (thd=0x7f56aa355000, rawbuf=0x7f568481f010 "CREATE TABLE t1(c1 INT UNSIGNED KEY,c2 INT,c3 INT,c4 INT,c5 INT,c6 INT,c7 INT)", length=78, parser_state=0x7f56d4e32500) at /git/compression1_dbg/sql/sql_parse.cc:7002
#18 0x00000000007e6758 in dispatch_command (command=COM_QUERY, thd=0x7f56aa355000, packet=0x7f56a43cb001 "CREATE TABLE t1(c1 INT UNSIGNED KEY,c2 INT,c3 INT,c4 INT,c5 INT,c6 INT,c7 INT)", packet_length=78) at /git/compression1_dbg/sql/sql_parse.cc:1450
#19 0x00000000007e55f9 in do_command (thd=0x7f56aa355000) at /git/compression1_dbg/sql/sql_parse.cc:1058
#20 0x00000000007acb9d in do_handle_one_connection (thd_arg=0x7f56aa355000) at /git/compression1_dbg/sql/sql_connect.cc:1541
#21 0x00000000007ac61d in handle_one_connection (arg=0x7f56aa355000) at /git/compression1_dbg/sql/sql_connect.cc:1444
#22 0x0000000000b0f88d in pfs_spawn_thread (arg=0x7f56ba3ff2e0) at /git/compression1_dbg/storage/perfschema/pfs.cc:1860
#23 0x00007f56d4840dc5 in start_thread (arg=0x7f56d4e33700) at pthread_create.c:308
#24 0x00007f56d2c9dced in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:113

2016-09-09 11:02:18 12369 [Note] /sda/PS080916-percona-server-5.6.31-77.0-linux-x86_64-debug/bin/mysqld: ready for connections.
Version: '5.6.31-77.0-debug' socket: '/sda/PS080916-percona-server-5.6.31-77.0-linux-x86_64-debug/socket.sock' port: 12060 MySQL Community Server (GPL)
2016-09-09 11:02:19 12369 [ERROR] /sda/PS080916-percona-server-5.6.31-77.0-linux-x86_64-debug/bin/mysqld: Incorrect information in file: './test/t1.frm'
01:02:19 UTC - mysqld got signal 11 ;
[...]
Query (7f568481f010): CREATE TABLE t1(c1 INT UNSIGNED KEY,c2 INT,c3 INT,c4 INT,c5 INT,c6 INT,c7 INT)
Connection ID (thread ID): 1
Status: NOT_KILLED

Testcase:

DROP DATABASE test;CREATE DATABASE test;USE test;
CREATE TABLE t1(c1 INT,c2 CHAR)PARTITION BY HASH(c1) PARTITIONS 1;
SET innodb_fake_changes=1;
DROP TABLE t1;
CREATE TABLE t1(c1 INT UNSIGNED KEY,c2 INT,c3 INT,c4 INT,c5 INT,c6 INT,c7 INT);

[Yura Sorokin (yura-sorokin)]

This is not a "fake_changes" problem.

"TABLE_SHARE::destroy()" used to unconditionally destroy "zip_dict_data" and "zip_dict_data" in field definitions. These fields could have been left with garbage if "open_table()" returned an error.

Fixed in the initial "compressed_columns" commit
https://github.com/percona/percona-server/pull/735

[Yura Sorokin (yura-sorokin)]

This is similar to
https://bugs.launchpad.net/percona-server/+bug/1622588

[Shahriyar Rzayev (rzayev-sehriyar)]

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