Subject Re: [firebird-support] Database Inaccessability
Author marcus
Hej

Leyne, Sean wrote:
> 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
>
You're thinking about a transaction chain that is that big?
Being curious about the header information now...

Marcus


> *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
>
> *To: *firebird-support@yahoogroups.com
> <mailto:firebird-support@yahoogroups.com>
>
> *Reply To: *firebird-support@yahoogroups.com
> <mailto:firebird-support@yahoogroups.com>
>
> *Subject: *Re: [firebird-support] Database Inaccessability
>
> On 18-12-2013 13:48, hilton@...
> <mailto: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
>
>
>
>
>
>
>