My Oracle Support Banner

Deadlocks On BAL_GRP_T Table (Doc ID 2030335.1)

Last updated on JULY 08, 2018

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.3.1.0.0 to 7.5.0.0.0 [Release 7.3.1 to 7.5.0]
Information in this document applies to any platform.

Symptoms

On :  7.3.1.0.0 version, Balances

 

Deadlocks are occurring at different times, the select for update on bal_grp_t is causing a problem.

When the account has many service level balance groups, and concurrent operations are being carried out on the service level balance groups of same account, the deadlock is occurring. This occurring at different times.

cm.pinlog

# number of field entries allocated 20, used 1
0 PIN_FLD_POID           POID [0] 0.0.0.1 /event/notification/transaction/abort -1 0
W 2015-06-04 15:56:51.021  machine1  cm:1939.1  cm_utils.c(118):1689 1:machine1:cm:10481:1:1301:1433404611:1
        CM DM->FM opcode PCM_OP_PUBLISH_GEN_PAYLOAD, opflags=0x0
# number of field entries allocated 20, used 1
0 PIN_FLD_POID           POID [0] 0.0.0.1 /event/notification/transaction/abort -1 0
D 2015-06-04 15:56:51.021  machine1  cm:1939.1  fm_utils_publish.c:304 1:machine1:cm:10481:1:1301:1433404611:1
        Cleaning up state_infop
D 2015-06-04 15:56:51.021  machine1  cm:1939.1  fm_trans_pol_abort.c:115 1:machine1:cm:10481:1:1301:1433404611:1
        op_trans_pol_abort return flist
# number of field entries allocated 20, used 1
0 PIN_FLD_POID           POID [0] 0.0.0.1 /balance_group 15859667 0
D 2015-06-04 15:56:51.021  machine1  cm:1939.1  cm_utils_trans.c(14):362 1:machine1:cm:10481:1:1301:1433404611:1
        fm_utils_trans_abort returning
E 2015-06-04 15:56:51.021  machine1  cm:1939.1  cm_child.c(109):4661 1:machine1:cm:10481:1:1301:1433404611:1
        op PCM_OP_PYMT_DEBIT returned an error
        <location=PIN_ERRLOC_FM:5 class="PIN_ERRCLASS_SYSTEM_DETERMINATE":1 errno=PIN_ERR_CREDIT_LIMIT_EXCEEDED:81>
        <field num=0:0,0 recid=0 reserved=105 reserved2=0 time(sec:usec)=0:0>
        <facility=0 msg_id=0 version=0>

 

dm_oracle.pinlog

 

D 2015-06-04 15:56:50.811  machine1  cm:1939.1  cm_utils.c(118):4326 1:machine1:testnap:1936:1:105:1433404610:1
        DEBUG: cm_pre_lockobj:  opcode(PCM_OP_READ_FLDS), opflg(132096)
 W 2015-06-04 15:56:50.811  machine1  cm:1939.1  cm_utils.c(118):4686 1:machine1:testnap:1936:1:105:1433404610:1
        WARNING, Lock flag specified for op and object already locked in trans. Skipping lock.  Opcode(PCM_OP_READ_FLDS), opflg(0x20400)


ACTUAL BEHAVIOR  
---------------
Deadlocks are observed on global-enqueue of the database.
user session for deadlock lock 0x2f1a470278
sid: 3015 ser: 35045 audsid: 129609086 user: 119/PIN
flags: (0x8100045) USR/- flags_idl: (0x1) BSY/-/-/-/-/-
flags2: (0x40009) -/-/INC
pid: 559 O/S info: user: grid, term: UNKNOWN, ospid: 104244
image: oracle@machine1
client details:
O/S info: user: pin, term: , ospid: 29420
machine: machine1 program: dm_oracle@machine (TNS V1-V3)
application name: dm_oracle@machine1 (TNS V1-V3), hash value=3882011342
current SQL:
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
DUMP LOCAL BLOCKER: initiate state dump for DEADLOCK
possible owner[xxxx] on resource TX-0xxx00D-0000D789
 

EXPECTED BEHAVIOR
-----------------------
Deadlocks should not occur.


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!


In this Document
Symptoms
Cause
Solution
References


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