Bug #79349 InnoDB: Failing assertion: trx_sys->rseg_array[0] != __null trx_assign_rseg_low
Submitted: 20 Nov 2015 3:36 Modified: 20 Nov 2015 6:40
Reporter: Roel Van de Paar Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: InnoDB storage engine Severity:S6 (Debug Builds)
Version:5.7.9 GA, 5.7.11 OS:Any
Assigned to: CPU Architecture:Any

[20 Nov 2015 3:36] Roel Van de Paar
Description:
2015-11-20 14:12:01 0x7fbd06eca700  InnoDB: Assertion failure in thread 140449841719040 in file trx0trx.cc line 1262
InnoDB: Failing assertion: trx_sys->rseg_array[0] != __null

+bt
#0  0x00007fbd068d0771 in __pthread_kill (threadid=<optimized out>, signo=6) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:61
#1  0x0000000001796a78 in my_write_core (sig=6) at /git/mysql-server_dbg/mysys/stacktrace.c:247
#2  0x0000000000e1dc70 in handle_fatal_signal (sig=6) at /git/mysql-server_dbg/sql/signal_handler.cc:220
#3  <signal handler called>
#4  0x00007fbd054d45d7 in __GI_raise (sig=sig@entry=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:56
#5  0x00007fbd054d5cc8 in __GI_abort () at abort.c:90
#6  0x0000000001aedf9b in ut_dbg_assertion_failed (expr=0x20d36e0 "trx_sys->rseg_array[0] != __null", file=0x20d2d70 "/git/mysql-server_dbg/storage/innobase/trx/trx0trx.cc", line=1262) at /git/mysql-server_dbg/storage/innobase/ut/ut0dbg.cc:67
#7  0x0000000001ad8c4c in trx_assign_rseg_low (max_undo_logs=128, n_tablespaces=0, rseg_type=TRX_RSEG_TYPE_REDO) at /git/mysql-server_dbg/storage/innobase/trx/trx0trx.cc:1262
#8  0x0000000001ad9475 in trx_start_low (trx=0x7fbcf8800cf8, read_write=true) at /git/mysql-server_dbg/storage/innobase/trx/trx0trx.cc:1399
#9  0x0000000001add330 in trx_start_if_not_started_xa_low (trx=0x7fbcf8800cf8, read_write=true) at /git/mysql-server_dbg/storage/innobase/trx/trx0trx.cc:3068
#10 0x0000000001a1c4ea in row_drop_database_for_mysql (name=0x7fbc4ec2e240 "test/", trx=0x7fbcf8800cf8, found=0x7fbd06ec6bc8) at /git/mysql-server_dbg/storage/innobase/row/row0mysql.cc:4938
#11 0x00000000018d64cc in innobase_drop_database (hton=0x7fbcfe7df4a0, path=0x7fbd06ec71e0 "./test/") at /git/mysql-server_dbg/storage/innobase/handler/ha_innodb.cc:12454
#12 0x0000000000e8bd2f in dropdb_handlerton (unused1=0x0, plugin=0x7fbd06ec6d08, path=0x7fbd06ec71e0) at /git/mysql-server_dbg/sql/handler.cc:994
#13 0x00000000014bcbb1 in plugin_foreach_with_mask (thd=0x0, func=0xe8bcdc <dropdb_handlerton(THD*, plugin_ref, void*)>, type=1, state_mask=4294967287, arg=0x7fbd06ec71e0) at /git/mysql-server_dbg/sql/sql_plugin.cc:2249
#14 0x0000000000e8bd64 in ha_drop_database (path=0x7fbd06ec71e0 "./test/") at /git/mysql-server_dbg/sql/handler.cc:1001
#15 0x000000000143c2ba in mysql_rm_db (thd=0x7fbc4ec19000, db=..., if_exists=false, silent=false) at /git/mysql-server_dbg/sql/sql_db.cc:888
#16 0x000000000148f69b in mysql_execute_command (thd=0x7fbc4ec19000, first_level=true) at /git/mysql-server_dbg/sql/sql_parse.cc:3611
#17 0x0000000001494305 in mysql_parse (thd=0x7fbc4ec19000, parser_state=0x7fbd06ec9670) at /git/mysql-server_dbg/sql/sql_parse.cc:5357
#18 0x0000000001489caa in dispatch_command (thd=0x7fbc4ec19000, com_data=0x7fbd06ec9dc0, command=COM_QUERY) at /git/mysql-server_dbg/sql/sql_parse.cc:1284
#19 0x0000000001488b76 in do_command (thd=0x7fbc4ec19000) at /git/mysql-server_dbg/sql/sql_parse.cc:852
#20 0x00000000015b2cdb in handle_connection (arg=0x7fbc43ffb1c0) at /git/mysql-server_dbg/sql/conn_handler/connection_handler_per_thread.cc:295
#21 0x00000000017c3aa0 in pfs_spawn_thread (arg=0x7fbc54fe7620) at /git/mysql-server_dbg/storage/perfschema/pfs.cc:2192
#22 0x00007fbd068cbdf5 in start_thread (arg=0x7fbd06eca700) at pthread_create.c:308
#23 0x00007fbd055951ad in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:113

How to repeat:
# mysqld options required for replay:  --innodb-force-recovery=254
DROP DATABASE test;CREATE DATABASE test;USE test;
DROP TABLE mysql.innodb_table_stats;

Note: may crash on first SQL line already.
[20 Nov 2015 6:40] MySQL Verification Team
Hello Roel,

Thank you for the report and test case.
Observed that 5.7.9/5.7.11 debug builds are asserting.

Thanks,
Umesh