• 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 IT32257 Status: Closed

SQLEXEC THREAD CAN GET STUCK SPINNING INDEFINITELY IN PFSC_ADD_OR_UPD()
WHILE IN CRITICAL SECTION AND BLOCK CHECKPOINTS

product:
INFORMIX SERVER / 5725A3900 / E10 - 
Problem description:
When the problem occurs, you will often see messages like the
following in the online.log:

03/21/20 23:08:21  INC REFCOUNT: invalid refcount 55 entry
0x7000000502d08a0
03/21/20 23:08:21  DEC REFCOUNT: invalid refcount 56 entry
0x7000000502d08a0
03/21/20 23:08:21  pfsc_del_numidx: pfsc 0x502ce028 page 19544
unexpected ref. count 55
03/21/20 23:08:21  pfsc_add_or_upd: partn 0x200043 failed to
remove page 19544 from pg index
03/21/20 23:08:21  INC REFCOUNT: invalid refcount 55 entry
0x7000000502d08a0
03/21/20 23:08:21  pfsc_add_or_upd: partnum 0x200043 existing
entry found for page no. 18904
03/21/20 23:08:21  INC REFCOUNT: invalid refcount 56 entry
0x7000000502d08a0
03/21/20 23:08:21  DEC REFCOUNT: invalid refcount 57 entry
0x7000000502d08a0
03/21/20 23:08:21  pfsc_del_numidx: pfsc 0x502ce028 page 18904
unexpected ref. count 56

After these messages appear, the running thread will have a
stack like:

$ procstack 8847648
8847648: oninit -ivy
0x000000010089e480  pfsc_add_or_upd() + 0x280
0x00000001008a1e90  update_pfsc@AF58_20() + 0x50
0x0000000100c1ee34  delrecord() + 0x1294
0x0000000100c1db04  rsdelrec() + 0x1e4
0x0000000100c16a84  isdelrec() + 0x24
0x00000001008f533c  fmdelrec() + 0x13c
0x000000010050dc2c  sqisdelrec() + 0x2c
0x00000001009fe410  aud_sqisdelrec() + 0x50
0x000000010104d4bc  dodelete() + 0x45c
0x000000010104b404  chkrowcons() + 0x1524
0x00000001010540cc  dodmlrow() + 0x82c
0x0000000101056c38  dodelupd() + 0xa58
0x0000000100a0614c  aud_dodelupd() + 0xc
0x00000001009e7db0  excommand() + 0x1030
0x00000001006cfc84  sq_execute_workhorse() + 0x1e4
0x00000001006d04ec  sq_execute() + 0x6c
0x0000000100760b88  sqmain() + 0x1c8
0x0000000100b52590  listen_verify() + 0x4d0
0x0000000100b50f64  spawn_thread() + 0x1044
0x0000000100b4c99c  th_init_initgls() + 0x5c
0x0000000101a1139c  startup() + 0x1bc

And an onstat -u will show the thread in critical section and
the onstat banner can show CKPT REQ:

IBM Informix Dynamic Server Version 14.10.FC3 -- On-Line (CKPT
REQ) -- Up 00:37:06 -- 273264 Kbytes
Blocked:CKPT

Userthreads
address          flags   sessid   user     tty      wait
tout locks nreads   nwrites
...
7000000204cc968  ---PX-- 39       username    1        0
0    4     130544   101551
Problem Summary:
****************************************************************
* USERS AFFECTED:                                              *
* Users of Informix Server prior to 14.10.xC4.                 *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Update to Informix Server 14.10.xC4.                         *
****************************************************************
Customers can work around this problem by setting the following
onconfig params:

PFSC_BOOST 0
PFSC 0
Local Fix:
Solution
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
22.03.2020
09.06.2020
09.06.2020
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.