Re: [Bacula-users] beginner Bacula questions

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.

Hey Mr. Carl - you can also try that, if nothing else works: mysqlcheck -A --auto-repair

Regards,

============================================================
Heitor Medrado de Faria - LPIC-III | ITIL-F

+55 61 2021-8260 | 8268-4220

Site: www.bacula.com.br | Facebook: heitor.faria | Gtalk: heitorfaria AT gmail DOT com

============================================================

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