On Fri, 2007-10-26 at 10:55 -0700, Craig White wrote: > 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. > > ? ---- I was really hoping someone could explain this sql error or if I am going to run into that same error on Full backup again this week.
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
