DB2 - Problem description
Problem IT22143 | Status: Closed |
No room for retrieved log number xxx in retrieveArray during Rollfoward or Crash recovery | |
product: | |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 | |
Problem description: | |
1. Rollforward might fail with the following messages in the db2diag.log if the logs are compressed and the number of log files required for Rollforward is higher than 264 EDUID : 8822 EDUNAME: db2lfr.0 (W1P) 0 FUNCTION: DB2 UDB, data protection services, sqlpgRetrieveStartUse, probe:190 DATA #1 : <preformatted> WARNING: No room for retrieved log number 731930 in retrieveArray. Index 18446744073709551615 entryCount 264 CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol) [0] 0x0900000015C3C4CC pdLogPrintf + 0x28 [1] 0x09000000123FC008 sqlpgRetrieveStartUse__FP14sqlpMasterDbcbUiUsPUlUlPCcCUlT5 + 0x86C [2] 0x0900000011E09630 sqlpgOpenLogExtentAndUncompress__FP9SQLP_DBCBPCcPP9SQLP_LECBCUiU l + 0x678 [3] 0x0900000012400E30 sqlplfrFMOpenLog__FP12SQLPLFR_DBCBUiP21SQLPLFR_REQ_SCAN_NEXTUlPU lPP9SQLP_LECB + 0x15B4 [4] 0x0900000011E28434 sqlplfrFMReadLog__FP12SQLPLFR_DBCBP21SQLPLFR_REQ_SCAN_NEXTP17SQL PLFR_SCAN_DATA + 0x4008 [5] 0x0900000015A0F8D0 RunEDU__9sqpLfrEduFv + 0xB38 [6] 0x09000000159DD8E4 RunEDU__9sqpLfrEduFv + 0x864 2. Crash recovery might fail with the following: EDUID : 33 EDUNAME: db2lfr.0 (RON) FUNCTION: DB2 UDB, data protection services, sqlpRenameStartUse, probe:190 MESSAGE : ZRC=0x071000EA=118489322=SQLPG_EXT_COMPRESSED "Log extent is compressed." DATA #1 : <preformatted> sqlpRenameStartUse error EDUID : 33 EDUNAME: db2lfr.0 (RON) FUNCTION: DB2 UDB, data protection services, sqlpgOpenLogExtent, probe:7140 MESSAGE : ZRC=0x8710001D=-2028994531=SQLP_LERR "Fatal Logic Error" DIA8526C A fatal error occurred in data protection services. EDUID : 33 EDUNAME: db2lfr.0 (RON) FUNCTION: DB2 UDB, recovery manager, sqlplfrFMOpenLog, probe:390 MESSAGE : ZRC=0x8710001D=-2028994531=SQLP_LERR "Fatal Logic Error" DIA8526C A fatal error occurred in data protection services. DATA #1 : <preformatted> LFR Scan Num = 3 LFR Scan Caller's EDUID = 3182 Open error on log extnum 266. EDUID : 33 EDUNAME: db2lfr.0 (RON) FUNCTION: DB2 UDB, data protection services, sqlpgRetrieveStartUse, probe:190 DATA #1 : <preformatted> WARNING: No room for retrieved log number 266 in retrieveArray. Index 18446744073709551615 entryCount 264 CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol) [0] 0x00002B8BC1FA96BA pdLogVPrintf + 0x1B8 [1] 0x00002B8BC1FA9ABF pdLogPrintf + 0xF3 [2] 0x00002B8BC5DA9C07 _Z21sqlpgRetrieveStartUseP14sqlpMasterDbcbjtPmmPKctm + 0x1439 [3] 0x00002B8BC5EBC676 _Z18sqlpgOpenLogExtentP9SQLP_DBCBPKcPP9SQLP_LECBjm + 0x482 [4] 0x00002B8BC5F4D505 _Z16sqlplfrFMOpenLogP12SQLPLFR_DBCBjP21SQLPLFR_REQ_SCAN_NEXTmPmP P9SQLP_LECB + 0x262F [5] 0x00002B8BC5F2D12A _Z16sqlplfrFMReadLogP12SQLPLFR_DBCBP21SQLPLFR_REQ_SCAN_NEXTP17SQ LPLFR_SCAN_DATA + 0x424 [6] 0x00002B8BC5F3EEAF _Z28sqlplfrPrefetchNextFMReadLogP12SQLPLFR_DBCBmP21SQLPLFR_REQ_S CAN_NEXT + 0x117 [7] 0x00002B8BC5F38C09 _Z17sqlplfrDoScanNextP12SQLPLFR_DBCBP11SQLPLFR_REQ + 0x24A5 [8] 0x00002B8BC5F3C4D7 _Z10sqlplfrEduP9sqpLfrEdu + 0xB1B [9] 0x00002B8BC6172122 _ZN9sqpLfrEdu6RunEDUEv + 0x90 [10] 0x00002B8BC849E80C _ZN9sqzEDUObj9EDUDriverEv + 0x17C [11] 0x00002B8BC849E434 _Z10sqlzRunEDUPcj + 0x26 [12] 0x00002B8BC5C2222D sqloEDUEntry + 0x971 [13] 0x00002B8BBFDD2193 /lib64/libpthread.so.0 + 0x6193 [14] 0x00002B8BCF4F10DD __clone + 0x6D Conditions to hit this problem: In both scenarios a) Recovery requires more than 265 logs b) Logical logs are compressed For Crash recovery failure c) logical logs have been manually copied into the primary path (still compressed) and the number of logs is higher than 264 d) Infinite logging is enabled For rollforward failure e) If the overflowlogpath configuration parameter (or the "OVERFLOW LOG PATH" on the rollforward command) points to an archive log directory that contains compressed archived log files and the number of logs is higher than 264. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 11.1 Mod 3 Fix Pack 3 or higher * **************************************************************** | |
Local Fix: | |
DB2 will decompress logs as needed if the number of logs to decompress is higher than 264 issue the rollforward/ crash recovery again. | |
available fix packs: | |
Db2 Version 11.1 Mod 3 Fix Pack 3 for Linux, UNIX, and Windows | |
Solution | |
First fixed in Db2 11.1 Mod 3 Fix Pack 3 | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 25.08.2017 19.03.2018 19.03.2018 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |