Re: [Bacula-users] MySQL errors

2009-06-18 Thread John Kennedy
Martin Simmons wrote: >> 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

Re: [Bacula-users] MySQL errors

2009-06-17 Thread Martin Simmons
> 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 J

[Bacula-users] MySQL errors

2009-06-16 Thread John Kennedy
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 OR

Re: [Bacula-users] MySQL Errors being logged

2008-02-05 Thread James Harper
> > The first thing I'd check is to make sure that the partition holding /tmp > isn't running out of space. If it is, either tell MySQL to use a > different > directory with more space, or increase the amount of space allocated to > /tmp. > Just to follow up, I freed up some space and the probl

Re: [Bacula-users] MySQL Errors being logged

2008-02-03 Thread James Harper
> > The first thing I'd check is to make sure that the partition holding /tmp > isn't running out of space. If it is, either tell MySQL to use a > different > directory with more space, or increase the amount of space allocated to > /tmp. > When I just checked now, /var/log/mysql had about 2G o

Re: [Bacula-users] MySQL Errors being logged

2008-02-03 Thread Frank Sweetser
James Harper wrote: > I've been using bacula on a Xen server for many months with no problems > at all. A week ago I set up some jobs to run concurrently to the > existing jobs to back up some remote clients to a remote sd. > > Since then, jobs aren't completing and are hanging around and things a

[Bacula-users] MySQL Errors being logged

2008-02-03 Thread James Harper
I've been using bacula on a Xen server for many months with no problems at all. A week ago I set up some jobs to run concurrently to the existing jobs to back up some remote clients to a remote sd. Since then, jobs aren't completing and are hanging around and things are just not running well, alth