Hi Guys,
Every couple of weeks I get this problem and have to re-create the database to be able to run jobs again (otherwise the director crashes)
here's the error
11-Apr 12:16 backup1-dir: sql_create.c:564 INSERT INTO File (FileIndex,JobId,PathId,FilenameId,LStat,MD5) VALUES (17111,296,42025,11717,'GgH jUe IGk B A A A 4qF BAA HQ BCVR9K BAKbp5 BAUdMv A A C','0') 11-Apr 12:16 backup1-dir: LAS-1-Daily.2005-04-11_10.55.30 Fatal error: sql_create.c:565 Create db File record INSERT INTO File (FileIndex,JobId,PathId,FilenameId,LStat,MD5) VALUES (17111,296,42025,11717,'GgH jUe IGk B A A A 4qF BAA HQ BCVR9K BAKbp5 BAUdMv A A C','0') failed. ERR=Can't open file: 'File.MYD'. (errno: 145)
Any ideas?
I have had this error a couple of times, not quite every couple of weeks tho.
Rather than re-creating the database, why not start the MySQL command line tool and do a 'repair table File;'?
You could even set this up as a cron job.
Rowdy
------------------------------------------------------- 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