IT32484: WHEN A STORED PROCEDURE WITH 250+ ARGUMENTS IS DEFINED FOR CONFLICT RESOLUTION THE TARGET MAY REPORT AN AF IN DSISTOREDPROCEDURE

APAR status

• Closed as program error.

Error description

• When in an ER primary target environment a replicate is defined
  with SP conflict resolution and the SP has a very large
  parameter list, the target may abort with:
  
  16:19:28  stack trace for pid 26241 written to
  /opt/informix/IBM/11.70.FC9/tmp/af.48f45f0
  16:19:28  Assert Failed: No Exception Handler
  16:19:28  IBM Informix Dynamic Server Version 11.70.FC9
  16:19:28   Who: Session(153, informix@hostname, 0, 0x116ca77b8)
                  Thread(167, CDRD_22, 116c757b8, 1)
                  File: mtex.c Line: 490
  16:19:28   Results: Exception Caught. Type: MT_EX_OS, Context:
  mem
  16:19:28   Action: Please notify IBM Informix Technical Support.
  16:19:28   See Also: /opt/informix/IBM/11.70.FC9/tmp/af.48f45f0
  16:19:30  Thread ID 167 will NOT be suspended because
            it is deemed too critical to the server.
  16:19:30   See Also: /opt/informix/IBM/11.70.FC9/tmp/af.48f45f0,
  shmem.48f45f0.0
  16:19:30  Starting crash time check of:
  16:19:30  1. memory block headers
  16:19:30  2. stacks
  16:19:30  Crash time checking found no problems
  16:19:30  mtex.c, line 490, thread 167, proc id 26241, No
  Exception Handler.
  
  
  0x0000000001331ae6 (oninit) afstack
  0x0000000001338cac (oninit) mt_ex_throw_sig
  0x00000000012df593 (oninit) afsig_handler
  0x00007fb7c375fb10 (Linux) <signal frame>
  0x000000000106b4f6 (oninit) dsiStoredProcedure
  0x0000000001065ecd (oninit) dsiResolverThread
  0x0000000000fb4ce1 (oninit) cdrTrampolineThread
  0x000000000132f870 (oninit) th_init_initgls
  0x00000000012fc3a7 (oninit) startup
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users of Informix Server prior to 12.10.xC15 and 14.10.xC5.  *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to Informix Server 12.10.xC15 (when available) or    *
  * 14.10.xC5.                                                   *
  ****************************************************************
  

Problem conclusion

• Fixed in Informix Server 12.10.xC15 and 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