DB2 - Problem description
Problem IT29634 | Status: Closed |
INTERRUPTING ROLLFORWARD OPERATIONS DURING REPLAY CAN CAUSE SUBSEQUENT ROLLFORWARD TO FAIL | |
product: | |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 | |
Problem description: | |
Restarting the standby database during replay might fail indicated by the following db2diag.log message: FUNCTION: DB2 UDB, data management, sqldRedoUpsert, probe:2251 MESSAGE : Free Space does not match during redo! DATA #1 : String, 11 bytes insinfo_lr: DATA #2 : Hexdump, 26 bytes 0x00007F6CBC03A5A0 : 01A2 2A00 6405 0000 2A00 203B 0400 0000 ..*.d...*. ;.... 0x00007F6CBC03A5B0 : 0000 2A3B 0000 2A00 0100 ..*;..*... DATA #3 : String, 11 bytes Space used: DATA #4 : signed integer, 4 bytes 42 CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol) [0] 0x00007FEF403F60D3 /db2/db2pb3/sqllib/lib64/libdb2e.so.1 + 0x224A0D3 [1] 0x00007FEF403E8FA2 _Z8sqldRedoP8sqeAgentP8SQLD_LRHP9SQLP_LSN8mmm + 0x1A52 [2] 0x00007FEF403B2001 _Z8sqldmrdoP8sqeAgenttP9SQLP_LSN8PcmmmmP8SQLP_TIDP15SQLD_RECOV_I NFO + 0xD01 [3] 0x00007FEF45939B4B _Z13sqlpRecDbRedoP8sqeAgentP8SQLP_ACBP14sqlpMasterDbcbP10SQLP_FR APPP11SQLP_TENTRYP16SQLPR_LOGREC_DISP10REDO_INPUT + 0x273B [4] 0x00007FEF45937073 _Z15sqlpPRecProcLogP8sqeAgentP8SQLP_ACBP14sqlpMasterDbcb + 0x14D3 [5] 0x00007FEF458F479E _Z20sqlpParallelRecoveryP8sqeAgentP5sqlca + 0xF6E [6] 0x00007FEF437BB24C _Z26sqleSubCoordProcessRequestP8sqeAgent + 0x17C [7] 0x00007FEF437D80AE _ZN8sqeAgent6RunEDUEv + 0x5AE [8] 0x00007FEF470F8CBE _ZN9sqzEDUObj9EDUDriverEv + 0x1BE [9] 0x00007FEF4561EE1A sqloEDUEntry + 0x57A [10] 0x00007FEF4D1B5DD5 /lib64/libpthread.so.0 + 0x7DD5 [11] 0x00007FEF3CC59B3D clone + 0x6D Other cases include crash recovery or rollforward operations. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 11.5 Mod 2 Fixpack 0 or higher * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
BUG-Tracking | |
forerunner : IT29633 follow-up : | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 05.07.2019 18.02.2020 18.02.2020 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |