Subject Re: [firebird-support] Database corruption
Author Ann W. Harrison
Jacques Marneweck wrote:
>> >
>> > wrong page type
>> > page 169452 is of wrong type (expected 7, found 5)
>> > (Error message: Database error.) (0x8000000d)
>> >
> Currently we are running 1.5.3 in our test environment. What I
> currently do at the moment is just "/opt/firebird/bin/gbak -r -c -v
> db.bak db.fdb && chown firebird:firebird db.bak" to get things back to
> a state for rerunning tests again.

That's a pretty big ax for killing a medium sized fly, but it works.
As I said, there's a bug that's fixed in 2.0.1 which may be the one
you're looking at, and no, it's not likely we'll back port the fix
to 1.5.x.
> What I did the other day was disable automatic sweeping (garbage
> collection) on the firebird database in question. Is there any
> recommended sweep interval which one should be doing with firebird?

I guess that could be related because the bug happens during index
clean up with contention, so if your indexes are dirty, you're more
likely to see it. Many people schedule a sweep nightly or daily
during a low usage time. A regular daily (or nightly) backup has
nearly the same effect.