Subject | Re: [ib-support] --* Please Help*--- Database corruption and cannot backup & restore |
---|---|
Author | robert-wagner@t-online.de |
Post date | 2001-08-07T14:10:03Z |
Helen,
[...]
Obviously it is somehow possible to corrupt a gdb, even under Linux.
Robert
Hi all:
We have an IB database created on server:/dir/base.gdb (RedHat Linux
6.2)
One of our programmers set its Database Desktop (we´re using Delphi)
as server://dir/base.gdb (double slash)
and created
some tables and Stored Procs . Every change she makes is not seen by
anybody if database is registered (Database
Desktop , IBAdmin , isql ) with a single slash . Only if double slash is
provided changes are seen . So we have
ONE file in the system (only one base.gdb is found) and if we use two
ways to acces to it we get two different
databases . I´m sure Í´m wrong somewhere
but don´t I know where.
---
Hi, Pablo. NEVER connect to .gdb with different strings - it is most
direct way to corrupt database namely because server treat this as
different databases. Check Language Reference ("Connection-specific
examples", p. 73 for IB6) and always use connection string accordingly
your network protocol. 99% for fact your database is already
corrupted. Check it and try to repair if so.
Best regards.
---
Of course our DB was corrupted ... Any way I´m unable to understand how
I
can have
2 different databases ( at least for IbAdmin) and one physical file . As
you
said we have changed all references to db with the same string , and now
things work OK
[...]
> I haven't heard of symbolic links causing this problem on Linux...but I don't think I've heard of corruption on a Linux database either. It would be worthwhile raising on firebird-devel and/or asking Ann (world-expert database-decorrupter) if she has run across it...Below is something I found a while ago in an interbase newsgroup.
Obviously it is somehow possible to corrupt a gdb, even under Linux.
Robert
Hi all:
We have an IB database created on server:/dir/base.gdb (RedHat Linux
6.2)
One of our programmers set its Database Desktop (we´re using Delphi)
as server://dir/base.gdb (double slash)
and created
some tables and Stored Procs . Every change she makes is not seen by
anybody if database is registered (Database
Desktop , IBAdmin , isql ) with a single slash . Only if double slash is
provided changes are seen . So we have
ONE file in the system (only one base.gdb is found) and if we use two
ways to acces to it we get two different
databases . I´m sure Í´m wrong somewhere
but don´t I know where.
---
Hi, Pablo. NEVER connect to .gdb with different strings - it is most
direct way to corrupt database namely because server treat this as
different databases. Check Language Reference ("Connection-specific
examples", p. 73 for IB6) and always use connection string accordingly
your network protocol. 99% for fact your database is already
corrupted. Check it and try to repair if so.
Best regards.
---
Of course our DB was corrupted ... Any way I´m unable to understand how
I
can have
2 different databases ( at least for IbAdmin) and one physical file . As
you
said we have changed all references to db with the same string , and now
things work OK