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
