[Freeswitch-users] Fw: SQL error on 'show calls count'

[Steven Ayre]

I suspect the core.db file was corrupted by an incomplete write when FS2
crashed. Delete the file and restart FS and it'll be recreated.

If you use ODBC and MySQL/PostgreSQL/etc then they'll recover from crashes
better.




On 28 August 2013 11:46, Georgi Stefanov <georgi_mei at abv.bg> wrote:

>  Hello all,
>
> I have just found something strange
>
> Please see the following
>
> freeswitch at internal> status
> UP 0 years, 0 days, 0 hours, 0 minutes, 20 seconds, 669 milliseconds, 247
> microseconds
> FreeSWITCH (Version 1.4.0 ) is ready
> 0 session(s) since startup
> 0 session(s) - 0 out of max 2200 per sec
> 3000 session(s) max
> min idle cpu 0.00/94.00
> Current Stack Size/Max 240K/8192K
>
> freeswitch at internal> version
> FreeSWITCH Version 1.4.0 ()
>
> freeswitch at internal> show calls count
>
> 0 total.
>
> 2013-08-28 13:40:28.554849 [ERR] switch_core_sqldb.c:1126 SQL ERR: [select
> count(*) from basic_calls where hostname='my-domain-name-as-example']
> database disk image is malformed
> freeswitch at internal>
>
>
> How this happened?
> 1.I have two freeswitches (same version 1.4.0 installed yesterday)
> 2.2000 calls from FS1-> FS2
> 3.FS3 just died
> 4.I have launched FS2 again (freeswitch -nc)
> 5.Open fs_cli
> 6.Execute the commands shown in listing above
>
> Is this bug?
> Am I missing something?
>
> p.s. Forgive me if this is not the right list to post this message
>
> _________________________________________________________________________
> Professional FreeSWITCH Consulting Services:
> consulting at freeswitch.org
> http://www.freeswitchsolutions.com
>
> 
> 
>
> Official FreeSWITCH Sites
> http://www.freeswitch.org
> http://wiki.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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20130828/78a13bac/attachment.html