[Freeswitch-users] SQL ERR [database is locked]

Klaus Hochlehnert Mailings at kh-dev.de
Tue Feb 28 20:18:04 MSK 2012


Hi all,

I've compiled FS on a server mid of December.
Since then it worked basically without problems (with some reboots in between for OS updates).
But today no calls could be made or received.

When checking the log I found this every 30 seconds:
...
2012-02-28 09:29:17.691556 [DEBUG] switch_core_state_machine.c:86 sofia/internal/10 at 192.168.1.22 Standard DESTROY
2012-02-28 09:29:17.691556 [DEBUG] switch_core_state_machine.c:504 (sofia/internal/10 at 192.168.1.22) State DESTROY going to sleep
2012-02-28 10:57:37.091612 [ERR] switch_core_sqldb.c:481 SQL ERR [database is locked]
COMMIT
2012-02-28 10:57:37.091612 [ERR] switch_core_sqldb.c:481 SQL ERR [cannot start a transaction within a transaction]
BEGIN
2012-02-28 10:58:06.951594 [ERR] switch_core_sqldb.c:481 SQL ERR [database is locked]
COMMIT
2012-02-28 10:58:06.951594 [ERR] switch_core_sqldb.c:481 SQL ERR [cannot start a transaction within a transaction]
...

After rebooting the server everything worked again.
Reproducing might not be so easy as it took several weeks to hit this problem (and it's a productive system).

Any idea what this might be?

Thanks
Klaus
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20120228/064c6b17/attachment.html 


Join us at ClueCon 2011 Aug 9-11, 2011
More information about the FreeSWITCH-users mailing list