IT30993: QUERY CAN CAUSE SEGV ASSERT IN FIXCOLEXPRS DURING OPTIMIZATION

APAR status

• Closed as program error.

Error description

• Failure stack:
  
  0x00000000013d42d7 (oninit) afstack
  0x00000000013d746e (oninit) afhandler
  0x00000000013d78e2 (oninit) affail_interface
  0x00000000013d7e71 (oninit) mt_ex_throw_sig
  0x00000000013f5c83 (oninit) afsig_handler
  0x0000003ddfa0e4c0 (Linux) <signal frame>
  0x000000000078d67c (oninit) fixcolexprs
  0x000000000078d907 (oninit) fixcolexprs
  0x000000000078d840 (oninit) fixcolexprs
  0x00000000007986e6 (oninit) opchkby
  0x00000000007cc550 (oninit) sqoptim
  0x00000000009f734c (oninit) bldstructs
  0x00000000009fbce0 (oninit) sqcmd
  0x0000000000a06512 (oninit) sq_cmnd
  0x0000000000a06664 (oninit) sq_prepare
  0x0000000000ad57b3 (oninit) sqmain
  0x00000000014fc70c (oninit) spawn_thread
  0x00000000013c61d0 (oninit) th_init_initgls
  0x000000000142d228 (oninit) startup
  
  Running this query:
    select
      t1.tag,
      t1.label_type_code,
      t1.actual_slot_id,
      t1.item_nbr,
      t1,item1_desc,
      t1.curr_unit_qty,
      t1.pallet_ti_qty,
      t1.pallet_hi_qty,
      t1.actl_qty
    from
      (select
         ru.rcv_unit_tag_id as tag,
         ru.label_type_code,
         ru.actual_slot_id,
         ru.item_nbr,
         it.item1_desc,
         ru.curr_unit_qty,
         ru.pallet_ti_qty,
         ru.pallet_hi_qty,
         sum(su.ship_unit_qty) as actl_qty
       from
         db1:tab1 ru left join
           db2:tab2 su on ru.rcv_unit_id = su.rcv_unit_id inner
  join
             db3:tab3 it on ru.item_nbr = it.item_nbr
       where
         ru.actual_slot_id in
  
  ('132','133','134','135','136','137','138','139','140','141','14
  2','143','144',
  
  '145','146','147','148','149','150','151','152','153','154','155
  ','156','157',
            '158','159','160','161','162','163','164','165','166')
  and
         su.cur_loc_slot_id in
  
  ('132','133','134','135','136','137','138','139','140','141','14
  2','143','144',
  
  '145','146','147','148','149','150','151','152','153','154','155
  ','156','157',
            '158','159','160','161','162','163','164','165','166')
       group by
         1,2,3,4,5,6,7,8) t1
    where
      t1.actl_qty > 0;
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users of Informix Server prior to 12.10.xC14 and 14.10.xC4.  *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Update to Informix Server 12.10.xC14 or 14.10.xC4.           *
  ****************************************************************
  

Problem conclusion

• Fixed in Informix Server 12.10.xC14 and 14.10.xC4.
  

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