DB2 - Problem description
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) |