Subject RE: [firebird-support] Database Inaccessability
Author Leyne, Sean
Post date 2013-12-18T20:15:22Z

Hilton,

 

After you restart the server, run gstat with ‘header’ option and post the output here – before you open the database with your application.

 

 

Sean

 

From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of hilton@...
Sent: Wednesday, December 18, 2013 2:58 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Database Inaccessability

 




OS : windows server 2008 R2 x64... firebird v2.5.1

 

Firebird is running, I don't get any errors... all apps that access the firebird SQL database just hang, at the end of the 2-3 hours it responds, if I leave the app open it will suddenly respond at that time... even if I remove and re-install the firebird service it still waits the 2-3 hours before responding, if I try run a gfix on the db during this time it responds that the db might be corrupted... after the time if I run gfix it responds that the db is fine with no errors.

 

From: Mark Rotteveel

Sent: Wednesday 18 December 2013 19:55

Subject: Re: [firebird-support] Database Inaccessability

 

 

On 18-12-2013 13:48, hilton@... wrote:
> I have a Firebird SQL database running on a HP ML350 Server, 16GB Ram
> and Dual Processors.. The Problem I have is when we restart this server,
> the Database is completely inaccessible for a minimum of 2 - 3 hours,
> can't even open Using a SQL Manager... any Ideas on what to look at??
> after the 2-3Hours the db is accessible and works perfectly, it only
> happens when the server is restarted...

You really need to provide a lot more detail. What OS, what Firebird
version, what Firebird server type. Have you checked that Firebird is
actually running? What error do you get when trying to access it? Have
you checked the Firebird log

My first impression would be that Firebird isn't started immediately.

Mark
--
Mark Rotteveel