On 01/26/10 15:16, Arno Lehmann wrote:
> Hi all,
>
> 25.01.2010 17:16, Kern Sibbald wrote:
>> On Monday 25 January 2010 16:45:49 Phil Stracchino wrote:
>>> One of my ten differential backups last night failed with an error I've
>>> never seen before:
>>>
> ...
>>> 25-Jan 03:43 babylon4-dir JobId 978: Fatal error: sql_create.c:825 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
> ...
>> This is a Windows client that is generating the error messages.
>
> I disagree... looks definitely like the DIR producing the error during
> a database transaction.
That was my thought too. I was wondering if something different happens
on DB commits with VSS clients.
> This looks quite like something we've seen recently - I assume you're
> using MySQLs InnoDB database engine?
Correct.
> In that case, you may be able to tweak the settings, but what might
> really help *may* be an upgrade of MySQL to a more recent and stable
> version.
>
> Actually, I don't know the cause for the error, but I'm pretty sure
> that - where I observed this - switching to a different MySQL version
> fixed this.
I can check and see if there's a newer Solaris 10 MySQL package. (I'm
trying to stay as much as possible with original Sun packages on that
machine.) If it's a known potential issue with a known fix, then that's
fine. I reported it in case it was a hitherto unseen problem.
--
Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355
ala...@caerllewys.net ala...@metrocast.net p...@co.ordinate.org
Renaissance Man, Unix ronin, Perl hacker, Free Stater
It's not the years, it's the mileage.
------------------------------------------------------------------------------
The Planet: dedicated and managed hosting, cloud storage, colocation
Stay online with enterprise data centers and the best network in the business
Choose flexible plans and management services without long-term contracts
Personal 24x7 support from experience hosting pros just a phone call away.
http://p.sf.net/sfu/theplanet-com
_______________________________________________
Bacula-devel mailing list
Bacula-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-devel
