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