<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8">
<META NAME="GENERATOR" CONTENT="GtkHTML/3.16.3">
</HEAD>
<BODY>
Hi,<BR>
<BR>
Yeah, that's what I thought as well - we ran for a while with 2 MySQL DB's then a flat file and same thing would happen where if the first one "lost connection" it would only hit the second one and would not try the first one until a restart.<BR>
<BR>
Let me know if you want me to perform any testing.<BR>
<BR>
Thanks<BR>
<BR>
On Fri, 2010-08-27 at 11:00 +0300, Bogdan-Andrei Iancu wrote:
<BLOCKQUOTE TYPE=CITE>
<PRE>
<FONT COLOR="#000000">Hi Brad,</FONT>
<FONT COLOR="#000000">strange, as the db_virtual should try to reconnect to primary DB URL </FONT>
<FONT COLOR="#000000">from time to time.....</FONT>
<FONT COLOR="#000000">I need to run some tests on this...</FONT>
<FONT COLOR="#000000">Thanks and regards,</FONT>
<FONT COLOR="#000000">Bogdan</FONT>
<FONT COLOR="#000000">Brad Bendy wrote:</FONT>
<FONT COLOR="#000000">> I should probably add that im using db_virtual with a single DB server </FONT>
<FONT COLOR="#000000">> then flat file in failover mode.</FONT>
<FONT COLOR="#000000">></FONT>
<FONT COLOR="#000000">> Ive had this on 1.6.2 and 1.6.1 (using 1.6.2 currently)</FONT>
<FONT COLOR="#000000">></FONT>
<FONT COLOR="#000000">> On Wed, 2010-08-25 at 07:04 -0700, Brad Bendy wrote:</FONT>
<FONT COLOR="#000000">>> Hi,</FONT>
<FONT COLOR="#000000">>></FONT>
<FONT COLOR="#000000">>> Sometimes OpenSIPS losses connection to our database server and </FONT>
<FONT COLOR="#000000">>> starts writing acc entries via flat file. It appears to happen when </FONT>
<FONT COLOR="#000000">>> the DB server is under heavy load. It seems like some sort of timeout </FONT>
<FONT COLOR="#000000">>> or something.</FONT>
<FONT COLOR="#000000">>></FONT>
<FONT COLOR="#000000">>> Is there a way to have OpenSIPS re connect to the database without </FONT>
<FONT COLOR="#000000">>> having to do a restart? We do not lose any data as its still writing </FONT>
<FONT COLOR="#000000">>> to flat file but then we have to import from that.</FONT>
<FONT COLOR="#000000">>></FONT>
<FONT COLOR="#000000">>> Thanks!</FONT>
<FONT COLOR="#000000">>> _______________________________________________</FONT>
<FONT COLOR="#000000">>> Users mailing list</FONT>
<FONT COLOR="#000000">>> <A HREF="mailto:Users@lists.opensips.org">Users@lists.opensips.org</A> <<A HREF="mailto:Users@lists.opensips.org">mailto:Users@lists.opensips.org</A>></FONT>
<FONT COLOR="#000000">>> <A HREF="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</A></FONT>
<FONT COLOR="#000000">>> </FONT>
<FONT COLOR="#000000">></FONT>
<FONT COLOR="#000000">> ------------------------------------------------------------------------</FONT>
<FONT COLOR="#000000">></FONT>
<FONT COLOR="#000000">> _______________________________________________</FONT>
<FONT COLOR="#000000">> Users mailing list</FONT>
<FONT COLOR="#000000">> <A HREF="mailto:Users@lists.opensips.org">Users@lists.opensips.org</A></FONT>
<FONT COLOR="#000000">> <A HREF="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</A></FONT>
<FONT COLOR="#000000">> </FONT>
</PRE>
</BLOCKQUOTE>
<TABLE CELLSPACING="0" CELLPADDING="0" WIDTH="100%">
<TR>
<TD>
<BR>
</TD>
</TR>
</TABLE>
</BODY>
</HTML>