Hello,
Well, I don't understand this at all because there should only be two keys on
the File table. 1 is the primary key, which must be unique and is FileId.
The second is an index on several items, and it does not need to be unique.
Now, for the first key FileId, I do not specify it in the INSERT, so MySQL
should automatically select a unique key. The second index should not
matter.
Perhaps you have run into some limitation of the MySQL database -- e.g.
maximum number of rows and you need to increase this value. If that is the
case, I would say that the error message (created by MySQL) is not very
appropriate.
You might search their manual and see if there is some silly limitation
(maximum rows?) around 59 million -- it is complaining about 59302989, but
that may not be the exact number of rows you have in that table.
Please send text to the list instead of html in your future messages. Thanks.
On Friday 09 September 2005 14:29, Masopust Christian wrote:
> > > 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
>
--
Best regards,
Kern
(">
/\
V_V
-------------------------------------------------------
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
