SIGSEGV Issue On PCM_OP_SEARCH (Doc ID 2121954.1)

Last updated on APRIL 30, 2016

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

If the /event class has extended classes with many arrays, PCM_OP_SEARCH is causing dm_oracle to crash with SIGSEGV leading to PCP errors in CM.

dm_oracle.log:

SQL_STMT dm_search_rflds: doing "select event_t.poid_DB, event_t.poid_ID0, event_t.poid_TYPE, event_t.poid_REV from event_t ,event_session_custom_t where event_t.poid_TYPE = :1 and event_session_custom_t.req_id = :2 and event_t.poid_id0 = event_session_custom.obj_id0 and ((event_t.poid_ID0 >= :3 and event_t.poid_ID0 < :4)) "
DDD dm_search_rflds_sub: poid id = 284078620246098967
DDD remap_poid_type: input type , real type /event/session/custom
DDD remap_poid_type: tablename set to 0x25386910, colcnt to 80
DDD op_rflds ENTRY o_flist 0x9270d30, record_id 0, rid2 0
# number of field entries allocated 20, used 1
0 PIN_FLD_POID POID [0] 0.0.0.1 /event/session/custom 284078620246098967 0
DDD *******
DDD op_rflds 1 doing N (1) for 13322
DDD op_rflds ENTRY o_flist 0x9270d30, record_id 0, rid2 0
# number of field entries allocated 20, used 1
0 PIN_FLD_POID POID [0] 0.0.0.1 /event/session/custom 284078620246098967 0
DDD *******
DDD op_rflds 1 doing N (1) for 16
DM(8478) got SIGV...
/portal/7.5/bin/dm_oracle(print_traceback+0x15)[0x4160a9]


cm.pinlog:

----
Op (PCM_OP_SEARCH) 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>

----

 

Example Test case:


1) Extend /event class with sub class having multiple arrays like below and execute PCM_OP_SEARCH opcode.
.
# number of field entries allocated 20, used 6
0 PIN_FLD_POID POID [0] 0.0.0.1 /search -1 0
0 PIN_FLD_FLAGS INT [0] 512
0 PIN_FLD_TEMPLATE STR [0] "select X from /event/session/custom
where F1 = V1 and F2 = V2"
0 PIN_FLD_ARGS ARRAY [1] allocated 20, used 1
1 SIR_FLD_M_COMMON_USAGE_DETAILS ARRAY [0] allocated 20, used 1
2 SIR_FLD_M_TRANS_ID STR [0] "586"
0 PIN_FLD_ARGS ARRAY [2] allocated 20, used 1
1 SIR_FLD_M_COMMON_USAGE_DETAILS ARRAY [0] allocated 20, used 1
2 SIR_FLD_M_EVENT_LOG_SUBTYPE STR [0] "Customer"
0 PIN_FLD_RESULTS ARRAY [*] NULL array ptr
--
2) Verify that dm_oracle gets terminated with SIGSEGV signal ( Segmentation fault).

 

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