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

rpl.rpl_row_index_choice fails with higher binlog-row-event-max-size

    XMLWordPrintable

Details

    • Bug
    • Status: Confirmed (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.1.20, 5.5(EOL), 10.0(EOL), 10.1(EOL), 10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5, 10.6, 10.7(EOL)
    • 10.5, 10.6
    • Replication, Tests
    • 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

          Activity

            People

              Elkin Andrei Elkin
              nirbhay_c Nirbhay Choubey (Inactive)
              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.