Bug #55930 Assertion `thd->transaction.stmt.is_empty() || thd->in_sub_stmt || (thd->state..
Submitted: 12 Aug 2010 0:33 Modified: 20 Nov 2010 17:41
Reporter: Elena Stepanova Email Updates:
Status: Closed Impact on me:
Category:MySQL Server: DML Severity:S2 (Serious)
Version:5.5.6-m3-debug, 5.6.0-m4-debug OS:Any
Assigned to: Jon Olav Hauglid
Triage: Triaged: D1 (Critical) / R2 (Low) / E2 (Low)

[12 Aug 2010 0:33] Elena Stepanova
trunk-bugfixing, 5.5-bugfixing

mysqld: mysql-5.6.0-m4/sql/sql_base.cc:1412: void close_thread_tables(THD*): Assertion `thd->transaction.stmt.is_empty() || thd->in_sub_stmt || (thd->state_flags & Open_tables_state::BACKUPS_AVAIL)' failed.
100809  2:45:56 - mysqld got signal 6 ;

#7  0x000000000056a105 in close_thread_tables (thd=0x2aaab05e4ee0) at mysql-5.6.0-m4/sql/sql_base.cc:1411
#8  0x000000000056d3ed in open_ltable (thd=0x2aaab05e4ee0, table_list=0x2881db0, lock_type=TL_WRITE, lock_flags=0)
    at mysql-5.6.0-m4/sql/sql_base.cc:5264
#9  0x00000000006377d4 in mysql_admin_table (thd=0x2aaab05e4ee0, tables=0x2881db0, check_opt=0x2aaab05e74b0, operator_name=0xb27681 "optimize",
    lock_type=TL_WRITE, open_for_modify=false, no_warnings_for_error=false, extra_open_options=0, prepare_func=0, operator_func=
    (int ( class handler::*)(class THD *,HA_CHECK_OPT *,)) 919947, view_operator_func=0)
    at mysql-5.6.0-m4/sql/sql_table.cc:5219
#10 0x0000000000638370 in mysql_optimize_table (thd=0x2aaab05e4ee0, tables=0x2881db0, check_opt=0x2aaab05e74b0)
    at mysql-5.6.0-m4/sql/sql_table.cc:5378
#11 0x00000000005b50aa in mysql_execute_command (thd=0x2aaab05e4ee0) at mysql-5.6.0-m4/sql/sql_parse.cc:3007
#12 0x00000000005ba9ba in mysql_parse (thd=0x2aaab05e4ee0, rawbuf=0x2881c50 "ALTER TABLE t_celosia_ddl_partitions OPTIMIZE PARTITION p3", length=58,
    parser_state=0x47a97a30) at mysql-5.6.0-m4/sql/sql_parse.cc:5827
#13 0x00000000005bbfe6 in dispatch_command (command=COM_QUERY, thd=0x2aaab05e4ee0, packet=0x2aaaae361881 "", packet_length=58)
    at mysql-5.6.0-m4/sql/sql_parse.cc:1129
#14 0x00000000005bd450 in do_command (thd=0x2aaab05e4ee0) at mysql-5.6.0-m4/sql/sql_parse.cc:801
#15 0x0000000000684c3c in do_handle_one_connection (thd_arg=0x2aaab05e4ee0)
    at mysql-5.6.0-m4/sql/sql_connect.cc:1191
#16 0x0000000000684d05 in handle_one_connection (arg=0x2aaab05e4ee0) at mysql-5.6.0-m4/sql/sql_connect.cc:1130
#17 0x00002b5a1d91f143 in start_thread () from /lib64/libpthread.so.0
#18 0x00002b5a1e0908cd in clone () from /lib64/libc.so.6

Trying to get some variables.
Some pointers may be invalid and cause the dump to abort...
thd->query at 0x2881c50 = ALTER TABLE t_celosia_ddl_partitions OPTIMIZE PARTITION p3

How to repeat:
No test case yet
[23 Sep 2010 10:30] Jon Olav Hauglid
Also seen when running RQG tests on mysql-5.5-runtime.
[1 Oct 2010 6:34] Jon Olav Hauglid
Also seen when running RQG tests on mysql-5.5-runtime for non-partitioned tables.
Setting bug to Verified and assigning it to myself for further investigation.
[13 Oct 2010 11:53] Jon Olav Hauglid
MTR test case:

--source include/have_debug_sync.inc

CREATE TABLE t1(a INT) engine=InnoDB;

connect (con1, localhost, root);
connect (con2, localhost, root);

connection con1;
SET SESSION lock_wait_timeout= 1;
SET DEBUG_SYNC= 'ha_admin_open_ltable SIGNAL opti_recreate WAIT_FOR opti_analyze';

connection con2;
SET DEBUG_SYNC= 'now WAIT_FOR opti_recreate';
SET DEBUG_SYNC= 'after_lock_tables_takes_lock SIGNAL thrlock WAIT_FOR release_thrlock';
--send INSERT INTO t1 VALUES (3)

connection default;
SET DEBUG_SYNC= 'now WAIT_FOR thrlock';
SET DEBUG_SYNC= 'now SIGNAL opti_analyze';

connection con1;
SET DEBUG_SYNC= 'now SIGNAL release_thrlock';

connection con2;

connection default;
disconnect con1;
disconnect con2;
[13 Oct 2010 11:55] Jon Olav Hauglid
Bug #57148 was marked as a duplicate of this bug.
[13 Oct 2010 14:16] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:


3164 Jon Olav Hauglid	2010-10-13
      Bug #55930 Assertion `thd->transaction.stmt.is_empty() ||
                 thd->in_sub_stmt || (thd->state..
      OPTIMIZE TABLE is not directly supported by InnoDB. Instead,
      recreate and analyze of the table is done. After recreate,
      the table is closed and locks are released before the table
      is reopened and locks re-acquired for the analyze phase.
      This assertion was triggered if OPTIMIZE TABLE failed to
      acquire thr_lock locks before starting the analyze phase.
      The assertion tests (among other things) that there no
      active statement transaction. However, as part of acquiring
      the thr_lock lock, external_lock() is called for InnoDB
      tables and this causes a statement transaction to be started.
      If thr_multi_lock() later fails (e.g. due to timeout),
      the failure handling code causes this assert to be triggered.
      This patch fixes the problem by doing rollback of the
      current statement transaction in case open_ltable (used by
      OPTIMIZE TABLE) fails to acquire thr_lock locks.
      Test case added to lock_sync.test.
[13 Oct 2010 14:29] Konstantin Osipov
OK to push.
[13 Oct 2010 14:58] Jon Olav Hauglid
Pushed to mysql-5.5-runtime.
[14 Oct 2010 9:05] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:


3165 Jon Olav Hauglid	2010-10-14
      Follow-up for Bug #55930 Assertion `thd->transaction.stmt.is_empty()
                               || thd->in_sub_stmt || (thd->state..
      Don't rollback statement transactions if we are in a sub-statement.
      This could for example happen for open_ltable() when opening the
      general log during execution of a stored procedure.
[13 Nov 2010 16:11] Bugs System
Pushed into mysql-trunk 5.6.99-m5 (revid:alexander.nozdrin@oracle.com-20101113155825-czmva9kg4n31anmu) (version source revid:alexander.nozdrin@oracle.com-20101113152450-2zzcm50e7i4j35v7) (merge vers: 5.6.1-m4) (pib:21)
[13 Nov 2010 16:31] Bugs System
Pushed into mysql-next-mr (revid:alexander.nozdrin@oracle.com-20101113160336-atmtmfb3mzm4pz4i) (version source revid:vasil.dimov@oracle.com-20100629074804-359l9m9gniauxr94) (pib:21)
[20 Nov 2010 17:41] Paul Dubois
Noted in 5.5.8 changelog.

OPTIMIZE TABLE for InnoDB tables could raise an assertion.
[16 Dec 2010 22:27] Bugs System
Pushed into mysql-5.5 5.5.9 (revid:jonathan.perkin@oracle.com-20101216101358-fyzr1epq95a3yett) (version source revid:jonathan.perkin@oracle.com-20101216101358-fyzr1epq95a3yett) (merge vers: 5.5.9) (pib:24)