Bacula-users

[Bacula-users] Duplicate entries on mysql database

2011-04-15 20:09:04
Subject: [Bacula-users] Duplicate entries on mysql database
From: Leonardo Almeida Lage <leo AT hostrevenda DOT com>
To: bacula-users AT lists.sourceforge DOT net
Date: Fri, 15 Apr 2011 20:37:43 -0300
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 AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users

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