I’ll be restarting the server tonight between 7 – 8pm South African time, I’ll post the Gstat output immediatley
From: [email protected] [mailto:[email protected]] On Behalf Of Leyne, Sean Sent: 18 December 2013 22:15 To: [email protected] Subject: RE: [firebird-support] Database Inaccessability 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: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Wednesday, December 18, 2013 2:58 PM To: [email protected] 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: [email protected] Reply To: [email protected] Subject: Re: [firebird-support] Database Inaccessability On 18-12-2013 13:48, [email protected] 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 __________ Information from ESET Smart Security, version of virus signature database 9190 (20131218) __________ The message was checked by ESET Smart Security. http://www.eset.com
