> > > > 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.
all right, here is my configuration: backup-server is a P4 2,8GHz on a Fujitsu-Siemens Mainboard, 512MB RAM (upgrade to 2GB planned), 2 SATA disks for system (soft-mirrored), Gigabit ethernet (3C996B-T with tg3 driver), 2 LSI 22320 (MPT Dual Ultra320 SCSI hostadapter) for connecting 2 Infortrend EonStor SATA-SCSI-Raids with 2TB (each). system is running Fedora Core 3 (all patches except last kernel update 2.6.12-1.1376 as it won't boot with this smp-kernel), mysql is 4.1.12 and bacula is 1.36.3. when my system stops there are NO entries in any logfile, no crash-dump after reboot and i've no idea what's going on when it stops (it's totally frozen at this time, no output to console, no input possible). i'm monitoring the server with HotSaNIC and it also shows no special problems before the server stops. the only thing which is common for all times is that there are 4 or 5 of my heavy load backups are running at this time, so there is much traffic on my network-card and also much traffic to both Raids. but these backups run fine for 3 or 4 days and after that at the next run the server stops.... thanks, chris > > > > 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
