Any and all non-support discussions
Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N
by 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
by 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: 20258
- Joined: Wed Oct 31, 2007 4:17 pm
- Location: Davenport, FL (By Disney!)
-
by 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
by 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: 20258
- 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 84 guests