Subject Re: [firebird-support] Re: Processor Alert
Author Helen Borrie
At 10:39 PM 16/03/2006, you wrote:
>--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@...>
>wrote:
> >
> > At 08:47 PM 15/03/2006, you wrote:
> > >I am experiencing problem with processor alerts caused by Firebird.
> >
> > Never heard of such a thing. What does a processor alert look
> > like? What platform?
> >
>
>The processor alert is from Windows 2003 server. It is caused by low
>system idle time.

That's cute - does it beep? page you?

>If you look in task manger, you can see that the
>firebird process is taking up a large amount of processor time. These
>alert often occour during the night, when I know that nobody is using
>the system.
>
>If I look in the FB log file I can sometimes see error messages.
>The messages that I have seen are
>
>Server01 (Client) Fri Feb 17 03:55:56 2006
> C:\Program Files\Firebird\bin\fbserver.exe: terminated
>abnormally (4294967295)

Crash, could be due to resource exhaustion, or some filesystem backup
utility locking blocks of disk so the server can't access
them. (Online databases must be excluded from system backups!)


>If I shut down the server, when I know there are no users on the
>sytem, I sometimes get the messages below
>
>Server01 (Server) Thu Feb 02 18:09:17 2006
> Shutting down the Firebird service with 13 active connection
>(s) to 2 database(s)
>
>Server01 (Server) Thu Feb 02 18:09:17 2006
> The database E:\STEEL\DATA\BRANCH04.GDB was being accessed
>when the server was shutdown
>
>Server01 (Server) Thu Feb 02 18:09:17 2006
> The database E:\STEEL\DATA\SYSTEM.GDB was being accessed when
>the server was shutdown
>
>It is clear that for some reason users are not disconnecting from the
>database correctly.

...or, rather, not disconnecting at all. When you say "nobody is
using the system", what means do you use to test that users are not
connected before you shut down the server?

...are you sure that the busy night-work is not
garbage-collection? Do you watch the stats at all to get an idea of
what to expect when idle time is available?

...do any of your applications use events?

...is some kind of filesystem backup being done over the top of
connected databases?

>Usin WI-V1.5.1.4481 Firebird 1.5

That's more than a year and a half old and 2 sub-releases
behind. Have you checked the v.1.5.2 and v.1.5.3 bugfixes in the
latest (1.5.3) release notes to see whether there are any fixes there
for problems similar to yours?

./heLen