> On Jun 3, 2018, at 1:23 AM, Ben Wong <[email protected]>
> wrote:
>
> 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
If you really need it, perhaps bextract will help.
Keep a fresh backup of your Catalog.
------------------------------------------------------------------------------
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
[email protected]
https://lists.sourceforge.net/lists/listinfo/bacula-users
