Database is full

Any and all non-support discussions

Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N

Database is full

Postby rbbumanlag » Mon Feb 20, 2017 9:01 pm

Hi Vicidial,

Specification:
ViciBox 6.0.4.(iso) | Asterisk 1.8.32-3-vici | VERSION: 2.12-538a BUILD: 160122-1401 | Cluster Setup | Intel(R) Xeon(R) CPU E5-2680 V3 @ 2.5GHz | 16GB DDR4 RAM | 1TB (SAS) 10kRPM |No Digium/Sangoma Hardware | No Extra Software After Installation | Virtualized on XenServer

Problem

We have encountered and error with our asterisk server with below information:
ERROR[8893]: res_config_sqlite.c:849 in cdr_handler: database is full
ERROR[25569]: res_config_sqlite.c:849 in cdr_handler: database is full
ERROR[27018]: res_config_sqlite.c:849 in cdr_handler: database is full
ERROR[10742]: cdr_sqlite.c:183 in sqlite_log: cdr_sqlite: database is full
ERROR[28228]: cdr_sqlite.c:183 in sqlite_log: cdr_sqlite: database is full
ERROR[28227]: cdr_sqlite.c:183 in sqlite_log: cdr_sqlite: database is full

Where is the location of cdr_handler and cdr_sqlite? We still have 59GB available for disk space. Where can I adjust the setting for this?

Database Server is located on another server and still have available space of around 80GB.

Thanks!
rbbumanlag
 
Posts: 74
Joined: Mon Sep 26, 2016 10:37 am

Re: Database is full

Postby williamconley » Sat Feb 25, 2017 5:28 am

Code: Select all
nano /etc/asterisk/modules.conf


Code: Select all
noload => res_config_sqlite.so
noload => res_config_sqlite3.so
noload => cdr_sqlite.so
noload => cel_sqlite3_custom.so
noload => cdr_sqlite3_custom.so

reboot or kill asterisk and restart it.
Code: Select all
rm /var/log/asterisk/cdr.db
rm /var/lib/asterisk/sqlite.db
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20018
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Re: Database is full

Postby rbbumanlag » Mon Feb 27, 2017 1:04 am

Thanks! I will try this one. What this is is to disable local database? is it safe to do this to other asterisk servers?
rbbumanlag
 
Posts: 74
Joined: Mon Sep 26, 2016 10:37 am

Re: Database is full

Postby williamconley » Mon Feb 27, 2017 1:57 am

rbbumanlag wrote:Thanks! I will try this one. What this is is to disable local database? is it safe to do this to other asterisk servers?

this is an asterisk database. it's not in any way related to mysql. it's an unused asterisk non-sql database that stores call information ... that's never used (unless you get a subpoena).
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20018
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)


Return to General Discussion

Who is online

Users browsing this forum: No registered users and 66 guests