The table 'vicidial_manager' is full

[vkad]

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?

[vkad]

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

[thephaseusa]

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

Previous thread about this same issue. Hope it helps.

John

[thephaseusa]

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.

[mflorell]

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.

[vkad]

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

[mflorell]

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

[vkad]

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

[mflorell]

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