DB2 - Problem description
Problem IT37868 | Status: Closed |
FODC_APPERR: 'COLUMN.GETISNULLABLE()' ASSERTION DURING REPLICATION FOR COLUMN-ORGANIZED TABLES | |
product: | |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 | |
Problem description: | |
An FODC_AppErr can occur if conducting replication on a table with the following conditions: * Column organized table * A column with a primary key or unique constraint * Indexes on one or more of the columns * NULL values in any of the columns with indexes This message should also show up in the db2diag.log: FUNCTION: DB2 UDB, CDE Trace, cdeDiagnosticsFacility, probe:1228 DATA #1 : String, 196 bytes AssertionFailedException: An assertion 'column.getIsNullable()' failed. Additional info: colList returned NULL value for not-NULL column: TEST.T5.PrevRowTSN:1:8 Thrown at Replicator.cpp : 1228 DATA #2 : Function name in Library, 83 bytes Uint64 ibm_cde::data::Replicator::formatValuesForLogging(const sqlriCdeColumnList*) DATA #3 : File name, 14 bytes Replicator.cpp CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol) [0] 0x00007F9F62E438D7 _ZN7ibm_cde8services6Tracer9traceDataENS0_11ComponentIDENS0_16Co mmonTraceLevelENS1_10TraceEventEPKcmS6_PKvmRKSbIcSt11char_trait + 0x9A7 [1] 0x00007F9F62DDF29B _ZNK7ibm_cde8services13BaseException14traceExceptionENS0_11Compo nentIDEPKc + 0x26B [2] 0x00007F9F62DD9057 _ZN7ibm_cde8services24AssertionFailedException17constructAndThro wENS0_11ComponentIDEPKcmS4_S4_RNS0_16CdeOStringStreamE + 0xB7 [3] 0x00007F9F63C58E88 _ZN7ibm_cde4data10Replicator22formatValuesForLoggingEPK18sqlriCd eColumnList + 0x248 [4] 0x00007F9F63C617E3 _ZN7ibm_cde4data10Replicator14writeSingleRowILNS1_9OperationE2EE EvPK18sqlriCdeColumnListPKNS_5types3TSNE + 0x1F3 [5] 0x00007F9F63C63418 _ZN7ibm_cde4data16DeleteReplicator9replicateEPK18sqlriCdeColumnL istPKNS_5types3TSNE + 0x58 [6] 0x00007F9F63471B08 _ZN7ibm_cde4data21DatabaseTableAccessor9deleteRowENS_5types3TSNE PKNS2_7IntegerIlEEPK18sqlriCdeColumnListP10SQLI_IXPCRm + 0x10B8 [7] 0x00007F9F65871840 _ZN25cdeTableAccessorInterface9deleteRowEmPK18sqlriCdeColumnList P10SQLI_IXPCRRb + 0x360 [8] 0x00007F9F65871FF2 _ZN12cdeInterface13performDeleteEmPK18sqlriCdeColumnListP10SQLI_ IXPCRRb + 0x192 [9] 0x00007F9F6B252593 _Z18sqlriCdeFastDeleteP8sqlrr_cb + 0x1B3 [10] 0x00007F9F6B2E8E27 _Z15sqlriSectInvokeP8sqlrr_cbP12sqlri_opparm + 0x5E7 [11] 0x00007F9F6ADA4ED4 _Z23sqlrr_execute_immediateP8sqlrr_cbi + 0x7C4 [12] 0x00007F9F6AD7604F _Z14sqlrr_execimmdP14db2UCinterfaceP16db2UCprepareInfo + 0x12F [13] 0x00007F9F687D4D55 _Z19sqljs_ddm_excsqlimmP14db2UCinterfaceP13sqljDDMObject + 0x1E95 [14] 0x00007F9F6878BA5B _Z21sqljsParseRdbAccessedP13sqljsDrdaAsCbP13sqljDDMObjectP14db2U Cinterface + 0x32B [15] 0x00007F9F6878D5FA _Z10sqljsParseP13sqljsDrdaAsCbP14db2UCinterfaceP8sqeAgentb + 0x83A [16] 0x00007F9F687849F1 /home/kelvinlu/sqllib/lib64/libdb2e.so.1 + 0x8C3F9F1 [17] 0x00007F9F68788965 _Z17sqljsDrdaAsDriverP18SQLCC_INITSTRUCT_T + 0xCF5 [18] 0x00007F9F680D4289 _ZN8sqeAgent6RunEDUEv + 0x639 [19] 0x00007F9F6C370D34 _ZN9sqzEDUObj9EDUDriverEv + 0x1A4 [20] 0x00007F9F6A610139 sqloEDUEntry + 0x2A9 [21] 0x00007F9F711F0EA5 /lib64/libpthread.so.0 + 0x7EA5 [22] 0x00007F9F5EA7B9FD clone + 0x6D | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * all * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to 11.5 FP7 or later * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * all * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to 11.5 FP7 or later * **************************************************************** | |
Comment | |
Upgrade to 11.5 FP7 or later | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 03.08.2021 24.11.2021 24.11.2021 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |