APAR status
Closed as fixed if next.
Error description
If STMT_CACHE is set globally (2) and a scroll cursor and a regular cursor are declared with the same SQL statement, then while sql_nfetch() checks for testcurr() getting CR_INVALID because SD_INVALID (#define SD_INVALID 0x0002 /* cursor is positioned */) 16:12:47 IBM Informix Dynamic Server Version 11.50.FC8 Software Serial Number AAA#B000000 16:12:47 Assert Failed: found errno 285 in session 12215 16:12:47 Who: Session(12215, cinacio@vulca_1, 3162506, 7000007e5556bb8) Thread(86236, sqlexec, 7000007e58d9e40, 1) File: rsdebug.c Line: 3670 16:12:47 Action: Use onmode -I to stop verbose error trapping. 16:12:47 Raw hex dump of stack located in /vulca/informix/tmp/dump/af.54c4faaf.rawstk 16:12:47 Stack for thread: 86236 sqlexec base: 0x0700000824786000 len: 266240 pc: 0x00000001000b7474 tos: 0x07000008247c5270 state: running vp: 1 (oninit)afstack (oninit)afhandler (oninit)check_traperror (oninit)sqerr (oninit)sql_nfetch (oninit)sq_nfetch (oninit)sqmain (oninit)listen_verify (oninit)spawn_thread (oninit)startup
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * Users who have set STMT_CACHE to 1 or 2 and use scroll and * * non-scroll cursors on the same SQL statement. * **************************************************************** * PROBLEM DESCRIPTION: * * If STMT_CACHE is set globally (2) and a scroll cursor and a * * * * regular cursor are declared with the same SQL statement, * * then * * while sql_nfetch() checks for testcurr() getting CR_INVALID * * * * because SD_INVALID (#define SD_INVALID 0x0002 * * /* * * cursor is positioned */) * * * * * * * * * * * * 16:12:47 IBM Informix Dynamic Server Version 11.50.FC8 * * * * Software * * * * Serial Number AAA#B000000 * * * * * * * * * * * * * * * * 16:12:47 Assert Failed: found errno 285 in session 12215 * * * * * * * * 16:12:47 Who: Session(12215, cinacio@vulca_1, 3162506, * * * * * * * * 7000007e5556bb8) * * * * * * * * Thread(86236, sqlexec, 7000007e58d9e40, 1) * * * * * * * * File: rsdebug.c Line: 3670 * * * * * * * * 16:12:47 Action: Use onmode -I to stop verbose error * * trapping. * * * * * * 16:12:47 Raw hex dump of stack located in * * * * * * * * /vulca/informix/tmp/dump/af.54c4faaf.rawstk * * * * * * * * 16:12:47 Stack for thread: 86236 sqlexec * * * * * * * * * * * * * * * * base: 0x0700000824786000 * * * * * * * * len: 266240 * * * * * * * * pc: 0x00000001000b7474 * * * * * * * * tos: 0x07000008247c5270 * * * * * * * * state: running * * * * * * * * vp: 1 * * * * * * * * * * * * * * * * (oninit)afstack * * * * (oninit)afhandler * * * * (oninit)check_traperror * * * * (oninit)sqerr * * * * (oninit)sql_nfetch * * * * (oninit)sq_nfetch * * * * (oninit)sqmain * * * * (oninit)listen_verify * * * * (oninit)spawn_thread * * * * (oninit)startup * **************************************************************** * RECOMMENDATION: * * Upgrade to IDS version 11.50.xC10 when available. * ****************************************************************
Problem conclusion
Fixed in IDS version 11.50.xC10.
Temporary fix
Comments
http://publib.boulder.ibm.com/infocenter/idshelp/v117/topic/com. ibm.start.doc/welcome.htm For download information, go to: http://www.ibm.com/support/fixcentral
APAR Information
APAR number
IC78924
Reported component name
IBM IDS ENTRP E
Reported component ID
5724L2304
Reported release
B15
Status
CLOSED FIN
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2011-09-26
Closed date
2012-06-04
Last modified date
2012-06-04
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Applicable component levels
RB15 PSY
UP
[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"B15","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
04 June 2012