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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
