Hi, 24.09.2007 15:35,, Jonathan Fine wrote:: > Hi, > > I just upgraded my sarge bacula server and clients to your latest > packages. Upgrades seemed to go smoothly, but when I ran a test > backup form one of my clients, I received the following error at > finish: > > 24-Sep 09:28 bserv-sd: Sending spooled attrs to the Director. > Despooling 20,209 bytes ... > 24-Sep 09:28 bserv-dir: xxxtape.2007-09-24_09.27.08 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 > > > > Any ideas?
Yup. Which catalog database do you run, which version exactly? For example, you need MySQL 4.1.something and above for batch inserts to work. Arno > Thanks, > > Jon > > > On 9/13/07, Marc Schiffbauer <[EMAIL PROTECTED]> wrote: >> Hi all, >> >> this is to let you know that I have finished packaging Bacula 2.2.3 >> for the following distros: >> >> * Debian sarge (i386) >> * Debian etch (i386 and amd64) >> * Ubuntu edgy (i386 and amd64) >> * Ubuntu feisty (i386 and amd64) >> >> The packages are based on the debian unstable packages by John >> Goerzen (thanks John) >> >> Please note that these packages are being built using pbuilder which >> allows to build very clean packages regarding package dependencies >> and the like, however: >> >> Although the packages did build clean I have not tested them on >> every platform so if you want to use them in production: >> Please test them first. Also it would be useful to have some >> feedback here that they are working. >> >> I built a bat package (bacula-console-qt) for distros that have at >> least recent qt4 packages available. (libqwt5 is builtin statically >> on systems where it is not available) >> >> There is an issue on ubuntu left: Stopping bacula-fd does not work >> with the init script, so on upgrades you have to manually >> "killall bacula-fd" one time. Patch would be welcome. >> >> Find instructions to use the packages here: >> >> http://wiki.links2linux.de/en/index.php/PackMan_repo_instructions_for_Debian/Ubuntu_%28en%29 >> >> Cheers >> -Marc >> -- >> BUGS My programs never have bugs. They just develop random >> features. If you discover such a feature and you want it to >> be removed: please send an email >> >> -----BEGIN PGP SIGNATURE----- >> Version: GnuPG v1.4.1 (GNU/Linux) >> >> iD8DBQFG6cz9KWxsyjWmQTQRAqA8AJ4xHgS3ni/sTs11EaHUhDHwiXevhACgmqwT >> OIL7uZJQ915F3/6/FMTv3rk= >> =X5g3 >> -----END PGP SIGNATURE----- >> >> ------------------------------------------------------------------------- >> 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 >> >> > > ------------------------------------------------------------------------- > 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 -- Arno Lehmann IT-Service Lehmann www.its-lehmann.de ------------------------------------------------------------------------- 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
