Assertion `transactional_table || !changed || thd->transaction.stmt.modified_non_trans_table' failed.

[Roel Van de Paar]

Core was generated by `/sda/PS050517-percona-server-5.5.55-38.8-linux-x86_64-debug/bin/mysqld --no-def'.
Program terminated with signal 6, Aborted.
#0 0x00007f11eba63741 in __pthread_kill (threadid=<optimized out>, signo=signo@entry=6)
    at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:61
61 val = INTERNAL_SYSCALL (tgkill, err, 3, THREAD_GETMEM (THREAD_SELF, pid),
(gdb) bt
#0 0x00007f11eba63741 in __pthread_kill (threadid=<optimized out>, signo=signo@entry=6)
    at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:61
#1 0x00000000007fb008 in my_write_core (sig=6) at /git/PS-5.5.55_dbg/mysys/stacktrace.c:433
#2 0x00000000006bae14 in handle_fatal_signal (sig=6) at /git/PS-5.5.55_dbg/sql/signal_handler.cc:250
#3 <signal handler called>
#4 0x00007f11ea2151d7 in __GI_raise (sig=sig@entry=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:56
#5 0x00007f11ea2168c8 in __GI_abort () at abort.c:90
#6 0x00007f11ea20e146 in __assert_fail_base (fmt=0x7f11ea35f3a8 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n",
    assertion=assertion@entry=0xa9d478 "transactional_table || !changed || thd->transaction.stmt.modified_non_trans_table",
    file=file@entry=0xa9d400 "/git/PS-5.5.55_dbg/sql/sql_insert.cc", line=line@entry=3689,
    function=function@entry=0xa9df80 <select_insert::abort_result_set()::__PRETTY_FUNCTION__> "virtual void select_insert::abort_result_set()") at assert.c:92
#7 0x00007f11ea20e1f2 in __GI___assert_fail (
    assertion=0xa9d478 "transactional_table || !changed || thd->transaction.stmt.modified_non_trans_table",
    file=0xa9d400 "/git/PS-5.5.55_dbg/sql/sql_insert.cc", line=3689,
    function=0xa9df80 <select_insert::abort_result_set()::__PRETTY_FUNCTION__> "virtual void select_insert::abort_result_set()")
    at assert.c:101
#8 0x000000000057ee86 in select_insert::abort_result_set (this=this@entry=0x7f11c701fe60)
    at /git/PS-5.5.55_dbg/sql/sql_insert.cc:3688
#9 0x000000000057efa4 in select_create::abort_result_set (this=0x7f11c701fe60) at /git/PS-5.5.55_dbg/sql/sql_insert.cc:4184
#10 0x00000000005dcd60 in handle_select (thd=thd@entry=0x7f11dcbc7000, lex=lex@entry=0x7f11dcbc8c78,
    result=result@entry=0x7f11c701fe60, setup_tables_done_option=setup_tables_done_option@entry=0)
    at /git/PS-5.5.55_dbg/sql/sql_select.cc:321
#11 0x0000000000598169 in mysql_execute_command (thd=thd@entry=0x7f11dcbc7000) at /git/PS-5.5.55_dbg/sql/sql_parse.cc:2847
#12 0x000000000059ec54 in mysql_parse (thd=thd@entry=0x7f11dcbc7000, rawbuf=<optimized out>, length=35,
    parser_state=parser_state@entry=0x7f11ec055520) at /git/PS-5.5.55_dbg/sql/sql_parse.cc:6109
#13 0x00000000005a0720 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7f11dcbc7000,
    packet=packet@entry=0x7f11dcb98001 "create table t0 as select * from t1", packet_length=packet_length@entry=35)
    at /git/PS-5.5.55_dbg/sql/sql_parse.cc:1108
#14 0x00000000005a25ef in do_command (thd=0x7f11dcbc7000) at /git/PS-5.5.55_dbg/sql/sql_parse.cc:792
#15 0x0000000000651050 in do_handle_one_connection (thd_arg=thd_arg@entry=0x7f11dcbc7000)
    at /git/PS-5.5.55_dbg/sql/sql_connect.cc:1438
#16 0x0000000000651146 in handle_one_connection (arg=0x7f11dcbc7000) at /git/PS-5.5.55_dbg/sql/sql_connect.cc:1345
#17 0x00007f11eba5edc5 in start_thread (arg=0x7f11ec056700) at pthread_create.c:308
#18 0x00007f11ea2d773d 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;
CREATE TABLE t1(c1 CHAR (1));
SET binlog_format="row";
INSERT INTO t1 VALUES(@inserted_value);
SET innodb_fake_changes=1;
SET @@session.default_storage_engine=MYISAM;
create table t0 as select * from t1;

[Roel Van de Paar (roel11)]

Similar to bug 1647608 but not the same

[Shahriyar Rzayev (rzayev-sehriyar)]

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