Hello! I built FS HA solution based on keepalived and mysql master-master. It works ok generally, but as I understand FS after restarting cleaning own database. So when node1 fails calls jump to node2, after script restarts node1 it is not possible to move calls back. Tried options in switch.conf.xml, but no luck: <param name="auto-create-schemas" value="false"/> <param name="auto-clear-sql" value="false"/> Is there is a way to solve this? BR, Denys
Hi, Denys Talking about HA ,it's complex , and have lots of detail. The "FS HA Solution" is very simple . if you think deeper ,you will find more question,such as: A. if we have 5 servers in the group , what is the rule for transfer the calls ? B. Once the broken server have 1000 concurrent call , if there's new "performance issue" when we transfer so many calls to a server. So, forgot your question , the "HA Solution" is just a demo . It need more work to use for business . Raymond 在 2017-06-01 06:28:42，"Denys Pozniak" <denys.pozniak@crazycall.com> 写道： Hello! I built FS HA solution based on keepalived and mysql master-master. It works ok generally, but as I understand FS after restarting cleaning own database. So when node1 fails calls jump to node2, after script restarts node1 it is not possible to move calls back. Tried options in switch.conf.xml, but no luck: <param name="auto-create-schemas" value="false"/> <param name="auto-clear-sql" value="false"/> Is there is a way to solve this? BR, Denys
Hi, Denys Talking about HA ,it's complex , and have lots of detail. The "FS HA Solution" is very simple . if you think deeper ,you will find more question,such as: A. if we have 5 servers in the group , what is the rule for transfer the calls ? B. Once the broken server have 1000 concurrent call , if there's new "performance issue" when we transfer so many calls to a server. If it really need an answer about your question -- "if it is possible to move calls back". I think it's unnecessary. Every time when we transfer the calls from one server to another, there's a little "audio dropped" , maybe , not good for user experience. So, forgot your question , the "HA Solution" is just a demo . It need more work to do for product situation. Raymond 在 2017-06-01 06:28:42，"Denys Pozniak" <denys.pozniak@crazycall.com> 写道： Hello! I built FS HA solution based on keepalived and mysql master-master. It works ok generally, but as I understand FS after restarting cleaning own database. So when node1 fails calls jump to node2, after script restarts node1 it is not possible to move calls back. Tried options in switch.conf.xml, but no luck: <param name="auto-create-schemas" value="false"/> <param name="auto-clear-sql" value="false"/> Is there is a way to solve this? BR, Denys
+1 for Raymond On Jun 3, 2017 12:58, "Raymond" <xxxman2008@126.com> wrote:
Hi, Denys
Talking about HA ,it's complex , and have lots of detail. The "FS HA Solution" is very simple . if you think deeper ,you will find more question,such as: A. if we have 5 servers in the group , what is the rule for transfer the calls ? B. Once the broken server have 1000 concurrent call , if there's new "performance issue" when we transfer so many calls to a server.
If it really need an answer about your question -- "if it is possible to move calls back". I think it's unnecessary. Every time when we transfer the calls from one server to another, there's a little "audio dropped" , maybe , not good for user experience.
So, forgot your question , the "HA Solution" is just a demo . It need more work to do for product situation.
Raymond
在 2017-06-01 06:28:42，"Denys Pozniak" <denys.pozniak@crazycall.com> 写道：
Hello!
I built FS HA solution based on keepalived and mysql master-master. It works ok generally, but as I understand FS after restarting cleaning own database.
So when node1 fails calls jump to node2, after script restarts node1 it is not possible to move calls back.
Tried options in switch.conf.xml, but no luck:
<param name="auto-create-schemas" value="false"/> <param name="auto-clear-sql" value="false"/>
Is there is a way to solve this?
BR, Denys
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
Official FreeSWITCH Sites http://www.freeswitch.org http://confluence.freeswitch.org http://www.cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
You may want to read this article. http://inside-out.xyz/technology/how-to-configure-freeswitch-for-ha.html Le 31 mai 2017 6:29 PM, "Denys Pozniak" <denys.pozniak@crazycall.com> a écrit : Hello! I built FS HA solution based on keepalived and mysql master-master. It works ok generally, but as I understand FS after restarting cleaning own database. So when node1 fails calls jump to node2, after script restarts node1 it is not possible to move calls back. Tried options in switch.conf.xml, but no luck: <param name="auto-create-schemas" value="false"/> <param name="auto-clear-sql" value="false"/> Is there is a way to solve this? BR, Denys _________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com Official FreeSWITCH Sites http://www.freeswitch.org http://confluence.freeswitch.org http://www.cluecon.com FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
Hello! Thank you *Raymond* about your explanation, but I dont agree with some point: *If it really need an answer about your question -- "if it is possible to move calls back". I think it's unnecessary.* - in my case I have two not equal servers, so I need to have only one as a master. If switchover happens I need to have ability to restore master back. Thank you *Luis* for your link, you can do simple test to understand what I am talking about: do call -> check on master and slave #show channels -> restart FS on slave -> check on master #show channels. In my case I dont see any active calls after this, so restoring back is not possible. On 3 June 2017 at 22:16, Luis Daniel Lucio Quiroz < luis.daniel.lucio@gmail.com> wrote:
You may want to read this article.
http://inside-out.xyz/technology/how-to-configure-freeswitch-for-ha.html
Le 31 mai 2017 6:29 PM, "Denys Pozniak" <denys.pozniak@crazycall.com> a écrit :
Hello!
I built FS HA solution based on keepalived and mysql master-master. It works ok generally, but as I understand FS after restarting cleaning own database.
So when node1 fails calls jump to node2, after script restarts node1 it is not possible to move calls back.
Tried options in switch.conf.xml, but no luck:
<param name="auto-create-schemas" value="false"/> <param name="auto-clear-sql" value="false"/>
Is there is a way to solve this?
BR, Denys
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
Official FreeSWITCH Sites http://www.freeswitch.org http://confluence.freeswitch.org http://www.cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
recovered calls will get new entries in the table.
On Jun 5, 2017, at 7:41 AM, Denys Pozniak <denys.pozniak@crazycall.com> wrote:
Hello!
Thank you Raymond about your explanation, but I dont agree with some point: If it really need an answer about your question -- "if it is possible to move calls back". I think it's unnecessary. - in my case I have two not equal servers, so I need to have only one as a master. If switchover happens I need to have ability to restore master back.
Thank you Luis for your link, you can do simple test to understand what I am talking about: do call -> check on master and slave #show channels -> restart FS on slave -> check on master #show channels. In my case I dont see any active calls after this, so restoring back is not possible.
On 3 June 2017 at 22:16, Luis Daniel Lucio Quiroz <luis.daniel.lucio@gmail.com <mailto:luis.daniel.lucio@gmail.com>> wrote: You may want to read this article.
http://inside-out.xyz/technology/how-to-configure-freeswitch-for-ha.html <http://inside-out.xyz/technology/how-to-configure-freeswitch-for-ha.html>
Le 31 mai 2017 6:29 PM, "Denys Pozniak" <denys.pozniak@crazycall.com <mailto:denys.pozniak@crazycall.com>> a écrit : Hello!
I built FS HA solution based on keepalived and mysql master-master. It works ok generally, but as I understand FS after restarting cleaning own database.
So when node1 fails calls jump to node2, after script restarts node1 it is not possible to move calls back.
Tried options in switch.conf.xml, but no luck:
<param name="auto-create-schemas" value="false"/> <param name="auto-clear-sql" value="false"/>
Is there is a way to solve this?
Yes, correct. But when you restart FS on slave, it will erase database. And option auto-clear-sql=false not working for me. On Jun 5, 2017 6:32 PM, "Michael Jerris" <mike@jerris.com> wrote: recovered calls will get new entries in the table. On Jun 5, 2017, at 7:41 AM, Denys Pozniak <denys.pozniak@crazycall.com> wrote: Hello! Thank you *Raymond* about your explanation, but I dont agree with some point: *If it really need an answer about your question -- "if it is possible to move calls back". I think it's unnecessary.* - in my case I have two not equal servers, so I need to have only one as a master. If switchover happens I need to have ability to restore master back. Thank you *Luis* for your link, you can do simple test to understand what I am talking about: do call -> check on master and slave #show channels -> restart FS on slave -> check on master #show channels. In my case I dont see any active calls after this, so restoring back is not possible. On 3 June 2017 at 22:16, Luis Daniel Lucio Quiroz < luis.daniel.lucio@gmail.com> wrote:
You may want to read this article.
http://inside-out.xyz/technology/how-to-configure-freeswitch-for-ha.html
Le 31 mai 2017 6:29 PM, "Denys Pozniak" <denys.pozniak@crazycall.com> a écrit :
Hello!
I built FS HA solution based on keepalived and mysql master-master. It works ok generally, but as I understand FS after restarting cleaning own database.
So when node1 fails calls jump to node2, after script restarts node1 it is not possible to move calls back.
Tried options in switch.conf.xml, but no luck:
<param name="auto-create-schemas" value="false"/> <param name="auto-clear-sql" value="false"/>
Is there is a way to solve this?
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com Official FreeSWITCH Sites http://www.freeswitch.org http://confluence.freeswitch.org http://www.cluecon.com FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
Ok, Denys , I understand you have an "Master - Slave" situation. So ,you must move the call back when Master server come back. I'm sorry ,no help for u ,but ,maybe ,use an " master - master - master -...." architecture is the fastest way to resolve the problem. :-)) . The key of your question is "auto-clear-sql" option not functioning normally . plz double check your config ,and make sure , all servers have same option. Raymond 在 2017-06-06 01:50:18，"Denys Pozniak" <denys.pozniak@crazycall.com> 写道： Yes, correct. But when you restart FS on slave, it will erase database. And option auto-clear-sql=false not working for me. On Jun 5, 2017 6:32 PM, "Michael Jerris" <mike@jerris.com> wrote: recovered calls will get new entries in the table.
That param should keep it from doing so, if its not you are not setting it somehow or something else is wiping the db.
On Jun 5, 2017, at 1:50 PM, Denys Pozniak <denys.pozniak@crazycall.com> wrote:
Yes, correct. But when you restart FS on slave, it will erase database. And option auto-clear-sql=false not working for me.
On Jun 5, 2017 6:32 PM, "Michael Jerris" <mike@jerris.com <mailto:mike@jerris.com>> wrote: recovered calls will get new entries in the table.
On Jun 5, 2017, at 7:41 AM, Denys Pozniak <denys.pozniak@crazycall.com <mailto:denys.pozniak@crazycall.com>> wrote:
Hello!
Thank you Raymond about your explanation, but I dont agree with some point: If it really need an answer about your question -- "if it is possible to move calls back". I think it's unnecessary. - in my case I have two not equal servers, so I need to have only one as a master. If switchover happens I need to have ability to restore master back.
Thank you Luis for your link, you can do simple test to understand what I am talking about: do call -> check on master and slave #show channels -> restart FS on slave -> check on master #show channels. In my case I dont see any active calls after this, so restoring back is not possible.
On 3 June 2017 at 22:16, Luis Daniel Lucio Quiroz <luis.daniel.lucio@gmail.com <mailto:luis.daniel.lucio@gmail.com>> wrote: You may want to read this article.
http://inside-out.xyz/technology/how-to-configure-freeswitch-for-ha.html <http://inside-out.xyz/technology/how-to-configure-freeswitch-for-ha.html>
Le 31 mai 2017 6:29 PM, "Denys Pozniak" <denys.pozniak@crazycall.com <mailto:denys.pozniak@crazycall.com>> a écrit : Hello!
I built FS HA solution based on keepalived and mysql master-master. It works ok generally, but as I understand FS after restarting cleaning own database.
So when node1 fails calls jump to node2, after script restarts node1 it is not possible to move calls back.
Tried options in switch.conf.xml, but no luck:
<param name="auto-create-schemas" value="false"/> <param name="auto-clear-sql" value="false"/>
Is there is a way to solve this?
Which tables in particular? The one related to call recovery is the only one that matters and it never auto-clears On Wed, Jun 7, 2017 at 10:36 AM Michael Jerris <mike@jerris.com> wrote:
That param should keep it from doing so, if its not you are not setting it somehow or something else is wiping the db.
On Jun 5, 2017, at 1:50 PM, Denys Pozniak <denys.pozniak@crazycall.com> wrote:
Yes, correct. But when you restart FS on slave, it will erase database. And option auto-clear-sql=false not working for me.
On Jun 5, 2017 6:32 PM, "Michael Jerris" <mike@jerris.com> wrote:
recovered calls will get new entries in the table.
On Jun 5, 2017, at 7:41 AM, Denys Pozniak <denys.pozniak@crazycall.com> wrote:
Hello!
Thank you *Raymond* about your explanation, but I dont agree with some point: *If it really need an answer about your question -- "if it is possible to move calls back". I think it's unnecessary.* - in my case I have two not equal servers, so I need to have only one as a master. If switchover happens I need to have ability to restore master back.
Thank you *Luis* for your link, you can do simple test to understand what I am talking about: do call -> check on master and slave #show channels -> restart FS on slave -> check on master #show channels. In my case I dont see any active calls after this, so restoring back is not possible.
On 3 June 2017 at 22:16, Luis Daniel Lucio Quiroz < luis.daniel.lucio@gmail.com> wrote:
You may want to read this article.
http://inside-out.xyz/technology/how-to-configure-freeswitch-for-ha.html
Le 31 mai 2017 6:29 PM, "Denys Pozniak" <denys.pozniak@crazycall.com> a écrit :
Hello!
I built FS HA solution based on keepalived and mysql master-master. It works ok generally, but as I understand FS after restarting cleaning own database.
So when node1 fails calls jump to node2, after script restarts node1 it is not possible to move calls back.
Tried options in switch.conf.xml, but no luck:
<param name="auto-create-schemas" value="false"/> <param name="auto-clear-sql" value="false"/>
Is there is a way to solve this?
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
Official FreeSWITCH Sites http://www.freeswitch.org http://confluence.freeswitch.org http://www.cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
-- Anthony Minessale II ♬ @anthmfs ♬ @FreeSWITCH ♬ ☞ http://freeswitch.org/ ☞ http://cluecon.com/ ☞ http://twitter.com/FreeSWITCH ☞ irc.freenode.net #freeswitch ☞ *http://freeswitch.org/g+ <http://freeswitch.org/g+>* ClueCon Weekly Development Call ☎ sip:888@conference.freeswitch.org ☎ +19193869900 https://www.youtube.com/watch?v=9XXgW34t40s https://www.youtube.com/watch?v=NLaDpGQuZDA
Hello! My configs: *switch.conf.xml* <param name="switchname" value="freeswitch01"/> <param name="core-recovery-db-dsn" value="odbc://freeswitch:root:ubuntu"/> <param name="core-db-dsn" value="odbc://freeswitch:root:ubuntu"/> <param name="auto-create-schemas" value="false"/> <param name="auto-clear-sql" value="false"/> *external.conf.xml* <param name="track-calls" value="true"/> <param name="odbc-dsn" value="odbc://freeswitch:root:ubuntu"/> On 7 June 2017 at 17:35, Michael Jerris <mike@jerris.com> wrote:
That param should keep it from doing so, if its not you are not setting it somehow or something else is wiping the db.
On Jun 5, 2017, at 1:50 PM, Denys Pozniak <denys.pozniak@crazycall.com> wrote:
Yes, correct. But when you restart FS on slave, it will erase database. And option auto-clear-sql=false not working for me.
On Jun 5, 2017 6:32 PM, "Michael Jerris" <mike@jerris.com> wrote:
recovered calls will get new entries in the table.
On Jun 5, 2017, at 7:41 AM, Denys Pozniak <denys.pozniak@crazycall.com> wrote:
Hello!
Thank you *Raymond* about your explanation, but I dont agree with some point: *If it really need an answer about your question -- "if it is possible to move calls back". I think it's unnecessary.* - in my case I have two not equal servers, so I need to have only one as a master. If switchover happens I need to have ability to restore master back.
Thank you *Luis* for your link, you can do simple test to understand what I am talking about: do call -> check on master and slave #show channels -> restart FS on slave -> check on master #show channels. In my case I dont see any active calls after this, so restoring back is not possible.
On 3 June 2017 at 22:16, Luis Daniel Lucio Quiroz < luis.daniel.lucio@gmail.com> wrote:
You may want to read this article.
http://inside-out.xyz/technology/how-to-configure-freeswitch-for-ha.html
Le 31 mai 2017 6:29 PM, "Denys Pozniak" <denys.pozniak@crazycall.com> a écrit :
Hello!
I built FS HA solution based on keepalived and mysql master-master. It works ok generally, but as I understand FS after restarting cleaning own database.
So when node1 fails calls jump to node2, after script restarts node1 it is not possible to move calls back.
Tried options in switch.conf.xml, but no luck:
<param name="auto-create-schemas" value="false"/> <param name="auto-clear-sql" value="false"/>
Is there is a way to solve this?
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
Official FreeSWITCH Sites http://www.freeswitch.org http://confluence.freeswitch.org http://www.cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
check your db logs as nothing we are doing should be clearing those. On Thu, Jun 8, 2017 at 4:08 AM Denys Pozniak <denys.pozniak@crazycall.com> wrote:
Hello!
My configs:
*switch.conf.xml*
<param name="switchname" value="freeswitch01"/> <param name="core-recovery-db-dsn" value="odbc://freeswitch:root:ubuntu"/> <param name="core-db-dsn" value="odbc://freeswitch:root:ubuntu"/> <param name="auto-create-schemas" value="false"/> <param name="auto-clear-sql" value="false"/>
*external.conf.xml*
<param name="track-calls" value="true"/> <param name="odbc-dsn" value="odbc://freeswitch:root:ubuntu"/>
On 7 June 2017 at 17:35, Michael Jerris <mike@jerris.com> wrote:
That param should keep it from doing so, if its not you are not setting it somehow or something else is wiping the db.
On Jun 5, 2017, at 1:50 PM, Denys Pozniak <denys.pozniak@crazycall.com> wrote:
Yes, correct. But when you restart FS on slave, it will erase database. And option auto-clear-sql=false not working for me.
On Jun 5, 2017 6:32 PM, "Michael Jerris" <mike@jerris.com> wrote:
recovered calls will get new entries in the table.
On Jun 5, 2017, at 7:41 AM, Denys Pozniak <denys.pozniak@crazycall.com> wrote:
Hello!
Thank you *Raymond* about your explanation, but I dont agree with some point: *If it really need an answer about your question -- "if it is possible to move calls back". I think it's unnecessary.* - in my case I have two not equal servers, so I need to have only one as a master. If switchover happens I need to have ability to restore master back.
Thank you *Luis* for your link, you can do simple test to understand what I am talking about: do call -> check on master and slave #show channels -> restart FS on slave -> check on master #show channels. In my case I dont see any active calls after this, so restoring back is not possible.
On 3 June 2017 at 22:16, Luis Daniel Lucio Quiroz < luis.daniel.lucio@gmail.com> wrote:
You may want to read this article.
http://inside-out.xyz/technology/how-to-configure-freeswitch-for-ha.html
Le 31 mai 2017 6:29 PM, "Denys Pozniak" <denys.pozniak@crazycall.com> a écrit :
Hello!
I built FS HA solution based on keepalived and mysql master-master. It works ok generally, but as I understand FS after restarting cleaning own database.
So when node1 fails calls jump to node2, after script restarts node1 it is not possible to move calls back.
Tried options in switch.conf.xml, but no luck:
<param name="auto-create-schemas" value="false"/> <param name="auto-clear-sql" value="false"/>
Is there is a way to solve this?
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
Official FreeSWITCH Sites http://www.freeswitch.org http://confluence.freeswitch.org http://www.cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
Official FreeSWITCH Sites http://www.freeswitch.org http://confluence.freeswitch.org http://www.cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
Hi! Same situation here. Idea is: I’m having Freeswitch HA (keepalived, working, same database, calls recovering…) If I look on «show calls» at slave node, I see calls on master node. I crash master node (with «fsctl crash»), calls are transferred to slave node, restored, but when I run «show calls» on this (slave) node again, I see 0 calls. But calls are actually going on. So, it’s seems impossible to have 2nd recover on already recovered call. In DB logs seen an errors like insert into channels (uuid,direction,created,created_epoch, name,state,callstate,dialplan,context,hostname,initial_cid_name,initial_cid_num,initial_ip_addr,initial_dest,initial_dialplan,initial_context) values('57904410-a8ad-4c28-a88a-83bd2280e146','outbound','2017-06-15 19:30:32','1497519032','sofia/internal/113-akbepcb59gt2a@172.17.240.50:5060 ','CS_INIT','DOWN','XML','sip303.empowervoice.com ','blueAPACHE_test','103','103','172.17.240.50','113-akbepcb59gt2a','XML',' sip303.empowervoice.com') Jun 15 19:30:31 E2-EVL-T-DB-01 postgres[28042]: [109-1] 2017-06-15 19:30:31 AEST [28042-103] freeswitch@freeswitch ERROR: duplicate key value violates unique constraint «channels_pkey" Or like statement: insert into calls (call_uuid,call_created,call_created_epoch,caller_uuid,callee_uuid,hostname) values ('ffaf3eb5-3fc5-47fe-adef-cc4dddf53bab','2017-06-15 19:30:32','1497519032','ffaf3eb5-3fc5-47fe-adef-cc4dddf53bab','57904410-a8ad-4c28-a88a-83bd2280e146','blueAPACHE_test') Jun 15 19:30:31 E2-EVL-T-DB-01 postgres[28042]: [147-1] 2017-06-15 19:30:31 AEST [28042-142] freeswitch@freeswitch ERROR: duplicate key value violates unique constraint «calls_pkey" Also I see much queries like this delete from calls where (caller_uuid=‘ffaf3eb5-3fc5-47fe-adef-cc4dddf53bab’ or callee_uuid='ffaf3eb5-3fc5-47fe-adef-cc4dddf53bab') delete from recovery where runtime_uuid!=‘91f571c5-e0d2-462e-aa84-e4ca07052119’ and technology=‘sofia’…. when calls are switched. So, can this help to point an issue? 2017-06-08 18:48 GMT+03:00 Michael Jerris <mike@jerris.com>:
check your db logs as nothing we are doing should be clearing those.
On Thu, Jun 8, 2017 at 4:08 AM Denys Pozniak <denys.pozniak@crazycall.com> wrote:
Hello!
My configs:
*switch.conf.xml*
<param name="switchname" value="freeswitch01"/> <param name="core-recovery-db-dsn" value="odbc://freeswitch:root: ubuntu"/> <param name="core-db-dsn" value="odbc://freeswitch:root:ubuntu"/> <param name="auto-create-schemas" value="false"/> <param name="auto-clear-sql" value="false"/>
*external.conf.xml*
<param name="track-calls" value="true"/> <param name="odbc-dsn" value="odbc://freeswitch:root:ubuntu"/>
On 7 June 2017 at 17:35, Michael Jerris <mike@jerris.com> wrote:
That param should keep it from doing so, if its not you are not setting it somehow or something else is wiping the db.
On Jun 5, 2017, at 1:50 PM, Denys Pozniak <denys.pozniak@crazycall.com> wrote:
Yes, correct. But when you restart FS on slave, it will erase database. And option auto-clear-sql=false not working for me.
On Jun 5, 2017 6:32 PM, "Michael Jerris" <mike@jerris.com> wrote:
recovered calls will get new entries in the table.
On Jun 5, 2017, at 7:41 AM, Denys Pozniak <denys.pozniak@crazycall.com> wrote:
Hello!
Thank you *Raymond* about your explanation, but I dont agree with some point: *If it really need an answer about your question -- "if it is possible to move calls back". I think it's unnecessary.* - in my case I have two not equal servers, so I need to have only one as a master. If switchover happens I need to have ability to restore master back.
Thank you *Luis* for your link, you can do simple test to understand what I am talking about: do call -> check on master and slave #show channels -> restart FS on slave -> check on master #show channels. In my case I dont see any active calls after this, so restoring back is not possible.
On 3 June 2017 at 22:16, Luis Daniel Lucio Quiroz < luis.daniel.lucio@gmail.com> wrote:
You may want to read this article.
http://inside-out.xyz/technology/how-to-configure- freeswitch-for-ha.html
Le 31 mai 2017 6:29 PM, "Denys Pozniak" <denys.pozniak@crazycall.com> a écrit :
Hello!
I built FS HA solution based on keepalived and mysql master-master. It works ok generally, but as I understand FS after restarting cleaning own database.
So when node1 fails calls jump to node2, after script restarts node1 it is not possible to move calls back.
Tried options in switch.conf.xml, but no luck:
<param name="auto-create-schemas" value="false"/> <param name="auto-clear-sql" value="false"/>
Is there is a way to solve this?
____________________________________________________________ _____________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
Official FreeSWITCH Sites http://www.freeswitch.org http://confluence.freeswitch.org http://www.cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
Official FreeSWITCH Sites http://www.freeswitch.org http://confluence.freeswitch.org http://www.cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
Official FreeSWITCH Sites http://www.freeswitch.org http://confluence.freeswitch.org http://www.cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
-- Best regards, Igor
what is “channels_pkey” … thats not something thats anywhere in our codebase.
On Jun 15, 2017, at 5:40 AM, Igor Olhovskiy <igorolhovskiy@gmail.com> wrote:
Hi! Same situation here. Idea is: I’m having Freeswitch HA (keepalived, working, same database, calls recovering…) If I look on «show calls» at slave node, I see calls on master node. I crash master node (with «fsctl crash»), calls are transferred to slave node, restored, but when I run «show calls» on this (slave) node again, I see 0 calls. But calls are actually going on.
So, it’s seems impossible to have 2nd recover on already recovered call.
In DB logs seen an errors like insert into channels (uuid,direction,created,created_epoch, name,state,callstate,dialplan,context,hostname,initial_cid_name,initial_cid_num,initial_ip_addr,initial_dest,initial_dialplan,initial_context) values('57904410-a8ad-4c28-a88a-83bd2280e146','outbound','2017-06-15 19:30:32','1497519032','sofia/internal/113-akbepcb59gt2a@172.17.240.50:5060 <http://113-akbepcb59gt2a@172.17.240.50:5060/>','CS_INIT','DOWN','XML','sip303.empowervoice.com <http://sip303.empowervoice.com/>','blueAPACHE_test','103','103','172.17.240.50','113-akbepcb59gt2a','XML','sip303.empowervoice.com <http://sip303.empowervoice.com/>') Jun 15 19:30:31 E2-EVL-T-DB-01 postgres[28042]: [109-1] 2017-06-15 19:30:31 AEST [28042-103] freeswitch@freeswitch ERROR: duplicate key value violates unique constraint «channels_pkey" Or like statement: insert into calls (call_uuid,call_created,call_created_epoch,caller_uuid,callee_uuid,hostname) values ('ffaf3eb5-3fc5-47fe-adef-cc4dddf53bab','2017-06-15 19:30:32','1497519032','ffaf3eb5-3fc5-47fe-adef-cc4dddf53bab','57904410-a8ad-4c28-a88a-83bd2280e146','blueAPACHE_test') Jun 15 19:30:31 E2-EVL-T-DB-01 postgres[28042]: [147-1] 2017-06-15 19:30:31 AEST [28042-142] freeswitch@freeswitch ERROR: duplicate key value violates unique constraint «calls_pkey"
Also I see much queries like this delete from calls where (caller_uuid=‘ffaf3eb5-3fc5-47fe-adef-cc4dddf53bab’ or callee_uuid='ffaf3eb5-3fc5-47fe-adef-cc4dddf53bab') delete from recovery where runtime_uuid!=‘91f571c5-e0d2-462e-aa84-e4ca07052119’ and technology=‘sofia’…. when calls are switched.
So, can this help to point an issue?
2017-06-08 18:48 GMT+03:00 Michael Jerris <mike@jerris.com <mailto:mike@jerris.com>>: check your db logs as nothing we are doing should be clearing those.
On Thu, Jun 8, 2017 at 4:08 AM Denys Pozniak <denys.pozniak@crazycall.com <mailto:denys.pozniak@crazycall.com>> wrote: Hello!
My configs:
switch.conf.xml
<param name="switchname" value="freeswitch01"/> <param name="core-recovery-db-dsn" value="odbc://freeswitch:root:ubuntu"/> <param name="core-db-dsn" value="odbc://freeswitch:root:ubuntu"/> <param name="auto-create-schemas" value="false"/> <param name="auto-clear-sql" value="false"/>
external.conf.xml
<param name="track-calls" value="true"/> <param name="odbc-dsn" value="odbc://freeswitch:root:ubuntu"/>
On 7 June 2017 at 17:35, Michael Jerris <mike@jerris.com <mailto:mike@jerris.com>> wrote: That param should keep it from doing so, if its not you are not setting it somehow or something else is wiping the db.
On Jun 5, 2017, at 1:50 PM, Denys Pozniak <denys.pozniak@crazycall.com <mailto:denys.pozniak@crazycall.com>> wrote:
Yes, correct. But when you restart FS on slave, it will erase database. And option auto-clear-sql=false not working for me.
On Jun 5, 2017 6:32 PM, "Michael Jerris" <mike@jerris.com <mailto:mike@jerris.com>> wrote: recovered calls will get new entries in the table.
On Jun 5, 2017, at 7:41 AM, Denys Pozniak <denys.pozniak@crazycall.com <mailto:denys.pozniak@crazycall.com>> wrote:
Hello!
Thank you Raymond about your explanation, but I dont agree with some point: If it really need an answer about your question -- "if it is possible to move calls back". I think it's unnecessary. - in my case I have two not equal servers, so I need to have only one as a master. If switchover happens I need to have ability to restore master back.
Thank you Luis for your link, you can do simple test to understand what I am talking about: do call -> check on master and slave #show channels -> restart FS on slave -> check on master #show channels. In my case I dont see any active calls after this, so restoring back is not possible.
On 3 June 2017 at 22:16, Luis Daniel Lucio Quiroz <luis.daniel.lucio@gmail.com <mailto:luis.daniel.lucio@gmail.com>> wrote: You may want to read this article.
http://inside-out.xyz/technology/how-to-configure-freeswitch-for-ha.html <http://inside-out.xyz/technology/how-to-configure-freeswitch-for-ha.html>
Le 31 mai 2017 6:29 PM, "Denys Pozniak" <denys.pozniak@crazycall.com <mailto:denys.pozniak@crazycall.com>> a écrit : Hello!
I built FS HA solution based on keepalived and mysql master-master. It works ok generally, but as I understand FS after restarting cleaning own database.
So when node1 fails calls jump to node2, after script restarts node1 it is not possible to move calls back.
Tried options in switch.conf.xml, but no luck:
<param name="auto-create-schemas" value="false"/> <param name="auto-clear-sql" value="false"/>
Is there is a way to solve this?
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org <mailto:consulting@freeswitch.org> http://www.freeswitchsolutions.com <http://www.freeswitchsolutions.com/>
Official FreeSWITCH Sites http://www.freeswitch.org <http://www.freeswitch.org/> http://confluence.freeswitch.org <http://confluence.freeswitch.org/> http://www.cluecon.com <http://www.cluecon.com/>
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org <mailto:FreeSWITCH-users@lists.freeswitch.org> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users <http://lists.freeswitch.org/mailman/listinfo/freeswitch-users> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users <http://lists.freeswitch.org/mailman/options/freeswitch-users> http://www.freeswitch.org <http://www.freeswitch.org/> _________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org <mailto:consulting@freeswitch.org> http://www.freeswitchsolutions.com <http://www.freeswitchsolutions.com/>
Official FreeSWITCH Sites http://www.freeswitch.org <http://www.freeswitch.org/> http://confluence.freeswitch.org <http://confluence.freeswitch.org/> http://www.cluecon.com <http://www.cluecon.com/>
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org <mailto:FreeSWITCH-users@lists.freeswitch.org> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users <http://lists.freeswitch.org/mailman/listinfo/freeswitch-users> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users <http://lists.freeswitch.org/mailman/options/freeswitch-users> http://www.freeswitch.org <http://www.freeswitch.org/> _________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org <mailto:consulting@freeswitch.org> http://www.freeswitchsolutions.com <http://www.freeswitchsolutions.com/>
Official FreeSWITCH Sites http://www.freeswitch.org <http://www.freeswitch.org/> http://confluence.freeswitch.org <http://confluence.freeswitch.org/> http://www.cluecon.com <http://www.cluecon.com/>
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org <mailto:FreeSWITCH-users@lists.freeswitch.org> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users <http://lists.freeswitch.org/mailman/listinfo/freeswitch-users> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users <http://lists.freeswitch.org/mailman/options/freeswitch-users> http://www.freeswitch.org <http://www.freeswitch.org/>
-- Best regards, Igor _________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
Official FreeSWITCH Sites http://www.freeswitch.org http://confluence.freeswitch.org http://www.cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
participants (7)
-
Anthony Minessale
-
Denys Pozniak
-
Do Nguyen Ha
-
Igor Olhovskiy
-
Luis Daniel Lucio Quiroz
-
Michael Jerris
-
Raymond