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.
Carl ------------------------------------------------------------------------------
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
|
