[Freeswitch-users] Freeswitch HA postgresql BDR mod_sofia fails to start

[Arsen]

It looks like the issue is with the replication, I've removed BDR from
freeswitch database and freeswitch is flying again..
Not sure whether it's BDR or VPS performance issue or something specific
related to freeswitch DB..

If someone has experience running FS with postgre in the core and BDR your
advices are very welcome! :)

On Fri, Oct 7, 2016 at 10:45 PM, Arsen <arsen.semionov at gmail.com> wrote:

> Hi guys,
>
> I am running two freeswitch instances in HA cluster in OVH cloud VPS.
> with postgresql in the core
> postgresql BDR master-master replication
>
> sometimes (almost always) when I start/restart freeswitch service or
> mod_sofia I get errors:
>
> 2016-10-07 19:22:22.499304 [CRIT] switch_pgsql.c:360 Query (create index
> sr_call_id on sip_registrations (call_id)) took too long to complete or
> database not responding.
> 2016-10-07 19:22:22.599306 [CRIT] switch_pgsql.c:360 Query (insert into
> tasks (task_id, task_desc, task_group, task_runtime, task_sql_manager,
> hostname) values(1,'zrtp_cache_save','core',1475869032,0,'fusion01-2'))
> took too long to complete or database not responding.
> 2016-10-07 19:22:22.599306 [DEBUG] switch_pgsql.c:415 Query (insert into
> tasks (task_id, task_desc, task_group, task_runtime, task_sql_manager,
> hostname) values(2,'heartbeat','core',1475868132,0,'fusion01-2'))
> returned PGRES_FATAL_ERROR
> 2016-10-07 19:22:22.599306 [ERR] switch_pgsql.c:656 Error executing query:
> ERROR:  current transaction is aborted, commands ignored until end of
> transaction block
>
> ..and sofia can not initialize profiles or only one profile or freeswitch
> fails to start at all
>
> I can see some queries on freeswitch db with state=active when I execute
> (select * from pg_stat_activity) even when FS is down.
>
>
> top - 19:39:38 up  3:07,  7 users,  load average: 1.03, 1.04, 0.95
> Tasks: 126 total,   2 running, 124 sleeping,   0 stopped,   0 zombie
> %Cpu0  : 93.0 us,  0.3 sy,  0.0 ni,  6.6 id,  0.0 wa,  0.0 hi,  0.0 si,
>  0.0 st
> %Cpu1  :  7.1 us,  0.7 sy,  0.0 ni, 92.3 id,  0.0 wa,  0.0 hi,  0.0 si,
>  0.0 st
>
> Release:     Debian   8.6
> freeswitch                     1.6.11~19~5e413fe-1~jessie+1 amd64
> postgresql-bdr-9.4             9.4.9-1jessie
> FS config is default
>
> both VPS LAN interconnected
> OpenStack KVM
> 2 vCores
> 2.4 GHz
> 8 GB RAM
> 40 GB SSD
> Local RAID 10
>
>
> any ideas ?
>
> --
> Regards,
> Arsen.
>



-- 
Regards,
Arsen.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20161008/304606a4/attachment-0001.html