IBM Support

IT34162: JSON/BSON QUERY RETURNS -937 AGAINST DRDAEXEC AND SQLEXEC THREADS

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error 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.
    

Local fix

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.                                                   *
    ****************************************************************
    

Problem conclusion

  • Fixed in Informix Server 12.10.xC15 and 14.10.xC5.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT34162

  • Reported component name

    INFORMIX SERVER

  • Reported component ID

    5725A3900

  • Reported release

    C10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2020-09-09

  • Closed date

    2021-01-25

  • Last modified date

    2021-01-25

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    INFORMIX SERVER

  • Fixed component ID

    5725A3900

Applicable component levels

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU029","label":"Software"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"C10"}]

Document Information

Modified date:
26 January 2021