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

Assertion `!error || !ot_ctx.can_recover_from_failed_open()' failed in open_purge_table upon concurrent ALTER and FLUSH

    XMLWordPrintable

Details

    Description

      Note: Run with --repeat=N --mem. N can vary a lot, there are periods when it fails for me every time within 5 attempts, and sometimes it takes over 100. Luckily the test is very fast when in runs in shm, so set a really big number for starters.

      --source include/have_innodb.inc
       
      CREATE TABLE t1 ( 
        pk SERIAL,
        c VARCHAR(128),
        d DATE,
        vd DATE AS (d) VIRTUAL,
        PRIMARY KEY(pk),
        KEY(vd,c)
      ) ENGINE=InnoDB;
      INSERT IGNORE INTO t1 (pk,c) VALUES (1,'foo');
       
      --connect (con1,localhost,root,,test)
      REPLACE INTO t1 (pk,c) VALUES (1,'bar');
       
      --connection default
      --send
        ALTER TABLE t1 ADD FULLTEXT KEY(c), ALGORITHM=COPY;
      --connection con1
      FLUSH TABLES;
       
      # Cleanup
      --disconnect con1
      --connection default
      --reap
      DROP TABLE t1;
      

      10.3 8716bb3b72b

      mysqld: /data/src/10.3/sql/sql_class.cc:4672: TABLE* open_purge_table(THD*, const char*, size_t, const char*, size_t): Assertion `!error || !ot_ctx.can_recover_from_failed_open()' failed.
      180818  1:17:07 [ERROR] mysqld got signal 6 ;
       
      #7  0x00007f5a635fdee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
      #8  0x00005602b08e90ab in open_purge_table (thd=0x7f5a28000b00, db=0x7f5a48ff70a0 "test", dblen=4, tb=0x7f5a48ff7240 "t1", tblen=2) at /data/src/10.3/sql/sql_class.cc:4672
      #9  0x00005602b0f6f72b in innodb_acquire_mdl (thd=0x7f5a28000b00, table=0x7f5a0c1502f8) at /data/src/10.3/storage/innobase/handler/ha_innodb.cc:20738
      #10 0x00005602b0f6f926 in innodb_find_table_for_vc (thd=0x7f5a28000b00, table=0x7f5a0c1502f8) at /data/src/10.3/storage/innobase/handler/ha_innodb.cc:20793
      #11 0x00005602b0f6fe99 in innobase_allocate_row_for_vcol (thd=0x7f5a28000b00, index=0x7f5a0c196e88, heap=0x7f5a48ff7670, table=0x7f5a48ff7680, record=0x7f5a48ff7688, storage=0x7f5a48ff7678) at /data/src/10.3/storage/innobase/handler/ha_innodb.cc:20947
      #12 0x00005602b111b01e in row_vers_build_clust_v_col (row=0x7f5a28014108, clust_index=0x7f5a0c133158, index=0x7f5a0c196e88, heap=0x7f5a28014030, vcol_info=0x5602b4adfd08) at /data/src/10.3/storage/innobase/row/row0vers.cc:465
      #13 0x00005602b111c1b0 in row_vers_old_has_index_entry (also_curr=true, rec=0x7f5a5d3fc07f "", mtr=0x7f5a48ff7ab0, index=0x7f5a0c196e88, ientry=0x7f5a28014698, roll_ptr=16888498624468088, trx_id=0, vcol_info=0x5602b4adfd08) at /data/src/10.3/storage/innobase/row/row0vers.cc:959
      #14 0x00005602b10d09f8 in row_purge_poss_sec (node=0x5602b4adfb68, index=0x7f5a0c196e88, entry=0x7f5a28014698, sec_pcur=0x7f5a48ff8050, sec_mtr=0x7f5a48ff82b0, is_tree=false) at /data/src/10.3/storage/innobase/row/row0purge.cc:346
      #15 0x00005602b10d16cb in row_purge_remove_sec_if_poss_leaf (node=0x5602b4adfb68, index=0x7f5a0c196e88, entry=0x7f5a28014698) at /data/src/10.3/storage/innobase/row/row0purge.cc:597
      #16 0x00005602b10d1bb3 in row_purge_remove_sec_if_poss (node=0x5602b4adfb68, index=0x7f5a0c196e88, entry=0x7f5a28014698) at /data/src/10.3/storage/innobase/row/row0purge.cc:710
      #17 0x00005602b10d1dc0 in row_purge_del_mark (node=0x5602b4adfb68) at /data/src/10.3/storage/innobase/row/row0purge.cc:784
      #18 0x00005602b10d32d9 in row_purge_record_func (node=0x5602b4adfb68, undo_rec=0x5602b4ae0118 "", thr=0x5602b4adf998, updated_extern=false) at /data/src/10.3/storage/innobase/row/row0purge.cc:1178
      #19 0x00005602b10d3616 in row_purge (node=0x5602b4adfb68, undo_rec=0x5602b4ae0118 "", thr=0x5602b4adf998) at /data/src/10.3/storage/innobase/row/row0purge.cc:1245
      #20 0x00005602b10d39c4 in row_purge_step (thr=0x5602b4adf998) at /data/src/10.3/storage/innobase/row/row0purge.cc:1331
      #21 0x00005602b1057484 in que_thr_step (thr=0x5602b4adf998) at /data/src/10.3/storage/innobase/que/que0que.cc:1046
      #22 0x00005602b10576b7 in que_run_threads_low (thr=0x5602b4adf998) at /data/src/10.3/storage/innobase/que/que0que.cc:1108
      #23 0x00005602b10578a8 in que_run_threads (thr=0x5602b4adf998) at /data/src/10.3/storage/innobase/que/que0que.cc:1148
      #24 0x00005602b11248fb in srv_task_execute () at /data/src/10.3/storage/innobase/srv/srv0srv.cc:2437
      #25 0x00005602b1124aa0 in srv_worker_thread (arg=0x0) at /data/src/10.3/storage/innobase/srv/srv0srv.cc:2485
      #26 0x00007f5a652d4494 in start_thread (arg=0x7f5a48ff9700) at pthread_create.c:333
      #27 0x00007f5a636ba93f in clone () from /lib/x86_64-linux-gnu/libc.so.6
      

      Note: The provided test case does not fail on 10.2 for me (still fails on 10.3), however the assertion failure has been observed on 10.2 as well, so I'm adding it to the list of affected/to-be-fixed versions.

      Example of 10.2 failure, ab1ce2204e959bea596817494e932754ab5cbe88

      Version: '10.2.19-MariaDB-debug-log'  socket: '/home/travis/logs/vardir/mysql.sock'  port: 19300  Source distribution
      mysqld: /home/travis/src/sql/sql_class.cc:4404: TABLE* open_purge_table(THD*, const char*, size_t, const char*, size_t): Assertion `!error || !ot_ctx.can_recover_from_failed_open()' failed.
      181020  9:19:58 [ERROR] mysqld got signal 6 ;
       
      #3  0x00007f98a6eaeca2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
      #4  0x000056466a9f376c in open_purge_table (thd=0x7f98a0002260, db=0x7f98860e34e0 "test", dblen=4, tb=0x7f98860e3680 "t5", tblen=2) at /home/travis/src/sql/sql_class.cc:4404
      #5  0x000056466aedd338 in innodb_acquire_mdl (thd=0x7f98a0002260, table=0x7f98a05809b8) at /home/travis/src/storage/innobase/handler/ha_innodb.cc:21417
      #6  0x000056466aedd53b in innodb_find_table_for_vc (thd=0x7f98a0002260, table=0x7f98a05809b8) at /home/travis/src/storage/innobase/handler/ha_innodb.cc:21472
      #7  0x000056466aeddac3 in innobase_allocate_row_for_vcol (thd=0x7f98a0002260, index=0x7f98a0208ac8, heap=0x7f98860e3af0, table=0x7f98860e3b00, record=0x7f98860e3b08, storage=0x7f98860e3af8) at /home/travis/src/storage/innobase/handler/ha_innodb.cc:21627
      #8  0x000056466b06235f in row_vers_build_clust_v_col (row=0x7f98a0080e00, clust_index=0x7f98a009e898, index=0x7f98a0208ac8, heap=0x7f98a0080c80, vcol_info=0x56466d18b820) at /home/travis/src/storage/innobase/row/row0vers.cc:470
      #9  0x000056466b063431 in row_vers_old_has_index_entry (also_curr=true, rec=0x7f989436f2c1 ' ' <repeats 49 times>, mtr=0x7f98860e3f60, index=0x7f98a0208ac8, ientry=0x7f98a0724af8, roll_ptr=9851624223149860, trx_id=10079, vcol_info=0x56466d18b820) at /home/travis/src/storage/innobase/row/row0vers.cc:966
      #10 0x000056466b01d7ee in row_purge_poss_sec (node=0x56466d18b680, index=0x7f98a0208ac8, entry=0x7f98a0724af8, sec_pcur=0x7f98860e4510, sec_mtr=0x7f98860e4770, is_tree=false) at /home/travis/src/storage/innobase/row/row0purge.cc:346
      #11 0x000056466b01e42a in row_purge_remove_sec_if_poss_leaf (node=0x56466d18b680, index=0x7f98a0208ac8, entry=0x7f98a0724af8) at /home/travis/src/storage/innobase/row/row0purge.cc:604
      #12 0x000056466b01e90a in row_purge_remove_sec_if_poss (node=0x56466d18b680, index=0x7f98a0208ac8, entry=0x7f98a0724af8) at /home/travis/src/storage/innobase/row/row0purge.cc:717
      #13 0x000056466b01eb11 in row_purge_del_mark (node=0x56466d18b680) at /home/travis/src/storage/innobase/row/row0purge.cc:791
      #14 0x000056466b01f763 in row_purge_record_func (node=0x56466d18b680, undo_rec=0x56466d91ce50 "", thr=0x56466d18b5c8, updated_extern=false) at /home/travis/src/storage/innobase/row/row0purge.cc:1102
      #15 0x000056466b01f9df in row_purge (node=0x56466d18b680, undo_rec=0x56466d91ce50 "", thr=0x56466d18b5c8) at /home/travis/src/storage/innobase/row/row0purge.cc:1163
      #16 0x000056466b01fd1b in row_purge_step (thr=0x56466d18b5c8) at /home/travis/src/storage/innobase/row/row0purge.cc:1249
      #17 0x000056466afb0468 in que_thr_step (thr=0x56466d18b5c8) at /home/travis/src/storage/innobase/que/que0que.cc:1049
      #18 0x000056466afb0663 in que_run_threads_low (thr=0x56466d18b5c8) at /home/travis/src/storage/innobase/que/que0que.cc:1111
      #19 0x000056466afb080d in que_run_threads (thr=0x56466d18b5c8) at /home/travis/src/storage/innobase/que/que0que.cc:1151
      #20 0x000056466b06b608 in srv_task_execute () at /home/travis/src/storage/innobase/srv/srv0srv.cc:2538
      #21 0x000056466b06b756 in srv_worker_thread (arg=0x0) at /home/travis/src/storage/innobase/srv/srv0srv.cc:2585
      #22 0x00007f98a7a70184 in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
      #23 0x00007f98a6f7cffd in clone () from /lib/x86_64-linux-gnu/libc.so.6
      

      Attachments

        Issue Links

          Activity

            People

              nikitamalyavin Nikita Malyavin
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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