SET STATEMENT ... FOR <statement> crashes server if <statement> is RW in a RO transaction
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
|
Unassigned | ||
5.5 |
Invalid
|
Undecided
|
Unassigned | ||
5.6 |
Fix Released
|
High
|
Laurynas Biveinis |
Bug Description
(gdb) bt
#0 0x00007faf2ed9b771 in pthread_kill () from /lib64/
#1 0x000000000067679d in handle_fatal_signal (sig=11) at /mnt/workspace/
#2 <signal handler called>
#3 0x00000000006f54b0 in mysql_execute_
#4 0x00000000006fc148 in mysql_parse (thd=thd@
#5 0x00000000006fd8b9 in dispatch_command (command=<optimized out>, thd=0x7fae9e721000, packet=
#6 0x00000000006ff619 in do_command (thd=<optimized out>) at /mnt/workspace/
#7 0x00000000006cb3f2 in do_handle_
#8 0x00000000006cb4e0 in handle_
#9 0x0000000000af81f3 in pfs_spawn_thread (arg=0x7fae9e73
#10 0x00007faf2ed96df3 in start_thread () from /lib64/
#11 0x00007faf2da6001d in clone () from /lib64/libc.so.6
SET @@session.
SET STATEMENT myisam_
or
SET @@session.
SET STATEMENT myisam_
Related branches
- Laurynas Biveinis (community): Approve
-
Diff: 150 lines (+82/-6)3 files modifiedmysql-test/r/percona_statement_set.result (+29/-2)
mysql-test/t/percona_statement_set.test (+48/-2)
sql/sql_parse.cc (+5/-2)
tags: | added: set-statement |
summary: |
- handle_fatal_signal (sig=11) in mysql_execute_command for SET STATEMENT - queries + SET STATEMENT ... FOR <statement> crashes server if <statement> is RW in + a RO transaction |
We are seeing this issue in many trials (1 in 4) for PXC, so it is blocking poper PXC testing. Adding qablock.