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: Josh F. <jf...@ja...> - 2023-05-11 14:04:22
|
On 5/11/23 06:59, Marco Gaiarin wrote: > 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). Yes. That certainly seems like a logic bug to me. My opinion is that Bacula should not try to load a volume that is not in one of the changer's slots. I understand why it picks the only available volumes, but it should send a operator notice to load the volume. It should not be trying to load and use it. > > 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. > |
