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