Subject Re: [firebird-support] Database Inaccessability
Author Ann Harrison
On 12/18/2013 7:48 AM, 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...


What is happening on the machine at the process level?  If you're running a shared server - SuperServer or Super Classic - has that process started?  If so, what's it doing - I/O? CPU load? Page faulting? Idle?  If you're running classic, has the connection process started?  Same questions about what's happening.  After your database has been running for a while, check the header statistics, looking for a long-running process.

Good luck,

Ann