>>>>> 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 <cgr AT u.washington DOT 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 AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users