Subject Re: Problem with gfix
Author aertjan
--- In, Helen Borrie <helebor@...>
> 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
> >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.
> ./heLen

Hi, Helen

followed this mornig your tips and everything worked fine.
Apparently the record I tried to update was the bad one because
after the gfix -v -full it was gone. But no data was lost as I could
reconstruct it.
Thanks a lot.