On Thursday 06 September 2007 11:46, Arno Lehmann wrote: > Hi, > > 06.09.2007 08:23,, Silver Salonen wrote:: > > Hello. > > > > Yesterday I upgraded Bacula (dir, sd, fd) from 2.0.3 to 2.2.0 on FreeBSD-5.3. > > I use Bacula with MySQL 4.0.27. In the evening all the backups failed with > > error: > > ===== > > 06-Sep 00:33 mydom-sd: Job write elapsed time = 00:00:44, Transfer rate = > > 2.103 M bytes/second > > 06-Sep 00:33 mydom-dir: myser-conf.2007-09-06_00.32.49 Fatal error: Can't fill > > Path table Query failed: INSERT INTO Path (Path) SELECT a.Path > > FROM (SELECT DISTINCT Path FROM batch) AS a > > > > WHERE NOT EXISTS (SELECT Path FROM Path > > AS p WHERE p.Path = a.Path) : 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 'SELECT DISTINCT Path > > FROM batch) AS a WHE > > ===== > > > > May the problem be in MySQL, i.e. Bacula 2.2 isn't compatible with MySQL 4.0 > > although 2.0 was? > > Yes... as far as I know, subqueries or nested selects are available > ony with MySQL 4.1 and up.
Yep, today morning I upgraded to MySQL 4.1 and backups were OK. ------------------------------------------------------------------------- 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