Subject | RE: [firebird-support] Corrupted index |
---|---|
Author | Alan McDonald |
Post date | 2010-02-01T09:31:38Z |
> Hi all,try 2.1.4 snapshot.
>
> I've problem with indexes in my DB. I did a full validation of DB and
> it
> returns 8 index errors. I looked into the log file and all of them
> belongs to table STREETS (it contains like 50+ millions records). So I
> deactivated all indices and dropped PK. Then I did full validation
> again
> with no errors. So next step was to recreate PK and activate all other
> indices. When it finishes I ran full validation again and there were
> again 8 index errors. Error message in log file is "Index 1 is corrupt
> (missing entries) in table STREETS (155)".
>
> I'm running Windows 2008 R2 server, Firebird 2.1.3.18185, ODS 11.1
>
> I also tried to backup and restore my DB, but restore failed with
> "unable to allocate memory from operating system" message.
>
> Thanks for any help
>
> Milan Tomes
I had memory leakage(loss) with 2.1.3 due to transliteration of blob fields.
(same OS message unable to allocate... etc)
I don't know what characterset you use of if you have blob fields in this
table, but it's worth a go cause it solved my problems moving to 2.1.4
snapshot
Alan