suche 36x36
  • Admin-Scout-small-Banner
           

    CURSOR Admin-Scout

    get the ultimate tool for Informix

    pfeil  
Latest versionsfixlist
14.10.xC10 FixList
12.10.xC16.X5 FixList
11.70.xC9.XB FixList
11.50.xC9.X2 FixList
11.10.xC3.W5 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

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)
Informix EditionsInformix Editions
Informix Editions
DocumentationDocumentation
Documentation
IBM NewsletterIBM Newsletter
IBM Newsletter
Current BugsCurrent Bugs
Current Bugs
Bug ResearchBug Research
Bug Research
Bug FixlistsBug Fixlists
Bug Fixlists
Release NotesRelease Notes
Release Notes
Machine NotesMachine Notes
Machine Notes
Release NewsRelease News
Release News
Product LifecycleProduct Lifecycle
Lifecycle
Media DownloadMedia Download
Media Download