Vicibox 7, randomly crashing tables.

Support forum for the ViciBox ISO Server Install and ISO LiveCD Demo

Moderators: enjay, williamconley, Staydog, mflorell, MJCoate, mcargile, Kumba

Vicibox 7, randomly crashing tables.

Postby covarrubiasgg » Sun Mar 06, 2016 1:29 pm

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-
covarrubiasgg
 
Posts: 420
Joined: Thu Jun 10, 2010 10:20 am
Location: Tijuana, Mexico

Re: Vicibox 7, randomly crashing tables.

Postby mflorell » Sun Mar 06, 2016 3:11 pm

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.
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Re: Vicibox 7, randomly crashing tables.

Postby covarrubiasgg » Sun Mar 06, 2016 3:53 pm

Yes, this is how i have been working around, but it doesnt prevent this to happen again :S
covarrubiasgg
 
Posts: 420
Joined: Thu Jun 10, 2010 10:20 am
Location: Tijuana, Mexico

Re: Vicibox 7, randomly crashing tables.

Postby Kumba » Tue Mar 08, 2016 10:35 pm

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.
Kumba
 
Posts: 939
Joined: Tue Oct 16, 2007 11:44 pm
Location: Florida


Return to ViciBox Server Install and Demo

Who is online

Users browsing this forum: No registered users and 43 guests