-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hello again, all:

I've written about this before at least twice and it seems that everyone
is either ignoring it or has no insights. I would really appreciate some
help here if anyone has anything to offer. It looks like if not, I'm
left to drop my database and scan back all the tapes because it really
cannot continue like this.

I am running Bacula 2.2.8 from the Blastwave packages on Solaris 9,
which use MySQL 5.0.51. I have had this database awhile, so I figured I
would go through and try to clean it up. I have clients that are no
longer being backed up, maybe some old tapes -- the kind of stuff that
dbcheck cleans up.

The problem is, dbcheck never seems to finish. I'm not sure if it ever
will, but it cannot be completed in the nearly 72 hours on the weekend
that I can allow it to run before it starts to impact production
backups. Here is what it's doing:

| 187 | bacula | localhost | bacula | Query   | 198111 | Copying to tmp
table | SELECT DISTINCT Path.PathId,File.PathId FROM Path LEFT OUTER
JOIN File ON (Path.PathId=File.PathId)

As far as I can tell, I have every index that is listed in the manual.
If someone is interested to see them, I will paste them, though as I
said I've done that before a number of times and no one has been
interested. Before I dig them up, perhaps someone can offer some help.

Thank you!

- --
~ ---- _  _ _  _ ___  _  _  _
~ |Y#| |  | |\/| |  \ |\ |  | |Ryan Novosielski - Systems Programmer II
~ |$&| |__| |  | |__/ | \| _| |novosirj AT umdnj DOT edu - 973/972.0922 (2-0922)
~ \__/ Univ. of Med. and Dent.|IST/AST - NJMS Medical Science Bldg - C630
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.5 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFIqYS/mb+gadEcsb4RAv/OAJ0aij06NqEj4x8ZSawXoSgtJSBmFQCgjFsZ
6Sm1utw2gL4CAG7cad3Gttc=
=2a7j
-----END PGP SIGNATURE-----

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users