Subject Re: Firebird 1.5.1 sucking all memory
Author jssahdra
--- In firebird-support@yahoogroups.com, "Alan McDonald" <alan@m...>
wrote:
> > ======
> > I started firebird 15 minutes before and it is using only 9M. Now
it
> > will keep increasing. After 4-5 hours it will reach 300MB. Then
we do
> > a fb restart.
> >
> > In fact that reminds me, there is a web interface also, written in
> > perl. I remember we don't care much about closing connections etc,
> > becuase we assume that the perl will do it for us. Let me see if
that
> > is the reason. It will take at least 2 hours to monitor.
> >
> > One more problem, may be you can help me. My application gives
> > segfault sometimes, but from the core dump I am not able to find
the
> > source of error. It does not show any function name, line number
etc.
> > It is compiled with '-g' option for debugging information. Are
there
> > any other options, which can give me some more info. Because It
is a
> > multi-threaded app, logging also does not help much.
> >
> > here is the dump.
> > ================
> > Program terminated with signal 11, Segmentation fault.
> > Cannot access memory at address 0x404f3000
> > #0 0x40210780 in ?? ()
> > (gdb) bt
> > #0 0x40210780 in ?? ()
> > Cannot access memory at address 0xbf7ff5c4
> > ================
> >
> >
> > JS
>
> how often do you get these seg faults?
> In any case - keep looking - you might find yet another interface
you've
> forgotten about :-)
> Alan
I tested for four hours. It is still increasing, but at a slower
speed. In 4 hours it reached 182MB. Here is the database header.


Database header page information:
Flags 0
Checksum 12345
Generation 1272353
Page size 4096
ODS version 10.1
Oldest transaction 1272317
Oldest active 1272318
Oldest snapshot 1272318
Next transaction 1272341
Bumped transaction 1
Sequence number 0
Next attachment ID 0
Implementation ID 19
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3
Creation date Jul 28, 2004 10:25:32
Attributes