DB2 - Problem description
Problem IT21808 | Status: Closed |
VARIOUS MEMORY LEAKS IN DB2SYSC WHEN USING TEXTSEARCH | |
product: | |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 | |
Problem description: | |
Using TextSearch can lead to various memory leaks in db2sysc. The following stack traces for blocks that are leaking will depend on what commands are run, select, update via stored procedure, etc... Block sizes are omitted from the list below because most likely they would change based on the platform. 0x0090000000004c928 malloc_common_debugging 0x00900000000ba9b10 _Fancy_malloc 0x00900000000bacf50 __nw__FUlRCQ2_3std9nothrow_t 0x00900000023ac17c0 cie::CteCommand::createMiniIndexObject() 0x00900000023ac45cc cie::CteCommand::checkDistribution() 0x00900000023abeba4 cie::CteCommand::executeVerify() 0x0090000001fb772f4 CIESRVSP_FG() 0x0090000001fb780fc ciesrvsp() 0x00900000012950bd0 sqloInvokeFnArgs 0x0090000000004c928 malloc_common_debugging 0x00900000000ba9b10 _Fancy_malloc 0x00900000000bacf50 __nw__FUlRCQ2_3std9nothrow_t 0x00900000000bace90 __vn__FUlRCQ2_3std9nothrow_t 0x009000000237e6414 cie::CteCLIDataType::CteCLIDataType() 0x009000000237eb440 cie::CteCLIUchar::CteCLIUchar() 0x009000000237e8948 cie::CteCLIVarchar::CteCLIVarchar() 0x0090000002388055c cie::CteTextIndexDefinition::CteTextIndexDefinition() 0x00900000023ac1814 cie::CteCommand::createMiniIndexObject() 0x00900000023ac45cc cie::CteCommand::checkDistribution() 0x00900000023abeba4 cie::CteCommand::executeVerify() 0x0090000001fb772f4 CIESRVSP_FG() 0x00900000000ba9b10 _Fancy_malloc 0x00900000000bacf50 __nw 0x00900000000bace90 __vn 0x009000000237e6414 cie::CteCLIDataType::CteCLIDataType() 0x009000000237eb440 cie::CteCLIUchar::CteCLIUchar() 0x009000000237e91c8 cie::CteCLIBinary::CteCLIBinary() 0x00900000023943144 cie::CteKeyColumns::CteKeyColumns() 0x009000000239a64ec cie::CteLogTableRow::CteLogTableRow() 0x009000000239a6a38 cie::CteLogTableRowClassic::CteLogTableRowClassic() 0x0090000002397338c cie::CteLogTableClassic::CteLogTableClassic() 0x00900000023961a58 cie::CteLogTable::newCteLogTable() 0x00900000000ba9b10 _Fancy_malloc 0x00900000000bad42c init_pres 0x009000000237ef9b8 std::list 0x009000000237ef83c cie::CteCLIDataTypeList::add() 0x00900000023837c00 cie::CteColumnListDescription::newCteCLIDatatypes() 0x00900000023943258 cie::CteKeyColumns::CteKeyColumns() 0x009000000239a64ec cie::CteLogTableRow::CteLogTableRow() 0x009000000239a6a38 cie::CteLogTableRowClassic::CteLogTableRowClassic() 0x0090000002397338c cie::CteLogTableClassic::CteLogTableClassic() 0x00900000023961a58 cie::CteLogTable::newCteLogTable() 0x00900000023ac3628 cie::CteCommand::checkDistribution() 0x009000000237c5e38 std::basic_ostream 0x009000000237c3990 cie::CteCLISelectAbstractStmt::getTypeInfo() 0x009000000237f2244 cie::CteSQLTypeInfo::determineTypeInfo() 0x00900000023841940 cie::CteTextColumnDescription::determineTypeInfo() 0x009000000237c5e38 std::basic_ostream 0x009000000237c3990 cie::CteCLISelectAbstractStmt::getTypeInfo() 0x009000000237f2244 cie::CteSQLTypeInfo::determineTypeInfo() 0x00900000023841940 cie::CteTextColumnDescription::determineTypeInfo() 0x00900000023875030 cie::CteTextIndexExtendedInformation::getTypeInformation() 0x0090000002386df24 cie::CteTextIndexExtendedInformation::checkAndFinalize() 0x009000000237c5dc0 std::basic_ostream 0x009000000237c3990 cie::CteCLISelectAbstractStmt::getTypeInfo() 0x009000000237f2244 cie::CteSQLTypeInfo::determineTypeInfo() 0x00900000023841940 cie::CteTextColumnDescription::determineTypeInfo() 0x00900000023875030 cie::CteTextIndexExtendedInformation::getTypeInformation() 0x0090000002386df24 cie::CteTextIndexExtendedInformation::checkAndFinalize() 0x0090000002386ee48 cie::CteTextIndexExtendedInformation::CteTextIndexExtendedInform ation() 0x00900000023ac3590 cie::CteCommand::checkDistribution() 0x00900000023f7a1e8 std::basic_filebuf::_Initcvt() 0x00900000023f76c00 std::basic_ifstream::basic_ifstream() 0x00900000023f75060 cie::CteDB2NodesCfg::checkForDB2NodesCfg() 0x00900000023f78c70 cie::CteDB2NodesCfg::isDPFsetup() 0x00900000023ac31ac cie::CteCommand::checkDistribution() 0x00900000023abeba4 cie::CteCommand::executeVerify() 0x00900000000ba9b10 _Fancy_malloc__FUl 0x00900000000ba9a2c init_pres__FUl 0x0090000000067f698 _Allocate__3stdHc_UlPc_Pc 0x0090000000067f618 allocate__Q2_3std9allocatorXTc_FUlPCv 0x0090000000067f404 _Copy__Q2_3std12basic_stringXTcTQ2_3std11char_traitsXTc_TQ2_3st 0x0090000000067eef4 _Grow__Q2_3std12basic_stringXTcTQ2_3std11char_traitsXTc_TQ2_3st 0x0090000000067e50c assign__Q2_3std12basic_stringXTcTQ2_3std11char_traitsXTc_TQ2_3s 0x00900000023f7425c cie::CteNodeInfo::CteNodeInfo() 0x00900000023f75218 cie::CteDB2NodesCfg::checkForDB2NodesCfg() 0x00900000023f78c70 cie::CteDB2NodesCfg::isDPFsetup() 0x00900000023ac31ac cie::CteCommand::checkDistribution() | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 11.1 Mod 2 Fix Pack 2 or higher * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
BUG-Tracking | |
forerunner : IT18287 follow-up : | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 04.08.2017 24.10.2017 24.10.2017 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |