[Freeswitch-users] database disk image is malformed

[Vallimamod Abdullah]

Hi,

This error message corresponds to sqlite3 SQLITE_CORRUPT error code. You may find this page interesting: https://www.sqlite.org/lockingv3.html#how_to_corrupt
You can alternatively try to put your core db in RAM disk: https://freeswitch.org/confluence/display/FREESWITCH/SSD+Tuning+for+Linux#SSDTuningforLinux-FreeSWITCH'score.dbI/Obottleneck 

-- 
Best Regards,
Vallimamod
.

> On 13 May 2016, at 17:34, Steven Schoch <schoch+freeswitch.org at xwin32.com> wrote:
> 
> I shut down freeswitch, removed core.db (and sofia_reg*.db), and restarted freeswitch.
> core.db was recreated, but I still get this message in the log file:
> 
> 2016-05-13 08:29:16.382469 [ERR] switch_core_sqldb.c:1197 SQL ERR: [select call_id,sip_user,sip_host,contact,status,rpid,expires,user_agent,server_user,server_host,profile_name,network_ip, network_port,0,sip_realm from sip_registrations where expires > 0 and expires <= 1463153356] database disk image is malformed
> 
> The messages immediately before that message were:
> FreeSWITCH Started
> Max Sessions [1000]
> Session Rate [30]
> SQL [Enabled]
> 2016-05-13 08:25:54.002477 [CONSOLE] mod_voicemail.c:4088 Event Thread Started
> 2016-05-13 08:26:10.282464 [WARNING] sofia.c:5912 Ping succeeded flowroute with code 200 - count 1/1/1, state UP
> 2016-05-13 08:26:10.422469 [WARNING] sofia.c:5912 Ping succeeded sip2sip with code 200 - count 1/1/1, state UP
> 
> -- 
> Steve