[Freeswitch-users] Callcenter DB-Lock Problem(DELETE FROM members)

[Erkan Durmuş]

Hi,

When active calls increases(300 calls/min, cps:4-9) in the sytem we get 
errors like:
2013-03-30 19:29:40.913442 [ERR] switch_core_sqldb.c:579 NATIVE SQL ERR 
[database is locked]
DELETE FROM members WHERE system = 'single_box' AND uuid = 
'f8b239d0-995e-11e2-b825-b9a5cd559726' AND (abandoned_epoch = 
'1364664489' OR joined_epoch = '1364664395')

We are using local PostgreSQL instance over UnixODBC for callcenter and 
core db(not default sqllite)

Restarting DB does not resolve problem, same errors continues. Also no 
errors in postgre's log file.

During problem, although free agents available; no calls are routed to 
agents; all calls were waiting on the queue.
All calls seem to hang at queue(but ghost calls), only cleaned after 
clean FS restart.

At http://jira.freeswitch.org/browse/FS-3127 
<http://jira.freeswitch.org/browse/FS-3127>  says it is fixed.

FS VERSION: 1.2.7 Compiled from stable tar release
SYSTEM: CentOS release 6.3 x64
DB: Postgresql 9.2(on the same machine, only used by FreeSWITCH)
HARDWARE: Xen Virtual Machine; 4x Xeon E5530  @ 2.40GHz, 8GB Memory

Has anyone faced same problem? How can I resolve it?

Regards,
Erkan D.


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20130401/c64fc13e/attachment.html