Re: RES: [firebird-support] Wrong page type, how to examine/fix?

2014-02-26 Thread Kjell Rilbe
Den 2014-02-24 22:02 skrev Fabiano - Desenvolvimento SCI såhär: The right thing to do to avoid this kind of corruption is make diary backups and ensure you can restore them! If you can’t backup or not restore the entire database (including reactivating all foreign keys) you must stop

[firebird-support] Wrong page type, how to examine/fix?

2014-02-24 Thread Kjell Rilbe
On a manual sweep I got this error message: database file appears corrupt (D:\DATADIA\DATA\FIREBIRD\BACKUP\DIAMONDS.FDB) -wrong page type -page 12301932 is of wrong type (expected 4, found 7) How do I proceed to examine this error and how would I fix it? What are page types 4 and 7 and what

Re: [firebird-support] Wrong page type, how to examine/fix?

2014-02-24 Thread Ann Harrison
On Feb 24, 2014, at 7:24 AM, Kjell Rilbe kjell.ri...@datadia.se database file appears corrupt (D:\DATADIA\DATA\FIREBIRD\BACKUP\DIAMONDS.FDB) -wrong page type -page 12301932 is of wrong type (expected 4, found 7) Alas, not a great situation. Page type 4 is a pointer page - an array of

Re: [firebird-support] Wrong page type, how to examine/fix?

2014-02-24 Thread Kjell Rilbe
Den 2014-02-24 13:57 skrev Ann Harrison såhär: On Feb 24, 2014, at 7:24 AM, Kjell Rilbe kjell.ri...@datadia.se database file appears corrupt (D:\DATADIA\DATA\FIREBIRD\BACKUP\DIAMONDS.FDB) -wrong page type -page 12301932 is of wrong type (expected 4, found 7) Alas, not a great

Re: [firebird-support] Wrong page type, how to examine/fix?

2014-02-24 Thread Kjell Rilbe
Den 2014-02-24 18:31 skrev Kjell Rilbe såhär: Den 2014-02-24 13:57 skrev Ann Harrison såhär: On Feb 24, 2014, at 7:24 AM, Kjell Rilbe kjell.ri...@datadia.se database file appears corrupt (D:\DATADIA\DATA\FIREBIRD\BACKUP\DIAMONDS.FDB) -wrong page type -page 12301932 is of

Re: [firebird-support] Wrong page type, how to examine/fix?

2014-02-24 Thread Jesus Garcia
Hello, Kjell, do you know the source of the issue? Is a reproducible error in engine what have caused the corruption? Jesus García

Re: [firebird-support] Wrong page type, how to examine/fix?

2014-02-24 Thread Kjell Rilbe
Den 2014-02-24 21:13 skrev Jesus Garcia såhär: Hello, Kjell, do you know the source of the issue? Is a reproducible error in engine what have caused the corruption? No idea, really. But I do know I did some sloppy do before I think ad hoc SQL work when I created the table that has the

Re: [firebird-support] Wrong page type, how to examine/fix?

2014-02-24 Thread Alexey Kovyazin
Hi, No idea, really. But I do know I did some sloppy do before I think ad hoc SQL work when I created the table that has the corruption, and I note that IBSurgeon writes in one of their docs that dropping tables while other transactions might be working (trying to work?) with it, can confuse

Re: [firebird-support] Wrong page type, how to examine/fix?

2014-02-24 Thread Ann Harrison
Kjell, On Feb 24, 2014, at 7:24 AM, Kjell Rilbe kjell.ri...@datadia.se database file appears corrupt (D:\DATADIA\DATA\FIREBIRD\BACKUP\DIAMONDS.FDB) -wrong page type -page 12301932 is of wrong type (expected 4, found 7) Alas, not a great situation. Page type 4 is a pointer page - an

RES: [firebird-support] Wrong page type, how to examine/fix?

2014-02-24 Thread Fabiano - Desenvolvimento SCI
: [firebird-support] Wrong page type, how to examine/fix? Kjell, On Feb 24, 2014, at 7:24 AM, Kjell Rilbe kjell.ri...@datadia.se database file appears corrupt (D:\DATADIA\DATA\FIREBIRD\BACKUP\DIAMONDS.FDB) -wrong page type -page 12301932 is of wrong type (expected 4, found 7) Alas