IT29477: NON-LOGGING DATABASE, CONCURRENT TRIGGERED SPL EXECUTION CAN CAUSE CORRUPTED SYSPROCPLAN (SYSPROC BTREE)

APAR status

• Closed as unreproducible in next release.

Error description

• In a Non-Logging Database, with two sessions executing same
  triggered procedure under different conditions.
  The procedures creates temp tables and indexes on temp tables.
  
  The first session trigger cause plan re-opt and save which
  deletes the plan with an internal save point.
  
  Before completing a second session triggering of the same
  procedure delete the plan that was just inserted by the first
  session.
  
  Before the second session completes, the first sessions tries to
  rollback to the save point, which tries to delete what it
  inserted, but that plan was already deleted by the second
  session, corrupting sysprocplan/procplan.
  
  Messages include:
  08:43:03  Rowid 0x6e03 not found for delete in partnum 0x300013,
  key 1
  08:43:04   Who: Session(6012, informix@server, 28957,
  0x943a0860)
                  Thread(1059432, sqlexec, 9436a838, 9)
                  File: rsnode.c Line: 2565
  08:43:04   Results: Delete failed
  08:43:04   Action: Run 'oncheck -cI procplan'
  08:43:04  stack trace for pid 6464 written to
  /var/tmp/af.2e50c256
  
  
  08:43:04   Results: Log record (OLDRSAM:HINSERT) in log 1957,
  offset 0x10949488 was not rolled back
  08:43:04   Action: Use 'onlog' to view the transaction and
  repair manually.
  08:43:04  stack trace for pid 6425 written to
  /var/tmp/af.2e50c256
  08:43:04   See Also: /var/tmp/af.2e50c256
  08:43:04  Rollback error 126
  08:43:04  Assert Failed: Rollback error 126
  
  
  ---------------
  
  Stack:
  
  
  afstack
  afhandler
  affail_interface
  btdelitem
  doitem
  logundo
  rlogm_undo
  rbacktxnlogs
  sprback
  rssprback
  excommand
  ip_evalsql
  runproc
  udrlm_spl_execute
  udrlm_exec_routine
  udr_execute
  exroutine
  execproc
  aud_execproc
  excommand
  dotrstmts
  dotrigs
  ferafttrig
  addone
  insone_next
  doinsert
  excommand
  ip_evalsql
  runproc
  udrlm_spl_execute
  udrlm_exec_routine
  udr_execute
  exroutine
  execproc
  aud_execproc
  excommand
  dotrstmts
  dotrigs
  ferafttrig
  addone
  insone_next
  doinsert
  excommand
  ip_evalsql
  runproc
  udrlm_spl_execute
  udrlm_exec_routine
  udr_execute
  exroutine
  execproc
  aud_execproc
  excommand
  dotrigs
  ferafttrig
  addone
  insone_next
  doinsert
  excommand
  sq_execute
  sqmain
  spawn_thread
  th_init_initgls
  startup
  

Local fix

• Use Logging Database
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users of Informix Server releases prior to 12.10             *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * see Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to 12.10 or higher.                                  *
  ****************************************************************
  

Problem conclusion

• The problem is no longer present in 12.10.  The underlying
  architectural/design change cannot be back-ported to the 11.70
  code line.
  

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