Hi, 02.11.2007 15:25,, Bob Duman wrote:: > Last night our server room overheated and the system that Bacula > run's on locked up. Bacula was in the middle of a backup job > waiting for a tape change when the system crashed. Five backup > jobs had already completed, it was on the 6th and there were two > more to complete after the tape was changed and the 6th job > finished. After restarting the system, MySQL and Bacula both > started without any errors.
Good start at least... > Now when I look at the status for the director and the clients in > bconsole, it appears that there are missing jobs as follows: > > > 1) When I run 'status director', the latest date for > terminated jobs in the list is October 30. Jobs run every night so > there should be terminated jobs from October 31, November 1, and > the 5 that completed before the crash on November 2. > > 2) When I run 'status client=' for each client, some of the > clients show terminated jobs from no later than October 11, while > others show October 11 and November 2 but nothing in between. One > of the clients shows all of the recent jobs. Ignore that information - it's from the state files, and these probably are not up to date after a server crash. > Do I have a corrupted database due to the crash, or am I missing > something here as to how to see these jobs? Try a catalog query, in the simplest case for all the jobs from a client. Using SQL, you could also print a list of each job on all the clients that finished successfull. In general, I find that simply letting Bacula decide what to do is sufficient - you might skip one job, but that's about the worst thing that could happen. To be on the safe side, I'd suggest to run a dbcheck on your catalog to ensure the catalogues internal structure is ok - the database can't detect problems there. Arno > Thanks, Bob Duman Senior Systems Engineer Cleantech Group LLC > > > ------------------------------------------------------------------------ > > > ------------------------------------------------------------------------- > 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 -- 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