DB2 - Problem description
Problem IT22622 | Status: Closed |
INSTANCE MAY CRASH WHEN SQLGGTSS API IS RUN WITHOUT A CONNECTION | |
product: | |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 | |
Problem description: | |
Instance may crash when sqlggtss API is run without a connection. Trap file will show the following: <StackTrace> -----FUNC-ADDR---- ------FUNCTION + OFFSET------ 0x00007F09A24CE975 _Z25ossDumpStackTraceInternalmR11OSSTrapFileiP7siginfoPvmm + 0x0385 0x00007F09A24CE57C ossDumpStackTraceV98 + 0x002c 0x00007F09A24CA61D _ZN11OSSTrapFile6dumpExEmiP7siginfoPvm + 0x00fd x00007F09A8B0CAB4 sqlo_trce + 0x0404 x00007F09A8B964EC sqloEDUCodeTrapHandler + 0x02ac x000000363120F500 address: 0x000000363120F500 ; dladdress: 0x0000003631200000 ; offset in lib: 0x000000000000F500 ; x00007F09A9B6E390 _Z9sqlpSpReqP8sqeAgent11SQLP_SPTYPEPm + 0x0060 x00007F09A7A57418 _Z17sqlbgtss_route_inP12SQLE_DB2RA_TP8sqeAgent + 0x0078 x00007F09A5B450F6 _Z8sqlesrvrP14db2UCinterface + 0x1356 x00007F09A5B6479E _Z19sqleMappingFnServerP5sqldaP5sqlca + 0x04de x00007F09A5D8AE47 _Z19sqlerKnownProcedureiPcPiP5sqldaS2_P13sqlerFmpTableP8sqeAgent P5sqlca + 0x0247 x00007F09A5D8CC7D _Z11sqlerCallDLP14db2UCinterfaceP9UCstpInfo + 0x06fd x00007F09A9ADE91E _Z19sqljs_ddm_excsqlsttP14db2UCinterfaceP13sqljDDMObject + 0x09be x00007F09A9ADD9AE _Z21sqljsParseRdbAccessedP13sqljsDrdaAsCbP13sqljDDMObjectP14db2U Cinterface + 0x007e x00007F09A5E74FEB _Z10sqljsParseP13sqljsDrdaAsCbP14db2UCinterfaceP8sqeAgentb + 0x036b x00007F09A5E6F4E9 address: 0x00007F09A5E6F4E9 ; dladdress: 0x00007F09A29F4000 ; offset in lib: 0x000000000347B4E9 ; x00007F09A5E6D93C address: 0x00007F09A5E6D93C ; dladdress: 0x00007F09A29F4000 ; offset in lib: 0x000000000347993C ; x00007F09A5E6A999 address: 0x00007F09A5E6A999 ; dladdress: 0x00007F09A29F4000 ; offset in lib: 0x0000000003476999 ; x00007F09A5E6A58B _Z17sqljsDrdaAsDriverP18SQLCC_INITSTRUCT_T + 0x00eb x00007F09A5B68C27 _ZN8sqeAgent6RunEDUEv + 0x0ad7 x00007F09A7382227 _ZN9sqzEDUObj9EDUDriverEv + 0x00f7 x00007F09A6B3A8C3 sqloEDUEntry + 0x0303 x0000003631207851 address: 0x0000003631207851 ; dladdress: 0x0000003631200000 ; offset in lib: 0x0000000000007851 ; x0000003630EE894D clone + 0x006d </StackTrace> Cleaned up stack: <StackTrace> -----FUNC-ADDR---- ------FUNCTION + OFFSET------ 0x00007F09A24CE975 ossDumpStackTraceInternal(unsigned long, OSSTrapFile&, int, siginfo*, void*, unsigned long, unsigned long) + 0x0385 0x00007F09A24CE57C ossDumpStackTraceV98 + 0x002c 0x00007F09A24CA61D OSSTrapFile::dumpEx(unsigned long, int, siginfo*, void*, unsigned long) + 0x00fd x00007F09A8B0CAB4 sqlo_trce + 0x0404 x00007F09A8B964EC sqloEDUCodeTrapHandler + 0x02ac x000000363120F500 address: 0x000000363120F500 ; dladdress: 0x0000003631200000 ; offset in lib: 0x000000000000F500 ; x00007F09A9B6E390 sqlpSpReq(sqeAgent*, SQLP_SPTYPE, unsigned long*) + 0x0060 x00007F09A7A57418 sqlbgtss_route_in(SQLE_DB2RA_T*, sqeAgent*) + 0x0078 x00007F09A5B450F6 sqlesrvr(db2UCinterface*) + 0x1356 x00007F09A5B6479E sqleMappingFnServer(sqlda*, sqlca*) + 0x04de x00007F09A5D8AE47 sqlerKnownProcedure(int, char*, int*, sqlda*, sqlda*, sqlerFmpTable*, sqeAgent*, sqlca*) + 0x0247 x00007F09A5D8CC7D sqlerCallDL(db2UCinterface*, UCstpInfo*) + 0x06fd x00007F09A9ADE91E sqljs_ddm_excsqlstt(db2UCinterface*, sqljDDMObject*) + 0x09be x00007F09A9ADD9AE sqljsParseRdbAccessed(sqljsDrdaAsCb*, sqljDDMObject*, db2UCinterface*) + 0x007e x00007F09A5E74FEB sqljsParse(sqljsDrdaAsCb*, db2UCinterface*, sqeAgent*, bool) + 0x036b x00007F09A5E6F4E9 address: 0x00007F09A5E6F4E9 ; dladdress: 0x00007F09A29F4000 ; offset in lib: 0x000000000347B4E9 ; x00007F09A5E6D93C address: 0x00007F09A5E6D93C ; dladdress: 0x00007F09A29F4000 ; offset in lib: 0x000000000347993C ; x00007F09A5E6A999 address: 0x00007F09A5E6A999 ; dladdress: 0x00007F09A29F4000 ; offset in lib: 0x0000000003476999 ; x00007F09A5E6A58B sqljsDrdaAsDriver(SQLCC_INITSTRUCT_T*) + 0x00eb x00007F09A5B68C27 sqeAgent::RunEDU() + 0x0ad7 x00007F09A7382227 sqzEDUObj::EDUDriver() + 0x00f7 x00007F09A6B3A8C3 sqloEDUEntry + 0x0303 x0000003631207851 address: 0x0000003631207851 ; dladdress: 0x0000003631200000 ; offset in lib: 0x0000000000007851 ; x0000003630EE894D clone + 0x006d </StackTrace> | |
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: | |
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 : | 02.10.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) |