Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: 10.0.0
-
Component/s: None
-
Labels:None
Description
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.
#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
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:
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:
--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
Gliffy Diagrams
Attachments
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
The fix is was pushed into maria-5.5-mwl248.