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@lists.sourceforge.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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users