InnoDB: Failing assertion: event in file os0sync.cc line 475 | abort (sig=6) in os_event_reset on shutdown
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS |
Confirmed
|
High
|
Laurynas Biveinis | ||
5.1 |
New
|
Undecided
|
Unassigned | ||
5.5 |
New
|
Undecided
|
Unassigned | ||
5.6 |
Confirmed
|
High
|
Laurynas Biveinis |
Bug Description
(gdb) bt
#0 0x00007fee09631771 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 0x00007fee08235989 in raise () from /lib64/libc.so.6
#5 0x00007fee08237098 in abort () from /lib64/libc.so.6
#6 0x0000000000b5d216 in os_event_reset (event=0x0) at /mnt/workspace/
#7 0x0000000000b38038 in log_io_
#8 0x0000000000b365dc in log_io_complete (group=
#9 0x0000000000d2552f in fil_aio_wait (segment=1) at /mnt/workspace/
#10 0x0000000000c27b45 in io_handler_thread (arg=0x18b1a28 <n+8>) at /mnt/workspace/
#11 0x00007fee0962cdf3 in start_thread () from /lib64/
#12 0x00007fee082f63dd in clone () from /lib64/libc.so.6
2014-09-22 20:11:45 15979 [Note] InnoDB: Starting shutdown...
2014-09-22 20:11:46 7fed587fe700 InnoDB: Assertion failure in thread 140657368753920 in file os0sync.cc line 475
InnoDB: Failing assertion: event
InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to http://
InnoDB: If you get repeated assertion failures or crashes, even
InnoDB: immediately after the mysqld startup, there may be
InnoDB: corruption in the InnoDB tablespace. Please refer to
InnoDB: http://
InnoDB: about forcing recovery.
10:11:46 UTC - mysqld got signal 6 ;
============= Testcase:
1. Start mysqld:
[roel@localhost Percona- 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 --tmpdir= /sda/Percona- Server- 5.6.20- rel68.0- 657.Linux. x86_64- debug/data --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=10480 --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'
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-
2. Start client:
[roel@localhost Percona- Server- 5.6.20- rel68.0- 657.Linux. x86_64- debug]$ cat cl Server- 5.6.20- rel68.0- 657.Linux. x86_64- debug/bin/ mysql -A -uroot -S/sda/ Percona- Server- 5.6.20- rel68.0- 657.Linux. x86_64- debug/socket. sock test
/sda/Percona-
3. Execute:
mysql> source bug1372210.sql;
4. Shutdown: (important!)
[roel@localhost Percona- Server- 5.6.20- rel68.0- 657.Linux. x86_64- debug]$ cat stop Server- 5.6.20- rel68.0- 657.Linux. x86_64- debug/bin/ mysqladmin -uroot -S/sda/ Percona- Server- 5.6.20- rel68.0- 657.Linux. x86_64- debug/socket. sock shutdown 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 halted'
/sda/Percona-
echo 'Server on socket /sda/Percona-
5. Check error log.