In a mid-sized bacula installation (debian buster based, so bacula 9.4) i've
renamed some clients and pool, so i wanted to do a 'dbcheck' to cleanup the
database.
But postgres get killed by OOM:
root@lnfbacula:~# dbcheck -b -d 10 /var/lib/bacula bacula bacula password
Checking for Paths without a trailing slash
Found 1 bad Path records.
Checking for Filenames with a trailing slash
Found 0 bad Filename records.
Checking for duplicate Filename entries.
Found 0 duplicate Filename records.
Checking for duplicate Path entries.
Found 0 duplicate Path records.
Checking for orphaned JobMedia entries.
Checking for orphaned File entries. This may take some time!
Checking for orphaned Path entries. This may take some time!
WARNING: terminating connection because of crash of another server process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited abnormally
and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and repeat
your command.
Query failed: SELECT DISTINCT Path.PathId,File.PathId FROM Path LEFT OUTER
JOIN File ON (Path.PathId=File.PathId) WHERE File.PathId IS NULL LIMIT 300000:
ERR=server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
I've tried to lieave more RAM to the VM that run the direcod (and the DB),
first 8, the 16 now i try with 32GB, but...
Thanks.
--
Vedi, è che in gastronomia ci sono quello che mangia e quello che cucina.
Nella nostra politica, quello che cucina, manca??? (Emanuele Pucciarelli)
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
