Re: [Firebird-test] Firebird RC3 keeps restarting

[<ce...@so...>]

Hi Mike,

I got this problem earlier (RC1 & 2). The server restarted without apparent
reason.

Finally I found out (after moving to MySQL v5) that the problem was 'too
many connection' open (or connection pool exhausted). The problem was that
in one of my codings (of course, the most used...) I was opening a
connection and not closing it properly!

MySQL has error messages much more explicit than Firebird, and as MySQL has
now views, procedures, triggers... I will stay with MySQL. I loved very much
Firebird, I enjoyed it a lot, but I need a more reliable database for my
business.

Now I created a debugging option logging any open or closing of connection,
so I can detect easily what (new) coding is not closing connection properly.

I hope it will help you.

Regards,

Cedric.

-----Mensaje original-----
De: fir...@li...
[mailto:fir...@li...]En nombre de Mike
Starov ( aka xsaero00 )
Enviado el: Jueves, 03 de Agosto de 2006 10:18 a.m.
Para: fir...@li...
Asunto: [Firebird-test] Firebird RC3 keeps restarting


I am running FB RC3 on Suse Linux and for reason unknown firebird server
just keep on restarting. I used to run RC3 with NPTL but because of the
problem I switched to one without NPTL, but it did not help.
I don't know how to go about debugging it to pinpoint the problem so
here I am asking for pointers. It usually happens when I run python unit
tests. I use kinterbasdb for connecting to the database. The restart
usually happens when the statement is executed; the connection part
seems to go fine. In the firebird log I simply get messages about server
being abnormally shut down and then restarted by the fbguard.
Like so:
devserver (Client)    Tue Aug  1 15:58:01 2006
    /opt/firebird/bin/fbguard: bin/fbserver terminated abnormally (-1)

devserver (Client)    Tue Aug  1 15:58:01 2006
    /opt/firebird/bin/fbguard: guardian starting bin/fbserver

Where can I find out more about what caused the restart? What procedure
to follow? Any suggestion is anticipated.

--
Mike Starov
mik...@gm...

CME Resource, Inc.
Roseville, CA 95661
www.netce.com
(916) 783-4238





-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys -- and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Firebird-test mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-test