>>>>> On Fri, 12 Dec 2014 14:00:13 -0800 (PST), Carl G Riches said: > > On Fri, 12 Dec 2014, Carl G. Riches wrote: > > > On Fri, 12 Dec 2014, Radosław Korzeniewski wrote: > > > >> Hello, > >> 2014-12-09 22:58 GMT+01:00 Carl G. Riches <c...@u.washington.edu>: > >> 28-Nov 13:45 backuphost.localdomain.TLD JobId 1: Fatal error: > >> sql_create.c:832 Fill Path table Query failed: INSERT INTO Path > >> (Path) SELECT a.Path FROM (SELECT DISTINCT Path FROM batch) AS a > >> WHERE NOT EXISTS (SELECT Path FROM Path AS p WHERE p.Path = > >> a.Path): ERR=Incorrect key file for table '/tmp/#sql_9aa_0.MYI'; > >> try to repair it > >> > >> The table "/tmp/#sql_9aa_0.MYI" doesn't exist. I've run > >> "mysqlcheck" > >> against the Bacula database--this shows all tables are OK. > >> > >> > >> Not a solution, but a guess: check if you have enough space available on > >> /tmp filesystem. > >> > > > > What constitutes "enough space"? Is there an algorithm or other mechanism > > to > > determine whether this is the problem? > > > > And is this an error one that is happening on the Bacula server? Or is it > happening on the MySQL server? MySQL does not run on the same machine as > Bacula.
It will be on the MySQL server, but it is difficult to predict the size. See http://dev.mysql.com/doc/refman/5.0/en/temporary-files.html if /tmp is too constrained. __Martin ------------------------------------------------------------------------------ Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server from Actuate! Instantly Supercharge Your Business Reports and Dashboards with Interactivity, Sharing, Native Excel Exports, App Integration & more Get technology previously reserved for billion-dollar corporations, FREE http://pubads.g.doubleclick.net/gampad/clk?id=164703151&iu=/4140/ostg.clktrk _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
