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 > [email protected] > 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 [email protected] https://lists.sourceforge.net/lists/listinfo/bacula-users
