>>From the error, you might want to increase the lock wait timeout, there
>>should be other posts describing that sort of problem in the archives.
> -----Original Message-----
> From: bacula-users-bounces AT lists.sourceforge DOT net [mailto:bacula-users-
> bounces AT lists.sourceforge DOT net] On Behalf Of Jason A. Kates
> Sent: Saturday, June 21, 2008 8:10 AM
> To: bacula-users AT lists.sourceforge DOT net
> Subject: Re: [Bacula-users] mysql ERR=Lock wait timeout exceeded; try
> restarting transaction
>
> I think that I found this from another thread. I had read the thread
> but I thought it didn't apply since I can create temp tables:
> http://www.mail-archive.com/bacula-
> devel AT lists.sourceforge DOT net/msg01145.html
>
> It seems that I am using more than my 8GB of /tmp for temporary tables
> when the I get the insert error.
>
> I have mysql using /tmp for temp tables:
> none 8.0G 1.3G 6.8G 17% /tmp
>
> This is a mysql error that I will fix.
> Thanks -Jason
>
> On Sat, 2008-06-21 at 08:51 -0400, Jason A. Kates wrote:
> > Has anybody else experianced this error with bacula:
> > 20-Jun 23:07 bacula-dir JobId 30430: Fatal error: sql_create.c:822 Fill
> > File table Query failed: INSERT INTO File (FileIndex, JobId, PathId,
> > FilenameId, LStat, MD5)SELECT batch.FileIndex, batch.JobId, Path.PathId,
> > Filename.FilenameId,batch.LStat, batch.MD5 FROM batch JOIN Path ON
> > (batch.Path = Path.Path) JOIN Filename ON (batch.Name = Filename.Name):
> > ERR=Lock wait timeout exceeded; try restarting transaction
> >
> > If you did what was your fix? I am getting about one of these a night.
> > If I rerun the job it runs fine.
> > Thanks -Jason
> >
> --
> --------------------------------------------------------------------------
> --
> Jason A. Kates (jason AT kates DOT org)
> Fax: 208-975-1514
> Phone: 212-400-1670 x2
> ==========================================================================
> ==
>
>
>
> -------------------------------------------------------------------------
> Check out the new SourceForge.net Marketplace.
> It's the best place to buy or sell services for
> just about anything Open Source.
> http://sourceforge.net/services/buy/index.php
> _______________________________________________
> Bacula-users mailing list
> Bacula-users AT lists.sourceforge DOT net
> https://lists.sourceforge.net/lists/listinfo/bacula-users
-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://sourceforge.net/services/buy/index.php
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
|
