InnoDB: Failing assertion: block->n_pointers == 0 in buf0lru.cc line 2259

[Ramesh Sivaraman]

** Error info :

2016-03-03 20:08:47 0x7f3c2f621700 InnoDB: Assertion failure in thread 139896469722880 in file buf0lru.cc line 2259
InnoDB: Failing assertion: block->n_pointers == 0

** Startup option

--sql_mode=ONLY_FULL_GROUP_BY

** Testcase

DROP DATABASE test;CREATE DATABASE test;USE test;
CREATE TABLE t1(i INT)ROW_FORMAT=COMPRESSED;
CREATE TABLE t2(cdate date,note char(1));
XA START 'GTRID_6789012345678901234567890123456789012345678901234567890123',0x425155414C5FA5A53839303132333435363738393031323334353637383930313233343536373839303132333435363738393031323334353637383930313233,1234567890;
INSERT INTO t2 VALUES('',1),(1,2);
INSERT INTO t1 VALUES(1),(1),(1),(1),(1),(1),(1),(1),(1),(1),(1),(1),(1),(1),(1),(1),(1),(1),(1),(1),(1),(1),(1),(1),(1),(1),(1),(1),(1),(1),(1),(1),(1),(1),(1),(1),(1),(1),(1),(1),(1),(1),(1),(1),(1),(1),(1),(1),(1),(1),(1),(1),(1),(1),(1),(1),(1),(1);
DELETE FROM t1 .*,test.t2.*,a.* USING t1,t2,t1 AS a;
SET GLOBAL innodb_buffer_pool_evict='uncompressed';

** GDB info

#0 0x00007f3efb7a8771 in pthread_kill () from /lib64/libpthread.so.0
#1 0x0000000001811a30 in my_write_core (sig=6) at /sda/ps57/PS-5.7-GA_dbg/mysys/stacktrace.c:247
#2 0x0000000000e60ae3 in handle_fatal_signal (sig=6) at /sda/ps57/PS-5.7-GA_dbg/sql/signal_handler.cc:223
#3 <signal handler called>
#4 0x00007f3ef99345c9 in raise () from /lib64/libc.so.6
#5 0x00007f3ef9935cd8 in abort () from /lib64/libc.so.6
#6 0x0000000001b045e3 in ut_dbg_assertion_failed (expr=0x22006c9 "block->n_pointers == 0", file=0x21ffa58 "/sda/ps57/PS-5.7-GA_dbg/storage/innobase/buf/buf0lru.cc", line=2259) at /sda/ps57/PS-5.7-GA_dbg/storage/innobase/ut/ut0dbg.cc:67
#7 0x0000000001b8cd7e in buf_LRU_block_free_non_file_page (block=0x7f3ecbddc900) at /sda/ps57/PS-5.7-GA_dbg/storage/innobase/buf/buf0lru.cc:2259
#8 0x0000000001b8dd58 in buf_LRU_block_free_hashed_page (block=0x7f3ecbddc900) at /sda/ps57/PS-5.7-GA_dbg/storage/innobase/buf/buf0lru.cc:2562
#9 0x0000000001b8de7a in buf_LRU_free_one_page (bpage=0x7f3ecbddc900, zip=false) at /sda/ps57/PS-5.7-GA_dbg/storage/innobase/buf/buf0lru.cc:2589
#10 0x00000000018e9b89 in innodb_buffer_pool_evict_uncompressed () at /sda/ps57/PS-5.7-GA_dbg/storage/innobase/handler/ha_innodb.cc:18337
#11 0x00000000018e9c16 in innodb_buffer_pool_evict_update (thd=0x7f3eb9419000, var=0x2b7f2c0 <mysql_sysvar_buffer_pool_evict>, var_ptr=0x2c7e890 <srv_buffer_pool_evict>, save=0x7f3eb942bc10) at /sda/ps57/PS-5.7-GA_dbg/storage/innobase/handler/ha_innodb.cc:18367
#12 0x000000000153acc3 in sys_var_pluginvar::global_update (this=0x7f3eec7fd3f0, thd=0x7f3eb9419000, var=0x7f3eb942bbf0) at /sda/ps57/PS-5.7-GA_dbg/sql/sql_plugin.cc:3475
#13 0x000000000144c6a6 in sys_var::update (this=0x7f3eec7fd3f0, thd=0x7f3eb9419000, var=0x7f3eb942bbf0) at /sda/ps57/PS-5.7-GA_dbg/sql/set_var.cc:183
#14 0x000000000144ddb6 in set_var::update (this=0x7f3eb942bbf0, thd=0x7f3eb9419000) at /sda/ps57/PS-5.7-GA_dbg/sql/set_var.cc:812
#15 0x000000000144d67e in sql_set_variables (thd=0x7f3eb9419000, var_list=0x7f3eb941b9a8) at /sda/ps57/PS-5.7-GA_dbg/sql/set_var.cc:669
#16 0x0000000001509c85 in mysql_execute_command (thd=0x7f3eb9419000, first_level=true) at /sda/ps57/PS-5.7-GA_dbg/sql/sql_parse.cc:3787
#17 0x000000000150f2ca in mysql_parse (thd=0x7f3eb9419000, parser_state=0x7f3efbd5d500) at /sda/ps57/PS-5.7-GA_dbg/sql/sql_parse.cc:5786
#18 0x00000000015042e1 in dispatch_command (thd=0x7f3eb9419000, com_data=0x7f3efbd5dc90, command=COM_QUERY) at /sda/ps57/PS-5.7-GA_dbg/sql/sql_parse.cc:1445
#19 0x00000000015031fb in do_command (thd=0x7f3eb9419000) at /sda/ps57/PS-5.7-GA_dbg/sql/sql_parse.cc:1008
#20 0x000000000163acb3 in handle_connection (arg=0x7f3ee33fbbe0) at /sda/ps57/PS-5.7-GA_dbg/sql/conn_handler/connection_handler_per_thread.cc:313
#21 0x0000000001849a34 in pfs_spawn_thread (arg=0x7f3ed47f2220) at /sda/ps57/PS-5.7-GA_dbg/storage/perfschema/pfs.cc:2192
#22 0x00007f3efb7a3df3 in start_thread () from /lib64/libpthread.so.0
#23 0x00007f3ef99f51ad in clone () from /lib64/libc.so.6

The attached tarball (1457088583_bug_bundle.tar.gz) gives the testcase as an exact match of our system, including some handy utilities

$ vi 1457088583_mybase # STEP1: Update the base path in this file (usually the only change required!). If you use a non-binary distribution, please update SOURCE_DIR location also
$ ./1457088583_init # STEP2: Initializes the data dir
$ ./1457088583_start # STEP3: Starts mysqld
$ ./1457088583_cl # STEP4: To check mysqld is up
$ ./1457088583_run_pquery # STEP5: Run the testcase with the pquery binary
$ ./1457088583_run # OPTIONAL: Run the testcase with the mysql CLI (may not reproduce the issue, as the pquery binary was used for the original testcase reduction)
$ vi /dev/shm/1457088583/error.log.out # STEP6: Verify the error log
$ ./1457088583_gdb # OPTIONAL: Brings you to a gdb prompt with gdb attached to the used mysqld and attached to the generated core
$ ./1457088583_parse_core # OPTIONAL: Creates 1457088583_STD.gdb and 1457088583_FULL.gdb; standard and full variables gdb stack traces

[Laurynas Biveinis (laurynas-biveinis)]

https://github.com/percona/percona-server/pull/411, https://github.com/percona/percona-server/pull/412, https://github.com/percona/percona-server/pull/413

[Shahriyar Rzayev (rzayev-sehriyar)]

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