DB2 - Problem description
Problem IT25765 | Status: Closed |
DB2 CLIENT FAILS WITH SIGSEGV OR GIVES SQL ERRORS WHEN embeddedSQL application EXECUTES MULTI ROW INSERT | |
product: | |
DB2 CONNECT / DB2CONNCT / B10 - DB2 | |
Problem description: | |
In embeddedSQL application, when doing the array insert using the multi-row insert feature of the embeddedSQL, if we have the different sizes of data in the array, embddedSQL application may crash with the following stack. For example: copying form dump files -------Frame------ ------Function + Offset------ 0x000000000000F5AC ?unknown + 0x0 0x090000000A500E98 clientbiPutVarcharDataSpanBuffers__FP14CLIENTBI_PARMSPcsT3 + 0x238 [ NO FDPR ] ( = offset 0xC7EA98 in library /home/jplincdl/sqllib/lib64/libdb2.a ) 0x090000000A6CB868 sqlak_callbDrdaInput__FP14db2UCinterface + 0x35E8 [ NO FDPR ] ( = offset 0xE49468 in library /home/jplincdl/sqllib/lib64/libdb2.a ) 0x090000000A14AE6C sqljrGenSqlDta__FP14db2UCinterfaceUi + 0x56C [ NO FDPR ] ( = offset 0x8C8A6C in library /home/jplincdl/sqllib/lib64/libdb2.a ) 0x090000000A688414 sqljrDrdaArArrayInput__FP14db2UCinterfacePP15db2UCdiagStructUlUs + 0xBF4 [ NO FDPR ] ( = offset 0xE06014 in library /home/jplincdl/sqllib/lib64/libdb2.a ) 0x090000000A215FFC sqlacall + 0x355C [ NO FDPR ] ( = offset 0x993BFC in library /home/jplincdl/sqllib/lib64/libdb2.a ) 0x0000000100109C68 execMultiRowInsert__13db2SqlStmtMgrFCPCcRCPC6lpdataPP13sqlStmtHa ndleR15sqlStmtInfoTypeCUsCP5sqldai + 0x1368 0x000000010032B4C4 runMultirowInsertSQL__7subsSQLFCP6dbConnP5QAsubP5sqldaP4stmtR15s qlStmtInfoTypeCUs + 0x344 0x0000000100364098 insertMRI__5QArowFP7appAgntP7agntSubCP14updateStmtDesc + 0x298 0x000000010035D6FC applyMultiRow__5QArowFP7appAgntP7agntSubPC10encodeInfoiPP5QArow + 0x41C 0x000000010035B8A0 applyTran__5QAtxsFP7appAgntP7ASNBOOL + 0xAC0 0x00000001003250C4 appAgntMain__FP9asnThread + 0x5C64 0x0900000000519E10 _pthread_body + 0xF0 [ NO FDPR ] ( = offset 0x3E10 in library /usr/lib/libpthreads.a ) | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * embeddedSQL applications using array insert. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Please upgrade to DB2 v11.1 m4fp4 or later. * **************************************************************** | |
Local Fix: | |
NA | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 20.07.2018 28.11.2018 28.11.2018 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |