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

InnoDB: Assertion failure in file trx/trx0roll.cc line 326 in trx_rollback_last_sql_stat_for_mysql

    XMLWordPrintable

Details

    Description

      Update: See comments for the test case


      10.2 8f98835bb86550a68a6c412d8417cc169dfdc206

      2018-03-06 14:09:17 140281232664448 [Warning] No argument was provided to --log-bin and neither --log-basename or --log-bin-index where used;  This may cause repliction to break when this server acts as a master and has its hostname changed! Please use '--log-basename=travis-job-7b5ef115-5276-4b5c-ad07-c19c10ba4d04' or '--log-bin=mysql-bin' to avoid this problem.
      Version: '10.2.14-MariaDB-debug-log'  socket: '/home/travis/logs/vardir1_1/mysql.sock'  port: 19300  Source distribution
      2018-03-06 14:13:59 140281148442368 [ERROR] Event Scheduler: [rqg@localhost][testdb_S.e1_2_S] Table 'testdb_S.t1_merge1_N' doesn't exist
      2018-03-06 14:14:00 0x7f95a415f700  InnoDB: Assertion failure in file /home/travis/src/storage/innobase/trx/trx0roll.cc line 334
       
      Query (0x7f95a0013578): HANDLER handler_a READ `col_int_key` NEXT  /* QNO 6893 CON_ID 16 */
      Connection ID (thread ID): 88
      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
      

      #5  0x00007f95c2e0f028 in __GI_abort () at abort.c:89
      #6  0x0000557b914ade4c in ut_dbg_assertion_failed (expr=0x0, file=0x557b91a68340 "/home/travis/src/storage/innobase/trx/trx0roll.cc", line=334) at /home/travis/src/storage/innobase/ut/ut0dbg.cc:61
      #7  0x0000557b9148ceb2 in trx_rollback_last_sql_stat_for_mysql (trx=0x7f95c0a79c90) at /home/travis/src/storage/innobase/trx/trx0roll.cc:334
      #8  0x0000557b9129a48f in innobase_rollback (hton=0x557b949a3860, thd=0x7f95a0002b20, rollback_trx=false) at /home/travis/src/storage/innobase/handler/ha_innodb.cc:4879
      #9  0x0000557b91092f41 in ha_rollback_trans (thd=0x7f95a0002b20, all=false) at /home/travis/src/sql/handler.cc:1672
      #10 0x0000557b90f77ad7 in trans_rollback_stmt (thd=0x7f95a0002b20) at /home/travis/src/sql/transaction.cc:565
      #11 0x0000557b90deffb6 in mysql_ha_read (thd=0x7f95a0002b20, tables=0x7f95a0013750, mode=RNEXT, keyname=0x7f95a0013d70 "col_int_key", key_expr=0x0, ha_rkey_mode=HA_READ_KEY_EXACT, cond=0x0, select_limit_cnt=1, offset_limit_cnt=0) at /home/travis/src/sql/sql_handler.cc:914
      #12 0x0000557b90e1ec87 in mysql_execute_command (thd=0x7f95a0002b20) at /home/travis/src/sql/sql_parse.cc:5519
      #13 0x0000557b90e25b2f in mysql_parse (thd=0x7f95a0002b20, rawbuf=0x7f95a0013578 "HANDLER handler_a READ `col_int_key` NEXT  /* QNO 6893 CON_ID 16 */", length=67, parser_state=0x7f95a415e210, is_com_multi=false, is_next_command=false) at /home/travis/src/sql/sql_parse.cc:7902
      #14 0x0000557b90e13a65 in dispatch_command (command=COM_QUERY, thd=0x7f95a0002b20, packet=0x7f95a0008b41 "HANDLER handler_a READ `col_int_key` NEXT  /* QNO 6893 CON_ID 16 */ ", packet_length=68, is_com_multi=false, is_next_command=false) at /home/travis/src/sql/sql_parse.cc:1806
      #15 0x0000557b90e123c8 in do_command (thd=0x7f95a0002b20) at /home/travis/src/sql/sql_parse.cc:1360
      #16 0x0000557b90f6190a in do_handle_one_connection (connect=0x557b94febeb0) at /home/travis/src/sql/sql_connect.cc:1335
      #17 0x0000557b90f61697 in handle_one_connection (arg=0x557b94febeb0) at /home/travis/src/sql/sql_connect.cc:1241
      #18 0x00007f95c39c6184 in start_thread (arg=0x7f95a415f700) at pthread_create.c:312
      #19 0x00007f95c2ed303d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
      

      Attachments

        Activity

          People

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