Dan, Can you find out more about these: "INSERT INTO Path (Path)..." SQL errors.
This doesn't sound like some new feature incompatibility, but that some how (possibly because of trying with batch insert) the user's database has been corrupted. In any case, I would like to see the exact output with the error message if possible. Thanks, Kern On Thursday 06 September 2007 21:43, Dan Langille wrote: > It seems that turning off batch updates is not sufficient on MySQL < > 4.1 > > ------- Forwarded message follows ------- > Date sent: Thu, 6 Sep 2007 15:31:36 -0400 > From: "Jody McDonnell" <[EMAIL PROTECTED]> > To: "Dan Langille" <[EMAIL PROTECTED]>, > [EMAIL PROTECTED] > Subject: Re: [Bacula-users] Post-upgrade database issues, > Bacula 1.38.11 to 2.2.1 on Solaris > > [ Double-click this line for list subscription options ] > > On 9/6/07, Dan Langille <[EMAIL PROTECTED]> wrote: > > On 6 Sep 2007 at 13:18, Jody McDonnell wrote: > > > Hi all, > > > > > > I spent the day yesterday upgrading the Bacula install on our Solaris > > > servers from 1.38.11 to 2.2.1. Things initially seemed to work, but > > > the overnight incremental backup failed with some database issues. > > > > > > I should note that I am using MySQL 4.0.18 with Bacula. I've been > > > using this version since I started using Bacula three years ago with > > > version 1.34.2. I haven't upgraded our version of MySQL, mainly > > > because I wasn't exactly sure of the steps required to upgrade MySQL > > > without risking data loss. > > > > > > The only database-related maintenance I performed before the upgrade > > > was to compact the MySQL database via the mysqldump utility, as per > > > section 21.2 of the Bacula manual. > > > > > > After building and installing Bacula 2.2.1, I ran the > > > "update_mysql_tables_9_to_10" script to update my database tables from > > > 1.38-era to 2.0-era. > > > > > > I seem to have encountered two issues. The first seems to be related > > > to the fact that my initial configuration script included the > > > "--enable-batch-insert" directive. The nightly incremental backup > > > failed with the following error messages: > > > > Have you tried the old MySQL without the batch insert enabled? > > > > -- > > Dan Langille - http://www.langille.org/ > > Available for hire: http://www.freebsddiary.org/dan_langille.php > > I did try that...I recompiled Bacula without batch insert enabled, > and > I received the "INSERT INTO Path (Path)..." SQL error. > > Actually, to be more precise, when I first tried an incremental > backup > with batch insert enabled, I received "Table 'bacula.batch' does not > exist" errors on the backup itself and "INSERT INTO Path (Path)..." > errors on the Catalog backup job that ran immediately afterward. > > After I recompiled Bacula 2.2.1 without batch inserts enabled (and > still with the old MySQL database), I triggered an incremental backup > and received the "INSERT INTO Path (Path)..." SQL errors. > > I have pretty much completed what I'd thought about in my first > post--and what you said sounded like a good plan--dumped the existing > database tables to a text file, installed the MySQL 5.0.45 Community > server, ran the grant_bacula_privileges, create_mysql_database, and > make_mysql_tables scripts, and read my data back in via the mysql > executable. The data looks okay--or, at least, I can get a > decent-looking listing when I run "list volumes". > > I've just kicked off an incremental backup; I'll post back with > results. > > Thanks! > Jody > > ---------------------------------------------------------------------- > --- > 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 > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/bacula-users > > > ------- End of forwarded message ------- ------------------------------------------------------------------------- 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-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/bacula-devel
