[MDEV-15782] Assertion `0' or unknown error on slave upon inserting into sequence Created: 2018-04-04  Updated: 2018-05-18  Resolved: 2018-05-18

Status: Closed
Project: MariaDB Server
Component/s: Replication, Sequences
Affects Version/s: 10.3
Fix Version/s: 10.3.7

Type: Bug Priority: Critical
Reporter: Elena Stepanova Assignee: Andrei Elkin
Resolution: Fixed Votes: 0
Labels: 10.3-ga

Issue Links:
Duplicate
duplicates MDEV-15106 Unexpected ER_WRONG_INSERT_INTO_SEQUE... Closed

 Description   

--source include/have_innodb.inc
--source include/have_binlog_format_mixed_or_row.inc
--source include/master-slave.inc
 
CREATE TABLE t1 (a INT) ENGINE=InnoDB;
CREATE TABLE t2 (b INT) ENGINE=MyISAM;
CREATE TABLE t3 (c INT) ENGINE=InnoDB;
CREATE SEQUENCE seq;
CREATE TRIGGER tr BEFORE INSERT ON t1 FOR EACH ROW UPDATE t2 SET b = 9;
 
BEGIN;
INSERT INTO t1 VALUES (1);
INSERT INTO t3 VALUES (1);
REPLACE INTO seq VALUES (1,1,9223372036854775806,1,1,1000,0,0);
COMMIT;
 
--sync_slave_with_master
 
# Cleanup
--connection master
DROP SEQUENCE seq;
DROP TABLE t1, t2, t3;
--source include/rpl_end.inc

10.3 debug 69efa1343a0a

#7  0x00007fd820bebee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
#8  0x0000559826191847 in Write_rows_log_event::do_exec_row (this=0x7fd7c0020230, rgi=0x7fd7c0000a90) at /data/src/10.3/sql/log_event.cc:13267
#9  0x000055982618ca71 in Rows_log_event::do_apply_event (this=0x7fd7c0020230, rgi=0x7fd7c0000a90) at /data/src/10.3/sql/log_event.cc:11400
#10 0x0000559825c882a7 in Log_event::apply_event (this=0x7fd7c0020230, rgi=0x7fd7c0000a90) at /data/src/10.3/sql/log_event.h:1481
#11 0x0000559825c7c652 in apply_event_and_update_pos_apply (ev=0x7fd7c0020230, thd=0x7fd7c0001560, rgi=0x7fd7c0000a90, reason=0) at /data/src/10.3/sql/slave.cc:3883
#12 0x0000559825c7cb1c in apply_event_and_update_pos (ev=0x7fd7c0020230, thd=0x7fd7c0001560, rgi=0x7fd7c0000a90) at /data/src/10.3/sql/slave.cc:4031
#13 0x0000559825c7d288 in exec_relay_log_event (thd=0x7fd7c0001560, rli=0x559829388048, serial_rgi=0x7fd7c0000a90) at /data/src/10.3/sql/slave.cc:4318
#14 0x0000559825c808b6 in handle_slave_sql (arg=0x559829386380) at /data/src/10.3/sql/slave.cc:5477
#15 0x0000559826347c2b in pfs_spawn_thread (arg=0x7fd7c4178880) at /data/src/10.3/storage/perfschema/pfs.cc:1862
#16 0x00007fd8228c2494 in start_thread (arg=0x7fd814388700) at pthread_create.c:333
#17 0x00007fd820ca893f in clone () from /lib/x86_64-linux-gnu/libc.so.6

10.3 non-debug 209375fdd

Last_Error	Could not execute Write_rows_v1 event on table test.seq; Unknown error, Error_code: 1105; handler error No Error!; the event's master log master-bin.000001, end_log_pos 1437



 Comments   
Comment by Andrei Elkin [ 2018-04-24 ]

Changed the status back to in-progress.

Comment by Andrei Elkin [ 2018-05-18 ]

The case duplicates MDEV-15106.

Generated at Thu Feb 08 08:23:59 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.