Hi This will speed up your dbcheck (and tree building before a restore) drastically: Mysql > use bacula; > ALTER TABLE File ADD INDEX (JobId, PathId, FilenameId);
Wait for the index creation to finish (takes some time on a huge db). Bye Roland -----Ursprüngliche Nachricht----- Von: Jeff McCune [mailto:[EMAIL PROTECTED] Gesendet: Freitag, 18. März 2005 20:11 An: Bacula Users Betreff: Re: [Bacula-users] sql_create.c:663 More than one Filename! Warnings Kern Sibbald wrote: > > Given these two points, which you didn't previously mention, unless I > missed something else, I would say there is a problem. You should > fill out a bug report with bugs.bacula.org and specify the details of what is happening. > I'm running into the sql_create.c:663 error message on all of my jobs. My database is heavily populated and not virgin. I do not have "Multiple Connections" anywhere in my config files. I'm trying to run dbcheck as you mentioned, running fixes on ALL the checks. I'm having trouble telling if it's wedged itself or if it's still working. Here's what I'm getting: [EMAIL PROTECTED] bacula]# /usr/sbin/dbcheck -c /etc/bacula/bacula-dir.conf -f Hello, this is the database check/correct program. Modify database is On. Verbose is Off. Please select the fuction you want to perform. 1) Toggle modify database flag 2) Toggle verbose flag 3) Repair bad Filename records 4) Repair bad Path records 5) Eliminate duplicate Filename records 6) Eliminate duplicate Path records 7) Eliminate orphaned Jobmedia records 8) Eliminate orphaned File records 9) Eliminate orphaned Path records 10) Eliminate orphaned Filename records 11) Eliminate orphaned FileSet records 12) Eliminate orphaned Client records 13) Eliminate orphaned Job records 14) Eliminate all Admin records 15) Eliminate all Restore records 16) All (3-15) 17) Quit Select function number: 16 Checking for Filenames with a trailing slash Found 0 bad Filename records. Checking for Paths without a trailing slash Found 0 bad Path records. Checking for duplicate Filename entries. Found 0 duplicate Filename records. Checking for duplicate Path entries. Found 0 duplicate Path records. Checking for orphaned JobMedia entries. Found 0 orphaned JobMedia records. Checking for orphaned File entries. This may take some time! Found 0 orphaned File records. Checking for orphaned Path entries. This may take some time! Found 0 orphaned Path records. Checking for orphaned Filename entries. This may take some time! (Note this is the second time I've run this, so it didn't find any problems this run, but it "stops" at the same place.) mytop is showing me: MySQL on localhost (3.23.58) up 0+23:04:03 [14:07:56] Queries: 32.5k qps: 0 Slow: 3.0 Se/In/Up/De(%): 00/00/00/00 qps now: 0 Slow qps: 0.0 Threads: 2 (2/0) 00/00/00/00 Key Efficiency: -106.3% Bps in/out: 8.4/600.4 Now in/out: 8.4/603.6 Id User Host/IP DB Time Cmd Query or State -- ---- ------- -- ---- --- ---------- 3 root localhost bacula 0 Query show full 4 bacula localhost bacula 75301 Query SELECT Filename.FilenameId,File.FilenameId FROM Filename LEFT OUTER JOIN File ON (Filename.FilenameId=File.FilenameId) WHERE File.FilenameId IS *truncated* So... That one querey has been running for 75,301 seconds... And I'm getting a key efficiency of -106%. Is this thing ever gonna finish? Should I scrap my database and rebuild the tables from my last set of full backups? Regards, -- Jeff McCune OSU Department of Mathematics System Support (614) 292-4962 gpg --keyserver pgp.mit.edu --recv-key BAF3211A ------------------------------------------------------- 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_ide95&alloc_id396&op=click _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
