Re: [Bacula-users] Help! "Duplicate entry" dbcheck doesn't fix it?!?

[Michael Joyner]

What's describe File; look like?
mysql> describe File;
+------------+------------------+------+-----+---------+----------------+
| Field      | Type             | Null | Key | Default | Extra
+------------+------------------+------+-----+---------+----------------+
| FileId     | int(10) unsigned |      | PRI | NULL    | auto_increment
| FileIndex  | int(10) unsigned |      |     | 0       |
| JobId      | int(10) unsigned |      |     | 0       |
| PathId     | int(10) unsigned |      |     | 0       |
| FilenameId | int(10) unsigned |      | MUL | 0       |
| MarkId     | int(10) unsigned |      |     | 0       |
| LStat      | tinyblob         |      |     |         |
| MD5        | tinyblob         |      |     |         |
+------------+------------------+------+-----+---------+----------------+
8 rows in set (0.00 sec)
 > I'm still perplexed about your problem though.  Dropping the index on
FilenameId and Path shouldn't change the constraints on the tables at 
all...

Weird.
Yes, WEIRD.
What is even weirder is that I have two machines doing it.
Both are SuSE with the pre-packaged MySQL and a pre-packaged bacula.
I wonder if there is something weird about the pre-packaged MySQL ???
I tried installing the MySQL rpm from the mysql.com site, but ran 
immediately into dependency/conflict problems with my system wanting to 
erase my bacula.

-------------------------------------------------------
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users