Hello,
Thanks for replies...
I my case, I'm running bacula on vps server, de dbcheck fix problems,
but delay a big time to finish.. . I make a single purge of old backups
too (my File table have 10GB!) and now problem is fixed... now i migrate
bacula db for a more best server too.
If problem back, I try another sugestions and post results here.
Thanks
Leonardo
On 18-04-2011 08:58, Matias Banchoff wrote:
> Hi!
> once I had a problem with our MySQL catalog. I don't know if the
> problem is the same, but perhaps this helps you...
> 1) First, make a dump of your database, just in case!!!!
> 2) You can run from the mysql console:
> - check table, to verify data and indexes integrity.
> - Repair table, fixes a table magically (I don't know how mysql
> repairs the table).
> - analyze table, it works on the indexes trying to optimize them.
> But I don't remember whether it fixes anything.
>
> Si hablás castellano, te paso unas notas que tomé en ese momento sobre
> el catálogo roto y cómo arreglarlo:
>
> Comandos usados:
> - check table: verifica la integridad de los datos e índices.
> - comando perror unNumeroDeError: da el significado del error
> unNumeroDeError
> - repair table: arregla una tabla mágicamente
> - optimize table: defragmenta el espacio (en este caso deberia
> correrse una vez por semana sobre bacula.File). Trabaja sobre los
> archivos de datos
> - analyze table: similar, pero sobre los indices. Este no lo corri
>
> Bye!!! Saludos!!!
>
> On 04/15/2011 08:37 PM, Leonardo Almeida Lage wrote:
>> Hello Friends,
>>
>> I'm using bacula at one month.. no problems, but this week, many jobs
>> fail, with this error:
>>
>> 2011-04-15 20:19:25 JobId 637: Fatal error: sql_create.c:875 Fill
>> Filename table Query failed: INSERT INTO Filename (Name) SELECT a.Name
>> FROM (SELECT DISTINCT Name FROM batch) AS a WHERE NOT EXISTS (SELECT
>> Name FROM Filename AS f WHERE f.Name = a.Name): ERR=Duplicate entry
>> '20821966' for key 1
>>
>> My database really have big number of register, but have a limit?
>>
>> I use mysql database, I already try to repair db using myisamchk but not
>> fix problem.
>>
>> Anybody already see this problem?
>>
>> Thanks
>>
>> Leonardo
>>
>> ------------------------------------------------------------------------------
>>
>>
>> Benefiting from Server Virtualization: Beyond Initial Workload
>> Consolidation -- Increasing the use of server virtualization is a top
>> priority.Virtualization can reduce costs, simplify management, and
>> improve
>> application availability and disaster protection. Learn more about
>> boosting
>> the value of server virtualization. http://p.sf.net/sfu/vmware-sfdev2dev
>> _______________________________________________
>> Bacula-users mailing list
>> Bacula-users AT lists.sourceforge DOT net
>> https://lists.sourceforge.net/lists/listinfo/bacula-users
>
> -----
> CeSPI Centro Superior para el Procesamiento de la Información
>
> Universidad Nacional de La Plata
> -------------------------------------------------------------------------------
>
>
> Proteja el Medioambiente. No imprima este mail si no es absolutamente
> necesario
------------------------------------------------------------------------------
Benefiting from Server Virtualization: Beyond Initial Workload
Consolidation -- Increasing the use of server virtualization is a top
priority.Virtualization can reduce costs, simplify management, and improve
application availability and disaster protection. Learn more about boosting
the value of server virtualization. http://p.sf.net/sfu/vmware-sfdev2dev
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
|
