> --- 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

hang on - this is just real growth being finally reported by the OS when the
disconnection of the file occurs.
When you connect to a db and insert records madly for ten mintues, nothing
is visibly happening to the file until you disconnect. It's then that the OS
refreshes the file statistics and you see the sudden growth.

I think you're back to working out why your app crashes and how that's tied
to corruption if at all.

Alan