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

InnoDB: Failing assertion: thr_get_trx(thr)->error_state == DB_SUCCESS

    XMLWordPrintable

    Details

      Description

      Note: The failure is not easy to reproduce on vanilla tree, because the test case mostly fails with MDEV-19501. You might have to use some wrapper to MTR which would run the test repeatedly, but would only allow it to abort when it hits the "right" assertion. Alternatively, it can be run on a modified tree where the assertion from MDEV-19501 is disabled. But then, the suggestion could be that the failure described here is an aftermath of MDEV-19501, while in fact it sometimes happens before (or possibly concurrently with) MDEV-19501.

      --source include/have_innodb.inc
       
      SET @fulltext_only.save= @@innodb_optimize_fulltext_only;
      SET GLOBAL innodb_optimize_fulltext_only = 1;
       
      CREATE TABLE t1 (f TEXT, FULLTEXT KEY (f)) ENGINE=InnoDB;
      INSERT IGNORE INTO t1 SELECT description FROM mysql.help_topic;
      DELETE FROM t1 LIMIT 3 ;
       
      --connect (con1,localhost,root,,test)
      --send
          OPTIMIZE TABLE t1;
      --connection default
      OPTIMIZE TABLE t1;
       
      # Cleanup
      --connection con1
      --reap
      --disconnect con1
      --connection default
      DROP TABLE t1;
      SET GLOBAL innodb_optimize_fulltext_only = @fulltext_only.save;
      

      10.2 d30e51fa

      2019-11-23 19:49:59 0x7f263c2bc700  InnoDB: Assertion failure in file /data/src/10.2-bug/storage/innobase/que/que0que.cc line 1140
      InnoDB: Failing assertion: thr_get_trx(thr)->error_state == DB_SUCCESS
       
      #6  0x00005624763858b8 in ut_dbg_assertion_failed (expr=0x5624768e4330 "thr_get_trx(thr)->error_state == DB_SUCCESS", file=0x5624768e3fd8 "/data/src/10.2-bug/storage/innobase/que/que0que.cc", line=1140) at /data/src/10.2-bug/storage/innobase/ut/ut0dbg.cc:60
      #7  0x000056247626951d in que_run_threads (thr=0x7f25e8242280) at /data/src/10.2-bug/storage/innobase/que/que0que.cc:1140
      #8  0x00005624764c4081 in fts_eval_sql (trx=0x7f263c6204b8, graph=0x7f25e82421a8) at /data/src/10.2-bug/storage/innobase/fts/fts0sql.cc:219
      #9  0x00005624764b2260 in fts_config_set_value (trx=0x7f263c6204b8, fts_table=0x7f263c2b96f0, name=0x7f25e8240d10 "last_optimized_word_", '0' <repeats 14 times>, "1c", value=0x7f25e823c408) at /data/src/10.2-bug/storage/innobase/fts/fts0config.cc:259
      #10 0x00005624764b2311 in fts_config_set_index_value (trx=0x7f263c6204b8, index=0x7f25e81865f8, param=0x5624769c1f11 "last_optimized_word", value=0x7f25e823c408) at /data/src/10.2-bug/storage/innobase/fts/fts0config.cc:290
      #11 0x00005624764b6705 in fts_optimize_compact (optim=0x7f25e8049c78, index=0x7f25e81865f8, start_time=1574531344) at /data/src/10.2-bug/storage/innobase/fts/fts0opt.cc:1558
      #12 0x00005624764b6c7c in fts_optimize_words (optim=0x7f25e8049c78, index=0x7f25e81865f8, word=0x7f263c2b99d0) at /data/src/10.2-bug/storage/innobase/fts/fts0opt.cc:1806
      #13 0x00005624764b7406 in fts_optimize_index (optim=0x7f25e8049c78, index=0x7f25e81865f8) at /data/src/10.2-bug/storage/innobase/fts/fts0opt.cc:1991
      #14 0x00005624764b7d86 in fts_optimize_indexes (optim=0x7f25e8049c78) at /data/src/10.2-bug/storage/innobase/fts/fts0opt.cc:2295
      #15 0x00005624764b811c in fts_optimize_table (table=0x7f25e809a8c8) at /data/src/10.2-bug/storage/innobase/fts/fts0opt.cc:2472
      #16 0x0000562476185a46 in ha_innobase::optimize (this=0x7f25e80578b8, thd=0x7f25e8000af0, check_opt=0x7f25e8005608) at /data/src/10.2-bug/storage/innobase/handler/ha_innodb.cc:14946
      #17 0x0000562475f71305 in handler::ha_optimize (this=0x7f25e80578b8, thd=0x7f25e8000af0, check_opt=0x7f25e8005608) at /data/src/10.2-bug/sql/handler.cc:4243
      #18 0x0000562475e49634 in mysql_admin_table(THD *, TABLE_LIST *, HA_CHECK_OPT *, const char *, thr_lock_type, bool, bool, uint, int (*)(THD *, TABLE_LIST *, HA_CHECK_OPT *), struct {...}, int (*)(THD *, TABLE_LIST *, HA_CHECK_OPT *)) (thd=0x7f25e8000af0, tables=0x7f25e8012528, check_opt=0x7f25e8005608, operator_name=0x5624767b7df8 "optimize", lock_type=TL_WRITE, org_open_for_modify=true, repair_table_use_frm=false, extra_open_options=0, prepare_func=0x0, operator_func=(int (handler::*)(handler * const, THD *, HA_CHECK_OPT *)) 0x562475f71284 <handler::ha_optimize(THD*, st_ha_check_opt*)>, view_operator_func=0x0) at /data/src/10.2-bug/sql/sql_admin.cc:803
      #19 0x0000562475e4b94b in Sql_cmd_optimize_table::execute (this=0x7f25e8012b48, thd=0x7f25e8000af0) at /data/src/10.2-bug/sql/sql_admin.cc:1364
      #20 0x0000562475cefe96 in mysql_execute_command (thd=0x7f25e8000af0) at /data/src/10.2-bug/sql/sql_parse.cc:5972
      #21 0x0000562475cf4f7e in mysql_parse (thd=0x7f25e8000af0, rawbuf=0x7f25e8012458 "OPTIMIZE TABLE t1", length=17, parser_state=0x7f263c2bb200, is_com_multi=false, is_next_command=false) at /data/src/10.2-bug/sql/sql_parse.cc:7740
      #22 0x0000562475ce3299 in dispatch_command (command=COM_QUERY, thd=0x7f25e8000af0, packet=0x7f25e8096821 "", packet_length=17, is_com_multi=false, is_next_command=false) at /data/src/10.2-bug/sql/sql_parse.cc:1831
      #23 0x0000562475ce1bed in do_command (thd=0x7f25e8000af0) at /data/src/10.2-bug/sql/sql_parse.cc:1384
      #24 0x0000562475e372b5 in do_handle_one_connection (connect=0x562478e8b120) at /data/src/10.2-bug/sql/sql_connect.cc:1336
      #25 0x0000562475e37020 in handle_one_connection (arg=0x562478e8b120) at /data/src/10.2-bug/sql/sql_connect.cc:1241
      #26 0x0000562476669140 in pfs_spawn_thread (arg=0x562478def230) at /data/src/10.2-bug/storage/perfschema/pfs.cc:1862
      #27 0x00007f2642f804a4 in start_thread (arg=0x7f263c2bc700) at pthread_create.c:456
      #28 0x00007f26414c7d0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              sanja Oleksandr Byelkin
              Reporter:
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated: