INSERT into column-organized table might fail with error SQL901:
DB21034E The command was processed as an SQL statement
because it was not a
valid Command Line Processor command. During SQL processing
it returned:
SQL0901N The SQL statement or command failed because of a
database system
error. (Reason "unexpected error at
RegionWriteState.cpp:516".)
SQLSTATE=58004
This column-organized table contains a nullable variable length
string
column (VARCHAR/VARGRAPHIC) that has been altered to increase in
length.
In the database logs one can find entry similar to the one
below:
2017-09-25-09.25.29.318116+000 I21157422E3625 LEVEL:
Error
PID : 13760 TID : 139038027671296 PROC :
db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB :
DBNAME
APPHDL : 0-2963 APPID:
10.38.82.237.48706.170925092440
AUTHID : BORG HOSTNAME: MYHOST
EDUID : 56151 EDUNAME: db2agent (DBNAME) 0
FUNCTION: DB2 UDB, CDE Trace, cdeDiagnosticsFacility, probe:516
DATA #1 : String, 242 bytes
AssertionFailedException: An assertion
'mRegionForInserts->getBankCount() == bankCount' failed.
Additional info: region bank count does not match cell
descriptor: region count = 2 cell descriptor count = 1
Thrown at RegionWriteState.cpp : 516
DATA #2 : Function name in Library, 92 bytes
void
ibm_cde::data::RegionWriteState::registerRegionForInsert(ibm_cde
::data::Region *, bool)
DATA #3 : File name, 20 bytes
RegionWriteState.cpp
CALLSTCK: (Static functions may not be resolved correctly, as
they are resolved to the nearest symbol)
[0] 0x00007F1ABED7A179
_ZN7ibm_cde8services6Tracer9traceDataENS0_11ComponentIDENS0_16Co
mmonTraceLevelENS1_10TraceEventEPKcmS6_PKvmRKSbIcSt11char_trait
+ 0x369
[1] 0x00007F1ABED19FC2
_ZNK7ibm_cde8services13BaseException14traceExceptionENS0_11Compo
nentIDEPKc + 0x322
[2] 0x00007F1ABED11690
_ZN7ibm_cde8services24AssertionFailedException17constructAndThro
wENS0_11ComponentIDEPKcmS4_S4_RKNS0_16CdeOStringStreamE + 0xF0
[3] 0x00007F1ABF54B0CC
_ZN7ibm_cde4data16RegionWriteState23registerRegionForInsertEPNS0
_6RegionEb + 0x30C
[4] 0x00007F1ABF561F8A
_ZN7ibm_cde4data21ColumnGroupWriteState21registerPageForInsertEP
KNS0_4PageEb + 0x60A
[5] 0x00007F1ABF574262
_ZN7ibm_cde4data21ColumnGroupWriteState26initPageBufferFromLastP
ageENS_5types3TSNES3_ + 0x772
[6] 0x00007F1ABF3A977F
_ZN7ibm_cde4data11TableWriter32insertTupleToColumnGroupBufferedE
RKSt6vectorIPKNS_5types10ValUncodedENS_8services9AllocatorIS6_E
+ 0x17FF
[7] 0x00007F1ABF3A6FAC
_ZN7ibm_cde4data11TableWriter19insertTupleBufferedERKSt6vectorIP
KNS_5types10ValUncodedENS_8services9AllocatorIS6_EEEPK18sqlriCd
+ 0x2BC
[8] 0x00007F1ABF486093
_ZN7ibm_cde4data13TableAccessor17insertRowInternalERKNS0_18Uncod
edInsertTupleEbPKmPK18sqlriCdeColumnListS9_m + 0xF3
[9] 0x00007F1ABF485593
_ZN7ibm_cde4data13TableAccessor9insertRowERKSt6vectorINS_5types8
DataTypeENS_8services9AllocatorIS4_EEERKS2_IPKNS3_10ValUncodedE
+ 0x7A3
[10] 0x00007F1AC0E5E0C6
_ZN12cdeInterface13performInsertEPK18sqlriCdeColumnListP26cdeDir
ectInsertTupleHandlelPl + 0x466
[11] 0x00007F1AC4375B1A _Z18sqlriCdeFastInsertP8sqlrr_cb +
0x23A
[12] 0x00007F1AC43FA948
_Z15sqlriSectInvokeP8sqlrr_cbP12sqlri_opparm + 0x4F8
[13] 0x00007F1AC3E2BCD2
_Z29sqlrr_process_execute_requestP8sqlrr_cbib + 0xF32
[14] 0x00007F1AC3E0A936
_Z17sqlrr_array_inputP14db2UCinterfacePP15db2UCdiagStructmt +
0x1776
[15] 0x00007F1AC201F5F8
_Z19sqljs_ddm_excsqlsttP14db2UCinterfaceP13sqljDDMObject + 0x488
[16] 0x00007F1AC1FEA72B
_Z21sqljsParseRdbAccessedP13sqljsDrdaAsCbP13sqljDDMObjectP14db2U
Cinterface + 0x10B
[17] 0x00007F1AC1FEB7D6
_Z10sqljsParseP13sqljsDrdaAsCbP14db2UCinterfaceP8sqeAgentb +
0x546
[18] 0x00007F1AC1FDE63A /home/edwuat/sqllib/lib64/libdb2e.so.1
+ 0x559563A
[19] 0x00007F1AC1FE4C03 /home/edwuat/sqllib/lib64/libdb2e.so.1
+ 0x559BC03
[20] 0x00007F1AC1FE58BF
_Z17sqljsDrdaAsDriverP18SQLCC_INITSTRUCT_T + 0x11F
[21] 0x00007F1AC1A2BDB4 _ZN8sqeAgent6RunEDUEv + 0xDE4
[22] 0x00007F1AC5204276 _ZN9sqzEDUObj9EDUDriverEv + 0x116
[23] 0x00007F1AC37DD6E8 sqloEDUEntry + 0x578
[24] 0x00007F1ACB01F806 /lib64/libpthread.so.0 + 0x7806
[25] 0x00007F1ABB54D67D clone + 0x6D |
