INFORMIX SERVER / 5725A3900 / B50 - IDS 11.50

A create index online operation will use additional threads to
process data page changes that occur whilst the index is built.
If an error occurs in one of these threads causing it to
terminate the error may not be detected leading to the sqlexec
thread becoming stuck in a loop that may not be interruptible.
One common cause of this problem may be insufficient free space
in a dbspace used to contain the index and the temporary
partitions used for storage of the old data page images. A
message indicating the full dbspace will appear in the online
log but the create index operation will continue to run.

An indication of the problem may be seen by examining the active
threads for a session. Immediately after starting the create
index online operation the onstat -g ses command for the session
will show the threads used for creation of the index and those
for processing the data page changes. For example:

tid      name     rstcb            flags    curstk   status
50       sqlexec  114d2dbf0        Y-BP---  22607    cond wait
opened_up -
51       pimage_0 114d30e00        --B----  4895     ready-
52       ulog_0x6 114d31658        --B----  3471     ready-
53       ulog_0x7 114d31eb0        --B----  3471     ready-
57       mb_colle 114d34010        --B----  3951     sleeping
secs: 1     -
58       xchg_1.0 114d34868        Y-B----  3823     cond wait
opened_up -
59       xchg_2.0 114d350c0        Y-B----  3695     cond wait
packet_con-
60       xchg_3.0 114d35918        --B-R--  3551     running-

Following the error in one or more data page processing threads
those threads with names starting "pimage" or "ulog" will
terminate and not appear in the onstat -g sess command output.
However the operation will continue until the base index has
been created at which point the other threads will exit leaving
only the sqlexec thread. This will enter a sleep loop that may
not be interrupted with onmode -z. The session information will
include:

tid      name     rstcb            flags    curstk   status
50       sqlexec  114d2dbf0        --BP---  22063    sleeping
secs: 3     -

A typical stack for the thread in this state is:

oninit :: yield_processor_mvp
oninit :: activate_updator_log_apply
oninit :: rsbldpidx
oninit :: isbldpidx
oninit :: fmamaddindex
oninit :: sqmgm_isaddindex
oninit :: creaidx
oninit :: aud_creaidx
oninit :: excommand
oninit :: sq_execute
oninit :: sqmain
oninit :: listen_verify
oninit :: spawn_thread

If onmode -z does not terminate the session then a database
server restart will be required.

****************************************************************
* USERS AFFECTED:                                              *
* Users building indexes on-line.                              *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Update to IBM Informix Server 11.50.xC10                     *
****************************************************************

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

06.07.2016
15.06.2017
15.06.2017

11.50.xC10