Subject Re: lock-ups in v1.5.2
Author kgdayau
superserver

Kevin.
--- In firebird-support@yahoogroups.com, "Nigel Weeks" <nweeks@e...>
wrote:
> Is this SuperServer or Classic?
>
> N
>
> > -----Original Message-----
> > From: firebird-support@yahoogroups.com
> > [mailto:firebird-support@yahoogroups.com] On Behalf Of Kevin
> > Day Programming
> > Sent: Wednesday, 25 May 2005 1:27 PM
> > To: firebird-support@yahoogroups.com
> > Subject: [firebird-support] lock-ups in v1.5.2
> >
> > Has anyone experienced anything like this. I have a firebird
> > 1.5.2 version running on a dual cpu machine running windows
> > 2000 server. There are approximately 30 users that logon via
> > my application, an accounting/ inventory/ purchasing/
> > ordering etc system.
> >
> > At any time of the day the application will all of a sudden
> > lock up, evident by the application on the clients computers
> > freezing. Then if the use task manager to kill the
> > application, they cannot login or access the database at all.
> > Even a third party query/maintenance tool such as ib_sql
> > cannot be used to connect to the database. When the lockup
> > occurs, the I.T.
> > manager on site, checks the cpu utilisation each time. The
> > cup utilisation is always low, about 2% on the cpu that the
> > firebird service is bound to.
> > The only remedy for this situation is to restart the server
> > machine, since the firebird service cannot be restarted (the
> > stop operation in service operation fails).
> >
> > This lockup occur might not occur for a day or two and then
> > it may occur 2 or 3 times in the day.
> >
> > Unfortunately I upgraded them to version 1.5.2 at the same
> > time I made some changes to the application, the main one
> > being implementing a number of computed fields which perform
> > a select sum on other table.
> >
> > Thanks,
> > Kevin.
> >
> >
> >
> >
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> >
> > Visit http://firebird.sourceforge.net and click the Resources
> > item on the main (top) menu. Try Knowledgebase and FAQ links !
> >
> > Also search the knowledgebases at http://www.ibphoenix.com
> >
> >
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> >
> > Yahoo! Groups Links
> >
> >
> >
> >
> >
> >
> >
> >
> > __________ NOD32 1.1107 (20050524) Information __________
> >
> > This message was checked by NOD32 antivirus system.
> > http://www.nod32.com
> >
> >