Dear bacula users, last night my bacula server reported lots of the following errors:
23-Sep 13:38 bacula-dir: iwmuser.2007-09-23_04.05.11 Fatal error: sql_create.c:730 sql_create.c:730 insert INSERT INTO batch VALUES (5,2652,'/home/','','U C EHt BD A A A BAA QAA I BG9k/M BG3Y4l BG3Y4l A A E','0') failed: Table 'bacula.batch' doesn't exist 23-Sep 13:38 bacula-dir: sql_create.c:730 INSERT INTO batch VALUES (5,2652,'/home/','','U C EHt BD A A A BAA QAA I BG9k/M BG3Y4l BG3Y4l A A E','0') 23-Sep 13:38 bacula-dir: iwmuser.2007-09-23_04.05.11 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 iwmuser-fd: Filesystem change prohibited. Will not descend into /sys 23-Sep 13:38 bacula-dir: iwmuser.2007-09-23_04.05.11 Fatal error: sql_create.c:730 sql_create.c:730 insert INSERT INTO batch VALUES (6,2652,'/sbin/','','gR EEAB EHt C A A A CAA BAA Y BG9Icu BG9dXz BG9dXz A A E','0') failed: Table 'bacula.batch' doesn't exist 23-Sep 13:38 bacula-dir: sql_create.c:730 INSERT INTO batch VALUES (6,2652,'/sbin/','','gR EEAB EHt C A A A CAA BAA Y BG9Icu BG9dXz BG9dXz A A E','0') 23-Sep 13:38 bacula-dir: iwmuser.2007-09-23_04.05.11 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 Seems as if my database structure isn't correct? But what about the sql syntax errors? I am running bacula-mysql 2.2.4 on a SuSE SLES10_SP1 system. Thanks a lot in advance. -- Regards Christoph Litauer ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users