Ora-07445: [Kdzsbuffercupiece()+35] [11] [0x000000000] On Cell Server (Doc ID 1349167.1)

Last updated on APRIL 09, 2020

Applies to:

Symptoms

Getting ORA-07445: [KDZSBUFFERCUPIECE()+35] [11] [0X000000000] from cell causing CELLSRV process to terminate and then a "plan step" and "disk region" is quarantined.

The cell server alerthistory shows following

name: 150
alertMessage: "ORA-7445: exception encountered: core dump
[kdzsBufferCUPiece()+35] [11] [0x000000000] [] [] []"
alertSequenceID: 150
alertShortName: ADR
alertType: Stateless
beginTime: 2010-12-29T11:19:42+09:00
endTime:
examinedBy:
notificationState: 1
sequenceBeginTime: 2010-12-29T11:19:42+09:00
severity: critical
alertAction: "Errors in file
/opt/oracle/cell11.2.2.2.0_LINUX.X64_101206.2/log/diag/asm/cell/<cell host>/t
race/svtrc_13745_100.trc (incident=713). Please create an incident package
for incident 713 using ADRCI and upload the incident package to Oracle
Support. This can be done as shown below. From a shell session on cell

name: 151_1
alertMessage: "A SQL PLAN quarantine has been added. As a result,
Smart Scan is disabled for SQL statements with the quarantined SQL plan.
Quarantine id : 1 Quarantine type : SQL PLAN Quarantine reason :
alertSequenceID: 151
alertShortName: Software
alertType: Stateful
beginTime: 2010-12-29T11:20:30+09:00
examinedBy:
metricObjectName: QUARANTINE/1
notificationState: 1
sequenceBeginTime: 2010-12-29T11:20:30+09:00
severity: critical

The cell alert log shows following:

Errors in file /opt/oracle/cell11.2.2.2.0_LINUX.X64_101206.2/log/diag/asm/cell/<CELL_SERVER_NAME>/trace/svtrc_13745_100.trc (incident=713):
ORA-07445: exception encountered: core dump [kdzsBufferCUPiece()+35] [11] [0x000000000] [] [] []
Incident details in: /opt/oracle/cell11.2.2.2.0_LINUX.X64_101206.2/log/diag/asm/cell/<CELL_SERVER_NAME>/incident/incdir_713/svtrc_13745_100_i713.trc
Exception [type: 11] [ADDR:0x0]
QuarantineMgr: quarantining plan step {4053132994, 17} DBID: 2814020554 DBName: CFSD quaID: 1 threadID: 100
QuarantineMgr: quarantining disk region {DATA_CD_06_<CELL_SERVER_NAME>, 303443214336, 1M} DBID: 2814020554 DBName: CFSD quaID: 2 threadID 100

The trace contains following stack:

[00]: dbgeEndDDEInvocation [diag_dde]
[01]: ossex_exception_handler []
[02]: __sighandler []
[03]: kdzsBufferCUPiece []<-- Signaling
[04]: sageDataGetCUMinMax [SAGE_Data]
[05]: oracle_storidx_compute_ridx_sum []
[06]: sageDataRIdxComputeStats [SAGE_Data]
[07]: oracle_storidx_compute_region_s []
[08]: oracle_storidx_compute_region_s []
[09]: _ZN10StorageIdx33computeSummary []
[10]: _ZN15PredicateFilter20postFilte []
[11]: _ZN15PredicateFilter19processCo []
[12]: _ZN15PredicateFilter7processEv []
[13]: _ZN10UserThread8mainLoopEv []
[14]: _ZN10UserThread3runEv []
[15]: _ZN9Scheduler8scheduleEv []
[16]: _Z16kernelThreadMainPv []
[17]: oracle_fp_thread_main [FPLIB_MAIN]
[18]: start_thread []
[19]: clone []
[20]: 0000000000000000 []

Cause

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