Hi, during a differential backup at the weekend, one of the jobs failed as it couldn't update the job record:
26-Mar 19:10 bareos-sd JobId 25189: Elapsed time=10:36:02, Transfer rate=29.31 M Bytes/second 26-Mar 19:16 bareos-dir JobId 25189: Warning: Error updating job record. sql_update.c:189 Update failed: affected_rows=0 for UPDATE Job SET JobStatus='T',Level='D',EndTime='2018-03-26 19:16:21',ClientId =9,JobBytes=1117026098791,ReadBytes=1117026098791,JobFiles=7229944,JobErrors=0,VolSessionId=2031,VolSessionTime=1518004112,PoolId=4,FileSetId=12,JobTDate=1522088181,RealEndTime='2018-03-26 19:16:21',Pri orJobId=0,HasBase=0,PurgedFiles=0 WHERE JobId=25189 26-Mar 19:16 bareos-dir JobId 25189: Warning: Error getting Job record for Job report: ERR=sql_get.c:309 No Job found for JobId 25189 26-Mar 19:16 bareos-dir JobId 25189: Error: Bareos bareos-dir 16.2.4 (01Jul16): Build OS: x86_64-pc-linux-gnu debian Debian GNU/Linux 8.0 (jessie) JobId: 25189 Job: fs01.2018-03-24_21.00.00_40 Backup Level: Differential, since=2018-03-03 01:31:33 Client: "fs01-fd" 16.2.4 (01Jul16) Microsoft Windows Server 2012 Standard Edition (build 9200), 64-bit,Cross-compile,Win64 FileSet: "Windows File Server" 2016-10-25 16:45:57 Pool: "Differential" (From Job DiffPool override) Catalog: "MyCatalog" (From Client resource) Storage: "File01" (From Pool resource) Scheduled time: 24-Mar-2018 21:00:00 Start time: 24-Mar-2018 21:49:53 End time: 26-Mar-2018 19:16:21 Elapsed time: 1 day 20 hours 26 mins 28 secs Priority: 10 FD Files Written: 7,229,944 SD Files Written: 7,229,944 FD Bytes Written: 1,117,026,098,791 (1.117 TB) SD Bytes Written: 1,118,731,673,356 (1.118 TB) Rate: 6981.9 KB/s Software Compression: None VSS: yes Encryption: no Accurate: no Volume name(s): Differential-1369|Differential-1334|Differential-1335|Differential-1336|Differential-1337|Differential-1338|Differential-1339|Differential-1340|Differential-1341|Differential-1342|Differential-1343|Differential-0529|Differential-0530|Differential-0531|Differential-0532|Differential-0917|Differential-0918|Differential-0919|Differential-0920|Differential-0921|Differential-0922|Differential-0533|Differential-0041|Differential-0049|Differential-0534|Differential-0535|Differential-0536|Differential-0537|Differential-0538|Differential-0923|Differential-0924|Differential-0925|Differential-0926|Differential-0927|Differential-0928|Differential-1350|Differential-1351|Differential-1352|Differential-1353|Differential-1354|Differential-1355|Differential-1356|Differential-1357|Differential-1358|Differential-1359|Differential-1360|Differential-1361|Differential-1362|Differential-1363|Differential-1364|Differential-1365|Differential-1366|Differential-1367|Differential-1368|Differential-0929|Differential-0539|Differential-0050|Differential-1027|Differential-1028|Differential-1029|Differential-1030|Differential-1031|Differential-1032|Differential-1033|Differential-1034|Differential-1035|Differential-1036|Differential-1037|Differential-1038|Differential-1039|Differential-1040 Volume Session Id: 2031 Volume Session Time: 1518004112 Last Volume Bytes: 8,960,918,716 (8.960 GB) Non-fatal FD errors: 0 SD Errors: 0 FD termination status: OK SD termination status: OK Termination: *** Backup Error *** The jobid doesn't exist and none of the volumes have jobs associated with them (except the last as it was appended to by the next job). Is there a way of recovering this into the db? Presumably these are now useless for restores. Will they get recycled after the retention period? Regards, Niall -- You received this message because you are subscribed to the Google Groups "bareos-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. For more options, visit https://groups.google.com/d/optout.
