>>>>> On Tue, 16 Jun 2009 14:29:25 +0100, John Kennedy said: > > 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).
Errcode 30 means "Read-only file system" so I think you might have problems with your /tmp directory. What are the permissions on it? Can you create files in /tmp from the shell when running as the same user as mysqld? Is it a separate partition and does mount show rw for it? Have you tried rebooting in single user mode and doing an fsck to check for errors? __Martin ------------------------------------------------------------------------------ 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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users