[Freeswitch-users] sqldb and GREAT SCOTT! errors

[Anthony Minessale]

You might want to move them all out of the way and see if it creates new
ones that work or open them with sqlite3 util to ensure they work.


On Tue, Oct 21, 2014 at 4:43 PM, Guillermo Ruiz Camauer <grcamauer at gmail.com
> wrote:

> 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
>
> _________________________________________________________________________
> Professional FreeSWITCH Consulting Services:
> consulting at freeswitch.org
> http://www.freeswitchsolutions.com
>
> Official FreeSWITCH Sites
> http://www.freeswitch.org
> http://confluence.freeswitch.org
> http://www.cluecon.com
>
> 
> 
>
> FreeSWITCH-users mailing list
> FreeSWITCH-users at lists.freeswitch.org
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> http://www.freeswitch.org
>



-- 
Anthony Minessale II       ♬ @anthmfs  ♬ @FreeSWITCH  ♬

☞ http://freeswitch.org/  ☞ http://cluecon.com/  ☞
http://twitter.com/FreeSWITCH
☞ irc.freenode.net #freeswitch ☞ *http://freeswitch.org/g+
<http://freeswitch.org/g+>*

ClueCon Weekly Development Call
☎ sip:888 at conference.freeswitch.org  ☎ +19193869900
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20141021/299a67a3/attachment.html