Hello,
I was trying to clean up my failed jobs from my catalog but I happened to
accidentally delete the jobid of a running job. Stupid, I know. From what
I can see, the backup looks like it succeeded, it only appears failed due
to bacula being unable to find original jobid because I deleted it.
Is there a simple way to retrieve that catalog data for the jobid I
deleted? The backup is written across four LTO7 tape volumes. I was
thinking of redoing the backup and not deleting the jobid but maybe there's
an option where I don't have to rewrite all that data?
Here's the error I get: JobID 245 is the job I accidentally deleted.
02-Jun 20:38 bacula-dir JobId 245: Warning: Error updating job record.
sql_update.c:202 Update failed: affected_rows=0 for UPDATE Job SET
JobStatus='T',EndTime='2018-06-02 20:38:50',ClientId=8,JobBytes=
40063503226963,ReadBytes=40063503226963,JobFiles=2684608,JobErrors=28,
VolSessionId=8,VolSessionTime=1527615994,PoolId=4,FileSetId=
8,JobTDate=1527997130,RealEndTime='2018-06-02
20:38:50',PriorJobId=0,HasBase=0,PurgedFiles=0
WHERE JobId=245
02-Jun 20:38 bacula-dir JobId 245: Warning: Error getting Job record for
Job report: ERR=sql_get.c:318 No Job found for JobId 245
Thanks for any help,
Benjamin Wong
p.s.
bacula version 5.2.13
CentOS 7.5
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
