Re: [Firebird-test] Firebird RC3 keeps restarting

[Miguel <mi...@fr...>]

Hey Cedric,

        Could you please tell me, how many connections on Firebird you found 
out?

Miguel

----- Original Message ----- 
From: "Cedric Simon" <ce...@so...>
To: <xsa...@sb...>; <fir...@li...>
Sent: Saturday, August 05, 2006 10:32 AM
Subject: Re: [Firebird-test] Firebird RC3 keeps restarting


> 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
>
>
> -------------------------------------------------------------------------
> 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
>
>
> -- 
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.1.394 / Virus Database: 268.10.7/410 - Release Date: 5/8/2006
>
>