Bacula-users

[Bacula-users] mysql-> postgres conversion. Problems...

2010-03-19 14:19:35
Subject: [Bacula-users] mysql-> postgres conversion. Problems...
From: Alan Brown <ajb2 AT mssl.ucl.ac DOT uk>
To: bacula-users AT lists.sourceforge DOT net
Date: Fri, 19 Mar 2010 17:53:03 +0000
bacula 5.0.1, postgres 8.1

Any ideas why I'm getting this?

9-Mar 17:47 msslay-dir JobId 6: 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 WHERE Name = a.Name): ERR=ERROR:  duplicate key 
violates unique constraint "filename_pkey"

Dan?




------------------------------------------------------------------------------
Download Intel&#174; Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users