Hi,
On 15/09/2009 16:54, Alan Brown wrote:
>
> 2.4.4 (not able to update yet)
>
> I keep getting errors like this on update slots and incremental updates of
> the bacula-dir server
>
> Subject: Bacula: Admin Fatal Error of UpdateSlots.2009-09-13_12.30.43 Full
>
> 14-Sep 18:24 msslay-dir JobId 104670: Fatal error: sql_update.c:122 Update
> failed: affected_rows=0 for UPDATE Job SET
> JobStatus='R',Level='F',StartTime='2009-09-14
> 18:24:29',ClientId=10,JobTDate=1252949069,PoolId=0 WHERE JobId=104670
>
The immediate failure is because the number of affected rows is zero.
I'm not sure what the underlying cause could be (apart from the fact
that JobId 104670 is not in the Job table - pruning or a bug?)
But I vaguely remember a discussion about zero lines changed on
bacula-devel. Looking at the code the test that reports the failure has
changed between 2.4.4 and now (it tests affected_rows < 1 in the latest
code).
I don't know if the failure that you are seeing is a real problem or
whether it is just a symptom of normal behaviour.
For reference the appropriate bits of code are:
tag 2.4.4
See line2 202-209 of sql.c
http://bacula.git.sourceforge.net/git/gitweb.cgi?p=bacula/bacula;a=blob;f=bacula/src/cats/sql.c;h=99503f7c8bd9452e5f7316078a98b1d37d864f7a;hb=82e9ab55205674c9b394a58ceb781970a6be24c9
Head
line 258 of
http://bacula.git.sourceforge.net/git/gitweb.cgi?p=bacula/bacula;a=blob;f=bacula/src/cats/sql.c;h=49e9762010fb35ba1743c2396bf137613c67f740;hb=HEAD
> 14-Sep 18:24 msslay-dir JobId 104670: Warning: Error updating job record.
> sql_update.c:194 Update failed: affected_rows=0 for UPDATE Job SET
> JobStatus='f',EndTime='2009-09-14
> 18:24:29',ClientId=10,JobBytes=0,JobFiles=0,JobErrors=0,VolSessionId=0,VolSessionTime=0,PoolId=NULL,FileSetId=NULL,JobTDate=1252949069,RealEndTime='2009-09-14
> 18:24:29',PriorJobId=0 WHERE JobId=104670
>
Same here affected_rows = 0 too.
Regards
Richard
>
> Any ideas?
>
> Cpu appears fine and there are tens of Gb of spare space where Mysql and
> Bacula have their respective temp directories.
>
> AB
>
>
>
>
> ------------------------------------------------------------------------------
> Come build with us! The BlackBerry® Developer Conference in SF, CA
> is the only developer event you need to attend this year. Jumpstart your
> developing skills, take BlackBerry mobile applications to market and stay
> ahead of the curve. Join us from November 9-12, 2009. Register now!
> http://p.sf.net/sfu/devconf
> _______________________________________________
> Bacula-users mailing list
> Bacula-users AT lists.sourceforge DOT net
> https://lists.sourceforge.net/lists/listinfo/bacula-users
------------------------------------------------------------------------------
Come build with us! The BlackBerry® Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9-12, 2009. Register now!
http://p.sf.net/sfu/devconf
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
|