Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
None
-
None
-
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
|
|
Attachments
Issue Links
- relates to
-
MDEV-22848 Assertion `trx_is_registered_for_2pc(trx)' failed in innobase_xa_prepare on DROP and in innobase_savepoint on SAVEPOINT
- Confirmed