My Oracle Support Banner

dm_oracle Produces a Core Dump when Using PCM_OP_BULK_DELETE_OBJ to Delete More than 25 Distinct Events (Doc ID 1677141.1)

Last updated on JULY 03, 2018

Applies to:

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

Symptoms

The dm_oracle process is core dumping upon invoking PCM_OP_BULK_DELETE_OBJ opcode on /event objects where the count of distinct events (POIDs) to be deleted is > 20 events.

Example

  1. Create an account and make sure it has more than 20 distinct events poids.
  2. Using testnap, try to remove all the event types for the above account with following opcode & flist

    nap(11986)> r << XXX 1
    0 PIN_FLD_POID POID [0] 0.0.0.1 /event -1 0
    0 PIN_FLD_TEMPLATE STR [0] "delete X for /event where F1 = V1 "
    0 PIN_FLD_FLAGS INT [0] 256
    0 PIN_FLD_ARGS ARRAY [1]
    1 PIN_FLD_ACCOUNT_OBJ POID [0] 0.0.0.1 /account 494842693 0
    XXX


    nap(11986)> xop PCM_OP_BULK_DELETE_OBJ 0 1
This generates an error in the cm.pinlog
 

Op (PCM_OP_BULK_DELETE_OBJ) receive failed in pcm_op
<location=PIN_ERRLOC_PCP:2 class="PIN_ERRCLASS_SYSTEM_RETRYABLE":3 errno=PIN_ERR_STREAM_EOF:50>
<field num=0:0,0 recid=0 reserved=0 reserved2=257 time(sec:usec)=0:0>
<facility=0 msg_id=0 version=0>

This also generates an error in the dm_oracle.pinlog

E Thu Nov 3 09:30:11 2011 sjbmbe348.corp.webex.com dm:5735 dm_main.c(63):2737 1:sjbmbe348.corp.webex.com:dm:5735:-1786756864:0:1381254193:0
DM(master) respawning backend child for slot 18
E Thu Nov 3 09:30:11 2011 sjbmbe348.corp.webex.com dm:5735 dm_main.c(63):1108 1:sjbmbe348.corp.webex.com:dm:5735:-1786756864:0:1381254193:0
DM(master) respawned backend child for slot 18, pid 5194

And forces dm_oracle to coredump, the dm_oracle.log shows :

DM(26565) got SIGV...
/BRM/portal/brmuat11/webexBRM/opt/portal/7.5/bin/dm_oracle(print_traceback+0x15)[0x415bd9]
/BRM/portal/brmuat11/webexBRM/opt/portal/7.5/bin/dm_oracle(sigsegv_handler+0x54)[0x40d684]
/lib64/tls/libc.so.6[0x3bd132e330]
/lib64/tls/libc.so.6(strstr+0x13)[0x3bd1371ac3]
/BRM/portal/brmuat11/webexBRM/opt/portal/7.5/sys/dm_oracle/dm_oracle10g64.so(populate_poid_list+0x48)[0x2b1587ebb3]
/BRM/portal/brmuat11/webexBRM/opt/portal/7.5/sys/dm_oracle/dm_oracle10g64.so(dm_search_rflds+0x177c)[0x2b1587ca71]
/BRM/portal/brmuat11/webexBRM/opt/portal/7.5/sys/dm_oracle/dm_oracle10g64.so(op_search_and_bulk_act+0x84c1)[0x2b158a06e7]
/BRM/portal/brmuat11/webexBRM/opt/portal/7.5/sys/dm_oracle/dm_oracle10g64.so(dm_if_process_op+0xd2f)[0x2b15854851]
/BRM/portal/brmuat11/webexBRM/opt/portal/7.5/bin/dm_oracle(process_op+0x265)[0x4077e2]
/BRM/portal/brmuat11/webexBRM/opt/portal/7.5/bin/dm_oracle(dm_back_select_stuff+0x8b8)[0x406e56]
/BRM/portal/brmuat11/webexBRM/opt/portal/7.5/bin/dm_oracle(dm_back+0x60c)[0x4074d2]
/BRM/portal/brmuat11/webexBRM/opt/portal/7.5/bin/dm_oracle(make_a_child+0x2c6)[0x40e668]
/BRM/portal/brmuat11/webexBRM/opt/portal/7.5/bin/dm_oracle(main+0x2835)[0x411596]
/lib64/tls/libc.so.6(__libc_start_main+0xdb)[0x3bd131c4fb]
/BRM/portal/brmuat11/webexBRM/opt/portal/7.5/bin/dm_oracle[0x40591a]
DM(26521) sigchld: back end 10, pid 26565, stat 0xb00

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.