[Freeswitch-users] Can't access voicemail because DB is locked

[Steven Schoch]

One of my users, whose phone has BLF lines, is having trouble accessing
voicemail.  The logs say the core database is locked.  It is not clear if
that is what is causing the inability to access voicemail.  Any ideas?

2013-04-11 11:14:31.962286 [ERR] switch_core_sqldb.c:579 NATIVE SQL ERR
[database is locked]
insert into sip_subscriptions
(proto,sip_user,sip_host,sub_to_user,sub_to_host,presence_hosts,event,contact,call_id,full_from,full_via,expires,user_agent,accept,profile_name,hostname,network_port,network_ip,version,orig_proto,
full_to) values
('sip','519','xxx.com','519','xxx.com','xxx.com,192.168.4.1','line-seize','"519"
<sip:519 at 192.168.4.235>','540bafdc-5146c237-f2c1bfea at 192.168.4.235','"519" <
sip:519 at xxx.com>;tag=AB12B2E0-A28C235B','SIP/2.0/UDP
192.168.4.235;branch=z9hG4bK3073a02e92D29019',1365704072,'PolycomSoundPointIP-SPIP_320-UA/
3.3.5.0247','','phone','pbx.xxx.com','5060','192.168.4.235',-1,'','<
sip:519 at xxx.com>;tag=GvUHrcCb8WWl')
2013-04-11 11:14:32.222286 [ERR] switch_core_sqldb.c:579 NATIVE SQL ERR
[database is locked]
BEGIN EXCLUSIVE
2013-04-11 11:14:32.222286 [CRIT] switch_core_sqldb.c:1679 ERROR [database
is locked]
2013-04-11 11:14:32.222286 [ERR] switch_core_sqldb.c:579 NATIVE SQL ERR
[cannot commit - no transaction is active]
COMMIT
2013-04-11 11:15:02.102979 [ERR] switch_core_sqldb.c:579 NATIVE SQL ERR
[database is locked]
insert into sip_dialogs
(sip_from_user,sip_from_host,call_info,call_info_state,hostname,expires,rcd,profile_name)
values ('519','xxx.com','appearance-index=1','seized','pbx.xxx.com
',1365704101,1365704071,'phone')
2013-04-11 11:15:02.502977 [ERR] switch_core_sqldb.c:579 NATIVE SQL ERR
[database is locked]
BEGIN EXCLUSIVE
2013-04-11 11:15:02.502977 [CRIT] switch_core_sqldb.c:1679 ERROR [database
is locked]
2013-04-11 11:15:02.502977 [ERR] switch_core_sqldb.c:579 NATIVE SQL ERR
[cannot commit - no transaction is active]
COMMIT
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20130411/d16bbe53/attachment.html