VoIP Mailing List Archives

[dome at tel.co.th]

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

[rob4manhere at gmail.com]

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:

[dome at tel.co.th]

2009/10/20 Rob Forman <rob4manhere@gmail.com>:

[rob4manhere at gmail.com]

Try 300 seconds (5 minutes) and see if it improves.


On Oct 20, 2009, at 9:00 AM, Dome Charoenyost wrote:

[leon at scarlet-intern...]

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:

[dome at tel.co.th]

2009/10/20 Rob Forman <rob4manhere@gmail.com>:

[dome at tel.co.th]

2009/10/20 Leon de Rooij <leon@scarlet-internet.nl>:

[rob4manhere at 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.

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:

[dome at tel.co.th]

2009/10/20 Rob Forman <rob4manhere@gmail.com>:

[rob4manhere at 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:

[dome at tel.co.th]

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>: