CentOS 5 - MySQL 5 # uname -r -v -m -p -o 2.6.18-8.1.14.el5 #1 SMP Thu Sep 27 18:58:54 EDT 2007 i686 i686 GNU/Linux
# rpm -qa |grep bacula bacula-mtx-2.2.5-1 bacula-mysql-2.2.5-1 # rpm -qa |grep mysql mysql-devel-5.0.22-2.1.0.1 libdbi-dbd-mysql-0.8.1a-1.2.2 mysql-connector-odbc-3.51.12-2.2 php-mysql-5.1.6-15.el5 mysql-5.0.22-2.1.0.1 mysql-server-5.0.22-2.1.0.1 bacula-mysql-2.2.5-1 Monday through Wednesday, single tape went fine. Last night started a 'Full' backup which would span to second tape. Things went fine until it tried to write the first file from the 3rd job onto the second tape for this Pool, then... 26-Oct 08:30 LINSERV1-sd JobId 14: Wrote label to prelabeled Volume "1_Friday_Week_2" on device "LTO" (/dev/nst0) 26-Oct 08:30 LINSERV1-sd JobId 14: New volume "1_Friday_Week_2" mounted on device "LTO" (/dev/nst0) at 26-Oct-2007 08:30. 26-Oct 08:30 LINSERV1 JobId 14: Fatal error: sql_create.c:732 sql_create.c:732 insert INSERT INTO batch VALUES (16858,14,'E:/WinShares/PR/P R CLIENTS/Toll Brothers #535/2006/Phoenix/Correspondence/Clips/Phoenix 2 April - June Clips/','Apr Arizona Republic 4-21.jpg','A A IH/ B A A A 9S5 A A BHGA+/ BEV2T2 BEV2T2 A A L','0') failed: Table 'bacula.batch' doesn't exist 26-Oct 08:30 LINSERV1 JobId 14: Fatal error: catreq.c:404 Attribute create error. Query failed: DROP INDEX DelInx1: ERR=You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 26-Oct 08:30 LINSERV1-sd JobId 14: Job NAS-Backup.2007-10-25_20.00.12 marked to be canceled. ? Craig ------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
