Assertion failure with Query_cache on debug build + --debug option
Affects | Status | Importance | Assigned to | Milestone | ||
---|---|---|---|---|---|---|
MySQL Server |
Unknown
|
Unknown
|
||||
Percona Server moved to https://jira.percona.com/projects/PS | Status tracked in 5.7 | |||||
5.1 |
Won't Fix
|
Low
|
Unassigned | |||
5.5 |
Triaged
|
Low
|
Unassigned | |||
5.6 |
Triaged
|
Low
|
Unassigned | |||
5.7 |
Fix Released
|
Low
|
Unassigned |
Bug Description
Hit this assertion when running UNIV_DEBUG enabled binary (tested with both 5.5.27 and trunk PS).
=======
mysqld: /media/
Program received signal SIGABRT, Aborted.
[Switching to Thread 0x7fffc422f700 (LWP 3651)]
0x00007ffff6185fa5 in raise () from /lib/libc.so.6
(gdb) bt
#0 0x00007ffff6185fa5 in raise () from /lib/libc.so.6
#1 0x00007ffff6187428 in abort () from /lib/libc.so.6
#2 0x00007ffff617f002 in __assert_fail_base () from /lib/libc.so.6
#3 0x00007ffff617f0b2 in __assert_fail () from /lib/libc.so.6
bt ful#4 0x0000000000568484 in Query_cache:
#5 0x000000000059deec in dispatch_command (command=
#6 0x000000000059e73f in do_command (thd=0x24b7cc0) at /media/
#7 0x0000000000648041 in do_handle_
#8 0x0000000000648137 in handle_
#9 0x00007ffff7bc6e0f in start_thread () from /lib/libpthread
#10 0x00007ffff623504d in clone () from /lib/libc.so.6
(gdb) bt full
#0 0x00007ffff6185fa5 in raise () from /lib/libc.so.6
No symbol table info available.
#1 0x00007ffff6187428 in abort () from /lib/libc.so.6
No symbol table info available.
#2 0x00007ffff617f002 in __assert_fail_base () from /lib/libc.so.6
No symbol table info available.
#3 0x00007ffff617f0b2 in __assert_fail () from /lib/libc.so.6
No symbol table info available.
#4 0x0000000000568484 in Query_cache:
header = 0x7fffee007058
allign_size = <optimized out>
len = <optimized out>
query_block = 0x7fffee007000
#5 0x000000000059deec in dispatch_command (command=
net = 0x24b7ef0
error = false
#6 0x000000000059e73f in do_command (thd=0x24b7cc0) at /media/
packet = 0x24a80f0 "\001"
net = 0x24b7ef0
command = COM_QUERY
#7 0x0000000000648041 in do_handle_
rc = <optimized out>
create_user = true
thd = 0x24b7cc0
#8 0x0000000000648137 in handle_
thd = 0x24afdf0
#9 0x00007ffff7bc6e0f in start_thread () from /lib/libpthread
No symbol table info available.
#10 0x00007ffff623504d in clone () from /lib/libc.so.6
No symbol table info available.
=======
The my.cnf is http://
To reproduce: start mysqld as mysqld --user=mysql --debug (with above my.cnf) and run sysbench or some load, and wait for it to crash on signal 6.
Changed in percona-server: | |
status: | New → Confirmed |
summary: |
- Assertion failure with Query_cache on UNIV_DEBUG + Assertion failure with Query_cache on debug configuration |
tags: | added: upstream |
I wonder if the crashing workload could be minimized? Does sysbench load depend on multiple client connections?