Bacula-users

[Bacula-users] failed:,database is full

2011-08-05 11:46:12
Subject: [Bacula-users] failed:,database is full
From: terryc <terryc AT woa.com DOT au>
To: Bacula-users AT lists.sourceforge DOT net
Date: Sat, 06 Aug 2011 01:43:31 +1000
I am now getting  ..."failed: database is full" error messages.
Job completes, but fails at the end with this sequence of messages.
Using sqlite.

...............................................................
05-Aug 15:19 damselfly-sd JobId 10362: Writing spooled data to Volume. 
Despooling 2,543,471,533 bytes ...
05-Aug 15:22 damselfly-dir JobId 10362: Fatal error: sql_create.c:145 
sql_create.c:145 insert INSERT INTO JobMedia 
(JobId,MediaId,FirstIndex,LastIndex,StartFile,EndFile,StartBlock,EndBlock,VolIndex,Copy)
 
VALUES (10362,196,1,6484,0,0,1,15499,2,0) failed:
database is full
05-Aug 15:22 damselfly-dir JobId 10362: Fatal error: Catalog error 
creating JobMedia record. sql_create.c:147 Create JobMedia record INSERT 
INTO JobMedia 
(JobId,MediaId,FirstIndex,LastIndex,StartFile,EndFile,StartBlock,EndBlock,VolIndex,Copy)
 
VALUES (10362,196,1,6484,0,0,1,15499,2,0) failed: ERR=database is full
05-Aug 15:22 damselfly-sd JobId 10362: Fatal error: Error creating 
JobMedia record: 1992 Create JobMedia error

05-Aug 15:22 damselfly-sd JobId 10362: Fatal error: block.c:799 Could 
not create JobMedia record for Volume="DLT-IV-018" 
Job=DamselfyHome.2011-08-05_14.54.22.08
05-Aug 15:22 damselfly-dir JobId 10362: Error: sql_update.c:334 
sql_update.c:334 update UPDATE Media Set LastWritten='2011-08-05 
15:22:21' WHERE VolumeName='DLT-IV-018' failed:
database is full
05-Aug 15:22 damselfly-dir JobId 10362: Error: sql_update.c:366 
sql_update.c:366 update UPDATE Media SET 
VolJobs=1,VolFiles=2,VolBlocks=15499,VolBytes=999936000,VolMounts=34,VolErrors=0,VolWrites=8591797,MaxVolBytes=0,VolStatus='Full',Slot=3,InChanger=1,VolReadTime=0,VolWriteTime=166619730522,VolParts=0,LabelType=0,StorageId=6,PoolId=9,VolRetention=2592000,VolUseDuration=0,MaxVolJobs=0,MaxVolFiles=0,Enabled=1,LocationId=0,ScratchPoolId=0,RecyclePoolId=0,RecycleCount=14
 
WHERE VolumeName='DLT-IV-018' failed:
database is full
05-Aug 15:22 damselfly-dir JobId 10362: Error: sql_update.c:453 
sql_update.c:453 update UPDATE Media SET InChanger=0, Slot=0 WHERE 
Slot=3 AND StorageId=6 AND MediaId!=196 failed:
database is full
05-Aug 15:22 damselfly-dir JobId 10362: Fatal error: Catalog error 
updating Media record. sql_update.c:453 update UPDATE Media SET 
InChanger=0, Slot=0 WHERE Slot=3 AND StorageId=6 AND MediaId!=196 failed:
database is full
.......................................................
Web search turned up;
a) no disk space. Not the problem, 2.4Gb available.
b) media related problems, but that was for Sd card.

I have tried a DUMP and reload, but that didn't fix the problem.
It did reduce the bacula.db by 50%, but that was all.

Looking for a fix or ideas to try.

-- 
Terry Collins {:-)}}}}}
Bicycles, Minimal Technology, Natural Environment, Metal Mangling

------------------------------------------------------------------------------
BlackBerry&reg; DevCon Americas, Oct. 18-20, San Francisco, CA
The must-attend event for mobile developers. Connect with experts. 
Get tools for creating Super Apps. See the latest technologies.
Sessions, hands-on labs, demos & much more. Register early & save!
http://p.sf.net/sfu/rim-blackberry-1
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users