Hi, 28.08.2007 19:18,, Justin Wainwright wrote:: > Just recently upgraded to Bacula 2.2.0 from 2.0.3 on Debian etch with > mySQL 5.0.32- since the upgrade, I've seen a number of incremental jobs > fail with references to the bacula.batch table: > > 28-Aug 13:02 socrates-dir: Socrates.2007-08-28_12.55.12 Fatal error: > catreq.c:478 Attribute create error. sql_update.c:454 Update failed: > affected_rows=0 for UPDATE Media SET InChanger=0 WHERE Slot=12 AND > StorageId=3 AND MediaId!=61
The above one is probably also part of a problem... > 28-Aug 13:02 socrates-dir: Socrates.2007-08-28_12.55.12 Fatal error: > sql_create.c:730 sql_create.c:730 insert INSERT INTO batch VALUES > (4444,13172,'/backups/bacula/working/','bacula-dir.9101.state','GgJ T0AR > IGg B A Bs A fw BAA I BG1EyX BG1Exw BG1Exw A A > C','AnUhBiQfrp4RKc5TXi4Pai+Dye8') failed: > Table 'bacula.batch' doesn't exist Have you run the script to update the catalog database schema? > 28-Aug 13:02 socrates-dir: sql_create.c:730 INSERT INTO batch VALUES > (4444,13172,'/backups/bacula/working/','bacula-dir.9101.state','GgJ T0AR > IGg B A Bs A fw BAA I BG1EyX BG1Exw BG1Exw A A > C','AnUhBiQfrp4RKc5TXi4Pai+Dye8') > > The only other reference I've seen to something like this in the mailing > list is some questions about mySQL 5 with the Bacula 2.1.x branch- is > this still some sort of lingering issue? I don't know anything about this. Arno -- Arno Lehmann IT-Service Lehmann www.its-lehmann.de ------------------------------------------------------------------------- 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
