On Monday 12 September 2005 10:52, Masopust Christian wrote: > hello kern, > > sorry for the delay.... > > all right, it really is no problem in bacula, i've some problems with my > backup-server. it suddenly stops working during backup and after reboot i > always get these messages. seems that database gets currupt when my server > stops...
This doesn't seem at all normal to me. I suggest you send a few more details to the bacula-users list, such as your OS/version, the MySQL version, and more of the details of why your backup server stops. Normally, if you are running a Linux system, it doesn't just stop and there is no reason to reboot, it is just perhaps a matter of killing off an errant program. If you are rebooting without properly shutting down your MySQL server (which should be automatic), this could potentially cause problems like this, but that would be rather exceptional. I think something else is going wrong like bad memory, or other hardware problems. Perhaps when you explain more in detail what is happening, someone can help you. > > anyway, thanks a lot for your support! > chris > > > -----Original Message----- > > From: Kern Sibbald [mailto:[EMAIL PROTECTED] > > Sent: Friday, September 09, 2005 2:58 PM > > To: Masopust Christian > > Cc: bacula-users@lists.sourceforge.net > > Subject: Re: AW: [Bacula-users] Big problems with my Bacula..... > > > > 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 -- 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
