Hello Craig, Which Bacula version are you using?
Best regards, Ana On Fri, Sep 11, 2015 at 4:14 PM, Craig Shiroma <shiroma.crai...@gmail.com> wrote: > My apologies. I hit the send button before entering a subject. > > On Fri, Sep 11, 2015 at 9:13 AM, Craig Shiroma <shiroma.crai...@gmail.com> > wrote: > >> Hello All, >> >> I'm getting the following problem occasionally: >> 2015-09-10 23:47:24bacula-dir JobId 140080: Fatal error: JobId 139901 >> already running. Duplicate job not allowed. >> >> Due to this type of error: >> 2015-09-10 23:47:22bacula-dir JobId 139901: Fatal error: sql_create.c:870 >> Fill File table Query failed: INSERT INTO File (FileIndex, JobId, PathId, >> FilenameId, LStat, MD5, DeltaSeq) SELECT batch.FileIndex, batch.JobId, >> Path.PathId, Filename.FilenameId,batch.LStat, batch.MD5, batch.DeltaSeq >> FROM batch JOIN Path ON (batch.Path = Path.Path) JOIN Filename ON >> (batch.Name = Filename.Name): ERR=Lock wait timeout exceeded; try >> restarting transaction >> >> This happens when a database lock has timed out on a backup and the job >> is rescheduled. For some reason, it seems a new job is starting up as soon >> as the error is detected. I posted about this issue earlier and someone >> mentioned it is happening because I configured Bacula to do that (or at >> least that's the impression I got from the post). Would anyone know which >> config would have the setting to start up a new job for the client backup >> when an error like a lock is detected? So far, I've only found settings >> for rescheduling, not restarting such as below: >> >> Reschedule Interval = 1 hour >> Reschedule Times = 3 >> Cancel Lower Level Duplicates = yes >> Allow Duplicate Jobs = no >> >> Obviously, the backup is getting canceled because of the last two >> settings above. But, what setting is causing a new job to be created when >> I get a lock timeout error is detected that says it has rescheduled the job >> for 3600 minutes later? >> >> I realize it appears I may need to do some database fixing/turning. But, >> my immediate wonder is why a new job is being created when one has been >> rescheduled? >> >> Regards, >> -craig >> > > > > ------------------------------------------------------------------------------ > > _______________________________________________ > Bacula-users mailing list > Bacula-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/bacula-users > >
------------------------------------------------------------------------------
_______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
