[Bacula-users] Database index problem? dbcheck runs forever

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

I'm assuming this is a DB index problem. dbcheck never completes, and I
suspect I have a lot of stale garbage in my catalog DB.

In any case, here are my indexes:

mysql> show index from File;
+-------+------------+----------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
| Table | Non_unique | Key_name       | Seq_in_index | Column_name |
Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment |
+-------+------------+----------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
| File  |          0 | PRIMARY        |            1 | FileId      | A
       |     3591688 |     NULL | NULL   |      | BTREE      |         |
| File  |          1 | JobId          |            1 | JobId       | A
       |         131 |     NULL | NULL   |      | BTREE      |         |
| File  |          1 | JobId          |            2 | PathId      | A
       |      276283 |     NULL | NULL   |      | BTREE      |         |
| File  |          1 | JobId          |            3 | FilenameId  | A
       |     3591688 |     NULL | NULL   |      | BTREE      |         |
| File  |          1 | file_jobid_idx |            1 | JobId       | A
       |         131 |     NULL | NULL   |      | BTREE      |         |
+-------+------------+----------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+

...since I don't understand these very well, I figured I'd at least
check my indexes by attempting to create those that might be missing.
Check this out:

mysql> CREATE INDEX file_jpf_idx on File (Job, FilenameId, PathId);
ERROR 1072 (42000): Key column 'Job' doesn't exist in table

...should that concern me perhaps?

- --
 ---- _  _ _  _ ___  _  _  _
 |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.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFIpQa6mb+gadEcsb4RAjgMAKCxP6KsayeYGSwbQvZtIdH5ZE07XgCgrg4a
BMDQmXazZdkBBZLxOoOlJZQ=
=d9GR
-----END PGP SIGNATURE-----

novosirj.vcf
Description: Vcard

-------------------------------------------------------------------------
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