| another ORA-01591: lock held by in-doubt distributed transaction xx problem [message #304953] |
Fri, 07 March 2008 05:23  |
fozerol
Messages: 17
Registered: March 2007
|
Junior Member |
|
|
Hello
main database shutdown abnormally because of power problem
after that, database startup normally
but there is pending transactions when i update or delete specific row with statement
update rezervasyonlar set durum=3 where rezervasyonid=2950335
error occurs
ORA-01591: lock held by in-doubt distributed transaction 3.3.142964
here is brief dba_2pc_pending query result
select local_tran_id, global_tran_id, state, mixed, host, commit# from dba_2pc_pending
3.3.142964
1145324612.C4FD65EB567392428453748509853C8000000000
prepared no
WORKGROUP\KKBSNET
5967368082522
i try to force commit and rolback with the statement
commit force '3.3.142964'
and
rollback force '3.3.142964'
and
commit force <GLOBAL_TANSAC_ID>
nothing changed
and last try to purge with
EXECUTE DBMS_TRANSACTION.PURGE_LOST_DB_ENTRY('3.3.142964');
error occured when i execute this statement
BEGIN dbms_transaction.purge_lost_db_entry('3.3.142964'); END;
Error at line 1
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "SYS.DBMS_TRANSACTION", line 94
ORA-06512: at line 1
any suggestion will be appreciated
thanks
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
