Informix - Problem description
Problem IT34162 | Status: Closed |
JSON/BSON QUERY RETURNS -937 AGAINST DRDAEXEC AND SQLEXEC THREADS | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem description: | |
Customer is issuing the following statement and it abends w/ error -937: tid name rstcb flags curstk status 7064 drdaexec 546f9888 ---P--- 17040 running- Sess SQL Current Iso Lock SQL ISAM F.E. Id Stmt type Database Lvl Mode ERR ERR Vers Explain 1665 SELECT unoeste LC Not Wait -937 0 - Off Current SQL statement (9) : SELECT '{nomé:"josé"}'::json::bson FROM sca_periodo Last parsed SQL statement : SELECT '{nomé:"josé"}'::json::bson FROM sca_periodo The following stack signature was found after getting the trap error output: 0x000000000141f989 (oninit) afstack 0x0000000001422961 (oninit) afhandler 0x0000000001423142 (oninit) affail_interface 0x0000000000e24aa7 (oninit) check_traperror 0x0000000000728503 (oninit) sqerr 0x000000000072896e (oninit) sqerr1 0x000000000070e046 (oninit) sqapi_sqlstate_setup 0x000000000070e816 (oninit) sqapi_udr_error 0x00000000005cea1d (oninit) mi_db_error_raise 0x000000000166c47c (oninit) json_to_bson_output 0x0000000000adc1a6 (oninit) udrlm_clang_execute_internal 0x0000000000adc83f (oninit) udrlm_clang_execute 0x0000000000a8179e (oninit) udrlm_exec_routine 0x00000000006fdfdc (oninit) udr_execute 0x0000000000704725 (oninit) exroutine 0x0000000000899ce1 (oninit) geval 0x0000000000693c78 (oninit) evalcexpr 0x0000000000698d2a (oninit) expr2expr 0x000000000064feb6 (oninit) prjlst2expr 0x0000000000665642 (oninit) sel2cb 0x0000000000669284 (oninit) qblk2cb 0x000000000066c09c (oninit) stmt2cb 0x000000000066fa6e (oninit) p_sp2cb 0x0000000000a307bc (oninit) parsecmd 0x0000000000a30cd2 (oninit) sqcmd 0x0000000000a68650 (oninit) drda_cmnd 0x0000000000a6872c (oninit) drda_prepare 0x0000000000be5d60 (oninit) _Z19sqljs_ddm_prpsqlsttP14db2UCinterfaceP13sqljDDMObject 0x0000000000bc09dd (oninit) sqljsParse 0x0000000000bb8af6 (oninit) do_drdamain 0x0000000000b0611a (oninit) drdamain 0x000000000154c19b (oninit) spawn_thread 0x0000000001411450 (oninit) th_init_initgls 0x0000000001456d88 (oninit) startup But that works fine using the regular soctcp/sqlexec connection. The issue can be reproduced using the following query (both using drdaexec and sqlexec): "SELECT '{\'"nome\'": \'"aaaáa\'"}'::json::bson from crm_leads;"); The stacks produced via DRDAEXEC thread: ================================ 0x000000000142e819 (oninit) afstack 0x00000000014317f1 (oninit) afhandler 0x0000000001431fd2 (oninit) affail_interface 0x0000000000e31677 (oninit) check_traperror 0x0000000000729081 (oninit) sqerr 0x00000000007294ee (oninit) sqerr1 0x000000000070e0f6 (oninit) sqapi_sqlstate_setup 0x000000000070e8c6 (oninit) sqapi_udr_error 0x00000000005cdbbd (oninit) mi_db_error_raise 0x000000000167d33c (oninit) json_to_bson_output 0x0000000000ae15eb (oninit) udrlm_clang_execute_internal 0x0000000000ae1ccf (oninit) udrlm_clang_execute 0x0000000000a86b9e (oninit) udrlm_exec_routine 0x00000000006fe079 (oninit) udr_execute 0x00000000007047d5 (oninit) exroutine 0x000000000089c9db (oninit) geval 0x0000000000693458 (oninit) evalcexpr 0x000000000069850a (oninit) expr2expr 0x000000000064f046 (oninit) prjlst2expr 0x0000000000663832 (oninit) sel2cb 0x0000000000667474 (oninit) qblk2cb 0x000000000066b6ac (oninit) stmt2cb 0x000000000066f08e (oninit) p_sp2cb 0x0000000000a3593c (oninit) parsecmd 0x0000000000a35e52 (oninit) sqcmd 0x0000000000a6daf0 (oninit) drda_cmnd 0x0000000000a6dbcc (oninit) drda_prepare 0x0000000000be8e40 (oninit) _Z19sqljs_ddm_prpsqlsttP14db2UCinterfaceP13sqljDDMObject 0x0000000000bc3abd (oninit) sqljsParse 0x0000000000bbbbd6 (oninit) do_drdamain 0x0000000000b081fa (oninit) drdamain 0x000000000155c92b (oninit) spawn_thread 0x0000000001420130 (oninit) th_init_initgls 0x0000000001465c48 (oninit) startup via SQLEXEC thread: =============== 0x000000000142e819 (oninit) afstack 0x00000000014317f1 (oninit) afhandler 0x0000000001431fd2 (oninit) affail_interface 0x0000000000e31677 (oninit) check_traperror 0x0000000000729081 (oninit) sqerr 0x00000000007294ee (oninit) sqerr1 0x000000000070e0f6 (oninit) sqapi_sqlstate_setup 0x00000000006ff070 (oninit) udr_execute 0x00000000007047d5 (oninit) exroutine 0x000000000089c9db (oninit) geval 0x0000000000693458 (oninit) evalcexpr 0x000000000069850a (oninit) expr2expr 0x000000000069b1d7 (oninit) castexpr2expr 0x0000000000698ca2 (oninit) expr2expr 0x000000000064f046 (oninit) prjlst2expr 0x0000000000663832 (oninit) sel2cb 0x0000000000667474 (oninit) qblk2cb 0x000000000066b6ac (oninit) stmt2cb 0x000000000066f08e (oninit) p_sp2cb 0x0000000000a3593c (oninit) parsecmd 0x0000000000a35e52 (oninit) sqcmd 0x0000000000a40c2a (oninit) sq_cmnd 0x0000000000a40d84 (oninit) sq_prepare 0x0000000000b0b641 (oninit) sqmain 0x000000000155d1ab (oninit) spawn_thread 0x0000000001420130 (oninit) th_init_initgls 0x0000000001465c48 (oninit) startup Tried it using 12.10.FC14 and issue remains. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 12.10.xC15 and 14.10.xC5. * **************************************************************** * PROBLEM DESCRIPTION: * * Issuing the following statement abends with error -937: * * * * tid name rstcb flags curstk status * * 7064 drdaexec 546f9888 ---P--- 17040 * * running- * * * * Sess SQL Current Iso Lock * * SQL * * ISAM F.E. * * Id Stmt type Database Lvl Mode * * ERR * * ERR Vers Explain * * 1665 SELECT unoeste LC Not Wait * * -937 * * 0 - Off * * * * Current SQL statement (9) : * * SELECT '{nomé:"josé"}'::json::bson FROM sca_periodo * * * * Last parsed SQL statement : * * SELECT '{nomé:"josé"}'::json::bson FROM sca_periodo * **************************************************************** * 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: * * Issuing the following statement abends with error -937: * * * * tid name rstcb flags curstk status * * 7064 drdaexec 546f9888 ---P--- 17040 * * running- * * * * Sess SQL Current Iso Lock * * SQL * * ISAM F.E. * * Id Stmt type Database Lvl Mode * * ERR * * ERR Vers Explain * * 1665 SELECT unoeste LC Not Wait * * -937 * * 0 - Off * * * * Current SQL statement (9) : * * SELECT '{nomé:"josé"}'::json::bson FROM sca_periodo * * * * Last parsed SQL statement : * * SELECT '{nomé:"josé"}'::json::bson FROM sca_periodo * **************************************************************** * 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 : | 09.09.2020 25.01.2021 25.01.2021 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |