[MDEV-463] Statistics: Failing assertion: trx_is_registered_for_2pc(trx) in ha_innodb.cc on ANALYZE TABLE with row binary logging Created: 2012-08-17  Updated: 2020-06-09  Resolved: 2012-08-23

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: None
Fix Version/s: 10.0.0

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Igor Babaev
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-22848 Assertion `trx_is_registered_for_2pc(... Confirmed

 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
 



 Comments   
Comment by Igor Babaev [ 2012-08-23 ]

The fix is was pushed into maria-5.5-mwl248.

Generated at Thu Feb 08 06:28:56 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.