DB2 - Problem description
Problem IT33146 | Status: Closed |
DB2 SERVER TERMINATES ABNORMALLY DURING ROLLFORWARD RECOVERY IN THE SQLPLRQ FUNCTION WITH DB2_4K_DEVICE_SUPPORT=ON SET. | |
product: | |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 | |
Problem description: | |
During rollforward recovery, Db2 may need to restore a load copy. If there are any LOB columns in the load copy, we will attempt to perform extra serialization to avoid corruption of LOB data when DB2_4K_DEVICE_SUPPORT=ON is set. However, the preconditions for the Db2 lock manager are not met, resulting in a panic. The following stack will be generated in this case: [0] 0x00007FD480220611 sqloPGRPRegisterOneCrash + 0x221 [1] 0x00007FD4803A7026 sqloEDUCodeTrapHandler + 0xAB6 [2] 0x00007FD48913A630 /lib64/libpthread.so.0 + 0xF630 [3] 0x00007FD48065EC72 _Z7sqlplrqP9sqeBsuEduP14SQLP_LOCK_INFO + 0xD2 [4] 0x00007FD479145D12 _Z18sqlbDMSMapAndWriteP16SQLB_OBJECT_DESC14SQLB_AS_SCHEMEjtP12SQ LB_POOL_CBPllPjS5_lPcS5_P12SQLB_GLOBALS + 0x1A92 [5] 0x00007FD479143310 _Z18sqlbDMSDirectWriteP20SQLB_DIRECT_WRITE_CB + 0x1280 [6] 0x00007FD4791B55D5 _Z15sqlbDirectWriteP20SQLB_DIRECT_WRITE_CB + 0x955 [7] 0x00007FD478EC3CC8 _Z29sqlbServiceDirectWriteRequestP11SQLB_pfMisc + 0x2D8 [8] 0x00007FD478EBBA0B _Z26sqlbPFPrefetcherEntryPointP16sqbPrefetcherEdu + 0xD9B [9] 0x00007FD478EBABE4 _ZN16sqbPrefetcherEdu6RunEDUEv + 0x24 [10] 0x00007FD481F4302E _ZN9sqzEDUObj9EDUDriverEv + 0x1BE [11] 0x00007FD4803A3DD9 sqloEDUEntry + 0x589 [12] 0x00007FD489132EA5 /lib64/libpthread.so.0 + 0x7EA5 [13] 0x00007FD4750D68DD clone + 0x6D | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * All environments using DB2_4K_DEVICE_SUPPORT. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 11.5 m4 fp0 or later. * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 10.06.2020 30.06.2020 30.06.2020 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |