[Freeswitch-users] [ERR] switch_core_sqldb.c:586 NATIVE SQL ERR [database or disk is full]

covici at ccs.covici.com covici at ccs.covici.com
Fri Jul 22 23:44:10 MSD 2016


You are probably losing disk space for some other reason fs probably has
nothing to do with the problem.  You have everything under the root
partition which is a bad idea indeed.

Sean Devoy <sdevoy at bizfocused.com> wrote:

> Thanks Ken.  The system is up and seems ok for now.  Sorry, but I definitely cannot afford even your single per-call-fee.  Your $8K fee represents about 4 years of income for our FS services.  It is really sort of a courtesy to some Cash Cow customers.
> 
> I had hopes the Wiki would help with DB clean up, but have not found anything.  As for disk cleanup, that is really just general Redhat support that is hardly worth your time to address.  Maybe some of the other low budget FS users out there can help me out.
> 
> Regards,
> Sean
> 
> From: freeswitch-users-bounces at lists.freeswitch.org [mailto:freeswitch-users-bounces at lists.freeswitch.org] On Behalf Of Ken Rice
> Sent: Friday, July 22, 2016 2:11 PM
> To: 'FreeSWITCH Users Help' <freeswitch-users at lists.freeswitch.org>
> Subject: Re: [Freeswitch-users] [ERR] switch_core_sqldb.c:586 NATIVE SQL ERR [database or disk is full]
> 
> Sean,
> 
> Drop us an email to consulting at freeswitch.org<mailto:consulting at freeswitch.org> we can get you back up and running pretty quick and diagnose the problem
> 
> From: freeswitch-users-bounces at lists.freeswitch.org<mailto:freeswitch-users-bounces at lists.freeswitch.org> [mailto:freeswitch-users-bounces at lists.freeswitch.org] On Behalf Of Sean Devoy
> Sent: Friday, July 22, 2016 1:06 PM
> To: FreeSWITCH Users Help <freeswitch-users at lists.freeswitch.org<mailto:freeswitch-users at lists.freeswitch.org>>
> Subject: [Freeswitch-users] [ERR] switch_core_sqldb.c:586 NATIVE SQL ERR [database or disk is full]
> 
> HI All,
> 
> Needless to say we are a non-Linux shop.  Today we got FreeSwitch phone problems and the log says "[ERR] switch_core_sqldb.c:586 NATIVE SQL ERR [database or disk is full]".  Obviously something is out of space.  How do we determine WHAT is out of space?  I do periodically delete old FS log files.  Other than that, this system DOES NOT EVER get changed.
> 
> The only information I have found on disk space usage is to use "df", which seems to show 100% usage regardless, I have removed several 100 MB of files with no change.
> 
> We do not use CDR data for our billing.
> How do I empty cdr_data and sofia reg DBs?
> 
> We are offering paypal reward to clean up and leave us a "maintenance plan" commensurate with effort involved.
> 
> df shows:
> Filesystem           1K-blocks      Used Available Use% Mounted on
> /dev/mapper/vg_root-lv_root
>                      145725896 144108556         0 100% /
> tmpfs                  1029260         0   1029260   0% /dev/shm
> 
> ls -l /usr/local/freeswitch/db  shows:
> total 210704
> -rw-r--r-- 1 root root     38912 Jul 22 13:57 call_limit.db
> -rw-r--r-- 1 root root  56908800 Jul 22 13:53 cdr_data.db
> -rw-r--r-- 1 root root    475136 Jul 22 13:58 core.db
> -rw-r--r-- 1 root root      5120 Jul 22 13:33 fifo.db
> -rw-r--r-- 1 root root 157506560 Jul 22 13:58 sofia_reg_external.db
> -rw-r--r-- 1 root root    189440 Jul 22 13:57 sofia_reg_external_noauth.db
> -rw-r--r-- 1 root root    362496 Jul 22 11:47 voicemail_default.db
> 
> Thanks in advance.
> Sean
> 
> ----------------------------------------------------
> Alternatives:
> 
> ----------------------------------------------------
> _________________________________________________________________________
> 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

-- 
Your life is like a penny.  You're going to lose it.  The question is:
How do
you spend it?

         John Covici
         covici at ccs.covici.com



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