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

[Draft] Assertion `thd->transaction.stmt.is_empty()' failed upon killing connection or server

    Details

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 10.3
    • Fix Version/s: None
    • Component/s: Prepared Statements
    • Labels:
      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

        1. threads
          54 kB
        2. threads_full
          138 kB

          Activity

            People

            • Assignee:
              elenst Elena Stepanova
              Reporter:
              elenst Elena Stepanova
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated: