> > anyway i dont think that this really happend, because he writes that > > bacula is complaining about > > duplicate entries which means that bacula wants to insert something and > > that would be a duplicate. > > Yes, I cannot argue this point as I am not really sure what is going on > because Christian did not show the actual error message. Bacula does not care > if there are duplicate entries in the File table, as far as I remember, and > when it does insert an entry in that table, the FileId of NULL is used.
sorry, i was out of office this week ..... here are the exact errormessages i get when running into this problem: 05-Sep 22:07 atpcc7fc-dir: sunserv-system.2005-09-05_22.07.39 Fatal error: sql_create.c:564 sql_create.c:564 insert INSERT INTO File (FileIndex,JobId,PathId,FilenameId,LStat,MD5) VALUES (1,3473,561200,2164602,'gAFo igq IGk B A B A L8 CAA C BCGe2H BDG/ZC BDG/ZC A A E','0') failed: Duplicate entry '59302989' for key 1 05-Sep 22:07 atpcc7fc-dir: sql_create.c:564 INSERT INTO File (FileIndex,JobId,PathId,FilenameId,LStat,MD5) VALUES (1,3473,561200,2164602,'gAFo igq IGk B A B A L8 CAA C BCGe2H BDG/ZC BDG/ZC A A E','0') 05-Sep 22:07 atpcc7fc-dir: sunserv-system.2005-09-05_22.07.39 Fatal error: sql_create.c:566 Create db File record INSERT INTO File (FileIndex,JobId,PathId,FilenameId,LStat,MD5) VALUES (1,3473,561200,2164602,'gAFo igq IGk B A B A L8 CAA C BCGe2H BDG/ZC BDG/ZC A A E','0') failed. ERR=Duplicate entry '59302989' for key 1 05-Sep 22:07 atpcc7fc-dir: sunserv-system.2005-09-05_22.07.39 Fatal error: catreq.c:346 Attribute create error. sql_create.c:566 Create db File record INSERT INTO File (FileIndex,JobId,PathId,FilenameId,LStat,MD5) VALUES (1,3473,561200,2164602,'gAFo igq IGk B A B A L8 CAA C BCGe2H BDG/ZC BDG/ZC A A E','0') failed. ERR=Duplicate entry '59302989' for key 1 05-Sep 22:07 atpcc7fc-dir: sunserv-system.2005-09-05_22.07.39 Error: Catalog error updating MD5/SHA1. sql_update.c:65 Update problem: affected_rows=0 05-Sep 22:07 atpcc7fc-dir: sunserv-system.2005-09-05_22.07.39 Fatal error: sql_create.c:564 sql_create.c:564 insert INSERT INTO File (FileIndex,JobId,PathId,FilenameId,LStat,MD5) VALUES (2,3473,561200,1,'gAFo igA EHt C A D A IA CAA C BBtYzd BDG/ZC BDG/ZC A A E','0') failed: Duplicate entry '59302989' for key 1 and i get many of these messages (i think one for each file saved for the current job). thanks a lot! christian ------------------------------------------------------- SF.Net email is Sponsored by the Better Software Conference & EXPO September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices Agile & Plan-Driven Development * Managing Projects & Teams * Testing & QA Security * Process Improvement & Measurement * http://www.sqe.com/bsce5sf _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
