Informix - Problem description
Problem IT14445 | Status: Closed |
"TABLE REPACK" TASK ON A FRAGMENTED TABLE WITH PARTITION BLOBS CAN GENERATE THE 'PHPOSITION:ISLAST:BAD PAGE' TYPE OF ASSERTION | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem description: | |
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.) | |
Problem Summary: | |
**************************************************************** * 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 * **************************************************************** | |
Local Fix: | |
Make sure you run the 'table repack' task when no other activity is done on the table, ideally in Single-User mode. | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 23.03.2016 29.06.2016 29.06.2016 |
Problem solved at the following versions (IBM BugInfos) | |
12.10.xC7 | |
Problem solved according to the fixlist(s) of the following version(s) |