When issuing a complex insert/update/delete statement involving
column-organized tables and common subexpressions, you might
encounter an sqlcode -901 and/or trap similar to the following
(this does not occur in MPP configurations):
-----FUNC-ADDR---- ------FUNCTION + OFFSET------
0x00007F06EE0C0196
_Z25ossDumpStackTraceInternalmR11OSSTrapFileiP7siginfoPvmm +
0x0356
(/home/svtdbm/sqllib/lib64/libdb2osse.so.1)
0x00007F06EE0BFDDB ossDumpStackTraceV98 + 0x002b
(/home/svtdbm/sqllib/lib64/libdb2osse.so.1)
0x00007F06EE0BBFD7 _ZN11OSSTrapFile6dumpExEmiP7siginfoPvm +
0x00d7
(/home/svtdbm/sqllib/lib64/libdb2osse.so.1)
0x00007F06F874D6C9 sqlo_trce + 0x03e9
(/home/svtdbm/sqllib/lib64/libdb2e.so.1)
0x00007F06F88E91AB sqloDumpDiagInfoHandler + 0x020b
(/home/svtdbm/sqllib/lib64/libdb2e.so.1)
0x00007F07019C6630 address: 0x00007F07019C6630 ; dladdress:
0x00007F07019B7000 ; offset in lib: 0x000000000000F630 ;
(/lib64/libpthread.so.0)
0x00007F07019C3AA1 pthread_kill + 0x0031
(/lib64/libpthread.so.0)
0x00007F06F88E8D62 sqloDumpEDU + 0x0052
(/home/svtdbm/sqllib/lib64/libdb2e.so.1)
0x00007F06F134A699 _Z15sqldDumpContextP9sqeBsuEduiiiiiPKcPvi +
0x11e9
(/home/svtdbm/sqllib/lib64/libdb2e.so.1)
0x00007F06F8F9D0C3 _Z15sqlrr_dump_ffdcP8sqlrr_cbii + 0x06f3
(/home/svtdbm/sqllib/lib64/libdb2e.so.1)
0x00007F06FA4D5786 _Z13sqlzeDumpFFDCP8sqeAgentjP5sqlcai + 0x00a6
(/home/svtdbm/sqllib/lib64/libdb2e.so.1)
0x00007F06FA4D55A9
_Z12sqlzeSqlCodeP8sqeAgentjmjP5sqlcaitP13__va_list_tag + 0x0199
(/home/svtdbm/sqllib/lib64/libdb2e.so.1)
0x00007F06F90C2D9D sqlrrSqlCode + 0x00dd
(/home/svtdbm/sqllib/lib64/libdb2e.so.1)
0x00007F06F1685E35
_ZN7ibm_cde8services24AssertionFailedException4doneEv + 0x08e5
(/home/svtdbm/sqllib/lib64/libdb2e.so.1)
0x00007F06F1689219
_ZN7ibm_cde8services24AssertionFailedException17constructAndThro
wENS0_11ComponentIDEPKcmS4_S4_RNS0_16CdeOStringStreamE + 0x0149
(/home/svtdbm/sqllib/lib64/libdb2e.so.1)
0x00007F06F33C010C
_ZN7ibm_cde5query14CommonStmtInfo10addCseTempERSbIcSt11char_trai
tsIcENS_8services9AllocatorIcEEEPNS4_14SpillableStoreE + 0x078c
(/home/svtdbm/sqllib/lib64/libdb2e.so.1)
0x00007F06F33B255A
_ZN7ibm_cde5query24LoadNestedQueryEvaluator23getCseNestedQueryOu
tputERmRSt6vectorINS_8services18CountedPtrWithCopyIKNS_5types10V
ectorBaseILNS6_12NullIndParamE0ELNS6_6PolicyE0EEELNS4_16CountedP
trDeleteE2ELNS4_19CountedPtrThreadingE1EEENS4_9AllocatorISE_EEE
+ 0x06ca
(/home/svtdbm/sqllib/lib64/libdb2e.so.1)
0x00007F06F33B1B43
_ZN7ibm_cde5query24LoadNestedQueryEvaluator26processInputsSynchr
onouslyEv + 0x1f13
(/home/svtdbm/sqllib/lib64/libdb2e.so.1)
0x00007F06F3088F7A
_ZN7ibm_cde5query9Evaluator8evaluateEbbRNS1_21EvaluatorRestartSt
ateEPNS0_19OptPredicateTrackerE + 0x04da
(/home/svtdbm/sqllib/lib64/libdb2e.so.1)
0x00007F06F2FFEAB1
_ZN7ibm_cde5query17EvaluationRoutine8evaluateEjP15sql_static_dat
a + 0x0321
(/home/svtdbm/sqllib/lib64/libdb2e.so.1)
0x00007F06F388BBB6
_ZN7ibm_cde5query9Scheduler13evaluateChainEPNS0_17EvaluationRout
ineERmj + 0x01c6
(/home/svtdbm/sqllib/lib64/libdb2e.so.1)
0x00007F06F388F56B
_ZN7ibm_cde5query9Scheduler15runWorkerThreadEPvPi + 0x030b
(/home/svtdbm/sqllib/lib64/libdb2e.so.1)
0x00007F06F38A05FE
_ZN7ibm_cde5query17cdeEntryPointImplEP8sqeAgentPvS3_ + 0x006e
(/home/svtdbm/sqllib/lib64/libdb2e.so.1)
0x00007F06F44CC245
_ZN12cdeInterface16startCdeSubagentEP8sqeAgent + 0x0295
(/home/svtdbm/sqllib/lib64/libdb2e.so.1)
0x00007F06F979DD0F _Z14sqlriInvokeCdeP8sqlrr_cb + 0x003f
(/home/svtdbm/sqllib/lib64/libdb2e.so.1)
0x00007F06F95F73B9 _Z15sqlriSectInvokeP8sqlrr_cbP12sqlri_opparm
+ 0x04e9
(/home/svtdbm/sqllib/lib64/libdb2e.so.1)
0x00007F06F8FDF880 _Z16sqlrr_smp_routerP8sqlrr_cb + 0x03f0
(/home/svtdbm/sqllib/lib64/libdb2e.so.1)
0x00007F06F8FDE14E
_Z21sqlrr_subagent_routerP8sqeAgentP12SQLE_DB2RA_T + 0x09be
(/home/svtdbm/sqllib/lib64/libdb2e.so.1)
0x00007F06F6762EBD address: 0x00007F06F6762EBD ; dladdress:
0x00007F06EE637000 ; offset in lib: 0x000000000812BEBD ;
(/home/svtdbm/sqllib/lib64/libdb2e.so.1)
0x00007F06F676024F _Z21sqleProcessSubRequestP8sqeAgent + 0x08ff
(/home/svtdbm/sqllib/lib64/libdb2e.so.1)
0x00007F06F6795A34 _ZN8sqeAgent6RunEDUEv + 0x0604
(/home/svtdbm/sqllib/lib64/libdb2e.so.1)
0x00007F06FA4D5D8E _ZN9sqzEDUObj9EDUDriverEv + 0x01be
(/home/svtdbm/sqllib/lib64/libdb2e.so.1)
0x00007F06F88E6C19 sqloEDUEntry + 0x0589
(/home/svtdbm/sqllib/lib64/libdb2e.so.1)
0x00007F07019BEEA5 address: 0x00007F07019BEEA5 ; dladdress:
0x00007F07019B7000 ; offset in lib: 0x0000000000007EA5 ;
(/lib64/libpthread.so.0)
0x00007F06ED0AF8DD clone + 0x006d
(/lib64/libc.so.6)
and db2diag.log are similar to this:
2020-09-04-03.05.03.447175-240 I14925047E3340 LEVEL:
Error
PID : 14661 TID : 139646503741184 PROC :
db2sysc
INSTANCE: svtdbm NODE : 000 DB :
TESTCVC
APPHDL : 0-67 APPID: xxxx
UOWID : 1 ACTID: 2
AUTHID : xxxx HOSTNAME: xxxx
EDUID : 200 EDUNAME: db2agntcol (TESTCVC)
FUNCTION: DB2 UDB, CDE Trace, cdeDiagnosticsFacility, probe:460
DATA #1 : String, 247 bytes
AssertionFailedException: An assertion
'mCseTempMap.find(cseTempName) == mCseTempMap.end()' failed.
Additional info: CSE temp TEMP0 al
ready exists
Thrown at
/view/db2_v115m5fp0_linuxamd64_s2009021300/vbs/engn/cde/query/Qu
eryInfoContainer.hpp : 460
DATA #2 : Function name in Library, 171 bytes
void
ibm_cde::query::CommonStmtInfo::addCseTemp(std::basic_string
&,
ibm_cde::services::SpillableStore *)
DATA #3 : File name, 84 bytes
/view/db2_v115m5fp0_linuxamd64_s2009021300/vbs/engn/cde/query/Qu
eryInfoContainer.hpp
CALLSTCK: (Static functions may not be resolved correctly, as
they are resolved to the nearest symbol)
[0] 0x00007F06F172A7E9
_ZN7ibm_cde8services6Tracer9traceDataENS0_11ComponentIDENS0_16Co
mmonTraceLevelENS1_10TraceEventEPKcmS6_PKvmRKSbIcSt11char_trait
+ 0x4B9
[1] 0x00007F06F16943B3
_ZNK7ibm_cde8services13BaseException14traceExceptionENS0_11Compo
nentIDEPKc + 0x323
[2] 0x00007F06F168920F
_ZN7ibm_cde8services24AssertionFailedException17constructAndThro
wENS0_11ComponentIDEPKcmS4_S4_RNS0_16CdeOStringStreamE + 0x13F
[3] 0x00007F06F33C010C
_ZN7ibm_cde5query14CommonStmtInfo10addCseTempERSbIcSt11char_trai
tsIcENS_8services9AllocatorIcEEEPNS4_14SpillableStoreE + 0x78C
[4] 0x00007F06F33B255A
_ZN7ibm_cde5query24LoadNestedQueryEvaluator23getCseNestedQueryOu
tputERmRSt6vectorINS_8services18CountedPtrWithCopyIKNS_5types10
+ 0x6CA
[5] 0x00007F06F33B1B43
_ZN7ibm_cde5query24LoadNestedQueryEvaluator26processInputsSynchr
onouslyEv + 0x1F13
[6] 0x00007F06F3088F7A
_ZN7ibm_cde5query9Evaluator8evaluateEbbRNS1_21EvaluatorRestartSt
ateEPNS0_19OptPredicateTrackerE + 0x4DA
[7] 0x00007F06F2FFEAB1
_ZN7ibm_cde5query17EvaluationRoutine8evaluateEjP15sql_static_dat
a + 0x321
[8] 0x00007F06F388BBB6
_ZN7ibm_cde5query9Scheduler13evaluateChainEPNS0_17EvaluationRout
ineERmj + 0x1C6
[9] 0x00007F06F388F56B
_ZN7ibm_cde5query9Scheduler15runWorkerThreadEPvPi + 0x30B
[10] 0x00007F06F38A05FE
_ZN7ibm_cde5query17cdeEntryPointImplEP8sqeAgentPvS3_ + 0x6E
[11] 0x00007F06F44CC245
_ZN12cdeInterface16startCdeSubagentEP8sqeAgent + 0x295
[12] 0x00007F06F979DD0F _Z14sqlriInvokeCdeP8sqlrr_cb + 0x3F
[13] 0x00007F06F95F73B9
_Z15sqlriSectInvokeP8sqlrr_cbP12sqlri_opparm + 0x4E9
[14] 0x00007F06F8FDF880 _Z16sqlrr_smp_routerP8sqlrr_cb + 0x3F0
[15] 0x00007F06F8FDE14E
_Z21sqlrr_subagent_routerP8sqeAgentP12SQLE_DB2RA_T + 0x9BE
[16] 0x00007F06F6762EBD /home/svtdbm/sqllib/lib64/libdb2e.so.1
+ 0x812BEBD
[17] 0x00007F06F676024F _Z21sqleProcessSubRequestP8sqeAgent +
0x8FF
[18] 0x00007F06F6795A34 _ZN8sqeAgent6RunEDUEv + 0x604
[19] 0x00007F06FA4D5D8E _ZN9sqzEDUObj9EDUDriverEv + 0x1BE
[20] 0x00007F06F88E6C19 sqloEDUEntry + 0x589
[21] 0x00007F07019BEEA5 /lib64/libpthread.so.0 + 0x7EA5
[22] 0x00007F06ED0AF8DD clone + 0x6D
2020-09-04-03.05.04.107113-240 E14931230E863 LEVEL:
Error
PID : 14661 TID : 139646503741184 PROC :
db2sysc
INSTANCE: svtdbm NODE : 000 DB :
TESTCVC
APPHDL : 0-67 APPID: xxxx
UOWID : 1 ACTID: 2
AUTHID : xxxx HOSTNAME: xxxx
EDUID : 200 EDUNAME: db2agntcol
FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc, probe:30
MESSAGE : ADM14005E The following error occurred: "AppErr".
First Occurrence
Data Capture (FODC) has been invoked in the following
mode:
"Automatic". Diagnostic information has been recorded
in the
directory named
"/home/svtdbm/sqllib/db2dump/FODC_AppErr_2020-09-04-03.05.04.104
405_1
4661_200_000/".
2020-09-04-03.05.04.166839-240 I14934688E973 LEVEL:
Severe
PID : 14661 TID : 139646503741184 PROC :
db2sysc
INSTANCE: svtdbm NODE : 000 DB :
TESTCVC
APPHDL : 0-67 APPID: xxxx
UOWID : 1 ACTID: 2
AUTHID : xxxx HOSTNAME: xxxx
EDUID : 200 EDUNAME: db2agntcol
FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc,
probe:300
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -901 sqlerrml: 46
sqlerrmc: unexpected error at QueryInfoContainer.hpp:460
sqlerrp : SQLCT001
sqlerrd : (1) 0x00000000 (2) 0x00000000 (3)
0x00000000
(4) 0x00000000 (5) 0xFFFFFE34 (6)
0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate: |
To avoid this error you can set the following registry variables
either for the whole instance or via an optimization guideline
for a specific SQL statement. NOTE: the instance-level setting
might slow down all insert/update/delete statements.
Instance-level:
db2set -immediate DB2_REDUCED_OPTIMIZATION="NO_RTABLE_INS"
db2set -immediate DB2_EXTENDED_OPTIMIZATION="COL_PAR_IUD
DISABLE"
(and then flush the dynamic package cache).
If DB2_REDUCED_OPTIMIZATION and/or DB2_EXTENDED_OPTIMIZATION
already have existing settings, you can add the new keywords to
the end, separated by a comma (no spaces).
Optimization guideline: the example shown here is an embedded
guideline added to the end of the SQL statement (before any
terminating semicolon). The guideline can also be applied via an
optimization profile.
/*
*/
If the registry variables have existing settings, include those
settings in the guideline and add the new keyword to the end of
each, separated by a comma (no spaces). |
