Hello everyone,
I use Bacula for 3 months and I am happy to use it.
However I have several problems with the GUI Baculum.
In Baculum, I have problem to restore files with path contains '
character like "D:\Data\l'information"
I can see in baculum the folder but when I select it, I can't browse
into, the sub folder is empty.
I can restore upper folder but it's not a great job.
Any advice to browse in baculum with folders with special character ?
I have a lot...
Another problem with Baculum :
Randomly, I have some lag (about 20 minutes) when I select a "group
most recent backup" or one full backup in the list.
My postgresql DB is working at 100% on 1CPU/8 for about 20 minutes.
I optimize my postgresql DB and with pg_stat_statements, I found the
slow bacula query (sorry for presentation) :
postgres=# SELECT *
FROM
pg_stat_statements
ORDER BY
total_time DESC;
userid | dbid | queryid | query | calls | total_time |
min_time | max_time | mean_time | stddev_time
| rows | shared_blks_hit | shared_blks_read | shared_blks_dirtied
| shared_blks_written | local_blks_hit | local_blks_read |
local_blks_dirtied | local_blks_written | temp_blks_read |
temp_blks_written | blk_read_time | blk_write_time
10 | 16384 | 1980744281 | INSERT INTO PathVisibility (PathId,
JobId) SELECT a.PathId,$1 FROM ( SELECT DISTINCT h.PPathId AS PathId
FROM PathHierarchy AS h JOIN P
athVisibility AS p ON (h.PathId=p.PathId) WHERE p.JobId=$2) AS a LEFT
JOIN (SELECT PathId FROM PathVisibility WHERE JobId=$3) AS b ON
(a.PathId = b.PathId) WHERE b.Path
Id IS NULL | 60 | 1478982.747849 | 0.225819 |
484839.953712 | 24649.71246415 | 105518.8118646
13 | 4074 | 205691266 | 165 |
62 | 0 | 0 | 0 |
0 |
0 | 1011 | 1014 | 0 | 0
I am not sure it is a DB problem rather a bacula optimization but what ?
According to my stats, I have :
- 5.31 TB of data saved, around 13M files
- Bacula DB 5,18 Go
- Fileset : 82
OS : CentOS 7.5.1804
Postgresql : 10.6
Bacula : 9.2.1-1-el7
Postgresql.conf tweaks :
max_connections = 100
shared_buffers = 2016MB
maintenance_work_mem = 512MB
effective_cache_size = 6GB
max_worker_processes = 8
max_parallel_workers_per_gather = 2
max_parallel_workers = 8
Hardware
HP Proliant server (2017)
CPU Xeon 4/8 cores
Memory : 8 Go
HD in RAID 5 (no SSD)
Off topic question : is there another web GUI to restore files easily ?
Thank you for your help
PS : sorry for my approximate english.
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
