Bacula-users

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

2011-04-15 21:48:34
Subject: Re: [Bacula-users] Duplicate entries on mysql database
From: "James Harper" <james.harper AT bendigoit.com DOT au>
To: "Leonardo Almeida Lage" <leo AT hostrevenda DOT com>, <bacula-users AT lists.sourceforge DOT net>
Date: Sat, 16 Apr 2011 11:45:34 +1000
> 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 AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users

<Prev in Thread] Current Thread [Next in Thread>