[OpenSIPS-Users] Loosing DB connection

[Brad Bendy]

Hi,

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.

Let me know if you want me to perform any testing.

Thanks

On Fri, 2010-08-27 at 11:00 +0300, Bogdan-Andrei Iancu wrote:

> Hi Brad,
> 
> strange, as the db_virtual should try to reconnect to primary DB URL 
> from time to time.....
> 
> I need to run some tests on this...
> 
> Thanks and regards,
> Bogdan
> 
> Brad Bendy wrote:
> > I should probably add that im using db_virtual with a single DB server 
> > then flat file in failover mode.
> >
> > Ive had this on 1.6.2 and 1.6.1 (using 1.6.2 currently)
> >
> > On Wed, 2010-08-25 at 07:04 -0700, Brad Bendy wrote:
> >> Hi,
> >>
> >> Sometimes OpenSIPS losses connection to our database server and 
> >> starts writing acc entries via flat file. It appears to happen when 
> >> the DB server is under heavy load. It seems like some sort of timeout 
> >> or something.
> >>
> >> Is there a way to have OpenSIPS re connect to the database without 
> >> having to do a restart? We do not lose any data as its still writing 
> >> to flat file but then we have to import from that.
> >>
> >> Thanks!
> >> _______________________________________________
> >> Users mailing list
> >> Users at lists.opensips.org <mailto:Users at lists.opensips.org>
> >> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
> >>     
> >
> > ------------------------------------------------------------------------
> >
> > _______________________________________________
> > Users mailing list
> > Users at lists.opensips.org
> > http://lists.opensips.org/cgi-bin/mailman/listinfo/users
> >   
> 
> 


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.opensips.org/pipermail/users/attachments/20100827/214143e6/attachment.htm