[Freeswitch-users] Using Postgres in core and channels keep on piling up
Victor Chukalovskiy
victor.chukalovskiy at gmail.com
Fri Jun 13 01:44:40 MSD 2014
Fair enough, thank you. I'm glad to find a definitive answer. Will stick
with odbc whenever there is a need to connect to postgres.
On 14-06-12 05:25 PM, Anthony Minessale wrote:
> 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 <mailto: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
>> <mailto: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>
>> <mailto: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:vGriffins at 88.208.219.118>
>> <mailto:sofia
>> <mailto:sofia>/Profile_250.218/vGriffins at 88.208.219.118
>> <mailto: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>
>> <mailto: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>
>> <mailto: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 <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://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 <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
>>>> <tel: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 <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://www.freeswitch.org
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>
>> _________________________________________________________________________
>> 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://www.freeswitch.org
>>
>
> _________________________________________________________________________
> 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://www.freeswitch.org
>
>
>
>
> --
> Anthony Minessale II ? @anthmfs ? @FreeSWITCH ?
>
> ? http://freeswitch.org/ ? http://cluecon.com/ ?
> http://twitter.com/FreeSWITCH
> ? irc.freenode.net <http://irc.freenode.net> #freeswitch ?
> _http://freeswitch.org/g+_
>
> ClueCon Weekly Development Call
> ? sip:888 at conference.freeswitch.org
> <mailto:sip%3A888 at conference.freeswitch.org> ? +19193869900
>
>
>
> _________________________________________________________________________
> 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/e93d7871/attachment-0001.html
Join us at ClueCon 2016 Aug 8-12, 2016
More information about the FreeSWITCH-users
mailing list