Informix - Problem description
Problem IT33053 | Status: Closed |
ER CDRACK_1 THREAD HUNG FOREVER WHILE UPDATING ACK POINT IN PROGRESS TABLE | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem 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 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 | |
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. * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * 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. * **************************************************************** | |
Comment | |
Fixed in Informix Server 12.10.xC15 and 14.10.xC5. | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 02.06.2020 05.01.2021 05.01.2021 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |