vicidial.org

May 29 16:50:33 dialsf mysql-systemd-helper[1518]: 2018-05-29 16:50:33 140693801236224 [ERROR] mysqld: The table 'vicidial_manager' is full

We are getting this error in journalctl. How can we fix it?

I had converted the table to Memory table. How do I convert it back to MyISAM

http://www.eflo.net/VICIDIALforum/viewt ... =4&t=35047

Previous thread about this same issue. Hope it helps.

John

mysql -p asterisk

select engine from information_schema.tables where table_schema ='asterisk' and table_name = 'vicidial_manager';

That shows the engine type of vicidial_manager.

ALTER TABLE vicidial_manager ENGINE='MyISAM';

That converts it to MyISAM.

select engine from information_schema.tables where table_schema ='asterisk' and table_name = 'vicidial_manager';

verify that it is now engine MyISAM.

I would suggest running the /usr/share/astguiclient/AST_flush_DBqueue.pl script more frequently in your crontab, also setting it to a shorter time period with the "--seconds" option. Wouldn't recommend setting it any lower than 300 seconds.

mflorell wrote:I would suggest running the /usr/share/astguiclient/AST_flush_DBqueue.pl script more frequently in your crontab, also setting it to a shorter time period with the "--seconds" option. Wouldn't recommend setting it any lower than 300 seconds.

So, should I keep the table as Memory or convert it to MyISAM

If you clear it out more frequently, you might be able to keep it as MEMORY

Is memory better for autodialing? Does it reduce load or reduce waiting times or dropped calls, etc?

Sometimes it is better for some clients, it's not the same for everyone, depends on the configurations and usage.