<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head>
<body dir="ltr">
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 10pt; color: rgb(0, 0, 0);">
Hi Frédérick,</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 10pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 10pt; color: rgb(0, 0, 0);">
PostgreSQL BDR uses 'Master-Master' replication and requires locking if any of the PostgreSQL BDR nodes (that are in replication cluster) executes DDL SQL queries. It causes the whole cluster to lock as far as I remember.</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 10pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 10pt; color: rgb(0, 0, 0);">
The reason you may be experiencing the database getting locked when you restart one of the FreeSWITCH nodes is that FreeSWITCH upon its start/restart executes DDL queries. </div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 10pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 10pt; color: rgb(0, 0, 0);">
FreeSWITCH AFAIK unconditionally executes 'DROP TABLE/VIEW...' and 'CREATE TABLE/VIEW ...' for tables like 'channels', 'calls', 'interfaces', 'tasks' (TABLES) & 'detailed_calls', 'basic_calls' (VIEWS) that ultimately leads to PostgreSQL BDR getting locked.</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 10pt; color: rgb(0, 0, 0);">
<br>
</div>
<div id="Signature">
<div id="divtagdefaultwrapper" dir="ltr" style="font-size:10pt; color:#000000; font-family:Calibri,Arial,Helvetica,sans-serif">
<font face="Calibri" size="2" color="#5133ab" style="font-size:10pt">--</font>
<div><font face="Calibri" size="2" color="#5133ab" style="font-size:10pt"><font face="Calibri" color="#5133ab" style="font-size:10pt"><b>Praveen Chourasia</b><br>
</font><span style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:13.3333px"></span>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:13.3333px">
<br>
</div>
</font>
<div><span style="font-family:Calibri; font-size:10pt"><u><font color="#2672ec"></font></u></span></div>
</div>
</div>
</div>
<div id="appendonsend"></div>
<hr style="display:inline-block;width:98%" tabindex="-1">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" style="font-size:11pt" color="#000000"><b>From:</b> FreeSWITCH-users <freeswitch-users-bounces@lists.freeswitch.org> on behalf of Frédérick Pruneau <frederick@targointernet.com><br>
<b>Sent:</b> Monday, May 6, 2019 7:38 PM<br>
<b>To:</b> freeswitch-users@lists.freeswitch.org<br>
<b>Subject:</b> [Freeswitch-users] FS can't reconnect to PostgreSQL database</font>
<div> </div>
</div>
<div class="BodyFragment"><font size="2"><span style="font-size:11pt;">
<div class="PlainText">Hi guys,<br>
<br>
I have an issue with FS unable to reconnect to postgresql database. Here <br>
is the setup: 2 FreeSWITCH servers with 2 postgresql servers. Each <br>
freeswitch is connected to 1 postgresql server. DB servers are synced <br>
with BDR. It was working very well until I restarted freeswitch service <br>
on one of the servers. Then, I got theses errors showing up on <br>
freeswitch console:<br>
<br>
switch_pgsql.c:384 Query X took too long to complete or database not <br>
responding.<br>
<br>
database is locked against ddl by another node<br>
<br>
I followed some guides to remove locks with these commands:<br>
<br>
SELECT * FROM pg_stat_activity;<br>
SELECT pg_terminate_backend(${pid});<br>
<br>
But the issue is still there. Do you have an idea how to fix this issue?<br>
<br>
Thanks.<br>
<br>
_________________________________________________________________________<br>
<br>
The FreeSWITCH project is sponsored by SignalWire <a href="https://signalwire.com">
https://signalwire.com</a><br>
Enhance your FreeSWITCH install with disruptive priced SMS and PSTN services.<br>
Build your next product on our scalable cloud platform.<br>
<br>
Join our online community to chat in real time <a href="https://signalwire.community">
https://signalwire.community</a><br>
<br>
Professional FreeSWITCH Services<br>
sales@freeswitch.com<br>
<a href="https://freeswitch.com">https://freeswitch.com</a><br>
<br>
Official FreeSWITCH Sites<br>
<a href="https://freeswitch.com/oss">https://freeswitch.com/oss</a><br>
<a href="https://freeswitch.org/confluence">https://freeswitch.org/confluence</a><br>
<a href="https://cluecon.com">https://cluecon.com</a><br>
<br>
FreeSWITCH-users mailing list<br>
FreeSWITCH-users@lists.freeswitch.org<br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users<br>
<a href="https://freeswitch.com">https://freeswitch.com</a></div>
</span></font></div>
</body>
</html>