|
Problem IT19990
|
Status: Closed |
CHECKPOINT WAITING UNNECESSARILY FOR BTSCANNER WHICH IS IN A CRITICAL SECTION TOO LONG
|
| product: |
IFMX ULT WHSE E / IM0019BOS / C10 - IDS 12.10 |
| Problem description: |
Symptoms:
IBM Informix Dynamic Server Version 12.10.FC* -- On-Line (CKPT
REQ) ...
From onstat -u:
61f687a8 ---PX-B 10 informix - 0
0 2 744460499 469791
From onstat -g ath:
28 638e46a8 61f687a8 1 IO Wait
1cpu btscanner_0
From onstat -g bth:
Highest level blocker(s)
tid name session
28 btscanner_0 10
onstat -C shows the btscanner is actively scanning an index.
Depending upon the platform and how the compiler processes the
code, some possible stack traces for the btscanner thread could
be:
[observed on Linux 64 bit]
yield_processor_mvp
mt_yield
mt_aio_wait
btc_scan_index
btscanner_loop
th_init_initgls
startup
yield_processor_mvp
mt_yield
mt_aio_wait
btc_alice_scan_index
btc_scan_index
btscanner_loop
th_init_initgls
startup
yield_processor_mvp
mt_yield
mt_aio_wait
btc_range_scan_clean_buffer
btc_alice_scan_index
btc_scan_index
btscanner_loop
th_init_initgls
startup |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All platforms *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Update to IBM Informix Server 12.10.xC8 *
**************************************************************** |
| Local Fix: |
|
| Solution |
|
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 31.03.2017
19.06.2017
19.06.2017 |
| Problem solved at the following versions (IBM BugInfos) |
12.10.xC8
|
| Problem solved according to the fixlist(s) of the following version(s) |
