Informix - Problembeschreibung
| Problem IT07470 | Status: Geschlossen |
DYNAMIC_LOGS CAN CREATE LOG. LOG GREATER THAN 1048575 PAGES LEADING TO LOGPOS OVERFLOW | |
| Produkt: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
| Problembeschreibung: | |
In a system down situation with "Checkpoint Record not Found in
Logical Log.", after a rollback failure with
"logerr('logreadlen')" it turned out the checkpoint position
occurred twice in same log - and first one was not a checkpoint.
Looking closer at this revealed two log. logs with tremendous
sizes (> 1048575 = 0xfffff pages, which is max. addressable page
within a log. log):
Log file number 70
Unique identifier 117908
Log file flags 0x5 Log file in use
& Log file has been
backed up
Physical location 42:2589619
Log size 1732608 (p)
Number pages used 373725
Date/Time file filled 02/28/2015 22:36:30
Time stamp 0x411adb04
Log file number 71
Unique identifier 117909
Log contains last checkpoint: Page 15156, byte 24
Log file flags 0x3 Log file in use
& Current log file
Physical location 42:4322227
Log size 3502080 (p)
Number pages used 1063782
Date/Time file filled -
Time stamp -
For at least the second one (#71) we're seeing this in
online.log:
02/28/15 12:32:54 Logical Recovery has reached the transaction
cleanup phase.
02/28/15 12:35:14 Dynamically added log file 71 to DBspace 6
02/28/15 12:35:14 Checkpoint Completed: duration was 0
seconds. | |
| Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * ALL DBUSERS * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to IBM Informix Server 12.10.xC6 * **************************************************************** | |
| Local-Fix: | |
| Lösung | |
Problem Fixed In IBM Informix Server 12.10.xC6 | |
| Workaround | |
keiner bekannt / siehe Local-Fix | |
| Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 03.03.2015 30.12.2015 30.12.2015 |
| Problem behoben ab folgender Versionen (IBM BugInfos) | |
12.10.xC6 | |
| Problem behoben lt. FixList in der Version | |
| 12.10.xC5.W1 |
|
| 12.10.xC6 |
|