Using the xscmd -c listindoubt command,
you can view the state of a transaction and determine a course of
action.
[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
[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
[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