[Bacula-users] I need a little advice how to auto label new tapes for my pool
Hello, this is the first time, that I try to get Bacula running. At the moment the system looks good, but can someone advice me - what I must do - so that Bacula will label new tapes automatically? I tried to add volumes to my pool, but all new volumes got an diffrent slot. e.g.: Save_0001 got Slot 0, Save_0002 got Slot 1, Save_0003 got Slot2. The funny think is, that the LTO4 has only one slot. So my question would be, how can I change the slot of the volumes. Or how can I remove all the wrong tapes from the pool and add new Volumes with the correct slots. At the moment I label my tapes manually, but that is nothing that I want that my peers schould do, when I'm on easter holiday. I'm grateful to any advice, of what I did wrong. Best regards Wolf-Elmar Rath Here are some screenshots from the dir and fd config files and the bacula console: *list jobs +---+--+-+--+---+--+-+---+ | JobId | Name | StartTime | Type | Level | JobFiles | JobBytes| JobStatus | +---+--+-+--+---+--+-+---+ | 1 | Nightly-Save-bocsles | 2009-03-25 09:28:51 | B| F | 766510 | 33543328966 | T | +---+--+-+--+---+--+-+---+ *lis volumes Pool: Default No results to list. Pool: Scratch No results to list. Pool: TagesPool +-+--+---+-+-+--+--+-+--+---+---+-+ | MediaId | VolumeName | VolStatus | Enabled | VolBytes| VolFiles | VolRetention | Recycle | Slot | InChanger | MediaType | LastWritten | +-+--+---+-+-+--+--+-+--+---+---+-+ | 1 | BoC_Save_0001| Append| 1 | 0 | 0 | 432000 | 1 | 0| 0 | LTO-4 | 0 | | 2 | BoC_Save_0002| Append| 1 | 0 | 0 | 432000 | 1 | 1| 0 | LTO-4 | 0 | | 3 | BoC_Save_0003| Append| 1 | 0 | 0 | 432000 | 1 | 2| 0 | LTO-4 | 0 | | 4 | BoC_Save_0004| Append| 1 | 0 | 0 | 432000 | 1 | 3| 0 | LTO-4 | 0 | | 5 | BoC_Save_0005| Append| 1 | 0 | 0 | 432000 | 1 | 4| 0 | LTO-4 | 0 | | 6 | BoC_Save_0006| Append| 1 | 0 | 0 | 432000 | 1 | 5| 0 | LTO-4 | 0 | | 7 | BoC_Save_0007| Append| 1 | 0 | 0 | 432000 | 1 | 6| 0 | LTO-4 | 0 | | 8 | BoC_Save_0008| Append| 1 | 0 | 0 | 432000 | 1 | 7| 0 | LTO-4 | 0 | | 9 | BoC_Save_0009| Append| 1 | 0 | 0 | 432000 | 1 | 8| 0 | LTO-4 | 0 | | 10 | BoC_Save_0010| Append| 1 | 0 | 0 | 432000 | 1 | 9| 0 | LTO-4 | 0 | | 11 | BoC_Save_0011| Append| 1 | 0 | 0 | 432000 | 1 | 10 | 0 | LTO-4 | 0 | | 12 | BoC_Save_0012| Append| 1 | 0 | 0 | 432000 | 1 | 11 | 0 | LTO-4 | 0 | | 13 | BoC_Save_0013| Append| 1 | 0 | 0 | 432000 | 1 | 12 | 0 | LTO-4 | 0 | | 14 | BoC_Save_0014| Append| 1 | 0 | 0 | 432000 | 1 | 13 | 0 | LTO-4 | 0 | | 15 | BoC_Save_0015| Append| 1 | 0 | 0 | 432000 | 1 | 14 | 0 | LTO-4 | 0 | | 16 | BoC_Save_0016| Append| 1 | 0 | 0 | 432000 | 1 | 15 | 0 | LTO-4 | 0 | | 17 | BoC_Save_0017| Append| 1 | 0 | 0 | 432000 | 1 | 16 | 0 | LTO-4 | 0 | | 18 | BoC_Save_0018| Append| 1 | 0 | 0 | 432000 | 1 | 17 | 0 | LTO-4 | 0 | | 19 | BoC_Save_0019| Append| 1 | 0 | 0 | 432000 | 1 | 18 | 0 | LTO-4 | 0 | | 20 | BoC_Save_0020| Append| 1 | 0 | 0 | 432000 | 1 | 19 | 0 | LTO-4 | 0 | | 21 | BoC_Save_0021| Append| 1 | 0 | 0 | 432000 | 1 | 20 | 0 | LTO-4 | 0 | | 22 | BoC_Save_0022| Append| 1 | 0 | 0 | 432000 | 1 | 21 | 0 | LTO-4 | 0 | | 23 | BoC_Save_0023| Append| 1 | 0
[Bacula-users] Bacula abort Backup with a SQL-Error
This is the notification, that I got from the Job: Bacula: Backup Fatal Error of bocsles-fd Full 22-Apr 02:01 bocsles-dir JobId 52: Start Backup JobId 52, Job=Nightly-Save-bocsles.2009-04-22_02.01.00.02 22-Apr 02:01 bocsles-dir JobId 52: Using Device "LTO4" 22-Apr 02:01 bocsles-sd JobId 52: Error: 22-Apr 02:01 bocsles-sd JobId 52: Wrote label to prelabeled Volume "BoC_Save_20090421" on device "LTO4" (/dev/st0) bocsles-fd JobId 52: /dev is a different filesystem. Will not descend from / into /dev bocsles-fd JobId 52: /opt is a different filesystem. Will not descend from / into /opt bocsles-fd JobId 52: /var/lib/ntp/proc is a different filesystem. Will not descend from / into /var/lib/ntp/proc bocsles-fd JobId 52: /home is a different filesystem. Will not descend from / into /home bocsles-fd JobId 52: /var/lib/ntp/proc is a different filesystem. Will not descend from /var into /var/lib/ntp/proc 22-Apr 03:51 bocsles-sd JobId 52: Job write elapsed time = 01:50:34, Transfer rate = 5.627 M bytes/second 22-Apr 04:09 bocsles-dir JobId 52: Fatal error: Can't 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=disk I/O error 22-Apr 04:09 bocsles-dir JobId 52: Error: Bacula bocsles-dir 2.4.4 (28Dec08): 22-Apr-2009 04:09:15 Build OS: powerpc64-unknown-linux-gnu suse 10 JobId: 52 Job:Nightly-Save-bocsles.2009-04-22_02.01.00.02 Backup Level: Full Client: "bocsles-fd" 2.4.4 (28Dec08) powerpc64-unknown-linux-gnu,suse,10 FileSet:"BOC_Full_Set" 2009-03-17 02:01:00 Pool: "TagesPool" (From Job resource) Storage:"LTO4" (From Job resource) Scheduled time: 22-Apr-2009 02:01:00 Start time: 22-Apr-2009 02:01:02 End time: 22-Apr-2009 04:09:15 Elapsed time: 2 hours 8 mins 13 secs Priority: 10 FD Files Written: 785,734 SD Files Written: 785,734 FD Bytes Written: 37,207,722,525 (37.20 GB) SD Bytes Written: 37,329,598,535 (37.32 GB) Rate: 4836.6 KB/s Software Compression: 36.9 % VSS:no Storage Encryption: no Volume name(s): BoC_Save_20090421 Volume Session Id: 1 Volume Session Time:1240357811 Last Volume Bytes: 37,386,768,384 (37.38 GB) Non-fatal FD errors:0 SD Errors: 0 FD termination status: OK SD termination status: OK Termination:*** Backup Error *** 22-Apr 04:09 bocsles-dir JobId 52: Begin pruning Jobs. 22-Apr 04:09 bocsles-dir JobId 52: No Jobs found to prune. 22-Apr 04:09 bocsles-dir JobId 52: Begin pruning Files. 22-Apr 04:09 bocsles-dir JobId 52: No Files found to prune. The first time I got this error was, when I didn't notice, that my root-disk had no space left. After I deletet the file, that was the reason for the problem. I thought that the problem was solved, but I got the same error this night again. I'm running Bacula 2.4.4 with SQLIGHT 3 on a SLES 10 SP2. I saw that there was some patches relesed on 4 April for 2.4.4 but I didn't installed them yet. I hope you can help me. Kind regards Wolf-Elmar Rath Mit freundlichen Gruessen Wolf-Elmar Rath SYSTEM COMPETENCE GmbH Ohlendorfer Strasse 40 21220 Seevetal Telefon: 04185-77-0 Telefax: 04185-77-440 Email: elmar.r...@systemcompetence.de Sitz der Gesellschaft: Seevetal Geschäftsführer: Sven Hannemann, Martin Pranzner, Rigo Rothenbröker Handelsregister: HRB 111223, Amtsgericht Lüneburg-- Stay on top of everything new and different, both inside and around Java (TM) technology - register by April 22, and save $200 on the JavaOne (SM) conference, June 2-5, 2009, San Francisco. 300 plus technical and hands-on sessions. Register today. Use priority code J9JMT32. http://p.sf.net/sfu/p___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Antwort: Re: Bacula abort Backup with a SQL-Error
Hello Jean-Sebastien, on monday morning I got a no disk space problem, because the daily dump of the Bacula database appended in one file on the root-partition. After nearly over one month the file had a size of nearly 22GB. I removed the file so that I got my free space back. I changed the configuration for the dump job, so that it will now overwrite the file and not append at the end of the file other dumps. Now the "df -h"- command gets me this informations: bocsles:~ # df -h FilesystemSize Used Avail Use% Mounted on /dev/mapper/system-system 33G 14G 20G 41% / udev 3.0G 180K 3.0G 1% /dev /dev/mapper/home-home 33G 7.7G 26G 24% /home /dev/mapper/opt-opt50G 33G 18G 66% /opt bocsles:~ # I'm not really sure, why I got the same errror message today after I freed the diskspace yesterday. Mit freundlichen Gruessen Wolf-Elmar Rath SYSTEM COMPETENCE GmbH Ohlendorfer Strasse 40 21220 Seevetal Telefon: 04185-77-0 Telefax: 04185-77-440 Email: elmar.r...@systemcompetence.de Sitz der Gesellschaft: Seevetal Geschäftsführer: Sven Hannemann, Martin Pranzner, Rigo Rothenbröker Handelsregister: HRB 111223, Amtsgericht Lüneburg Jean-Sébastien Hederer 22.04.2009 11:32 An elmarr...@systemcompetence.de Kopie bacula-users@lists.sourceforge.net Thema Re: [Bacula-users] Bacula abort Backup with a SQL-Error Can you make a "df -h" . This seems to be a no disk space left problem. elmarr...@systemcompetence.de a écrit : This is the notification, that I got from the Job: Bacula: Backup Fatal Error of bocsles-fd Full 22-Apr 02:01 bocsles-dir JobId 52: Start Backup JobId 52, Job=Nightly-Save-bocsles.2009-04-22_02.01.00.02 22-Apr 02:01 bocsles-dir JobId 52: Using Device "LTO4" 22-Apr 02:01 bocsles-sd JobId 52: Error: 22-Apr 02:01 bocsles-sd JobId 52: Wrote label to prelabeled Volume "BoC_Save_20090421" on device "LTO4" (/dev/st0) bocsles-fd JobId 52: /dev is a different filesystem. Will not descend from / into /dev bocsles-fd JobId 52: /opt is a different filesystem. Will not descend from / into /opt bocsles-fd JobId 52: /var/lib/ntp/proc is a different filesystem. Will not descend from / into /var/lib/ntp/proc bocsles-fd JobId 52: /home is a different filesystem. Will not descend from / into /home bocsles-fd JobId 52: /var/lib/ntp/proc is a different filesystem. Will not descend from /var into /var/lib/ntp/proc 22-Apr 03:51 bocsles-sd JobId 52: Job write elapsed time = 01:50:34, Transfer rate = 5.627 M bytes/second 22-Apr 04:09 bocsles-dir JobId 52: Fatal error: Can't 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=disk I/O error 22-Apr 04:09 bocsles-dir JobId 52: Error: Bacula bocsles-dir 2.4.4 (28Dec08): 22-Apr-2009 04:09:15 Build OS: powerpc64-unknown-linux-gnu suse 10 JobId: 52 Job:Nightly-Save-bocsles.2009-04-22_02.01.00.02 Backup Level: Full Client: "bocsles-fd" 2.4.4 (28Dec08) powerpc64-unknown-linux-gnu,suse,10 FileSet:"BOC_Full_Set" 2009-03-17 02:01:00 Pool: "TagesPool" (From Job resource) Storage:"LTO4" (From Job resource) Scheduled time: 22-Apr-2009 02:01:00 Start time: 22-Apr-2009 02:01:02 End time: 22-Apr-2009 04:09:15 Elapsed time: 2 hours 8 mins 13 secs Priority: 10 FD Files Written: 785,734 SD Files Written: 785,734 FD Bytes Written: 37,207,722,525 (37.20 GB) SD Bytes Written: 37,329,598,535 (37.32 GB) Rate: 4836.6 KB/s Software Compression: 36.9 % VSS:no Storage Encryption: no Volume name(s): BoC_Save_20090421 Volume Session Id: 1 Volume Session Time:1240357811 Last Volume Bytes: 37,386,768,384 (37.38 GB) Non-fatal FD errors:0 SD Errors: 0 FD termination status: OK SD termination status: OK Termination:*** Backup Error *** 22-Apr 04:09 bocsles-dir JobId 52: Begin pruning Jobs. 22-Apr 04:09 bocsles-dir JobId 52: No Jobs found to prune. 22-Apr 04:09 bocsles-dir JobId 52: Begin pruning Files. 22-Apr 04:09 bocsles-dir JobId 52: No Files found to prune. The first time I got this error was, when I didn't notice, that my root-disk had no space left. After I deletet the file, that was the reason for the problem. I thought that the problem was solved, but I got the same error this night again. I'm running Bacula 2.4.4 with SQLIGHT 3 on a SLES 10 SP2. I saw that there was some patches relesed on 4 April for 2.4.4 but I didn't installed them yet. I hope you can help me. Kin
[Bacula-users] Bacula didn't start anymore
Haloo, I hope someone could help me wirth my problem. Monday morning faild my backup with the following log. 25-May 02:01 bocsles-dir JobId 124: Start Backup JobId 124, Job=Nightly-Save-bocsles.2009-05-25_02.01.00.02 25-May 02:01 bocsles-dir JobId 124: Using Device "LTO4" 25-May 02:01 bocsles-sd JobId 124: Error: 25-May 02:01 bocsles-sd JobId 124: Volume "LIN-TAG-22" previously written, moving to end of data. 25-May 02:01 bocsles-sd JobId 124: Ready to append to end of Volume "LIN-TAG-22" at file=136. bocsles-fd JobId 124: /dev is a different filesystem. Will not descend from / into /dev bocsles-fd JobId 124: /opt is a different filesystem. Will not descend from / into /opt bocsles-fd JobId 124: /var/lib/ntp/proc is a different filesystem. Will not descend from / into /var/lib/ntp/proc bocsles-fd JobId 124: /home is a different filesystem. Will not descend from / into /home bocsles-fd JobId 124: /var/lib/ntp/proc is a different filesystem. Will not descend from /var into /var/lib/ntp/proc 25-May 02:54 bocsles-sd JobId 124: Job write elapsed time = 00:52:53, Transfer rate = 22.19 M bytes/second 25-May 03:15 bocsles-dir JobId 124: Fatal error: Can't 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=disk I/O error 25-May 03:15 bocsles-dir JobId 124: Error: sql_update.c:178 sql_update.c:178 update UPDATE Job SET JobStatus='f',EndTime='2009-05-25 03:15:26',ClientId=1,JobBytes=70287992114,JobFiles=805529,JobErrors=0,VolSessionId=1,VolSessionTime=1243209010,PoolId=3,FileSetId=3,JobTDate=1243214126,RealEndTime='2009-05-25 03:15:26',PriorJobId=0 WHERE JobId=124 failed: disk I/O error 25-May 03:15 bocsles-dir JobId 124: sql_update.c:178 UPDATE Job SET JobStatus='f',EndTime='2009-05-25 03:15:26',ClientId=1,JobBytes=70287992114,JobFiles=805529,JobErrors=0,VolSessionId=1,VolSessionTime=1243209010,PoolId=3,FileSetId=3,JobTDate=1243214126,RealEndTime='2009-05-25 03:15:26',PriorJobId=0 WHERE JobId=124 25-May 03:15 bocsles-dir JobId 124: Warning: Error updating job record. sql_update.c:178 update UPDATE Job SET JobStatus='f',EndTime='2009-05-25 03:15:26',ClientId=1,JobBytes=70287992114,JobFiles=805529,JobErrors=0,VolSessionId=1,VolSessionTime=1243209010,PoolId=3,FileSetId=3,JobTDate=1243214126,RealEndTime='2009-05-25 03:15:26',PriorJobId=0 WHERE JobId=124 failed: disk I/O error 25-May 03:15 bocsles-dir JobId 124: Fatal error: sql_get.c:289 sql_get.c:289 query SELECT VolSessionId,VolSessionTime,PoolId,StartTime,EndTime,JobFiles,JobBytes,JobTDate,Job,JobStatus,Type,Level,ClientId,Name,PriorJobId,RealEndTime,JobId,FileSetId,SchedTime,RealEndTime FROM Job WHERE JobId=124 failed: disk I/O error 25-May 03:15 bocsles-dir JobId 124: sql_get.c:289 SELECT VolSessionId,VolSessionTime,PoolId,StartTime,EndTime,JobFiles,JobBytes,JobTDate,Job,JobStatus,Type,Level,ClientId,Name,PriorJobId,RealEndTime,JobId,FileSetId,SchedTime,RealEndTime FROM Job WHERE JobId=124 25-May 03:15 bocsles-dir JobId 124: Warning: Error getting Job record for Job report: ERR=sql_get.c:289 query SELECT VolSessionId,VolSessionTime,PoolId,StartTime,EndTime,JobFiles,JobBytes,JobTDate,Job,JobStatus,Type,Level,ClientId,Name,PriorJobId,RealEndTime,JobId,FileSetId,SchedTime,RealEndTime FROM Job WHERE JobId=124 failed: disk I/O error 25-May 03:15 bocsles-dir JobId 124: Fatal error: sql_get.c:672 sql_get.c:672 query SELECT ClientId,Name,Uname,AutoPrune,FileRetention,JobRetention FROM Client WHERE Client.Name='bocsles-fd' failed: disk I/O error 25-May 03:15 bocsles-dir JobId 124: sql_get.c:672 SELECT ClientId,Name,Uname,AutoPrune,FileRetention,JobRetention FROM Client WHERE Client.Name='bocsles-fd' 25-May 03:15 bocsles-dir JobId 124: Warning: Error getting Client record for Job report: ERR=Client record not found in Catalog. 25-May 03:15 bocsles-dir JobId 124: Fatal error: sql_get.c:942 sql_get.c:942 query SELECT MediaId,VolumeName,VolJobs,VolFiles,VolBlocks,VolBytes,VolMounts,VolErrors,VolWrites,MaxVolBytes,VolCapacityBytes,MediaType,VolStatus,PoolId,VolRetention,VolUseDuration,MaxVolJobs,MaxVolFiles,Recycle,Slot,FirstWritten,LastWritten,InChanger,EndFile,EndBlock,VolParts,LabelType,LabelDate,StorageId,Enabled,LocationId,RecycleCount,InitialWrite,ScratchPoolId,RecyclePoolId,VolReadTime,VolWriteTime FROM Media WHERE VolumeName='LIN-TAG-22' failed: disk I/O error 25-May 03:15 bocsles-dir JobId 124: sql_get.c:942 SELECT MediaId,VolumeName,VolJobs,VolFiles,VolBlocks,VolBytes,VolMounts,VolErrors,VolWrites,MaxVolBytes,VolCapacityBytes,MediaType,VolStatus,PoolId,VolRetention,VolUseDuration,MaxVolJobs,MaxVolFiles,Recycle,Slot,FirstWritten,LastWritten,InChanger,EndFile,EndBlock,VolParts,LabelType,LabelDate,StorageId,Enabled,LocationId,RecycleCount,InitialWrite,ScratchP
[Bacula-users] Antwort: Re: Bacula didn't start anymore
Hi, I checked the raid and the disks twice if there is any problem. Gpart didn't found anything. My major problem is that bacula-dir isn't starting, because I 've got he out of memory message, that I posted on the end of my mail. Mit freundlichen Gruessen Wolf-Elmar Rath SYSTEM COMPETENCE GmbH Ohlendorfer Strasse 40 21220 Seevetal Telefon: 04185-77-0 Telefax: 04185-77-440 Email: elmar.r...@systemcompetence.de Sitz der Gesellschaft: Seevetal Geschäftsführer: Sven Hannemann, Martin Pranzner, Rigo Rothenbröker Handelsregister: HRB 111223, Amtsgericht Lüneburg SystemManagement 26.05.2009 17:41 Bitte antworten an dass...@fs.wettzell.de An elmarr...@systemcompetence.de Kopie bacula-users@lists.sourceforge.net Thema Re: [Bacula-users] Bacula didn't start anymore Hallo, the messages point to a disc problem. I see: ERR=disk I/O error Check your discs! Reiner elmarr...@systemcompetence.de schrieb: > Haloo, > > I hope someone could help me wirth my problem. Monday morning faild my > backup with the following log. > > > > 25-May 02:01 bocsles-dir JobId 124: Start Backup JobId 124, > Job=Nightly-Save-bocsles.2009-05-25_02.01.00.02 > 25-May 02:01 bocsles-dir JobId 124: Using Device "LTO4" > 25-May 02:01 bocsles-sd JobId 124: Error: 25-May 02:01 bocsles-sd JobId > 124: Volume "LIN-TAG-22" previously written, moving to end of data. > 25-May 02:01 bocsles-sd JobId 124: Ready to append to end of Volume > "LIN-TAG-22" at file=136. > bocsles-fd JobId 124: /dev is a different filesystem. Will not > descend from / into /dev > bocsles-fd JobId 124: /opt is a different filesystem. Will not > descend from / into /opt > bocsles-fd JobId 124: /var/lib/ntp/proc is a different filesystem. > Will not descend from / into /var/lib/ntp/proc > bocsles-fd JobId 124: /home is a different filesystem. Will not > descend from / into /home > bocsles-fd JobId 124: /var/lib/ntp/proc is a different filesystem. > Will not descend from /var into /var/lib/ntp/proc > 25-May 02:54 bocsles-sd JobId 124: Job write elapsed time = 00:52:53, > Transfer rate = 22.19 M bytes/second > 25-May 03:15 bocsles-dir JobId 124: Fatal error: Can't 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=disk I/O error > > 25-May 03:15 bocsles-dir JobId 124: Error: sql_update.c:178 > sql_update.c:178 update UPDATE Job SET JobStatus='f',EndTime='2009-05-25 > 03:15:26',ClientId=1,JobBytes=70287992114,JobFiles=805529,JobErrors=0,VolSessionId=1,VolSessionTime=1243209010,PoolId=3,FileSetId=3,JobTDate=1243214126,RealEndTime='2009-05-25 > 03:15:26',PriorJobId=0 WHERE JobId=124 failed: > disk I/O error > 25-May 03:15 bocsles-dir JobId 124: sql_update.c:178 UPDATE Job SET > JobStatus='f',EndTime='2009-05-25 > 03:15:26',ClientId=1,JobBytes=70287992114,JobFiles=805529,JobErrors=0,VolSessionId=1,VolSessionTime=1243209010,PoolId=3,FileSetId=3,JobTDate=1243214126,RealEndTime='2009-05-25 > 03:15:26',PriorJobId=0 WHERE JobId=124 > 25-May 03:15 bocsles-dir JobId 124: Warning: Error updating job record. > sql_update.c:178 update UPDATE Job SET JobStatus='f',EndTime='2009-05-25 > 03:15:26',ClientId=1,JobBytes=70287992114,JobFiles=805529,JobErrors=0,VolSessionId=1,VolSessionTime=1243209010,PoolId=3,FileSetId=3,JobTDate=1243214126,RealEndTime='2009-05-25 > 03:15:26',PriorJobId=0 WHERE JobId=124 failed: > disk I/O error > 25-May 03:15 bocsles-dir JobId 124: Fatal error: sql_get.c:289 > sql_get.c:289 query SELECT > VolSessionId,VolSessionTime,PoolId,StartTime,EndTime,JobFiles,JobBytes,JobTDate,Job,JobStatus,Type,Level,ClientId,Name,PriorJobId,RealEndTime,JobId,FileSetId,SchedTime,RealEndTime > FROM Job WHERE JobId=124 failed: > disk I/O error > 25-May 03:15 bocsles-dir JobId 124: sql_get.c:289 SELECT > VolSessionId,VolSessionTime,PoolId,StartTime,EndTime,JobFiles,JobBytes,JobTDate,Job,JobStatus,Type,Level,ClientId,Name,PriorJobId,RealEndTime,JobId,FileSetId,SchedTime,RealEndTime > FROM Job WHERE JobId=124 > 25-May 03:15 bocsles-dir JobId 124: Warning: Error getting Job record for > Job report: ERR=sql_get.c:289 query SELECT > VolSessionId,VolSessionTime,PoolId,StartTime,EndTime,JobFiles,JobBytes,JobTDate,Job,JobStatus,Type,Level,ClientId,Name,PriorJobId,RealEndTime,JobId,FileSetId,SchedTime,RealEndTime > FROM Job WHERE JobId=124 failed: > disk I/O error > 25-May 03:15 bocsles-dir JobId 124: Fatal error: sql_get.c:672 > sql_get.c:672 query SELECT > ClientId,Name,Uname,AutoPrune,FileRetention,JobRetention FROM Client WHERE > Client.Name='bocsles-fd' failed: > disk I/O error > 25-May 03:15 bocsles-dir JobId 124: sql_get.c:672 SELECT > ClientId,Name,Uname,AutoPrune,FileRetention,JobRetention FROM Client WHERE > Client.Name='bocsles-fd' > 25-May 0
[Bacula-users] Antwort: Re: Antwort: Re: Bacula didn't start anymore
Hi Reiner, I didn't change the bacula-dir.conf. Bacula is running since the last two month with out a problem. All of sudden last monday my backup failed. I tried then to access bacula and got that failure, after I restarted bacula. I first checked, if the configuration was corrupted, after that I checked the working folders for missing files etc. The databasefile bacula.db is in the working dir /root/bacula/working/ and has a size of nearly 2 GB. My problem is that I also have no experience with sqlite, but I wasn't aloud to use an other one like mysql. Mit freundlichen Gruessen Wolf-Elmar Rath SYSTEM COMPETENCE GmbH Ohlendorfer Strasse 40 21220 Seevetal Telefon: 04185-77-0 Telefax: 04185-77-440 Email: elmar.r...@systemcompetence.de Sitz der Gesellschaft: Seevetal Geschäftsführer: Sven Hannemann, Martin Pranzner, Rigo Rothenbröker Handelsregister: HRB 111223, Amtsgericht Lüneburg SystemManagement 27.05.2009 15:26 Bitte antworten an dass...@fs.wettzell.de An elmarr...@systemcompetence.de Kopie dass...@fs.wettzell.de, bacula-users@lists.sourceforge.net Thema Re: [Bacula-users] Antwort: Re: Bacula didn't start anymore Hi, starting from bacula-dir: dird.c:883 sqlite.c:210 Unable to open Database=/root/bacula/working/bacula.db. ERR=out of memory 26-May 16:54 bacula-dir ERROR TERMINATION Please correct configuration file: bacula-dir.conf there are different subjects to consider: - bacula-dir.conf - SQLite - bacula-dir Did you change bacula-dir.conf before the problem arises? As I remember there is a tool to check the syntax of this file. (Please, ask the docs) Does file "/root/bacula/working/bacula.db" exists? Did you made sure that SQLite causes the problem? I have no experiences with SQLite but you shold use or write a test application to access the database without using bacula Is there a tool to check the conistency of the SQLite database? That are my ideas for further steps. Regards, Reiner elmarr...@systemcompetence.de schrieb: > Hi, > > I checked the raid and the disks twice if there is any problem. Gpart > didn't found anything. > My major problem is that bacula-dir isn't starting, because I 've got he > out of memory message, > that I posted on the end of my mail. > > Mit freundlichen Gruessen > > > Wolf-Elmar Rath > > SYSTEM COMPETENCE GmbH > Ohlendorfer Strasse 40 > 21220 Seevetal > > Telefon: 04185-77-0 > Telefax: 04185-77-440 > Email: elmar.r...@systemcompetence.de > > Sitz der Gesellschaft: Seevetal > Geschäftsführer: Sven Hannemann, Martin Pranzner, Rigo Rothenbröker > Handelsregister: HRB 111223, Amtsgericht Lüneburg > > > > SystemManagement > 26.05.2009 17:41 > Bitte antworten an > dass...@fs.wettzell.de > > > An > elmarr...@systemcompetence.de > Kopie > bacula-users@lists.sourceforge.net > Thema > Re: [Bacula-users] Bacula didn't start anymore > > > > > > > Hallo, > > the messages point to a disc problem. > > I see: ERR=disk I/O error > > Check your discs! > > Reiner > > > elmarr...@systemcompetence.de schrieb: > >> Haloo, >> >> I hope someone could help me wirth my problem. Monday morning faild my >> backup with the following log. >> >> >> >> 25-May 02:01 bocsles-dir JobId 124: Start Backup JobId 124, >> Job=Nightly-Save-bocsles.2009-05-25_02.01.00.02 >> 25-May 02:01 bocsles-dir JobId 124: Using Device "LTO4" >> 25-May 02:01 bocsles-sd JobId 124: Error: 25-May 02:01 bocsles-sd JobId >> 124: Volume "LIN-TAG-22" previously written, moving to end of data. >> 25-May 02:01 bocsles-sd JobId 124: Ready to append to end of Volume >> "LIN-TAG-22" at file=136. >> bocsles-fd JobId 124: /dev is a different filesystem. Will not >> descend from / into /dev >> bocsles-fd JobId 124: /opt is a different filesystem. Will not >> descend from / into /opt >> bocsles-fd JobId 124: /var/lib/ntp/proc is a different filesystem. >> Will not descend from / into /var/lib/ntp/proc >> bocsles-fd JobId 124: /home is a different filesystem. Will not >> descend from / into /home >> bocsles-fd JobId 124: /var/lib/ntp/proc is a different filesystem. >> Will not descend from /var into /var/lib/ntp/proc >> 25-May 02:54 bocsles-sd JobId 124: Job write elapsed time = 00:52:53, >> Transfer rate = 22.19 M bytes/second >> 25-May 03:15 bocsles-dir JobId 124: Fatal error: Can't 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=disk I/O error >> >> 25-May 03:15 bocsles-dir JobId 124: Error: sql_update.c:178 >> sql_update.c:178 update UPDATE Job SET JobStatus='f',EndTime='2009-05-25 >> > > > 03:15:26',ClientId=1,JobBytes=70287992114,JobFiles=805529,JobErrors=0,VolSessionId=1,VolSessionTime=1243209010,PoolId=3,FileSetId=3,JobTDate=1243214126,RealEndTime='2009-05-25 > > >> 03:15:26',Pr
