[Freeswitch-users] sqldb and GREAT SCOTT! errors
Guillermo Ruiz Camauer
grcamauer at gmail.com
Thu Oct 23 02:22:03 MSD 2014
I had performed a make clean modwipe followed by make current and
everything remained the same.
Started from scratch with ./bootstrap and ./configure and problem has gone
away.
Thanks for all the help.
Guillermo
On Wed, Oct 22, 2014 at 4: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
>
--
Guillermo Ruiz Camauer
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20141022/face983f/attachment-0001.html
Join us at ClueCon 2016 Aug 8-12, 2016
More information about the FreeSWITCH-users
mailing list