Hi, I'm using Bacula to backup servers into files (not tapes). One of the servers has to backup 30GB of information. It has been working fine for 2 years but 3 weeks ago I received a Fatal Error message.
Here I post a little bit of the message (it's too large): 10-Nov 22:40 iesa8-dir: BackupIESA4.2008-11-10_21.30.00 Fatal error: sql_create.c:564 sql_create.c:564 insert INSERT INTO File (FileIndex,JobId,PathId,FilenameId,LStat,MD5) VALUES (42322,10216,14961,17509,'MK EgAR IH0 B IM IM A SXHu BAA CTY BJEhK1 BCNzD+ BFE418 A A E','0') failed: database is locked 10-Nov 22:40 iesa8-dir: BackupIESA4.2008-11-10_21.30.00 Fatal error: sql_create.c:566 Create db File record INSERT INTO File (FileIndex,JobId,PathId,FilenameId,LStat,MD5) VALUES (42322,10216,14961,17509,'MK EgAR IH0 B IM IM A SXHu BAA CTY BJEhK1 BCNzD+ BFE418 A A E','0') failed. ERR=database is locked10-Nov 22:40 iesa8-dir: BackupIESA4.2008-11-10_21.30.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 (42322,10216,14961,17509,'MK EgAR IH0 B IM IM A SXHu BAA CTY BJEhK1 BCNzD+ BFE418 A A E','0') failed. ERR=database is locked10-Nov 22:40 iesa8-dir: BackupIESA4.2008-11-10_21.30.00 Error: sql_update.c:65 sql_update.c:65 update UPDATE File SET MD5='9+U+v++at+/7+hddu/+SNC' WHERE FileId=0 failed: database is locked 10-Nov 22:40 iesa8-sd: BackupIESA4.2008-11-10_21.30.00 Fatal error: Could not create JobMedia record for Volume="iesa4-0003" Job=BackupIESA4.2008-11-10_21.30.00 10-Nov 22:40 iesa8-dir: Max Volume jobs exceeded. Marking Volume "iesa4-0003" as Used. 10-Nov 22:40 iesa8-dir: BackupIESA4.2008-11-10_21.30.00 Error: sql_update.c:276 sql_update.c:276 update UPDATE Media SET FirstWritten='2008-11-10 21:30:02' WHERE VolumeName='iesa4-0003' failed: database is locked 10-Nov 22:40 iesa8-dir: BackupIESA4.2008-11-10_21.30.00 Error: sql_update.c:327 sql_update.c:327 update UPDATE Media SET VolJobs=1,VolFiles=0,VolBlocks=258801,VolBytes=16695744573,VolMounts=88,VolE rrors=0,VolWrites=4719577,MaxVolBytes=0,LastWritten='2008-11-10 22:40:56',VolStatus='Used',Slot=0,InChanger=0,VolReadTime=0,VolWriteTime=0 WHERE VolumeName='iesa4-0003' failed: database is locked 10-Nov 22:40 iesa8-dir: BackupIESA4.2008-11-10_21.30.00 Error: Catalog error updating volume "iesa4-0003". ERR=sql_update.c:327 update UPDATE Media SET VolJobs=1,VolFiles=0,VolBlocks=258801,VolBytes=16695744573,VolMounts=88,VolE rrors=0,VolWrites=4719577,MaxVolBytes=0,LastWritten='2008-11-10 22:40:56',VolStatus='Used',Slot=0,InChanger=0,VolReadTime=0,VolWriteTime=0 WHERE VolumeName='iesa4-0003' failed: database is locked 10-Nov 22:40 iesa4-fd: BackupIESA4.2008-11-10_21.30.00 Fatal error: Bad status 102 returned from Storage Daemon. 10-Nov 22:40 iesa8-dir: BackupIESA4.2008-11-10_21.30.00 Error: sql_update.c:166 sql_update.c:166 update UPDATE Job SET JobStatus='f', EndTime='2008-11-10 22:40:56', ClientId=23, JobBytes=16666528723, JobFiles=43815, JobErrors=0, VolSessionId=25, VolSessionTime=1226321423, PoolId=41, FileSetId=50, JobTDate=1226353256 WHERE JobId=10216 failed: database is locked 10-Nov 22:40 iesa8-dir: BackupIESA4.2008-11-10_21.30.00 Warning: Error updating job record. sql_update.c:166 update UPDATE Job SET JobStatus='f', EndTime='2008-11-10 22:40:56', ClientId=23, JobBytes=16666528723, JobFiles=43815, JobErrors=0, VolSessionId=25, VolSessionTime=1226321423, PoolId=41, FileSetId=50, JobTDate=1226353256 WHERE JobId=10216 failed: database is locked 10-Nov 22:40 iesa8-dir: BackupIESA4.2008-11-10_21.30.00 Error: Bacula 1.36.3 (22Apr05): 10-Nov-2008 22:40:56 JobId: 10216 Job: BackupIESA4.2008-11-10_21.30.00 Backup Level: Full Client: iesa4-fd FileSet: "iesa4" 2008-10-21 21:30:02 Pool: "iesa4Pool" Storage: "iesa4FileStorage" Start time: 10-Nov-2008 21:30:02 End time: 10-Nov-2008 22:40:56 FD Files Written: 0 SD Files Written: 43,815 FD Bytes Written: 0 SD Bytes Written: 16,674,228,256 Rate: 0.0 KB/s Software Compression: 44.4 % Volume name(s): iesa4-0003 Volume Session Id: 25 Volume Session Time: 1226321423 Last Volume Bytes: 15,998,975,041 Non-fatal FD errors: 2 SD Errors: 0 FD termination status: Error SD termination status: Error Termination: *** Backup Error *** This message appears only when doing Full Backup. Does anyone know what is the problem? I've read it could be the amount of data I'm backing up but this has been working fine till 3 weeks ago. I'm using Bacula 1.38 and I haven't modified nothing at all because it was working fine. Thank you ISABEL ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
