DB2 - Problem description
Problem IT33293 | Status: Closed |
QUERY FAILING WITH SQL0901N AND AN ASSERTION FAILURE "UNABLE TO ACCESS TARGET PAGE FROM PAGE MAP" | |
product: | |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 | |
Problem description: | |
SQL using a column organized table may fail with an assertion failure and SQL0901N error as follows: 2020-05-22-18.24.11.432997+540 I11182521E4194 LEVEL: Error PID : 18806 TID : 47035663247104 PROC : db2sysc 10 INSTANCE: db2inst1 NODE : 010 DB : BLUDB APPHDL : 0-32837 APPID: 127.0.0.1.51554.200522092411 UOWID : 1 ACTID: 2 AUTHID : BLUADMIN HOSTNAME: hostname.ibm.com EDUID : 166222 EDUNAME: db2agntcol (BLUDB) 10 FUNCTION: DB2 UDB, CDE Trace, cdeDiagnosticsFacility, probe:815 DATA #1 : String, 1023 bytes AssertionFailedException: An assertion 'false' failed. Additional info: Unable to access target page from page map: ... DATA #2 : Function name in Library, 255 bytes ibm_cde::data::Page *ibm_cde::data::PageIteratorForTSNRange::readNextPageInternal(bool, unsigned int &, ibm_cde::data::PageRequest *&, bool &, bool &, bool *, const ibm_cde::data::PageDescriptor *) [with CheckAllCom DATA #3 : File name, 27 bytes PageIteratorForTSNRange.cpp CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol) [0] 0x00002AB9DF40BAB9 _ZN7ibm_cde8services6Tracer9traceDataENS0_11ComponentIDENS0_16Co mmonTraceLevelENS1_10TraceEventEPKcmS6_PKvmRKSbIcSt11char_trait + 0x369 [1] 0x00002AB9DF377777 _ZNK7ibm_cde8services13BaseException14traceExceptionENS0_11Compo nentIDEPKc + 0x337 [2] 0x00002AB9DF36DC4F _ZN7ibm_cde8services24AssertionFailedException17constructAndThro wENS0_11ComponentIDEPKcmS4_S4_RNS0_16CdeOStringStreamE + 0x13F [3] 0x00002AB9DFF8F917 _ZN7ibm_cde4data23PageIteratorForTSNRangeILb0ELb0EE20readNextPag eInternalILb0ELb0EEEPNS0_4PageEbRjRPNS0_11PageRequestERbSA_PbPK + 0x1B57 [4] 0x00002AB9DFF903D8 _ZN7ibm_cde4data23PageIteratorForTSNRangeILb0ELb0EE12readNextPag eERjRPNS0_11PageRequestE + 0x28 [5] 0x00002AB9E0DEFAC0 _ZN7ibm_cde5query21LoadColValueEvaluator15processTSNRangeILNS0_3 OpTE305ENS_5types7IntegerIiEES6_EEvv + 0x8A0 [6] 0x00002AB9E0CC54EE _ZN7ibm_cde5query21LoadColValueEvaluator26processInputsSynchrono uslyEv + 0x2CE ... 2020-05-22-18.24.11.470951+540 I11186716E5833 LEVEL: Severe (Origin) PID : 18806 TID : 47035663247104 PROC : db2sysc 10 INSTANCE: db2inst1 NODE : 010 DB : BLUDB APPHDL : 0-32837 APPID: 127.0.0.1.51554.200522092411 UOWID : 1 ACTID: 2 AUTHID : BLUADMIN HOSTNAME: hostname.ibm.com EDUID : 166222 EDUNAME: db2agntcol (BLUDB) 10 FUNCTION: DB2 UDB, CDE Trace, cdeDiagnosticsFacility, probe:815 MESSAGE : SQL0901N The SQL statement or command failed because of a database system error. (Reason "".) DATA #1 : 'false' failed. Info: Unable to access target page from page map: ... ----- Begin dump of Page object at 0x00002abb79198030 ----- ... ------ End dump of Page object at 0x00002abb79198030 ------ currentPageLSN: 428006938 commitLSN: 434388247 isPageLSNBelowReadLSN: 1 currentTSN: 144115188075896650 (0x0200000000009f4a) | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * all * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to db2_v115m5fp0 or later * **************************************************************** | |
Local Fix: | |
db2set -im DB2_EXTENDED_OPTIMIZATION="PARTSCAN 100" (plus any existing settings) | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 23.06.2020 19.11.2020 19.11.2020 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |