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

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

Ryan Novosielski wrote:
> 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?

Incidentally, the rel-manual says "JobId" not "Job". Is this a
documentation error, or has this table changed?

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

iD8DBQFIpQdVmb+gadEcsb4RAt49AJ9lpnFUn+p5FMs6UvrUWI7VFzHLIgCghL1p
TZLudwd3iZVtVhUoQNIqUEg=
=wnGG
-----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