Hi List,
using BareOS 16.2.4 on CentOS 7.
After removing a client from the Director, it still shows up every now
and then in certain bconsole queries, for instance "list jobs last"
shows jobs from clients that were removed in 2016. The executable
bareos-dbcheck doesn't seem to help here.
When I want to remove this client _entirely_ from the db, should I:
1. SELECT * FROM Client WHERE Name = 'my_removed_client-fd'; -- note
the ClientId
2. SELECT JobID FROM Job WHERE ClientId = ClientId_From_Above; -- get a
number of jobs
3. -- for each JobID from above:
SELECT PathId,FilenameId FROM File WHERE JobId = Each_JobID;
4. -- for each PathId from above:
DELETE FROM Path WHERE PathId = Each_PathId;
-- for each FilenameId from above:
DELETE FROM Filename WHERE FilenameId = Each_FilenameId
5. -- then, for each JobId from above:
DELETE FROM File WHERE JobId = Each_JobID;
-- and then for the ClientId:
DELETE FROM Job WHERE ClientId = ClientId_From_Above;
DELETE FROM Client WHERE ClientId = ClientId_From_Above;
Or should I just forget about it because I am going to create a DB with
loose ends?
Thanks in advance for an answer!
Best regards,
Arjen Van Drie.
--
You received this message because you are subscribed to the Google Groups
"bareos-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to bareos-users+unsubscr...@googlegroups.com.
To post to this group, send email to bareos-users@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
