Atomikos Forum

All feedback will be investigated, but priority support, confidential support, and product priority updates are reserved for customers. Interested in becoming a customer? Subscribe here...

Only registered users can post (registration is free). Problems registering? Send an email to support@atomikos.com to get help.


how to force unlock atomikos  a dead two-phase commit

When i force to shutdown my application, some transaction can not close itself and my oracle dabase has a dead two-phase commits.

Is there any solution to solve this error without force rollback by dBA.

I mean Atomokis has any fature like when it start again, it will kill all dead two-phase commit  prepared transactions??

I need your help.
this is my error :

Error report -
SQL Error: ORA-01591: lock held by in-doubt distributed transaction 177.20.733689
01591. 00000 -  "lock held by in-doubt distributed transaction %s"
*Cause:    Trying to access resource that is locked by a dead two-phase commit
          transaction that is in prepared state.
*Action:  DBA should query the pending_trans$ and related tables, and attempt
          to repair network connection(s) to coordinator and commit point.
          If timely repair is not possible, DBA should contact DBA at commit
          point if known or end user for correct outcome, or use heuristic
          default if given to issue a heuristic commit or abort command to
          finalize the local portion of the distributed transaction.

this is my query result.
  SELECT LOCAL_TRAN_ID, GLOBAL_TRAN_ID, STATE, MIXED, HOST, COMMIT#
  FROM  DBA_2PC_PENDING

 
186.0.836351    1096044365.3139322E3136382E34302E31312E746D31373635393030323839    prepared    no    test-srv11    46598778142
177.20.733689    1096044365.3139322E3136382E34302E31312E746D31373633393030323839    prepared    no    test-srv11    46598777871
nuri Send private email
maandag 6 maart 2017
 
 

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics
 
Powered by FogBugz