Informix - Problem description
Problem IT39814 | Status: Closed |
TABLE LEVEL RESTORE FAILURE ON TABLE WITH DIFFERING IN-PLACE ALTER HISTORY BETWEEN ITS FRAGMENTS | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem description: | |
An archecker table level restore (TLR) on a fragmented table can fail with 'row alter' errors if table underwent in-place alters and different sets of fragments existed at each alter. Errors might look like this: ERROR: acu_ipa_rowalter: row data version(1) is invalid : pts_oldvers(0), total_versions(1) ERROR: Unable to perform ipa for (0x22f00002) ERROR: IPA row alter failed for rowid 0x0076d601 ERROR: Unable to convert page(2133_30475) for partnum 586153986 or ERROR(acu_ipa.c :2494) acu_ipa_rowalter: row data version(0) is invalid : pts_oldvers(0), total_versions(0) ERROR(acu_ipa.c : 196) Unable to perform ipa for (0x4b000002) ERROR(acu_main.c : 714) IPA row alter failed for rowid 0x00000101 ERROR(acu_unl_tab.c: 868) Unable to convert page(3705_54) for partnum 1258291202 with others possible too. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 12.10.xC16 and 14.10.xC8. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix Server 12.10.xC16 or 14.10.xC8. * **************************************************************** | |
Local Fix: | |
The problem can be circumvented by running separate TLR attempts for those sets of fragments sharing same in-place alter history. | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 12.10.xC16 and 14.10.xC8. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Informix Server 12.10.xC16 or 14.10.xC8. * **************************************************************** | |
Comment | |
Fixed in Informix Server 12.10.xC16 and 14.10.xC8. | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 01.02.2022 05.05.2023 05.05.2023 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |