November 27-28 DB failure

[Jim]

Something in the November 27 site update caused the mysql server to crash, disabling both TM services and this forum.  It wasn't the old problem with a "User Sleep" query.  I've restarted the server process, but I would like to investigate a bit before I try to relaunch the site update.

[Jim]

Good news.  It was just a full partition.  I have moved some files and successfully re-run last night's update.

I will be looking into extra storage, as this will continue to happen if I don't pay attention to space available on noreaster's /var partition.  Fortunately, disks are cheap, and I am confident that I will be able to acquire and install a second disk before the year is out.

[yakra]

Yikes, At least there's the option of compressing /home/tmp/tm to buy some time.

[Jim]

I made a very poor decision when setting up to keep the /var partition relatively small.  As our databases have grown, so has the usage for their storage in /var/db .

My plan is to get a new drive and give /var a ridiculously large amount of space on either the old or new drive.