[bareos-users] bareos - VolBytes doesen't sum up ...

[Oliver Fink]

Hello,

I have a small job which runs after the backup jobs.
It should show the tape-uasge:

"SELECT Slot,MediaId,VolStatus,VolumeName,Pool.Name AS Pool, round(VolBytes / (1024*1024*1024) , 2) AS "GB-gesamt" FROM Media,Pool WHERE Media.PoolId=Pool.PoolId AND Media.InChanger=1 ORDER BY Slot;"

But VolBytes stays the same - it doesn't sum up - although the backups do work!

Does anybody know how I can correct this behaviour?

Thanks in advance
Olli

[diamaunt]

Post by Oliver Fink
Hello,
I have a small job which runs after the backup jobs.
"SELECT Slot,MediaId,VolStatus,VolumeName,Pool.Name AS Pool, round(VolBytes / (1024*1024*1024) , 2) AS "GB-gesamt" FROM Media,Pool WHERE Media.PoolId=Pool.PoolId AND Media.InChanger=1 ORDER BY Slot;"
But VolBytes stays the same - it doesn't sum up - although the backups do work!
Does anybody know how I can correct this behaviour?
Thanks in advance
Olli

What do you mean it doesn't "sum up"?

I ran it, and the report I got matches the report from the webui, with one important distinction...

in the webui, they are dividing volbytes by 1000000000, not 1073741824, ie a straight "gig" not a binary "gig".

[Oliver Fink]

Post by diamaunt

Post by Oliver Fink
Hello,
I have a small job which runs after the backup jobs.
"SELECT Slot,MediaId,VolStatus,VolumeName,Pool.Name AS Pool, round(VolBytes / (1024*1024*1024) , 2) AS "GB-gesamt" FROM Media,Pool WHERE Media.PoolId=Pool.PoolId AND Media.InChanger=1 ORDER BY Slot;"
But VolBytes stays the same - it doesn't sum up - although the backups do work!
Does anybody know how I can correct this behaviour?
Thanks in advance
Olli

What do you mean it doesn't "sum up"?
I ran it, and the report I got matches the report from the webui, with one important distinction...
in the webui, they are dividing volbytes by 1000000000, not 1073741824, ie a straight "gig" not a binary "gig".

Hi diamaunt,

I get a report like this:
#############################
Connecting to Director localhost:9101
1000 OK: bareos-dir Version: 17.2.4 (21 Sep 2017) Enter a period to cancel a command.
sqlquery
Automatically selected Catalog: MyCatalog Using Catalog "MyCatalog"
Entering SQL query mode.
Terminate each query with a semicolon.
Terminate query mode with a blank line.
Enter SQL query: SELECT Slot,MediaId,VolStatus,VolumeName,Pool.Name AS Pool, round(VolBytes / (1024*1024*1024) , 2) AS "GB-gesamt" FROM Media,Pool WHERE Media.PoolId=Pool.PoolId AND Media.InChanger=1 ORDER BY Slot;
+------+---------+-----------+------------+-------+-----------+
| slot | mediaid | volstatus | volumename | pool | GB-gesamt |
+------+---------+-----------+------------+-------+-----------+
| 1 | 22 | Full | A00021L5 | Full | 3394.00 |
| 2 | 23 | Append | A00022L5 | Full | 1816.00 |
| 3 | 24 | Append | A00023L5 | Full | 0.00 |
| 4 | 25 | Append | A00024L5 | Full | 0.00 |
| 5 | 26 | Append | A00025L5 | Diff | 1140.00 |
| 6 | 27 | Append | A00026L5 | Diff | 0.00 |
| 7 | 28 | Append | A00007L6 | Monat | 1465.00 |
+------+---------+-----------+------------+-------+-----------+
#############################

And the column GB-gesamt is the same as yesterday although there were some backups.

But on the web-ui it shows the right amounts....


Is there something like a cache I could rebuild .... ??????


Greetings Olli