ODBC connection in 1.0.5 (trunk 16912) Problem.
Dear All, I found big odbc problem when i try to move to FS 1.0.5. in same server i'm testing 1.0.4 and 1.0.5 and same config 1. config limit.conf.xml use odbc (i use postgresql) <param name="odbc-dsn" value="tuxza:admin:xxx"/> 2. create dialplan in context public for test limit <condition field="destination_number" expression="^(1111)$"> <action application="limit" data="$${domain} 0838833133 500"/> <action application="answer"/> <action application="sleep" data="60000"/> </condition> 3. use sipp generate test call sipp -rtp_echo -sn uac -r 30 -l 500 -d 30000 -s 1111 -mp 25000 xx.xx.xx.xx:5080 1.0.4 work fine i found 2 connection in postgresql server but 1.0.5 use 1 connection for 1 calls. and get error when call over 100 calls. (postgresql maximum client connect is 100 ) So i'm not sure its' BUG or not ? BG Dome C.
hmm.. at some point postgres is falling behind and rather than waiting, we're opening another connection. <ponder/> can you open a jira on this? we probably need to implement connection limits in the core db connection thingie. On Fri, Mar 5, 2010 at 11:14 AM, Dome Charoenyost <dome@tel.co.th> wrote:
Dear All, I found big odbc problem when i try to move to FS 1.0.5. in same server i'm testing 1.0.4 and 1.0.5 and same config 1. config limit.conf.xml use odbc (i use postgresql) <param name="odbc-dsn" value="tuxza:admin:xxx"/> 2. create dialplan in context public for test limit <condition field="destination_number" expression="^(1111)$"> <action application="limit" data="$${domain} 0838833133 500"/> <action application="answer"/> <action application="sleep" data="60000"/> </condition> 3. use sipp generate test call sipp -rtp_echo -sn uac -r 30 -l 500 -d 30000 -s 1111 -mp 25000 xx.xx.xx.xx:5080
1.0.4 work fine i found 2 connection in postgresql server but 1.0.5 use 1 connection for 1 calls. and get error when call over 100 calls. (postgresql maximum client connect is 100 )
So i'm not sure its' BUG or not ?
BG
Dome C.
_______________________________________________ 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
-- -Rupa
Now i use mod_limit from 1.0.4 and fix some code for work in 1.0.5 I'll open JIRA for this case. Dome C. 2010/3/6 Rupa Schomaker <rupa@rupa.com>:
hmm.. at some point postgres is falling behind and rather than waiting, we're opening another connection. <ponder/> can you open a jira on this? we probably need to implement connection limits in the core db connection thingie.
On Fri, Mar 5, 2010 at 11:14 AM, Dome Charoenyost <dome@tel.co.th> wrote:
Dear All, I found big odbc problem when i try to move to FS 1.0.5. in same server i'm testing 1.0.4 and 1.0.5 and same config 1. config limit.conf.xml use odbc (i use postgresql) <param name="odbc-dsn" value="tuxza:admin:xxx"/> 2. create dialplan in context public for test limit <condition field="destination_number" expression="^(1111)$"> <action application="limit" data="$${domain} 0838833133 500"/> <action application="answer"/> <action application="sleep" data="60000"/> </condition> 3. use sipp generate test call sipp -rtp_echo -sn uac -r 30 -l 500 -d 30000 -s 1111 -mp 25000 xx.xx.xx.xx:5080
1.0.4 work fine i found 2 connection in postgresql server but 1.0.5 use 1 connection for 1 calls. and get error when call over 100 calls. (postgresql maximum client connect is 100 )
So i'm not sure its' BUG or not ?
BG
Dome C.
_______________________________________________ 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
-- -Rupa
_______________________________________________ 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
participants (2)
-
Dome Charoenyost
-
Rupa Schomaker