InnoDB: Failing assertion: bpage->oldest_modification != 0 in file buf0flu.c and buf0lru.c
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS |
Fix Released
|
High
|
Laurynas Biveinis | ||
5.1 |
Invalid
|
Undecided
|
Laurynas Biveinis | ||
5.5 |
Fix Released
|
High
|
Laurynas Biveinis |
Bug Description
InnoDB: DEBUG: update_statistics for query13003/
130130 20:26:03 InnoDB: Assertion failure in thread 465360640 in file buf0flu.c line 1123
InnoDB: Failing assertion: bpage->
Thread 5 (LWP 23771):
+bt
#0 0x0000000004e3969c in pthread_kill () from /lib64/
#1 0x00000000007e2779 in my_write_core (sig=6) at /ssd/QA-
#2 0x00000000006ab0ea in handle_fatal_signal (sig=6) at /ssd/QA-
#3 <signal handler called>
#4 0x0000000005b448a5 in raise () from /lib64/libc.so.6
#5 0x0000000005b46085 in abort () from /lib64/libc.so.6
#6 0x00000000008d4346 in buf_flush_
#7 buf_flush_
#8 buf_flush_
#9 buf_LRU_
#10 0x000000000090687a in fil_delete_
#11 0x0000000000841d1b in row_drop_
#12 0x000000000081d3f3 in ha_innobase:
#13 0x00000000006b396c in handler:
#14 0x00000000006b3ba4 in ha_delete_table (thd=0x101a8f20, table_type=
#15 0x00000000006030a7 in quick_rm_table (base=0x6293750, db=0x16d40300 "query011069", table_name=
#16 0x0000000000606b84 in mysql_alter_table (thd=<optimized out>, new_db=0x16d40300 "query011069", new_name=0x16d40318 "t1", create_
#17 0x00000000007c1a21 in Alter_table_
#18 0x000000000059f198 in mysql_execute_
#19 0x000000000059fa80 in mysql_parse (thd=0x101a8f20, rawbuf=0x16d40220 "ALTER TABLE query011069 . `t1` DROP COLUMN `c34`", length=<optimized out>, parser_
#20 0x00000000005a0d9f in dispatch_command (command=COM_QUERY, thd=0x101a8f20, packet=<optimized out>, packet_length=48) at /ssd/QA-
#21 0x00000000005a22d9 in do_command (thd=0x101a8f20) at /ssd/QA-
#22 0x00000000006479b1 in do_handle_
#23 0x0000000000647aa7 in handle_
#24 0x0000000004e34851 in start_thread () from /lib64/
#25 0x0000000005bfa11d in clone () from /lib64/libc.so.6
Run command:
[roel@macpro2 210222]$ cat cmd1004
ps -ef | grep 'cmdrun_1004' | grep -v grep | awk '{print $2}' | xargs sudo kill -9
rm -Rf /ssd/210222/
mkdir /ssd/210222/
cd /ssd/randgen
bash -c "set -o pipefail; perl runall.pl --queries=100000000 --seed=29973 --duration=180 --querytimeout=60 --short_
Related branches
- Stewart Smith (community): Approve
-
Diff: 434 lines (+153/-46)7 files modifiedPercona-Server/storage/innobase/buf/buf0buf.c (+1/-1)
Percona-Server/storage/innobase/buf/buf0flu.c (+2/-2)
Percona-Server/storage/innobase/buf/buf0lru.c (+97/-37)
Percona-Server/storage/innobase/fil/fil0fil.c (+1/-1)
Percona-Server/storage/innobase/ibuf/ibuf0ibuf.c (+1/-1)
Percona-Server/storage/innobase/include/buf0buf.h (+22/-2)
Percona-Server/storage/innobase/include/buf0buf.ic (+29/-2)
tags: | removed: bitmap |
Crash in trial 1005
InnoDB: DEBUG: update_statistics for query13003/ #sql-694_ 406. oldest_ modification != 0
130130 20:26:03 InnoDB: Assertion failure in thread 465360640 in file buf0flu.c line 1123
InnoDB: Failing assertion: bpage->
Note the different location. If you would like stacks/error log, happy to run/provide.