• Admin-Scout-small-Banner
           
    CURSOR Admin-Scout
    get the ultimate tool for Informix
    pfeil  
invispix 10x10
invispix 10x10
Latest versionsfixlist
14.10.xC5 FixList
12.10.xC14.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
Question in the chat LiveZilla Live Help

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
not known / see Local fix
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)
invispix 10x10
invispix 10x10
invispix 10x10
Technical InfoTechnical Info

Technical Info

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

invispix 10x10
Service und SupportService und Support

Service and Support

Informix MonitoringInformix Monitoring

Informix Monitoring

Admin-Scout forInformixAdmin-Scout forInformix

Admin-Scout for Informix

Informix News & InfosInformix News & Infos

Informix News & Infos

This site uses cookies to make it easier for us to provide you with our services. By using our site you agree to the use of cookies.