DB2 - Problem description
Problem IC99041 | Status: Closed |
DIVIDE BY ZERO TRAP IN PAGE_AGE CODE IN SQLPCHECKFORBAFLSH | |
product: | |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 | |
Problem description: | |
The trap occurs with this call stack: 2014-01-12-08.30.06.156758-300 I289911E3230 LEVEL: Event PID : 3076 TID : 46912833055040 PROC : db2sysc 2 INSTANCE: abdce30 NODE : 002 DB : DBABC APPHDL : 1-68 APPID: *N1.DB2.140112125247 AUTHID : MYUSER HOSTNAME: hostabc EDUID : 188 EDUNAME: db2evmtp (WLM_STATS_MON) 2 FUNCTION: DB2 UDB, oper system services, sqloPGRPRegisterOneCrash, probe:2154 MESSAGE : lastCrashCount DATA #1 : unsigned integer, 8 bytes 0 DATA #2 : String, 10 bytes inRecovery DATA #3 : Boolean, 1 bytes false CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol) [0] 0x00002AAAABE316AE pdLog + 0x38E [1] 0x00002AAAAE28EAFD sqloPGRPRegisterOneCrash + 0x17D [2] 0x00002AAAAE2D53B1 sqloEDUCodeTrapHandler + 0x871 [3] 0x00002AAAAACD7CA0 /lib64/libpthread.so.0 + 0xECA0 [4] 0x00002AAAACBC0482 _Z18sqlpCheckForBaflshP14sqlpMasterDbcbmm + 0x162 [5] 0x00002AAAAF118631 _Z14sqlpWriteToLogP8sqeAgentmmmP14SQLP_LREC_PARTP9SQLP_LSN8Pm + 0xCF1 [6] 0x00002AAAAF11ACB4 _Z11sqlpWriteLRP8sqeAgentmmmmmP14SQLP_LREC_PARTmP9SQLP_LSN8Pm + 0x304 [7] 0x00002AAAABDCFA17 _Z11sqlpWriteLRP8sqeAgentmmmmmP14SQLP_LREC_PARTmP9SQLP_LSN8 + 0x17 [8] 0x00002AAAAD82E690 _Z15sqldxLogLobDataP9SQLDX_LWAhhtPK12SQLDX_IOPARMPc + 0x280 [9] 0x00002AAAAC0B28C5 _Z17sqldxWriteLobDataP9SQLDX_LWAhtPK12SQLDX_IOPARMPc + 0x415 [10] 0x00002AAAAC0B8846 _Z15sqldxReplaceLobP9SQLDX_LWAhtP8SQLDX_LDjiPcj + 0x136 [11] 0x00002AAAAC0B8519 _Z14sqldxCreateLobP9SQLDX_LWAhtiiPciP8SQLDX_LD + 0xE9 [12] 0x00002AAAAC0AEBA2 _Z14sqldxLobCreateP8sqeAgentP8SQLD_TCBhtiiPciP8SQLDX_LD + 0x92 [13] 0x00002AAAABFE6892 _Z8sqldmadxP8sqeAgentP8SQLD_TCBhtP9sqllf_csoiiP8SQLD_LFDPm + 0x252 [14] 0x00002AAAABFE5B68 /var/ibmdb2/nypxt430/sqllib/lib64/libdb2e.so.1 + 0x10FFB68 [15] 0x00002AAAAEFB036A _Z22sqldFullFormatFixedVarP8sqeAgentP13SQLD_TDATARECS2_PP10SQLD_ VALUEmP8SQLD_TCBPiPhP15SQLD_XOR_UPDATEP8SQLD_CCB + 0xDCA [16] 0x00002AAAAEFC9417 _Z13sqldRowInsertP8sqeAgenttthmiPP10SQLD_VALUEP13SQLD_TDATARECP8 SQLZ_RID + 0x19F7 [17] 0x00002AAAAF171AA9 _Z8sqlrinsrP8sqlrr_cbttitPP10SQLD_VALUEN10sqlri_iudo11t_iudoFlag s17t_iudoFlagsKernelEP8SQLZ_RID + 0x79 [18] 0x00002AAAADB89504 _ZN17sqm_evmon_ttarget10write_dataEPcjP17sqmRequestMetrics + 0x14E4 [19] 0x00002AAAADB81FE5 _ZN16sqm_evmon_target16prepAndWriteDataEPcj + 0xF5 [20] 0x00002AAAADB9403A _ZN14sqmEvmonBuffer10write_dataEP16sqm_evmon_target + 0x7A [21] 0x00002AAAAC410308 _ZN14sqmEvmonWriter11evmonWriterEv + 0x7F8 [22] 0x00002AAAAC41489D _ZN14sqmEvmonWriter9startMeUpEP12sqzDataChainI9sqmTarget16sqzCha inNodeBaseIS1_EERbb + 0x149D [23] 0x00002AAAADB712F2 _Z26sqlm_bds_start_monitor_hdlP8sqeAgentb + 0x552 [24] 0x00002AAAAC0FE291 /var/ibmdb2/nypxt430/sqllib/lib64/libdb2e.so.1 + 0x1218291 [25] 0x00002AAAAC0FD8F3 _Z21sqleProcessSubRequestP8sqeAgent + 0xE3 [26] 0x00002AAAAC117FB4 _ZN8sqeAgent6RunEDUEv + 0x604 [27] 0x00002AAAAD0FDAB3 _ZN9sqzEDUObj9EDUDriverEv + 0xF3 [28] 0x00002AAAAD0FD9B9 _Z10sqlzRunEDUPcj + 0x9 [29] 0x00002AAAACB8A861 sqloEDUEntry + 0x2A1 [30] 0x00002AAAAACCF83D /lib64/libpthread.so.0 + 0x683D [31] 0x00002AAAB349BF8D clone + 0x6D 2014-01-12-08.31.52.705833-300 I293142E505 LEVEL: Error PID : 3117 TID : 46912781500384 PROC : db2vend (PD Vendor Process - 29) INSTANCE: abdce30 NODE : 000 HOSTNAME: hostabc FUNCTION: DB2 UDB, oper system services, DB2VEND_main, probe:1040 MESSAGE : ZRC=0x870F0009=-2029060087=SQLO_EOF "the data does not exist" DIA8506C Unexpected end of file was reached. DATA #1 : String, 63 bytes Fenced vendor process pipe failure, terminating vendor process. 2014-01-12-08.31.52.786604-300 E293648E594 LEVEL: Severe PID : 3073 TID : 46912791112000 PROC : db2wdog 2 [abdce30] INSTANCE: abdce30 NODE : 002 HOSTNAME: hostabc EDUID : 2 EDUNAME: db2wdog 2 [abdce30] FUNCTION: DB2 UDB, base sys utilities, sqleWatchDog, probe:20 MESSAGE : ADM0503C An unexpected internal processing error has occurred. All DB2 processes associated with this instance have been shutdown. Diagnostic information has been recorded. Contact IBM Support for further assistance. From the trap file we can see the trap with signal #8: </Siginfo_t> Signal #8 (SIGFPE): si_addr is 0x00002AAAACBC0482, si_code is 0x00000001 (FPE_INTDIV:Integer divide by zero.) </SignalDetails> <StackTrace> Raw stack dump. Stack top is at 0x00002AAABEBFFF20. 0x00002AAABEBF2D50 : B4B5 4447 253F 0000 6C95 4447 253F 0000 ..DG%?..l.DG%?.. 0x00002AAABEBF2D60 : 0000 0000 0000 0000 00D1 47E8 AA2A 0000 ..........G..*.. 0x00002AAABEBF2D70 : 80AB 17D9 AA2A 0000 003B 17D9 AA2A 0000 .....*...;...*.. 0x00002AAABEBF2D80 : 0100 0000 0000 0000 3186 11AF AA2A 0000 ........1....*.. 0x00002AAABEBF2D90 : 0200 0000 0000 0000 ED2C 45B3 AA2A 0000 .........,E..*.. 0x00002AAABEBF2DA0 : E07E 8CD5 AC2A 0000 128D FAAB AA2A 0000 .~...*.......*.. 0x00002AAABEBF2DB0 : 00E0 D189 AD2A 0000 0000 0000 0000 0000 .....*.......... 0x00002AAABEBF2DC0 : E0BC 50B2 AA2A 0000 0000 0000 0000 0000 ..P..*.......... 0x00002AAABEBF2DD0 : 0000 0000 0000 0000 4CC8 F9AE AA2A 0000 ........L....*.. 0x00002AAABEBF2DE0 : 80E0 D189 AD2A 0000 6091 55E8 AA2A 0000 .....*..`.U..*.. 0x00002AAABEBF2DF0 : 0000 0000 AA2A 0000 00F0 52E9 AA2A 0000 .....*....R..*.. 0x00002AAABEBF2E00 : E00A 1CE9 AA2A 0000 E034 BFBE AA2A 0000 .....*...4...*.. 0x00002AAABEBF2E10 : 0000 0000 0000 0000 F036 BFBE AA2A 0000 .........6...*.. . . . 0x00002AAABEBFAD20 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00002AAABEBFAD30 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00002AAABEBFAD40 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00002AAABEBFAD50 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00002AAABEBFAD60 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00002AAABEBFAD70 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ </StackTrace> | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Linux, AIX * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 10.1 FP4 * **************************************************************** | |
Local Fix: | |
available fix packs: | |
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows | |
Solution | |
See error description | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 28.01.2014 12.05.2014 12.05.2014 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) | |
10.1.0.4 |