8 Sockets Detached Only in Asterisk, Can't call Softphone

After my hard drive was full again from recordings, I deleted the extra recordings and then rebooted. After this, the users told me that their X-Lite (our softphone) wasn't being called into the conference anymore.

For those unfamiliar, every time the agent logs into the website of Vicidial, the softphone will ring and will join a conference. Vicidial will dial numbers and when it gets an answered call, it will connect this phone call to the conference.

Upon checking using the "screen -ls" command, there are only 8 sockets detached (vs the usual 9). I found that "astsend" was missing. I assume this is the socket that "sends" the calls to the softphones.

I found 2 suggestions on how to fix it:

1. Recompile Asterisk - I don't know how to do this exactly, but might be worth looking into for those who know how to do this.

2. Perform a Mysql Repair - Thankfully, this was the solution that worked for me! Turns out, when deleting unwanted recordings, it also damaged the mysql database.

mysqlcheck --auto-repair asterisk
sudo reboot

After performing the mysql repair and rebooting, Asterisk now calls my X-lite again.

No More Leads in the Hopper for Campaign

Early this morning, I had to free up some space by deleting unneeded .WAV files. Later in the day, we found out that we couldn't make any outbound calls for all of the campaigns (but we could still receive inbound calls). The error was "No more leads in the hopper for campaign: <campaign name>". This was the same error message regardless of if it was Manual Dialing or Predictive Dialing.

I found the way to identify the issue through Support ALG's blog (see link below).
https://supportalg.blogspot.com/2015/06/how-to-fix-error-this-campaign-has-zero.html

It was the 2nd method that helped me identify the error:

/usr/share/astguiclient/AST_VDhopper.pl --debugX

Sorry, I was only able to get a partial screenshot

Because of this, I was able to identify that the /asterisk/vicidial_list table had crashed. After googling "table vicidial list is marked as crashed", I found this vicidial.org forum thread:
http://www.vicidial.org/VICIDIALforum/viewtopic.php?t=20206

Scrolling down below, I found this command (first when mysql has no password, second has password - you'll only need one of them):

mysqlcheck --auto-repair asterisk vicidial_list
mysqlcheck --auto-repair asterisk vicidial_list -p

Now after running the mysqlcheck, I logged out of and in to the campaign, and I can dial outbound calls again!