Subject | RE: [firebird-support] Can't run GFix |
---|---|
Author | Tommi Prami |
Post date | 2007-12-11T07:48:52Z |
I did not run it so I did not see it (the Error message, I'll ask the dudes,
wait a Sec :) ).
I remember trying to run it a year back and never got it right.
do we need to take DB offline first (there was GFix command s for that
also).
Because dude on my left thisks he gotr DB in use, or similar, error message
I suggest that, if this is this difficult (Gfix don't give too much help, in
case of error and gfix /? don't give exact examples how to use it), could
some make small GUI frontend to do all this for us. If one knows how to use
it from commandline it should take about a day to make GUI application and
us (the casual db admins, doing the task because guru is at Bahamas) can try
to do something with corrupted DB.
btw... any ideas where to look, because this particular DB has corrupted
couple of times at very short period of time. Is it possible that db gets
corrupted by incoming selects/updates/inserts while Backup is runnign (gpak
if I recall)...
-TP-
_____
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Ann W. Harrison
Sent: 10. joulukuuta 2007 15:42
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Can't run GFix
Tommi Prami wrote:
to run gfix from a remote node or that you're trying to run it with
other connections active.
Regards,
Ann
[Non-text portions of this message have been removed]
wait a Sec :) ).
I remember trying to run it a year back and never got it right.
do we need to take DB offline first (there was GFix command s for that
also).
Because dude on my left thisks he gotr DB in use, or similar, error message
I suggest that, if this is this difficult (Gfix don't give too much help, in
case of error and gfix /? don't give exact examples how to use it), could
some make small GUI frontend to do all this for us. If one knows how to use
it from commandline it should take about a day to make GUI application and
us (the casual db admins, doing the task because guru is at Bahamas) can try
to do something with corrupted DB.
btw... any ideas where to look, because this particular DB has corrupted
couple of times at very short period of time. Is it possible that db gets
corrupted by incoming selects/updates/inserts while Backup is runnign (gpak
if I recall)...
-TP-
_____
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Ann W. Harrison
Sent: 10. joulukuuta 2007 15:42
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Can't run GFix
Tommi Prami wrote:
>In the absence of an error message, I can only guess that you're trying
> We have corrupted DB and want to run full fix/check for it. We use Super
> Server.
>
to run gfix from a remote node or that you're trying to run it with
other connections active.
Regards,
Ann
[Non-text portions of this message have been removed]