DB2 - Problem description
Problem IT35949 | Status: Closed |
OUT OF MEMORY: SIGNAL #11 DATABASETABLEACCESSOR::DESTROYDELETEREPLICATOR | |
product: | |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 | |
Problem description: | |
Signal #11 crash which brings down DB2 instance after an out of memory error when using replication on a BLU (column organized) table. ibm_cde::data::DatabaseTableAccessor::destroyDeleteReplicator( (unsigned long const)) + 0x9C ibm_cde::data::TableAccessorAllocator::__dt( (void)) + 0x7A8 ibm_cde::query::Scheduler::__dt( (void)) + 0x2D84 ibm_cde::query::Scheduler::cleanAndDeleteScheduler( (ibm_cde::query::Scheduler *)) + 0x33C cdeInterface::cdeFreeSchedulerObject(ibm_cde::query::Scheduler *) + 0x100 sqlriCdeFinalSectionCleanup(sqlrr_cb *, sqlri_shd *) + 0x340 sqlricls_complex__FP8sqlrr_cbilN23 + 0x2E44 sqlrr_subagent_close(sqlrr_cb *) + 0x3A8 sqlrr_subagent_router(sqeAgent *, SQLE_DB2RA_T *) + 0x1190 IPRA.$sqleSubRequestRouter(sqeAgent *, unsigned int *, unsigned long *) + 0x870 sqleProcessSubRequest(sqeAgent *) + 0x2F24 sqeAgent::RunEDU(void) + 0x9F4 sqzEDUObj::EDUDriver(void) + 0x2F0 sqloEDUEntry + 0x364 | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * SQL queries against column organized tables * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to 11.5.6 or later * **************************************************************** | |
Local Fix: | |
Do not use column organized tables or if using column organized tables, avoid out of memory error | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * SQL queries against column organized tables * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to 11.5.6 or later * **************************************************************** | |
Comment | |
Upgrade to 11.5.6 or later | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 18.02.2021 21.06.2021 21.06.2021 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |