IT26655: PREPARING LARGE STATEMENTS THAT CONSIST OF MANY SMALLER STATEMENTS CAN CAUSE SEGV IN STMT2CB WHILE PARSING

APAR status

• Closed as program error.

Error description

• Common stacks for the asserting threads include:
  
  0x000000000141fa89 (oninit) afstack
  0x0000000001423571 (oninit) mt_ex_throw_sig
  0x000000000142e443 (oninit) afsig_handler
  0x0000003ddfa0e4c0 (Linux) <signal frame>
  0x000000000066be08 (oninit) stmt2cb
  0x000000000066fa6e (oninit) p_sp2cb
  0x0000000000a3072c (oninit) parsecmd
  0x0000000000a30c42 (oninit) sqcmd
  0x0000000000a3b9ca (oninit) sq_cmnd
  0x0000000000a3bb24 (oninit) sq_prepare
  0x0000000000b0af81 (oninit) sqmain
  0x000000000154cb1b (oninit) spawn_thread
  0x0000000001411550 (oninit) th_init_initgls
  0x0000000001456e88 (oninit) startup
  
  0x000000000141fa89 (oninit) afstack
  0x0000000001423571 (oninit) mt_ex_throw_sig
  0x000000000142e443 (oninit) afsig_handler
  0x0000003ddfa0e4c0 (Linux) <signal frame>
  0x000000000066be08 (oninit) stmt2cb
  0x000000000066fa6e (oninit) p_sp2cb
  0x000000000072533e (oninit) ssc_link
  0x0000000000a3060e (oninit) parsecmd
  0x0000000000a30c42 (oninit) sqcmd
  0x0000000000a3b9ca (oninit) sq_cmnd
  0x0000000000a3bb24 (oninit) sq_prepare
  0x0000000000b0af81 (oninit) sqmain
  0x000000000154cb1b (oninit) spawn_thread
  0x0000000001411550 (oninit) th_init_initgls
  0x0000000001456e88 (oninit) startup
  
  The statement that the parser was parsing was about 300 lines of
  update statements that looked like this:
  
    UPDATE ResulAnaRede SET  POTRESUL = 38.253 WHERE DATPDP =
  '20181018' AND
      CODEQUIP = 'CHPTU04T3' AND TIPEQUIP = 'TR' AND INTRESUL = 4
  AND ((POTRESUL
      IS NULL)  OR  (POTRESUL IS NOT NULL AND POTRESUL < 38.253));
  UPDATE
      ResulAnaRede SET  POTRESUL = 37.761 WHERE DATPDP =
  '20181018' AND CODEQUIP
      = 'CHPTU04T2' AND TIPEQUIP = 'TR' AND INTRESUL = 4 AND
  ((POTRESUL IS NULL)
      OR  (POTRESUL IS NOT NULL AND POTRESUL < 37.761)); UPDATE
  ResulAnaRede SET
       POTRESUL = 38.728 WHERE DATPDP = '20181018' AND CODEQUIP =
  'CHPTU04T4'
      AND TIPEQUIP = 'TR' AND INTRESUL = 4 AND ((POTRESUL IS NULL)
  OR
      (POTRESUL IS NOT NULL AND POTRESUL < 38.728));  UPDATE
  ResulAnaRede SET
      POTRESUL = 27.53 WHERE DATPDP = '20181018' AND CODEQUIP =
  'CHPTU-2MTT-'
      AND TIPEQUIP = 'LN' AND INTRESUL = 4 AND ((POTRESUL IS NULL)
  OR  (POTRESUL
      IS NOT NULL AND POTRESUL < 27.53));
      ...
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users of IDS prior to 12.10.xC13.                            *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Preparing large statements that consist of many smaller      *
  * statements can cause segv in stmt2cb while parsing.          *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

• Fixed in IDS 12.10.xC13.
  

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