[Freeswitch-users] FS can't reconnect to PostgreSQL database

[Giovanni Maruzzelli]

Fredrick, no, that is a very bad idea.

Mike was rwferring to disable the freeswitch feature that manage the db
schema (eg, drop and create tables) at startup.

This can be configured in vars.conf.xml or in some other xml config file,
near where you config the dsn to access the db.

So, freeswitch will not emit ddl commands.




On Wed, May 29, 2019, 06:54 Frédérick Pruneau <frederick at targointernet.com>
wrote:

> Thanks for your help.
>
> I have found this to remove DDL locks and it works. I don't know if it is
> a good way:
>
> SELECT pg_terminate_backend(pid) FROM pg_stat_activity WHERE datname =
> 'freeswitch';
>
> ALTER ROLE $db_user SET bdr.permit_ddl_locking = false;
>
> I will check to disable schema management features.
> Le 19-05-10 à 16 h 26, Mike Jerris a écrit :
>
> If you are using shared db you should be disabling the features for
> managing the schema.  The issue is you will need to manually maintain your
> schema.  Almost always we manage schema it a way that is backwards
> compatible so you can do staged upgrades if you manually add to the tables.
>
> On May 10, 2019, at 5:45 AM, Praveen Chourasia <
> praveen.chourasia at outlook.com> wrote:
>
> Hi Frédérick,
>
> 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.
>
> 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.
>
> 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.
>
> --
> *Praveen Chourasia*
>
> ------------------------------
> *From:* FreeSWITCH-users <freeswitch-users-bounces at lists.freeswitch.org>
> on behalf of Frédérick Pruneau <frederick at targointernet.com>
> *Sent:* Monday, May 6, 2019 7:38 PM
> *To:* freeswitch-users at lists.freeswitch.org
> *Subject:* [Freeswitch-users] FS can't reconnect to PostgreSQL database
>
> Hi guys,
>
> I have an issue with FS unable to reconnect to postgresql database. Here
> is the setup: 2 FreeSWITCH servers with 2 postgresql servers. Each
> freeswitch is connected to 1 postgresql server. DB servers are synced
> with BDR. It was working very well until I restarted freeswitch service
> on one of the servers. Then, I got theses errors showing up on
> freeswitch console:
>
> switch_pgsql.c:384 Query X took too long to complete or database not
> responding.
>
> database is locked against ddl by another node
>
> I followed some guides to remove locks with these commands:
>
> SELECT * FROM pg_stat_activity;
> SELECT pg_terminate_backend(${pid});
>
> But the issue is still there. Do you have an idea how to fix this issue?
>
> Thanks.
>
>
>
> _________________________________________________________________________
>
> The FreeSWITCH project is sponsored by SignalWire https://signalwire.com
> Enhance your FreeSWITCH install with disruptive priced SMS and PSTN services.
> Build your next product on our scalable cloud platform.
>
> Join our online community to chat in real time https://signalwire.community
>
> Professional FreeSWITCH Servicessales at freeswitch.comhttps://freeswitch.com
>
> Official FreeSWITCH Siteshttps://freeswitch.com/osshttps://freeswitch.org/confluencehttps://cluecon.com
>
> FreeSWITCH-users mailing listFreeSWITCH-users at lists.freeswitch.orghttp://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-usershttps://freeswitch.com
>
> --
> *Frédérick Pruneau *| Spécialiste VoIP
>
> *T * 514.448.0773 * #* 121
> *E * frederick at targointernet.com
> <http://www.targo.ca>
>
> <https://fr-ca.facebook.com/pages/category/Local-Business/Targo-Communications-176964412324634/>
> <https://goo.gl/maps/MQtJ4S3rYLP537ss7>
> _________________________________________________________________________
>
> The FreeSWITCH project is sponsored by SignalWire https://signalwire.com
> Enhance your FreeSWITCH install with disruptive priced SMS and PSTN
> services.
> Build your next product on our scalable cloud platform.
>
> Join our online community to chat in real time
> https://signalwire.community
>
> Professional FreeSWITCH Services
> sales at freeswitch.com
> https://freeswitch.com
>
> Official FreeSWITCH Sites
> https://freeswitch.com/oss
> https://freeswitch.org/confluence
> https://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
> https://freeswitch.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20190529/04eab80e/attachment.html>