Hi Karol and Dimitry,
Thanks for the tips.
On 23/02/2014 14:24, liviusliv...@poczta.onet.pl wrote:
Hi,
To debbug trigger use log table in autonomous transaction context
avaiable in fb2.5 or use external table which is outside of
transaction management
I tried this one first but still
Hi,
do not use global temporary table to debug
it is “temporary” and its data can dissapear after transaction or connection end
use normal table with autonomous transaction and this will be ok
regards,
Karol Bieniaszewski
From: Werner
Sent: Monday, February 24, 2014 9:49 AM
To:
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
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
Hi Karol and Dimitry,
Thanks for your tips, with them I managed to fix it.
Werner
Following just for the archive in case it might help someone else.
Not 100% but I think my initial problem had to do with not using
begin/end in my if blocks.
What did I change:
- trigger is now only for update
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
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
Hello, Kjell, do you know the source of the issue?
Is a reproducible error in engine what have caused the corruption?
Jesus García
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
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
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
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 immediately and try to fix the
database.
I think you ran this database
12 matches
Mail list logo