|
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) |
