|
Problem IT33570
|
Status: Closed |
A CDE UPDATE STATEMENT MIGHT FAIL WITH SQL0901N '!ISROWLOGBUFFERINITIALIZED()' AND TRAP IN SQERDFSROWSERIALIZER
|
| product: |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 |
| Problem description: |
A CDE update statement might fail with -901 and subsequent
traps:
2020-06-04-09.44.23.660122+180 I27427194E2563 LEVEL:
Severe (Origin)
PID : 93984 TID : 138088542103296 PROC :
db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB :
BLUDB
APPHDL : 0-8272 APPID:
10.8.114.197.50666.200604043642
UOWID : 7 ACTID: 12 AUTHID :
ETL
EDUID : 41744 EDUNAME: db2agnts (BLUDB) 0
FUNCTION: DB2 UDB, CDE Trace, cdeDiagnosticsFacility, probe:1039
MESSAGE : SQL0901N The SQL statement or command failed because
of a database
system error. (Reason "".)
DATA #1 :
'!isRowLogBufferInitialized()' failed. Info: The row log buffer
should NOT be initialized.
A trap file might show:
-----FUNC-ADDR---- ------FUNCTION + OFFSET------
0x00007F1FBB7CC006
_Z25ossDumpStackTraceInternalmR11OSSTrapFileiP7sigi
(/mnt/blumeta0/home/db2inst1/sqllib/lib64/libdb2osse.so.1)
0x00007F1FBB7CBC4B ossDumpStackTraceV98 + 0x002b
(/mnt/blumeta0/home/db2inst1/sqllib/lib64/libdb2osse.so.1)
0x00007F1FBB7C7E37 _ZN11OSSTrapFile6dumpExEmiP7siginfoPvm +
0x00d7
(/mnt/blumeta0/home/db2inst1/sqllib/lib64/libdb2osse.so.1)
0x00007F1FC54C4D77 sqlo_trce + 0x03c7
(/mnt/blumeta0/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00007F1FC565DF50 sqloEDUCodeTrapHandler + 0x02b0
(/mnt/blumeta0/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00007F1FCE37A5D0 address: 0x00007F1FCE37A5D0 ; dladdress:
0x00007F1F
(/lib64/libpthread.so.0)
0x0000000000424F20 __intel_avx_rep_memcpy + 0x0440
(db2sysc 0)
0x00007F1FC3951A44
_ZN20sqerDFSRowSerializer12serializeRowEP8sqlrr_cbP
(/mnt/blumeta0/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00007F1FC3949FD3
_Z16sqlerExtTableIUDP8sqeAgentP18sqerExtTableHandle
(/mnt/blumeta0/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00007F1FBFCADC2A
_ZN7ibm_cde4data10Replicator14writeSingleRowILNS1_9
(/mnt/blumeta0/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00007F1FBFCB3F6D
_ZN7ibm_cde4data16DeleteReplicator9replicateEPK18sq
(/mnt/blumeta0/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00007F1FBF33D0F5
_ZN7ibm_cde4data21DatabaseTableAccessor9deleteRowEN
(/mnt/blumeta0/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00007F1FC17BF0C4
_ZN25cdeTableAccessorInterface19decomposedUpdateRow
(/mnt/blumeta0/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00007F1FC17BE170
_ZN12cdeInterface13performUpdateEmmPK18sqlriCdeColu
(/mnt/blumeta0/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00007F1FC62799C7 _Z18sqlriCdeFastUpdateP8sqlrr_cb + 0x02e7
(/mnt/blumeta0/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00007F1FC6310EC5 _Z15sqlriSectInvokeP8sqlrr_cbP12sqlri_opparm
+ 0x04
(/mnt/blumeta0/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00007F1FC5D1D7A4 _Z16sqlrr_smp_routerP8sqlrr_cb + 0x03e4
(/mnt/blumeta0/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00007F1FC5D1C16A
_Z21sqlrr_subagent_routerP8sqeAgentP12SQLE_DB2RA_T
(/mnt/blumeta0/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00007F1FC3579563 address: 0x00007F1FC3579563 ; dladdress:
0x00007F1F
(/mnt/blumeta0/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00007F1FC3576BEF _Z21sqleProcessSubRequestP8sqeAgent + 0x08ff
(/mnt/blumeta0/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00007F1FC35AB634 _ZN8sqeAgent6RunEDUEv + 0x0604
(/mnt/blumeta0/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00007F1FC71FED0E _ZN9sqzEDUObj9EDUDriverEv + 0x01be
(/mnt/blumeta0/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00007F1FC565B509 sqloEDUEntry + 0x0589
(/mnt/blumeta0/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00007F1FCE372DD5 address: 0x00007F1FCE372DD5 ; dladdress:
0x00007F1F
(/lib64/libpthread.so.0)
0x00007F1FBA7C602D clone + 0x006d |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* all *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to db2_v115m5fp0 or later *
**************************************************************** |
| Local Fix: |
|
| Solution |
|
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 16.07.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) |
