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,ScratchPoolId,RecyclePoolId,VolReadTime,VolWriteTime
FROM Media WHERE VolumeName='LIN-TAG-22'
25-May 03:15 bocsles-dir JobId 124: Warning: Error getting Media record
for Volume "LIN-TAG-22": ERR=Media record for Vol=LIN-TAG-22 not found in
Catalog.
25-May 03:15 bocsles-dir JobId 124: Fatal error: sql_get.c:359
sql_get.c:359 query SELECT VolumeName,MAX(VolIndex) FROM JobMedia,Media
WHERE JobMedia.JobId=124 AND JobMedia.MediaId=Media.MediaId GROUP BY
VolumeName ORDER BY 2 ASC failed:
disk I/O error
25-May 03:15 bocsles-dir JobId 124: sql_get.c:359 SELECT
VolumeName,MAX(VolIndex) FROM JobMedia,Media WHERE JobMedia.JobId=124 AND
JobMedia.MediaId=Media.MediaId GROUP BY VolumeName ORDER BY 2 ASC
25-May 03:15 bocsles-dir JobId 124: Error: Bacula bocsles-dir 2.4.4
(28Dec08): 25-May-2009 03:15:26
Build OS: powerpc64-unknown-linux-gnu suse 10
JobId: 124
Job: Nightly-Save-bocsles.2009-05-25_02.01.00.02
Backup Level: Full
Client: "bocsles-fd"
FileSet: "BOC_Full_Set" 2009-03-17 02:01:00
Pool: "TagesPool" (From Job resource)
Storage: "LTO4" (From Job resource)
Scheduled time: 25-May-2009 02:01:00
Start time: 25-May-2009 02:01:03
End time: 25-May-2009 03:15:26
Elapsed time: 1 hour 14 mins 23 secs
Priority: 10
FD Files Written: 805,529
SD Files Written: 805,529
FD Bytes Written: 70,287,992,114 (70.28 GB)
SD Bytes Written: 70,412,688,427 (70.41 GB)
Rate: 15749.0 KB/s
Software Compression: None
VSS: no
Storage Encryption: no
Volume name(s):
Volume Session Id: 1
Volume Session Time: 1243209010
Last Volume Bytes: 0 (0 B)
Non-fatal FD errors: 1
SD Errors: 0
FD termination status: OK
SD termination status: OK
Termination: *** Backup Error ***
25-May 03:15 bocsles-dir JobId 124: Begin pruning Jobs.
25-May 03:15 bocsles-dir JobId 124: Fatal error: sql_create.c:488
sql_create.c:488 query SELECT ClientId,Uname FROM Client WHERE
Name='bocsles-fd' failed:
disk I/O error
25-May 03:15 bocsles-dir JobId 124: sql_create.c:488 SELECT ClientId,Uname
FROM Client WHERE Name='bocsles-fd'
25-May 03:15 bocsles-dir JobId 124: Fatal error: sql_create.c:523
sql_create.c:523 insert INSERT INTO Client
(Name,Uname,AutoPrune,FileRetention,JobRetention) VALUES
('bocsles-fd','',0,0,0) failed:
disk I/O error
25-May 03:15 bocsles-dir JobId 124: sql_create.c:523 INSERT INTO Client
(Name,Uname,AutoPrune,FileRetention,JobRetention) VALUES
('bocsles-fd','',0,0,0)
25-May 03:15 bocsles-dir JobId 124: Error: sql_create.c:525 Create DB
Client record INSERT INTO Client
(Name,Uname,AutoPrune,FileRetention,JobRetention) VALUES
('bocsles-fd','',0,0,0) failed. ERR=disk I/O error
25-May 03:15 bocsles-dir JobId 124: Begin pruning Files.
25-May 03:15 bocsles-dir JobId 124: Fatal error: sql_create.c:488
sql_create.c:488 query SELECT ClientId,Uname FROM Client WHERE
Name='bocsles-fd' failed:
disk I/O error
25-May 03:15 bocsles-dir JobId 124: sql_create.c:488 SELECT ClientId,Uname
FROM Client WHERE Name='bocsles-fd'
25-May 03:15 bocsles-dir JobId 124: Fatal error: sql_create.c:523
sql_create.c:523 insert INSERT INTO Client
(Name,Uname,AutoPrune,FileRetention,JobRetention) VALUES
('bocsles-fd','',0,0,0) failed:
disk I/O error
25-May 03:15 bocsles-dir JobId 124: sql_create.c:523 INSERT INTO Client
(Name,Uname,AutoPrune,FileRetention,JobRetention) VALUES
('bocsles-fd','',0,0,0)
25-May 03:15 bocsles-dir JobId 124: Error: sql_create.c:525 Create DB
Client record INSERT INTO Client
(Name,Uname,AutoPrune,FileRetention,JobRetention) VALUES
('bocsles-fd','',0,0,0) failed. ERR=disk I/O error
25-May 03:15 bocsles-dir JobId 124: End auto prune.
After that I tried to restart bacula and get now the following problem:
bocsles:~ # /root/bacula/bin/bacula-dir -t
bacula-dir: dird.c:878 Could not open Catalog "MyCatalog", database
"bacula".
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
bocsles:~ #
I don't know why it thinks, that there is no memory left. I checked my
harddrives and there was more then 14GB space left. Also I didn't have any
problems with my swap or RAM, there should be more then enough memory left
for the backup job to run.
BTW: The bacula.db has a size of 2 GB, could that be a problem for SQLite?
I hope you could help me.
Best regards
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------------------------------------------------------------------------------
Register Now for Creativity and Technology (CaT), June 3rd, NYC. CaT
is a gathering of tech-side developers & brand creativity professionals. Meet
the minds behind Google Creative Lab, Visual Complexity, Processing, &
iPhoneDevCamp asthey present alongside digital heavyweights like Barbarian
Group, R/GA, & Big Spaceship. http://www.creativitycat.com
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
