We're updating the issue view to help you get more done. 

Statistics: Failing assertion: trx_is_registered_for_2pc(trx) in ha_innodb.cc on ANALYZE TABLE with row binary logging

Description

1 2 3 InnoDB: Assertion failure in thread 2805345136 in file ha_innodb.cc line 10594 InnoDB: Failing assertion: trx_is_registered_for_2pc(trx) InnoDB: We intentionally generate a memory trap.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 #7 0xb75190f0 in abort () from /lib/libc.so.6 #8 0xad0d0454 in innobase_xa_prepare (hton=0x9674ae8, thd=0x9dd9610, all=false) at storage/innobase/handler/ha_innodb.cc:10594 #9 0x083dade2 in ha_commit_trans (thd=0x9dd9610, all=false) at sql/handler.cc:1264 #10 0x0833ed92 in trans_commit_stmt (thd=0x9dd9610) at sql/transaction.cc:299 #11 0x0833d786 in mysql_admin_table (thd=0x9dd9610, tables=0x9daa1b0, check_opt=0x9ddb464, operator_name=0x8922f9d "analyze", lock_type=TL_READ_NO_INSERT, open_for_modify=true, repair_table_use_frm=false, extra_open_options=0, prepare_func=0, operator_func= (int (handler::*)(handler *, THD *, HA_CHECK_OPT *)) 0x83df758 <handler::ha_analyze(THD*, HA_CHECK_OPT*)>, view_operator_func=0) at sql/sql_admin.cc:952 #12 0x0833dc7c in Analyze_table_statement::execute (this=0x9daa5c8, thd=0x9dd9610) at sql/sql_admin.cc:1075 #13 0x08244d44 in mysql_execute_command (thd=0x9dd9610) at sql/sql_parse.cc:4459 #14 0x08247b91 in mysql_parse (thd=0x9dd9610, rawbuf=0x9daa110 "ANALYZE TABLE t1", length=16, parser_state=0xa7361da4) at sql/sql_parse.cc:5736 #15 0x0823bfdc in dispatch_command (command=COM_QUERY, thd=0x9dd9610, packet=0x9d917a1 "", packet_length=16) at sql/sql_parse.cc:1055 #16 0x0823b4a1 in do_command (thd=0x9dd9610) at sql/sql_parse.cc:794 #17 0x0832e271 in do_handle_one_connection (thd_arg=0x9dd9610) at sql/sql_connect.cc:1253 #18 0x0832ddbc in handle_one_connection (arg=0x9dd9610) at sql/sql_connect.cc:1168 #19 0x08558033 in pfs_spawn_thread (arg=0x9dc7df8) at storage/perfschema/pfs.cc:1015 #20 0xb77efb25 in start_thread () from /lib/libpthread.so.0
1 2 3 4 5 Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0x9daa110): ANALYZE TABLE t1 Connection ID (thread ID): 3 Status: NOT_KILLED

bzr version-info:

1 2 3 4 revision-id: igor@askmonty.org-20120814194214-bc5hme0t1qeewrmj date: 2012-08-14 12:42:14 -0700 build-date: 2012-08-17 05:53:58 +0400 revno: 3358

Test case:

1 2 3 4 5 6 7 8 9 10 11 12 13 14 --source include/have_binlog_format_row.inc --source include/have_innodb.inc SET GLOBAL use_stat_tables = PREFERABLY; --connect (con1,localhost,root,,) CREATE TABLE t1 (i INT) ENGINE=InnoDB; ANALYZE TABLE t1; # Cleanup DROP TABLE t1; SET GLOBAL use_stat_tables = DEFAULT; --disconnect con1

Environment

None

Status

Assignee

Igor Babaev

Reporter

Elena Stepanova

Fix versions

Priority

Major