Are using mysql ou postgres?
What version?
Kleber
2011/8/5 terryc <ter...@woa.com.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® 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@lists.sourceforge.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@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
