vicidial.org

Hello.


I have a consitente error with all my Vicibox 7 based installations.

MyISAM tables are randomly crashing, maybe not randomly but can not identify why. my best guess is that this is happening when the cron executes the optimize during night (keep reading i will tell why)...

Example

One setup is crashing vicidial_live_agents. After repair if i try top optimize i get:

Can't create new tempfile: '/var/lib/mysql/asterisk/vicidial_live_agents.TMM'
after this, the table crash inmediatliy....

The result for this issue, is all my agents gettings "your session has been disabled"

Another setup is doing exactly the same with the tables vicidial_xfer_log and vicidial_callbacks_archive, with this the error is no that critical because agents can work, but eventually the vicidial_live_agents crash too.

I found information saying this was a bug on mariadb 10.0 branch

https://mariadb.atlassian.net/browse/MDEV-8475

Not sure if someone is facing this error.... i want to upgrade the mariadb version from another repository but not sure if this is going to cause any issues with the rest of the setup-

We had a client with this issue, and I think Kumba even posted about this on another topic. Basically, you just have to delete the .TMM files and then everything will work properly.

Yes, this is how i have been working around, but it doesnt prevent this to happen again :S

The issue is documented in the official ViciBox v.7 post here:

viewtopic.php?f=8&t=35346

If you don't stop mysql and delete all the TMM files, it will likely keep crashing. Haven't had any reoccurring issues after successfully deleting the TMM files.