Pin_crypt_upgrade Deadlock Error (Doc ID 1577215.1)

Last updated on JUNE 14, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.4.0.0.0 to 7.4.0.1.0 [Release 7.4.0]
Information in this document applies to any platform.
*** Checked for relevance on 06-14-2016 ***

Symptoms

The pin_crypt_upgrade is entering in deadlock when executed for a set of migrated accounts in BRM.


The following errors are being returned by pin_crypt_rewrite.pinlog:

...
0 PIN_FLD_POID           POID [0] 0.0.0.1 / -1 0
E Wed May 15 17:16:35 2013  abc5504.adm.infra  pin_crypt_rewrite:8815  pin_crypt_rewrite.c:513 1:abc5504.adm.infra:pin_crypt_rewrite:8815:-510714992:13:1368648995:166
pin_mta_worker_opcode error
<location=PIN_ERRLOC_DM:4 class="PIN_ERRCLASS_SYSTEM_DETERMINATE":1 errno=PIN_ERR_DEADLOCK:79>
<field num=PIN_FLD_RESULTS:9,51 recid=0 reserved=0 reserved2=0 time(sec:usec)=0:0>
<facility=0 msg_id=0 version=0>
E Wed May 15 17:16:35 2013  abc5504.adm.infra  pin_crypt_rewrite:8815  pin_mta.c:1052 1:abc5504.adm.infra:pin_crypt_rewrite:8815:-510714992:13:1368648995:166
normal error
<location=PIN_ERRLOC_DM:4 class="PIN_ERRCLASS_SYSTEM_DETERMINATE":1 errno=PIN_ERR_DEADLOCK:79>
<field num=PIN_FLD_RESULTS:9,51 recid=0 reserved=0 reserved2=0 time(sec:usec)=0:0>
<facility=0 msg_id=0 version=0>
...


The following errors are being returned by dm_oracle.pinlog:

..
E Wed May 15 17:16:35 2013  abc5504.adm.infra  dm:8650  dm_subr.c(146):8654 1:abc5504.adm.infra:pin_crypt_rewrite:8815:-351278192:5:1368648985:226
ORACLE error: do_sql_mr_select: PINStmtExecute: code 60, op 0
=ORA-00060: deadlock detected while waiting for resource

E Wed May 15 17:16:35 2013  abc5504.adm.infra  dm:8650  dm_search.c(105):1114 1:abc5504.adm.infra:pin_crypt_rewrite:8815:-351278192:5:1368648985:226
dm_search_rflds: do_sql_mr_select failed select   poid_DB, poid_ID0, poid_TYPE, poid_REV from bal_grp_t   where bal_grp_t.account_obj_ID0 = :1  order by bal_grp_t.poid_id0  for update of bal_grp_t.poid_id0
E Wed May 15 17:16:35 2013  abc5504.adm.infra  dm:8650  dm_ops.c(236):10341 1:abc5504.adm.infra:pin_crypt_rewrite:8815:-351278192:5:1368648985:226
op_search_and_bulk_act: dm_search_rflds() failed: err=0(PIN_ERR_NONE)
W Wed May 15 17:16:35 2013  abc5504.adm.infra  dm:8650  dm_do_ops.c(93):218 1:abc5504.adm.infra:pin_crypt_rewrite:8815:-351278192:5:1368648985:226
do_lockobj_with_template: op_search_and_bulk_act failed
W Wed May 15 17:16:35 2013  abc5504.adm.infra  dm:8650  dm_ops.c(236):4068 1:abc5504.adm.infra:pin_crypt_rewrite:8815:-351278192:5:1368648985:226
op_wflds: do_lockobj_with_template failed
E Wed May 15 17:16:35 2013  abc5504.adm.infra  dm:8650  dm_back.c(31):1440 1:abc5504.adm.infra:pin_crypt_rewrite:8815:-351278192:5:1368648985:226
DMbe #181: process_op: op 5(PCM_OP_WRITE_FLDS), err 79(PIN_ERR_DEADLOCK)
M Wed May 15 17:16:35 2013  abc5504.adm.infra  dm:8673  dm_search.c(105):2912 1:abc5504.adm.infra:pin_crypt_rewrite:8815:-510714992:5:1368648995:168
in update size is 1000 (default)
...

  

 

  

Cause

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 hundreds of Community platforms