|
Problem IT09017
|
Status: Closed |
INSTANCE CAN CRASH RUNNING A SQL ON COLUMN BASED TABLES(CDE). |
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problem description: |
Instance can crash running a SQL on Column Based Tables(CDE).
The trap look like the following:
2015-04-22-16.15.04.814251+120 I33801238E2318 LEVEL:
Event
PID : 20934 TID : 140685860660992 PROC :
db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB :
SAMPLE
APPHDL : 0-37247 APPID:
255.255.255.255.57615.150422140056
AUTHID : db2inst1 HOSTNAME: db2host1
EDUID : 2096 EDUNAME: db2agntcol (SAMPLE) 0
FUNCTION: DB2 UDB, oper system services,
sqloPGRPRegisterOneCrash, probe:2159
MESSAGE : lastCrashCount
DATA #1 : unsigned integer, 8 bytes
0
DATA #2 : String, 10 bytes
inRecovery
DATA #3 : Boolean, 1 bytes
false
CALLSTCK: (Static functions may not be resolved correctly, as
they are resolved to the nearest symbol)
[0] 0x00007FFFF28F02BC sqloPGRPRegisterOneCrash + 0x17C
[1] 0x00007FFFF2941719 sqloEDUCodeTrapHandler + 0xA49
[2] 0x00007FFFF7BCF710 /lib64/libpthread.so.0 + 0xF710
[3] 0x00007FFFF1C21963
_ZN7ibm_cde5query24LoadNestedQueryEvaluator23getCseNestedQueryOu
tputERmRSt6vectorINS_8services18CountedPtrWithCopyIKNS_5types10
+ 0xEC3
[4] 0x00007FFFF1C1FF01
_ZN7ibm_cde5query24LoadNestedQueryEvaluator26processInputsSynchr
onouslyEv + 0x251
[5] 0x00007FFFF38427A2
_ZN7ibm_cde5query9Evaluator8evaluateEbbRNS1_21EvaluatorRestartSt
ateEPNS0_19OptPredicateTrackerE + 0x402
[6] 0x00007FFFEE69775E
_ZN7ibm_cde5query17EvaluationRoutine8evaluateEjP15sql_static_dat
a + 0x31E
[7] 0x00007FFFF1C2D8F3
_ZN7ibm_cde5query9Scheduler13runThreadTaskEPvPi + 0x3C3
[8] 0x00007FFFF1C35A6E
_ZN7ibm_cde5query17cdeEntryPointImplEP8sqeAgentPvS3_ + 0x6E
[9] 0x00007FFFF1BE5FB3
_ZN12cdeInterface16startCdeSubagentEP8sqeAgent + 0x83
[10] 0x00007FFFF0D32071 _Z14sqlriInvokeCdeP8sqlrr_cb + 0x41
[11] 0x00007FFFF3933071
_Z15sqlriSectInvokeP8sqlrr_cbP12sqlri_opparm + 0x1B1
[12] 0x00007FFFF0B3D9F8 _Z16sqlrr_smp_routerP8sqlrr_cb + 0x2C8
[13] 0x00007FFFF0B3C8FE
_Z21sqlrr_subagent_routerP8sqeAgentP12SQLE_DB2RA_T + 0x58E
[14] 0x00007FFFEF97657D
/bbdd_idisarbl/sqllib/lib64/libdb2e.so.1 + 0x30C057D
[15] 0x00007FFFEF97503C _Z21sqleProcessSubRequestP8sqeAgent +
0x2DC
[16] 0x00007FFFEF990580 _ZN8sqeAgent6RunEDUEv + 0x4A0
[17] 0x00007FFFF1176047 _ZN9sqzEDUObj9EDUDriverEv + 0xF7
[18] 0x00007FFFF094F181 sqloEDUEntry + 0x301
[19] 0x00007FFFF7BC79D1 /lib64/libpthread.so.0 + 0x79D1
[20] 0x00007FFFEB6F6B6D clone + 0x6D |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All Platforms *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 LUW v10.5 Fixpack 7 or Later. *
**************************************************************** |
| Local Fix: |
|
| Solution |
First Fixed in DB2 LUW v10.5 Fixpack 7. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 21.05.2015
21.01.2016
21.01.2016 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.5.0.7
|
 |
