[Freeswitch-users] sqldb and GREAT SCOTT! errors

Wed Oct 22 23:49:08 MSD 2014

I have the exact same version and I am not experiencing that problem.
That suggests that the issue is environmental and specific to something on
your machine.
Perhaps get some others to test the same thing and confirm.

On Wed, Oct 22, 2014 at 2:20 PM, Guillermo Ruiz Camauer <grcamauer at gmail.com
> wrote:

> Anthony,
>
> This is what I get:
>
> drwxrwxrwt 2 root root 60 Oct 22 13:28 /run/shm  which is very similar to
> yours.
>
> I have tried making a different tmpfs which I mount manually, to no
> avail.  Note that it creates the core.db file, so it can definitely write
> there.  The problem is that inserts and updates don't work:
>
> 2014-10-22 13:58:25.245897 [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-22 13:58:25.245908 [CRIT] sofia.c:2750 Cannot Open SQL Database
> [internal]!
> 2014-10-22 13:58:25.251979 [ERR] sofia.c:3292 Ignoring invalid name ''
> 2014-10-22 13:58:26.743056 [ERR] switch_core_sqldb.c:586 NATIVE SQL ERR
> [attempt to write a readonly database]
> delete from limit_data where hostname='FS2';
> 2014-10-22 13:58:27.250209 [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-22 13:58:27.250285 [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'
>
> Running database on HDD or running FS with -nosql eliminates this
> problem.  I think this started after I updated Debian from
>                    Linux freeswitch 3.2.0-4-amd64 #1 SMP Debian
> 3.2.60-1+deb7u3 x86_64 GNU/Linux
> to
>                    Linux FS2 3.2.0-4-amd64 #1 SMP Debian 3.2.63-2 x86_64
> GNU/Linux
>
> Guillermo
>
> On Wed, Oct 22, 2014 at 1:27 PM, Anthony Minessale <
> anthony.minessale at gmail.com> wrote:
>
>> I tried to do the same to see what happens and it works for me.
>>
>> what does ls -ld /run/shm say?
>>
>> for me it's
>>
>> drwxrwxrwt 2 root root 180 Oct 22 11:23 /run/shm
>>
>>
>>
>>
>>
>>
>> On Tue, Oct 21, 2014 at 6:29 PM, Guillermo Ruiz Camauer <
>> grcamauer at gmail.com> wrote:
>>
>>> OK, so when I run with -nosql or with <param name="core-db-name"
>>> value="/usr/local/freeswitch/db/core.db" />
>>> I don't get errors. As soon as I run with <param name="core-db-name"
>>> value="/dev/shm/core.db" /> I get the errors again.
>>>
>>> root at FS2:~# ls -la /dev/shm
>>> lrwxrwxrwx 1 root root 8 Oct 21 20:02 /dev/shm -> /run/shm
>>>
>>> and I can freely copy files to and from /dev/shm.
>>>
>>> FS is running as a service with user freeswitch/daemon or starting it by
>>> hand as root.  Either way produces the same error.
>>>
>>> Guillermo
>>>
>>>
>>> On Tue, Oct 21, 2014 at 7:55 PM, Anthony Minessale <
>>> anthony.minessale at gmail.com> wrote:
>>>
>>>> I already provided a suggestion.
>>>>
>>>> On Tue, Oct 21, 2014 at 5:47 PM, Guillermo Ruiz Camauer <
>>>> grcamauer at gmail.com> wrote:
>>>>
>>>>> If I run FS with -nosql  I don't get any errors.  What exaclty do I
>>>>> miss out on by doing this?
>>>>>
>>>>> Guillermo
>>>>>
>>>>> On Tue, Oct 21, 2014 at 7:46 PM, Guillermo Ruiz Camauer <
>>>>> grcamauer at gmail.com> wrote:
>>>>>
>>>>>> All I did was:
>>>>>>
>>>>>> <param name="core-db-name" value="/dev/shm/core.db" />
>>>>>>
>>>>>> I manually copied something to /deb/shm and no problem.
>>>>>>
>>>>>> Any thoughts?
>>>>>>
>>>>>>
>>>>>> Guillermo
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> On Tue, Oct 21, 2014 at 7:18 PM, Anthony Minessale <
>>>>>> anthony.minessale at gmail.com> wrote:
>>>>>>
>>>>>>> Maybe start over and use the real dir for db and trace your steps to
>>>>>>> moving it to memdisk.
>>>>>>> Maybe the memdisk is mounted read only.
>>>>>>>
>>>>>>>
>>>>>>> On Tue, Oct 21, 2014 at 5:12 PM, Guillermo Ruiz Camauer <
>>>>>>> grcamauer at gmail.com> wrote:
>>>>>>>
>>>>>>>> I forgot to mention that I stopped FS, deleted core.db and started
>>>>>>>> FS again, but the same errors result.
>>>>>>>>
>>>>>>>> Guillermo
>>>>>>>>
>>>>>>>> On Tue, Oct 21, 2014 at 6:58 PM, Anthony Minessale <
>>>>>>>> anthony.minessale at gmail.com> wrote:
>>>>>>>>
>>>>>>>>> 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
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> _________________________________________________________________________
>>>>>>>>> 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
>>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> --
>>>>>>>> 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
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> _________________________________________________________________________
>>>>>>> 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
>>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> --
>>>>>> Guillermo Ruiz Camauer
>>>>>>
>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> 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
>>>>
>>>>
>>>>
>>>> _________________________________________________________________________
>>>> 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
>>>>
>>>
>>>
>>>
>>> --
>>> 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
>>
>>
>> _________________________________________________________________________
>> 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
>>
>
>
>
> --
> 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/20141022/39a50522/attachment-0001.html 