-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Arno Lehmann wrote: > 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.
One easy way to fix this (directing this at Marc, really) is to have a dependency on not just MySQL, but MySQL >= 4.1. =R >> 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 > - -- ---- _ _ _ _ ___ _ _ _ |Y#| | | |\/| | \ |\ | | |Ryan Novosielski - Systems Programmer II |$&| |__| | | |__/ | \| _| |[EMAIL PROTECTED] - 973/972.0922 (2-0922) \__/ Univ. of Med. and Dent.|IST/AST - NJMS Medical Science Bldg - C630 -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.5 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFG98Somb+gadEcsb4RAk9aAJ9Jgdwqs3eBTEMKMxoRU24Z/J/zZACdF9Iw r6nPDQw3cNpotw4eglmtgJE= =h+iu -----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
