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