I have a bunch of volumes that bacula seems to have forgotten about.
Can you explain why?
Also, what SQL/etc can I do to fix it?
Attached are a DB list for the volumes, and the ls -l.
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 214-642-9640 E-Mail: l...@lerctr.org
US Mail: 5708 Sabbia Dr, Round Rock, TX 78665-2106
mediaid | volumename | slot | poolid | mediatype | mediatypeid | labeltype |
firstwritten | lastwritten | labeldate | voljobs |
volfiles | volblocks | volparts | volcloudparts | volmounts | volbytes |
volabytes | volapadding | volholebytes | volholes | voltype | volerrors |
volwrites | volcapacitybytes | lastpartbytes | volstatus | enabled | recycle |
actiononpurge | cacheretention | volretention | voluseduration | maxvoljobs |
maxvolfiles | maxvolbytes | inchanger | storageid | deviceid | mediaaddressing
| volreadtime | volwritetime | endfile | endblock | locationid | recyclecount
| initialwrite | scratchpoolid | recyclepoolid | comment
---------+-------------+------+--------+-----------+-------------+-----------+---------------------+---------------------+---------------------+---------+----------+-----------+----------+---------------+-----------+----------+-----------+-------------+--------------+----------+---------+-----------+-----------+------------------+---------------+-----------+---------+---------+---------------+----------------+--------------+----------------+------------+-------------+--------------+-----------+-----------+----------+-----------------+-------------+--------------+---------+------------+------------+--------------+--------------+---------------+---------------+---------
66 | LERCTR-0066 | 0 | 1 | File | 0 | 0 |
2021-10-20 23:05:09 | 2020-02-03 03:44:47 | 2020-02-02 23:05:00 | 0 |
0 | 0 | 1 | 0 | 7 | 1 | 0
| 0 | 0 | 0 | 1 | 0 | 3980971 |
0 | 225 | Purged | 1 | 1 | 1 |
0 | 0 | 43200 | 0 | 0 |
100000000000 | 0 | 1 | 0 | 0 | 566204
| 3703489328 | 23 | 1 | 0 | 6 |
| 0 | 0 |
67 | LERCTR-0067 | 0 | 1 | File | 0 | 0 |
2021-10-20 23:05:09 | 2020-02-03 21:32:48 | 2020-02-02 23:05:00 | 0 |
0 | 0 | 1 | 0 | 8 | 1 | 0
| 0 | 0 | 0 | 1 | 0 | 3996564 |
0 | 225 | Purged | 1 | 1 | 1 |
0 | 0 | 43200 | 0 | 0 |
100000000000 | 0 | 1 | 0 | 0 | 0
| 3538171047 | 23 | 1 | 0 | 6 |
| 0 | 0 |
79 | LERCTR-0079 | 0 | 1 | File | 0 | 0 |
2021-10-20 23:05:09 | 2020-02-16 00:46:08 | 2020-02-15 23:05:06 | 0 |
0 | 0 | 1 | 0 | 8 | 1 | 0
| 0 | 0 | 0 | 1 | 0 | 3417503 |
0 | 225 | Purged | 1 | 1 | 1 |
0 | 0 | 43200 | 0 | 0 |
100000000000 | 0 | 1 | 0 | 0 | 0
| 3333521226 | 9 | 1 | 0 | 6 |
| 0 | 0 |
88 | LERCTR-0088 | 0 | 1 | File | 0 | 0 |
2021-10-20 23:05:09 | 2020-03-02 04:00:42 | 2020-03-01 23:05:04 | 0 |
0 | 0 | 1 | 0 | 7 | 1 | 0
| 0 | 0 | 0 | 1 | 0 | 4559460 |
0 | 225 | Purged | 1 | 1 | 1 |
0 | 0 | 43200 | 0 | 0 |
100000000000 | 0 | 1 | 0 | 0 | 0
| 4840761786 | 23 | 1 | 0 | 6 |
| 0 | 0 |
90 | LERCTR-0090 | 0 | 1 | File | 0 | 0 |
2021-10-20 23:05:09 | 2020-03-02 06:38:55 | 2020-03-01 23:05:03 | 0 |
0 | 0 | 1 | 0 | 6 | 1 | 0
| 0 | 0 | 0 | 1 | 0 | 5501977 |
0 | 225 | Purged | 1 | 1 | 1 |
0 | 0 | 43200 | 0 | 0 |
100000000000 | 0 | 1 | 0 | 0 | 0
| 5080639980 | 23 | 1 | 0 | 6 |
| 0 | 0 |
96 | LERCTR-0096 | 0 | 1 | File | 0 | 0 |
2021-10-20 23:05:09 | 2020-03-02 20:20:07 | 2020-03-01 23:05:03 | 0 |
0 | 0 | 1 | 0 | 5 | 1 | 0
| 0 | 0 | 0 | 1 | 0 | 5817959 |
0 | 225 | Purged | 1 | 1 | 1 |
0 | 0 | 43200 | 0 | 0 |
100000000000 | 0 | 1 | 0 | 0 | 0
| 4932205408 | 23 | 1 | 0 | 6 |
| 0 | 0 |
97 | LERCTR-0097 | 0 | 1 | File | 0 | 0 |
2021-10-20 23:05:09 | 2020-02-03 23:06:32 | 2020-02-02 23:05:00 | 0 |
0 | 0 | 1 | 0 | 8 | 1 | 0
| 0 | 0 | 0 | 1 | 0 | 3574030 |
0 | 225 | Purged | 1 | 1 | 1 |
0 | 0 | 43200 | 0 | 0 |
100000000000 | 0 | 1 | 0 | 0 | 1034572
| 3026529469 | 5 | 1 | 0 | 6 |
| 0 | 0 |
102 | LERCTR-0102 | 0 | 1 | File | 0 | 0 |
2021-10-20 23:05:09 | 2020-03-02 09:22:26 | 2020-03-01 23:05:04 | 0 |
0 | 0 | 1 | 0 | 5 | 1 | 0
| 0 | 0 | 0 | 1 | 0 | 5237641 |
0 | 225 | Purged | 1 | 1 | 1 |
0 | 0 | 43200 | 0 | 0 |
100000000000 | 0 | 1 | 0 | 0 | 0
| 4888927550 | 23 | 1 | 0 | 6 |
| 0 | 0 |
109 | LERCTR-0109 | 0 | 1 | File | 0 | 0 |
2021-10-20 23:05:09 | 2020-03-03 00:36:10 | 2020-03-01 23:05:03 | 0 |
0 | 0 | 1 | 0 | 9 | 1 | 0
| 0 | 0 | 0 | 1 | 0 | 4165197 |
0 | 225 | Purged | 1 | 1 | 1 |
0 | 0 | 43200 | 0 | 0 |
100000000000 | 0 | 1 | 0 | 0 | 0
| 5553315805 | 10 | 1 | 0 | 6 |
| 0 | 0 |
111 | LERCTR-0111 | 0 | 1 | File | 0 | 0 |
2021-10-20 23:05:09 | 2020-02-08 00:21:10 | 2020-02-07 23:05:04 | 0 |
0 | 0 | 1 | 0 | 9 | 1 | 0
| 0 | 0 | 0 | 1 | 0 | 2037519 |
0 | 225 | Purged | 1 | 1 | 1 |
0 | 0 | 43200 | 0 | 0 |
100000000000 | 0 | 1 | 0 | 0 | 0
| 2014170080 | 3 | 1 | 0 | 6 |
| 0 | 0 |
114 | LERCTR-0114 | 0 | 1 | File | 0 | 0 |
2021-10-20 23:05:09 | 2020-02-10 00:48:16 | 2020-02-09 23:05:03 | 0 |
0 | 0 | 1 | 0 | 8 | 1 | 0
| 0 | 0 | 0 | 1 | 0 | 3125689 |
0 | 225 | Purged | 1 | 1 | 1 |
0 | 0 | 43200 | 0 | 0 |
100000000000 | 0 | 1 | 0 | 0 | 0
| 2893779066 | 7 | 1 | 0 | 6 |
| 0 | 0 |
123 | LERCTR-0123 | 0 | 1 | File | 0 | 0 |
2021-10-20 23:05:09 | 2020-03-06 00:20:03 | 2020-03-05 23:05:04 | 0 |
0 | 0 | 1 | 0 | 5 | 1 | 0
| 0 | 0 | 0 | 1 | 0 | 4915849 |
0 | 225 | Purged | 1 | 1 | 1 |
0 | 0 | 43200 | 0 | 0 |
100000000000 | 0 | 1 | 0 | 0 | 0
| 4756971564 | 3 | 1 | 0 | 6 |
| 0 | 0 |
126 | LERCTR-0126 | 0 | 1 | File | 0 | 0 |
2021-10-20 23:05:09 | 2020-03-08 03:58:46 | 2020-03-07 23:05:16 | 0 |
0 | 0 | 0 | 0 | 9 | 1 | 0
| 0 | 0 | 0 | 1 | 0 | 3620699 |
0 | 0 | Purged | 1 | 1 | 1 |
0 | 0 | 43200 | 0 | 0 |
100000000000 | 0 | 1 | 0 | 0 | 13349030
| 5700025638 | 13 | 3038124218 | 0 | 6 |
| 0 | 0 |
128 | LERCTR-0128 | 0 | 1 | File | 0 | 0 |
2021-10-20 23:05:09 | 2020-02-22 00:25:53 | 2020-02-21 23:05:04 | 0 |
0 | 0 | 1 | 0 | 7 | 1 | 0
| 0 | 0 | 0 | 1 | 0 | 3573519 |
0 | 225 | Purged | 1 | 1 | 1 |
0 | 0 | 43200 | 0 | 0 |
100000000000 | 0 | 1 | 0 | 0 | 0
| 3295023734 | 4 | 1 | 0 | 6 |
| 0 | 0 |
151 | LERCTR-0151 | 0 | 1 | File | 0 | 0 |
2021-10-20 23:05:09 | 2020-03-09 02:22:07 | 2020-03-08 23:05:04 | 0 |
0 | 0 | 0 | 0 | 7 | 1 | 0
| 0 | 0 | 0 | 1 | 0 | 4997373 |
0 | 0 | Purged | 1 | 1 | 1 |
0 | 0 | 43200 | 0 | 0 |
100000000000 | 0 | 1 | 0 | 0 | 0
| 7133011794 | 22 | 3748498437 | 0 | 7 |
| 0 | 0 |
168 | LERCTR-0168 | 0 | 1 | File | 0 | 0 |
2021-10-20 23:05:09 | 2020-02-03 07:06:46 | 2020-02-02 23:05:03 | 0 |
0 | 0 | 1 | 0 | 4 | 1 | 0
| 0 | 0 | 0 | 1 | 0 | 4067204 |
0 | 225 | Purged | 1 | 1 | 1 |
0 | 0 | 43200 | 0 | 0 |
100000000000 | 0 | 1 | 0 | 0 | 0
| 3510695801 | 23 | 1 | 0 | 6 |
| 0 | 0 |
170 | LERCTR-0170 | 0 | 1 | File | 0 | 0 |
2021-10-20 23:05:09 | 2020-02-03 09:28:37 | 2020-02-02 23:05:00 | 0 |
0 | 0 | 1 | 0 | 4 | 1 | 0
| 0 | 0 | 0 | 1 | 0 | 3709113 |
0 | 225 | Purged | 1 | 1 | 1 |
0 | 0 | 43200 | 0 | 0 |
100000000000 | 0 | 1 | 0 | 0 | 0
| 3323585416 | 23 | 1 | 0 | 6 |
| 0 | 0 |
180 | LERCTR-0180 | 0 | 1 | File | 0 | 0 |
1969-12-31 18:00:00 | 2020-03-07 00:42:51 | 2020-03-06 23:05:08 | 0 |
0 | 0 | 0 | 0 | 3 | 1 | 0
| 0 | 0 | 0 | 1 | 0 | 2317727 |
0 | 0 | Purged | 1 | 1 | 1 |
0 | 0 | 43200 | 0 | 0 |
100000000000 | 0 | 1 | 0 | 0 | 0
| 2313254956 | 11 | 2276330789 | 0 | 4 |
| 0 | 0 |
(18 rows)
-rw-r----- 1 bacula bacula 225 Jul 5 2020 LERCTR-0123
-rw-r----- 1 bacula bacula 225 Jul 2 2020 LERCTR-0109
-rw-r----- 1 bacula bacula 225 Jul 1 2020 LERCTR-0088
-rw-r----- 1 bacula bacula 225 Jul 1 2020 LERCTR-0102
-rw-r----- 1 bacula bacula 225 Jul 1 2020 LERCTR-0090
-rw-r----- 1 bacula bacula 225 Jul 1 2020 LERCTR-0096
-rw-r----- 1 bacula bacula 225 Jun 22 2020 LERCTR-0128
-rw-r----- 1 bacula bacula 225 Jun 15 2020 LERCTR-0079
-rw-r----- 1 bacula bacula 225 Jun 9 2020 LERCTR-0111
-rw-r----- 1 bacula bacula 225 Jun 9 2020 LERCTR-0114
-rw-r----- 1 bacula bacula 225 Jun 3 2020 LERCTR-0066
-rw-r----- 1 bacula bacula 225 Jun 3 2020 LERCTR-0097
-rw-r----- 1 bacula bacula 225 Jun 3 2020 LERCTR-0168
-rw-r----- 1 bacula bacula 225 Jun 3 2020 LERCTR-0170
-rw-r----- 1 bacula bacula 225 Jun 3 2020 LERCTR-0067
-rw-r----- 1 bacula bacula 98237778950 Mar 9 2020 LERCTR-0151
-rw-r----- 1 bacula bacula 58872699067 Mar 8 2020 LERCTR-0126
-rw-r----- 1 bacula bacula 49520971046 Mar 7 2020 LERCTR-0180
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
