Subject Re: [firebird-support] GFIX syntax question - what am I doing wrong?
Author Alexandre Benson Smith
Michael Badnarik wrote:
>> At 09:47 PM 5/10/2007, Michael Badnarik wrote:
>>
>>> I have a very important database that suddenly got corrupted. I'm
>>> trying to clean it up using GFIX, but the best I can do is generate
>>> an "unavailable database" message. Most of the time it
>>> says "incompatible switch combination - please retry specifying an
>>> option - plausible options are:"
>>>
>> Alexandre Benson Smith responded:
>> a good starting point would be if you provide the command you are trying.
>>
>
> I'm sorry I didn't give more specific details.
>
> My OPEN CONTACTS database is installed on my laptop as a one-user
> system. I have installed OPEN CONTACTS as a multi-user, server-based
> system for my friend's company, and I am very familiar with the
> concept of "client/server" (or "client/service") applications. The
> scenario leading up to the problem was:
>
> My database was working just fine.
> I closed the database and all other applications to install a new application
> (This new application theoretically has nothing to do with OPEN CONTACTS.)
>

Perhaps installed an old version of FB or IB.

> After installation of the new application, my database was corrupted
> and would not open.
> The error message I received was:
> "Object: TRmMain--EAccessViolation~Access violation at address
> 00711E36 in module 'OpenContacts.exe'. Read of address 000000C"
> (This occurs after the "fuel gauge" indicates almost 95% of the data
> has been loaded)
>
> Given the circumstances, I believe that my database contains the data
> I had entered just prior to failure, and that - somehow - there was a
> lost flag, or something that corrupted the database, preventing it
> from opening.
>
> I have attempted to use the GFIX administrative application without
> success. I have copied the GFIX.EXE file to the "Open Contacts\data"
> subdirectory, where I have opened a DOS window (remember those?) and
> I have typed:
>
> gfix -user SYSDBA -password masterkey BADNARIK_ERROR.GDB -no_update
> [response=]incompatible switch option
> [response=]please retry specifying an option
>
> gfix -user SYSDBA -password masterkey BADNARIK_ERROR.GDB -online
> [response=]unsupported on-disk structure for file C:\OPEN
> CONTACTS\DATA\BADNARIK_ERROR.GDB;
> [response=]found 32779, support 10
>
> gfix -user SYSDBA -password masterkey BADNARIK_ERROR.GDB -validate
> [response=]unsupported on-disk structure for file C:\OPEN
> CONTACTS\DATA\BADNARIK_ERROR.GDB;
> [response=]found 32779, support 10
>
> gfix -user SYSDBA -password masterkey BADNARIK_ERROR.GDB -commit all
> [response=]unsupported on-disk structure for file C:\OPEN
> CONTACTS\DATA\BADNARIK_ERROR.GDB;
> [response=]found 32779, support 10
>
What versions of FB/IB did you have installed prior to install the new
software ?

Maybe you have prior FB 1.5 and now IB 6.0, or something like it.

please check de versions of the installed FB/IB.

see you !

--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br