IC65379: WIN64: SERVER TERMINATES UNEXPECTEDLY IN DEFERRED CONSTRAINT CHECKING DURING ROLLBACK OF GLOBAL TRANSACTION

APAR status

• Closed as program error.

Error description

• IDS might terminate unexpectedly in deferred constraint checking
  during rollback of global transaction when the dictionary cache
  is too small.
  
  The statement executed in the transaction looks like this:
  
  INSERT INTO MYTAB(CID2, CDATE, CID3)
  SELECT FIRST 1 2222, TODAY , CID3 FROM MYTAB2;
  
  The table has several constraints defined and a trigger which
  raises an exception.
  
  Call Stack for thread #50 - sqlexec
  0x00000001403526E8 (oninit)col2expr
  0x000000014035499D (oninit)dotted2expr
  0x0000000140358755 (oninit)expr2expr
  0x0000000140354D9E (oninit)op_bind_rtn
  0x000000014035575C (oninit)buildexpr
  0x0000000140358B30 (oninit)expr2expr
  0x0000000140354D9E (oninit)op_bind_rtn
  0x000000014035575C (oninit)buildexpr
  0x0000000140358B30 (oninit)expr2expr
  0x00000001400C0887 (oninit)readchkcon
  0x00000001400D89EE (oninit)ddrallcons
  0x00000001400DEAC2 (oninit)readcats
  0x00000001400E48A9 (oninit)readtab
  0x00000001400E56B9 (oninit)ddgettable_hierarchy
  0x00000001400E73D3 (oninit)ddgettable
  0x000000014042AC13 (oninit)getdictab
  0x000000014021A1DB (oninit)setdeflist
  0x000000014021C59F (oninit)ifx_common_xrollback
  0x000000014021CCFD (oninit)sq_xrollback
  0x0000000140061228 (oninit)sqmain
  0x0000000140BD0D20 (oninit)listen_verify
  0x0000000140BD220E (oninit)spawn_thread
  0x0000000140B8616A (oninit)startup
  
  onstat -g dic shows that the dictionary cache is full:
  
  > onstat -g dic
  
  IBM Informix Dynamic Server Version 11.50.FC6     -- On-Line --
  Up 1 days 12:12:49 -- 80320 Kbytes
  
  Dictionary Cache:  Number of lists: 31, Maximum list size: 10
  ...
  
  Total number of dictionary entries: 310
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Win64 customers running rollback in global transaction with  *
  * deferred constraint checking                                 *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Server abends                                                *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to 11.50.xC7 or higher                               *
  ****************************************************************
  

Problem conclusion

• Problem already fixed in 11.50.xC7
  

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

  IBM IDS ENTRP E

• Fixed component ID

  5724L2304

Applicable component levels

• RB15 PSN

     UP