[Bacula-users] Note about MySQL crashing or bacula stopping

Hi, this note is primarily for the search engines to pick up so someone 
that has the same
problem as me doesn't spend a lot of time searching. Bacula was stopping 
or not stopping
and the MySQL engine seemed to be running but the sockets looked stale. 
After some time
I noticed in the mysql log were some references to creating temp files 
and tmp space unsuccessful.

So after some combing of docs and notes I concluded that the tmp space 
for MySQL must be
getting too full to handle the tmp transactions Bacula is doing so I 
moved it, restarted MySQL,
restarted Bacula, then the crashes stopped. So if Bacula is crashing 
(search terms) look here as well:

The MySQL log had some of these in it:

110123  4:28:45 [ERROR] /usr/libexec/mysqld: Incorrect key file for 
table '/tmp/#sql4c31_135_0.MYI'; try to repair it
110123  4:28:45 [ERROR] /usr/libexec/mysqld: Incorrect key file for 
table '/tmp/#sql4c31_137_0.MYI'; try to repair it
110123  4:28:47 [ERROR] /usr/libexec/mysqld: Incorrect key file for 
table '/tmp/#sql4c31_159_0.MYI'; try to repair it

and some of these as well:

110123  4:59:41 [Warning] Could not remove tmp table: 
'/tmp/#sql4c31_137_0', error: 2
110123  4:59:41 [Warning] Could not remove tmp table: 
'/tmp/#sql4c31_139_0', error: 2
110123  4:59:42 [Warning] Could not remove tmp table: 
'/tmp/#sql4c31_135_0', error: 2

The change to /etc/my.cnf for moving the tmpdir space:

[mysqld]
datadir=/var/lib/mysql
tmpdir=/somegoodplacewithplentyofspace

Thanks,
Randy Katz


------------------------------------------------------------------------------
Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)!
Finally, a world-class log management solution at an even better price-free!
Download using promo code Free_Logger_4_Dev2Dev. Offer expires 
February 28th, so secure your free ArcSight Logger TODAY! 
http://p.sf.net/sfu/arcsight-sfd2d
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users