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

Assertion `0' fails with different table on master and slave (MySQL:53386)

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Minor
    • Resolution: Unresolved
    • 5.1.67, 5.2.14, 5.3.12, 5.5.35, 10.0.8
    • 5.5
    • None
    • None

    Description

      There was MySQL bug http://bugs.mysql.com/bug.php?id=53386 which was fixed long time ago in the tree that later became 5.6.

      -- source include/have_binlog_format_row.inc
      -- source include/master-slave.inc
       
      --connection master
       
      SET SQL_LOG_BIN=0;
      CREATE TABLE t1 (a INT, b CHAR(255) CHARACTER SET UTF8) ENGINE=MyISAM;
      SET SQL_LOG_BIN=1;
       
      -- connection slave
      CREATE TABLE t1 (c INT) ENGINE=MyISAM;
       
      --connection master
      INSERT INTO t1 VALUES (1, 'x');
       
      -- sync_slave_with_master

      140212 13:58:24 [ERROR] Slave SQL: Could not read field 'c' of table 'test.t1', Error_code: 1610
      mysqld: 5.5/sql/log_event.cc:10124: virtual int Write_rows_log_event::do_exec_row(const Relay_log_info*): Assertion `0' failed.
      140212 13:58:24 [ERROR] mysqld got signal 6 ;

      #6  0x00007fc0d2a7c621 in *__GI___assert_fail (assertion=0xe35ef0 "0", file=<optimized out>, line=10124, function=0xe3ab80 "virtual int Write_rows_log_event::do_exec_row(const Relay_log_info*)") at assert.c:81
      #7  0x00000000008d0816 in Write_rows_log_event::do_exec_row (this=0x7fc0d205f6a0, rli=0x7fc0cd3e6850) at 5.5/sql/log_event.cc:10124
      #8  0x00000000008ccccb in Rows_log_event::do_apply_event (this=0x7fc0d205f6a0, rli=0x7fc0cd3e6850) at 5.5/sql/log_event.cc:8528
      #9  0x00000000005ada2c in Log_event::apply_event (this=0x7fc0d205f6a0, rli=0x7fc0cd3e6850) at 5.5/sql/log_event.h:1256
      #10 0x00000000005a57ae in apply_event_and_update_pos (ev=0x7fc0d205f6a0, thd=0x7fc0cd2b5060, rli=0x7fc0cd3e6850) at 5.5/sql/slave.cc:2637
      #11 0x00000000005a5d43 in exec_relay_log_event (thd=0x7fc0cd2b5060, rli=0x7fc0cd3e6850) at 5.5/sql/slave.cc:2797
      #12 0x00000000005a8191 in handle_slave_sql (arg=0x7fc0cd3e5060) at 5.5/sql/slave.cc:3654
      #13 0x0000000000985a9d in pfs_spawn_thread (arg=0x7fc0c3133440) at 5.5/storage/perfschema/pfs.cc:1015
      #14 0x00007fc0d3fdcb50 in start_thread (arg=<optimized out>) at pthread_create.c:304
      #15 0x00007fc0d2b2ba7d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112

      Attachments

        Activity

          People

            Unassigned Unassigned
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.