xtrabackup_56 does not roll back prepared XA transactions
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona XtraBackup moved to https://jira.percona.com/projects/PXB |
Fix Released
|
Medium
|
Alexey Kopytov | ||
2.0 |
Won't Fix
|
Undecided
|
Unassigned | ||
2.1 |
Fix Released
|
Medium
|
Alexey Kopytov | ||
2.2 |
Fix Released
|
Medium
|
Alexey Kopytov |
Bug Description
I start Percona Server 5.6 on prepared backup and it fails with following:
2013-11-23 03:08:33 18497 [Note] InnoDB: Highest supported file format is Barracuda.
InnoDB: Transaction 459959599 was in the XA prepared state.
InnoDB: Transaction 459959599 was in the XA prepared state.
InnoDB: 1 transaction(s) which must be rolled back or cleaned up
InnoDB: in total 0 row operations to undo
InnoDB: Trx id counter is 459962112
2013-11-23 03:08:33 18497 [Note] InnoDB: 128 rollback segment(s) are active.
InnoDB: Starting in background the rollback of uncommitted transactions
2013-11-23 03:08:33 7ffb28bff700 InnoDB: Rollback of non-prepared transactions completed
2013-11-23 03:08:33 18497 [Note] InnoDB: Waiting for purge to start
2013-11-23 03:08:33 18497 [Note] InnoDB: Percona XtraDB (http://
2013-11-23 03:08:33 7ffeb516e780 InnoDB: Starting recovery for XA transactions...
2013-11-23 03:08:33 7ffeb516e780 InnoDB: Transaction 459959599 in prepared state after recovery
2013-11-23 03:08:33 7ffeb516e780 InnoDB: Transaction contains changes to 2 rows
2013-11-23 03:08:33 7ffeb516e780 InnoDB: 1 transactions in prepared state after recovery
2013-11-23 03:08:33 18497 [Note] Found 1 prepared transaction(s) in InnoDB
2013-11-23 03:08:33 18497 [ERROR] Found 1 prepared transactions! It means that mysqld was not shut down properly last time and critical recovery information (last binlog or tc.log file) was manually deleted after a crash. You have to start mysqld with --tc-heuristic-
2013-11-23 03:08:33 18497 [ERROR] Aborting
Related branches
- Vlad Lesin (community): Approve (g2)
-
Diff: 83 lines (+67/-1)2 files modifiedpatches/innodb56.patch (+25/-1)
test/t/bug1254227.sh (+42/-0)
- Vlad Lesin (community): Approve (g2)
-
Diff: 74 lines (+48/-4)2 files modifiedstorage/innobase/trx/trx0trx.cc (+6/-4)
storage/innobase/xtrabackup/test/t/bug1254227.sh (+42/-0)
In addition I am not sure about binary log postion binlog_ info
cat xtrabackup_
mysql-bin.000810 882347277
cat xtrabackup_ binlog_ pos_innodb
mysql-bin.000810 882317925