Subject | Re: [firebird-support] database corruption without system restart |
---|---|
Author | Alexey Kovyazin |
Post date | 2005-10-26T10:06:17Z |
Hello, Michal!
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
>Exception: database file appears corrupt ()Index was corrupted.
>wrong page type
>page 1849263 is of wrong type (expected 7, found 0)
>Exception: database file appears corrupt ()Table (data) was corrupted.
>wrong page type
>page 4051 is of wrong type (expected 5, found 0)
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
>
>