Bug #82013 assertion: state == TRX_STATE_NOT_STARTED || state == TRX_STATE_FORCED_ROLLBACK
Submitted: 27 Jun 2016 9:30
Reporter: Viswanatham Gudipati Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: InnoDB storage engine Severity:S3 (Non-critical)
Version:5.7 OS:Any
Assigned to: CPU Architecture:Any

[27 Jun 2016 9:30] Viswanatham Gudipati
Description:
2016-06-26 02:51:21 0x7fa9c440f700  InnoDB: Assertion failure in thread 140367118792448 in file trx0trx.ic line 63
InnoDB: Failing assertion: state == TRX_STATE_NOT_STARTED || state == TRX_STATE_FORCED_ROLLBACK
00:51:21 UTC - mysqld got signal 6 ;

Back trace:
-----------
Thread 1 (Thread 0x7fa9c440f700 (LWP 32426)):
 #0  0x00007faa487db771 in pthread_kill () from /lib64/libpthread.so.0
 #1  0x0000000001863cd0 in my_write_core (sig=6) at /export/home/tmp/qauser/nroot/mysql_src_c57d/mysys/stacktrace.c:247
 #2  0x0000000000ea1108 in handle_fatal_signal (sig=6) at /export/home/tmp/qauser/nroot/mysql_src_c57d/sql/signal_handler.cc:220
 #3  <signal handler called>
 #4  0x00007faa471d65c9 in raise () from /lib64/libc.so.6
 #5  0x00007faa471d7cd8 in abort () from /lib64/libc.so.6
 #6  0x0000000001ae8a3b in ut_dbg_assertion_failed (expr=0x217fa18 "state == TRX_STATE_NOT_STARTED || state == TRX_STATE_FORCED_ROLLBACK", file=0x217f898 "/export/home/tmp/qauser/nroot/mysql_src_c57d/storage/innobase/include/trx0trx.ic", line=63) at /export/home/tmp/qauser/nroot/mysql_src_c57d/storage/innobase/ut/ut0dbg.cc:67
 #7  0x0000000001ac60a0 in trx_state_eq (trx=0x7faa3db72e28, state=TRX_STATE_ACTIVE) at /export/home/tmp/qauser/nroot/mysql_src_c57d/storage/innobase/include/trx0trx.ic:62
 #8  0x0000000001ac7bab in trx_release_savepoint_for_mysql (trx=0x7faa3db72e28, savepoint_name=0x7fa9c440cae0 "1DR6V953PC") at /export/home/tmp/qauser/nroot/mysql_src_c57d/storage/innobase/trx/trx0roll.cc:575
 #9  0x00000000018afb96 in innobase_release_savepoint (hton=0x4be3940, thd=0x7fa950000b70, savepoint=0x7fa950004700) at /export/home/tmp/qauser/nroot/mysql_src_c57d/storage/innobase/handler/ha_innodb.cc:4592
 #10 0x0000000000f18a96 in ha_release_savepoint (thd=0x7fa950000b70, sv=0x7fa9500046d0) at /export/home/tmp/qauser/nroot/mysql_src_c57d/sql/handler.cc:2386
 #11 0x0000000001630ad8 in trans_savepoint (thd=0x7fa950000b70, name=...) at /export/home/tmp/qauser/nroot/mysql_src_c57d/sql/transaction.cc:645
 #12 0x0000000001533125 in mysql_execute_command (thd=0x7fa950000b70, first_level=true) at /export/home/tmp/qauser/nroot/mysql_src_c57d/sql/sql_parse.cc:4311
 #13 0x000000000153648d in mysql_parse (thd=0x7fa950000b70, parser_state=0x7fa9c440ddc0) at /export/home/tmp/qauser/nroot/mysql_src_c57d/sql/sql_parse.cc:5559
 #14 0x000000000152babb in dispatch_command (thd=0x7fa950000b70, com_data=0x7fa9c440edf0, command=COM_QUERY) at /export/home/tmp/qauser/nroot/mysql_src_c57d/sql/sql_parse.cc:1427
 #15 0x000000000152a943 in do_command (thd=0x7fa950000b70) at /export/home/tmp/qauser/nroot/mysql_src_c57d/sql/sql_parse.cc:995
 #16 0x000000000165a9c2 in handle_connection (arg=0x88c9c70) at /export/home/tmp/qauser/nroot/mysql_src_c57d/sql/conn_handler/connection_handler_per_thread.cc:300
 #17 0x0000000001ce33dc in pfs_spawn_thread (arg=0x9304850) at /export/home/tmp/qauser/nroot/mysql_src_c57d/storage/perfschema/pfs.cc:2188
 #18 0x00007faa487d6df3 in start_thread () from /lib64/libpthread.so.0
 #19 0x00007faa4729747d in clone () from /lib64/libc.so.6

How to repeat:
As of now its not reproducible "How To Repeat"  

Suggested fix:
No crash
[7 Nov 2016 22:56] MySQL Verification Team
see bug: http://bugs.mysql.com/bug.php?id=83730.
[13 Nov 2016 8:32] Erlend Dahl
Bug#83730 	Assertion "state == TRX_STATE_NOT_STARTED || state == TRX_STATE_FORCED_ROLLBACK"

was marked as a duplicate - that bug has a repro testcase.