|
Problem IT20126
|
Status: Closed |
DB2 SIG #11 CRASH IN SQLNO_HINT_VALIDATE WHEN REBINDING USING THE APREUSE (ACCESS PLAN REUSE) OPTION |
| product: |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 |
| Problem description: |
DB2 crashed with a signal #11 trap while recompiling a query
with the APREUSE bind option set.
In this case the option was set automatically by the rebind
daemon, but this scenario is also possible when the rebind is
initiated by a user.
Stack traceback excerpt:
<StackTrace>
-----FUNC-ADDR---- ------FUNCTION + OFFSET------
0x00002AAAB9085686
_Z25ossDumpStackTraceInternalmR11OSSTrapFileiP7siginfoPvmm +
0x0356
(/mnt/blumeta0/home/db2inst1/sqllib/lib64/libdb2osse.so.1)
0x00002AAAB90852CB ossDumpStackTraceV98 + 0x002b
(/mnt/blumeta0/home/db2inst1/sqllib/lib64/libdb2osse.so.1)
0x00002AAAB9081477 _ZN11OSSTrapFile6dumpExEmiP7siginfoPvm +
0x00d7
(/mnt/blumeta0/home/db2inst1/sqllib/lib64/libdb2osse.so.1)
0x00002AAAB18E6B37 sqlo_trce + 0x03c7
(/mnt/blumeta0/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00002AAAB1A4CE6C sqloEDUCodeTrapHandler + 0x03ac
(/mnt/blumeta0/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x0000003CD800F7E0 address: 0x0000003CD800F7E0 ; dladdress:
0x0000003CD8000000 ; offset in lib: 0x000000000000F7E0 ;
(/lib64/libpthread.so.0)
0x00002AAAB0D6B4AB
_Z19sqlno_hint_validateP13sqlno_globalsP19sqlno_plan_operatorP10
sqlno_hintP9sqlno_qtbP13SQLNN_BOOLEAN + 0x041b
(/mnt/blumeta0/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00002AAAB0B67AFE
_Z22sqlno_crule_save_plansP13sqlno_globalsP13sqlno_context9sqlno
_setP14sqlno_planlistP10sqlno_hint + 0x189e
(/mnt/blumeta0/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00002AAAB0B713F9
_Z22sqlno_crule_save_plansP13sqlno_globalsP13sqlno_context9sqlno
_setP14sqlno_planlist + 0x0009
(/mnt/blumeta0/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00002AAAB0B6AE92
_Z18sqlno_crule_accessP13sqlno_globalsP9sqlno_qtbP18sqlno_join_c
ontext9sqlno_setS5_S5_S5_S5_13SQLNN_BOOLEANS5_PS6_ + 0x0272
(/mnt/blumeta0/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00002AAAB0CEA487
_Z14sqlno_plan_qunP13sqlno_globalsP9sqlno_sfbP9sqlnq_oprP9sqlnq_
qun + 0x1217
(/mnt/blumeta0/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00002AAAB0CF8C4F
_Z14sqlno_each_oprP13sqlno_globalsP9sqlno_sfbP9sqlnq_qunP9sqlnq_
opr + 0x09bf
(/mnt/blumeta0/home/db2inst1/sqllib/lib64/libdb2e.so.1)
... |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 11.1.1.2.2 *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Version 11.1 Mod 2 Fix Pack 2 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod2 Fix Pack2 iFix001 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod2 Fix Pack2 iFix002 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 3 Fix Pack 3 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod3 Fix Pack3 iFix001 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod3 Fix Pack3 iFix002 for Linux, UNIX, and Windows
|
| Solution |
First fixed in DB2 Version 11.1.1.2.2 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 07.04.2017
23.06.2017
23.06.2017 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
