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
|