|
Problem IT31693
|
Status: Closed |
SPORADIC -25824 ALTER FRAGMENT ATTACH ON TABLE FRAGMENT BY RANGEINTERVAL MONTH TO MONTH
|
| product: |
INFORMIX SERVER / 5725A3900 / E10 - |
| Problem description: |
Dates show below are DD/MM/YYYY.
The table in question has the following fragment schema:
fragment by range(datefe) interval(interval(1) month(9) to
month) store in (dbs1)
partition part_his_stomvt_2009 VALUES < DATE
('01/01/1900') in dbs1
and the alter executed:
alter fragment on table his_stomvt_2009 attach
his_stomvt_20091001 as
partition p20091001 VALUES < DATE ('01/11/2009')
Alters like this can sporadically fail with error:
-25824 The upper limit of the fragment must be aligned to
an interval fragment boundary.
... despite the attached fragment being correctly aligned on an
interval fragment boundary (Nov 1, 2009).
Trapping for the error, shows it occurs with the following stack
at prepare time:
0x00000000014e501d (oninit) afstack
0x00000000014e9d5d (oninit) afhandler
0x00000000014ea372 (oninit) affail_interface
0x0000000000f12f40 (oninit) check_traperror
0x0000000000797631 (oninit) sqerr
0x00000000006b78f2 (oninit) checkvalidfrag
0x00000000006beba8 (oninit) af2cb
0x00000000006c1f7c (oninit) stmt2cb
0x00000000006c3d9d (oninit) p_sp2cb
0x0000000000ade335 (oninit) parsecmd
0x0000000000adea13 (oninit) sqcmd
0x0000000000adf09d (oninit) sq_prepare
0x0000000000bc655e (oninit) sqmain |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Users of Informix Server prior to 12.10.xC14 and 14.10.xC4. *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Update to Informix Server 12.10.xC14 or 14.10.xC4. *
**************************************************************** |
| Local Fix: |
|
| Solution |
|
| Workaround |
****************************************************************
* USERS AFFECTED: *
* Users of Informix Server prior to 12.10.xC14 and 14.10.xC4. *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Update to Informix Server 12.10.xC14 or 14.10.xC4. *
**************************************************************** |
| Comment |
Fixed in Informix Server 12.10.xC14 and 14.10.xC4. |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 29.01.2020
09.06.2020
09.06.2020 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
