Informix - Problem description
Problem IT34094 | Status: Closed |
JSON STATEMENT CRASHES THE SERVER ON UDR_EXECUTE | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem description: | |
When executing a JSON select statement the server crashes with the following stacks. SQLEXEC thread thru a soctcp connection: (oninit) mt_system (oninit) afhandler (oninit) afcrash_interface (oninit) mt_ex_throw_sig (oninit) afsig_handler (Linux) (oninit) udr_execute (oninit) deepcopyval (oninit) evalcexpr (oninit) expr2expr (oninit) prjlst2expr (oninit) sel2cb (oninit) qblk2cb (oninit) stmt2cb (oninit) p_sp2cb (oninit) parsecmd (oninit) sqcmd (oninit) sq_cmnd (oninit) sq_prepare (oninit) sqmain (oninit) spawn_thread (oninit) th_init_initgls (oninit) startup DRDAEXEC thru a drsoctcp connection: (oninit) mt_system (oninit) afhandler (oninit) afcrash_interface (oninit) mt_ex_throw_sig (oninit) afsig_handler (Linux) (oninit) udr_execute (oninit) deepcopyval (oninit) evalcexpr (oninit) expr2expr (oninit) prjlst2expr (oninit) sel2cb (oninit) qblk2cb (oninit) stmt2cb (oninit) p_sp2cb (oninit) parsecmd (oninit) sqcmd (oninit) drda_cmnd (oninit) drda_prepare (oninit) _Z19sqljs_ddm_prpsqlsttP14db2UCinterfaceP13sqljDDMObject (oninit) sqljsParse (oninit) do_drdamain (oninit) drdamain (oninit) spawn_thread (oninit) th_init_initgls (oninit) startup SQL/JSON statement shows similar to this: SELECT '{name: "test"}'::json::bson FROM tab1 | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 12.10.xC15 and 14.10.xC5. * **************************************************************** * PROBLEM DESCRIPTION: * * When executing a JSON select statement the server crashes * * with * * the following stacks. * * * * SQLEXEC thread thru a soctcp connection: * * (oninit) mt_system * * (oninit) afhandler * * (oninit) afcrash_interface * * (oninit) mt_ex_throw_sig * * (oninit) afsig_handler * * (Linux) * * (oninit) udr_execute * * (oninit) deepcopyval * * (oninit) evalcexpr * * (oninit) expr2expr * * (oninit) prjlst2expr * * (oninit) sel2cb * * (oninit) qblk2cb * * (oninit) stmt2cb * * (oninit) p_sp2cb * * (oninit) parsecmd * * (oninit) sqcmd * * (oninit) sq_cmnd * * (oninit) sq_prepare * * (oninit) sqmain * * (oninit) spawn_thread * * (oninit) th_init_initgls * * (oninit) startup * * * * DRDAEXEC thru a drsoctcp connection: * * (oninit) mt_system * * (oninit) afhandler * * (oninit) afcrash_interface * * (oninit) mt_ex_throw_sig * * (oninit) afsig_handler * * (Linux) * * (oninit) udr_execute * * (oninit) deepcopyval * * (oninit) evalcexpr * * (oninit) expr2expr * * (oninit) prjlst2expr * * (oninit) sel2cb * * (oninit) qblk2cb * * (oninit) stmt2cb * * (oninit) p_sp2cb * * (oninit) parsecmd * * (oninit) sqcmd * * (oninit) drda_cmnd * * (oninit) drda_prepare * * (oninit) * * _Z19sqljs_ddm_prpsqlsttP14db2UCinterfaceP13sqljDDMObject * * (oninit) sqljsParse * * (oninit) do_drdamain * * (oninit) drdamain * * (oninit) spawn_thread * * (oninit) th_init_initgls * * (oninit) startup * * * * SQL/JSON statement shows similar to this: * * SELECT '{name: "test"}'::json::bson FROM tab1 * **************************************************************** * 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: * * When executing a JSON select statement the server crashes * * with * * the following stacks. * * * * SQLEXEC thread thru a soctcp connection: * * (oninit) mt_system * * (oninit) afhandler * * (oninit) afcrash_interface * * (oninit) mt_ex_throw_sig * * (oninit) afsig_handler * * (Linux) * * (oninit) udr_execute * * (oninit) deepcopyval * * (oninit) evalcexpr * * (oninit) expr2expr * * (oninit) prjlst2expr * * (oninit) sel2cb * * (oninit) qblk2cb * * (oninit) stmt2cb * * (oninit) p_sp2cb * * (oninit) parsecmd * * (oninit) sqcmd * * (oninit) sq_cmnd * * (oninit) sq_prepare * * (oninit) sqmain * * (oninit) spawn_thread * * (oninit) th_init_initgls * * (oninit) startup * * * * DRDAEXEC thru a drsoctcp connection: * * (oninit) mt_system * * (oninit) afhandler * * (oninit) afcrash_interface * * (oninit) mt_ex_throw_sig * * (oninit) afsig_handler * * (Linux) * * (oninit) udr_execute * * (oninit) deepcopyval * * (oninit) evalcexpr * * (oninit) expr2expr * * (oninit) prjlst2expr * * (oninit) sel2cb * * (oninit) qblk2cb * * (oninit) stmt2cb * * (oninit) p_sp2cb * * (oninit) parsecmd * * (oninit) sqcmd * * (oninit) drda_cmnd * * (oninit) drda_prepare * * (oninit) * * _Z19sqljs_ddm_prpsqlsttP14db2UCinterfaceP13sqljDDMObject * * (oninit) sqljsParse * * (oninit) do_drdamain * * (oninit) drdamain * * (oninit) spawn_thread * * (oninit) th_init_initgls * * (oninit) startup * * * * SQL/JSON statement shows similar to this: * * SELECT '{name: "test"}'::json::bson FROM tab1 * **************************************************************** * 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 : | 02.09.2020 22.01.2021 22.01.2021 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |