[OpenSIPS-Users] Opensips loses location table contents

[Schneur Rosenberg]

The reason I do master/master is so that if one system goes down and
the other one comes back up then it should have all the data like
location and dialog tables, (do you have another way to do it without
master/master replication) both servers sync via same NTP time server
so that's not a issue, I will try to redo replication, and see what
happens

On Mon, Aug 20, 2012 at 9:17 PM, Ali Pey <alipey at gmail.com> wrote:
> 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
> <rosenberg11219 at gmail.com> 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
>> <rosenberg11219 at gmail.com> 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
>> 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
>