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

Assertion `!index->table->is_temporary()' failed in trx_undo_prev_version_build upon CHECK

    XMLWordPrintable

    Details

      Description

      --source include/have_innodb.inc
       
      CREATE TEMPORARY TABLE t (a INT, KEY(a)) ENGINE=InnoDB;
      INSERT INTO t VALUES (1);
      ALTER TABLE t FORCE;
      UPDATE t SET a = 8;
      CHECK TABLE t EXTENDED;
       
      # Cleanup
      DROP TABLE t;
      

      10.6 b7fe6179

      mariadbd: /home/jenkins/workspace/sandbox-elenst/Nightly-Build-CS/src/storage/innobase/trx/trx0rec.cc:2164: dberr_t trx_undo_prev_version_build(const rec_t*, dict_index_t*, rec_offs*, mem_heap_t*, rec_t**, mem_heap_t*, dtuple_t**, ulint): Assertion `!index->table->is_temporary()' failed.
      221026 14:26:01 [ERROR] mysqld got signal 6 ;
       
      #7  0x00007ff20a715662 in __GI___assert_fail (assertion=0x55c263dc3f20 "!index->table->is_temporary()", file=0x55c263dc4f00 "/home/jenkins/workspace/sandbox-elenst/Nightly-Build-CS/src/storage/innobase/trx/trx0rec.cc", line=2164, function=0x55c263dc7aa0 "dberr_t trx_undo_prev_version_build(const rec_t*, dict_index_t*, rec_offs*, mem_heap_t*, rec_t**, mem_heap_t*, dtuple_t**, ulint)") at assert.c:101
      #8  0x000055c2628f1af7 in trx_undo_prev_version_build (rec=0x7ff2006b807e "", index=0x6160009c0d20, offsets=0x611000069220, heap=0x61a00005a098, old_vers=0x7ff1f71f96a0, v_heap=0x0, vrow=0x0, v_status=0) at /home/jenkins/workspace/sandbox-elenst/Nightly-Build-CS/src/storage/innobase/trx/trx0rec.cc:2164
      #9  0x000055c262852c29 in row_check_index (prebuilt=0x620000014120, n_rows=0x7ff1f71fa670) at /home/jenkins/workspace/sandbox-elenst/Nightly-Build-CS/src/storage/innobase/row/row0sel.cc:6591
      #10 0x000055c2624567d6 in ha_innobase::check (this=0x61d0002846b8, thd=0x62b0000bd218, check_opt=0x62b0000c2848) at /home/jenkins/workspace/sandbox-elenst/Nightly-Build-CS/src/storage/innobase/handler/ha_innodb.cc:15311
      #11 0x000055c261a3b33b in handler::ha_check (this=0x61d0002846b8, thd=0x62b0000bd218, check_opt=0x62b0000c2848) at /home/jenkins/workspace/sandbox-elenst/Nightly-Build-CS/src/sql/handler.cc:4949
      #12 0x000055c261653dd6 in mysql_admin_table (thd=0x62b0000bd218, tables=0x62b0000c4320, check_opt=0x62b0000c2848, operator_name=0x55c2644f0580 <msg_check>, lock_type=TL_READ_NO_INSERT, org_open_for_modify=false, repair_table_use_frm=false, extra_open_options=32, prepare_func=0x0, operator_func=(int (handler::*)(handler * const, THD *, HA_CHECK_OPT *)) 0x55c261a3aeb6 <handler::ha_check(THD*, st_ha_check_opt*)>, view_operator_func=0x55c2615158b9 <view_check(THD*, TABLE_LIST*, st_ha_check_opt*)>, is_cmd_replicated=false) at /home/jenkins/workspace/sandbox-elenst/Nightly-Build-CS/src/sql/sql_admin.cc:875
      #13 0x000055c2616590de in Sql_cmd_check_table::execute (this=0x62b0000c4a40, thd=0x62b0000bd218) at /home/jenkins/workspace/sandbox-elenst/Nightly-Build-CS/src/sql/sql_admin.cc:1486
      #14 0x000055c2611e22ae in mysql_execute_command (thd=0x62b0000bd218, is_called_from_prepared_stmt=false) at /home/jenkins/workspace/sandbox-elenst/Nightly-Build-CS/src/sql/sql_parse.cc:5997
      #15 0x000055c2611ef430 in mysql_parse (thd=0x62b0000bd218, rawbuf=0x62b0000c4238 "CHECK TABLE t EXTENDED", length=22, parser_state=0x7ff1f71fc990) at /home/jenkins/workspace/sandbox-elenst/Nightly-Build-CS/src/sql/sql_parse.cc:8016
      #16 0x000055c2611c5d86 in dispatch_command (command=COM_QUERY, thd=0x62b0000bd218, packet=0x62900028a219 "", packet_length=22, blocking=true) at /home/jenkins/workspace/sandbox-elenst/Nightly-Build-CS/src/sql/sql_parse.cc:1896
      #17 0x000055c2611c2b4d in do_command (thd=0x62b0000bd218, blocking=true) at /home/jenkins/workspace/sandbox-elenst/Nightly-Build-CS/src/sql/sql_parse.cc:1409
      #18 0x000055c26161afbc in do_handle_one_connection (connect=0x608000003338, put_in_cache=true) at /home/jenkins/workspace/sandbox-elenst/Nightly-Build-CS/src/sql/sql_connect.cc:1416
      #19 0x000055c26161a952 in handle_one_connection (arg=0x6080000032b8) at /home/jenkins/workspace/sandbox-elenst/Nightly-Build-CS/src/sql/sql_connect.cc:1318
      #20 0x000055c2622409ac in pfs_spawn_thread (arg=0x617000007418) at /home/jenkins/workspace/sandbox-elenst/Nightly-Build-CS/src/storage/perfschema/pfs.cc:2201
      #21 0x00007ff20abf3ea7 in start_thread (arg=<optimized out>) at pthread_create.c:477
      #22 0x00007ff20a7e0aef in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
      

      The failure started happening on 10.6 after

      commit ab0190101b0587e0e03b2d75a967050b9a85fd1b
      Author: Marko Mäkelä
      Date:   Fri Oct 21 10:02:54 2022 +0300
       
          MDEV-24402: InnoDB CHECK TABLE ... EXTENDED
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              marko Marko Mäkelä
              Reporter:
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              1 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.