InnoDB: Failing assertion: success | InnoDB: page_zip_apply_log: 97>>1 > 1 | InnoDB: unable to decompress space 6 page 3

[Roel Van de Paar]

2016-12-06 14:44:31 4969 [Note] /sda/PS071116-percona-server-5.6.34-79.1-linux-x86_64-debug/bin/mysqld: ready for connections.
Version: '5.6.34-79.1-debug' socket: '/sda/PS071116-percona-server-5.6.34-79.1-linux-x86_64-debug/socket.sock' port: 12406 MySQL Community Server (GPL)
2016-12-06 14:44:37 7fe66c4fe700 InnoDB: page_zip_apply_log: 97>>1 > 1
InnoDB: unable to decompress space 6 page 3
2016-12-06 14:44:37 7fe66c4fe700 InnoDB: Assertion failure in thread 140627636381440 in file buf0buf.cc line 3060
InnoDB: Failing assertion: success

Core was generated by `/sda/PS071116-percona-server-5.6.34-79.1-linux-x86_64-debug/bin/mysqld --no-def'.
Program terminated with signal 6, Aborted.
#0 0x00007fe66bf10741 in __pthread_kill (threadid=<optimized out>, signo=6) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:61
61 val = INTERNAL_SYSCALL (tgkill, err, 3, THREAD_GETMEM (THREAD_SELF, pid),
(gdb) bt
#0 0x00007fe66bf10741 in __pthread_kill (threadid=<optimized out>, signo=6) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:61
#1 0x0000000000ac335e in my_write_core (sig=6) at /git/PS-5.6.34_dbg/mysys/stacktrace.c:422
#2 0x00000000007374d7 in handle_fatal_signal (sig=6) at /git/PS-5.6.34_dbg/sql/signal_handler.cc:236
#3 <signal handler called>
#4 0x00007fe66a2a75f7 in __GI_raise (sig=sig@entry=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:56
#5 0x00007fe66a2a8ce8 in __GI_abort () at abort.c:90
#6 0x0000000000d69ffd in buf_page_get_gen (space=6, zip_size=8192, offset=3, rw_latch=3, guess=0x0, mode=10,
    file=0x10161c0 "/git/PS-5.6.34_dbg/storage/innobase/include/btr0pcur.ic", line=518, mtr=0x7fe66c4fb660) at /git/PS-5.6.34_dbg/storage/innobase/buf/buf0buf.cc:3060
#7 0x0000000000d48217 in btr_cur_open_at_index_side_func (from_left=true, index=0x7fe61cc9b478, latch_mode=1, cursor=0x7fe61cd5aef0, level=0,
    file=0x10161c0 "/git/PS-5.6.34_dbg/storage/innobase/include/btr0pcur.ic", line=518, mtr=0x7fe66c4fb660) at /git/PS-5.6.34_dbg/storage/innobase/btr/btr0cur.cc:969
#8 0x0000000000cbc3e3 in btr_pcur_open_at_index_side (from_left=true, index=0x7fe61cc9b478, latch_mode=1, pcur=0x7fe61cd5aef0, init_pcur=false, level=0, mtr=0x7fe66c4fb660)
    at /git/PS-5.6.34_dbg/storage/innobase/include/btr0pcur.ic:518
#9 0x0000000000cc3def in row_search_for_mysql (buf=0x7fe61cc9b010 "\377", mode=1, prebuilt=0x7fe61cd5ae78, match_mode=0, direction=0)
    at /git/PS-5.6.34_dbg/storage/innobase/row/row0sel.cc:4186
#10 0x0000000000b9e3d7 in ha_innobase::index_read (this=0x7fe61ccaa510, buf=0x7fe61cc9b010 "\377", key_ptr=0x0, key_len=0, find_flag=HA_READ_AFTER_KEY)
    at /git/PS-5.6.34_dbg/storage/innobase/handler/ha_innodb.cc:8684
#11 0x0000000000b9f236 in ha_innobase::index_first (this=0x7fe61ccaa510, buf=0x7fe61cc9b010 "\377") at /git/PS-5.6.34_dbg/storage/innobase/handler/ha_innodb.cc:9071
#12 0x0000000000b9f41a in ha_innobase::rnd_next (this=0x7fe61ccaa510, buf=0x7fe61cc9b010 "\377") at /git/PS-5.6.34_dbg/storage/innobase/handler/ha_innodb.cc:9168
#13 0x000000000064a764 in handler::ha_rnd_next (this=0x7fe61ccaa510, buf=0x7fe61cc9b010 "\377") at /git/PS-5.6.34_dbg/sql/handler.cc:2937
#14 0x00000000009a30f8 in rr_sequential (info=0x7fe61cc209e0) at /git/PS-5.6.34_dbg/sql/records.cc:490
#15 0x00000000007bdfac in join_init_read_record (tab=0x7fe61cc20950) at /git/PS-5.6.34_dbg/sql/sql_executor.cc:2405
#16 0x00000000007bb79e in sub_select (join=0x7fe61cc1fbf8, join_tab=0x7fe61cc20950, end_of_records=false) at /git/PS-5.6.34_dbg/sql/sql_executor.cc:1259
#17 0x00000000007bb19e in do_select (join=0x7fe61cc1fbf8) at /git/PS-5.6.34_dbg/sql/sql_executor.cc:936
#18 0x00000000007b913d in JOIN::exec (this=0x7fe61cc1fbf8) at /git/PS-5.6.34_dbg/sql/sql_executor.cc:194
#19 0x000000000081cc97 in mysql_execute_select (thd=0x7fe641b4a000, select_lex=0x7fe641b4c8d8, free_join=true) at /git/PS-5.6.34_dbg/sql/sql_select.cc:1101
#20 0x000000000081cf89 in mysql_select (thd=0x7fe641b4a000, tables=0x7fe61cc1f5b8, wild_num=0, fields=..., conds=0x0, order=0x7fe641b4caa0, group=0x7fe641b4c9d8, having=0x0,
    select_options=2147748608, result=0x7fe61cc1fbd0, unit=0x7fe641b4c290, select_lex=0x7fe641b4c8d8) at /git/PS-5.6.34_dbg/sql/sql_select.cc:1222
#21 0x000000000081b082 in handle_select (thd=0x7fe641b4a000, result=0x7fe61cc1fbd0, setup_tables_done_option=0) at /git/PS-5.6.34_dbg/sql/sql_select.cc:110
#22 0x00000000007f32b8 in execute_sqlcom_select (thd=0x7fe641b4a000, all_tables=0x7fe61cc1f5b8) at /git/PS-5.6.34_dbg/sql/sql_parse.cc:5726
#23 0x00000000007eb5c9 in mysql_execute_command (thd=0x7fe641b4a000) at /git/PS-5.6.34_dbg/sql/sql_parse.cc:3023
#24 0x00000000007f5f7f in mysql_parse (thd=0x7fe641b4a000, rawbuf=0x7fe61cc1f010 "SELECT CAST(COALESCE(a,a)AS DECIMAL(25,3)) FROM t1", length=50, parser_state=0x7fe66c4fd500)
    at /git/PS-5.6.34_dbg/sql/sql_parse.cc:7011
#25 0x00000000007e7c20 in dispatch_command (command=COM_QUERY, thd=0x7fe641b4a000, packet=0x7fe63bfd8001 "", packet_length=50) at /git/PS-5.6.34_dbg/sql/sql_parse.cc:1455
#26 0x00000000007e6ac1 in do_command (thd=0x7fe641b4a000) at /git/PS-5.6.34_dbg/sql/sql_parse.cc:1062
#27 0x00000000007ae041 in do_handle_one_connection (thd_arg=0x7fe641b4a000) at /git/PS-5.6.34_dbg/sql/sql_connect.cc:1541
#28 0x00000000007adac1 in handle_one_connection (arg=0x7fe641b4a000) at /git/PS-5.6.34_dbg/sql/sql_connect.cc:1444
#29 0x0000000000b11ef1 in pfs_spawn_thread (arg=0x7fe651bff6a0) at /git/PS-5.6.34_dbg/storage/perfschema/pfs.cc:1860
#30 0x00007fe66bf0bdc5 in start_thread (arg=0x7fe66c4fe700) at pthread_create.c:308
#31 0x00007fe66a368ced in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:113

DROP DATABASE test;CREATE DATABASE test;USE test;
SET GLOBAL innodb_compressed_columns_threshold=1000;
SET GLOBAL innodb_file_format=Barracuda;
CREATE TABLE t1(a VARBINARY(255)COLUMN_FORMAT COMPRESSED) ROW_FORMAT=COMPRESSED ENGINE=InnoDB;
INSERT INTO t1 VALUES(REPEAT('abc',1000));
SET GLOBAL innodb_buffer_pool_evict='uncompressed';
SELECT CAST(COALESCE(a,a)AS DECIMAL(25,3)) FROM t1;

[Yura Sorokin (yura-sorokin)]

5.7 is not affected.
Only MTR test cases from 5.6 fix need to be merged.

[Yura Sorokin (yura-sorokin)]

https://github.com/percona/percona-server/pull/1248
https://github.com/percona/percona-server/pull/1249

[Shahriyar Rzayev (rzayev-sehriyar)]

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