• Admin-Scout-small-Banner
           
    CURSOR Admin-Scout
    get the ultimate tool for Informix
    pfeil  
invispix 10x10
invispix 10x10
Latest versionsfixlist
14.10.xC5 FixList
12.10.xC14.X5 FixList
11.70.xC9.XB FixList
11.50.xC9.X2 FixList
11.10.xC3.W5 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26
Question in the chat LiveZilla Live Help

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
not known / see Local fix
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)
invispix 10x10
invispix 10x10
invispix 10x10
Technical InfoTechnical Info

Technical Info

DocumentationDocumentation

Documentation

IBM NewsletterIBM Newsletter

IBM Newsletter

Current BugsCurrent Bugs

Current Bugs

Bug ResearchBug Research

Bug Research

Bug FixlistsBug Fixlists

Bug Fixlists

Release NotesRelease Notes

Release Notes

Machine NotesMachine Notes

Machine Notes

Release NewsRelease News

Release News

Product LifecycleProduct Lifecycle

Lifecycle

Media DownloadMedia Download

Media Download

invispix 10x10
Service und SupportService und Support

Service and Support

Informix MonitoringInformix Monitoring

Informix Monitoring

Admin-Scout forInformixAdmin-Scout forInformix

Admin-Scout for Informix

Informix News & InfosInformix News & Infos

Informix News & Infos

This site uses cookies to make it easier for us to provide you with our services. By using our site you agree to the use of cookies.