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 likeinsert 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 likestatement: 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 thisdelete 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
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