Assertion `transactional_table || !changed || thd->transaction.stmt.cannot_safely_rollback()' failed.

[Roel Van de Paar]

2016-12-06 19:46:14 18656 [Note] /sda/PS071116-percona-server-5.6.34-79.1-linux-x86_64-debug/bin/mysqld: ready for connections.
Version: '5.6.34-79.1-debug-log' socket: '/sda/PS071116-percona-server-5.6.34-79.1-linux-x86_64-debug/socket.sock' port: 12406 MySQL Community Server (GPL)
mysqld: /git/PS-5.6.34_dbg/sql/sql_insert.cc:3966: virtual void select_insert::abort_result_set(): Assertion `transactional_table || !changed || thd->transaction.stmt.cannot_safely_rollback()' failed.
08:46:20 UTC - mysqld got signal 6 ;

(gdb) bt
#0 0x00007fbbbc57b741 in __pthread_kill (threadid=<optimized out>, signo=6) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:61
#1 0x0000000000ac335e in my_write_core (sig=6) at /git/PS-5.6.34_dbg/mysys/stacktrace.c:422
#2 0x00000000007374d7 in handle_fatal_signal (sig=6) at /git/PS-5.6.34_dbg/sql/signal_handler.cc:236
#3 <signal handler called>
#4 0x00007fbbba9125f7 in __GI_raise (sig=sig@entry=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:56
#5 0x00007fbbba913ce8 in __GI_abort () at abort.c:90
#6 0x00007fbbba90b566 in __assert_fail_base (fmt=0x7fbbbaa5bce8 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n",
    assertion=assertion@entry=0xed0420 "transactional_table || !changed || thd->transaction.stmt.cannot_safely_rollback()",
    file=file@entry=0xed0228 "/git/PS-5.6.34_dbg/sql/sql_insert.cc", line=line@entry=3966,
    function=function@entry=0xed1700 <select_insert::abort_result_set()::__PRETTY_FUNCTION__> "virtual void select_insert::abort_result_set()") at assert.c:92
#7 0x00007fbbba90b612 in __GI___assert_fail (assertion=0xed0420 "transactional_table || !changed || thd->transaction.stmt.cannot_safely_rollback()",
    file=0xed0228 "/git/PS-5.6.34_dbg/sql/sql_insert.cc", line=3966,
    function=0xed1700 <select_insert::abort_result_set()::__PRETTY_FUNCTION__> "virtual void select_insert::abort_result_set()") at assert.c:101
#8 0x00000000007d1d67 in select_insert::abort_result_set (this=0x7fbb6d41fee0) at /git/PS-5.6.34_dbg/sql/sql_insert.cc:3965
#9 0x00000000007d31d5 in select_create::abort_result_set (this=0x7fbb6d41fee0) at /git/PS-5.6.34_dbg/sql/sql_insert.cc:4498
#10 0x000000000081b112 in handle_select (thd=0x7fbb9234d000, result=0x7fbb6d41fee0, setup_tables_done_option=0) at /git/PS-5.6.34_dbg/sql/sql_select.cc:116
#11 0x00000000007ec91c in mysql_execute_command (thd=0x7fbb9234d000) at /git/PS-5.6.34_dbg/sql/sql_parse.cc:3514
#12 0x00000000007f5f7f in mysql_parse (thd=0x7fbb9234d000, rawbuf=0x7fbb6d41f010 "CREATE TABLE t2 SELECT * FROM v1", length=32, parser_state=0x7fbbbcb6e500)
    at /git/PS-5.6.34_dbg/sql/sql_parse.cc:7011
#13 0x00000000007e7c20 in dispatch_command (command=COM_QUERY, thd=0x7fbb9234d000, packet=0x7fbb8c7f0001 "CREATE TABLE t2 SELECT * FROM v1", packet_length=32)
    at /git/PS-5.6.34_dbg/sql/sql_parse.cc:1455
#14 0x00000000007e6ac1 in do_command (thd=0x7fbb9234d000) at /git/PS-5.6.34_dbg/sql/sql_parse.cc:1062
#15 0x00000000007ae041 in do_handle_one_connection (thd_arg=0x7fbb9234d000) at /git/PS-5.6.34_dbg/sql/sql_connect.cc:1541
#16 0x00000000007adac1 in handle_one_connection (arg=0x7fbb9234d000) at /git/PS-5.6.34_dbg/sql/sql_connect.cc:1444
#17 0x0000000000b11ef1 in pfs_spawn_thread (arg=0x7fbba23ff6a0) at /git/PS-5.6.34_dbg/storage/perfschema/pfs.cc:1860
#18 0x00007fbbbc576dc5 in start_thread (arg=0x7fbbbcb6f700) at pthread_create.c:308
#19 0x00007fbbba9d3ced in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:113

# mysqld options required for replay: --log-bin
DROP DATABASE test;CREATE DATABASE test;USE test;
SET BINLOG_FORMAT=MIXED;
create temporary table v1 as select 'This is temp. table' A;
SET innodb_fake_changes=1;
SET @@storage_engine=MEMORY;
CREATE TABLE t2 SELECT * FROM v1;

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-3612