DB2 - Problem description
Problem IC87887 | Status: Closed |
DRDA STATEMENT CONTAINING PARAMETER MARKER RUNS IN PASSTHRU SESSION WILL CAUSE DB2 CRASH | |
product: | |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 | |
Problem description: | |
Runs a DRDA statement which contains parameter marker in passthru session will cause DB2 crash, the following log can be seen in db2diag.log: 2012-05-21-12.00.15.781587+060 I1304802E476 LEVEL: Error PID : 677 TID : 140506659022592PROC : db2sysc 0 INSTANCE: db2ods NODE : 000 DB : ODS APPHDL : 0-9026 APPID: *LOCAL.db2ods.120521110027 AUTHID : DB2ODS EDUID : 62637 EDUNAME: db2agent (ODS) 0 FUNCTION: DB2 UDB, drda wrapper, DRDA_Statement::process_input_data, probe:5 MESSAGE : No parameter markers allowed in passthru statements The trap file will contain this information: </Siginfo_t> Signal #11 (SIGSEGV): si_addr is 0x0000000000000010, si_code is 0x00000001 (SEGV_MAPERR:Address not mapped to object.) </SignalDetails> <POFDisassembly> _ZN14DRDA_Statement18process_input_dataEv + 0x0127 (/home/db2ods/sqllib/lib64/libdb2drdaF.so) 0x00007FCC309503F3 : 48035110E8CCE6FC </POFDisassembly> <StackTrace> -----FUNC-ADDR---- ------FUNCTION + OFFSET------ 0x00007FCCCEBD8293 ossDumpStackTraceEx + 0x01ef (/home/db2ods/sqllib/lib64/libdb2osse.so.1) 0x00007FCCCEBD3052 _ZN11OSSTrapFile6dumpExEmiP7siginfoPvm + 0x00cc (/home/db2ods/sqllib/lib64/libdb2osse.so.1) 0x00007FCCD18A5943 sqlo_trce + 0x03fb (/home/db2ods/sqllib/lib64/libdb2e.so.1) 0x00007FCCD18EB801 sqloEDUCodeTrapHandler + 0x026b (/home/db2ods/sqllib/lib64/libdb2e.so.1) 0x00007FCCD46E05D0 address: 0x00007FCCD46E05D0 ; dladdress: 0x00007FCCD46D1000 ; offset in lib: 0x000000000000F5D0 ; (/lib64/libpthread.so.0) 0x00007FCC309503F3 _ZN14DRDA_Statement18process_input_dataEv + 0x0127 (/home/db2ods/sqllib/lib64/libdb2drdaF.so) 0x00007FCC30951801 _ZN14DRDA_Statement4openEv + 0x0055 (/home/db2ods/sqllib/lib64/libdb2drdaF.so) 0x00007FCC30955301 _ZN13DRDA_Passthru4openEv + 0x0075 (/home/db2ods/sqllib/lib64/libdb2drdaF.so) 0x00007FCC30BED5B0 _Z22sqlqg_FMP_PassthruOpenP15sqlri_rpassthru + 0x004c (/home/db2ods/sqllib/lib64/libdb2qgstp.so) 0x00007FCC30BE3411 _Z11sqlqgRouterP17sqlqg_FMP_RequestPP15sqlqg_FMP_ReplyP10sqlri_u fob + 0x2631 (/home/db2ods/sqllib/lib64/libdb2qgstp.so) 0x00007FCC30BE64A4 sqlqg_fedstp_hook + 0x007a (/home/db2ods/sqllib/lib64/libdb2qgstp.so) 0x00007FCCD19B6055 _Z11sqlqgDyloadP10sqlri_ufob + 0x0129 (/home/db2ods/sqllib/lib64/libdb2e.so.1) 0x00007FCCD1D41F8D _Z22sqlriFedInvokerTrustedP10sqlri_ufobP21sqlriRoutineErrorIntf + 0x008b (/home/db2ods/sqllib/lib64/libdb2e.so.1) 0x00007FCCD1D4216D _Z21sqlriFedInvokeInvokerP10sqlri_ufobP14sqlqg_Fmp_Info + 0x00d9 (/home/db2ods/sqllib/lib64/libdb2e.so.1) 0x00007FCCD1A028FD _Z21sqlqg_Call_FMP_ThreadP17sqlqg_FMP_RequestPP15sqlqg_FMP_Reply + 0x01d3 (/home/db2ods/sqllib/lib64/libdb2e.so.1) 0x00007FCCD19F0768 _Z17sqlqgPassthruOpenP15sqlri_rpassthru + 0x019c (/home/db2ods/sqllib/lib64/libdb2e.so.1) 0x00007FCCD1BE1750 _Z19sqlri_passthru_openP8sqlrr_cbP15sqlri_rpassthru + 0x013c (/home/db2ods/sqllib/lib64/libdb2e.so.1) 0x00007FCCD1BE1AC8 _Z21sqlri_passthru_routerP8sqlrr_cb + 0x018e (/home/db2ods/sqllib/lib64/libdb2e.so.1) 0x00007FCCD266E6ED _Z15sqlriSectInvokeP8sqlrr_cbP12sqlri_opparm + 0x00fb (/home/db2ods/sqllib/lib64/libdb2e.so.1) 0x00007FCCD03C1824 _Z10sqlrr_openP14db2UCinterfaceP15db2UCCursorInfo + 0x0c08 (/home/db2ods/sqllib/lib64/libdb2e.so.1) 0x00007FCCCFFD8B58 _Z16sqljs_ddm_opnqryP14db2UCinterfaceP13sqljDDMObject + 0x03fa (/home/db2ods/sqllib/lib64/libdb2e.so.1) 0x00007FCCD2602789 _Z21sqljsParseRdbAccessedP13sqljsDrdaAsCbP13sqljDDMObjectP14db2U Cinterface + 0x00b9 (/home/db2ods/sqllib/lib64/libdb2e.so.1) 0x00007FCCCFFCA323 _Z10sqljsParseP13sqljsDrdaAsCbP14db2UCinterfaceP8sqeAgentb + 0x035b (/home/db2ods/sqllib/lib64/libdb2e.so.1) 0x00007FCCCFFBF038 address: 0x00007FCCCFFBF038 ; dladdress: 0x00007FCCCF070000 ; offset in lib: 0x0000000000F4F038 ; (/home/db2ods/sqllib/lib64/libdb2e.so.1) 0x00007FCCCFFC6403 address: 0x00007FCCCFFC6403 ; dladdress: 0x00007FCCCF070000 ; offset in lib: 0x0000000000F56403 ; (/home/db2ods/sqllib/lib64/libdb2e.so.1) 0x00007FCCCFFC3D0A address: 0x00007FCCCFFC3D0A ; dladdress: 0x00007FCCCF070000 ; offset in lib: 0x0000000000F53D0A ; (/home/db2ods/sqllib/lib64/libdb2e.so.1) 0x00007FCCCFFC3A78 _Z17sqljsDrdaAsDriverP18SQLCC_INITSTRUCT_T + 0x0102 (/home/db2ods/sqllib/lib64/libdb2e.so.1) 0x00007FCCCFEF7B72 _ZN8sqeAgent6RunEDUEv + 0x0a72 (/home/db2ods/sqllib/lib64/libdb2e.so.1) 0x00007FCCD05D3C9C _ZN9sqzEDUObj9EDUDriverEv + 0x00a6 (/home/db2ods/sqllib/lib64/libdb2e.so.1) 0x00007FCCD05D3BF3 _Z10sqlzRunEDUPcj + 0x0009 (/home/db2ods/sqllib/lib64/libdb2e.so.1) 0x00007FCCD03435AA sqloEDUEntry + 0x02f4 (/home/db2ods/sqllib/lib64/libdb2e.so.1) 0x00007FCCD46D85F0 address: 0x00007FCCD46D85F0 ; dladdress: 0x00007FCCD46D1000 ; offset in lib: 0x00000000000075F0 ; (/lib64/libpthread.so.0) 0x00007FCCCDFDA84D clone + 0x006d (/lib64/libc.so.6) </StackTrace> | |
Problem Summary: | |
User affected: Users of in InfoSphere Federation Server Problem description and summay: See error description | |
Local Fix: | |
Don't run a statement containing parameter marker in passthru session | |
available fix packs: | |
DB2 Version 10.1 Fix Pack 2 for Linux, UNIX, and Windows | |
Solution | |
Problem was fistly fixed in Version 10, FixPak 2. This fix should be applied on the federation Server. | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 04.11.2012 04.01.2013 04.01.2013 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) | |
10.1.0.2 | |
10.5.0.2 |