Take the appropriate actions to resolve the transaction. Problem: Transaction is marked as committed at TM but
RMs are indoubt.[1] WXS-40000139-DEF8-EF60-E002-1CB456931719
Timestamp Partition Role State Container Resync Attempts
--------------------------------------------------------------------------------------
2012-09-19 10:40:19.824 TestSet1:11 TM COMMIT MPTBasic2_C-0 Primary 0
2012-09-19 10:40:19.824 TestSet1:7 RM PREPARED MPTBasic0_C-1 Primary 0
2012-09-19 10:40:19.839 TestSet2:20 RM PREPARED MPTBasic2_C-0 Primary 0
2012-09-19 10:40:19.824 TestSet2:6 RM PREPARED MPTBasic0_C-1 Primary 0
Solution:
Commit the resource manager (RM) partitions and then forget the transaction.- Issue the following command to commit the RM partition in transaction WXS-40000139-DEF8-EF60-E002-1CB456931719: xscmd
-c listIndoubts -xid WXS-40000139-DEF8-EF60-E002-1CB456931719 -cm
-rm
- Issue the following command to forget this transaction: xscmd
-c listIndoubts -xid WXS-40000139-DEF8-EF60-E002-1CB456931719 -f
Problem: Transaction is indoubt at all partitions.[1] WXS-40000139-DEF6-FA84-E000-1CB456931719
Timestamp Partition Role State Container Resync Attempts
--------------------------------------------------------------------------------------
2012-09-19 10:38:11.603 TestSet1:10 RM PREPARED MPTBasic2_C-0 Primary 0
2012-09-19 10:38:11.588 TestSet1:5 TM PREPARED MPTBasic2_C-0 Primary 0
2012-09-19 10:38:11.603 TestSet2:11 RM PREPARED MPTBasic2_C-0 Primary 0
2012-09-19 10:38:11.619 TestSet2:13 RM PREPARED MPTBasic2_C-0 Primary 0
Solution:
Roll back the TM partition first, and then roll back subsequent RM
partitions. Then, forget the transaction.- Issue the following command to roll back the TM partition in transaction WXS-40000139-DEF6-FA84-E000-1CB456931719: xscmd
-c listIndoubts -xid WXS-40000139-DEF6-FA84-E000-1CB456931719 -r -tm
- Issue the following command to roll back the RM partitions in
this transaction: xscmd -c listIndoubts -xid WXS-40000139-DEF6-FA84-E000-1CB456931719
-r -rm
- Issue the following command to forget this transaction: xscmd
-c listIndoubts -xid WXS-40000139-DEF6-FA84-E000-1CB456931719 -f
Problem: Transaction is indoubt at all RM partitions,
but transaction decision is unknown at TM.[1] WXS-40000139-DEF8-EF31-E000-1CB456931719
Timestamp Partition Role State Container Resync Attempts
-----------------------------------------------------------------------------------
2012-09-19 10:40:19.777 TestSet1:11 RM PREPARED MPTBasic2_C-0 Primary 0
2012-09-19 10:40:19.792 TestSet2:5 RM PREPARED MPTBasic2_C-0 Primary 0
2012-09-19 10:40:19.777 TestSet2:6 RM PREPARED MPTBasic2_C-1 Primary 0
Solution:
Roll back the RM partitions.- Issue the following command to roll back the RM partitions in
transaction WXS-40000139-DEF8-EF31-E000-1CB456931719: xscmd
-c listIndoubts -xid WXS-40000139-DEF8-EF31-E000-1CB456931719 -r