Subject RE: [firebird-support] lock-ups in v1.5.2
Author Nigel Weeks
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
>
>