>-----Original Message----- >From: Kern Sibbald [mailto:[EMAIL PROTECTED] >Sent: 15 August 2006 09:08 >To: bacula-users@lists.sourceforge.net >Cc: graham.dicker >Subject: Re: [Bacula-users] Can I quit backup on database errors?
>On Tuesday 15 August 2006 09:35, graham.dicker wrote: >> Is there a way to make Bacula abandon a backup job if the database is >> corrupt? >In general, Bacula does fail a job if the database is corrupt, but the problem >is to define what kinds of errors are fatal and what errors are non-fatal. >> >> >> >> >From time to time a Bacula backup creates a huge log file full of >> database error messages. >I think you should look into why this is happening. I've been running >Bacula >for over 6 years now, and this has never happened to me. I can imagine >that >it happens because of some unusal event, but if it is happening "from time >to >time", it is most likely a problem you can resolve. >> This prevents the "backup result" email being >> sent because the message is too big. On some systems the hard drive gets >> full and that causes more problems. It would be very useful to be able >> to specify to abandon the backup if the number of database errors >> exceeds some given number. >Can you provide some examples of what kind of errors you are getting? >What SQL engine are you using? >What version of Bacula are you using? >If you are using bsmtp, it has an option that can limit the size of the email >message. It won't resolve the problem of not getting the Job Report, but it >might keep your HD from filling. >> TIA >> Graham Dicker Bacula version is 1.36.2 Using mysql Ver 12.22 Distrib 4.0.18 for suse-linux (i686) These next 3 lines from a recent log are fairly typical. It seems mostly the File table is the culprit. I repair the table(s) and that keeps it going for another month or two. Duplicate entry '3522434162' for key 1 19-Jul 00:42 lasertobit-dir: sql_create.c:564 INSERT INTO File (FileIndex,JobId,PathId,FilenameId,LStat,MD5) VALUES (655666,310,14167,110,'gC YQL EHt D A A A Bw BAA A BEtu/L BCQAgO BCQAgO A A E','0') 19-Jul 00:42 lasertobit-dir: All.2006-07-18_23.00.00 Fatal error: sql_create.c:566 Create db File record INSERT INTO File (FileIndex,JobId,PathId,FilenameId,LStat,MD5) VALUES (655666,310,14167,110,'gC YQL EHt D A A A Bw BAA A BEtu/L BCQAgO BCQAgO A A E','0') failed. ERR=Duplicate entry '3522434162' for key 119-Jul 00:42 lasertobit-dir: All.2006-07-18_23.00.00 Fatal error: catreq.c:346 Attribute create error. sql_create.c:566 Create db File record INSERT INTO File (FileIndex,JobId,PathId,FilenameId,LStat,MD5) VALUES (655666,310,14167,110,'gC YQL EHt D A A A Bw BAA A BEtu/L BCQAgO BCQAgO A A E','0') failed. ERR=Duplicate entry '3522434162' for key 119-Jul 00:42 lasertobit-dir: All.2006-07-18_23.00.00 Fatal error: sql_create.c:564 sql_create.c:564 insert INSERT INTO File (FileIndex,JobId,PathId,FilenameId,LStat,MD5) VALUES (655667,310,14169,28696,'gC L6N IGA B A A A tH BAA I BEtu/L BCP+Ku BCP/V0 A A E','0') failed: Thanks Graham Dicker ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
