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

Bug #1647607 reported by Roel Van de Paar
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Server moved to https://jira.percona.com/projects/PS
New
Undecided
Unassigned

Bug Description

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;

Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

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

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.