Informix - Problem description
Problem IT33715 | Status: Closed |
ASSERT FAILED SEGV TRYING TO EXECUTE PROCEDURE USING DRDA PROTOCOL WHEN FUNCTION DOES NOT EXECUTE A RETURN STATEMENT | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem description: | |
On Linux x86-64 this was the stack trace seen from the assertion: (oninit) afsig_handler (Linux) (oninit) _Z31sqljsDrdaAsCBInitializeSqldtardP14db2UCinterface (oninit) InitQryDta (oninit) drda_put_paramvalue (oninit) sq_exproc (oninit) drda_execute (oninit) _Z11sqljsDoExecP13sqljsDrdaAsCbP14db2UCinterfacePP15db2UCdiagStr uct (oninit) _Z19sqljs_ddm_excsqlsttP14db2UCinterfaceP13sqljDDMObject (oninit) sqljsParse (oninit) do_drdamain (oninit) drdamain (oninit) spawn_thread (oninit) th_init_initgls (oninit) startup The session was attempting to execute the following SQL: Current SQL statement (0) : execute procedure decproc(261029770); Here is the code for decproc, showing that it has no return statement: create function decproc (decarg dec(11,0)) returning smallint as retint; define n_retint smallint; let n_retint = 0; end function; The server has no problems doing the "execute procedure" call when using the SQLI protocol. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 12.10.xC15 and 14.10.xC5. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix Server 12.10.xC15 (when available) or * * 14.10.xC5. * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 12.10.xC15 and 14.10.xC5. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix Server 12.10.xC15 (when available) or * * 14.10.xC5. * **************************************************************** | |
Comment | |
Fixed in Informix Server 12.10.xC15 and 14.10.xC5. | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 28.07.2020 18.01.2021 18.01.2021 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |