UNCLASSIFIED Hi Guys, I'm received this fatal error on my last couple of full backups?
26-Nov 16:37 preqf-dir JobId 84: Fatal error: Can't 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_fd4_0.MYI'; try to repair it The backup seemed to have written the correct amount of data for a full backup compared to a previous backup (which completed OK) but the latest finished with the fatal error. Is it trying write to a full file? I've done a bit more research myself on this and most fixes say to increase the size of the tmp file directory or move the tmp file directory to a drive that has more space. So I've change the /etc/my.cnf file to reflect that the tmp file should be "tmpdir=/var/mysqltmp" which has 66Gb free. Restarted the services for - mysqld, bacula-dir, bacula-fd and bacula-sd. But I still get the error? Is this the correct file for bacula mysql? I've found 3 instances of my.cnf on my server; /etc/my.cnf /opt/bacula/etc/my.cnf /usr/share/system-mysql/etc/my.cnf Can anybody tell me which of these file bacula users? I've changed the /opt/bacula file but bacula-dir will not restart when I stop the daemon after doing this so had to back out. I have bacula-dir version 2.4.4 on a i686-redhat-linux-gnu redhat on a clearos system. Any suggestions on how to get pass this problem would be appreciated. Thanks Alan Langley UNCLASSIFIED ------------------------------------------------------------------------------ Write once. Port to many. Get the SDK and tools to simplify cross-platform app development. Create new or port existing apps to sell to consumers worldwide. Explore the Intel AppUpSM program developer opportunity. appdeveloper.intel.com/join http://p.sf.net/sfu/intel-appdev _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
