Okay, so your question is really: why are some (the majority) of the removed machines not detected as "orphaned" by dbcheck?
I'll have to pass that one on as I don't know about the inner workings of dbcheck's orphaned clients check. Perhaps it is not considering clients as orphaned as long as the catalog still lists backup jobs from them. On Tue, May 29, 2018, at 10:02, Steffen Schwebel wrote: > Thanks for your response. > > But Im not sure what to tell you. > > The Mysql Table bacula.Client has ~100 more entires than the output from > bconsole. > These are mostly machines the got removed from the bacula COnfiguration > but linger on in the database. > > I assume thats why the helper script dbcheck exists in the first place. > But even that will only give me a few out of the hundred I found. > > > On 05/28/2018 09:15 PM, Tilman Schmidt wrote: > > You may want to have a look at the raw result of the two commands > > > > mysql bacula -e "select * from Client" -ss > > echo "status client" | bconsole > > > > After saving both to files and massaging them a bit with sed or a > > similar tool, you should be able to feed them to diff and find out where > > the difference comes from. > > > > Am 28.05.2018 um 16:59 schrieb Steffen Schwebel: > >> Hello, > >> > >> Ive been working with Bacula and see a discrepany I cant explain: > >> > >> mysql bacula -e "select * from Client" -ss | wc -l > >> 336 > >> > >> echo "status client" | bconsole | wc -l > >> 241 > >> > >> I tried to use the dbcheck to correct this mismatch. > >> But that is showing me 16 orhpaned clients. It should close to a hundred. > >> > >> What am I missing? > >> > >> > >> Best regards, > >> Steffen Schwebel > > > > ------------------------------------------------------------------------------ > > Check out the vibrant tech community on one of the world's most > > engaging tech sites, Slashdot.org! http://sdm.link/slashdot > > _______________________________________________ > > Bacula-users mailing list > > Bacula-users@lists.sourceforge.net > > https://lists.sourceforge.net/lists/listinfo/bacula-users > > > ------------------------------------------------------------------------------ > Check out the vibrant tech community on one of the world's most > engaging tech sites, Slashdot.org! http://sdm.link/slashdot > _______________________________________________ > Bacula-users mailing list > Bacula-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/bacula-users -- Tilman Schmidt til...@imap.cc ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
