home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
14.10.xC11 FixList
12.10.xC16.X5 FixList
11.70.xC9.XB FixList
11.50.xC9.X2 FixList
11.10.xC3.W5 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

Informix - Problem description

Problem IT45640 Status: Closed

POTENTIAL PARTITION CORRUPTION WHEN TRUNCATING A TABLE AFTER ALTERING ITS
EXTENT SIZE

product:
INFORMIX SERVER / 5725A3900 / E10 -
Problem description:
You might alter a table's first extent size and later truncate
the table, and no problem typically would ensue, on the current
server or any secondaries following it.

There is a chance for a problem, though, if the truncate
operation later had to undergo recovery from the logical log, as
would be the case on any secondary server, and some unfortunate
sequence of server restarts occurred, for instance, in a
cluster, a secondary got restarted between the ALTER and the
TRUNCATE, but not the primary, or vice versa.

After such sequence of events, the table's data partition(s)
might disagree between primary and secondary with regards to
number, location and size of extents which can lead to various
kinds of problems, like log recovery failure (typically a
CHALLOC failure) and extent overlaps (surfacing as bad pages).
Problem Summary:
****************************************************************
* USERS AFFECTED:                                              *
* Users of Informix Server prior to 14.10.xC11.                *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to Informix Server 14.10.xC11.                       *
****************************************************************
Local Fix:


Solution




Workaround


****************************************************************
* USERS AFFECTED:                                              *
* Users of Informix Server prior to 14.10.xC11.                *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to Informix Server 14.10.xC11.                       *
****************************************************************


Comment


Fixed in Informix Server 14.10.xC11.


Timestamps


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

05.03.2024
07.06.2024
07.06.2024


Problem solved at the following versions (IBM BugInfos)




Problem solved according to the fixlist(s) of the following version(s)