Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
10.3(EOL)
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
|
Attachments
Issue Links
- duplicates
-
MDEV-15106 Unexpected ER_WRONG_INSERT_INTO_SEQUENCE upon INSERT with multiple locks on sequences
- Closed