My Oracle Support Banner

RDBPROD: DECdtm hangs on 2PC transaction with Rdb and Oracle on constraint violation (Doc ID 340031.1)

Last updated on OCTOBER 27, 2017

Applies to:

Oracle Rdb Server on OpenVMS - Version 7.0.1 to 7.2.2 [Release 7.0 to 7.2]
HP OpenVMS Itanium
HP OpenVMS Alpha

Symptoms

2pc transaction:

   insert into oracle-table;
   delete from rdb-table@rdb-dblink;
   commit;

hangs as an in-doubt transaction when a deferred constraint on rdb-table@rdb-dblink is violated as a result of the delete.

EXAMPLE:

PL/SQL Release 8.0.6.3.0 - Production
SQL> insert into idd_commit values ('0001',2,3,4,5,6);
1 row created.

SQL> select * from colleges@test72 where college_code ='PRDU';
COLL COLLEGE_NAME              CITY                 ST POSTA
---- ------------------------- -------------------- -- -----
PRDU Purdue University         West Lafayette       IN 47907

SQL> delete from colleges@test72 where college_code ='PRDU';
1 row deleted.

SQL> commit;
commit
*
ERROR at line 1:
ORA-02054: transaction 8.42.847263 in-doubt
ORA-02290: check constraint (.DEGREES_FOREIGN2) violated
%RDB-E-LOCK_CONFLICT, request failed due to locked resource
-RDMS-F-TIMEOUT, timeout on record 106:1554:0
-COSI-W-CANCEL, operation canceled
ORA-02063: preceding 4 lines from TEST72

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.