MySQL Bugs: #70983: Assertion `0' fails on creating a temporary table via trigger

Bug #70983	Assertion `0' fails on creating a temporary table via trigger
Submitted:	22 Nov 2013 16:58	Modified:	16 Jan 2014 5:43
Reporter:	Elena Stepanova	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Stored Routines	Severity:	S3 (Non-critical)
Version:	5.6	OS:	Any
Assigned to:		CPU Architecture:	Any

Description:
mysqld: /home/elenst/bzr/mysql-5.6/sql/protocol.cc:518: void Protocol::end_statement(): Assertion `0' failed.
16:51:56 UTC - mysqld got signal 6 ;

#6  0x00007f6830912621 in *__GI___assert_fail (assertion=0xf27c06 "0", file=<optimized out>, line=518, function=0xf28930 "void Protocol::end_statement()") at assert.c:81
#7  0x000000000074f505 in Protocol::end_statement (this=0x3224700) at /home/elenst/bzr/mysql-5.6/sql/protocol.cc:518
#8  0x0000000000806cf6 in dispatch_command (command=COM_QUERY, thd=0x32241e0, packet=0x32fb9e1 "insert into t1 values (1)", packet_length=25) at /home/elenst/bzr/mysql-5.6/sql/sql_parse.cc:1761
#9  0x0000000000804a0d in do_command (thd=0x32241e0) at /home/elenst/bzr/mysql-5.6/sql/sql_parse.cc:1036
#10 0x00000000007cbcab in do_handle_one_connection (thd_arg=0x32241e0) at /home/elenst/bzr/mysql-5.6/sql/sql_connect.cc:982
#11 0x00000000007cb73e in handle_one_connection (arg=0x32241e0) at /home/elenst/bzr/mysql-5.6/sql/sql_connect.cc:898
#12 0x0000000000b2b485 in pfs_spawn_thread (arg=0x3276080) at /home/elenst/bzr/mysql-5.6/storage/perfschema/pfs.cc:1858
#13 0x00007f6831c5bb50 in start_thread (arg=<optimized out>) at pthread_create.c:304
#14 0x00007f68309c1a7d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
#15 0x0000000000000000 in ?? ()

revision-id: balasubramanian.kandasamy@oracle.com-20130910072510-5qdf58pj8ispvyro
revno: 5412
branch-nick: mysql-5.6
BUILD/compile-pentium-debug-max-no-ndb

How to repeat:
create table t1 (i int);
create trigger tr after insert on t1 for each row
  create temporary table tmp as select new.i;

insert into t1 values (1);

Thanks for the report:

Version: '5.6.16-debug'  socket: ''  port: 3306  MySQL Community Server (GPL)
Assertion failed: 0, file protocol.cc, line 518
mysqld-debug.exe!my_sigabrt_handler()[my_thr_init.c:517]
mysqld-debug.exe!raise()[winsig.c:593]
mysqld-debug.exe!abort()[abort.c:81]
mysqld-debug.exe!_wassert()[assert.c:153]
mysqld-debug.exe!Protocol::end_statement()[protocol.cc:518]
mysqld-debug.exe!dispatch_command()[sql_parse.cc:1762]
mysqld-debug.exe!do_command()[sql_parse.cc:1036]
mysqld-debug.exe!do_handle_one_connection()[sql_connect.cc:982]
mysqld-debug.exe!handle_one_connection()[sql_connect.cc:899]
mysqld-debug.exe!pfs_spawn_thread()[pfs.cc:1860]
mysqld-debug.exe!pthread_start()[my_winthread.c:62]
mysqld-debug.exe!_callthreadstartex()[threadex.c:314]
mysqld-debug.exe!_threadstartex()[threadex.c:297]

This was fixed in 5.7.1 under the heading of Bug#14493938.	

[23 Jan 2013 5:08] Paul Dubois

Noted in 5.7.1 changelog.

For debug builds, creating a TEMPORARY table inside a trigger caused
the server to exit.