Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-15782

Assertion `0' or unknown error on slave upon inserting into sequence

    XMLWordPrintable

    Details

      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

            Activity

              People

              Assignee:
              Elkin Andrei Elkin
              Reporter:
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: