home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
15.0.xC1.2 FixList
14.10.xC13.3 FixList
12.10.xC16.X5 FixList
11.70.xC9.XB FixList
11.50.xC9.X2 FixList
11.10.xC3.W5 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

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 FixList
12.10.xC6 FixList