When multiple Kamailio servers are using the same database with different server_id's (one active the rest standby in this test), records disappear and are no longer tracked in location database table.
Some entries remain, but it never populates to the normal amount unless only one server is using the database.
Anyone run into this before? Happened with 5.0 and is happening with 5.1.
-dan
Hello,
On 20.12.17 06:28, Daniel W. Graham wrote:
When multiple Kamailio servers are using the same database with different server_id’s (one active the rest standby in this test), records disappear and are no longer tracked in location database table.
Some entries remain, but it never populates to the normal amount unless only one server is using the database.
I couldn't figure out the proper picture of what happens based on the above ... some questions:
- only one server (the active) writes to database, with its own id (other servers have different ids), after a while some records written by the active server disappear?
- is db_mode=3? If not, what value.
- is there any replication at database layer?
Cheers, Daniel
Anyone run into this before? Happened with 5.0 and is happening with 5.1.
-dan
Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
Yes, to your first question, most records originally written by the active server disappear. Only way to restore all records to the location table is taking standby servers offline and restart Kamailio on active server. If a restart is not performed records wont reappear in table. db_mode is 2 Database is replication is active passive.
Daniel W. Graham, CTO CMSInter.net LLC DIRECT (989) 400-4230
INTERNET | TELEPHONE | MANAGED IT
From: Daniel-Constantin Mierla [mailto:miconda@gmail.com] Sent: Wednesday, December 20, 2017 3:48 AM To: Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org; Daniel W. Graham dan@cmsinter.net Subject: Re: [SR-Users] Multiple Kamailio Servers + Location Table
Hello,
On 20.12.17 06:28, Daniel W. Graham wrote: When multiple Kamailio servers are using the same database with different server_id's (one active the rest standby in this test), records disappear and are no longer tracked in location database table.
Some entries remain, but it never populates to the normal amount unless only one server is using the database. I couldn't figure out the proper picture of what happens based on the above ... some questions:
- only one server (the active) writes to database, with its own id (other servers have different ids), after a while some records written by the active server disappear?
- is db_mode=3? If not, what value.
- is there any replication at database layer?
Cheers, Daniel
Anyone run into this before? Happened with 5.0 and is happening with 5.1.
-dan
_______________________________________________
Kamailio (SER) - Users Mailing List
sr-users@lists.kamailio.orgmailto:sr-users@lists.kamailio.org
https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
--
Daniel-Constantin Mierla
www.twitter.com/micondahttp://www.twitter.com/miconda -- www.linkedin.com/in/micondahttp://www.linkedin.com/in/miconda
Kamailio Advanced Training - www.asipto.comhttp://www.asipto.com
Kamailio World Conference - May 14-16, 2018 - www.kamailioworld.comhttp://www.kamailioworld.com
Is it possible that clients whose records disappear roam between servers? I.e. register with the active server, but then registers with a standby server while the active one is still up and running?
On Wednesday, December 20, 2017 10:34:42 AM EST Daniel W. Graham wrote:
Yes, to your first question, most records originally written by the active server disappear. Only way to restore all records to the location table is taking standby servers offline and restart Kamailio on active server. If a restart is not performed records wont reappear in table. db_mode is 2 Database is replication is active passive.
Daniel W. Graham, CTO CMSInter.net LLC DIRECT (989) 400-4230
INTERNET | TELEPHONE | MANAGED IT
From: Daniel-Constantin Mierla [mailto:miconda@gmail.com] Sent: Wednesday, December 20, 2017 3:48 AM To: Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org; Daniel W. Graham dan@cmsinter.net Subject: Re: [SR-Users] Multiple Kamailio Servers + Location Table
Hello,
On 20.12.17 06:28, Daniel W. Graham wrote: When multiple Kamailio servers are using the same database with different server_id's (one active the rest standby in this test), records disappear and are no longer tracked in location database table.
Some entries remain, but it never populates to the normal amount unless only one server is using the database. I couldn't figure out the proper picture of what happens based on the above ... some questions:
- only one server (the active) writes to database, with its own id (other
servers have different ids), after a while some records written by the active server disappear?
is db_mode=3? If not, what value.
is there any replication at database layer?
Cheers, Daniel
Anyone run into this before? Happened with 5.0 and is happening with 5.1.
-dan
Kamailio (SER) - Users Mailing List
sr-users@lists.kamailio.orgmailto:sr-users@lists.kamailio.org
https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
--
Daniel-Constantin Mierla
www.twitter.com/micondahttp://www.twitter.com/miconda -- www.linkedin.com/in/micondahttp://www.linkedin.com/in/miconda
Kamailio Advanced Training - www.asipto.comhttp://www.asipto.com
Kamailio World Conference - May 14-16, 2018 - www.kamailioworld.comhttp://www.kamailioworld.com
Only the active server has active IP, clients cannot connect to the ip of standbys.
-dan
-----Original Message----- From: sr-users [mailto:sr-users-bounces@lists.kamailio.org] On Behalf Of Sergey Okhapkin Sent: Wednesday, December 20, 2017 10:41 AM To: Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org Subject: Re: [SR-Users] Multiple Kamailio Servers + Location Table
Is it possible that clients whose records disappear roam between servers? I.e. register with the active server, but then registers with a standby server while the active one is still up and running?
On Wednesday, December 20, 2017 10:34:42 AM EST Daniel W. Graham wrote:
Yes, to your first question, most records originally written by the active server disappear. Only way to restore all records to the location table is taking standby servers offline and restart Kamailio on active server. If a restart is not performed records wont reappear in table. db_mode is 2 Database is replication is active passive.
Daniel W. Graham, CTO CMSInter.net LLC DIRECT (989) 400-4230
INTERNET | TELEPHONE | MANAGED IT
From: Daniel-Constantin Mierla [mailto:miconda@gmail.com] Sent: Wednesday, December 20, 2017 3:48 AM To: Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org; Daniel W. Graham dan@cmsinter.net Subject: Re: [SR-Users] Multiple Kamailio Servers + Location Table
Hello,
On 20.12.17 06:28, Daniel W. Graham wrote: When multiple Kamailio servers are using the same database with different server_id's (one active the rest standby in this test), records disappear and are no longer tracked in location database table.
Some entries remain, but it never populates to the normal amount unless only one server is using the database. I couldn't figure out the proper picture of what happens based on the above ... some questions:
- only one server (the active) writes to database, with its own id
(other servers have different ids), after a while some records written by the active server disappear?
is db_mode=3? If not, what value.
is there any replication at database layer?
Cheers, Daniel
Anyone run into this before? Happened with 5.0 and is happening with 5.1.
-dan
Kamailio (SER) - Users Mailing List
sr-users@lists.kamailio.orgmailto:sr-users@lists.kamailio.org
https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
--
Daniel-Constantin Mierla
www.twitter.com/micondahttp://www.twitter.com/miconda -- www.linkedin.com/in/micondahttp://www.linkedin.com/in/miconda
Kamailio Advanced Training - www.asipto.comhttp://www.asipto.com
Kamailio World Conference - May 14-16, 2018 - www.kamailioworld.comhttp://www.kamailioworld.com
_______________________________________________ Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
2017-12-20 17:39 GMT+01:00 Daniel W. Graham dan@cmsinter.net:
Only the active server has active IP, clients cannot connect to the ip of standbys.
is server_id value set and different on all servers config?
Yes they are all different.
-dan
On Dec 20, 2017, at 4:32 PM, Victor Seva <linuxmaniac@torreviejawireless.orgmailto:linuxmaniac@torreviejawireless.org> wrote:
2017-12-20 17:39 GMT+01:00 Daniel W. Graham <dan@cmsinter.netmailto:dan@cmsinter.net>: Only the active server has active IP, clients cannot connect to the ip of standbys.
is server_id value set and different on all servers config? _______________________________________________ Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.orgmailto:sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
Confirmed that db_mode = 3 works as intended however db_mode = 2 results in all records disappearing.
-dan
From: sr-users [mailto:sr-users-bounces@lists.kamailio.org] On Behalf Of Daniel W. Graham Sent: Wednesday, December 20, 2017 10:35 AM To: miconda@gmail.com; Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org Subject: Re: [SR-Users] Multiple Kamailio Servers + Location Table
Yes, to your first question, most records originally written by the active server disappear. Only way to restore all records to the location table is taking standby servers offline and restart Kamailio on active server. If a restart is not performed records wont reappear in table. db_mode is 2 Database is replication is active passive.
Daniel W. Graham, CTO CMSInter.net LLC DIRECT (989) 400-4230
INTERNET | TELEPHONE | MANAGED IT
From: Daniel-Constantin Mierla [mailto:miconda@gmail.com] Sent: Wednesday, December 20, 2017 3:48 AM To: Kamailio (SER) - Users Mailing List <sr-users@lists.kamailio.orgmailto:sr-users@lists.kamailio.org>; Daniel W. Graham <dan@cmsinter.netmailto:dan@cmsinter.net> Subject: Re: [SR-Users] Multiple Kamailio Servers + Location Table
Hello,
On 20.12.17 06:28, Daniel W. Graham wrote: When multiple Kamailio servers are using the same database with different server_id's (one active the rest standby in this test), records disappear and are no longer tracked in location database table.
Some entries remain, but it never populates to the normal amount unless only one server is using the database. I couldn't figure out the proper picture of what happens based on the above ... some questions:
- only one server (the active) writes to database, with its own id (other servers have different ids), after a while some records written by the active server disappear?
- is db_mode=3? If not, what value.
- is there any replication at database layer?
Cheers, Daniel
Anyone run into this before? Happened with 5.0 and is happening with 5.1.
-dan
_______________________________________________
Kamailio (SER) - Users Mailing List
sr-users@lists.kamailio.orgmailto:sr-users@lists.kamailio.org
https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
--
Daniel-Constantin Mierla
www.twitter.com/micondahttp://www.twitter.com/miconda -- www.linkedin.com/in/micondahttp://www.linkedin.com/in/miconda
Kamailio Advanced Training - www.asipto.comhttp://www.asipto.com
Kamailio World Conference - May 14-16, 2018 - www.kamailioworld.comhttp://www.kamailioworld.com
-
Daniel W. Graham -
Daniel-Constantin Mierla -
Sergey Okhapkin -
Victor Seva