DB2 - Problembeschreibung
Problem IC63424 | Status: Geschlossen |
POSSIBLE MEMORY CORRUPTION - TRAP IN <SQLRAERTDESTROYTABLE> <SQLRAERT.C:259> | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
If we run out of memory while constructing a cursor variable, the following connection reset might fail with -1224 which brings down the instance. <Header> DB2 build information: DB2 v9.7.100.119 s090917 SQL09071 timestamp: 2009-09-21-07.07.54.953000 uname: S:Windows comment: NTX6497 process id: 660 thread id: 3144 </Header> <POFDisassembly> <![CDATA[ Failing instruction at 000000018004801A offset: 0000000000000A04in <sqloFreeMemChunks> <NotFound:-1> ]]></POFDisassembly> <StackTrace> <![CDATA[ ------RBP--------------RIP--------------ARGS-------------------- ------------------------------------- 00000000136985E0 000000018004801A 0000000001B40000 0000000000000002 000007FFFC98EDA0 0000000001B48829 offset: 0000000000000A04 in <sqloFreeMemChunks> <NotFound:-1> 00000000136986E0 000000018004C581 0000000013698720 000007FFFC98EDA0 0000000000000000 000007FFCEDF0C98 offset: 00000000000005A3 in <sqlofmblkEx> <NotFound:-1> 0000000013698710 0000000001B48829 0000000000000001 000000000BD6419D 000007FF00000001 0000000001B44FB4 offset: 0000000000000009 in <sqlofmblk> <E:\db2_v97fp1\ntx64\s090917\engn\include\sqlomem.h:502> 0000000013698790 00000000030E96C8 0000000013698978 0000000013698D14 0000000013698D18 000000000213567E offset: 00000000000000F2 in <sqlraERTDestroyTable> <sqlraert.C:259> 0000000013699660 0000000002F7DFFF 0000000000000040 000000000000000B 0000000000000000 000007FF00000000 offset: 0000000000001585 in <sqlrr_appl_term> <sqlrr.C:3754> 00000000136998E0 0000000001F44674 0000000000000000 0000000006540740 0000000006506D10 0000000007C3B3E0 offset: 0000000000000492 in <sqeApplication::AppStopUsing> <sqle_application.C:5097> 0000000013699C30 00000000020261A7 0000000000000000 000007FFFDA35D00 0000000000000005 0000000000000000 offset: 0000000000000083 in <sqlesrspWrp> <sqleu_server.C:2288> 0000000013699CE0 0000000002025D91 0000000000000001 000000000000025A 0000000000000000 0000000000000000 offset: 0000000000000095 in <sqleUCagentConnectReset> <sqleu_server.C:2469> 0000000013699EB0 000000000211DABD 0000000000000000 00000002280D30D9 0000000000000000 0000000000000000 offset: 0000000000000EA9 in <sqljsCleanup> <sqljsqam.C:4419> 0000000013699F50 0000000002117D90 0000000000000000 0000000000000000 0000000000000000 0000000000000000 offset: 000000000000046E in <sqljsDrdaAsInnerDriver> <sqljsqam.C:1322> 000000001369F870 00000000021177A3 000007FFFC248270 000000018008D35B 000000000027C4B0 0000000007500348 offset: 000000000000012B in <sqljsDrdaAsDriver> <sqljsqam.C:1046> 000000001369FBD0 0000000001F4F276 0002625A00000000 000000018001A3D6 000000734BD67DBD 000000018002C17A offset: 0000000000000748 in <sqeAgent::RunEDU> <sqle_agent.C:3946> 000000001369FC60 00000000038ADF35 000000000F350D98 000000001369FCB0 0000000000000000 00000001800E007A offset: 000000000000010F in <sqlzRunEDU> <sqlz_edu_obj.C:35> 000000001369FF70 00000001800E0391 000000000F350D98 0000000000000000 0000000000000000 000000001369FFA8 offset: 000000000000042B in <sqloInitEDUServices> <NotFound:-1> 000000001369FFA0 0000000077D0B71A 0000000000000000 0000000000000000 0000000000000000 0000000000000000 ]]></StackTrace> | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * DB2 LUW All platforms * **************************************************************** * PROBLEM DESCRIPTION: * * the following connection reset might fail with -1224 which * * * * brings down the instance. * * * * <Header> * * DB2 build information: DB2 v9.7.100.119 s090917 SQL09071 * * * * timestamp: 2009-09-21-07.07.54.953000 * * uname: S:Windows * * comment: NTX6497 * * process id: 660 * * thread id: 3144 * * </Header> * * <POFDisassembly> * * <![CDATA[ * * Failing instruction at 000000018004801A offset: * * 0000000000000A04in <sqloFreeMemChunks> <NotFound:-1> * * ]]></POFDisassembly> * * <StackTrace> * * <![CDATA[ * * * * ------RBP--------------RIP--------------ARGS------------------ * ------------------------------------- * * 00000000136985E0 000000018004801A 0000000001B40000 * * 0000000000000002 000007FFFC98EDA0 0000000001B48829 offset: * * * * 0000000000000A04 in <sqloFreeMemChunks> <NotFound:-1> * * * * 00000000136986E0 000000018004C581 0000000013698720 * * 000007FFFC98EDA0 0000000000000000 000007FFCEDF0C98 offset: * * * * 00000000000005A3 in <sqlofmblkEx> <NotFound:-1> * * 0000000013698710 0000000001B48829 0000000000000001 * * 000000000BD6419D 000007FF00000001 0000000001B44FB4 offset: * * * * 0000000000000009 in <sqlofmblk> * * <E:\db2_v97fp1\ntx64\s090917\engn\include\sqlomem.h:502> * * * * 0000000013698790 00000000030E96C8 0000000013698978 * * 0000000013698D14 0000000013698D18 000000000213567E offset: * * * * 00000000000000F2 in <sqlraERTDestroyTable> <sqlraert.C:259> * * * * 0000000013699660 0000000002F7DFFF 0000000000000040 * * 000000000000000B 0000000000000000 000007FF00000000 offset: * * * * 0000000000001585 in <sqlrr_appl_term> <sqlrr.C:3754> * * 00000000136998E0 0000000001F44674 0000000000000000 * * 0000000006540740 0000000006506D10 0000000007C3B3E0 offset: * * * * 0000000000000492 in <sqeApplication::AppStopUsing> * * <sqle_application.C:5097> * * 0000000013699C30 00000000020261A7 0000000000000000 * * 000007FFFDA35D00 0000000000000005 0000000000000000 offset: * * * * 0000000000000083 in <sqlesrspWrp> <sqleu_server.C:2288> * * * * 0000000013699CE0 0000000002025D91 0000000000000001 * * 000000000000025A 0000000000000000 0000000000000000 offset: * * * * 0000000000000095 in <sqleUCagentConnectReset> * * <sqleu_server.C:2469> * * 0000000013699EB0 000000000211DABD 0000000000000000 * * 00000002280D30D9 0000000000000000 0000000000000000 offset: * * * * 0000000000000EA9 in <sqljsCleanup> <sqljsqam.C:4419> * * 0000000013699F50 0000000002117D90 0000000000000000 * * 0000000000000000 0000000000000000 0000000000000000 offset: * * * * 000000000000046E in <sqljsDrdaAsInnerDriver> * * <sqljsqam.C:1322> * * 000000001369F870 00000000021177A3 000007FFFC248270 * * 000000018008D35B 000000000027C4B0 0000000007500348 offset: * * * * 000000000000012B in <sqljsDrdaAsDriver> <sqljsqam.C:1046> * * * * 000000001369FBD0 0000000001F4F276 0002625A00000000 * * 000000018001A3D6 000000734BD67DBD 000000018002C17A offset: * * * * 0000000000000748 in <sqeAgent::RunEDU> <sqle_agent.C:3946> * * * * 000000001369FC60 00000000038ADF35 000000000F350D98 * * 000000001369FCB0 0000000000000000 00000001800E007A offset: * * * * 000000000000010F in <sqlzRunEDU> <sqlz_edu_obj.C:35> * * 000000001369FF70 00000001800E0391 000000000F350D98 * * 0000000000000000 0000000000000000 000000001369FFA8 offset: * * * * 000000000000042B in <sqloInitEDUServices> <NotFound:-1> * * * * 000000001369FFA0 0000000077D0B71A 0000000000000000 * * 0000000000000000 0000000000000000 0000000000000000 * * ]]></StackTrace> * **************************************************************** * RECOMMENDATION: * * Upgrade to db2 v97fp1 * **************************************************************** | |
Local-Fix: | |
Increase application heap size | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 1 for Linux, UNIX, and Windows | |
Lösung | |
First Fixed in DB2 Version 9.7 fix pack 1 | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 25.09.2009 15.01.2010 31.08.2011 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.FP1 | |
Problem behoben lt. FixList in der Version | |
9.7.0.1 |