Hi,
looks like the missing job has now been imported as 84814
(and the rest from another volume) also +1 in the jobid.
bacula=> select * from Job where JobId>=84813;
jobid | job | name | type | level |
clientid | jobstatus | schedtime | starttime |
endtime | realendtime | jobtdate | volsessionid |
volsessiontime | jobfiles | jobbytes | joberrors | jobmissingfiles | poolid
| filesetid | purgedfiles | hasbase | priorjobid | readbytes | hascache |
reviewed | comment
-------+--------------------------------------+---------------+------+-------+----------+-----------+---------------------+---------------------+---------------------+---------------------+------------+--------------+----------------+----------+-------------+-----------+-----------------+--------+-----------+-------------+---------+------------+-----------+----------+----------+---------
84814 | BackupCatalog.2026-05-31_23.52.00_25 | BackupCatalog | B | F |
1 | T | 2026-06-01 02:06:37 | 2026-06-01 02:06:37 | 2026-06-01
02:11:40 | 2026-06-01 02:11:40 | 1780272700 | 22 | 1780252068 |
2 | 27807038876 | 0 | 0 | 0 | 36 |
0 | 0 | 0 | 0 | 0 | 0 |
84815 | mail_full.2026-06-01_03.52.00_26 | mail_full | B | I |
6 | T | 2026-06-01 03:52:20 | 2026-06-01 03:52:20 | 2026-06-01
03:52:46 | 2026-06-01 03:52:46 | 1780278766 | 23 | 1780252068 |
56 | 637963464 | 0 | 0 | 2 | 31 |
0 | 0 | 0 | 0 | 0 | 0 |
84816 | mail_home.2026-06-01_03.52.01_27 | mail_home | B | I |
6 | T | 2026-06-01 03:52:59 | 2026-06-01 03:52:59 | 2026-06-01
03:53:46 | 2026-06-01 03:53:46 | 1780278826 | 24 | 1780252068 |
36 | 925368802 | 0 | 0 | 2 | 33 |
0 | 0 | 0 | 0 | 0 | 0 |
84817 | mail_full.2026-06-01_07.52.00_28 | mail_full | B | I |
6 | T | 2026-06-01 07:52:17 | 2026-06-01 07:52:17 | 2026-06-01
07:52:52 | 2026-06-01 07:52:52 | 1780293172 | 25 | 1780252068 |
856 | 705752121 | 0 | 0 | 2 | 31 |
0 | 0 | 0 | 0 | 0 | 0 |
84818 | mail_home.2026-06-01_07.52.00_29 | mail_home | B | I |
6 | T | 2026-06-01 07:53:06 | 2026-06-01 07:53:06 | 2026-06-01
07:54:51 | 2026-06-01 07:54:51 | 1780293291 | 26 | 1780252068 |
44 | 2481071670 | 0 | 0 | 2 | 33 |
0 | 0 | 0 | 0 | 0 | 0 |
84819 | mail_full.2026-06-01_11.52.00_30 | mail_full | B | I |
6 | T | 2026-06-01 11:52:16 | 2026-06-01 11:52:16 | 2026-06-01
11:52:49 | 2026-06-01 11:52:49 | 1780307569 | 27 | 1780252068 |
80 | 732147966 | 0 | 0 | 2 | 31 |
0 | 0 | 0 | 0 | 0 | 0 |
84820 | mail_home.2026-06-01_11.52.00_31 | mail_home | B | I |
6 | T | 2026-06-01 11:53:03 | 2026-06-01 11:53:03 | 2026-06-01
11:55:02 | 2026-06-01 11:55:02 | 1780307702 | 28 | 1780252068 |
46 | 3467873099 | 0 | 0 | 2 | 33 |
0 | 0 | 0 | 0 | 0 | 0 |
84821 | mail_full.2026-06-01_15.52.00_32 | mail_full | B | I |
6 | T | 2026-06-01 15:52:17 | 2026-06-01 15:52:17 | 2026-06-01
15:52:29 | 2026-06-01 15:52:29 | 1780321949 | 29 | 1780252068 |
203 | 27164371 | 0 | 0 | 2 | 31 |
0 | 0 | 0 | 0 | 0 | 0 |
84822 | mail_home.2026-06-01_15.52.00_33 | mail_home | B | I |
6 | T | 2026-06-01 15:52:35 | 2026-06-01 15:52:35 | 2026-06-01
15:54:48 | 2026-06-01 15:54:48 | 1780322088 | 30 | 1780252068 |
44 | 4498804805 | 0 | 0 | 2 | 33 |
0 | 0 | 0 | 0 | 0 | 0 |
84823 | mail_full.2026-06-02_15.52.00_03 | mail_full | B | I |
6 | T | 2026-06-02 15:52:21 | 2026-06-02 15:52:21 | 2026-06-02
15:53:27 | 2026-06-02 15:53:27 | 1780408407 | 1 | 1780407872 |
1501 | 1215916872 | 0 | 0 | 2 | 31 |
0 | 0 | 0 | 0 | 0 | 0 |
84824 | mail_home.2026-06-02_15.52.00_04 | mail_home | B | I |
6 | I | 2026-06-02 15:53:48 | 2026-06-02 15:53:48 | 2026-06-02
15:54:25 | 2026-06-02 15:54:25 | 1780408465 | 2 | 1780407872 |
50 | 436026324 | 0 | 0 | 2 | 33 |
0 | 0 | 0 | 0 | 0 | 0 |
(11 rows)
So the bscan of the full volumes are the only way of
importing the jobs to the catalog.
By the way the job now 84814 could still not recover:
*restore
First you select one or more JobIds that contain files
to be restored. You will be presented several methods
of specifying the JobIds. Then you will be allowed to
select which files from those JobIds are to be restored.
To select the JobIds, you have the following choices:
1: List last 20 Jobs run
2: List Jobs where a given File is saved
3: Enter list of comma separated JobIds to select
4: Enter SQL list command
5: Select the most recent backup for a client
6: Select backup for a client before a specified time
7: Enter a list of files to restore
8: Enter a list of files to restore before a specified time
9: Find the JobIds of the most recent backup for a client
10: Find the JobIds for a backup for a client before a specified time
11: Enter a list of directories to restore for found JobIds
12: Select full restore to a specified Job date
13: Cancel
Select item: (1-13): 3
Enter JobId(s), comma separated, to restore: 84814
You have selected the following JobId: 84814
Building directory tree for JobId(s) 84814 ...
1 files inserted into the tree.
You are now entering file selection mode where you add (mark) and
remove (unmark) files to be restored. No files are initially added, unless
you used the "all" keyword on the command line.
Enter "done" to leave this mode.
cwd is: /
$ add *
2 files marked.
$ lsmark
*var/
*lib/
*bacula/
*bacula.sql.lz4
$ done
Unable to get Job Volume Parameters. ERR=sql_get.c:429 No volumes found for
JobId=84814
Unable to construct a valid BSR. Cannot continue.
I will give up here my tries to recover the file. My goal to append jobs
on the volumes are finished so I restarted all jobs after which has to been
run after last catalog backup which I recovered in the database.
Maybe the imported jobs will work I doesn't trust them enough it will
work (so here only mail_home and mail_backup are relevant so I restarted
a diff backup for both jobs).
What do you think, should I open a bug report/feature
request so jobs could also imported by bscan -b job.bsr
option?
Cheer,
_______________________________________________
Bacula-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/bacula-users
