Re: [Bacula-users] failed:,database is full

Kleber Leal Fri, 05 Aug 2011 09:29:18 -0700

MySQL Table is Full
If you are running into the error The table ’File’ is full ..., it is
probably because on version 4.x MySQL,
the table is limited by default to a maximum size of 4 GB and you have
probably run into the limit. The
solution can be found at:
http://dev.mysql.com/doc/refman/5.0/en/full-table.html


Kleber

2011/8/5 Kleber Leal <kleber.l...@gmail.com>

> 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&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@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/bacula-users
>>
>
>

------------------------------------------------------------------------------
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@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] failed:,database is full

Reply via email to