[Freeswitch-users] Error on SQL - data malformed

[Victor Medina]

Italo!

Thanks for the replay.

I just deleted the db/ files.It was just a test. A vm. No power failures.
Running on vmware.

2015-05-07 10:22 GMT-04:30 Ítalo Rossi <italorossib at gmail.com>:

> Your core.db is corrupt, it could be caused by a power failure.
>
> To solve this you can try to repair the database (search for sqlite repair
> malformed) or you can just remove the old db and let FreeSWITCH recreate a
> new one for you.
>
> rm /usr/local/freeswitch/db/core.db
>
> On Thu, May 7, 2015 at 10:18 AM, Victor Medina <victor.medina at cibersys.com
> > wrote:
>
>> Hi guys!
>>
>> Im testing Master from yesterday. Im seeing this on the console
>>
>> freeswitch at srv-ovh-devel-in-000001> show registrations
>> 2015-05-07 13:16:03.047907 [ERR] switch_core_db.c:108 SQL ERR [database
>> disk image is malformed]
>> 2015-05-07 13:16:03.047907 [ERR] switch_core_db.c:223 SQL ERR [database
>> disk image is malformed]
>> 2015-05-07 13:16:03.047907 [CRIT] switch_core_sqldb.c:508 Failure to
>> connect to CORE_DB core!
>> 2015-05-07 13:16:03.047907 [ERR] switch_console.c:256 Database Error
>> 2015-05-07 13:16:03.047907 [ERR] switch_core_db.c:108 SQL ERR [database
>> disk image is malformed]
>> 2015-05-07 13:16:03.047907 [ERR] switch_core_db.c:223 SQL ERR [database
>> disk image is malformed]
>>
>> -ERR Database error!
>>
>> 2015-05-07 13:16:03.047907 [CRIT] switch_core_sqldb.c:508 Failure to
>> connect to CORE_DB core!
>> freeswitch at srv-ovh-devel-in-000001>
>> freeswitch at srv-ovh-devel-in-000001> show registrations
>> 2015-05-07 13:16:18.047877 [ERR] switch_core_db.c:108 SQL ERR [database
>> disk image is malformed]
>> 2015-05-07 13:16:18.047877 [ERR] switch_core_db.c:223 SQL ERR [database
>> disk image is malformed]
>> 2015-05-07 13:16:18.047877 [CRIT] switch_core_sqldb.c:508 Failure to
>> connect to CORE_DB core!
>> 2015-05-07 13:16:18.047877 [ERR] switch_console.c:256 Database Error
>> 2015-05-07 13:16:18.047877 [ERR] switch_core_db.c:108 SQL ERR [database
>> disk image is malformed]
>> 2015-05-07 13:16:18.047877 [ERR] switch_core_db.c:223 SQL ERR [database
>> disk image is malformed]
>> 2015-05-07 13:16:18.047877 [CRIT] switch_core_sqldb.c:508 Failure to
>> connect to CORE_DB core!
>>
>> -ERR Database error!
>>
>>
>>
>>
>> --
>>
>>
>>
>> Víctor E. Medina M.
>> Platform Architect / Chief Infrastructure
>> +58424 291 4561
>> BB #79A8AFA2
>> @VMCibersys
>>
>>
>> _________________________________________________________________________
>> 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
>>
>
>
>
> --
> Ítalo Rossi
>
> _________________________________________________________________________
> 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
>



-- 



Víctor E. Medina M.
Platform Architect / Chief Infrastructure
+58424 291 4561
BB #79A8AFA2
@VMCibersys
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20150507/f350a800/attachment.html