DB2 - Problem description
Problem IT35017 | Status: Closed |
CDE JOIN MINMAXINFO DUMP: TRAP DUE TO DEREFERENCING NULL POINTER | |
product: | |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 | |
Problem description: | |
Trap during MinMaxInfo dump as part of the agent dump after a query hit an error. The direct cause of the trap is the code tries to dereference a null pointer. Error -901 returned due to trap in EvaluationRoutine::determineSelectDatatypes -----Frame------ ------Address----- ------Function + Offset------ 0x0000101A38FE7360 0x000010000008FFAC pthread_kill + 0x006c 0x0000101A38FE7390 0x0000100002E2FA40 sqldDumpContext(sqeBsuEdu*, int, int, int, int, int, char const*, void*, int) + 0x0150 0x0000101A38FE7B70 0x000010000A81B7E8 sqlrr_dump_ffdc(sqlrr_cb*, int, int) + 0x0888 0x0000101A38FE7CD0 0x000010000BF7A8E8 sqlzeDumpFFDC(sqeAgent*, unsigned int, sqlca*, int) + 0x00f8 0x0000101A38FE7D50 0x000010000BF7ADA8 sqlzeSqlCode(sqeAgent*, unsigned int, unsigned long, unsigned int, sqlca*, int, unsigned short, char*) + 0x0218 0x0000101A38FE7E50 0x000010000A93F430 sqlrrSqlCode + 0x02c0 0x0000101A38FE80C0 0x000010000318C800 ibm_cde::services::AssertionFailedException::done() + 0x0740 0x0000101A38FE8560 0x000010000318D98C ibm_cde::services::AssertionFailedException::constructAndThrow(i bm_cde::services::ComponentID, char const*, unsigned long, char const*, char const*, ibm_cde::services::CdeOStringStream&) +0x00ec 0x0000101A38FE8E00 0x0000100004A19EAC ibm_cde::query::EvaluationRoutine::determineSelectDatatypes(...) + 0x02ec 0x0000101A38FE91E0 0x00001000052F39F8 0x0000101A38FE93F0 0x00001000052F7484 ibm_cde::query::Scheduler::Scheduler(..) + 0x04e4 0x0000101A38FE9550 0x00001000052F7D78 ibm_cde::query::acquireScheduler(runtimeSchedulerUsage, SQLO_MEM_POOL*, ibm_cde::query::SyntaxTree*, ibm_cde::query::QueryResources*, ibm_cde::data::TableAccessorAllocator*, ibm_cde::query::QueryInfoContainer*, ibm_cde::query::HashPartitionResult*, ibm_cde::query::JoinHashTableInfo*, unsigned short, void*, sqlriCdeRetainedSchedulerHandle*, bool, unsigned int, unsigned short, float) + 0x0328 0x0000101A38FE9760 0x0000100004A3B3F4 ibm_cde::query::EvaluationRoutine::formEvaluationRoutine(...) +0x0214 0x0000101A38FE9920 0x00001000052FB240 ibm_cde::query::Scheduler::genSingleTableQuery(ibm_cde::query::S yntaxTree*, ibm_cde::query::NLJoinControlBlock*) + 0x02a0 0x0000101A38FEA580 0x0000100005304070 ibm_cde::query::Scheduler::runSingleTableQuery() + 0x06c0 0x0000101A38FEBD50 0x000010000530731C ibm_cde::query::Scheduler::runCompositeQuery() + 0x03fc | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Modify after defect delivered * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Modify after defect delivered * **************************************************************** | |
Comment | |
See Error Description | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 23.11.2020 01.04.2021 06.04.2021 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |