Dear Sir, I'm using mod_odbc_query and mod_nibble_billing for my calling card solutoin. i found mod_odbc_query cant work with high load (200 calls concurrent) i got error [STATE: 53200 CODE 7 ERROR: [unixODBC]ERROR: out of shared memory; Error while executing the query ] in FS console How to fix it ? BG Dome C.
Hi Dome, Have you tried increasing global_heartbeat to reduce the frequency of odbc calls? What is it currently set to? Rob On Oct 20, 2009, at 8:31 AM, Dome Charoenyost wrote:
Dear Sir, I'm using mod_odbc_query and mod_nibble_billing for my calling card solutoin. i found mod_odbc_query cant work with high load (200 calls concurrent) i got error [STATE: 53200 CODE 7 ERROR: [unixODBC]ERROR: out of shared memory; Error while executing the query ] in FS console
How to fix it ?
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
2009/10/20 Rob Forman <rob4manhere@gmail.com>:
Hi Dome,
Have you tried increasing global_heartbeat to reduce the frequency of odbc calls? What is it currently set to?
Now 1 min
Rob
On Oct 20, 2009, at 8:31 AM, Dome Charoenyost wrote:
Dear Sir, I'm using mod_odbc_query and mod_nibble_billing for my calling card solutoin. i found mod_odbc_query cant work with high load (200 calls concurrent) i got error [STATE: 53200 CODE 7 ERROR: [unixODBC]ERROR: out of shared memory; Error while executing the query ] in FS console
How to fix it ?
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
_______________________________________________ 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
Try 300 seconds (5 minutes) and see if it improves. On Oct 20, 2009, at 9:00 AM, Dome Charoenyost wrote:
2009/10/20 Rob Forman <rob4manhere@gmail.com>:
Hi Dome,
Have you tried increasing global_heartbeat to reduce the frequency of odbc calls? What is it currently set to?
Now 1 min
Rob
On Oct 20, 2009, at 8:31 AM, Dome Charoenyost wrote:
Dear Sir, I'm using mod_odbc_query and mod_nibble_billing for my calling card solutoin. i found mod_odbc_query cant work with high load (200 calls concurrent) i got error [STATE: 53200 CODE 7 ERROR: [unixODBC]ERROR: out of shared memory; Error while executing the query ] in FS console
How to fix it ?
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
_______________________________________________ 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
_______________________________________________ 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
2009/10/20 Rob Forman <rob4manhere@gmail.com>:
Try 300 seconds (5 minutes) and see if it improves. Ok. i'll try
On Oct 20, 2009, at 9:00 AM, Dome Charoenyost wrote:
2009/10/20 Rob Forman <rob4manhere@gmail.com>:
Hi Dome,
Have you tried increasing global_heartbeat to reduce the frequency of odbc calls? What is it currently set to?
Now 1 min
Rob
On Oct 20, 2009, at 8:31 AM, Dome Charoenyost wrote:
Dear Sir, I'm using mod_odbc_query and mod_nibble_billing for my calling card solutoin. i found mod_odbc_query cant work with high load (200 calls concurrent) i got error [STATE: 53200 CODE 7 ERROR: [unixODBC]ERROR: out of shared memory; Error while executing the query ] in FS console
How to fix it ?
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
_______________________________________________ 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
_______________________________________________ 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
_______________________________________________ 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
Hi, I haven't run into that problem yet, but did you try increasing the maximum shared memory in /proc/sys/kernel/shmmax (sysctl kernel.shmmax) ? regards, Leon On Oct 20, 2009, at 3:31 PM, Dome Charoenyost wrote:
Dear Sir, I'm using mod_odbc_query and mod_nibble_billing for my calling card solutoin. i found mod_odbc_query cant work with high load (200 calls concurrent) i got error [STATE: 53200 CODE 7 ERROR: [unixODBC]ERROR: out of shared memory; Error while executing the query ] in FS console
How to fix it ?
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
2009/10/20 Leon de Rooij <leon@scarlet-internet.nl>:
Hi,
I haven't run into that problem yet, but did you try increasing the maximum shared memory in /proc/sys/kernel/shmmax (sysctl kernel.shmmax) ? Recommend me please i have 4GB RAM. is posible to increase to 50% RAM ?
Dome C.
regards,
Leon
On Oct 20, 2009, at 3:31 PM, Dome Charoenyost wrote:
Dear Sir, I'm using mod_odbc_query and mod_nibble_billing for my calling card solutoin. i found mod_odbc_query cant work with high load (200 calls concurrent) i got error [STATE: 53200 CODE 7 ERROR: [unixODBC]ERROR: out of shared memory; Error while executing the query ] in FS console
How to fix it ?
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
_______________________________________________ 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
You could, but I would try just doubling whatever it is to see if thats improves the issue first. The default is 32MB. You could double it to 64MB and test again. What is it currently set to (run: sysctl kernel.shmmax)? You can change it on the fly with sysctl. Once you're done testing and want it to persist across reboots, you'll want to set in /etc/sysctl.conf . Cheers, Rob On Oct 20, 2009, at 9:35 AM, Dome Charoenyost wrote:
2009/10/20 Leon de Rooij <leon@scarlet-internet.nl>:
Hi,
I haven't run into that problem yet, but did you try increasing the maximum shared memory in /proc/sys/kernel/shmmax (sysctl kernel.shmmax) ? Recommend me please i have 4GB RAM. is posible to increase to 50% RAM ?
Dome C.
regards,
Leon
On Oct 20, 2009, at 3:31 PM, Dome Charoenyost wrote:
Dear Sir, I'm using mod_odbc_query and mod_nibble_billing for my calling card solutoin. i found mod_odbc_query cant work with high load (200 calls concurrent) i got error [STATE: 53200 CODE 7 ERROR: [unixODBC]ERROR: out of shared memory; Error while executing the query ] in FS console
How to fix it ?
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
_______________________________________________ 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
_______________________________________________ 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
2009/10/20 Rob Forman <rob4manhere@gmail.com>:
You could, but I would try just doubling whatever it is to see if thats improves the issue first. The default is 32MB. You could double it to 64MB and test again. Ok' let's me try 64MB first i found some information https://www.ishoof.org/project/wiki/index.php/ORACLE_11_G_-_Gentoo_Installat...
What is it currently set to (run: sysctl kernel.shmmax)? You can change it on the fly with sysctl. Once you're done testing and want it to persist across reboots, you'll want to set in /etc/sysctl.conf .
Cheers, Rob
On Oct 20, 2009, at 9:35 AM, Dome Charoenyost wrote:
2009/10/20 Leon de Rooij <leon@scarlet-internet.nl>:
Hi,
I haven't run into that problem yet, but did you try increasing the maximum shared memory in /proc/sys/kernel/shmmax (sysctl kernel.shmmax) ? Recommend me please i have 4GB RAM. is posible to increase to 50% RAM ?
Dome C.
regards,
Leon
On Oct 20, 2009, at 3:31 PM, Dome Charoenyost wrote:
Dear Sir, I'm using mod_odbc_query and mod_nibble_billing for my calling card solutoin. i found mod_odbc_query cant work with high load (200 calls concurrent) i got error [STATE: 53200 CODE 7 ERROR: [unixODBC]ERROR: out of shared memory; Error while executing the query ] in FS console
How to fix it ?
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
_______________________________________________ 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
_______________________________________________ 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
_______________________________________________ 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
Those are recommended values for Oracle. Freeswitch != Oracle. They behave and use a server's resources very differently. I wouldn't change more than you need for now. Tweak shmmax then go from there. Cheers, Rob On Oct 20, 2009, at 10:14 AM, Dome Charoenyost wrote:
2009/10/20 Rob Forman <rob4manhere@gmail.com>:
You could, but I would try just doubling whatever it is to see if thats improves the issue first. The default is 32MB. You could double it to 64MB and test again. Ok' let's me try 64MB first i found some information https://www.ishoof.org/project/wiki/index.php/ORACLE_11_G_-_Gentoo_Installat...
What is it currently set to (run: sysctl kernel.shmmax)? You can change it on the fly with sysctl. Once you're done testing and want it to persist across reboots, you'll want to set in /etc/ sysctl.conf .
Cheers, Rob
On Oct 20, 2009, at 9:35 AM, Dome Charoenyost wrote:
2009/10/20 Leon de Rooij <leon@scarlet-internet.nl>:
Hi,
I haven't run into that problem yet, but did you try increasing the maximum shared memory in /proc/sys/kernel/shmmax (sysctl kernel.shmmax) ? Recommend me please i have 4GB RAM. is posible to increase to 50% RAM ?
Dome C.
regards,
Leon
On Oct 20, 2009, at 3:31 PM, Dome Charoenyost wrote:
Dear Sir, I'm using mod_odbc_query and mod_nibble_billing for my calling card solutoin. i found mod_odbc_query cant work with high load (200 calls concurrent) i got error [STATE: 53200 CODE 7 ERROR: [unixODBC]ERROR: out of shared memory; Error while executing the query ] in FS console
How to fix it ?
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
_______________________________________________ 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
_______________________________________________ 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
_______________________________________________ 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
_______________________________________________ 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
Now i'm setting to 64MB I found channel problem also. many channel not disconnect freeswitch@internal> show calls count 87 total. freeswitch@internal> show channels count 466 total. freeswitch@internal> status UP 0 years, 0 days, 1 hour, 53 minutes, 23 seconds, 872 milliseconds, 0 microseconds 11641 session(s) since startup 154 session(s) 0/30 1000 session(s) max I think channels should be 154 (same session) but 466 is to high. may be some channels not disconnect Dome C. 2009/10/20 Rob Forman <rob4manhere@gmail.com>:
Those are recommended values for Oracle. Freeswitch != Oracle. They behave and use a server's resources very differently.
I wouldn't change more than you need for now. Tweak shmmax then go from there.
Cheers, Rob
On Oct 20, 2009, at 10:14 AM, Dome Charoenyost wrote:
2009/10/20 Rob Forman <rob4manhere@gmail.com>:
You could, but I would try just doubling whatever it is to see if thats improves the issue first. The default is 32MB. You could double it to 64MB and test again. Ok' let's me try 64MB first i found some information https://www.ishoof.org/project/wiki/index.php/ORACLE_11_G_-_Gentoo_Installat...
What is it currently set to (run: sysctl kernel.shmmax)? You can change it on the fly with sysctl. Once you're done testing and want it to persist across reboots, you'll want to set in /etc/ sysctl.conf .
Cheers, Rob
On Oct 20, 2009, at 9:35 AM, Dome Charoenyost wrote:
2009/10/20 Leon de Rooij <leon@scarlet-internet.nl>:
Hi,
I haven't run into that problem yet, but did you try increasing the maximum shared memory in /proc/sys/kernel/shmmax (sysctl kernel.shmmax) ? Recommend me please i have 4GB RAM. is posible to increase to 50% RAM ?
Dome C.
regards,
Leon
On Oct 20, 2009, at 3:31 PM, Dome Charoenyost wrote:
Dear Sir, I'm using mod_odbc_query and mod_nibble_billing for my calling card solutoin. i found mod_odbc_query cant work with high load (200 calls concurrent) i got error [STATE: 53200 CODE 7 ERROR: [unixODBC]ERROR: out of shared memory; Error while executing the query ] in FS console
How to fix it ?
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
_______________________________________________ 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
_______________________________________________ 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
_______________________________________________ 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
_______________________________________________ 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
_______________________________________________ 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 (3)
-
Dome Charoenyost
-
Leon de Rooij
-
Rob Forman