DB2 - Problem description
Problem IT31716 | Status: Closed |
ON RARE OCCASION, DATA CORRUPTION MIGHT BE INDUCED BY FAILURE TOPANIC THE DATABASE ON ENCRYPTION ERROR. | |
product: | |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 | |
Problem description: | |
On rare occasion, db2 might report ECF_CRYPT_UNEXPECTED_ERROR and/or SQLEX_UNEXPECTED_SYSERR when doing page IOs with the following stack for an encrypted database, these errors in this code path are severe enough to panic the system right away, however, db2 continues on page IOs which results in corrupted data pages. 2020-01-27-19.24.05.875563-300 I112139129A2028 LEVEL: Error PID : 64684174 TID : 9768 PROC : db2sysc 0 INSTANCE: XXXXXX NODE : 000 DB : XXXXX HOSTNAME: XXXXX EDUID : 9768 EDUNAME: db2pclnr (TDSCCD01) 0 FUNCTION: DB2 Common, Cryptography, cryptDigestHP, probe:725 MESSAGE : ECF=0x90000403=-1879047165=ECF_CRYPT_UNEXPECTED_ERROR Unexpected cryptographic error DATA #1 : Hex integer, 4 bytes 0xFFFFFFFE CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol) [0] 0x0900000014CDCEC4 pdOSSeLoggingCallback + 0x59C [1] 0x090000000DED36FC oss_log__FP9OSSLogFacUiN32UlN26iPPc + 0x1BC [2] 0x090000000DED3500 ossLog + 0xA0 [3] 0x0900000016D14B38 cryptLogICCError + 0x180 [4] 0x0900000017C14E4C cryptDigestHP + 0x380 [5] 0x0900000017BCAE20 cryptGenerateIVFromData__FPUcUiPCUcN32PvT7 + 0x1F4 [6] 0x09000000140D0358 sqlexGetDatabaseDEKCipherInfo__FP16sqeLocalDatabasePPC20cryptBlo ckCipherInfoPUcUlT3PvT6 + 0xD8 [7] 0x0900000015096494 sqlbCommonWriteSetup__FP12SQLB_GLOBALSP8SQLB_BPDP9SQLB_PAGEP11SQ LO_IO_REQP15SQLB_RANGE_INFOP21SqlbLocalOpenFileInfobUsP14SQLB_P + 0xE8 [8] 0x0900000015061DC4 sqlbCommonWriteSetup__FP12SQLB_GLOBALSP8SQLB_BPDP9SQLB_PAGEP11SQ LO_IO_REQP15SQLB_RANGE_INFOP21SqlbLocalOpenFileInfobUsP14SQLB_P + 0x194C [9] 0x090000001506C138 sqloDispatchNBlocks__20SQLO_LIO_HANDLE_DATAFPP11SQLO_IO_REQUlPC2 2SQLO_LIO_CALLBACK_INFOP24SQLO_LIO_DISPATCH_STATUS16SQLO_LIO_OP + 0x8D8 [10] 0x0900000014F23194 sqlbClnrEntryPoint__FP12sqbPgClnrEdu + 0x1220 [11] 0x0900000014F23194 sqlbClnrEntryPoint__FP12sqbPgClnrEdu + 0x1220 [12] 0x0900000014F2135C sqlbClnrEntryPoint__FP12sqbPgClnrEdu + 0x974 2020-01-27-19.24.06.076678-300 I112830460A525 LEVEL: Severe PID : 64684174 TID : 9768 PROC : db2sysc 0 INSTANCE: XXXXX NODE : 000 DB : XXXXX HOSTNAME: XXXXX EDUID : 9768 EDUNAME: db2pclnr (TDSCCD01) 0 FUNCTION: DB2 UDB, bsu security, sqlexGetDatabaseDEKCipherInfo, probe:1328 MESSAGE : ZRC=0x875C00CD=-2024013619=SQLEX_UNEXPECTED_SYSERR "Unexpected System Error" DATA #1 : unsigned integer, 4 bytes 2415920131 2020-01-27-19.24.06.077032-300 I112830986A1846 LEVEL: Error PID : 64684174 TID : 9768 PROC : db2sysc 0 INSTANCE: XXXXX NODE : 000 DB : XXXXX HOSTNAME: XXXXX EDUID : 9768 EDUNAME: db2pclnr (TDSCCD01) 0 FUNCTION: DB2 Common, Cryptography, cryptEncryptBufferHP, probe:3318 MESSAGE : ECF=0x90000403=-1879047165=ECF_CRYPT_UNEXPECTED_ERROR Unexpected cryptographic error DATA #1 : Hex integer, 4 bytes 0xFFFFFFFE | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 v11.5 Mod 2 Fix Pack 0 or higher * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
BUG-Tracking | |
forerunner : IT31687 follow-up : | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 31.01.2020 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) |