DB2 - Problem description
Problem IT32589 | Status: Closed |
CDE JOIN CAUSES CRASH WHEN DB2 TRACE IS TURNED ON | |
product: | |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 | |
Problem description: | |
CDE join causes crash when Db2 trace is turned on We see the following db2diag entry EDUID : 57870 EDUNAME: db2agntcol (BLUDB) 2 FUNCTION: DB2 UDB, oper system services, sqloPGRPRegisterOneCrash, probe:2161 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] 0x00002B37DDB235CC sqloPGRPRegisterOneCrash + 0x20C [1] 0x00002B37DDC9F278 sqloEDUCodeTrapHandler + 0xB28 [2] 0x00002B37D44B55D0 /lib64/libpthread.so.0 + 0xF5D0 [3] 0x00002B37DB7DF471 _ZN7ibm_cde5query13JoinSpillInfo20computeAgentUsePartsEmRNS_5typ es9BitStringEm + 0x391 [4] 0x00002B37DB7D9735 _ZN7ibm_cde5query13JoinSpillInfo16reserveAgentPartEmRNS_5types9B itStringEmRm + 0x175 [5] 0x00002B37DB7D900C _ZN7ibm_cde5query13JoinSpillInfo21reserveAgentPartGroupEmRNS_5ty pes9BitStringEmRm + 0x10C [6] 0x00002B37DA9676F0 _ZN7ibm_cde5query23GetJoinPayloadEvaluator25loadWorkunitsAndPart GroupEPNS0_5QueueERb + 0x260 [7] 0x00002B37DA966E6E _ZN7ibm_cde5query23GetJoinPayloadEvaluator26processInputsSynchro nouslyEv + 0x180E [8] 0x00002B37D8DA797D _ZN7ibm_cde5query9Evaluator8evaluateEbbRNS1_21EvaluatorRestartSt ateEPNS0_19OptPredicateTrackerE + 0x4CD [9] 0x00002B37D8D256F4 _ZN7ibm_cde5query17EvaluationRoutine8evaluateEjP15sql_static_dat a + 0x304 [10] 0x00002B37D96A191C _ZN7ibm_cde5query9Scheduler13evaluateChainEPNS0_17EvaluationRout ineERmj + 0x64C [11] 0x00002B37D96A5070 _ZN7ibm_cde5query9Scheduler15runWorkerThreadEPvPi + 0x2F0 [12] 0x00002B37D96B4E8E _ZN7ibm_cde5query17cdeEntryPointImplEP8sqeAgentPvS3_ + 0x6E [13] 0x00002B37DA20A27E _ZN12cdeInterface16startCdeSubagentEP8sqeAgent + 0x27E [14] 0x00002B37DEAE877F _Z14sqlriInvokeCdeP8sqlrr_cb + 0x3F [15] 0x00002B37DE9475A5 _Z15sqlriSectInvokeP8sqlrr_cbP12sqlri_opparm + 0x4F5 [16] 0x00002B37DE3530EB _Z21sqlrr_subagent_routerP8sqeAgentP12SQLE_DB2RA_T + 0xE6B [17] 0x00002B37DBD108BB /mnt/blumeta0/home/db2inst1/sqllib/lib64/libdb2e.so.1 + 0x72A38BB [18] 0x00002B37DBD0F0EC _Z21sqleProcessSubRequestP8sqeAgent + 0x3EC [19] 0x00002B37DBD44754 _ZN8sqeAgent6RunEDUEv + 0x604 [20] 0x00002B37DF82F19E _ZN9sqzEDUObj9EDUDriverEv + 0x1BE [21] 0x00002B37DDC9BFBB sqloEDUEntry + 0x57B [22] 0x00002B37D44ADDD5 /lib64/libpthread.so.0 + 0x7DD5 [23] 0x00002B37E777102D clone + 0x6D | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * all * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to db2 v115m4fp0 or later * **************************************************************** | |
Local Fix: | |
Do not start Db2 trace | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 17.04.2020 30.06.2020 30.06.2020 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |