Greetings. Just found this thread. I also observe issues with postgres. In my case, trying to use mod_lcr with core postgresql (postgres dsn instead of odbc dsn): -at first it works like a charm and able to do 200-400 CPS of LCR queries -after a period of time (from a minute to a few hours depending on the load) it drops to marginal 45 CPS. -calls keep piling-up to whatever limit I set in my sipp After that nothing brings FS back to desired 200-400 queries, it stays at ~45 CPS no matter what: -restarting PostgreSQL does not help -restarting mod_lcr does not help -letting FS idle with 0 calls for a few minutes does not help When this happens I observe a build-up of idle PG connections, but it never reaches max_connections set on the PG end. So, I suspect the issues is in FS core rather than PG. The only thing that brings it back to high CPS throughput is a full restart of FS. I'm starting to think that core postgres support is poorly implemented And here is a note from Brian on FS-6582:
I vote for the complete removal of CORE PGSQL Support as its incomplete and has bugs.
/b
Does anyone have a similar experience or have confirmation of core pg support being not reliable? Cheers, -Victor On 14-06-05 08:59 PM, Ken Rice wrote:
you'll probably want to open a jira on this and make sure you include all the good logging..
Ken Sent from my iPad
On Jun 5, 2014, at 17:49, Muhammad Naseer Bhatti <nbhatti@gmail.com <mailto:nbhatti@gmail.com>> wrote:
Hi, I am using Postgres in the core as well as for mod_db because the limit subsystem needs to be shared with other hosts
for mod_db <param name="odbc-dsn" value="pgsql://hostaddr=remote_host port=15432 dbname=freeswitch user=freeswitch password=freeswitch options='-c client_min_messages=NOTICE'" /> and with switch.conf <param name="core-db-dsn" value="pgsql://hostaddr=remote_host port=15432 dbname=freeswitch user=freeswitch password=freeswitch options='-c client_min_messages=NOTICE'" />
DB host has a latency of 27 ms from FreeSWITCH server. Channels keep on piling up until the max_session limit is reached and the switch does not accept any more channels. Seems like the channel info is not being released from the database. Even now I have stopped sending any calls, the switch still shows 7000+ channels connected. Offcourse that's the database only. But why this is happening?
freeswitch@internal> show calls count
7260 total.
freeswitch@internal> status
UP 0 years, 0 days, 0 hours, 24 minutes, 54 seconds, 940 milliseconds, 636 microseconds
FreeSWITCH (Version 1.4.6 git 9479729 2014-06-03 19:35:16Z 64bit) is ready
12884 session(s) since startup
0 session(s) - peak 10000, last 5min 0
0 session(s) per Sec out of max 500, peak 89, last 5min 0
10000 session(s) max
min idle cpu 0.00/99.83
Current Stack Size/Max 240K/8192K
show channels shows
0d01315c-ed00-11e3-a7c7-dfbcc3672627,inbound,2014-06-05 18:23:42,1402007022,sofia/Profile_250.218/vGriffins@88.208.219.118 <mailto:sofia/Profile_250.218/vGriffins@88.208.219.118>:5050,CS_EXECUTE,vGriffins,123456789,88.208.219.118,4414732506,,,RINGING,,,,,vBilling,,,,,,,,,,,,,,,,,,,,,
But when I try to kill that uuid,
freeswitch@internal> uuid_kill 0d01315c-ed00-11e3-a7c7-dfbcc3672627
-ERR No such channel!
I am not sure what's going on except something is not allowing for the channels to be cleared from the database. I also have tried rtp-timer-name =soft and session-timeout=10 with enable-timer=true, but that does not helps. What should I look for now?
Thanks.
Sent with Unibox <http://www.uniboxapp.com/t/sig> _________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org <mailto:consulting@freeswitch.org> http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org <mailto:FreeSWITCH-users@lists.freeswitch.org> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users <http://lists.freeswitch.org/mailman/options/freeswitch-users> http://www.freeswitch.org
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org