sql/field.h:918: bool Field::has_associated_compression_dictionary() const: Assertion `zip_dict_name.str == 0 || column_format() == COLUMN_FORMAT_TYPE_COMPRESSED' failed.

Bug #1633957 reported by Roel Van de Paar
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Server moved to https://jira.percona.com/projects/PS
Fix Released
High
Yura Sorokin
5.6
Fix Released
High
Yura Sorokin

Bug Description

2016-10-17 13:17:44 14353 [Note] /sda/COMP8-PS131016-percona-server-5.6.33-78.0-linux-x86_64-debug/bin/mysqld: ready for connections.
Version: '5.6.33-78.0-debug' socket: '/sda/COMP8-PS131016-percona-server-5.6.33-78.0-linux-x86_64-debug/socket.sock' port: 17852 MySQL Community Server (GPL)
mysqld: /git/COMP-PS-5.6.33_dbg/sql/field.h:918: bool Field::has_associated_compression_dictionary() const: Assertion `zip_dict_name.str == 0 || column_format() == COLUMN_FORMAT_TYPE_COMPRESSED' failed.
02:17:49 UTC - mysqld got signal 6 ;
[...]
Query (7ffaa101f010): CREATE TEMPORARY TABLE t0 (a int KEY,b CHAR (0)) SELECT * FROM t0
Connection ID (thread ID): 1
Status: NOT_KILLED

+bt
#0 0x00007ffaf01ea741 in __pthread_kill (threadid=<optimized out>, signo=6) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:61
#1 0x0000000000ac271a in my_write_core (sig=6) at /git/COMP-PS-5.6.33_dbg/mysys/stacktrace.c:422
#2 0x0000000000736903 in handle_fatal_signal (sig=6) at /git/COMP-PS-5.6.33_dbg/sql/signal_handler.cc:236
#3 <signal handler called>
#4 0x00007ffaee5815f7 in __GI_raise (sig=sig@entry=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:56
#5 0x00007ffaee582ce8 in __GI_abort () at abort.c:90
#6 0x00007ffaee57a566 in __assert_fail_base (fmt=0x7ffaee6cace8 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0xee20b8 "zip_dict_name.str == 0 || column_format() == COLUMN_FORMAT_TYPE_COMPRESSED", file=file@entry=0xee2090 "/git/COMP-PS-5.6.33_dbg/sql/field.h", line=line@entry=918, function=function@entry=0xee5440 <Field::has_associated_compression_dictionary() const::__PRETTY_FUNCTION__> "bool Field::has_associated_compression_dictionary() const") at assert.c:92
#7 0x00007ffaee57a612 in __GI___assert_fail (assertion=0xee20b8 "zip_dict_name.str == 0 || column_format() == COLUMN_FORMAT_TYPE_COMPRESSED", file=0xee2090 "/git/COMP-PS-5.6.33_dbg/sql/field.h", line=918, function=0xee5440 <Field::has_associated_compression_dictionary() const::__PRETTY_FUNCTION__> "bool Field::has_associated_compression_dictionary() const") at assert.c:101
#8 0x000000000084a445 in Field::has_associated_compression_dictionary (this=0x7ffaa109ca40) at /git/COMP-PS-5.6.33_dbg/sql/field.h:917
#9 0x0000000000b98562 in innobase_check_zip_dicts (table=0x7ffaf07d3320, dict_ids=0x7ffaa10fd138, trx=0x7ffaa10ba478, err_dict_name=0x7ffaf07d2c90) at /git/COMP-PS-5.6.33_dbg/storage/innobase/handler/ha_innodb.cc:5597
#10 0x0000000000ba1dd8 in ha_innobase::create (this=0x7ffaa10aaf10, name=0x7ffaf07d4e70 "/sda/COMP8-PS131016-percona-server-5.6.33-78.0-linux-x86_64-debug/data/#sql3811_1_0", form=0x7ffaf07d3320, create_info=0x7ffaf07d6920) at /git/COMP-PS-5.6.33_dbg/storage/innobase/handler/ha_innodb.cc:10822
#11 0x000000000064dce4 in handler::ha_create (this=0x7ffaa10aaf10, name=0x7ffaf07d4e70 "/sda/COMP8-PS131016-percona-server-5.6.33-78.0-linux-x86_64-debug/data/#sql3811_1_0", form=0x7ffaf07d3320, info=0x7ffaf07d6920) at /git/COMP-PS-5.6.33_dbg/sql/handler.cc:4776
#12 0x000000000064ebd9 in ha_create_table (thd=0x7ffac5f4a000, path=0x7ffaf07d4e70 "/sda/COMP8-PS131016-percona-server-5.6.33-78.0-linux-x86_64-debug/data/#sql3811_1_0", db=0x7ffaa101f6a8 "test", table_name=0x7ffaa101f110 "t0", create_info=0x7ffaf07d6920, create_fields=0x7ffaf07d6408, update_create_info=false, is_temp_table=false) at /git/COMP-PS-5.6.33_dbg/sql/handler.cc:5139
#13 0x00000000008c96af in rea_create_table (thd=0x7ffac5f4a000, path=0x7ffaf07d4e70 "/sda/COMP8-PS131016-percona-server-5.6.33-78.0-linux-x86_64-debug/data/#sql3811_1_0", db=0x7ffaa101f6a8 "test", table_name=0x7ffaa101f110 "t0", create_info=0x7ffaf07d6920, create_fields=..., keys=1, key_info=0x7ffaa1078880, file=0x7ffaa10783a0, no_ha_table=false) at /git/COMP-PS-5.6.33_dbg/sql/unireg.cc:528
#14 0x000000000085c5af in create_table_impl (thd=0x7ffac5f4a000, db=0x7ffaa101f6a8 "test", table_name=0x7ffaa101f110 "t0", path=0x7ffaf07d4e70 "/sda/COMP8-PS131016-percona-server-5.6.33-78.0-linux-x86_64-debug/data/#sql3811_1_0", create_info=0x7ffaf07d6920, alter_info=0x7ffaf07d63c0, internal_tmp_table=false, select_field_count=4, no_ha_table=false, is_trans=0x0, key_info=0x7ffaf07d5078, key_count=0x7ffaf07d5074) at /git/COMP-PS-5.6.33_dbg/sql/sql_table.cc:5185
#15 0x000000000085ca9c in mysql_create_table_no_lock (thd=0x7ffac5f4a000, db=0x7ffaa101f6a8 "test", table_name=0x7ffaa101f110 "t0", create_info=0x7ffaf07d6920, alter_info=0x7ffaf07d63c0, select_field_count=4, is_trans=0x0) at /git/COMP-PS-5.6.33_dbg/sql/sql_table.cc:5301
#16 0x00000000007d15a7 in create_table_from_items (thd=0x7ffac5f4a000, create_info=0x7ffaf07d6920, create_table=0x7ffaa101f148, alter_info=0x7ffaf07d63c0, items=0x7ffac5f4c9f8) at /git/COMP-PS-5.6.33_dbg/sql/sql_insert.cc:4127
#17 0x00000000007d1822 in select_create::prepare (this=0x7ffaa1020210, values=..., u=0x7ffac5f4c290) at /git/COMP-PS-5.6.33_dbg/sql/sql_insert.cc:4193
#18 0x0000000000815187 in JOIN::prepare (this=0x7ffaa1020390, tables_init=0x7ffaa101fa58, wild_num=1, conds_init=0x0, og_num=0, order_init=0x0, group_init=0x0, having_init=0x0, select_lex_arg=0x7ffac5f4c8d8, unit_arg=0x7ffac5f4c290) at /git/COMP-PS-5.6.33_dbg/sql/sql_resolver.cc:348
#19 0x000000000081bf31 in mysql_prepare_select (thd=0x7ffac5f4a000, tables=0x7ffaa101fa58, wild_num=1, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, select_options=2416184064, result=0x7ffaa1020210, unit=0x7ffac5f4c290, select_lex=0x7ffac5f4c8d8, free_join=0x7ffaf07d61e7) at /git/COMP-PS-5.6.33_dbg/sql/sql_select.cc:1055
#20 0x000000000081c1ff in mysql_select (thd=0x7ffac5f4a000, tables=0x7ffaa101fa58, wild_num=1, fields=..., conds=0x0, order=0x7ffac5f4caa0, group=0x7ffac5f4c9d8, having=0x0, select_options=2416184064, result=0x7ffaa1020210, unit=0x7ffac5f4c290, select_lex=0x7ffac5f4c8d8) at /git/COMP-PS-5.6.33_dbg/sql/sql_select.cc:1178
#21 0x000000000081a44a in handle_select (thd=0x7ffac5f4a000, result=0x7ffaa1020210, setup_tables_done_option=0) at /git/COMP-PS-5.6.33_dbg/sql/sql_select.cc:110
#22 0x00000000007ebd24 in mysql_execute_command (thd=0x7ffac5f4a000) at /git/COMP-PS-5.6.33_dbg/sql/sql_parse.cc:3514
#23 0x00000000007f5393 in mysql_parse (thd=0x7ffac5f4a000, rawbuf=0x7ffaa101f010 "CREATE TEMPORARY TABLE t0 (a int KEY,b CHAR (0)) SELECT * FROM t0", length=65, parser_state=0x7ffaf07d7500) at /git/COMP-PS-5.6.33_dbg/sql/sql_parse.cc:7011
#24 0x00000000007e7028 in dispatch_command (command=COM_QUERY, thd=0x7ffac5f4a000, packet=0x7ffac03d8001 "CREATE TEMPORARY TABLE t0 (a int KEY,b CHAR (0)) SELECT * FROM t0", packet_length=65) at /git/COMP-PS-5.6.33_dbg/sql/sql_parse.cc:1455
#25 0x00000000007e5ec9 in do_command (thd=0x7ffac5f4a000) at /git/COMP-PS-5.6.33_dbg/sql/sql_parse.cc:1062
#26 0x00000000007ad449 in do_handle_one_connection (thd_arg=0x7ffac5f4a000) at /git/COMP-PS-5.6.33_dbg/sql/sql_connect.cc:1541
#27 0x00000000007acec9 in handle_one_connection (arg=0x7ffac5f4a000) at /git/COMP-PS-5.6.33_dbg/sql/sql_connect.cc:1444
#28 0x0000000000b112ad in pfs_spawn_thread (arg=0x7ffad5fff6a0) at /git/COMP-PS-5.6.33_dbg/storage/perfschema/pfs.cc:1860
#29 0x00007ffaf01e5dc5 in start_thread (arg=0x7ffaf07d8700) at pthread_create.c:308
#30 0x00007ffaee642ced in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:113

DROP DATABASE test;CREATE DATABASE test;USE test;
CREATE COMPRESSION_DICTIONARY d0('');
CREATE TABLE t0 (id INT,dummy INT,a BLOB COLUMN_FORMAT COMPRESSED WITH COMPRESSION_DICTIONARY d0,last INT)ENGINE=InnoDB;
CREATE TABLE t0 LIKE t0;
CREATE TEMPORARY TABLE t0 (a int KEY,b CHAR (0)) SELECT * FROM t0;

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

Any connection with bug 1621684 ?

Revision history for this message
Yura Sorokin (yura-sorokin) wrote :

This is not related to bug 1621684.
bug 1621684 is purely "fake-changes"-related.

Revision history for this message
Yura Sorokin (yura-sorokin) wrote :

A bit more simplified test case to reproduce this problem

CREATE COMPRESSION_DICTIONARY d0('');
CREATE TABLE t0(id INT, a BLOB COLUMN_FORMAT COMPRESSED WITH COMPRESSION_DICTIONARY d0) ENGINE=InnoDB;
CREATE TABLE t1(id INT, a BLOB) SELECT * FROM t0;

no longer affects: percona-server/5.7
Changed in percona-server:
status: Invalid → Triaged
importance: Undecided → High
assignee: nobody → Yura Sorokin (yura-sorokin)
no longer affects: percona-server/5.7
Changed in percona-server:
importance: Undecided → High
assignee: nobody → Yura Sorokin (yura-sorokin)
status: Invalid → Triaged
Revision history for this message
Yura Sorokin (yura-sorokin) wrote :
Changed in percona-server:
status: Triaged → Fix Released
milestone: none → 5.6.35-80.0
Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

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

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.