Bacula-users

[Bacula-users] Strange sql error

2013-08-19 15:57:36
Subject: [Bacula-users] Strange sql error
From: Demeter Tibor <tdemeter AT itsmart DOT hu>
To: bacula-users <bacula-users AT lists.sourceforge DOT net>
Date: Mon, 19 Aug 2013 21:34:32 +0200 (CEST)
Hi,

I got this error message when I ran a restore process.


19-Aug 20:35 bacula-dir JobId 0: Fatal error: bvfs.c:356 bvfs.c:356 query INSERT INTO PathVisibility (PathId, JobId) SELECT DISTINCT PathId, JobId FROM (SELECT PathId, JobId FROM File WHERE JobId = 3971 UNION SELECT PathId, BaseFiles.JobId FROM BaseFiles JOIN File AS F USING (FileId) WHERE BaseFiles.JobId = 3971) AS B failed:
Duplicate entry '3971-1' for key 'PRIMARY'
19-Aug 20:40 bacula-dir JobId 0: Fatal error: bvfs.c:356 bvfs.c:356 query INSERT INTO PathVisibility (PathId, JobId) SELECT DISTINCT PathId, JobId FROM (SELECT PathId, JobId FROM File WHERE JobId = 3971 UNION SELECT PathId, BaseFiles.JobId FROM BaseFiles JOIN File AS F USING (FileId) WHERE BaseFiles.JobId = 3971) AS B failed:
Duplicate entry '3971-1' for key 'PRIMARY'



What does this mean?

How can I do a DB repair?

The db backend is MySQL.

Thanks,

Best regards,


Demeter Tibor

------------------------------------------------------------------------------
Introducing Performance Central, a new site from SourceForge and 
AppDynamics. Performance Central is your source for news, insights, 
analysis and resources for efficient Application Performance Management. 
Visit us today!
http://pubads.g.doubleclick.net/gampad/clk?id=48897511&iu=/4140/ostg.clktrk
_______________________________________________
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>
  • [Bacula-users] Strange sql error, Demeter Tibor <=