Re: [Bacula-users] Duplicate entries on mysql database
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@lists.sourceforge.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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
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@lists.sourceforge.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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Duplicate entries on mysql database
16.4.2011 2:37, Leonardo Almeida Lage kirjoitti: > 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. > Try Baculas dbcheck program. Myisamchk does not fix bad bacula data. -- What no spouse of a writer can ever understand is that a writer is working when he's staring out the window. -- 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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Duplicate entries on mysql database
> 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? > What version of Bacula are you using? James -- 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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Duplicate entries on mysql database
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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users