Beren Gamble wrote:
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

Reply via email to