|
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) |
