From: <ce...@re...> - 2006-08-07 15:01:01
|
Hi Miguel, Under windows I could investigate running FB as application: it was 63 connection. Under Linux I didn't find out, but I suspect it was less than 100 as I had a connection pool of 100. Now I am under MySQL I didn't investigate FB backwards with my connection debugging code. You can do it easily logging any open and close of connection in your codes (time, open or close, code used). Good luck... Cedric. -----Mensaje original----- De: fir...@li... [mailto:fir...@li...]En nombre de Miguel Enviado el: Lunes, 07 de Agosto de 2006 07:16 a.m. Para: fir...@li... Asunto: Re: [Firebird-test] Firebird RC3 keeps restarting 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 > > ------------------------------------------------------------------------- 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 |