Re: [Bacula-users] Duplicate entries on mysql database

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