[Freeswitch-users] Using Postgres in core and channels keep on piling up

[Victor Chukalovskiy]

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 at gmail.com 
> <mailto:nbhatti at 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 at internal> show calls count
>>
>>
>> 7260 total.
>>
>>
>> freeswitch at 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 at 88.208.219.118 
>> <mailto:sofia/Profile_250.218/vGriffins at 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 at 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 at freeswitch.org <mailto:consulting at freeswitch.org>
>> http://www.freeswitchsolutions.com
>>
>> 
>> 
>>
>> Official FreeSWITCH Sites
>> http://www.freeswitch.org
>> http://wiki.freeswitch.org
>> http://www.cluecon.com
>>
>> FreeSWITCH-users mailing list
>> FreeSWITCH-users at lists.freeswitch.org 
>> <mailto:FreeSWITCH-users at 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 at freeswitch.org
> http://www.freeswitchsolutions.com
>
> 
> 
>
> Official FreeSWITCH Sites
> http://www.freeswitch.org
> http://wiki.freeswitch.org
> http://www.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
> http://www.freeswitch.org

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20140612/996571ee/attachment.html