InnoDB: Failing assertion: block->n_pointers == 0 in buf0lru.cc line 2259
Affects | Status | Importance | Assigned to | Milestone | ||
---|---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS | Status tracked in 5.7 | |||||
5.5 |
Fix Released
|
Medium
|
Laurynas Biveinis | |||
5.6 |
Invalid
|
Undecided
|
Unassigned | |||
5.7 |
Fix Released
|
Medium
|
Laurynas Biveinis |
Bug Description
** 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=
** Testcase
DROP DATABASE test;CREATE DATABASE test;USE test;
CREATE TABLE t1(i INT)ROW_
CREATE TABLE t2(cdate date,note char(1));
XA START 'GTRID_
INSERT INTO t2 VALUES('',1),(1,2);
INSERT INTO t1 VALUES(
DELETE FROM t1 .*,test.t2.*,a.* USING t1,t2,t1 AS a;
SET GLOBAL innodb_
** GDB info
#0 0x00007f3efb7a8771 in pthread_kill () from /lib64/
#1 0x0000000001811a30 in my_write_core (sig=6) at /sda/ps57/
#2 0x0000000000e60ae3 in handle_fatal_signal (sig=6) at /sda/ps57/
#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_
#7 0x0000000001b8cd7e in buf_LRU_
#8 0x0000000001b8dd58 in buf_LRU_
#9 0x0000000001b8de7a in buf_LRU_
#10 0x00000000018e9b89 in innodb_
#11 0x00000000018e9c16 in innodb_
#12 0x000000000153acc3 in sys_var_
#13 0x000000000144c6a6 in sys_var::update (this=0x7f3eec7
#14 0x000000000144ddb6 in set_var::update (this=0x7f3eb94
#15 0x000000000144d67e in sql_set_variables (thd=0x7f3eb941
#16 0x0000000001509c85 in mysql_execute_
#17 0x000000000150f2ca in mysql_parse (thd=0x7f3eb941
#18 0x00000000015042e1 in dispatch_command (thd=0x7f3eb941
#19 0x00000000015031fb in do_command (thd=0x7f3eb941
#20 0x000000000163acb3 in handle_connection (arg=0x7f3ee33f
#21 0x0000000001849a34 in pfs_spawn_thread (arg=0x7f3ed47f
#22 0x00007f3efb7a3df3 in start_thread () from /lib64/
#23 0x00007f3ef99f51ad in clone () from /lib64/libc.so.6
The attached tarball (1457088583_
$ 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_
$ ./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_gdb # OPTIONAL: Brings you to a gdb prompt with gdb attached to the used mysqld and attached to the generated core
$ ./1457088583_
tags: | added: bp-split xtradb |
https:/ /github. com/percona/ percona- server/ pull/411, https:/ /github. com/percona/ percona- server/ pull/412, https:/ /github. com/percona/ percona- server/ pull/413