| Latest versions | fixlist |
| 14.10.xC11 |
 |
| 12.10.xC16.X5 |
|
| 11.70.xC9.XB |
|
| 11.50.xC9.X2 |
|
| 11.10.xC3.W5 |
|
| Have problems? - contact us. | |
| Register for free |
|
| Contact form |
|
Informix - Problem description
| Problem IT31187 | Status: Closed |
ALTER TABLE CAN FAIL WITH -959/-172 AND ASSERT FAILED | |
| product: | |
INFORMIX SERVER / 5725A3900 / E10 - | |
| Problem description: | |
This alter:
alter table test add (a17 integer);
... might fail with:
959: The current transaction has been rolled back due to an
internal error.
172: ISAM error: Unexpected internal error
The table schema:
create table test
(
a1 integer,
a2 integer,
a3 integer,
a4 integer,
a5 integer,
a6 integer,
a7 integer,
a8 integer,
a9 integer,
a10 integer,
a11 integer,
a12 integer,
a13 integer,
a14 integer,
a15 integer,
a16 integer
) extent size 16 next size 16 lock mode page;
create index test_idx1 on test (a1, a2, a3, a4, a5, a6, a7, a8,
a9, a10, a11, a12, a13, a14, a15, a16);
Assert Failed is also generated
12:24:57 Assert Failed: No Exception Handler
12:24:57 IBM Informix Dynamic Server Version 14.10.FC3DE
12:24:57 Who: Session(51, user@host, 7047, 0x454ae048)
Thread(67, sqlexec, 4546d8c8, 1)
File: mtex.c Line: 508
12:24:57 Results: Exception Caught. Type: MT_EX_OS, Context:
mem
afsig_handler
(Linux)
setconcol
tab2cb
stmt2cb
p_sp2cb
parsecmd
sqcmd
sq_prepare
sqmain
spawn_thread
th_init_initgls
startup | |
| Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 12.10.xC14 and 14.10.xC4. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to Informix Server 12.10.xC14 or 14.10.xC4. * **************************************************************** | |
| Local Fix: | |
| Solution | |
| Workaround | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 12.10.xC14 and 14.10.xC4. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to Informix Server 12.10.xC14 or 14.10.xC4. * **************************************************************** | |
| Comment | |
Fixed in Informix Server 12.10.xC14 and 14.10.xC4. | |
| Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 06.12.2019 08.06.2020 08.06.2020 |
| Problem solved at the following versions (IBM BugInfos) | |
| Problem solved according to the fixlist(s) of the following version(s) | |
