[EMAIL PROTECTED] wrote:
Hello list,
I think because of a power-outage my sql-database is crashed. If a
job starts I get the following errors for example:
21-Jul 09:18 sc-7110-001-bu1-dir: Sc-7110-001-bu1.2005-07-21_09.00.00
Fatal error: sql_create.c:566 Create db File record INSERT INTO File
(FileIndex,JobId,PathId,FilenameId,LStat,MD5) VALUES
(19347,107,261,16381,'gh BbY/ IGk B A A A d5 BAA Q BC3fqW BBOfQm
BB2mpP A A C','0') failed. ERR=Can't open file: 'File.MYD'. (errno:
145) Can't open file: 'File.MYD'. (errno: 145) 21-Jul 09:18
sc-7110-001-bu1-dir: sql_update.c:65 UPDATE File SET
MD5='Y/96qGh8yj//DDUOU9I3KC' WHERE FileId=0 21-Jul 09:18
sc-7110-001-bu1-dir: Sc-7110-001-bu1.2005-07-21_09.00.00 Error:
Catalog error updating MD5/SHA1. sql_update.c:65 update UPDATE File
SET MD5='Y/96qGh8yj//DDUOU9I3KC' WHERE FileId=0 failed: Can't open
file: 'File.MYD'. (errno: 145)
I think about drop the tables and start from zero :-( Or is there
another way out ?
Thanks alot !!!
Best regards
Jürgen
Jürgen,
For various reasons I have had this error several times. I setup a
small shell script to automatte MySQL's table repair process:
<script>
#!/bin/sh
#
# repair1 - repair the Bacula tables
#
echo "repair table BaseFiles, Client, Counters, File, FileSet, Filename,
Job, JobMedia, Media, Path, Pool, UnsavedFiles, Version;" > repair1.sql
mysql -u bacula bacula < repair1.sql
rm repair1.sql
</script>
In case this wraps, the "echo" line containing the list of tables should
be one line in the script file.
Rowdy
-------------------------------------------------------
SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
from IBM. Find simple to follow Roadmaps, straightforward articles,
informative Webcasts and more! Get everything you need to get up to
speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
