Bug #90190 Sig=6 assertion in MYSQL_BIN_LOG::new_file_impl | binlog.cc:6862
Submitted: 23 Mar 2018 8:26 Modified: 23 Mar 2018 16:57
Reporter: Ramesh Sivaraman Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: DML Severity:S3 (Non-critical)
Version:5.7.21/8.0 OS:CentOS
Assigned to: CPU Architecture:Any
Tags: debug

[23 Mar 2018 8:26] Ramesh Sivaraman
Description:
GDB Info
********

+bt
#0  0x00007f8d36c239b1 in pthread_kill () from /lib64/libpthread.so.0
#1  0x000000000183f729 in my_write_core (sig=6) at /sda/qa/mysql57_dbg/mysys/stacktrace.c:249
#2  0x0000000000e80e82 in handle_fatal_signal (sig=6) at /sda/qa/mysql57_dbg/sql/signal_handler.cc:220
#3  <signal handler called>
#4  0x00007f8d34f451f7 in raise () from /lib64/libc.so.6
#5  0x00007f8d34f468e8 in abort () from /lib64/libc.so.6
#6  0x00000000017a0fff in exec_binlog_error_action_abort (err_string=0x2054c30 "Either disk is full or file system is read only while rotating the binlog. Aborting the server.") at /sda/qa/mysql57_dbg/sql/binlog.cc:1858
#7  0x00000000017acd2b in MYSQL_BIN_LOG::new_file_impl (this=0x2b90220 <mysql_bin_log>, need_lock_log=false, extra_description_event=0x0) at /sda/qa/mysql57_dbg/sql/binlog.cc:6862
#8  0x00000000017ac523 in MYSQL_BIN_LOG::new_file_without_locking (this=0x2b90220 <mysql_bin_log>, extra_description_event=0x0) at /sda/qa/mysql57_dbg/sql/binlog.cc:6669
#9  0x00000000017ae1c1 in MYSQL_BIN_LOG::rotate (this=0x2b90220 <mysql_bin_log>, force_rotate=true, check_purge=0x7f8d3721a34b) at /sda/qa/mysql57_dbg/sql/binlog.cc:7318
#10 0x00000000017ae37b in MYSQL_BIN_LOG::rotate_and_purge (this=0x2b90220 <mysql_bin_log>, thd=0x7f8d09419000, force_rotate=true) at /sda/qa/mysql57_dbg/sql/binlog.cc:7384
#11 0x00000000015497e3 in reload_acl_and_cache (thd=0x7f8d09419000, options=16130, tables=0x0, write_to_binlog=0x7f8d3721b08c) at /sda/qa/mysql57_dbg/sql/sql_reload.cc:161
#12 0x000000000150a34d in mysql_execute_command (thd=0x7f8d09419000, first_level=true) at /sda/qa/mysql57_dbg/sql/sql_parse.cc:4170
#13 0x000000000150dd05 in mysql_parse (thd=0x7f8d09419000, parser_state=0x7f8d3721b550) at /sda/qa/mysql57_dbg/sql/sql_parse.cc:5582
#14 0x0000000001503590 in dispatch_command (thd=0x7f8d09419000, com_data=0x7f8d3721bcb0, command=COM_QUERY) at /sda/qa/mysql57_dbg/sql/sql_parse.cc:1458
#15 0x00000000015024c4 in do_command (thd=0x7f8d09419000) at /sda/qa/mysql57_dbg/sql/sql_parse.cc:999
#16 0x0000000001633442 in handle_connection (arg=0x7f8d19ff8b60) at /sda/qa/mysql57_dbg/sql/conn_handler/connection_handler_per_thread.cc:300
#17 0x0000000001cb6b15 in pfs_spawn_thread (arg=0x7f8d1cbcfa20) at /sda/qa/mysql57_dbg/storage/perfschema/pfs.cc:2190
#18 0x00007f8d36c1ee25 in start_thread () from /lib64/libpthread.so.0
#19 0x00007f8d3500834d in clone () from /lib64/libc.so.6

How to repeat:
Startup options
***************
 --plugin-load=keyring_file=keyring_file.so --keyring_file_data=/dev/shm/1521784062/data/keyring --gtid_mode=ON --enforce_gtid_consistency=ON --log_slave_updates=ON --log_bin=binlog --binlog_format=ROW --server-id=101 --master-verify-checksum=1 --binlog-checksum=1

Testcase
********
CREATE DATABASE test;
USE test;
CREATE TABLE t1(c1 NUMERIC,c2 BINARY(1),c3 INT(1),c4 BINARY(1) PRIMARY KEY,c5 NUMERIC UNIQUE KEY,c6 DECIMAL(0,0) DEFAULT 3.141592);
set global innodb_trx_rseg_n_slots_debug=1;
ALTER TABLE t1 DROP PRIMARY KEY;
CREATE TABLE t2(c1 int,c2 int,unique key(c1));
CREATE TABLESPACE ts ADD DATAFILE 'f.ibd' ENGINE InnoDB ENCRYPTION='';
CREATE TABLESPACE tb1 ADD DATAFILE 't1.ibd'ENGINE=InnoDB ENCRYPTION='';
set @@global.binlog_checksum=default;
DROP TABLE t1,t2;
DROP TABLE t1;
SET @@SESSION.sql_log_bin=0;
CREATE TABLE t1(c1 INT,c2 CHAR(1)) PARTITION BY KEY(c1) PARTITIONS 99;
DROP TABLE t1,t2;
reset master;
CREATE TABLE t1(c1 CHAR (1));
SET GLOBAL EVENT_SCHEDULER=on;
CREATE TABLE t10(c1 INT,c2 char(1))ENGINE=InnoDB;
FLUSH LOGS;
SET GLOBAL event_scheduler='OFF';
[23 Mar 2018 16:57] MySQL Verification Team
Thank you for the bug report.