Subject Re: Database file grows
Author lsbtreis
--- In firebird-support@yahoogroups.com, "Alan McDonald" <alan@m...>
wrote:
> > --- In firebird-support@yahoogroups.com, "Alan McDonald" <alan@m...>
> > wrote:
> > > >
> > > > When the aplication crashes it stops.
> > > >
> > > > Elisabete
> > > >
> > >
> > > does this mean the fbserver process is running high and
> > uncontrollably when
> > > the crash occurs?
> >
> > No, during my aplication execution the fbserver is running low (
> > between 4 and 20 % CPU ) and when my aplication crashes it disapers
> > from TaskManager and the fbserver goes to 0% CPU.
> >
> > Elisabete
> >
> > > Alan
>
> but it's after this that the db file continues to grow out of
control? when
> the app is no longer in memory and the server is inactive?
> got me beat this...

I've found two different cases for which the db file grows:
1) the first is when my server app crashes. In this case the file
grows when my server app restarts.

2) In this case I have the 2 applications running and when one crahes
the db file grows. I was able to simulate this situation once. I
killed the second apllication (which has 16 open connections) but let
the server app running, The db file growed from 460M to 1.07G. This
happened in the exact moment I killed the app and there was not a
backup running at that time. The fbserver was occuping about 4% CPU
because the server app was still inserting records, I think.

So when the file grows the fbserver is not inactive but running low
(doing inserts).

Elisabete


> Alan