LOAD of small MDC table may fail during internal operation
"purge object pages from bufferpool", in
sqlbPurgeOrFlushAllPagesInSmallRange with error
SQLB_EMP_MAP_INFO_NOT_FOUND.
If this failure occurs during transaction commit time, it may
cause DB shutdown and subsequent crash recovery failure.
Errors in db2diag.log file point to:
2021-07-18-07.34.21.800184-240 I132233293E567 LEVEL: Error
PID : 406232 TID : 46914707908352 PROC : db2sysc
3
INSTANCE: db2inst1 NODE : 003 DB : SAMPLE
APPHDL : 1-28840 APPID:
xx.xxx.xx.xx.52150.210718113415
AUTHID : DB2INST1 HOSTNAME: MYHOST1
EDUID : 6176 EDUNAME: db2agnta (SAMPLE) 3
FUNCTION: DB2 UDB, buffer pool services, sqlbDMSMapObj2Pool,
probe:840
MESSAGE : ZRC=0x8402001B=-2080243685=SQLB_EMP_MAP_INFO_NOT_FOUND
"EMP MAP INFO NOT FOUND"
2021-07-18-07.34.21.801096-240 I132233293E567 LEVEL: Error
PID : 406232 TID : 46914707908352 PROC : db2sysc
3
INSTANCE: db2inst1 NODE : 003 DB : SAMPLE
APPHDL : 1-28840 APPID:
xx.xxx.xx.xx.52150.210718113415
AUTHID : DB2INST1 HOSTNAME: MYHOST1
EDUID : 6176 EDUNAME: db2agnta (SAMPLE) 3
FUNCTION: DB2 UDB, buffer pool services,
sqlbPurgeOrFlushAllPagesInSmallRange, probe:8940
MESSAGE : ZRC=0x8402001B=-2080243685=SQLB_EMP_MAP_INFO_NOT_FOUND
"EMP MAP INFO NOT FOUND"
DATA #1 : String, 38 bytes
Error mapping object page to pool page
...
CALLSTCK: (Static functions may not be resolved correctly, as
they are resolved to the nearest symbol)
[0] 0x00002AAAAD281EA2
_Z36sqlbPurgeOrFlushAllPagesInSmallRangeP16SQLB_OBJECT_DESCP22SQ
LB_OBJECT_PAGE_RANGEjjP12SQLB_GLOBALS + 0x18F2
[1] 0x00002AAAAD27FFDA
_Z20sqlbPurgeObjectLocalP16SQLB_OBJECT_DESCjP12SQLB_GLOBALSj +
0x62A
[2] 0x00002AAAAD27EEBD
_Z15sqlbPurgeObjectP16SQLB_OBJECT_DESCjP12SQLB_GLOBALSjb + 0x41D
[3] 0x00002AAAB3E4C4F2
_Z15sqluPurgeObjectP16SQLB_OBJECT_DESCjP10sqluCTableP16SQLU_GROU
P_PURGEj + 0x242
[4] 0x00002AAAB3EC007D
_Z22sqluCheckObjectForRedoP8sqeAgentP9SQLP_LSN8P11SQLB_OBJECTS2_
PiS5_PbS5_iiib + 0x3DD
[5] 0x00002AAAB3EC61C5
/var/ibmdb2/nypxt150/sqllib/lib64/libdb2e.so.1 + 0x8A541C5
[6] 0x00002AAAB3EBE035
_Z30sqlu_process_pending_operationP8sqeAgentiPcP9SQLP_LSN8P12SQL
P_PENLISTPjP15SQLD_RECOV_INFO + 0x545
[7] 0x00002AAAB2A12935 _Z8sqlptpplP8sqeAgentiPb + 0x425
[8] 0x00002AAAB29F7EB0
_Z8sqlpxcm2P8sqeAgentjP15SQLXA_CALL_INFOiP8SQLP_VTSP9SQLP_GXID +
0xA20
[9] 0x00002AAAB2FDCC27 _Z17sqlrr_tran_routerP8sqlrr_cb +
0x1327
[10] 0x00002AAAB2FAD572
_Z21sqlrr_subagent_routerP8sqeAgentP12SQLE_DB2RA_T + 0x962
[11] 0x00002AAAB0A87546
/var/ibmdb2/nypxt150/sqllib/lib64/libdb2e.so.1 + 0x5615546
[12] 0x00002AAAB0A85DE0 _Z21sqleProcessSubRequestP8sqeAgent +
0x3E0
[13] 0x00002AAAB0ABB057 _ZN8sqeAgent6RunEDUEv + 0x5D7
[14] 0x00002AAAB43F4F5E _ZN9sqzEDUObj9EDUDriverEv + 0x1BE
[15] 0x00002AAAB2912A6A sqloEDUEntry + 0x57A
[16] 0x00002AAAAAED6AA1 /lib64/libpthread.so.0 + 0x7AA1
[17] 0x00002AAABB469C4D clone + 0x6D
the above example occurs during transaction commit time. If it
occurs during crash recovery, we get similar message from
db2redom, with call stack
CALLSTCK: (Static functions may not be resolved correctly, as
they are resolved to the nearest symbol)
[0] 0x00002AAAAD281EA2
_Z36sqlbPurgeOrFlushAllPagesInSmallRangeP16SQLB_OBJECT_DESCP22SQ
LB_OBJECT_PAGE_RANGEjjP12SQLB_GLOBALS + 0x18F2
[1] 0x00002AAAAD27FFDA
_Z20sqlbPurgeObjectLocalP16SQLB_OBJECT_DESCjP12SQLB_GLOBALSj +
0x62A
[2] 0x00002AAAAD27EEBD
_Z15sqlbPurgeObjectP16SQLB_OBJECT_DESCjP12SQLB_GLOBALSjb + 0x41D
[3] 0x00002AAAB3E4C4F2
_Z15sqluPurgeObjectP16SQLB_OBJECT_DESCjP10sqluCTableP16SQLU_GROU
P_PURGEj + 0x242
[4] 0x00002AAAB3EC007D
_Z22sqluCheckObjectForRedoP8sqeAgentP9SQLP_LSN8P11SQLB_OBJECTS2_
PiS5_PbS5_iiib + 0x3DD
[5] 0x00002AAAB3EC61C5
/var/ibmdb2/nypxt150/sqllib/lib64/libdb2e.so.1 + 0x8A541C5
[6] 0x00002AAAB3EBE035
_Z30sqlu_process_pending_operationP8sqeAgentiPcP9SQLP_LSN8P12SQL
P_PENLISTPjP15SQLD_RECOV_INFO + 0x545
[7] 0x00002AAAB2A12935 _Z8sqlptpplP8sqeAgentiPb + 0x425
[8] 0x00002AAAB2C34F73
_Z10sqlpRFWpplP8sqeAgentP9SQLP_DBCBP11SQLP_TENTRYP10SQLP_FRAPPP1
0SQLP_FRSCBP9SQLP_LSN8 + 0x53
[9] 0x00002AAAB2C3118F
_Z13sqlpRecDbRedoP8sqeAgentP8SQLP_ACBP14sqlpMasterDbcbP10SQLP_FR
APPP11SQLP_TENTRYP16SQLPR_LOGREC_DISP10REDO_INPUT + 0xA1F
[10] 0x00002AAAB2C263C1
_Z15sqlprProcDPSrecP10SQLPR_PRCBjP20SQLPR_PR_QUEUE_ENTRY + 0x271
[11] 0x00002AAAB2C1F233
_Z15sqlpPRecReadLogP8sqeAgentP8SQLP_ACBP14sqlpMasterDbcb + 0x773
[12] 0x00002AAAB2BECC76
_Z20sqlpParallelRecoveryP8sqeAgentP5sqlca + 0xCA6
[13] 0x00002AAAB0A9E11C
_Z26sqleSubCoordProcessRequestP8sqeAgent + 0x17C
[14] 0x00002AAAB0ABB02E _ZN8sqeAgent6RunEDUEv + 0x5AE
[15] 0x00002AAAB43F4F5E _ZN9sqzEDUObj9EDUDriverEv + 0x1BE
[16] 0x00002AAAB2912A6A sqloEDUEntry + 0x57A
[17] 0x00002AAAAAED6AA1 /lib64/libpthread.so.0 + 0x7AA1
[18] 0x00002AAABB469C4D clone + 0x6D |
