I would look at your database replication. It might be that they are switching back and forth and deleting the rows. Why are you replicating as master/master? Also examine the time on both servers and make sure the date and time are in sync.
Regards, Ali Pey On Mon, Aug 20, 2012 at 2:00 PM, Schneur Rosenberg <[email protected] > wrote: > It happened again just out of the nowhere, please can someone please > suggest what can cause it, I'm going crazy already. > > On Sun, Aug 19, 2012 at 12:48 PM, Schneur Rosenberg > <[email protected]> wrote: > > I'm having a interesting scenario, every once in a while my OpenSIPS > > location table begins losing its contents, I lose like 100 at a time, > > then it might regain some and then loses again another 100 or so. > > > > I have 2 servers one active and one standby via Heartbeat, heartbeat > > shuts and turns on opensips when becoming the active node, the MYSQL > > databases are replicated as a MASTER/MASTER replication. > > > > First time this happened was when I tested a updated OpenSIPS script, > > so I turned on OpenSIPS on the standby node, I did not close OpenSIPS > > right away and thats why I suspected that the standby node kept on > > erasing lines once they expired and the active node kept on adding > > rows, this was a full fledged OpenSIPS war :-) > > > > But this same thing happened last week again for no reason, I did not > > touch the standby server at all, all of the sudden we got calls from > > customers that their phones are acting weird, going online and offline > > all the time, sure enough I saw that the location table was down to > > maybe 20 registrations, I rebooted the master and it did not help, I > > rebooted the slave too and it did not help so I did a > > /etc/init.d/heartbeat stop and the slave fired up and everything went > > back to normal, within a few minutes all registrations were all back > > up. > > > > I then ran a apt-get upgrade and one of the applications that were > > updated was mysql server, so I said maybe that will fix the problem, I > > rebooted the master and heartbeat fired up OpenSIPS and everything was > > fine till today. > > > > Today I by mistake ran opensipsctl fifo lb_list on the slave > > (standby) server and sure enough it gave me a error because opensips > > was not running, but 30 minutes later I got a call from a customer > > that his lines were down. > > > > Could it be that be merely running "opensipsctl fifo lb_list" > > something would of caused this issue? I did not run "ps aux | grep > > opensips" because I right away rebooted the servers, is there anything > > else that could cause such symptoms? > > > > thanks > > S. Rosenberg > > _______________________________________________ > Users mailing list > [email protected] > http://lists.opensips.org/cgi-bin/mailman/listinfo/users >
_______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
