Using Postgres in core and channels keep on piling up
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
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
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
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
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
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
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
_________________________________________________________________________ Professional FreeSWITCH Consulting Services:consulting@freeswitch.org http://www.freeswitchsolutions.com FreeSWITCH-powered IP PBX: The CudaTel Communication Serverhttp://www.cudatel.com Official FreeSWITCH Siteshttp://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com FreeSWITCH-users mailing listFreeSWITCH-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
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 <http://www.uniboxapp.com/t/sig>
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
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
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 <http://www.uniboxapp.com/t/sig>
_________________________________________________________________________ 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.orghttp://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Serverhttp://www.cudatel.com
Official FreeSWITCH Siteshttp://www.freeswitch.orghttp://wiki.freeswitch.orghttp://www.cluecon.com
FreeSWITCH-users mailing listFreeSWITCH-users@lists.freeswitch.orghttp://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-usershttp://www.frees...
_________________________________________________________________________ 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
-- 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@conference.freeswitch.org ☎ +19193869900
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@gmail.com <mailto: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 <http://www.uniboxapp.com/t/sig>
On Jun 13, 2014, at 12:01 AM, Victor Chukalovskiy <victor.chukalovskiy@gmail.com <mailto: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> <mailto: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:vGriffins@88.208.219.118> <mailto:sofia <mailto:sofia>/Profile_250.218/vGriffins@88.208.219.118 <mailto: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> <mailto: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> <mailto: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 <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://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@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 <tel: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 <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://www.freeswitch.org
_________________________________________________________________________ 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://www.freeswitch.org
_________________________________________________________________________ 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://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@conference.freeswitch.org <mailto:sip%3A888@conference.freeswitch.org> ? +19193869900
_________________________________________________________________________ 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
On Thu, Jun 12, 2014 at 11:25 PM, Anthony Minessale < anthony.minessale@gmail.com> wrote:
Core PGSQL support is alpha and should not be used in production
I find this slightly irritating, https://wiki.freeswitch.org/wiki/PostgreSQL_in_the_core does not state that it shouldn't be used or is alpha or anything like that at all.
On Fri, 13 Jun 2014, Markus Lindenberg wrote:
On Thu, Jun 12, 2014 at 11:25 PM, Anthony Minessale <anthony.minessale@gmail.com> wrote: Core PGSQL support is alpha and should not be used in production
I find this slightly irritating, https://wiki.freeswitch.org/wiki/PostgreSQL_in_the_core does not state that it shouldn't be used or is alpha or anything like that at all.
Agreed. I tried to update the page but is is locked because of migration to Confluence. Used my Jira login for that but was not permitted to make changes. Somebody is probably doing something fancy. Oh, well. If anywone else wants to do an update they can cut'n'paste this: '''WARNING:''' The current implementation should be considered ALPHA quality and not used in production setups! In June 2014 Brian West [https://jira.freeswitch.org/browse/FS-6582] comments "I vote for the complete removal of CORE PGSQL Support as its incomplete and has bugs." and Anthony Minessale [http://lists.freeswitch.org/pipermail/freeswitch-users/2014-June/105945.html] says on the mailing list that "Core PGSQL support is alpha and should not be used in production". Kind Regards, Claus Andersen
participants (6)
-
Anthony Minessale
-
Claus Andersen
-
Ken Rice
-
Markus Lindenberg
-
Muhammad Naseer Bhatti
-
Victor Chukalovskiy