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@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

On Jun 13, 2014, at 12:01 AM, Victor Chukalovskiy <victor.chukalovskiy@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@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





_________________________________________________________________________
Professional FreeSWITCH Consulting Services:
consulting@freeswitch.org
http://www.freeswitchsolutions.com

FreeSWITCH-powered IP PBX: The CudaTel Communication Server
http://www.cudatel.com




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> 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: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

_________________________________________________________________________
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


_________________________________________________________________________
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










_________________________________________________________________________
Professional FreeSWITCH Consulting Services:
consulting@freeswitch.org

http://www.freeswitchsolutions.com


FreeSWITCH-powered IP PBX: The CudaTel Communication Server
http://www.cudatel.com





_________________________________________________________________________

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





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

☞ http://freeswitch.org/  ☞ http://cluecon.com/  ☞ http://twitter.com/FreeSWITCH


☞ irc.freenode.net #freeswitch ☞ http://freeswitch.org/g+

ClueCon Weekly Development Call 


☎ sip:888@conference.freeswitch.org  ☎ +19193869900