InnoDB: Failing assertion: purge_sys->state == PURGE_STATE_RUN | abort (sig=6) in innodb_sched_priority_purge_update
Affects | Status | Importance | Assigned to | Milestone | ||
---|---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS | Status tracked in 5.7 | |||||
5.1 |
Invalid
|
Undecided
|
Unassigned | |||
5.5 |
Invalid
|
Undecided
|
Unassigned | |||
5.6 |
Fix Released
|
Medium
|
Yura Sorokin | |||
5.7 |
Fix Released
|
Medium
|
Yura Sorokin |
Bug Description
Version: '5.6.20-68.0-debug' socket: '/sda/Percona-
Revision 657, DEBUG BINARY
2014-09-13 02:50:03 6364 [Note] InnoDB: Stopping purge
2014-09-13 02:50:03 7f6723415700 InnoDB: Assertion failure in thread 140080949843712 in file ha_innodb.cc line 16159
InnoDB: Failing assertion: purge_sys->state == PURGE_STATE_RUN
(gdb) bt
#0 0x00007f78d3413771 in pthread_kill () from /lib64/
#1 0x0000000000ab09a2 in my_write_core (sig=6) at /mnt/workspace/
#2 0x000000000072ca03 in handle_fatal_signal (sig=6) at /mnt/workspace/
#3 <signal handler called>
#4 0x00007f78d2017989 in raise () from /lib64/libc.so.6
#5 0x00007f78d2019098 in abort () from /lib64/libc.so.6
#6 0x0000000000adfda8 in innodb_
#7 0x00000000007f7e98 in sys_var_
#8 0x000000000072a423 in sys_var::update (this=0x7f78d17
#9 0x000000000072b5be in set_var::update (this=0x7f77d88
#10 0x000000000072b132 in sql_set_variables (thd=0x7f78246a
#11 0x00000000007e304d in mysql_execute_
#12 0x00000000007ea051 in mysql_parse (thd=0x7f78246a
#13 0x00000000007dc5ec in dispatch_command (command=COM_QUERY, thd=0x7f78246a2000, packet=
#14 0x00000000007db518 in do_command (thd=0x7f78246a
#15 0x00000000007a34d5 in do_handle_
#16 0x00000000007a2fdd in handle_
#17 0x0000000000dbdbb8 in pfs_spawn_thread (arg=0x7f78b73c
#18 0x00007f78d340edf3 in start_thread () from /lib64/
#19 0x00007f78d20d83dd in clone () from /lib64/libc.so.6
================== Use version: Server- 5.6.20- rel68.0- 657.Linux. x86_64- debug
Percona-
================== Testcase: PURGE_STOP_ NOW=ON; sched_priority_ purge=0;
SET GLOBAL INNODB_
SET GLOBAL innodb_
================== Server start command: Server- 5.6.20- rel68.0- 657.Linux. x86_64- debug]$ cat start libjemalloc. so.1 ]; then export LD_PRELOAD= /usr/lib64/ libjemalloc. so.1 x86_64- linux-gnu/ libjemalloc. so.1 ]; then export LD_PRELOAD= /usr/lib/ x86_64- linux-gnu/ libjemalloc. so.1 Server- 5.6.20- rel68.0- 657.Linux. x86_64- debug/lib/ mysql/libjemall oc.so.1 ]; then export LD_PRELOAD= /sda/Percona- Server- 5.6.20- rel68.0- 657.Linux. x86_64- debug/lib/ mysql/libjemall oc.so.1 Server- 5.6.20- rel68.0- 657.Linux. x86_64- debug/bin/ mysqld --innodb_ buffer_ pool_size= 2147483648 --basedir= /sda/Percona- Server- 5.6.20- rel68.0- 657.Linux. x86_64- debug --datadir= /sda/Percona- Server- 5.6.20- rel68.0- 657.Linux. x86_64- debug/data --plugin- load=tokudb= ha_tokudb. so --core --socket= /sda/Percona- Server- 5.6.20- rel68.0- 657.Linux. x86_64- debug/socket. sock --port=13781 --log-error= /sda/Percona- Server- 5.6.20- rel68.0- 657.Linux. x86_64- debug/log/ master. err 2>&1 & Server- 5.6.20- rel68.0- 657.Linux. x86_64- debug/socket. sock with datadir: /sda/Percona- Server- 5.6.20- rel68.0- 657.Linux. x86_64- debug/data'
[roel@localhost Percona-
if [ -r /usr/lib64/
elif [ -r /usr/lib/
elif [ -r /sda/Percona-
else echo 'Error: jemalloc not found, please install it first'; exit 1; fi
/sda/Percona-
echo 'Server socket: /sda/Percona-