> On Jun 3, 2018, at 3:42 PM, Pedro Oliveira <oliveira...@gmail.com
> <mailto:oliveira...@gmail.com>> wrote:
>
> No dia 03/06/2018, às 16:13, Dan Langille <d...@langille.org
> <mailto:d...@langille.org>> escreveu:
>
>>> On Jun 3, 2018, at 1:23 AM, Ben Wong <benjamin.w...@blur.compbio.ucsf.edu
>>> <mailto:benjamin.w...@blur.compbio.ucsf.edu>> 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.
> Use Bscan to scan the volume with bsr file
>
Yes, bscan, not bextract. Sorry.
--
Dan Langille - BSDCan / PGCon
d...@langille.org <mailto:d...@langille.org>
------------------------------------------------------------------------------
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
