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 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 exist28-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?
Thanks in advance, -Justin
------------------------------------------------------------------------- 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
