<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<div class="moz-cite-prefix">Greetings.<br>
<br>
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):<br>
<br>
-at first it works like a charm and able to do 200-400 CPS of LCR
queries<br>
-after a period of time (from a minute to a few hours depending on
the load) it drops to marginal 45 CPS.<br>
-calls keep piling-up to whatever limit I set in my sipp<br>
<br>
After that nothing brings FS back to desired 200-400 queries, it
stays at ~45 CPS no matter what:<br>
-restarting PostgreSQL does not help<br>
-restarting mod_lcr does not help<br>
-letting FS idle with 0 calls for a few minutes does not help<br>
<br>
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<br>
<br>
And here is a note from Brian on FS-6582:<br>
<br>
<blockquote type="cite">I vote for the complete removal of CORE
PGSQL Support as its incomplete and has bugs.
<br>
<br>
/b
</blockquote>
<br>
Does anyone have a similar experience or have confirmation of core
pg support being not reliable?<br>
<br>
Cheers,<br>
-Victor<br>
<pre class="moz-signature" cols="72">
</pre>
On 14-06-05 08:59 PM, Ken Rice wrote:<br>
</div>
<blockquote
cite="mid:B0F01F7B-5A5E-40F7-A094-32E5D180B5CA@freeswitch.org"
type="cite">
<meta http-equiv="content-type" content="text/html;
charset=ISO-8859-1">
<div>you'll probably want to open a jira on this and make sure you
include all the good logging..<br>
<br>
<div>Ken</div>
Sent from my iPad</div>
<div><br>
On Jun 5, 2014, at 17:49, Muhammad Naseer Bhatti <<a
moz-do-not-send="true" href="mailto:nbhatti@gmail.com">nbhatti@gmail.com</a>>
wrote:<br>
<br>
</div>
<blockquote type="cite">
<div>
<title></title>
<div>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
</div>
<div><br>
</div>
<div>for mod_db
</div>
<div><param name=“odbc-dsn”
value="pgsql://hostaddr=remote_host port=15432
dbname=freeswitch user=freeswitch password=freeswitch
options='-c client_min_messages=NOTICE'" />
</div>
<div>and with switch.conf
</div>
<div><param name=“core-db-dsn”
value=“pgsql://hostaddr=remote_host port=15432
dbname=freeswitch user=freeswitch password=freeswitch
options=‘-c client_min_messages=NOTICE’” /><br>
</div>
<div><br>
</div>
<div>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?
</div>
<div><br>
</div>
<div>
<p style="margin: 0px; font-size: 10px; line-height: normal;
font-family: Monaco; color: rgb(245, 245, 245);
background-color: rgb(0, 0, 0);">freeswitch@internal>
show calls count
</p>
<p style="margin: 0px; font-size: 10px; line-height: normal;
font-family: Monaco; color: rgb(245, 245, 245);
background-color: rgb(0, 0, 0); min-height: 14px;"><br>
</p>
<p style="margin: 0px; font-size: 10px; line-height: normal;
font-family: Monaco; color: rgb(245, 245, 245);
background-color: rgb(0, 0, 0);">7260 total.
</p>
<p style="margin: 0px; font-size: 10px; line-height: normal;
font-family: Monaco; color: rgb(245, 245, 245);
background-color: rgb(0, 0, 0); min-height: 14px;"><br>
</p>
<p style="margin: 0px; font-size: 10px; line-height: normal;
font-family: Monaco; color: rgb(245, 245, 245);
background-color: rgb(0, 0, 0);">freeswitch@internal>
status
</p>
<p style="margin: 0px; font-size: 10px; line-height: normal;
font-family: Monaco; color: rgb(245, 245, 245);
background-color: rgb(0, 0, 0);">UP 0 years, 0 days, 0
hours, 24 minutes, 54 seconds, 940 milliseconds, 636
microseconds
</p>
<p style="margin: 0px; font-size: 10px; line-height: normal;
font-family: Monaco; color: rgb(245, 245, 245);
background-color: rgb(0, 0, 0);">FreeSWITCH (Version 1.4.6
git 9479729 2014-06-03 19:35:16Z 64bit) is ready
</p>
<p style="margin: 0px; font-size: 10px; line-height: normal;
font-family: Monaco; color: rgb(245, 245, 245);
background-color: rgb(0, 0, 0);">12884 session(s) since
startup
</p>
<p style="margin: 0px; font-size: 10px; line-height: normal;
font-family: Monaco; color: rgb(245, 245, 245);
background-color: rgb(0, 0, 0);">0 session(s) - peak
10000, last 5min 0
</p>
<p style="margin: 0px; font-size: 10px; line-height: normal;
font-family: Monaco; color: rgb(245, 245, 245);
background-color: rgb(0, 0, 0);">0 session(s) per Sec out
of max 500, peak 89, last 5min 0
</p>
<p style="margin: 0px; font-size: 10px; line-height: normal;
font-family: Monaco; color: rgb(245, 245, 245);
background-color: rgb(0, 0, 0);">10000 session(s) max
</p>
<p style="margin: 0px; font-size: 10px; line-height: normal;
font-family: Monaco; color: rgb(245, 245, 245);
background-color: rgb(0, 0, 0);">min idle cpu 0.00/99.83
</p>
<p style="margin: 0px; font-size: 10px; line-height: normal;
font-family: Monaco; color: rgb(245, 245, 245);
background-color: rgb(0, 0, 0);">Current Stack Size/Max
240K/8192K
</p>
</div>
<div><br>
</div>
<div>show channels shows
</div>
<div><br>
</div>
<div>
<p style="margin: 0px; font-size: 10px; line-height: normal;
font-family: Monaco; color: rgb(245, 245, 245);
background-color: rgb(0, 0, 0);">0d01315c-ed00-11e3-a7c7-dfbcc3672627,inbound,2014-06-05
18:23:42,1402007022,<a moz-do-not-send="true"
href="mailto:sofia/Profile_250.218/vGriffins@88.208.219.118">sofia/Profile_250.218/vGriffins@88.208.219.118</a>:5050,CS_EXECUTE,vGriffins,123456789,88.208.219.118,4414732506,,,RINGING,,,,,vBilling,,,,,,,,,,,,,,,,,,,,,
</p>
</div>
<div><br>
</div>
<div>But when I try to kill that uuid,
</div>
<div><br>
</div>
<div>
<p style="margin: 0px; font-size: 10px; line-height: normal;
font-family: Monaco; color: rgb(245, 245, 245);
background-color: rgb(0, 0, 0);">freeswitch@internal>
uuid_kill 0d01315c-ed00-11e3-a7c7-dfbcc3672627
</p>
<p style="margin: 0px; font-size: 10px; line-height: normal;
font-family: Monaco; color: rgb(245, 245, 245);
background-color: rgb(0, 0, 0);">-ERR No such channel!
</p>
</div>
<div><br>
</div>
<div>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?
</div>
<div><br>
</div>
<div>Thanks.
</div>
<div><br>
</div>
<div class="unibox-signature">Sent with <a
moz-do-not-send="true"
href="http://www.uniboxapp.com/t/sig">Unibox</a>
</div>
</div>
</blockquote>
<blockquote type="cite">
<div><span>_________________________________________________________________________</span><br>
<span>Professional FreeSWITCH Consulting Services:</span><br>
<span><a moz-do-not-send="true"
href="mailto:consulting@freeswitch.org">consulting@freeswitch.org</a></span><br>
<span><a moz-do-not-send="true"
href="http://www.freeswitchsolutions.com">http://www.freeswitchsolutions.com</a></span><br>
<span></span><br>
<span>FreeSWITCH-powered IP PBX: The CudaTel Communication
Server</span><br>
<span><a moz-do-not-send="true" href="http://www.cudatel.com">http://www.cudatel.com</a></span><br>
<span></span><br>
<span>Official FreeSWITCH Sites</span><br>
<span><a moz-do-not-send="true"
href="http://www.freeswitch.org">http://www.freeswitch.org</a></span><br>
<span><a moz-do-not-send="true"
href="http://wiki.freeswitch.org">http://wiki.freeswitch.org</a></span><br>
<span><a moz-do-not-send="true" href="http://www.cluecon.com">http://www.cluecon.com</a></span><br>
<span></span><br>
<span>FreeSWITCH-users mailing list</span><br>
<span><a moz-do-not-send="true"
href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a></span><br>
<span><a moz-do-not-send="true"
href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a></span><br>
<span>UNSUBSCRIBE:<a class="moz-txt-link-freetext" href="http://">http://</a><a moz-do-not-send="true"
href="http://lists.freeswitch.org/mailman/options/freeswitch-users">lists.freeswitch.org/mailman/options/freeswitch-users</a></span><br>
<span><a moz-do-not-send="true"
href="http://www.freeswitch.org">http://www.freeswitch.org</a></span><br>
</div>
</blockquote>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_________________________________________________________________________
Professional FreeSWITCH Consulting Services:
<a class="moz-txt-link-abbreviated" href="mailto:consulting@freeswitch.org">consulting@freeswitch.org</a>
<a class="moz-txt-link-freetext" href="http://www.freeswitchsolutions.com">http://www.freeswitchsolutions.com</a>
FreeSWITCH-powered IP PBX: The CudaTel Communication Server
<a class="moz-txt-link-freetext" href="http://www.cudatel.com">http://www.cudatel.com</a>
Official FreeSWITCH Sites
<a class="moz-txt-link-freetext" href="http://www.freeswitch.org">http://www.freeswitch.org</a>
<a class="moz-txt-link-freetext" href="http://wiki.freeswitch.org">http://wiki.freeswitch.org</a>
<a class="moz-txt-link-freetext" href="http://www.cluecon.com">http://www.cluecon.com</a>
FreeSWITCH-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a>
<a class="moz-txt-link-freetext" href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a>
UNSUBSCRIBE:<a class="moz-txt-link-freetext" href="http://lists.freeswitch.org/mailman/options/freeswitch-users">http://lists.freeswitch.org/mailman/options/freeswitch-users</a>
<a class="moz-txt-link-freetext" href="http://www.freeswitch.org">http://www.freeswitch.org</a>
</pre>
</blockquote>
<br>
</body>
</html>