|
Problem IC63424
|
Status: Closed |
POSSIBLE MEMORY CORRUPTION - TRAP IN <SQLRAERTDESTROYTABLE> <SQLRAERT.C:259> |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
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 Summary: |
****************************************************************
* 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 |
| available fix packs: |
DB2 Version 9.7 Fix Pack 1 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
First Fixed in DB2 Version 9.7 fix pack 1 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 25.09.2009
15.01.2010
31.08.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP1
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.1
|
 |
