Re: [Vchanger-users] Again wrong media and volume on error.../2
Brought to you by:
jaybus2
Menu
▾
▴
Re: [Vchanger-users] Again wrong media and volume on error.../2
|
From: Marco G. <ga...@li...> - 2023-05-11 11:10:28
|
Mandi! Josh Fisher via Vchanger-users In chel di` si favelave... > See my previous post. I believe the update slots is not happening after > the disk is ejected and BEFORE the job is run. Seemy previous post, seems get run. ;-) > Also, the below SQL can be put it your query.sql file to define a menu > item for the bconsole query command that will list volumes that bacula > thinks are in a slot (or "in changer"). Interesting... different situation, similar trouble. Volume status: *list media pool=PUG-BR-BRPVE2RDXPool Automatically selected Catalog: BaculaLNF Using Catalog "BaculaLNF" +---------+---------------------+-----------+---------+-----------------+----------+--------------+---------+------+-----------+-----------+---------+----------+---------------------+-----------+ | mediaid | volumename | volstatus | enabled | volbytes | volfiles | volretention | recycle | slot | inchanger | mediatype | voltype | volparts | lastwritten | expiresin | +---------+---------------------+-----------+---------+-----------------+----------+--------------+---------+------+-----------+-----------+---------+----------+---------------------+-----------+ | 95 | BRPVE2RDX_0000_0000 | Used | 1 | 208,849,026 | 0 | 1,728,000 | 1 | 0 | 0 | RDX | 1 | 0 | 2023-04-26 23:00:36 | 479,584 | | 96 | BRPVE2RDX_0000_0001 | Used | 1 | 30,271,526 | 0 | 1,728,000 | 1 | 0 | 0 | RDX | 1 | 0 | 2023-04-23 23:00:20 | 220,368 | | 97 | BRPVE2RDX_0000_0002 | Used | 1 | 245,449,879,830 | 57 | 1,728,000 | 1 | 0 | 0 | RDX | 1 | 0 | 2023-04-21 22:53:45 | 47,173 | | 98 | BRPVE2RDX_0000_0003 | Used | 1 | 2,728,283 | 0 | 1,728,000 | 1 | 0 | 0 | RDX | 1 | 0 | 2023-04-27 23:00:11 | 565,959 | | 99 | BRPVE2RDX_0000_0004 | Used | 1 | 67,134,269,206 | 15 | 1,728,000 | 1 | 0 | 0 | RDX | 1 | 0 | 2023-04-21 21:04:17 | 40,605 | | 100 | BRPVE2RDX_0000_0005 | Used | 1 | 32,143,254 | 0 | 1,728,000 | 1 | 0 | 0 | RDX | 1 | 0 | 2023-04-22 23:02:44 | 134,112 | | 101 | BRPVE2RDX_0000_0006 | Used | 1 | 83,933,767 | 0 | 1,728,000 | 1 | 0 | 0 | RDX | 1 | 0 | 2023-04-27 23:00:29 | 565,977 | | 102 | BRPVE2RDX_0000_0007 | Used | 1 | 2,101,942 | 0 | 1,728,000 | 1 | 0 | 0 | RDX | 1 | 0 | 2023-04-22 23:00:21 | 133,969 | | 103 | BRPVE2RDX_0000_0008 | Used | 1 | 31,871,214 | 0 | 1,728,000 | 1 | 0 | 0 | RDX | 1 | 0 | 2023-04-23 23:02:01 | 220,469 | | 104 | BRPVE2RDX_0000_0009 | Used | 1 | 42,334,248,183 | 9 | 1,728,000 | 1 | 0 | 0 | RDX | 1 | 0 | 2023-04-23 02:05:27 | 145,075 | | 175 | BRPVE2RDX_0001_0000 | Error | 1 | 1 | 0 | 1,728,000 | 1 | 0 | 0 | RDX | 1 | 0 | 2023-04-16 23:00:25 | 0 | | 176 | BRPVE2RDX_0001_0001 | Error | 1 | 1 | 0 | 1,728,000 | 1 | 0 | 0 | RDX | 1 | 0 | 2023-04-18 23:00:13 | 0 | | 177 | BRPVE2RDX_0001_0002 | Error | 1 | 1 | 0 | 1,728,000 | 1 | 0 | 0 | RDX | 1 | 0 | 2023-04-14 21:03:10 | 0 | | 178 | BRPVE2RDX_0001_0003 | Error | 1 | 1 | 0 | 1,728,000 | 1 | 0 | 0 | RDX | 1 | 0 | 2023-04-17 23:05:50 | 0 | | 179 | BRPVE2RDX_0001_0004 | Error | 1 | 1 | 0 | 1,728,000 | 1 | 0 | 0 | RDX | 1 | 0 | 2023-04-19 23:00:14 | 0 | | 180 | BRPVE2RDX_0001_0005 | Error | 1 | 1 | 0 | 1,728,000 | 1 | 0 | 0 | RDX | 1 | 0 | 2023-04-17 23:00:13 | 0 | | 181 | BRPVE2RDX_0001_0006 | Error | 1 | 1 | 0 | 1,728,000 | 1 | 0 | 0 | RDX | 1 | 0 | 2023-04-19 23:00:32 | 0 | | 182 | BRPVE2RDX_0001_0007 | Error | 1 | 1 | 0 | 1,728,000 | 1 | 0 | 0 | RDX | 1 | 0 | 2023-04-18 23:05:35 | 0 | | 183 | BRPVE2RDX_0001_0008 | Error | 1 | 1 | 0 | 1,728,000 | 1 | 0 | 0 | RDX | 1 | 0 | 2023-04-21 09:10:45 | 0 | | 184 | BRPVE2RDX_0001_0009 | Error | 1 | 1 | 0 | 1,728,000 | 1 | 0 | 0 | RDX | 1 | 0 | 2023-04-20 23:00:13 | 0 | | 275 | BRPVE2RDX_0002_0000 | Used | 1 | 1,798,243 | 0 | 1,728,000 | 1 | 1 | 1 | RDX | 1 | 0 | 2023-05-09 23:00:12 | 1,602,760 | | 276 | BRPVE2RDX_0002_0001 | Used | 1 | 1,704,328 | 0 | 1,728,000 | 1 | 2 | 1 | RDX | 1 | 0 | 2023-05-08 23:00:14 | 1,516,362 | | 277 | BRPVE2RDX_0002_0002 | Used | 1 | 29,739,131 | 0 | 1,728,000 | 1 | 3 | 1 | RDX | 1 | 0 | 2023-05-08 09:30:34 | 1,467,782 | | 278 | BRPVE2RDX_0002_0003 | Used | 1 | 70,855,889 | 0 | 1,728,000 | 1 | 4 | 1 | RDX | 1 | 1 | 2023-05-09 23:00:28 | 1,602,776 | | 279 | BRPVE2RDX_0002_0004 | Used | 1 | 2,646,417 | 0 | 1,728,000 | 1 | 5 | 1 | RDX | 1 | 1 | 2023-05-10 23:00:14 | 1,689,162 | | 280 | BRPVE2RDX_0002_0005 | Used | 1 | 75,205,456 | 0 | 1,728,000 | 1 | 6 | 1 | RDX | 1 | 0 | 2023-05-02 23:00:35 | 997,983 | | 281 | BRPVE2RDX_0002_0006 | Used | 1 | 49,188,203 | 0 | 1,728,000 | 1 | 7 | 1 | RDX | 1 | 0 | 2023-05-08 09:31:03 | 1,467,811 | | 282 | BRPVE2RDX_0002_0007 | Used | 1 | 1,974,592 | 0 | 1,728,000 | 1 | 8 | 1 | RDX | 1 | 0 | 2023-05-04 23:00:12 | 1,170,760 | | 283 | BRPVE2RDX_0002_0008 | Used | 1 | 42,406,838,890 | 9 | 1,728,000 | 1 | 9 | 1 | RDX | 1 | 0 | 2023-05-08 09:35:08 | 1,468,056 | | 284 | BRPVE2RDX_0002_0009 | Used | 1 | 125,260,576 | 0 | 1,728,000 | 1 | 10 | 1 | RDX | 1 | 1 | 2023-05-08 23:00:32 | 1,516,380 | | 716 | BRPVE2RDX_0001_0010 | Error | 1 | 1 | 0 | 1,728,000 | 1 | 0 | 0 | RDX | 1 | 0 | 2023-04-15 23:00:13 | 0 | | 717 | BRPVE2RDX_0001_0011 | Error | 1 | 1 | 0 | 1,728,000 | 1 | 0 | 0 | RDX | 1 | 0 | 2023-04-15 23:02:20 | 0 | | 718 | BRPVE2RDX_0001_0012 | Error | 1 | 1 | 0 | 1,728,000 | 1 | 0 | 0 | RDX | 1 | 0 | 2023-04-16 02:07:58 | 0 | | 719 | BRPVE2RDX_0001_0013 | Error | 1 | 1 | 0 | 1,728,000 | 1 | 0 | 0 | RDX | 1 | 0 | 2023-04-16 23:01:24 | 0 | | 720 | BRPVE2RDX_0001_0014 | Error | 1 | 1 | 0 | 1,728,000 | 1 | 0 | 0 | RDX | 1 | 0 | 2023-04-14 22:53:33 | 0 | | 731 | BRPVE2RDX_0000_0010 | Used | 1 | 2,126,555 | 0 | 1,728,000 | 1 | 0 | 0 | RDX | 1 | 0 | 2023-04-24 23:00:23 | 306,771 | | 732 | BRPVE2RDX_0000_0011 | Used | 1 | 22,547,597 | 0 | 1,728,000 | 1 | 0 | 0 | RDX | 1 | 0 | 2023-04-25 23:00:38 | 393,186 | | 733 | BRPVE2RDX_0000_0012 | Used | 1 | 1,237,550 | 0 | 1,728,000 | 1 | 0 | 0 | RDX | 1 | 0 | 2023-04-25 23:00:23 | 393,171 | | 734 | BRPVE2RDX_0000_0013 | Used | 1 | 2,052,329 | 0 | 1,728,000 | 1 | 0 | 0 | RDX | 1 | 0 | 2023-04-26 23:00:20 | 479,568 | | 735 | BRPVE2RDX_0000_0014 | Used | 1 | 37,422,681 | 0 | 1,728,000 | 1 | 0 | 0 | RDX | 1 | 0 | 2023-04-24 23:00:48 | 306,796 | | 740 | BRPVE2RDX_0002_0010 | Used | 1 | 3,148,955 | 0 | 1,728,000 | 1 | 11 | 1 | RDX | 1 | 0 | 2023-05-02 23:00:36 | 997,984 | | 741 | BRPVE2RDX_0002_0011 | Used | 1 | 95,135,350 | 0 | 1,728,000 | 1 | 12 | 1 | RDX | 1 | 0 | 2023-05-04 23:00:29 | 1,170,777 | | 742 | BRPVE2RDX_0002_0012 | Used | 1 | 30,921,050 | 0 | 1,728,000 | 1 | 13 | 1 | RDX | 1 | 0 | 2023-05-03 23:00:16 | 1,084,364 | | 743 | BRPVE2RDX_0002_0013 | Used | 1 | 245,887,157,874 | 57 | 1,728,000 | 1 | 14 | 1 | RDX | 1 | 0 | 2023-05-05 22:24:18 | 1,255,006 | | 744 | BRPVE2RDX_0002_0014 | Used | 1 | 121,686,143 | 0 | 1,728,000 | 1 | 15 | 1 | RDX | 1 | 0 | 2023-05-03 23:00:34 | 1,084,382 | +---------+---------------------+-----------+---------+-----------------+----------+--------------+---------+------+-----------+-----------+---------+----------+---------------------+-----------+ practically media 3 (2) are loaded, but volumes are all exausted. So bacula try to use the (just purged) volume in media 2 (1). If i run your query (thanks!): root@lnfbacula:/etc/bacula# echo "query 2" | bconsole | grep " BRPVE2" | 275 | BRPVE2RDX_0002_0000 | 0 | BRPVE2RDX | 1 | PUG-BR-BRPVE2RDXPool | RDX | Used | | 276 | BRPVE2RDX_0002_0001 | 0 | BRPVE2RDX | 2 | PUG-BR-BRPVE2RDXPool | RDX | Used | | 277 | BRPVE2RDX_0002_0002 | 0 | BRPVE2RDX | 3 | PUG-BR-BRPVE2RDXPool | RDX | Used | | 278 | BRPVE2RDX_0002_0003 | 0 | BRPVE2RDX | 4 | PUG-BR-BRPVE2RDXPool | RDX | Used | | 279 | BRPVE2RDX_0002_0004 | 0 | BRPVE2RDX | 5 | PUG-BR-BRPVE2RDXPool | RDX | Used | | 280 | BRPVE2RDX_0002_0005 | 0 | BRPVE2RDX | 6 | PUG-BR-BRPVE2RDXPool | RDX | Used | | 281 | BRPVE2RDX_0002_0006 | 0 | BRPVE2RDX | 7 | PUG-BR-BRPVE2RDXPool | RDX | Used | | 282 | BRPVE2RDX_0002_0007 | 0 | BRPVE2RDX | 8 | PUG-BR-BRPVE2RDXPool | RDX | Used | | 283 | BRPVE2RDX_0002_0008 | 39 | BRPVE2RDX | 9 | PUG-BR-BRPVE2RDXPool | RDX | Used | | 284 | BRPVE2RDX_0002_0009 | 0 | BRPVE2RDX | 10 | PUG-BR-BRPVE2RDXPool | RDX | Used | | 740 | BRPVE2RDX_0002_0010 | 0 | BRPVE2RDX | 11 | PUG-BR-BRPVE2RDXPool | RDX | Used | | 741 | BRPVE2RDX_0002_0011 | 0 | BRPVE2RDX | 12 | PUG-BR-BRPVE2RDXPool | RDX | Used | | 742 | BRPVE2RDX_0002_0012 | 0 | BRPVE2RDX | 13 | PUG-BR-BRPVE2RDXPool | RDX | Used | | 743 | BRPVE2RDX_0002_0013 | 229 | BRPVE2RDX | 14 | PUG-BR-BRPVE2RDXPool | RDX | Used | | 744 | BRPVE2RDX_0002_0014 | 0 | BRPVE2RDX | 15 | PUG-BR-BRPVE2RDXPool | RDX | Used | and seems all correct, as expected. -- Il settimo dice non ammazzare se del cielo vuoi esssere degno. Guardatela oggi, questa legge di Dio, tre volte inchiodata nel legno (F. De Andre`) |
