[Freeswitch-users] [ERR] switch_core_sqldb.c:586 NATIVE SQL ERR [database or disk is full]
Sean Devoy
sdevoy at bizfocused.com
Fri Jul 22 22:05:41 MSD 2016
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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20160722/3cbec129/attachment.html
Join us at ClueCon 2016 Aug 8-12, 2016
More information about the FreeSWITCH-users
mailing list