[Freeswitch-users] Error on SQL - data malformed

[Ítalo Rossi]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20150507/0b1d4ac9/attachment-0001.html