INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10

If you have a fragmented table containing partition blobs and
you run the 'table repack' (or 'fragment repack') SQL API tasks
against it, the task may fail and produce an assertion failure
below if there is an intent exclusive lock on the table.

The 'table repack' task itself - when invoked from dbaccess -
fails with following error:

  $ echo "EXECUTE FUNCTION TASK ('fragment repack','4194306');"
| dbaccess sysadmin
  Database selected.

  (expression)  FAILED: admin_fragment_command('fragment repack
','4194306')
  1 row(s) retrieved.

  Database closed.

Following assertion failure is written to the MSGPATH log at the
same time:

15:29:20  SCHAPI Repack for testdb:"informix".tab1 started
15:29:20  Assert Failed: Page Check Error in
phposition:islast:bad page
15:29:20  IBM Informix Dynamic Server Version 12.10.FC6
15:29:20   Who: Session(43, informix@, 0, 70000002056cc20)
                Thread(58, StorageMGR, 70000002052df28, 1)
                File: rsdebug.c Line: 1168
15:29:20   Results: Possible inconsistencies in
'testdb:"informix".tab1'
15:29:20   Action: Run 'oncheck -cDI testdb:"informix".tab1'
15:29:20  stack trace for pid 39780686 written to
/tmp/af.4226dbf
15:29:20   See Also: /tmp/af.4226dbf, shmem.4226dbf.0
15:29:29  Page Check Error in phposition:islast:bad page
15:29:29  ERROR Repack FAILED of table 'testdb:"informix".tab1'
partnum 400002 - iserrno 105
15:29:29  ERROR Repack FAILED for table 'testdb:"informix".tab1'
- iserrno 105.
15:29:29  ERROR: admin_fragment_command('fragment repack
','4194306') failed

and the stack of the StorageMGR thread looks like:

afstack
afhandler
affail_interface
bffail
phposition
rsstart
fmrepack_frag
fmreorg
docompress_op
th_init_initgls
startup

Another symptom of this problem could be the 'table repack' task
produces error -164 (ISAM error: TEXT or BYTE stamp is
incorrect.)

****************************************************************
* USERS AFFECTED:                                              *
* IDS users running repack operations in rare circumstances    *
* involving partition blobs                                    *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Update to IBM Informix Server 12.10.xC7                      *
****************************************************************

Make sure you run the 'table repack' task when no other activity
is done on the table, ideally in Single-User mode.

not known / see Local fix

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

23.03.2016
29.06.2016
29.06.2016

12.10.xC7