Subject Re: [firebird-support] Problem with gfix
Author Helen Borrie
At 11:04 PM 9/07/2007, you wrote:
>Hi there,
>We are working with an in house developped application that uses
>Firebird 1.5 on Red Hat Linux 8 as back-end server. As of today I
>cannot do an update on a table. I entered the update statement in
>isql and it simply hangs. Also when trying to access the table via
>MS Access it hangs when trying to go to the last record. On the
>other hand I can do a fuill table scan using a select * from ...
>Therefore I think I have a corruption on the index of one of the two
>foreign keys. So I would like to check it using gfix. And this is
>what happens
>[root@R2D2 bin]# ./gfix -v -full /data/COIVOCSC/DB/coivocsc.fdb
>bad parameters on attach or create database
>-secondary server attachments cannot validate databases

You need exclusive access to do this. Log in as sysdba and perform a
database shutdown first.

>I've also tried specifying user and password. Still the same.

You'll need the SYSDBA or owner login credentials for any gfix
operation other than sweeping.