Crashing repeated execution of SET STATEMENT ... FOR <SELECT FROM view> | Assertion `sl->join == 0' failed in reinit_stmt_before_use | sig 6 abort in sql/sql_prepare.cc:2619
Affects | Status | Importance | Assigned to | Milestone | ||
---|---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS | Status tracked in 5.7 | |||||
5.1 |
Invalid
|
Undecided
|
Unassigned | |||
5.5 |
Invalid
|
Undecided
|
Unassigned | |||
5.6 |
Fix Released
|
High
|
Laurynas Biveinis | |||
5.7 |
Fix Released
|
High
|
Laurynas Biveinis |
Bug Description
** Testcase (reproducible with debug build)
DROP DATABASE test;CREATE DATABASE test;USE test;
create view t1 as select 1 as a;
PREPARE stmt1 FROM 'SET STATEMENT binlog_format=row FOR SELECT * FROM t1';
execute stmt1;
EXECUTE stmt1;
** GDB info
#0 0x00007fdefd58e771 in pthread_kill () from /lib64/
#1 0x0000000000ab7e66 in my_write_core (sig=6) at /mnt/workspace/
#2 0x000000000072fcd3 in handle_fatal_signal (sig=6) at /mnt/workspace/
#3 <signal handler called>
#4 0x00007fdefc1925c9 in raise () from /lib64/libc.so.6
#5 0x00007fdefc193cd8 in abort () from /lib64/libc.so.6
#6 0x00007fdefc18b536 in __assert_fail_base () from /lib64/libc.so.6
#7 0x00007fdefc18b5e2 in __assert_fail () from /lib64/libc.so.6
#8 0x0000000000801f27 in reinit_
#9 0x000000000080606a in Prepared_
#10 0x00000000008051be in Prepared_
#11 0x0000000000802b5b in mysql_sql_
#12 0x00000000007e3115 in mysql_execute_
#13 0x00000000007ed49f in mysql_parse (thd=0x7fde68bf
#14 0x00000000007df8be in dispatch_command (command=COM_QUERY, thd=0x7fde68bf2000, packet=
#15 0x00000000007de7dc in do_command (thd=0x7fde68bf
#16 0x00000000007a6785 in do_handle_
#17 0x00000000007a628d in handle_
#18 0x0000000000dc648c in pfs_spawn_thread (arg=0x7fdef6b4
#19 0x00007fdefd589df3 in start_thread () from /lib64/
#20 0x00007fdefc25301d in clone () from /lib64/libc.so.6
tags: | added: qa set-statement |
The root cause is shared with bug 1635927