Informix - Problem description
Problem IT40774 | Status: Closed |
-410 AFTER TRUNCATING A TABLE WITH INTERVAL FRAGMENTS WITH ATTACHED INDEXES WHEN TABLE WAS RUNNING OUT SPACE BEFORE | |
product: | |
INFORMIX SERVER / 5725A3900 / E10 - | |
Problem description: | |
When such a table create table tab ( a bigserial not null , b integer not null , c datetime year to second not null ) fragment by range(a) interval(200) store in(dbs2,dbs3,dbs4,dbs5,dbs6,dbs7) partition part1 VALUES < 200 in dbs1 extent size 10 next size 10 lock mode row statlevel fragment; is running of of space and then truncate table is executed every subsequent operation is leading to -410 | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 12.10.xC16 and 14.10.xC9. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix Server 12.10.xC16 (if available) or * * 14.10.xC9. * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 12.10.xC16 and 14.10.xC9. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix Server 12.10.xC16 (if available) or * * 14.10.xC9. * **************************************************************** | |
Comment | |
Fixed in Informix Server 12.10.xC16 and 14.10.xC9. | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 28.04.2022 26.09.2022 26.09.2022 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |