[Freeswitch-users] question about HA solution

Thu Jun 15 09:40:00 UTC 2017

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 at 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 at 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 at 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 at 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 at 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 at 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 at 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 at jerris.com> wrote:
>>>
>>> recovered calls will get new entries in the table.
>>>
>>> On Jun 5, 2017, at 7:41 AM, Denys Pozniak <denys.pozniak at 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 at 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 at 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 at 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 at 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 at 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 at 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 at 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 at 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20170615/d15f222c/attachment.html>