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

[Draft] Assertion `!table->file || table->file->inited == handler::NONE' failed in close_thread_table

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.3
    • None
    • None
    • None

    Description

      https://api.travis-ci.org/v3/job/357939993/log.txt

      10.3 ad647cc84ebf331d59b24e81bffe89be2f5b1ed7

      mysqld: /home/travis/src/sql/sql_base.cc:866: void close_thread_table(THD*, TABLE**): Assertion `!table->file || table->file->inited == handler::NONE' failed.
      180325 10:41:48 [ERROR] mysqld got signal 6 ;
       
      Query (0x7f3c68013b88): (  SELECT * FROM INFORMATION_SCHEMA.`REFERENTIAL_CONSTRAINTS` AS table1 WHERE table1.`REFERENCED_TABLE_NAME` <= table1.`UPDATE_RULE` HAVING NOT (NOT ( table1.`REFERENCED_TABLE_NAME` != 5 AND table1.`CONSTRAINT_NAME` <= 'b') OR table1.`CONSTRAINT_SCHEMA` != '2004-12-08 08:21:20.006362') ORDER BY table1.`UNIQUE_CONSTRAINT_CATALOG` /* QNO 4845 CON_ID 18 */  ) UNION DISTINCT (  SELECT * FROM INFORMATION_SCHEMA.`REFERENTIAL_CONSTRAINTS` AS table1 WHERE table1.`REFERENCED_TABLE_NAME` <= table1.`UPDATE_RULE` HAVING NOT (NOT ( table1.`REFERENCED_TABLE_NAME` != 5 AND table1.`CONSTRAINT_NAME` <= 'b') OR table1.`CONSTRAINT_SCHEMA` != '2004-12-08 08:21:20.006362') ORDER BY table1.`UNIQUE_CONSTRAINT_CATALOG` /* QNO 4845 CON_ID 18 */  ) /* TRANSFORM_OUTCOME_DISTINCT */ /* QNO 4856 CON_ID 18 */
      Connection ID (thread ID): 18
      Status: NOT_KILLED
      Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on,split_materialized=on
      

      #6  0x00007f3cc8a25bf6 in __assert_fail_base (fmt=0x7f3cc8b7a058 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x5599480fc890 "!table->file || table->file->inited == handler::NONE", file=file@entry=0x5599480fc578 "/home/travis/src/sql/sql_base.cc", line=line@entry=866, function=function@entry=0x5599480fe220 <close_thread_table(THD*, TABLE**)::__PRETTY_FUNCTION__> "void close_thread_table(THD*, TABLE**)") at assert.c:92
      #7  0x00007f3cc8a25ca2 in __GI___assert_fail (assertion=0x5599480fc890 "!table->file || table->file->inited == handler::NONE", file=0x5599480fc578 "/home/travis/src/sql/sql_base.cc", line=866, function=0x5599480fe220 <close_thread_table(THD*, TABLE**)::__PRETTY_FUNCTION__> "void close_thread_table(THD*, TABLE**)") at assert.c:101
      #8  0x00005599475144a4 in close_thread_table (thd=0x7f3c68000c70, table_ptr=0x7f3c68000d60) at /home/travis/src/sql/sql_base.cc:866
      #9  0x0000559947514326 in close_thread_tables (thd=0x7f3c68000c70) at /home/travis/src/sql/sql_base.cc:851
      #10 0x0000559947641942 in fill_schema_table_by_open (thd=0x7f3c68000c70, mem_root=0x7f3cb0fed1c0, is_show_fields_or_keys=false, table=0x7f3c681b7e28, schema_table=0x559948aeb4a0 <schema_tables+1408>, orig_db_name=0x7f3c681e59f0, orig_table_name=0x7f3c681e5e98, open_tables_state_backup=0x7f3cb0fed210, can_deadlock=false) at /home/travis/src/sql/sql_show.cc:4634
      #11 0x000055994764345e in get_all_tables (thd=0x7f3c68000c70, tables=0x7f3c68014400, cond=0x7f3c68014d20) at /home/travis/src/sql/sql_show.cc:5276
      #12 0x0000559947653be2 in get_schema_tables_result (join=0x7f3c68221df0, executed_place=PROCESSED_BY_JOIN_EXEC) at /home/travis/src/sql/sql_show.cc:8786
      #13 0x00005599475edd0a in JOIN::exec_inner (this=0x7f3c68221df0) at /home/travis/src/sql/sql_select.cc:3950
      #14 0x00005599475ed3b0 in JOIN::exec (this=0x7f3c68221df0) at /home/travis/src/sql/sql_select.cc:3781
      #15 0x000055994769503d in st_select_lex_unit::exec (this=0x7f3c68004aa8) at /home/travis/src/sql/sql_union.cc:1435
      #16 0x000055994769018c in mysql_union (thd=0x7f3c68000c70, lex=0x7f3c680049e0, result=0x7f3c68221ce8, unit=0x7f3c68004aa8, setup_tables_done_option=0) at /home/travis/src/sql/sql_union.cc:41
      #17 0x00005599475e081e in handle_select (thd=0x7f3c68000c70, lex=0x7f3c680049e0, result=0x7f3c68221ce8, setup_tables_done_option=0) at /home/travis/src/sql/sql_select.cc:360
      #18 0x00005599475aba92 in execute_sqlcom_select (thd=0x7f3c68000c70, all_tables=0x7f3c68014400) at /home/travis/src/sql/sql_parse.cc:6552
      #19 0x00005599475a209b in mysql_execute_command (thd=0x7f3c68000c70) at /home/travis/src/sql/sql_parse.cc:3763
      #20 0x00005599475af454 in mysql_parse (thd=0x7f3c68000c70, rawbuf=0x7f3c68013b88 "(  SELECT * FROM INFORMATION_SCHEMA.`REFERENTIAL_CONSTRAINTS` AS table1 WHERE table1.`REFERENCED_TABLE_NAME` <= table1.`UPDATE_RULE` HAVING NOT (NOT ( table1.`REFERENCED_TABLE_NAME` != 5 AND table1.`C"..., length=790, parser_state=0x7f3cb0fef5e0, is_com_multi=false, is_next_command=false) at /home/travis/src/sql/sql_parse.cc:8009
      #21 0x000055994759cb4d in dispatch_command (command=COM_QUERY, thd=0x7f3c68000c70, packet=0x7f3c6800b3c1 "(  SELECT * FROM INFORMATION_SCHEMA.`REFERENTIAL_CONSTRAINTS` AS table1 WHERE table1.`REFERENCED_TABLE_NAME` <= table1.`UPDATE_RULE` HAVING NOT (NOT ( table1.`REFERENCED_TABLE_NAME` != 5 AND table1.`C"..., packet_length=791, is_com_multi=false, is_next_command=false) at /home/travis/src/sql/sql_parse.cc:1838
      #22 0x000055994759b599 in do_command (thd=0x7f3c68000c70) at /home/travis/src/sql/sql_parse.cc:1383
      #23 0x00005599477007c3 in do_handle_one_connection (connect=0x55994ae10050) at /home/travis/src/sql/sql_connect.cc:1402
      #24 0x0000559947700550 in handle_one_connection (arg=0x55994ae10050) at /home/travis/src/sql/sql_connect.cc:1308
      #25 0x00007f3cc95e7184 in start_thread (arg=0x7f3cb0ff0700) at pthread_create.c:312
      #26 0x00007f3cc8af403d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
      

      experimental a1ddcead83c7eff16d5f5a6ff967c8f77c16715e

      perl /home/travis/rqg/runall-new.pl --duration=350 --threads=6 --seed=1521974429 --reporters=Backtrace,ErrorLog,Deadlock --validators=TransformerNoComparator --transformers=ExecuteAsCTE,ExecuteAsDeleteReturning,ExecuteAsExcept,ExecuteAsExecuteImmediate,ExecuteAsInsertSelect,ExecuteAsIntersect,ExecuteAsUnion,ExecuteAsUpdateDelete,ExecuteAsView,ExecuteAsPreparedTwice,ExecuteAsSPTwice --redefine=conf/mariadb/general-workarounds.yy --mysqld=--log_output=FILE --views --vcols --redefine=conf/mariadb/versioning.yy --redefine=conf/mariadb/alter_table.yy --redefine=conf/mariadb/bulk_insert.yy --redefine=conf/mariadb/sequences.yy --redefine=conf/mariadb/xa.yy --basedir=/home/travis/server --mysqld=--log_bin_trust_function_creators=1 --mysqld=--log-bin --mysqld=--max-statement-time=30 --mysqld=--loose-debug_assert_on_not_freed_memory=0 --grammar=conf/runtime/information_schema.yy --mysqld=--default-storage-engine=MyISAM --engine=MyISAM --vardir=/home/travis/logs/vardir1_3
      

      Attachments

        Activity

          People

            elenst Elena Stepanova
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            1 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.