IT34205: STATEMENT WITH GROUP BY CAN CAUSE -640 ERROR IN STATEMENT CACHE AND THEN TRIGGER SEGV ASSERTION TRYING TO CLEANUP

APAR status

• Closed as program error.

Error description

• Here is the stack trace for the SIGSEGV assertion failure:
  
  0x00000000014a458d (oninit) afstack
  0x00000000014aa4b1 (oninit) mt_ex_throw_sig
  0x00000000014b88a8 (oninit) afsig_handler
  0x00007fc7ba70b5e0 (Linux) <signal frame>
  0x00000000009e2134 (oninit) oplooksubq
  0x00000000009e2210 (oninit) oplooksubq
  0x00000000007c803d (oninit) remrelease
  0x0000000000660dd7 (oninit) closecb
  0x0000000000661eb6 (oninit) close_cb_subtree
  0x0000000000662cf7 (oninit) closesdb
  0x000000000066306a (oninit) doreleasesdb
  0x000000000075e028 (oninit) ssc_link
  0x0000000000aa7452 (oninit) parsecmd
  0x0000000000aa78b3 (oninit) sqcmd
  0x0000000000aa7f3d (oninit) sq_prepare
  0x0000000000b8eeae (oninit) sqmain
  0x00000000015d2e3b (oninit) spawn_thread
  0x0000000001495103 (oninit) th_init_initgls
  0x00000000014dc0bf (oninit) startup
  
  Here is the SQL statement from the onstat -g ses output that
  also shows the -640 error that is triggering the code to get
  into the above code path:
  
  Sess       SQL            Current            Iso Lock       SQL
  ISAM F.E.
  Id         Stmt type      Database           Lvl Mode       ERR
  ERR  Vers  Explain
  4          SELECT         db1                CR  Not Wait   -640
  0    9.41  Off
  
  Current SQL statement (550) :
    SELECT FIRST 1 l.emp, l.intenc, l.intart, l.dcoart, l.dtmart,
  l.qtdanu ,
      sum(nvl(b.qtdanu,0))  FROM x_enclin l , outer  x_encanu b
  WHERE l.emp = ?
              AND l.intenc = ?  AND b.emp    = l.emp     AND
  b.intenc = l.intenc
       AND b.intart = l.intart  AND b.dtmart = l.dtmart  AND
  b.dcoart = l.dcoart
       GROUP BY 1,2,3,4,5,6  HAVING ( sum(nvl(b.qtdanu,0)) !=
  l.qtdanu)
  
  The server has the following values in the $ONCONFIG indicating
  the sql statement cache is in use:
  
  STMT_CACHE 2
  STMT_CACHE_HITS 3
  STMT_CACHE_SIZE 5120
  STMT_CACHE_NOLIMIT 0
  STMT_CACHE_NUMPOOL 1
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users of Informix Server prior to 14.10.xC5.                 *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Update to Informix Server 14.10.xC5.                         *
  ****************************************************************
  

Problem conclusion

• Fixed in Informix Server 14.10.xC5.
  

Temporary fix

Comments

APAR Information

• 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