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

Ken Rice krice at freeswitch.org
Fri Jul 22 22:10:53 MSD 2016



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] On Behalf Of Sean
Sent: Friday, July 22, 2016 1:06 PM
To: FreeSWITCH Users Help <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


                     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.


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20160722/620d8277/attachment.html 

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