IC77048: 'CDR SYNC' TASK CAN HANG WHILE PERFORMING SYNC ON A LARGE TABLE IF NETWORK CONNECTION WAS DISCONNECTED AND RECONNECTED

APAR status

• Closed as program error.

Error description

• Source server sendq has nnn transactions. All these txns are
  waiting for ack from server id xx(subhost_xyz).
  
  Source server sendq xxx  table shows txns are acknowledged for
  replicate id 0x123(sync replicate on badge table).
  
  Target server subhost_xyz receive queue is empty. It's xxx table
  shows txns received for replicate id 0x123. But ack point is not
  updated. But looks like txns are applied.
  
  part of onstat -g rcv full output at subhost_xyz  for replicate
  id 65576/0x123
  65576    22851  457020      0      0 2011/06/02 11:50:25 (apply
  time  at target server) 2011/06/02 11:50:04 (source server
  commit time)
  
  receive queue xxx table:
  
  1  0x10028          84544980 efffffff/efffffff/efffffff/efffffff
  (last txn acked, nothing acked) -        1/32/259f670/13 (last
  received txn id)
  
  Source xxx table:
    0x10028          17234155 1/32/259f670/0  (last txn acked from
  server xx)        -          1/32/259f670/0 (last txn queued to
  server xx)
  
  During this time, network connection lost between source and
  target server and connection re-established.
  
  Message log file at source server:
  11:50:05  CDR NIF ASF SEND failed asfcode -25580 oserr 0
  11:50:05  CDR connection to server lost, id xx, name
  <subhost_xyz>
  Reason: error detected
  11:50:19  CDR: Re-connected to server, id xx, name <subhost_xyz>
  
  
  
  Source server thinks that txns are not acknowledged by server xx
  even though ack is received. Due to this reason txns are not
  deleted from sendq. Sync task hung due to this reason as we
  temporarily suspend queuing txns to sendq if sendq spooling is
  required.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All platforms                                                *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Update to IBM Informix Server 11.50.xC9                      *
  ****************************************************************
  

Problem conclusion

• Problem Fixed In IBM Informix Server 11.50.xC9
  

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

• RB50 PSN

     UP