Database is full

[rbbumanlag]

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!

[williamconley]

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

[rbbumanlag]

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

[williamconley]

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).