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

Georgi Stefanov georgi_mei at abv.bg
Wed Aug 28 14:46:05 MSD 2013


 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



Join us at ClueCon 2013 Aug 6-8, 2013
More information about the FreeSWITCH-users mailing list