DB2 - Problem description
Problem IT37181 | Status: Closed |
POSSIBLE SIGSEGV WHEN SELECTING A ROW FROM A NONPARTITIONED TABLE USING AN INVALID RID_BIT VALUE | |
product: | |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 | |
Problem description: | |
When selecting a row from a nonpartitioned table using an invalid RID_BIT value, a SIGSEGV may be encountered. An example is if a value returned using the RID_BIT scalar function on a data partitioned table is used to fetch a row from a non partitioned table. A stack similar to the following will be encountered. 0x00007F02CE006BC6 _Z25ossDumpStackTraceInternalmR11OSSTrapFileiP7siginfoPvmm + 0x0356 (/fsudb/db2inst1/sqllib/lib64/libdb2osse.so.1) 0x00007F02CE00680B ossDumpStackTraceV98 + 0x002b (/fsudb/db2inst1/sqllib/lib64/libdb2osse.so.1) 0x00007F02CE0029F7 _ZN11OSSTrapFile6dumpExEmiP7siginfoPvm + 0x00d7 (/fsudb/db2inst1/sqllib/lib64/libdb2osse.so.1) 0x00007F02D7878FE7 sqlo_trce + 0x03c7 (/fsudb/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00007F02D79F5E01 sqloEDUCodeTrapHandler + 0x03d1 (/fsudb/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00007F02E045E5D0 address: 0x00007F02E045E5D0 ; dladdress: 0x00007F02E044F000 ; offset in lib: 0x000000000000F5D0 ; (/usr/lib64/libpthread.so.0) 0x00007F02D0EF0906 _Z12sqldRowFetchP8sqeAgentP8SQLD_CCBmmPP10SQLD_VALUEP8SQLZ_RIDmP 12SQLD_ID_LISTP9SQLP_LSN8 + 0x09b6 (/fsudb/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00007F02D85FDD6D _Z10sqlriFetchP8sqlrr_cbP9sqlri_taol + 0x01ed (/fsudb/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00007F02D878AAB9 _Z8sqlriitaP8sqlrr_cb + 0x0469 (/fsudb/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00007F02D86A8593 _Z15sqlriSectInvokeP8sqlrr_cbP12sqlri_opparm + 0x04c3 (/fsudb/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00007F02D8073534 _Z27sqlrr_process_fetch_requestP14db2UCinterface + 0x0774 (/fsudb/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00007F02D8071FEF _Z11sqlrr_fetchP14db2UCinterfaceP15db2UCCursorInfo + 0x076f (/fsudb/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00007F02D60D7044 _Z16sqljs_ddm_cntqryP14db2UCinterfaceP13sqljDDMObject + 0x0494 (/fsudb/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00007F02D60C083B _Z21sqljsParseRdbAccessedP13sqljsDrdaAsCbP13sqljDDMObjectP14db2U Cinterface + 0x014b (/fsudb/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00007F02D60C18BE _Z10sqljsParseP13sqljsDrdaAsCbP14db2UCinterfaceP8sqeAgentb + 0x054e (/fsudb/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00007F02D60B4826 address: 0x00007F02D60B4826 ; dladdress: 0x00007F02CE570000 ; offset in lib: 0x0000000007B44826 ; (/fsudb/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00007F02D60BAE73 address: 0x00007F02D60BAE73 ; dladdress: 0x00007F02CE570000 ; offset in lib: 0x0000000007B4AE73 ; (/fsudb/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00007F02D60BBB2F _Z17sqljsDrdaAsDriverP18SQLCC_INITSTRUCT_T + 0x011f (/fsudb/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00007F02D5AB4FF3 _ZN8sqeAgent6RunEDUEv + 0x0de3 (/fsudb/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00007F02D959106E _ZN9sqzEDUObj9EDUDriverEv + 0x01be (/fsudb/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00007F02D79F329A sqloEDUEntry + 0x057a (/fsudb/db2inst1/sqllib/lib64/libdb2e.so.1) 0x00007F02E0456DD5 address: 0x00007F02E0456DD5 ; dladdress: 0x00007F02E044F000 ; offset in lib: 0x0000000000007DD5 ; (/usr/lib64/libpthread.so.0) 0x00007F02CD005EAD clone + 0x006d (/usr/lib64/libc.so.6) | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * all * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade server to v115m7fp0 * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * all * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade server to v115m7fp0 * **************************************************************** | |
Comment | |
First fixed in v115m7fp0 | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 09.06.2021 21.04.2022 21.04.2022 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |