|
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
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 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
|
|
