Bug #72294 Assertion `0' fails on killing INSERT .. SELECT into a FEDERATED table
Submitted: 9 Apr 2014 17:28 Modified: 10 Apr 2014 6:19
Reporter: Elena Stepanova Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Optimizer Severity:S3 (Non-critical)
Version:5.5-debug, 5.6-debug OS:Any
Assigned to: CPU Architecture:Any

[9 Apr 2014 17:28] Elena Stepanova
Description:
Test case from bug #34660 readily causes assertion failure:

mysql-5.6/sql/protocol.cc:518: void Protocol::end_statement(): Assertion `0' failed.
2014-04-09 21:18:07 5110 [ERROR] Got error 1430 when reading table './test/t1_fed'
17:18:07 UTC - mysqld got signal 6 ;

#2  0x00007f9f8b6f8621 in *__GI___assert_fail (assertion=0xf39ee6 "0", file=<optimized out>, line=518, function=0xf3b010 "void Protocol::end_statement()") at assert.c:81
#3  0x0000000000732381 in Protocol::end_statement (this=0x7f9f40094ce8) at /home/elenst/bzr/mysql-5.6/sql/protocol.cc:518
#4  0x00000000007df67f in dispatch_command (command=COM_QUERY, thd=0x7f9f40094810, packet=0x7f9f400d1fa1 "insert ignore into `t1_fed` (`c1`) select `c1` from  `t1_local` a where not exists (select 1 from `t1_fed` b where a.c1 = b.c1)", packet_length=127) at /home/elenst/bzr/mysql-5.6/sql/sql_parse.cc:1761
#5  0x00000000007dd4f6 in do_command (thd=0x7f9f40094810) at /home/elenst/bzr/mysql-5.6/sql/sql_parse.cc:1036
#6  0x00000000007a7da4 in do_handle_one_connection (thd_arg=0x7f9f4c05ed90) at /home/elenst/bzr/mysql-5.6/sql/sql_connect.cc:982
#7  0x00000000007a78d3 in handle_one_connection (arg=0x7f9f4c05ed90) at /home/elenst/bzr/mysql-5.6/sql/sql_connect.cc:898
#8  0x0000000000dc099d in pfs_spawn_thread (arg=0x7f9f4c066f00) at /home/elenst/bzr/mysql-5.6/storage/perfschema/pfs.cc:1860
#9  0x00007f9f8ca41b50 in start_thread (arg=<optimized out>) at pthread_create.c:304
#10 0x00007f9f8b7a7a7d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112

How to repeat:
Compile and run C test case from bug #34660 ( http://bugs.mysql.com/file.php?id=8628&bug_id=34660 )
[10 Apr 2014 6:19] Umesh Shastry
Hello Elena,

Thank you for the bug report.
Verified as described on 5.6.18 debug build.

Thanks,
Umesh
[10 Apr 2014 6:23] Umesh Shastry
//

mysqld-debug: /export/home/pb2/build/sb_0-11688875-1394039015.42/mysqlcom-pro-5.6.18/sql/protocol.cc:518: void Protocol::end_statement(): Assertion `0' failed.
20:43:49 UTC - mysqld got signal 6 ;
..
..

Protocol::end_statement()
protocol.cc:522
dispatch_command(enum_server_command, THD*, char*, unsigned int)
sql_parse.cc:1762
do_command(THD*)
sql_parse.cc:1036
do_handle_one_connection(THD*)
sql_connect.cc:982
handle_one_connection
sql_connect.cc:899
pfs_spawn_thread
pfs.cc:1862