firebird database version 1.5.2 periodically at random the server to locks the firebird service
Posted on 2006-05-17
I am running a firebird database version 1.5.2 on a dual xeon server with 2GB RAM running windows 2000 server.
The business system is a set Delphi 7 apps which use IBObjects to communicate with firebird. Periodically at random, the server appears to lock up such so that all instances of the application on all client workstations freeze.
The server service will not respond to any shutdown or restart commands using command prompt or the firebird service gui utility. I need to restart the 2000 server to restart the service and all is OK until the next lock.
Locks occur any time of the day but generally only once a day 3 or so days a week. At bad times the server may lock 3 times per day.
The server task manager does not show 100% cpu usage.
The developer has looked at many things and we have had a third party developer also look at the system. We have looked at transaction handling,the udfs etc.
Does any one have any suggestions on what could be the cause or if they have heard of this.