suche 36x36
  • Admin-Scout-small-Banner
           

    CURSOR Admin-Scout

    get the ultimate tool for Informix

    pfeil  
Latest versionsfixlist
14.10.xC11 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 IT38357 Status: Closed

THREADS CAN REMAIN IN CRITICAL SECTIONS FOR EXTREMELY LONG TIMESDURING
LOADS INTO UNLOGGED COMPRESSED TABLES

product:
INFORMIX SERVER / 5725A3900 / E10 - 
Problem description:
Threads can remain in critical sections for extremely long times
during loads into unlogged compressed tables.

When this is happening, you will see the thread in a critical
section with a stack constantly like:

0x10142d350 oninit :: yield_processor_mvp
0x1013fb518 oninit :: mt_aio_wait
0x100c77e1c oninit :: chunkio_int
0x100c77234 oninit :: chunkio
0x100c7980c oninit :: physio
0x100c706b0 oninit :: buffget
0x100cd2840 oninit :: allocvrow
0x100e951f8 oninit :: wrt_home
0x100e946fc oninit :: wrtrecord
0x100e93ea4 oninit :: rswrite
0x1014f2270 oninit :: fmwrite
0x100577518 oninit :: aud_sqiswrite
0x100789bf8 oninit :: chkrowcons
0x100721e8c oninit :: addone
0x10071d884 oninit :: ins1row
0x10071e04c oninit :: insert_next
0x100790d34 oninit :: doinsert
0x1004583e0 oninit :: excommand
0x100936094 oninit :: sq_execute_workhorse
0x1009365dc oninit :: sq_execute
0x100a06a18 oninit :: sqmain
0x101554388 oninit :: listen_verify
0x1015539bc oninit :: spawn_thread
0x10140f958 oninit :: th_init_initgls
0x10143d104 oninit :: startup
Problem Summary:
****************************************************************
* USERS AFFECTED:                                              *
* Users of Informix Server prior to 12.10.xC16 and 14.10.xC7.  *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to Informix Server 12.10.xC16 or 14.10.xC7.          *
****************************************************************
Local Fix:
Solution
Workaround
****************************************************************
* USERS AFFECTED:                                              *
* Users of Informix Server prior to 12.10.xC16 and 14.10.xC7.  *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to Informix Server 12.10.xC16 or 14.10.xC7.          *
****************************************************************
Comment
Fixed in Informix Server 12.10.xC16 and 14.10.xC7.
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
13.09.2021
02.11.2021
13.06.2023
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