Re: [Firebird-devel] Problems after database shutdown

[Andrew G. <an...@fe...>]

Volker Rehn wrote:

> Hi Andrew,
>
> Andrew Guts schrieb:
>
>>> Can you connect as the owner or as sysdba?
>>
>>
>> No. Connection fails with message about database shutdown.
>>
>>> Did you bring the DB online again?
>>
>>
>> Yes, by running "gfix -online /data/db" locally on server host.
>
>
> This is strange: What I usually do is this:
> gfix -online -user <user> -password <password> <host>:<dbfile>
>
> and I have never had any problems. Normally, if you shutdown a DB, the 
> user who shuts it down and the sysdba are still able to connect to it. 
> Shut down here means a DB in single-user mode, not a DB which denies 
> any access. So if you cannot connect at all, but the server is running 
> and you are even getting an error msg from it saying the db is shut 
> down - this is weird.
> Because I cannot verify your setup - I am running firebird SS RC2 on 
> NT4, I can only guess now:
>
> - gfix needs your user/password but does not compain if it does not 
> get them.

As I know gfix running locally on linux server under root account does
not need user/password.
gfix works. Problem is establishing a remote connection to database in
"shutdown mode".

> - can you backup/restore the DB? 

Yes. This does not require shut down the DB. (restore as another DB)

>
> - can you connect to other DBs? 

Yes. And my local Firebird SS 1.5 works as expected under w2k.

>
> - does it make a difference after you stop and restart the server? 

I'll not play with production server till Saturday evening.

>
> - do you perhaps use different versions of gfix? different servers? 

No, the same, but OSes. gfix is above suspicion. The same happens when I
use IBConsole,
but I can not make database online with IBConsole because of remote
connection.

Andrew