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

Failing assertion: state == TRX_STATE_NOT_STARTED || state == TRX_STATE_FORCED_ROLLBACK

Details

    Description

      10.2 491f42d50d17f73d7c3dd2460f9cf84b740fe760

      		 
      2016-11-08 01:05:01 0x7f2cd2875300  InnoDB: Assertion failure in thread 139830487372544 in file trx0trx.ic line 63
      		 
      InnoDB: Failing assertion: state == TRX_STATE_NOT_STARTED || state == TRX_STATE_FORCED_ROLLBACK
      		 
       
      		 
      #6  0x00007f2cd1e7dd2e in ut_dbg_assertion_failed (expr=0x7f2cd23b9838 "state == TRX_STATE_NOT_STARTED || state == TRX_STATE_FORCED_ROLLBACK", file=0x7f2cd23b96d8 "/data/src/10.2/storage/innobase/include/trx0trx.ic", line=63) at /data/src/10.2/storage/innobase/ut/ut0dbg.cc:67
      		 
      #7  0x00007f2cd1e5a75c in trx_state_eq (trx=0x7f2cc6800d58, state=TRX_STATE_ACTIVE) at /data/src/10.2/storage/innobase/include/trx0trx.ic:62
      		 
      #8  0x00007f2cd1e5c20e in trx_release_savepoint_for_mysql (trx=0x7f2cc6800d58, savepoint_name=0x7f2cd2872ca0 "1DKCXDAPJ4") at /data/src/10.2/storage/innobase/trx/trx0roll.cc:584
      		 
      #9  0x00007f2cd1c4c500 in innobase_release_savepoint (hton=0x7f2cce413af0, thd=0x7f2caa016070, savepoint=0x7f2caa06b0c0) at /data/src/10.2/storage/innobase/handler/ha_innodb.cc:5510
      		 
      #10 0x00007f2cd1a1918b in ha_release_savepoint (thd=0x7f2caa016070, sv=0x7f2caa06b088) at /data/src/10.2/sql/handler.cc:2197
      		 
      #11 0x00007f2cd176e1ac in THD::restore_sub_statement_state (this=0x7f2caa016070, backup=0x7f2cd2872e20) at /data/src/10.2/sql/sql_class.cc:5072
      		 
      #12 0x00007f2cd1889595 in Table_triggers_list::process_triggers (this=0x7f2caa01da88, thd=0x7f2caa016070, event=TRG_EVENT_INSERT, time_type=TRG_ACTION_BEFORE, old_row_is_record1=true) at /data/src/10.2/sql/sql_trigger.cc:2201
      		 
      #13 0x00007f2cd174bd0a in fill_record_n_invoke_before_triggers (thd=0x7f2caa016070, table=0x7f2caa0aa870, ptr=0x7f2caa01d598, values=..., ignore_errors=false, event=TRG_EVENT_INSERT) at /data/src/10.2/sql/sql_base.cc:8140
      		 
      #14 0x00007f2cd1789082 in mysql_insert (thd=0x7f2caa016070, table_list=0x7f2caa064168, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_ERROR, ignore=false) at /data/src/10.2/sql/sql_insert.cc:958
      		 
      #15 0x00007f2cd17b01d8 in mysql_execute_command (thd=0x7f2caa016070) at /data/src/10.2/sql/sql_parse.cc:4328
      		 
      #16 0x00007f2cd17bb6a4 in mysql_parse (thd=0x7f2caa016070, rawbuf=0x7f2caa064088 "INSERT INTO t3 VALUES (2)", length=25, parser_state=0x7f2cd2873dd0, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:7799
      		 
      #17 0x00007f2cd17a93f4 in dispatch_command (command=COM_QUERY, thd=0x7f2caa016070, packet=0x7f2caa058071 "INSERT INTO t3 VALUES (2)", packet_length=25, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:1808
      		 
      #18 0x00007f2cd17a7dce in do_command (thd=0x7f2caa016070) at /data/src/10.2/sql/sql_parse.cc:1368
      		 
      #19 0x00007f2cd18ef256 in do_handle_one_connection (connect=0x7f2cce471870) at /data/src/10.2/sql/sql_connect.cc:1354
      		 
      #20 0x00007f2cd18eefe3 in handle_one_connection (arg=0x7f2cce471870) at /data/src/10.2/sql/sql_connect.cc:1260
      		 
      #21 0x00007f2cd1c24856 in pfs_spawn_thread (arg=0x7f2cbcfe7ef0) at /data/src/10.2/storage/perfschema/pfs.cc:1862
      		 
      #22 0x00007f2cd0dfb0a4 in start_thread (arg=0x7f2cd2875300) at pthread_create.c:309
      		 
      #23 0x00007f2cceda887d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111


      --source include/have_innodb.inc
      		 
       
      		 
      CREATE TABLE t1 (a INT) ENGINE=InnoDB;
      		 
      CREATE TABLE t2 (b INT) ENGINE=InnoDB;
      		 
      CREATE TABLE t3 (c INT) ENGINE=InnoDB;
      		 
       
      		 
      --delimiter $$
      		 
      CREATE TRIGGER tr BEFORE INSERT ON t3 FOR EACH ROW BEGIN SAVEPOINT sv; INSERT INTO t2 VALUES (0); END $$
      		 
      --delimiter ;
      		 
       
      		 
      --connect (con1,localhost,root,,test)
      		 
      START TRANSACTION;
      		 
      DELETE FROM t1;
      		 
       
      		 
      --connect (con2,localhost,root,,test)
      		 
      START TRANSACTION;
      		 
      INSERT INTO t2 VALUES (2);
      		 
      UPDATE t2 SET b = b+1;
      		 
      --send
      		 
      INSERT INTO t1 VALUES (1);
      		 
       
      		 
      --connection con1
      		 
      INSERT INTO t3 VALUES (2);

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-14846 InnoDB: assertion on trx->state because of deadlock error ignored

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          links to

          Web Link Bug #83730 Assertion "state == TRX_STATE_NOT_STARTED || state == TRX_STATE_FORCED_ROLLBACK"

          Activity

            Ascending order - Click to sort in descending order
            elenst Elena Stepanova created issue -
            elenst Elena Stepanova made changes -
            Field Original Value New Value
            Component/s Storage Engine - InnoDB [ 10129 ]
            Fix Version/s 10.2 [ 14601 ]
            Assignee Elena Stepanova [ elenst ] Jan Lindström [ jplindst ]
            Description http://buildbot.askmonty.org/buildbot/builders/win-rqg-se/builds/2827/steps/rqg_crash_tests/logs/stdio
            {noformat}
            Assertion failed: derived->table, file E:\buildbot\bbwin1\win-rqg-se\build-debug\sql\sql_derived.cc, line 534
            R6010
            - abort() has been called
            161103 23:47:03 [ERROR] mysqld got exception 0x80000003 ;
            This could be because you hit a bug. It is also possible that this binary
            or one of the libraries it was linked against is corrupt, improperly built,
            or misconfigured. This error can also be caused by malfunctioning hardware.

            To report this bug, see https://mariadb.com/kb/en/reporting-bugs

            We will try our best to scrape up some info that will hopefully help
            diagnose the problem, but since we have already crashed,
            something is definitely wrong and this may fail.

            Server version: 10.2.3-MariaDB-debug-log
            key_buffer_size=1048576
            read_buffer_size=131072
            max_used_connections=7
            max_threads=1001
            thread_count=7
            It is possible that mysqld could use up to
            key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 388193 K bytes of memory
            Hope that's ok; if not, decrease some variables in the equation.

            Thread pointer: 0x0xcf95005c58
            Attempting backtrace. You can use the following information to find out
            where mysqld died. If you see no messages after this, something went
            terribly wrong...
            mysqld.exe!my_sigabrt_handler()[my_thr_init.c:477]
            mysqld.exe!raise()[winsig.c:594]
            mysqld.exe!abort()[abort.c:82]
            mysqld.exe!_wassert()[assert.c:380]
            mysqld.exe!mysql_derived_merge_for_insert()[sql_derived.cc:534]
            mysqld.exe!mysql_handle_single_derived()[sql_derived.cc:197]
            mysqld.exe!TABLE_LIST::handle_derived()[table.cc:7608]
            mysqld.exe!mysql_prepare_insert()[sql_insert.cc:1425]
            mysqld.exe!mysql_insert_select_prepare()[sql_insert.cc:3419]
            mysqld.exe!mysql_insert_select_prepare_tester()[sql_prepare.cc:2202]
            mysqld.exe!select_like_stmt_test()[sql_prepare.cc:1766]
            mysqld.exe!select_like_stmt_test_with_open()[sql_prepare.cc:1811]
            mysqld.exe!mysql_test_insert_select()[sql_prepare.cc:2244]
            mysqld.exe!check_prepared_statement()[sql_prepare.cc:2487]
            mysqld.exe!Prepared_statement::prepare()[sql_prepare.cc:3866]
            mysqld.exe!Prepared_statement::execute_immediate()[sql_prepare.cc:4738]
            mysqld.exe!mysql_sql_stmt_execute_immediate()[sql_prepare.cc:2872]
            mysqld.exe!mysql_execute_command()[sql_parse.cc:3386]
            mysqld.exe!mysql_parse()[sql_parse.cc:7799]
            mysqld.exe!dispatch_command()[sql_parse.cc:1811]
            mysqld.exe!do_command()[sql_parse.cc:1368]
            mysqld.exe!threadpool_process_request()[threadpool_common.cc:319]
            mysqld.exe!tp_callback()[threadpool_common.cc:158]
            mysqld.exe!tp_callback()[threadpool_win.cc:378]
            mysqld.exe!work_callback()[threadpool_win.cc:452]
            ntdll.dll!RtlFreeUnicodeString()
            ntdll.dll!RtlFreeUnicodeString()
            KERNEL32.DLL!BaseThreadInitThunk()
            ntdll.dll!RtlUserThreadStart()

            Trying to get some variables.
            Some pointers may be invalid and cause the dump to abort.
            Query (0xcfaf3d75d8): REPLACE INTO view2 ( field1, field2, field3, field4 ) SELECT a2.field1 AS field1, a2.field2 AS field2, a1.field3 AS field3, a1.field4 AS field4 FROM view2 AS a1 LEFT JOIN table_partitioned AS a2 USING ( field1 ) WHERE a2.field3 >= NULL AND a1.field3 = 'p' ORDER BY field1, field2, field3, field4 LIMIT 0 /* QUERY_NO 15205 CON_ID 15 */
            Connection ID (thread ID): 15
            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
            {noformat}             		{noformat:title=10.2 491f42d50d17f73d7c3dd2460f9cf84b740fe760}
            2016-11-08 01:05:01 0x7f2cd2875300 InnoDB: Assertion failure in thread 139830487372544 in file trx0trx.ic line 63
            InnoDB: Failing assertion: state == TRX_STATE_NOT_STARTED || state == TRX_STATE_FORCED_ROLLBACK

            #6 0x00007f2cd1e7dd2e in ut_dbg_assertion_failed (expr=0x7f2cd23b9838 "state == TRX_STATE_NOT_STARTED || state == TRX_STATE_FORCED_ROLLBACK", file=0x7f2cd23b96d8 "/data/src/10.2/storage/innobase/include/trx0trx.ic", line=63) at /data/src/10.2/storage/innobase/ut/ut0dbg.cc:67
            #7 0x00007f2cd1e5a75c in trx_state_eq (trx=0x7f2cc6800d58, state=TRX_STATE_ACTIVE) at /data/src/10.2/storage/innobase/include/trx0trx.ic:62
            #8 0x00007f2cd1e5c20e in trx_release_savepoint_for_mysql (trx=0x7f2cc6800d58, savepoint_name=0x7f2cd2872ca0 "1DKCXDAPJ4") at /data/src/10.2/storage/innobase/trx/trx0roll.cc:584
            #9 0x00007f2cd1c4c500 in innobase_release_savepoint (hton=0x7f2cce413af0, thd=0x7f2caa016070, savepoint=0x7f2caa06b0c0) at /data/src/10.2/storage/innobase/handler/ha_innodb.cc:5510
            #10 0x00007f2cd1a1918b in ha_release_savepoint (thd=0x7f2caa016070, sv=0x7f2caa06b088) at /data/src/10.2/sql/handler.cc:2197
            #11 0x00007f2cd176e1ac in THD::restore_sub_statement_state (this=0x7f2caa016070, backup=0x7f2cd2872e20) at /data/src/10.2/sql/sql_class.cc:5072
            #12 0x00007f2cd1889595 in Table_triggers_list::process_triggers (this=0x7f2caa01da88, thd=0x7f2caa016070, event=TRG_EVENT_INSERT, time_type=TRG_ACTION_BEFORE, old_row_is_record1=true) at /data/src/10.2/sql/sql_trigger.cc:2201
            #13 0x00007f2cd174bd0a in fill_record_n_invoke_before_triggers (thd=0x7f2caa016070, table=0x7f2caa0aa870, ptr=0x7f2caa01d598, values=..., ignore_errors=false, event=TRG_EVENT_INSERT) at /data/src/10.2/sql/sql_base.cc:8140
            #14 0x00007f2cd1789082 in mysql_insert (thd=0x7f2caa016070, table_list=0x7f2caa064168, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_ERROR, ignore=false) at /data/src/10.2/sql/sql_insert.cc:958
            #15 0x00007f2cd17b01d8 in mysql_execute_command (thd=0x7f2caa016070) at /data/src/10.2/sql/sql_parse.cc:4328
            #16 0x00007f2cd17bb6a4 in mysql_parse (thd=0x7f2caa016070, rawbuf=0x7f2caa064088 "INSERT INTO t3 VALUES (2)", length=25, parser_state=0x7f2cd2873dd0, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:7799
            #17 0x00007f2cd17a93f4 in dispatch_command (command=COM_QUERY, thd=0x7f2caa016070, packet=0x7f2caa058071 "INSERT INTO t3 VALUES (2)", packet_length=25, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:1808
            #18 0x00007f2cd17a7dce in do_command (thd=0x7f2caa016070) at /data/src/10.2/sql/sql_parse.cc:1368
            #19 0x00007f2cd18ef256 in do_handle_one_connection (connect=0x7f2cce471870) at /data/src/10.2/sql/sql_connect.cc:1354
            #20 0x00007f2cd18eefe3 in handle_one_connection (arg=0x7f2cce471870) at /data/src/10.2/sql/sql_connect.cc:1260
            #21 0x00007f2cd1c24856 in pfs_spawn_thread (arg=0x7f2cbcfe7ef0) at /data/src/10.2/storage/perfschema/pfs.cc:1862
            #22 0x00007f2cd0dfb0a4 in start_thread (arg=0x7f2cd2875300) at pthread_create.c:309
            #23 0x00007f2cceda887d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
            {noformat}

            {code:sql}
            --source include/have_innodb.inc

            CREATE TABLE t1 (a INT) ENGINE=InnoDB;
            CREATE TABLE t2 (b INT) ENGINE=InnoDB;
            CREATE TABLE t3 (c INT) ENGINE=InnoDB;

            --delimiter $$
            CREATE TRIGGER tr BEFORE INSERT ON t3 FOR EACH ROW BEGIN SAVEPOINT sv; INSERT INTO t2 VALUES (0); END $$
            --delimiter ;

            --connect (con1,localhost,root,,test)
            START TRANSACTION;
            DELETE FROM t1;

            --connect (con2,localhost,root,,test)
            START TRANSACTION;
            INSERT INTO t2 VALUES (2);
            UPDATE t2 SET b = b+1;
            --send
            INSERT INTO t1 VALUES (1);

            --connection con1
            INSERT INTO t3 VALUES (2);
            {code}
            Summary [Draft] Assertion failed: derived->table Failing assertion: state == TRX_STATE_NOT_STARTED || state == TRX_STATE_FORCED_ROLLBACK
            elenst Elena Stepanova made changes -
            Labels upstream
            elenst Elena Stepanova made changes -
            ratzpo Rasmus Johansson (Inactive) made changes -
            Assignee Jan Lindström [ jplindst ] Marko Mäkelä [ marko ]
            marko Marko Mäkelä made changes -
            issue.field.resolutiondate 2016-12-02 14:49:00.0 2016-12-02 14:49:00.851
            marko Marko Mäkelä made changes -
            Fix Version/s 10.1.20 [ 22112 ]
            Fix Version/s 10.2.3 [ 22115 ]
            Fix Version/s 10.2 [ 14601 ]
            Resolution Fixed [ 1 ]
            Status Open [ 1 ] Closed [ 6 ]
            marko Marko Mäkelä made changes -
            thiru Thirunarayanan Balathandayuthapani made changes -
            Assignee Marko Mäkelä [ marko ] Thirunarayanan B [ thiru ]
            thiru Thirunarayanan Balathandayuthapani made changes -
            Assignee Thirunarayanan B [ thiru ] Oleksandr Byelkin [ sanja ]
            thiru Thirunarayanan Balathandayuthapani made changes -
            Assignee Oleksandr Byelkin [ sanja ] Thirunarayanan B [ thiru ]
            thiru Thirunarayanan Balathandayuthapani made changes -
            Assignee Thirunarayanan B [ thiru ] Marko Mäkelä [ marko ]
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 78211 ] MariaDB v4 [ 151189 ]

            People

              marko Marko Mäkelä
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.