Subject | Re[5]: [firebird-support] Broken databases |
---|---|
Author | Dmitry Kuzmenko |
Post date | 2013-11-18T18:56:21Z |
Hello, Dmitri!
Monday, November 18, 2013, 10:25:37 AM, you wrote:
DM> I try restore broken backup, a lot of errors in firebird.log like
DM> this. So a lot of trigger Check_X is broken, when I repair DB, I
DM> also delete them when repairing structure of DB.
DM> Server (Server)Mon Nov 18 10:10:27 2013
DM> Database: C:\DATABASE\ERRORDB\MAINBASE.FDB
DM> RDB$FLAGS for trigger CHECK_2791 in RDB$TRIGGERS is corrupted (304)
This is ... useless. Since metadata is broken, the only way to get
correct DB is to pump data from broken DB to a new, clean DB.
Al that you said about DB defects, can be caused by
- bad RAM
- updating metadata while working with data. 2.5 is more stable in
that situations, but I think there is still some problems can hide.
Do your application allow to change metadata? How often?
--
Dmitry Kuzmenko, www.ib-aid.com
Monday, November 18, 2013, 10:25:37 AM, you wrote:
DM> I try restore broken backup, a lot of errors in firebird.log like
DM> this. So a lot of trigger Check_X is broken, when I repair DB, I
DM> also delete them when repairing structure of DB.
DM> Server (Server)Mon Nov 18 10:10:27 2013
DM> Database: C:\DATABASE\ERRORDB\MAINBASE.FDB
DM> RDB$FLAGS for trigger CHECK_2791 in RDB$TRIGGERS is corrupted (304)
This is ... useless. Since metadata is broken, the only way to get
correct DB is to pump data from broken DB to a new, clean DB.
Al that you said about DB defects, can be caused by
- bad RAM
- updating metadata while working with data. 2.5 is more stable in
that situations, but I think there is still some problems can hide.
Do your application allow to change metadata? How often?
--
Dmitry Kuzmenko, www.ib-aid.com