Alan Brown wrote: > On Wed, 16 Sep 2009, Richard Mortimer wrote: > > >> The immediate failure is because the number of affected rows is zero. I'm not >> sure what the underlying cause could be (apart from the fact that JobId >> 104670 >> is not in the Job table - pruning or a bug?) >> > > More likely bug than pruning. It's being run by the scheduler and then > failing almost immediately. > > >> But I vaguely remember a discussion about zero lines changed on bacula-devel. >> Looking at the code the test that reports the failure has changed between >> 2.4.4 and now (it tests affected_rows < 1 in the latest code). >> > > This happens about 1 in 10 runs, so it's not consistent. > > It also happens more often than not on various incremental/diff backups of > the bacula server and there is _always_ at least one changed file each run > (logfiles) > I'm wondering if the problem is with MySQL. Is it possible the database is corrupt and/or that MySQL is running out of disk space?
W/rt to corruption, I'd suggest maybe running mysqlcheck and while you're at it you might as well run dbcheck (bacula's high-level database consistency checker). Also, I'd be interested to know if the "missing" job records really and truly are not there, or if the error report itself is bogus. You should be able to test this by doing a SQL query on the database after a failed job, something like "select * from Job where JobID = <jobid_of_failed_job>;". If the error message is accurate, this query should return no rows. - Cedric ------------------------------------------------------------------------------ Come build with us! The BlackBerry® Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9-12, 2009. Register now! http://p.sf.net/sfu/devconf _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
