[Bacula-users] MYSQL error [SEC=UNCLASSIFIED]
2011-12-21 19:36:09
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 AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
|
<Prev in Thread] |
Current Thread |
[Next in Thread> |
- [Bacula-users] MYSQL error [SEC=UNCLASSIFIED],
Alan Langley <=
|
|
|