Bug #82043 Failing assertion: !srv_read_only_mode || m_impl.m_log_mode == MTR_LOG_NO_REDO
Submitted: 29 Jun 2016 7:47 Modified: 29 Jun 2016 7:54
Reporter: Roel Van de Paar Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: InnoDB storage engine Severity:S6 (Debug Builds)
Version:5.7.13 OS:Any
Assigned to: CPU Architecture:Any

[29 Jun 2016 7:47] Roel Van de Paar
Description:
Version: '5.7.13-debug'  socket: '/sda/MS270616-mysql-5.7.13-linux-x86_64-debug/socket.sock'  port: 18573  MySQL Community Server (GPL)
2016-06-29 17:29:55 0x7f584b343700  InnoDB: Assertion failure in thread 140017195562752 in file mtr0mtr.cc line 574
InnoDB: Failing assertion: !srv_read_only_mode || m_impl.m_log_mode == MTR_LOG_NO_REDO

+bt
#0  0x00007f584ad32741 in __pthread_kill (threadid=<optimized out>, signo=6) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:61
#1  0x0000000001818928 in my_write_core (sig=6) at /git/mysql-5.7.13_dbg/mysys/stacktrace.c:247
#2  0x0000000000e6e428 in handle_fatal_signal (sig=6) at /git/mysql-5.7.13_dbg/sql/signal_handler.cc:220
#3  <signal handler called>
#4  0x00007f58490cb5f7 in __GI_raise (sig=sig@entry=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:56
#5  0x00007f58490ccce8 in __GI_abort () at abort.c:90
#6  0x0000000001b7a6e3 in ut_dbg_assertion_failed (expr=0x2191508 "!srv_read_only_mode || m_impl.m_log_mode == MTR_LOG_NO_REDO", file=0x2191330 "/git/mysql-5.7.13_dbg/storage/innobase/mtr/mtr0mtr.cc", line=574) at /git/mysql-5.7.13_dbg/storage/innobase/ut/ut0dbg.cc:67
#7  0x0000000001a04982 in mtr_t::commit (this=0x7f584b340b30) at /git/mysql-5.7.13_dbg/storage/innobase/mtr/mtr0mtr.cc:573
#8  0x0000000001b60173 in trx_sys_file_format_max_write (format_id=0, name=0x2c55ea0 <innobase_file_format_max>) at /git/mysql-5.7.13_dbg/storage/innobase/trx/trx0sys.cc:607
#9  0x0000000001b60751 in trx_sys_file_format_max_set (format_id=0, name=0x2c55ea0 <innobase_file_format_max>) at /git/mysql-5.7.13_dbg/storage/innobase/trx/trx0sys.cc:737
#10 0x0000000001962042 in innodb_file_format_max_update (thd=0x7f5827e16000, var=0x2b71140 <mysql_sysvar_file_format_max>, var_ptr=0x2c55ea0 <innobase_file_format_max>, save=0x7f5827e54ce0) at /git/mysql-5.7.13_dbg/storage/innobase/handler/ha_innodb.cc:17352
#11 0x000000000151e081 in sys_var_pluginvar::global_update (this=0x7f58475bc520, thd=0x7f5827e16000, var=0x7f5827e54cc0) at /git/mysql-5.7.13_dbg/sql/sql_plugin.cc:3500
#12 0x0000000001426f26 in sys_var::update (this=0x7f58475bc520, thd=0x7f5827e16000, var=0x7f5827e54cc0) at /git/mysql-5.7.13_dbg/sql/set_var.cc:183
#13 0x00000000014285a0 in set_var::update (this=0x7f5827e54cc0, thd=0x7f5827e16000) at /git/mysql-5.7.13_dbg/sql/set_var.cc:802
#14 0x0000000001427ec3 in sql_set_variables (thd=0x7f5827e16000, var_list=0x7f5827e186d0) at /git/mysql-5.7.13_dbg/sql/set_var.cc:662
#15 0x00000000014ed533 in mysql_execute_command (thd=0x7f5827e16000, first_level=true) at /git/mysql-5.7.13_dbg/sql/sql_parse.cc:3631
#16 0x00000000014f2743 in mysql_parse (thd=0x7f5827e16000, parser_state=0x7f584b342560) at /git/mysql-5.7.13_dbg/sql/sql_parse.cc:5525
#17 0x00000000014e7fdb in dispatch_command (thd=0x7f5827e16000, com_data=0x7f584b342cb0, command=COM_QUERY) at /git/mysql-5.7.13_dbg/sql/sql_parse.cc:1429
#18 0x00000000014e6ea5 in do_command (thd=0x7f5827e16000) at /git/mysql-5.7.13_dbg/sql/sql_parse.cc:997
#19 0x0000000001614344 in handle_connection (arg=0x7f5830135140) at /git/mysql-5.7.13_dbg/sql/conn_handler/connection_handler_per_thread.cc:301
#20 0x0000000001844e24 in pfs_spawn_thread (arg=0x7f5830479120) at /git/mysql-5.7.13_dbg/storage/perfschema/pfs.cc:2188
#21 0x00007f584ad2ddc5 in start_thread (arg=0x7f584b343700) at pthread_create.c:308
#22 0x00007f584918c21d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:113

How to repeat:
# mysqld options required for replay: --innodb-read-only=1
set global innodb_file_format_max=antelope;
[29 Jun 2016 7:53] Roel Van de Paar
Hum. Another duplicate of http://bugs.mysql.com/bug.php?id=78333

Can this bug be fixed please?
[29 Jun 2016 7:54] Roel Van de Paar
Marking as dup