IC61367: ASSERTION FAILURE OCCURS WHEN SELECTING A DELETED ROW USING THE LAST COMMITTED OPTION

APAR status

• Closed as program error.

Error description

• This problem will corrupt memory and can cause a segv or an
  assert failure to the engine.
  If the LAST COMMITTED option is used with the following query
  the engine will crash with
  various assertion failures.
  
    set isolation to dirty read;
    set lock mode to wait;
    set PDQPRIORITY 10;
    select max(col2) from customer;
  
  Here are two examples:
  
  oninit :: mt_shm_free_pool
  oninit :: destroy_session
  oninit :: sq_exit
  oninit :: sqmain
  oninit :: listen_verify
  oninit :: spawn_thread
  oninit :: startup
  
  oninit :: gather_records
  oninit :: rsread
  oninit :: fmread
  oninit :: readseq
  oninit :: gettupl
  oninit :: scan_next
  oninit :: producer_thread
  oninit :: startup
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * User using 11.50 release                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * A query using LASTCOMMITTED isolation level can crash the    *
  * server if the row it accesses was deleted by another user.   *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IDS 11.50.xC5 and above.                          *
  ****************************************************************
  

Problem conclusion

• Problem is first fixed in IDS 11.50.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:

  IT01450

Fix information

• Fixed component name

  IBM IDS ENTRP E

• Fixed component ID

  5724L2304

Applicable component levels

• RB15 PSY

     UP