Informix - Problem description
Problem IT44020 | Status: Closed |
TRUNCATE ON A INTERVAL FRAGMENTED TABLE WITH ATTACHED INDEXES LEAD TO PERMANENT 410 ERROR IN OUT OF STORAGE SITUATION | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem description: | |
When a table is fragmented by interval and allocates a lot of fragments over the lifetime. When there is a out of storage situation with returning errors 271/131 and a truncate is applied it may happen that all subsequent operations on the table return in an -410. Reason is that the sysfragments table doesnt define the same amount of fragments for the data | |
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 or 14.10.xC19. * **************************************************************** | |
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 or 14.10.xC19. * **************************************************************** | |
Comment | |
Fixed in Informix Server 12.10.xC16 and 14.10.xC9. | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 20.06.2023 20.06.2023 27.09.2023 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |