Bug #78333 handle_fatal_signal (sig=6) in mtr_commit
Submitted: 5 Sep 2015 1:56 Modified: 5 Sep 2015 6:56
Reporter: Roel Van de Paar Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: InnoDB storage engine Severity:S2 (Serious)
Version:5.6.23 OS:Any
Assigned to: CPU Architecture:Any
Tags: opt

[5 Sep 2015 1:56] Roel Van de Paar
Description:
2015-09-05 11:44:18 24746 [Note] /sdc/mysql-5.6.23-linux-x86_64/bin/mysqld: ready for connections.
Version: '5.6.23-debug'  socket: '/sdc/mysql-5.6.23-linux-x86_64/socket.sock'  port: 16901  MySQL Community Server (GPL)
2015-09-05 11:44:25 7f3c958fa700  InnoDB: Assertion failure in thread 139898183984896 in file mtr0mtr.cc line 323
InnoDB: Failing assertion: !srv_read_only_mode

+bt
#0  0x00007f3c952ee771 in __pthread_kill (threadid=<optimized out>, signo=6) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:61
#1  0x0000000000a9804e in my_write_core (sig=6) at /bzr/mysql-5.6.23/mysys/stacktrace.c:422
#2  0x00000000007277f0 in handle_fatal_signal (sig=6) at /bzr/mysql-5.6.23/sql/signal_handler.cc:230
#3  <signal handler called>
#4  0x00007f3c940fa5d7 in __GI_raise (sig=sig@entry=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:56
#5  0x00007f3c940fbcc8 in __GI_abort () at abort.c:90
#6  0x0000000000be8373 in mtr_commit (mtr=0x7f3c958f76b0) at /bzr/mysql-5.6.23/storage/innobase/mtr/mtr0mtr.cc:323
#7  0x0000000000ce06de in trx_sys_file_format_max_write (format_id=1, name=0x181c720 <innobase_file_format_max>) at /bzr/mysql-5.6.23/storage/innobase/trx/trx0sys.cc:646
#8  0x0000000000ce098a in trx_sys_file_format_max_set (format_id=1, name=0x181c720 <innobase_file_format_max>) at /bzr/mysql-5.6.23/storage/innobase/trx/trx0sys.cc:773
#9  0x0000000000b7e301 in innodb_file_format_max_update (thd=0x7f3bed3a5000, var=0x151a720 <mysql_sysvar_file_format_max>, var_ptr=0x181c720 <innobase_file_format_max>, save=0x7f3be50221e0) at /bzr/mysql-5.6.23/storage/innobase/handler/ha_innodb.cc:14191
#10 0x00000000007ead98 in sys_var_pluginvar::global_update (this=0x7f3c7abe8010, thd=0x7f3bed3a5000, var=0x7f3be50221c0) at /bzr/mysql-5.6.23/sql/sql_plugin.cc:3271
#11 0x0000000000725317 in sys_var::update (this=0x7f3c7abe8010, thd=0x7f3bed3a5000, var=0x7f3be50221c0) at /bzr/mysql-5.6.23/sql/set_var.cc:193
#12 0x0000000000726420 in set_var::update (this=0x7f3be50221c0, thd=0x7f3bed3a5000) at /bzr/mysql-5.6.23/sql/set_var.cc:670
#13 0x0000000000725fee in sql_set_variables (thd=0x7f3bed3a5000, var_list=0x7f3bed3a7e10) at /bzr/mysql-5.6.23/sql/set_var.cc:573
#14 0x00000000007d65ae in mysql_execute_command (thd=0x7f3bed3a5000) at /bzr/mysql-5.6.23/sql/sql_parse.cc:3713
#15 0x00000000007dd54a in mysql_parse (thd=0x7f3bed3a5000, rawbuf=0x7f3be5022010 "SET @@global.innodb_file_format_max='Barracuda'", length=47, parser_state=0x7f3c958f8e70) at /bzr/mysql-5.6.23/sql/sql_parse.cc:6357
#16 0x00000000007d06bc in dispatch_command (command=COM_QUERY, thd=0x7f3bed3a5000, packet=0x7f3bed3a0001 "SET @@global.innodb_file_format_max='Barracuda'", packet_length=47) at /bzr/mysql-5.6.23/sql/sql_parse.cc:1332
#17 0x00000000007cf7ab in do_command (thd=0x7f3bed3a5000) at /bzr/mysql-5.6.23/sql/sql_parse.cc:1034
#18 0x0000000000797b3d in do_handle_one_connection (thd_arg=0x7f3bed3a5000) at /bzr/mysql-5.6.23/sql/sql_connect.cc:982
#19 0x0000000000797626 in handle_one_connection (arg=0x7f3bed3a5000) at /bzr/mysql-5.6.23/sql/sql_connect.cc:898
#20 0x0000000000ae6600 in pfs_spawn_thread (arg=0x7f3c937fb1a0) at /bzr/mysql-5.6.23/storage/perfschema/pfs.cc:1860
#21 0x00007f3c952e9df5 in start_thread (arg=0x7f3c958fa700) at pthread_create.c:308
#22 0x00007f3c941bb1ad in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:113

How to repeat:
# mysqld options required for replay: --innodb-read-only=1
DROP DATABASE test;CREATE DATABASE test;USE test;
SET @@global.innodb_file_format_max='Barracuda';
[5 Sep 2015 2:11] Roel Van de Paar
Similar to bug 77972
[5 Sep 2015 6:55] MySQL Verification Team
It's a duplicate of https://bugs.mysql.com/bug.php?id=77972

5.6 : InnoDB: Failing assertion: !srv_read_only_mode
5.7 : InnoDB: Failing assertion: !srv_read_only_mode || m_impl.m_log_mode == MTR_LOG_NO_REDO
5.8 : option is gone
mysql> SET @@global.innodb_file_format_max='Barracuda';
ERROR 1193 (HY000): Unknown system variable 'innodb_file_format_max'