|
Problem IC81658
|
Status: Closed |
LOAD OPERATION MIGHT CRASH WITH A SPECIFIC STACK TRACE, BRING THE DB2 INSTANCE DOWN |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
A load operation might fail near the end of its operation in a
specific way, and crash the DB2 instance. This is a
timing-dependent issue, and only affects DB2 9.7 Fixpack 5. One
or more of the load processes (EDU) have stack trace like this:
...
0x00002AAAADF2ABFB sqloEDUCodeTrapHandler + 0x027b
(/home/wallace1/sqllib/lib64/libdb2e.so.1)
0x00002AAAAABD4C10 address: 0x00002AAAAABD4C10 ; dladdress:
0x00002AAAAABC7000 ; offset in lib: 0x000000000000DC10 ;
(/lib64/libpthread.so.0)
0x00002AAAAEDC57CC _ZN8SMemNode18findParentsPointerEPPS_ +
0x001c
(/home/wallace1/sqllib/lib64/libdb2e.so.1)
0x00002AAAAEDC94F2 _ZN17SqloChunkSubgroup14removeFromPoolEv +
0x0032
(/home/wallace1/sqllib/lib64/libdb2e.so.1)
0x00002AAAAEDC1EB0 sqlofmblkEx + 0x03d0
(/home/wallace1/sqllib/lib64/libdb2e.so.1)
0x00002AAAACCE8397 _Z17sqluLoadEDUDriverPhj + 0x01f7
(/home/wallace1/sqllib/lib64/libdb2e.so.1)
0x00002AAAAC8CC101 sqloEDUEntry + 0x02a1
(/home/wallace1/sqllib/lib64/libdb2e.so.1)
...
All LOADs can potentially hit this problem, but this should be
rarely hit. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All LOAD users running DB2 9.7 Fixpack 5 *
****************************************************************
* PROBLEM DESCRIPTION: *
* A load operation might fail near the end of its operation in *
* a *
* specific way, and crash the DB2 instance. This is a *
* timing-dependent issue, and only affects DB2 9.7 Fixpack 5. *
* One *
* or more of the load processes (EDU) have stack trace like *
* this: *
* *
* ... *
* 0x00002AAAADF2ABFB sqloEDUCodeTrapHandler + 0x027b *
* (/home/wallace1/sqllib/lib64/libdb2e.so.1) *
* 0x00002AAAAABD4C10 address: 0x00002AAAAABD4C10 ; dladdress: *
* 0x00002AAAAABC7000 ; offset in lib: 0x000000000000DC10 ; *
* (/lib64/libpthread.so.0) *
* 0x00002AAAAEDC57CC _ZN8SMemNode18findParentsPointerEPPS_ + *
* 0x001c *
* (/home/wallace1/sqllib/lib64/libdb2e.so.1) *
* 0x00002AAAAEDC94F2 _ZN17SqloChunkSubgroup14removeFromPoolEv *
* + *
* 0x0032 *
* (/home/wallace1/sqllib/lib64/libdb2e.so.1) *
* 0x00002AAAAEDC1EB0 sqlofmblkEx + 0x03d0 *
* (/home/wallace1/sqllib/lib64/libdb2e.so.1) *
* 0x00002AAAACCE8397 _Z17sqluLoadEDUDriverPhj + 0x01f7 *
* (/home/wallace1/sqllib/lib64/libdb2e.so.1) *
* 0x00002AAAAC8CC101 sqloEDUEntry + 0x02a1 *
* (/home/wallace1/sqllib/lib64/libdb2e.so.1) *
* ... *
* *
* *
* All LOADs can potentially hit this problem, but this should *
* be rarely hit. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 9.7 Fix Pack 6. *
**************************************************************** |
| Local Fix: |
Not available. |
| available fix packs: |
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 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 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
Problem was first fixed in DB2 Version 9.7 Fix Pack 6. At a
minimum, this fix should be applied on the server. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 24.02.2012
05.06.2012
05.06.2012 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP6
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.6
|
 |
