[Freeswitch-users] sqldb and GREAT SCOTT! errors

[Guillermo Ruiz Camauer]

I am getting these errors in my FS log:

2014-10-21 18:15:29.297837 [ERR] switch_core_sqldb.c:586 NATIVE SQL ERR
[attempt to write a readonly database]
delete from sip_registrations where sub_host is null and hostname='FS2' and
network_ip like '%' and network_port like '%' and sip_username like '%' and
mwi_user  like '%' and mwi_host like '%' and orig_server_host like '%' and
orig_hostname like '%';delete from sip_registrations where sub_host is null
and hostname='FS2' and network_ip like '%' and network_port like '%' and
sip_username like '%' and mwi_user  like '%' and mwi_host like '%' and
orig_server_host like '%' and orig_hostname like '%'
2014-10-21 18:15:29.297859 [CRIT] sofia_glue.c:2216 GREAT SCOTT!!! Cannot
execute batched statements! [attempt to write a readonly database]
If you are using mysql, make sure you are using MYODBC 3.51.18 or higher
and enable FLAG_MULTI_STATEMENTS
2014-10-21 18:15:29.297876 [CRIT] sofia.c:2750 Cannot Open SQL Database
[crossfonetrunk]!
2014-10-21 18:15:29.301425 [ERR] switch_core_sqldb.c:586 NATIVE SQL ERR
[attempt to write a readonly database]
delete from sip_registrations where sub_host is null and hostname='FS2' and
network_ip like '%' and network_port like '%' and sip_username like '%' and
mwi_user  like '%' and mwi_host like '%' and orig_server_host like '%' and
orig_hostname like '%';delete from sip_registrations where sub_host is null
and hostname='FS2' and network_ip like '%' and network_port like '%' and
sip_username like '%' and mwi_user  like '%' and mwi_host like '%' and
orig_server_host like '%' and orig_hostname like '%'
2014-10-21 18:15:29.301449 [CRIT] sofia_glue.c:2216 GREAT SCOTT!!! Cannot
execute batched statements! [attempt to write a readonly database]
If you are using mysql, make sure you are using MYODBC 3.51.18 or higher
and enable FLAG_MULTI_STATEMENTS
2014-10-21 18:15:29.301465 [CRIT] sofia.c:2750 Cannot Open SQL Database
[external]!
2014-10-21 18:15:29.302165 [ERR] switch_core_sqldb.c:586 NATIVE SQL ERR
[attempt to write a readonly database]
delete from sip_registrations where sub_host is null and hostname='FS2' and
network_ip like '%' and network_port like '%' and sip_username like '%' and
mwi_user  like '%' and mwi_host like '%' and orig_server_host like '%' and
orig_hostname like '%';delete from sip_registrations where sub_host is null
and hostname='FS2' and network_ip like '%' and network_port like '%' and
sip_username like '%' and mwi_user  like '%' and mwi_host like '%' and
orig_server_host like '%' and orig_hostname like '%'
2014-10-21 18:15:29.302190 [CRIT] sofia_glue.c:2216 GREAT SCOTT!!! Cannot
execute batched statements! [attempt to write a readonly database]
If you are using mysql, make sure you are using MYODBC 3.51.18 or higher
and enable FLAG_MULTI_STATEMENTS
2014-10-21 18:15:29.302202 [CRIT] sofia.c:2750 Cannot Open SQL Database
[internal]!
2014-10-21 18:15:29.308285 [ERR] sofia.c:3292 Ignoring invalid name ''
2014-10-21 18:15:30.799151 [ERR] switch_core_sqldb.c:586 NATIVE SQL ERR
[attempt to write a readonly database]
delete from limit_data where hostname='FS2';
2014-10-21 18:15:31.306387 [ERR] switch_core_sqldb.c:586 NATIVE SQL ERR
[attempt to write a readonly database]
update fifo_outbound set
start_time=0,stop_time=0,ring_count=0,use_count=0,outbound_call_count=0,outbound_fail_count=0
where static=0
2014-10-21 18:15:31.306466 [ERR] switch_core_sqldb.c:586 NATIVE SQL ERR
[attempt to write a readonly database]
delete from fifo_outbound where static=1 and hostname='FS2'


My core.db file is in a ramdisk (/dev/~shm) and has all the right
permissions.  I did a  'make clean modwipe' followed by a 'make current'
and I still get the same errors.  I am on STABLE.

How can I get my FS working again?

-- 
Guillermo Ruiz Camauer
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20141021/eb96d8e2/attachment.html