We keep getting the following errors when running backups and any time
we query:

16-Jun 13:56 ceres-dir JobId 8703: Fatal error: sql_get.c:359
sql_get.c:359 query SELECT VolumeName,MAX(VolIndex) FROM JobMedia,Media
WHERE JobMedia.JobId=8703 AND JobMedia.MediaId=Media.MediaId GROUP BY
VolumeName ORDER BY 2 ASC failed:
Can't create/write to file '/tmp/#sql_555_0.MYI' (Errcode: 30)

I can not find any problems with MySQL and /tmp is not full nor are
there any permission issues.
I am relatively new to Bacula and know a bit about MySQL (just short of
Jr DBA level).
Thanks,
John



Forgot to add that we are using Bacula 2.0.3 on Debian 3.

Thanks

The information in this message is intended solely for the addressee and should 
be considered confidential.  Publishing Technology does not accept legal 
responsibility for the contents of this message and any statements contained 
herein which do not relate to the official business of Publishing Technology 
are neither given nor endorsed by Publishing Technology and are those of the 
individual and not of Publishing Technology. This message has been scanned for 
viruses using the most current and reliable tools available and Publishing 
Technology excludes all liability related to any viruses that might exist in 
any attachment or which may have been acquired in transit.

------------------------------------------------------------------------------
Crystal Reports - New Free Runtime and 30 Day Trial
Check out the new simplified licensing option that enables unlimited
royalty-free distribution of the report engine for externally facing 
server and web deployment.
http://p.sf.net/sfu/businessobjects
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users