|
Problem IT37801
|
Status: Closed |
UPDATE OF A COLUMN-ORGANIZED TABLE WITH A SEARCH PREDICATE ON ANINDEX MIGHT RETURN A SQL901 ERROR DURING EXECUTION.
|
| product: |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 |
| Problem description: |
When performing an update on a column-organized table, the
update might return a SQL901 error if it contains a predicate
that could be evaluated using an index scan.
The failure is likely to occur if the following additional
conditions are met:
+ The update statement contains another predicate that cannot be
evaluated using an index.
+ The update statement uses parameter markers and array input
processing.
2021-07-22-06.47.33.753454+120 I8020911E3243 LEVEL:
Severe (Origin)
PID : 5381 TID : 140387431737088 PROC :
db2sysc 0
INSTANCE: xxxxxxxx NODE : 000 DB :
XXXXXXXX
APPHDL : 0-3520 APPID: 10.xxxxxxxxxxxxxxxxxxxxxxx
UOWID : 4 ACTID: 23
AUTHID : XXXXXXXXXXXXX HOSTNAME:
xxxxxxxx.xxxxxxxxxxxxxxxxxxx
EDUID : 8682 EDUNAME: db2agent (XXXXXXXX) 0
FUNCTION: DB2 UDB, CDE Trace, cdeDiagnosticsFacility, probe:1635
MESSAGE : SQL0901N The SQL statement or command failed because
of a database
system error. (Reason "".)
DATA #1 :
'pInsertRange != __null' failed. Info: InsertRange not reserved.
threadID = 0
isParallelUpdate = 0
Additional context info:
----- Begin dump of TableAccessor object at 0x00007fb03e99f0d0
-----
mMaxThreads = 8
mTableUse = 0
mIsDecomposedUpdate = 1
mIsMultiUpdatePossible = 0
mIsDelete = 0
mIsDeferredUnique = 0
mIsIgnoreDuplicates = 0
mIsWriteConflictOn = 1
mIsTwoPassUpdateOrDelete = 0
mIsSkipLockedData = 0
mIsSetIntegrity = 0
mInsertRanges: InsertRange address RangeIndex TableWriter
address
------------------------------------ ----------
-------------------
----- Begin dump of Table object at 0x00007fc47fe59700 -----
TableID: 0x003A0010 => (pool=16:obj=58:flags=2) TableName:
PR.XXXXXXXXXXXXXXXXXXXXXXXXX
mHasSynopsisTable = true
mIsSynopsisTable = false
------ End dump of Table object at 0x00007fc47fe59700 ------
------ End dump of TableAccessor object at 0x00007fb03e99f0d0
------
CALLSTCK: (Static functions may not be resolved correctly, as
they are resolved to the nearest symbol)
[0] 0x00007FFFE8DEB699 pdLogPrintf + 0x79
[1] 0x00007FFFE984A519
_ZN7ibm_cde8services24AssertionFailedException4doneEv + 0x9B9
[2] 0x00007FFFE984C84F
_ZN7ibm_cde8services24AssertionFailedException17constructAndThro
wENS0_11ComponentIDEPKcmS4_S4_RNS0_16CdeOStringStreamE + 0xBF
[3] 0x00007FFFEA3F5482
/insthome/XXXXXXXX/sqllib/lib64/libdb2e.so.1 + 0x3E37482
[4] 0x00007FFFEC2DD54A
_ZN12cdeInterface30handleInsertCompletedForThreadEbl + 0x4A
[5] 0x00007FFFF1C9D464
_Z13sqlriCdeCloseP8sqlrr_cbP17sqlriCdeStatementlb + 0x8A4
[6] 0x00007FFFF1CA0EAF _Z11sqlriCdeIUDP8sqlrr_cb + 0xFF
[7] 0x00007FFFF1D39B87
_Z15sqlriSectInvokeP8sqlrr_cbP12sqlri_opparm + 0x5E7
[8] 0x00007FFFF17FA0F0
_Z29sqlrr_process_execute_requestP8sqlrr_cbib + 0x8E0
[9] 0x00007FFFF17CF4FD
_Z17sqlrr_array_inputP14db2UCinterfacePP15db2UCdiagStructmt +
0x31D
[10] 0x00007FFFEF22B18E
_Z19sqljs_ddm_excsqlsttP14db2UCinterfaceP13sqljDDMObject + 0x2DE
[11] 0x00007FFFEF1E5B66
_Z21sqljsParseRdbAccessedP13sqljsDrdaAsCbP13sqljDDMObjectP14db2U
Cinterface + 0x156
[12] 0x00007FFFEF1E78DA
_Z10sqljsParseP13sqljsDrdaAsCbP14db2UCinterfaceP8sqeAgentb +
0x83A
[13] 0x00007FFFEF1DECD1
/insthome/XXXXXXXXX/sqllib/lib64/libdb2e.so.1 + 0x8C20CD1
[14] 0x00007FFFEF1E2C45
_Z17sqljsDrdaAsDriverP18SQLCC_INITSTRUCT_T + 0xCF5
[15] 0x00007FFFEEB3B539 _ZN8sqeAgent6RunEDUEv + 0x639
[16] 0x00007FFFF2DC1734 _ZN9sqzEDUObj9EDUDriverEv + 0x1A4
[17] 0x00007FFFF1063599 sqloEDUEntry + 0x2A9
[18] 0x00007FFFF7BC6EA5 /lib64/libpthread.so.0 + 0x7EA5
[19] 0x00007FFFE54F59FD clone + 0x6D |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* CDE *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Please Upgrade to 11.5.7 *
**************************************************************** |
| Local Fix: |
|
| Solution |
|
| Workaround |
****************************************************************
* USERS AFFECTED: *
* CDE *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Please Upgrade to 11.5.7 *
**************************************************************** |
| Comment |
Please Upgrade to 11.5.7 |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 28.07.2021
30.11.2021
30.11.2021 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
