BRM: Deadlock Errors When Opcodes Are Executed Concurrently To Update The Same Account (Doc ID 1347924.1)

Last updated on JULY 15, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.3.1.0.0 and later
Information in this document applies to any platform.
Checked for relevance on 10-Jul-2013

Symptoms

An error message PIN_ERR_DEADLOCK is observed when opcodes are executed concurrently for the same account.
So far, it is observed for product cancellation (PCM_OP_SUBSCRIPTION_CANCEL_PRODUCT) and subscription transfer (PCM_OP_SUBSCRIPTION_TRANSFER_SUBSCRIPTION) scenarios in production.

Snippet of cm.pinlog
---------------------------

D Mon Jan 17 15:32:05 2011 Server_name cm:2041 fm_bill_utils_config.c:87 1:S02BF193:cm:22322:1:1301:1302762405:4
   ##### op_bill_utils_prep_lock_obj(): output flist
# number of field entries allocated 20, used 2
0 PIN_FLD_POID POID [0] 0.0.0.1 /billinfo 156029263 0
0 PIN_FLD_LOCK_INFO SUBSTRUCT [0] allocated 20, used 2
1    PIN_FLD_TEMPLATE STR [0] "select X from /balance_group where F1 = V1 order by bal_grp_t.poid_id0 "
1    PIN_FLD_ARGS ARRAY [1] allocated 20, used 1
2       PIN_FLD_BILLINFO_OBJ POID [0] 0.0.0.1 /billinfo 156029263 0
D Mon Jan 17 15:32:07 2011 Server_name cm:2039 pcm.c(54):862 1:S02BF193:cm:22322:1:1301:1302762405:4
   pcm_op: cannot retry PCM_OP_LOCK_OBJ, flags 0x20000 - in a transaction - state=2
E Mon Jan 17 15:32:07 2011 Server_name cm:2039 cm_utils_trans.c(14):205 1:S02BF193:cm:22322:1:1301:1302762405:4
   Error:79(PIN_ERR_DEADLOCK) in fm_utils_trans_lock_obj: trying to lock object
E Mon Jan 17 15:32:07 2011 Server_name cm:2039 cm_utils_trans.c(14):165 1:S02BF193:cm:22322:1:1301:1302762405:4
   fm_utils_trans_open error
   <location=PIN_ERRLOC_DM:4 class=UNKNOWN:0 errno=PIN_ERR_DEADLOCK:79>
   <field num=0:0,0 recid=0 reserved=0 reserved2=0 time(sec:usec)=0:0>
   <facility=0 msg_id=0 version=0>
D Mon Jan 17 15:32:07 2011 Server_name cm:2039 cm_utils_trans.c(14):169 1:S02BF193:cm:22322:1:1301:1302762405:4
   fm_utils_trans_open returning
E Mon Jan 17 15:32:07 2011 Server_name cm:2039 fm_subscription_cycle_fold.c:385 1:S02BF193:cm:22322:1:1301:1302762405:4
   op_subscription_cycle_fold error
   <location=PIN_ERRLOC_DM:4 class=UNKNOWN:0 errno=PIN_ERR_DEADLOCK:79>
   <field num=0:0,0 recid=0 reserved=0 reserved2=0 time(sec:usec)=0:0>
   <facility=0 msg_id=0 version=0>
E Mon Jan 17 15:32:07 2011 Server_name cm:2039 fm_subscription_pol_prep_fold.c:367 1:S02BF193:cm:22322:1:1301:1302762405:4
   op_subscription_pol_prep_fold error
   <location=PIN_ERRLOC_DM:4 class=UNKNOWN:0 errno=PIN_ERR_DEADLOCK:79>
   <field num=0:0,0 recid=0 reserved=0 reserved2=0 time(sec:usec)=0:0>
   <facility=0 msg_id=0 version=0>
D Mon Jan 17 15:32:07 2011 Server_name cm:2039 fm_subscription_cycle_forward.c:1244 1:S02BF193:cm:22322:1:1301:1302762405:4
   op_subscription_cycle_prep_fold return flist
NULL flist ptr
E Mon Jan 17 15:32:07 2011 Server_name cm:2039 fm_subscription_cycle_forward.c:1290 1:S02BF193:cm:22322:1:1301:1302762405:4
   op_subscription_cycle_forward error
   <location=PIN_ERRLOC_DM:4 class=UNKNOWN:0 errno=PIN_ERR_DEADLOCK:79>
   <field num=0:0,0 recid=0 reserved=0 reserved2=0 time(sec:usec)=0:0>
   <facility=0 msg_id=0 version=0>
E Mon Jan 17 15:32:07 2011 Server_name cm:2039 fm_subscription_prodinfo.c:2063 1:S02BF193:cm:22322:1:1301:1302762405:4
   fm_subs_prodinfo_apply_cycle_fees error
   <location=PIN_ERRLOC_DM:4 class=UNKNOWN:0 errno=PIN_ERR_DEADLOCK:79>
   <field num=0:0,0 recid=0 reserved=0 reserved2=0 time(sec:usec)=0:0>
   <facility=0 msg_id=0 version=0>

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