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

[Arsen]

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20161007/51fb1695/attachment-0001.html