Subject Re: [firebird-support] database corruption without system restart
Author Alexey Kovyazin
Hello, Michal!

>Exception: database file appears corrupt ()
>wrong page type
>page 1849263 is of wrong type (expected 7, found 0)

Index was corrupted.


>Exception: database file appears corrupt ()
>wrong page type
>page 4051 is of wrong type (expected 5, found 0)

Table (data) was corrupted.

Did you check RAM?
It may be a reason.

Also you may gather database statisctis and take a look on table size -
the critical size is 36.6 gb.

Please feel free to contact me in private.

Sincerely yours,
Alexey Kovyazin
www.ibsurgeon.com




> hello,
>
> on one system i've experienced the following problem:
>
> firebird ss 1.5.2 on windows 2003
>
> one day, our application stop working, in log files i've found
> exception database corruption:
>
> Exception: database file appears corrupt ()
> wrong page type
> page 1849263 is of wrong type (expected 7, found 0)
>
> i took the last backup and restore - no problems; to check more
> i run gfix -v -full, no error messages. restart the system to
> be sure is clean.
>
> after few days of working again the same problem:
>
> Exception: database file appears corrupt ()
> wrong page type
> page 4051 is of wrong type (expected 5, found 0)
>
> the database is about 40GB size and one table has more than
> 100e6 records. is there some magic number i'm not aware of?
>
> what could cause the problem? hardware rather not - no messages
> in the event log, i will do the disk scan but can not stop computer at
> the moment.
>
> thanks in advance,
> ....michal
>
>