Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
10.3(EOL)
-
None
Description
https://travis-ci.org/elenst/travis-tests/jobs/402892317
10.3 813b7398500f8d216c11da9b92135048a03f3227 |
Version: '10.3.9-MariaDB-debug-log' socket: '/home/travis/logs/vardir/mysql.sock' port: 19300 Source distribution
|
mysqld: /home/travis/src/sql/sql_prepare.cc:3999: bool Prepared_statement::prepare(const char*, uint): Assertion `thd->transaction.stmt.is_empty()' failed.
|
180712 2:45:47 [ERROR] mysqld got signal 6 ;
|
 |
Query (0x7f3b9454aee0): DELETE HISTORY FROM `view_table0_int` BEFORE system_time @trx /* QNO 228 CON_ID 14 */
|
Connection ID (thread ID): 14
|
Status: KILL_CONNECTION
|
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
|
7 0x00007f3bffec2ca2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
|
#8 0x000055cbb31dbc09 in Prepared_statement::prepare (this=0x7f3b9452bae0, packet=0x7f3b94016a91 "DELETE HISTORY FROM `view_table0_int` BEFORE system_time @trx /* QNO 228 CON_ID 14 */ ", packet_len=86) at /home/travis/src/sql/sql_prepare.cc:3999
|
#9 0x000055cbb31d8582 in mysqld_stmt_prepare (thd=0x7f3b9400c4d0, packet=0x7f3b94016a91 "DELETE HISTORY FROM `view_table0_int` BEFORE system_time @trx /* QNO 228 CON_ID 14 */ ", packet_length=86) at /home/travis/src/sql/sql_prepare.cc:2618
|
#10 0x000055cbb31ad212 in dispatch_command (command=COM_STMT_PREPARE, thd=0x7f3b9400c4d0, packet=0x7f3b94016a91 "DELETE HISTORY FROM `view_table0_int` BEFORE system_time @trx /* QNO 228 CON_ID 14 */ ", packet_length=86, is_com_multi=false, is_next_command=false) at /home/travis/src/sql/sql_parse.cc:1804
|
#11 0x000055cbb31abf84 in do_command (thd=0x7f3b9400c4d0) at /home/travis/src/sql/sql_parse.cc:1392
|
#12 0x000055cbb3313093 in do_handle_one_connection (connect=0x55cbb6c4c840) at /home/travis/src/sql/sql_connect.cc:1402
|
#13 0x000055cbb3312e17 in handle_one_connection (arg=0x55cbb6c4c840) at /home/travis/src/sql/sql_connect.cc:1308
|
#14 0x00007f3c00a84184 in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
|
#15 0x00007f3bfff90ffd in clone () from /lib/x86_64-linux-gnu/libc.so.6
|
merge aa7bc7508b939e11fc7e444384290d5950a06f4f |
perl /home/travis/rqg/runall-new.pl --vardir=/home/travis/logs/vardir --basedir=/home/travis/server --duration=350 --threads=6 --seed=1531363536 --reporters=Backtrace,ErrorLog,Deadlock --validators=TransformerNoComparator --views --redefine=conf/mariadb/versioning.yy --redefine=conf/mariadb/alter_table.yy --redefine=conf/mariadb/bulk_insert.yy --redefine=conf/mariadb/sequences.yy --mysqld=--log_output=FILE --mysqld=--max-statement-time=30 --mysqld=--lock-wait-timeout=10 --mysqld=--loose-innodb-lock-wait-timeout=5 --mysqld=--loose-debug_assert_on_not_freed_memory=0 --mysqld=--innodb-sync-debug --grammar=conf/runtime/WL5004_sql.yy --gendata=conf/runtime/WL5004_data.zz --ps-protocol --transformers=ExecuteAsCTE,ExecuteAsDeleteReturning,ExecuteAsExcept,ExecuteAsInsertSelect,ExecuteAsIntersect,ExecuteAsUnion,ExecuteAsUpdateDelete,ExecuteAsView,ExecuteAsSPTwice
|
Stack traces are attached. Coredump, datadir etc. are available on demand.
Attachments
Issue Links
- duplicates
-
MDEV-20750 Assertion `thd->transaction.stmt.is_empty() || thd->in_sub_stmt || (thd->state_flags & Open_tables_state::BACKUPS_AVAIL)' fails in open_normal_and_derived_tables upon killing connection running SETVAL
- Open