Kbase P111178: Cannot roll forward AI files when sequence number is larger than 65535 error 8019
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
23/11/2010 |
|
Status: Verified
SYMPTOM(s):
Cannot roll forward AI files when sequence number is larger than 65535
Expected ai file number 1 but file specified is 65536 in sequence. (8019)
Roll forward open pathname/dbname.aX error: -1
Applying an AI file with a sequence number larger than 65535
FACT(s) (Environment):
Progress 9.1x
OpenEdge 10.x
All Supported Operating Systems
CAUSE:
There is a known product limit in earlier versions which is enhanced in later OpenEdge releases. Progress can create but not roll forward after-image sequence numbers higher than 65535.
CAUSE:
Bug# OE00181957
FIX:
Upgrade to 10.1C04; 10.2A02 or 10.2B where this bug has been addressed. In these versions the new limit is 2,147,483,647.
If upgrade is not possible the following method will be necessary.
Re-enable the after image on the source database in order to reset the sequence number.
A new backup (online or offline) from the source can then be applied on the hot spare database (target), where roll forward then begins again at sequence 1.
In future, parse or monitor the database log file for messages nearing:
This is after-image file number 65535 since the last AIMAGE BEGIN (3778)
once the ai sequence has hit, you will have to re-set your baseline:
This is after-image file number 65536 since the last AIMAGE BEGIN (3778)
Depending on the environment, depends how 'quickly' these sequences are used up.
For example,
ai switch every 5 minutes in a 24x7 environment, would mean every 227 days (excluding switches associated with probkup, proquiet)
ai switch every 10 minutes in a 24x7 environment, would mean every 455 days (excluding switches associated with probkup, proquiet)
ai switch every 25MB fixed ai extent, would mean every 1600 GB worth of ai notes (excluding switches associated with probkup, proquiet)
Consider decreasing the frequency at which the ai extents are switched on the production environment.