> On Dec 18, 2017, at 9:59 AM, Claudia Koch <ck...@telecolumbus.net> wrote: > > Hello list, > > I am using Bacula 5.2.6 on Debian 8 with mysql. The database dump is 82 > GB (with --add-drop-database --add-drop-table --allow-keywords > --single-transaction). > > I had checked the database for the remains of old clients and deleted > old entries with "purge jobid=xxxx". > > My problem is that as far as possible (backups, database queries etc.). > But I can't recover anymore. > > After selecting the client, the tapes used are still displayed, but > creating the file list does not come to an end. > > The last select is a rather cryptic construct. A tmp-table is created, > but apparently not filled. A CPU runs on 100% but the process never ends. > > What is it possible to check what goes wrong? How can a database of this > size (among other things, various mail servers with many small files are > backed up) be cleaned up in such a way that it can be used afterwards? > > I have had similar experiences with dbcheck in the past.
Never ends? How long have you waited? How many files are in that backup? -- Dan Langille - BSDCan / PGCon d...@langille.org ------------------------------------------------------------------------------ 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
