Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.5, 10.6, 10.1.20, 5.5(EOL), 10.0(EOL), 10.1(EOL), 10.2(EOL), 10.3(EOL), 10.4(EOL), 10.7(EOL)
-
None
Description
Logging: mtr rpl.rpl_row_index_choice --mysqld=--binlog-row-event-max-size=8K
|
...
|
rpl.rpl_row_index_choice 'innodb_plugin,row' [ fail ]
|
Test ended at 2016-12-24 10:48:07
|
|
CURRENT_TEST: rpl.rpl_row_index_choice
|
mysqltest: At line 134: failed in 'select master_pos_wait('master-bin.000001', 82051, 300, '')': 2013: Lost connection to MySQL server during query
|
|
The result from queries just before the failure was:
|
< snip >
|
KEY wrong_key6(c)) ENGINE=myisam;
|
INSERT INTO t2 SELECT d DIV 10, d MOD 41, d MOD 37, d FROM t1;
|
# Slave will crash if using the wrong or no index
|
SET GLOBAL debug_dbug="+d,slave_crash_if_wrong_index,slave_crash_if_table_scan";
|
UPDATE t2 SET d=10042 WHERE d=42;
|
DELETE FROM t2 WHERE d=53;
|
SET GLOBAL debug_dbug="";
|
SELECT * FROM t2 WHERE d IN (10042,53);
|
a b c d
|
4 1 5 10042
|
DROP TABLE t2;
|
CREATE TABLE t2 (a INT NOT NULL, b INT NOT NULL, c INT NOT NULL, d INT NOT NULL,
|
KEY expected_key(b),
|
KEY wrong_key7(d),
|
KEY wrong_key8(c)) ENGINE=myisam;
|
INSERT INTO t2 SELECT d DIV 10, d MOD 41, d MOD 37, d FROM t1;
|
# Slave will crash if using the wrong or no index
|
SET GLOBAL debug_dbug="+d,slave_crash_if_wrong_index,slave_crash_if_table_scan";
|
UPDATE t2 SET d=10042 WHERE d=42;
|
DELETE FROM t2 WHERE d=53;
|
|
|
2016-12-24 10:48:04 139819621255936 [Note] Slave SQL thread initialized, starting replication in log 'master-bin.000001' at position 4, relay log './slave-relay-bin.000001' position: 4
|
161224 10:48:05 [ERROR] mysqld got signal 6 ;
|
|
Thread 1 (Thread 0x7f2a4adb8b00 (LWP 3341)):
|
#0 __pthread_kill (threadid=<optimized out>, signo=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:62
|
#1 0x000055844b41eacd in my_write_core (sig=6) at /home/nirbhay/project/git-repo/mariadb/10.1/mysys/stacktrace.c:477
|
#2 0x000055844adb7f67 in handle_fatal_signal (sig=6) at /home/nirbhay/project/git-repo/mariadb/10.1/sql/signal_handler.cc:296
|
#3 <signal handler called>
|
#4 0x00007f2a4b005428 in __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:54
|
#5 0x00007f2a4b00702a in __GI_abort () at abort.c:89
|
#6 0x000055844aec3d8f in Rows_log_event::find_row (this=0x7f2a384943f0, rgi=0x7f2a425f0000) at /home/nirbhay/project/git-repo/mariadb/10.1/sql/log_event.cc:12110
|
#7 0x000055844aec4d9b in Update_rows_log_event::do_exec_row (this=0x7f2a384943f0, rgi=0x7f2a425f0000) at /home/nirbhay/project/git-repo/mariadb/10.1/sql/log_event.cc:12545
|
#8 0x000055844aebf152 in Rows_log_event::do_apply_event (this=0x7f2a384943f0, rgi=0x7f2a425f0000) at /home/nirbhay/project/git-repo/mariadb/10.1/sql/log_event.cc:10063
|
#9 0x000055844aae92e3 in Log_event::apply_event (this=0x7f2a384943f0, rgi=0x7f2a425f0000) at /home/nirbhay/project/git-repo/mariadb/10.1/sql/log_event.h:1343
|
#10 0x000055844aaded93 in apply_event_and_update_pos_apply (ev=0x7f2a384943f0, thd=0x7f2a384e4070, rgi=0x7f2a425f0000, reason=0) at /home/nirbhay/project/git-repo/mariadb/10.1/sql/slave.cc:3469
|
#11 0x000055844aadf230 in apply_event_and_update_pos (ev=0x7f2a384943f0, thd=0x7f2a384e4070, rgi=0x7f2a425f0000) at /home/nirbhay/project/git-repo/mariadb/10.1/sql/slave.cc:3590
|
#12 0x000055844aadfa16 in exec_relay_log_event (thd=0x7f2a384e4070, rli=0x7f2a3eeedc20, serial_rgi=0x7f2a425f0000) at /home/nirbhay/project/git-repo/mariadb/10.1/sql/slave.cc:3872
|
#13 0x000055844aae2bff in handle_slave_sql (arg=0x7f2a3eeec000) at /home/nirbhay/project/git-repo/mariadb/10.1/sql/slave.cc:4958
|
#14 0x000055844af95738 in pfs_spawn_thread (arg=0x7f2a3ee878f0) at /home/nirbhay/project/git-repo/mariadb/10.1/storage/perfschema/pfs.cc:1860
|
#15 0x00007f2a4ba2b70a in start_thread (arg=0x7f2a4adb8b00) at pthread_create.c:333
|
#16 0x00007f2a4b0d682d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109
|
Attachments
Issue Links
- relates to
-
MDEV-18745 DDL Algorithm <> Copy could break row based replication
- Confirmed
-
MDEV-7635 update defaults and simplify mysqld config parameters
- Closed