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 AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users