Hi Elmar,
one additional idea for your problem:
is SQLite running on ext2 file system?
I this is true there may be a 2 GByte file size limit according to
URL http://en.wikipedia.org/wiki/Ext2#File_system_limits
Regards
Reiner
elmarr...@systemcompetence.de schrieb:
> 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 <rd...@fs.wettzell.de>
> 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 <rd...@fs.wettzell.de>
>> 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 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
>>>
>>>
>>>
>>
>>
>> ------------------------------------------------------------------------
>>
>>
>>
> ------------------------------------------------------------------------------
>
>> 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 as they present alongside digital heavyweights like
>>
> Barbarian
>
>> Group, R/GA, & Big Spaceship. http://p.sf.net/sfu/creativitycat-com
>> ------------------------------------------------------------------------
>>
>> _______________________________________________
>> Bacula-users mailing list
>> Bacula-users@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/bacula-users
>>
>>
>
>
>
>
> ------------------------------------------------------------------------
>
> ------------------------------------------------------------------------------
> 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 as they present alongside digital heavyweights like Barbarian
> Group, R/GA, & Big Spaceship. http://p.sf.net/sfu/creativitycat-com
> ------------------------------------------------------------------------
>
> _______________________________________________
> Bacula-users mailing list
> Bacula-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/bacula-users
>
------------------------------------------------------------------------------
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 as they present alongside digital heavyweights like Barbarian
Group, R/GA, & Big Spaceship. http://p.sf.net/sfu/creativitycat-com
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
