InnoDB: Assertion failure in file buf0flu.cc line 546 | crashes if RW workload and InnoDB compression are combined
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 | ||
5.6 |
Fix Released
|
High
|
Laurynas Biveinis |
Bug Description
Crash happens regularily (3 times already) in Percona Server 56-5.6.
2014-03-24 21:50:57 7f3322ffd700 InnoDB: Assertion failure in thread 139857607251712 in file buf0flu.cc line 546
InnoDB: Failing assertion: buf_page_
InnoDB: We intentionally generate a memory trap.
...
Thread pointer: 0x0
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 0 thread_stack 0x40000
/usr/sbin/
/usr/sbin/
/lib64/
/lib64/
/lib64/
/usr/sbin/
/usr/sbin/
/usr/sbin/
/usr/sbin/
/usr/sbin/
/lib64/
/lib64/
decoding trace gives:
0xa4db52 buf_flush_
0xa5075c buf_flush_
0xa515fc buf_flush_
0xa52b2b buf_flush_
0xa53819 buf_flush_
Stack traces are identical for all of the 3 craches.
Database uses compressed (Barracuda) InnoDB tables.
my.cnf options relevant to InnoDB:
innodb_
innodb_
innodb_
innodb_
innodb_
innodb_
innodb_
innodb_
innodb_file_format = 'Barracuda'
Related branches
- Vlad Lesin (community): Approve (g2)
-
Diff: 302 lines (+47/-59)5 files modifiedstorage/innobase/buf/buf0buf.c (+9/-1)
storage/innobase/buf/buf0flu.c (+5/-1)
storage/innobase/buf/buf0lru.c (+22/-55)
storage/innobase/buf/buf0rea.c (+6/-2)
storage/innobase/include/buf0buf.ic (+5/-0)
- Vlad Lesin (community): Approve (g2)
-
Diff: 91 lines (+24/-3)4 files modifiedstorage/innobase/btr/btr0sea.cc (+5/-1)
storage/innobase/buf/buf0flu.cc (+12/-2)
storage/innobase/buf/buf0lru.cc (+2/-0)
storage/innobase/include/buf0buf.ic (+5/-0)
tags: | added: xtradb |
summary: |
- InnoDB: Assertion failure in file buf0flu.cc line 546 + InnoDB: Assertion failure in file buf0flu.cc line 546 | crashes if RW + workload and InnoDB compression are combined |
This is the same underlying issue as bug 1227581 and bug 1269352.