[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
Sean, Drop us an email to consulting@freeswitch.org <mailto:consulting@freeswitch.org> we can get you back up and running pretty quick and diagnose the problem From: freeswitch-users-bounces@lists.freeswitch.org [mailto:freeswitch-users-bounces@lists.freeswitch.org] On Behalf Of Sean Devoy Sent: Friday, July 22, 2016 1:06 PM To: FreeSWITCH Users Help <freeswitch-users@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
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@lists.freeswitch.org [mailto:freeswitch-users-bounces@lists.freeswitch.org] On Behalf Of Ken Rice Sent: Friday, July 22, 2016 2:11 PM To: 'FreeSWITCH Users Help' <freeswitch-users@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@freeswitch.org<mailto:consulting@freeswitch.org> we can get you back up and running pretty quick and diagnose the problem From: freeswitch-users-bounces@lists.freeswitch.org<mailto:freeswitch-users-bounces@lists.freeswitch.org> [mailto:freeswitch-users-bounces@lists.freeswitch.org] On Behalf Of Sean Devoy Sent: Friday, July 22, 2016 1:06 PM To: FreeSWITCH Users Help <freeswitch-users@lists.freeswitch.org<mailto:freeswitch-users@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
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@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@lists.freeswitch.org [mailto:freeswitch-users-bounces@lists.freeswitch.org] On Behalf Of Ken Rice Sent: Friday, July 22, 2016 2:11 PM To: 'FreeSWITCH Users Help' <freeswitch-users@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@freeswitch.org<mailto:consulting@freeswitch.org> we can get you back up and running pretty quick and diagnose the problem
From: freeswitch-users-bounces@lists.freeswitch.org<mailto:freeswitch-users-bounces@lists.freeswitch.org> [mailto:freeswitch-users-bounces@lists.freeswitch.org] On Behalf Of Sean Devoy Sent: Friday, July 22, 2016 1:06 PM To: FreeSWITCH Users Help <freeswitch-users@lists.freeswitch.org<mailto:freeswitch-users@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@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@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@ccs.covici.com
Yes, you were correct, it was pcapsipdump filling the disk. Clearly when I was debugging something I unknowingly started pcapsipdump to log every session - forever. Once the pcap files were removed, and pcapsipdump stopped, the space is again at 5% used and 95% free. If anyone has a source for a contract Unix administrator, we would love to hear about them. Thanks for your input and to Nathan for his help. Sean -----Original Message----- From: freeswitch-users-bounces@lists.freeswitch.org [mailto:freeswitch-users-bounces@lists.freeswitch.org] On Behalf Of covici@ccs.covici.com Sent: Friday, July 22, 2016 3:44 PM To: FreeSWITCH Users Help <freeswitch-users@lists.freeswitch.org> Subject: Re: [Freeswitch-users] [ERR] switch_core_sqldb.c:586 NATIVE SQL ERR [database or disk is full] 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@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@lists.freeswitch.org [mailto:freeswitch-users-bounces@lists.freeswitch.org] On Behalf Of Ken Rice Sent: Friday, July 22, 2016 2:11 PM To: 'FreeSWITCH Users Help' <freeswitch-users@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@freeswitch.org<mailto:consulting@freeswitch.org> we can get you back up and running pretty quick and diagnose the problem
From: freeswitch-users-bounces@lists.freeswitch.org<mailto:freeswitch-users- bounces@lists.freeswitch.org> [mailto:freeswitch-users-bounces@lists.freeswitch.org] On Behalf Of Sean Devoy Sent: Friday, July 22, 2016 1:06 PM To: FreeSWITCH Users Help <freeswitch-users@lists.freeswitch.org<mailto:freeswitch-users@lists.f reeswitch.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@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@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-use rs 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@ccs.covici.com _________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@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@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
participants (3)
-
covici＠ccs.covici.com
-
Ken Rice
-
Sean Devoy