IT33053: ER CDRACK_1 THREAD HUNG FOREVER WHILE UPDATING ACK POINT IN PROGRESS TABLE

APAR status

• Closed as program error.

Error description

• Thread stack:
  
  (oninit)yield_processor_mvp
  (*nosymtab*)0x0
  (oninit)volpt_updateAckPoint
  (oninit)stablept_updateAckPoint
  (oninit)rqmUpdatePTAckPoint
  (oninit)rqmAckReceived
  (oninit)queuerAckReceived_AckTxn
  (oninit)rmiAckInput
  (oninit)cdrTrampolineThread
  (oninit)th_init_initgls
  (oninit)startup
  
  
  In volpt_updateAckPoint() there is a wait until the sent point
  is ahead of the new ack point.  But it is not accounting for the
  sent point equal to the new ack point.
  
  
  relevant onstats:
  
  
  First Txn (0x700000027a06ab0) Key:
  5/275393/0x0eb990b0/0x00000000
   Txn Stamp: 10992320, Reference Count: 1.
   Txn Flags: Spooled, Free
   Txn Commit Time: (1584785012) 2020/03/21 05:03:32
   Txn Size in Queue: 6725
   First Buf's (0x70000004f2ea178) Queue Flags: Spooled, Resident
   First Buf's Buffer Flags: TRG, Stream, More
   NeedAck: Waiting for Acks from <[0004]>
   Traverse handle (0x700000025e6a028) for thread CDRACK_1 at txn
  (0x700000027a06ab0): 5/275393/0x0eb990b0/0x00000000
   Flags: In_Transaction
  
  
   Last Txn (0x70000003317c998) Key:
  5/275975/0x0185c7fc/0x00000000
   Txn Stamp: 20418831, Reference Count: 0.
   Txn Flags: Spooled, Delete, Free
   Txn Commit Time: (1587809368) 2020/04/25 05:09:28
   Txn Size in Queue: 3362
   First Buf's (0x700000048dc4080) Queue Flags: Spooled, Resident
   First Buf's Buffer Flags: TRG, Stream, More
   NeedAck: All acks have been received.
   No open handles on txn.
  
  
   Traverse handle (0x700000025e6a028) for thread CDRACK_1 at txn
  (0x700000027a06ab0): 5/275393/0x0eb990b0/0x00000000
   Flags: In_Transaction
  
  
  
  
       4  0x5004f               1305 5/275393/0xe9986b4/0x2   -
  5/275393/0xeb990b0/0x0
       4  0x5009a    235471148 5/276018/0xe685bb4/0x0   -
  5/276018/0xe685bb4/0x0
  
  
  Buffer 0:  cbSize: 284  Group: 327834  cbTRGBase:
  0x700000027a06c78RefCount: 1  Bflags: TRG, Stream, More
  Buffer 0:  Qflags:Spooled, Resident
  Buffer 1:  cbSize: 528  Group: 327834  cbTRGBase:
  0x700000041892170RefCount: 0  Bflags: TRG, Stream, Continuation
  Buffer 1:  Qflags:Spooled, Resident
  
  
  Buffer 20:  cbSize: 155  Group: 327759  cbTRGBase:
  0x70000003bcaa7f0RefCount: 0  Bflags: TRG, Stream
  Buffer 20:  Qflags:Spooled, Resident
  Buffer 21:  cbSize: 155  Group: 327759  cbTRGBase:
  0x70000003bcaa930RefCount: 0  Bflags: TRG, Stream
  Buffer 21:  Qflags:Spooled, Resident
  Buffer 22:  cbSize: 155  Group: 327759  cbTRGBase:
  0x70000003bcaaa70RefCount: 0  Bflags: TRG, Stream
  Buffer 22:  Qflags:Spooled, Resident
  Buffer 23:  cbSize: 174  Group: 327759  cbTRGBase:
  0x70000003bcaabb0RefCount: 0  Bflags: TRG, Stream
  Buffer 23:  Qflags:Spooled, Resident
  Buffer 24:  cbSize: 171  Group: 327759  cbTRGBase:
  0x70000003bcaad00RefCount: 0  Bflags: TRG, Stream
  Buffer 24:  Qflags:Spooled, Resident
  Buffer 25:  cbSize: 155  Group: 327759  cbTRGBase:
  0x70000003bcaae50RefCount: 0  Bflags: TRG, Stream
  Buffer 25:  Qflags:Spooled, Resident
  Buffer 26:  cbSize: 155  Group: 327759  cbTRGBase:
  0x70000004f2ea978RefCount: 0  Bflags: TRG, Stream
  Buffer 26:  Qflags:Spooled, Resident
  Buffer 27:  cbSize: 155  Group: 327759  cbTRGBase:
  0x70000004f2eaa40RefCount: 0  Bflags: TRG, Stream
  Buffer 27:  Qflags:Spooled, Resident
  Buffer 28:  cbSize: 179  Group: 327759  cbTRGBase:
  0x70000004f2eab80RefCount: 0  Bflags: TRG, Stream
  Buffer 28:  Qflags:Spooled, Resident
  Buffer 29:  cbSize: 171  Group: 327759  cbTRGBase:
  0x70000004f2eacd8RefCount: 0  Bflags: TRG, Stream
  Buffer 29:  Qflags:Spooled, Resident
  
  
  
  
   194      700000024f2ebe0  700000020dc9628  1    running
  8cpu         CDRACK_1
  
  
   tid    name              vp       Last Run           CPU Time
  #scheds    status
   194    CDRACK_1          8cpu    04/29 15:27:31       64.1598
  8343334    running
   25     soctcppoll       40soc*   05/01 16:46:35  5928638.8419
  1845522770    running
   126    CDRCparse        15cpu    02/28 16:09:57        0.0271
  166    cond wait  CDRCparse
   4150017 CDRStop           1cpu    05/01 16:46:37        0.3892
  177605    sleeping secs: 3
  

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