2011/8/5 Kleber Leal <kleber.leal AT gmail DOT com>

Are using mysql ou postgres?
What version?

Kleber

2011/8/5 terryc <terryc AT woa.com DOT au>

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

------------------------------------------------------------------------------
BlackBerry® 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