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

Fri Jun 13 01:25:40 MSD 2014

not going to allow this thread to continue.... http://jira.freeswitch.org
 Core PGSQL support is alpha and should not be used in production.

On Thu, Jun 12, 2014 at 4:07 PM, Muhammad Naseer Bhatti <nbhatti at gmail.com>
wrote:

> While I Should be filing a Jira, but the problem remains even is using
> ODBC with or without MySQL. Only then using Sqlite this behavior does not
> happen. Seems like FS looses track of channels and not cleaning up from the
> DB, and new channels also coming up at the same time. But I observed if
> traffic is stopped being sent to FS, all the channels from the DB
> eventually die. Maybe RTP timeout or something?
>
>
> Sent with Unibox <http://www.uniboxapp.com/t/sig>
>
> On Jun 13, 2014, at 12:01 AM, Victor Chukalovskiy <
> victor.chukalovskiy at gmail.com> wrote:
>
> 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
>
>
> 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>
> 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
> :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
> 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
>
>
>
> _________________________________________________________________________
> Professional FreeSWITCH Consulting Services:consulting at freeswitch.orghttp://www.freeswitchsolutions.com
>
> FreeSWITCH-powered IP PBX: The CudaTel Communication Server
>
> Official FreeSWITCH Siteshttp://www.freeswitch.orghttp://wiki.freeswitch.orghttp://www.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-usershttp://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
>
>
> _________________________________________________________________________
> 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
>
>

-- 
Anthony Minessale II       ♬ @anthmfs  ♬ @FreeSWITCH  ♬

☞ http://freeswitch.org/  ☞ http://cluecon.com/  ☞
http://twitter.com/FreeSWITCH
☞ irc.freenode.net #freeswitch ☞ *http://freeswitch.org/g+
<http://freeswitch.org/g+>*

ClueCon Weekly Development Call
☎ sip:888 at conference.freeswitch.org  ☎ +19193869900
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20140612/2cd011f2/attachment-0001.html 