<html><head><meta http-equiv="Content-Type" content="text/html charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">what is “channels_pkey” … thats not something thats anywhere in our codebase.<div class=""><br class=""></div><div class=""><br class=""><div><blockquote type="cite" class=""><div class="">On Jun 15, 2017, at 5:40 AM, Igor Olhovskiy <<a href="mailto:igorolhovskiy@gmail.com" class="">igorolhovskiy@gmail.com</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><div dir="ltr" class="">Hi!<div class="">Same situation here.</div><div class="">Idea is:</div><div class="">I’m having Freeswitch HA (keepalived, working, same database, calls recovering…)</div><div class="">If I look on «show calls» at slave node, I see calls on master node. </div><div class="">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.</div><div class=""><br class=""></div><div class="">So, it’s seems impossible to have 2nd recover on already recovered call.</div><div class=""><br class=""></div><div class=""><br class=""></div><div class="">In DB logs seen an errors like</div><div class=""><div class="">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/<a href="http://113-akbepcb59gt2a@172.17.240.50:5060/" class="">113-akbepcb59gt2a@172.17.240.50:5060</a>','CS_INIT','DOWN','XML','<a href="http://sip303.empowervoice.com/" class="">sip303.empowervoice.com</a>','blueAPACHE_test','103','103','172.17.240.50','113-akbepcb59gt2a','XML','<a href="http://sip303.empowervoice.com/" class="">sip303.empowervoice.com</a>')</div><div class="">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"</div></div><div class="">Or like</div><div class=""><div class="">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')</div><div class="">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"</div></div><div class=""><br class=""></div><div class=""><div class="">Also I see much queries like this</div><div class="">delete from calls where (caller_uuid=‘ffaf3eb5-3fc5-47fe-adef-cc4dddf53bab’ or callee_uuid='ffaf3eb5-3fc5-47fe-adef-cc4dddf53bab')<br class=""></div><div class="">delete from recovery where runtime_uuid!=‘91f571c5-e0d2-462e-aa84-e4ca07052119’ and technology=‘sofia’….</div><div class="">when calls are switched.</div></div><div class=""><br class=""></div><div class="">So, can this help to point an issue?</div></div><div class="gmail_extra"><br class=""><div class="gmail_quote">2017-06-08 18:48 GMT+03:00 Michael Jerris <span dir="ltr" class=""><<a href="mailto:mike@jerris.com" target="_blank" class="">mike@jerris.com</a>></span>:<br class=""><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div class="">check your db logs as nothing we are doing should be clearing those.</div><div class="HOEnZb"><div class="h5"><div class=""><br class=""><div class="gmail_quote"><div class="">On Thu, Jun 8, 2017 at 4:08 AM Denys Pozniak <<a href="mailto:denys.pozniak@crazycall.com" target="_blank" class="">denys.pozniak@crazycall.com</a>> wrote:<br class=""></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div class="">Hello!<div class=""><br class=""></div><div class="">My configs:</div><div class=""><br class=""></div><div class=""><b class="">switch.conf.xml</b></div><div class=""><br class=""></div><div class="">    <param name="switchname" value="freeswitch01"/><br class=""></div><div class=""><div class="">    <param name="core-recovery-db-dsn" value="<a href="odbc://freeswitch:root:" class="">odbc://freeswitch:root:</a><wbr class="">ubuntu"/></div><div class="">    <param name="core-db-dsn" value="<a href="odbc://freeswitch:root:" class="">odbc://freeswitch:root:</a><wbr class="">ubuntu"/></div></div></div><div class=""><div class=""><div class="">    <param name="auto-create-schemas" value="false"/></div><div class="">    <param name="auto-clear-sql" value="false"/></div><div class=""><br class=""></div></div></div><div class=""><div class=""></div><div class=""><br class=""></div><div class=""><b class="">external.conf.xml</b></div><div class=""><br class=""></div><div class=""><div class="">   <param name="track-calls" value="true"/></div><div class="">   <param name="odbc-dsn" value="<a href="odbc://freeswitch:root:" class="">odbc://freeswitch:root:</a><wbr class="">ubuntu"/><br class=""></div></div><div class=""><br class=""></div></div><div class="gmail_extra"><br class=""><div class="gmail_quote"></div></div><div class="gmail_extra"><div class="gmail_quote">On 7 June 2017 at 17:35, Michael Jerris <span class=""><<a href="mailto:mike@jerris.com" target="_blank" class="">mike@jerris.com</a>></span> wrote:<br class=""></div></div><div class="gmail_extra"><div class="gmail_quote"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div style="word-wrap:break-word" class="">That param should keep it from doing so, if its not you are not setting it somehow or something else is wiping the db.<span class=""><div class=""><br class=""><div class=""><blockquote type="cite" class=""><div class="">On Jun 5, 2017, at 1:50 PM, Denys Pozniak <<a href="mailto:denys.pozniak@crazycall.com" target="_blank" class="">denys.pozniak@crazycall.com</a>> wrote:</div><br class="m_7095689782826268291m_2266833125181999134m_-4201472578110456361Apple-interchange-newline"><div class=""><div class=""><div class="">Yes, correct. But when you restart FS on slave, it will erase database. And option auto-clear-sql=false not working for me.<br class=""><div class="gmail_extra"><br class=""><div class="gmail_quote">On Jun 5, 2017 6:32 PM, "Michael Jerris" <<a href="mailto:mike@jerris.com" target="_blank" class="">mike@jerris.com</a>> wrote:<br type="attribution" class=""><blockquote class="m_7095689782826268291m_2266833125181999134m_-4201472578110456361quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div style="word-wrap:break-word" class="">recovered calls will get new entries in the table.<div class="m_7095689782826268291m_2266833125181999134m_-4201472578110456361quoted-text"><div class=""><br class=""><div class=""><blockquote type="cite" class=""><div class="">On Jun 5, 2017, at 7:41 AM, Denys Pozniak <<a href="mailto:denys.pozniak@crazycall.com" target="_blank" class="">denys.pozniak@crazycall.com</a>> wrote:</div><br class="m_7095689782826268291m_2266833125181999134m_-4201472578110456361m_-7539566430575384145Apple-interchange-newline"><div class=""><div class="">Hello!<div class=""><br class=""></div>Thank you <b class="">Raymond</b> about your explanation, but I dont agree with some point: <br class=""><i class="">If it really need an answer about your question -- "if it is possible to move calls back".   I think it's unnecessary.</i>  - in my case I have two not equal servers, so I need to have only one as a master.<div class="">If switchover happens I need to have ability to restore master back.</div><div class=""><br class=""></div><div class="">Thank you <b class="">Luis</b> 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.</div><div class=""><br class=""></div><div class=""><div class=""><br class=""></div><div class="gmail_extra"><br class=""><div class="gmail_quote">On 3 June 2017 at 22:16, Luis Daniel Lucio Quiroz <span class=""><<a href="mailto:luis.daniel.lucio@gmail.com" target="_blank" class="">luis.daniel.lucio@gmail.com</a>></span> wrote:<br class=""><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div class=""><div class="">You may want to read this article.</div><div class=""><br class=""></div><div class=""><a href="http://inside-out.xyz/technology/how-to-configure-freeswitch-for-ha.html" target="_blank" class="">http://inside-out.xyz/<wbr class="">technology/how-to-configure-<wbr class="">freeswitch-for-ha.html</a><br class=""><div class="gmail_extra"><br class=""><div class="gmail_quote"><div class=""><div class="m_7095689782826268291m_2266833125181999134m_-4201472578110456361m_-7539566430575384145h5">Le 31 mai 2017 6:29 PM, "Denys Pozniak" <<a href="mailto:denys.pozniak@crazycall.com" target="_blank" class="">denys.pozniak@crazycall.com</a>> a écrit :<br type="attribution" class=""></div></div><blockquote class="m_7095689782826268291m_2266833125181999134m_-4201472578110456361m_-7539566430575384145m_5769005583832820732quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div class=""><div class="m_7095689782826268291m_2266833125181999134m_-4201472578110456361m_-7539566430575384145h5"><div class="">Hello!<div class=""><br class=""></div><div class="">I built FS HA solution based on keepalived and mysql master-master.</div><div class="">It works ok generally, but as I understand FS after restarting cleaning own database.</div><div class=""><br class=""></div><div class="">So when node1 fails calls jump to node2, after script restarts node1 it is not possible to move calls back.</div><div class=""><br class=""></div><div class="">Tried options in switch.conf.xml, but no luck:</div><div class=""><br class=""></div><div class=""><div class="">    <param name="auto-create-schemas" value="false"/></div><div class="">    <param name="auto-clear-sql" value="false"/></div></div><div class=""><br class=""></div><div class="">Is there is a way to solve this?</div><div class=""><br class=""></div></div></div></div></blockquote></div></div></div></div></blockquote></div></div></div></div></div></blockquote></div></div></div></div></blockquote></div></div></div></div></div></blockquote></div><br class=""></div></span></div><br class="">______________________________<wbr class="">______________________________<wbr class="">_____________<br class="">
Professional FreeSWITCH Consulting Services:<br class="">
<a href="mailto:consulting@freeswitch.org" target="_blank" class="">consulting@freeswitch.org</a><br class="">
<a href="http://www.freeswitchsolutions.com/" rel="noreferrer" target="_blank" class="">http://www.<wbr class="">freeswitchsolutions.com</a><br class="">
<br class="">
Official FreeSWITCH Sites<br class="">
<a href="http://www.freeswitch.org/" rel="noreferrer" target="_blank" class="">http://www.freeswitch.org</a><br class="">
<a href="http://confluence.freeswitch.org/" rel="noreferrer" target="_blank" class="">http://confluence.freeswitch.<wbr class="">org</a><br class="">
<a href="http://www.cluecon.com/" rel="noreferrer" target="_blank" class="">http://www.cluecon.com</a><br class="">
<br class="">
FreeSWITCH-users mailing list<br class="">
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org" target="_blank" class="">FreeSWITCH-users@lists.<wbr class="">freeswitch.org</a><br class="">
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" rel="noreferrer" target="_blank" class="">http://lists.freeswitch.org/<wbr class="">mailman/listinfo/freeswitch-<wbr class="">users</a><br class="">
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" rel="noreferrer" target="_blank" class="">http://lists.<wbr class="">freeswitch.org/mailman/<wbr class="">options/freeswitch-users</a><br class="">
<a href="http://www.freeswitch.org/" rel="noreferrer" target="_blank" class="">http://www.freeswitch.org</a><br class=""></blockquote></div></div>
______________________________<wbr class="">______________________________<wbr class="">_____________<br class="">
Professional FreeSWITCH Consulting Services:<br class="">
<a href="mailto:consulting@freeswitch.org" target="_blank" class="">consulting@freeswitch.org</a><br class="">
<a href="http://www.freeswitchsolutions.com/" rel="noreferrer" target="_blank" class="">http://www.<wbr class="">freeswitchsolutions.com</a><br class="">
<br class="">
Official FreeSWITCH Sites<br class="">
<a href="http://www.freeswitch.org/" rel="noreferrer" target="_blank" class="">http://www.freeswitch.org</a><br class="">
<a href="http://confluence.freeswitch.org/" rel="noreferrer" target="_blank" class="">http://confluence.freeswitch.<wbr class="">org</a><br class="">
<a href="http://www.cluecon.com/" rel="noreferrer" target="_blank" class="">http://www.cluecon.com</a><br class="">
<br class="">
FreeSWITCH-users mailing list<br class="">
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org" target="_blank" class="">FreeSWITCH-users@lists.<wbr class="">freeswitch.org</a><br class="">
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" rel="noreferrer" target="_blank" class="">http://lists.freeswitch.org/<wbr class="">mailman/listinfo/freeswitch-<wbr class="">users</a><br class="">
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" rel="noreferrer" target="_blank" class="">http://lists.<wbr class="">freeswitch.org/mailman/<wbr class="">options/freeswitch-users</a><br class="">
<a href="http://www.freeswitch.org/" rel="noreferrer" target="_blank" class="">http://www.freeswitch.org</a></blockquote></div></div>
</div></div><br class="">______________________________<wbr class="">______________________________<wbr class="">_____________<br class="">
Professional FreeSWITCH Consulting Services:<br class="">
<a href="mailto:consulting@freeswitch.org" class="">consulting@freeswitch.org</a><br class="">
<a href="http://www.freeswitchsolutions.com/" rel="noreferrer" target="_blank" class="">http://www.<wbr class="">freeswitchsolutions.com</a><br class="">
<br class="">
Official FreeSWITCH Sites<br class="">
<a href="http://www.freeswitch.org/" rel="noreferrer" target="_blank" class="">http://www.freeswitch.org</a><br class="">
<a href="http://confluence.freeswitch.org/" rel="noreferrer" target="_blank" class="">http://confluence.freeswitch.<wbr class="">org</a><br class="">
<a href="http://www.cluecon.com/" rel="noreferrer" target="_blank" class="">http://www.cluecon.com</a><br class="">
<br class="">
FreeSWITCH-users mailing list<br class="">
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org" class="">FreeSWITCH-users@lists.<wbr class="">freeswitch.org</a><br class="">
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" rel="noreferrer" target="_blank" class="">http://lists.freeswitch.org/<wbr class="">mailman/listinfo/freeswitch-<wbr class="">users</a><br class="">
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" rel="noreferrer" target="_blank" class="">http://lists.<wbr class="">freeswitch.org/mailman/<wbr class="">options/freeswitch-users</a><br class="">
<a href="http://www.freeswitch.org/" rel="noreferrer" target="_blank" class="">http://www.freeswitch.org</a><br class=""></blockquote></div><br class=""><br clear="all" class=""><div class=""><br class=""></div>-- <br class=""><div class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr" class="">Best regards,<div class="">Igor</div></div></div>
</div>
_________________________________________________________________________<br class="">Professional FreeSWITCH Consulting Services:<br class=""><a href="mailto:consulting@freeswitch.org" class="">consulting@freeswitch.org</a><br class="">http://www.freeswitchsolutions.com<br class=""><br class="">Official FreeSWITCH Sites<br class="">http://www.freeswitch.org<br class="">http://confluence.freeswitch.org<br class="">http://www.cluecon.com<br class=""><br class="">FreeSWITCH-users mailing list<br class="">FreeSWITCH-users@lists.freeswitch.org<br class="">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users<br class="">UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users<br class="">http://www.freeswitch.org</div></blockquote></div><br class=""></div></body></html>