On Wednesday 11 April 2007 18:36, Christian Bille wrote: > Okay thanks for your answer. Sure we are all in work and time is precious. > > And while we are at it: Please provide some basic system information: > Bacula version, relevant configuration, relevant job output etc. > > Okay then i'll try to provide some informations. Hope that this one is the > right one > ---------------------------------------- > The last backup job working fine > ---------------------------------------- > 06-Apr 16:44 epicure-dir: Start Backup JobId 43, > Job=ARCHIVER.2007-04-06_16.44.05 > 06-Apr 16:44 epicure-sd: 3301 Issuing autochanger "loaded? drive 0" command. > 06-Apr 16:44 epicure-sd: 3302 Autochanger "loaded? drive 0", result is Slot > 11. > 06-Apr 16:44 epicure-sd: Wrote label to prelabeled Volume "archives-29" on > device "Drive-1" (/dev/nst0) > 06-Apr 18:43 epicure-sd: Job write elapsed time = 01:59:47, Transfer rate = > 30.36 M bytes/second > 06-Apr 18:43 epicure-dir: Bacula 2.0.2 (28Jan07): 06-Apr-2007 18:43:58 > JobId: 43 > Job: ARCHIVER.2007-04-06_16.44.05 > Backup Level: Full > Client: "epicure-fd" 2.0.2 (28Jan07) > i686-suse-linux-gnu,suse,10.0 > FileSet: "archives" 2007-04-06 16:44:05 > Pool: "Archives" (From Job resource) > Storage: "EpicureUltrium" (From command line) > Scheduled time: 06-Apr-2007 16:43:32 > Start time: 06-Apr-2007 16:44:08 > End time: 06-Apr-2007 18:43:58 > Elapsed time: 1 hour 59 mins 50 secs > Priority: 10 > FD Files Written: 21,404 > SD Files Written: 21,404 > FD Bytes Written: 218,254,742,652 (218.2 GB) > SD Bytes Written: 218,258,595,119 (218.2 GB) > Rate: 30355.3 KB/s > Software Compression: None > VSS: no > Encryption: no > Volume name(s): archives-29 > Volume Session Id: 2 > Volume Session Time: 1175869447 > Last Volume Bytes: 218,420,923,392 (218.4 GB) > Non-fatal FD errors: 0 > SD Errors: 0 > FD termination status: OK > SD termination status: OK > Termination: Backup OK > > 06-Apr 18:43 epicure-dir: Begin pruning Jobs. > 06-Apr 18:43 epicure-dir: No Jobs found to prune. > 06-Apr 18:43 epicure-dir: Begin pruning Files. > 06-Apr 18:43 epicure-dir: No Files found to prune. > 06-Apr 18:43 epicure-dir: End auto prune. > > ----------------------------------------- > Job output of a job which errors > Note : All Mysql errors are the same for the jobs following > Duplicate entry '45-41' for key 2 > Duplicate entry '46-41' for key 2 > Duplicate entry '47-41' for key 2 > ...... > ----------------------------------------- > 10-Apr 15:07 epicure-dir: Start Backup JobId 45, > Job=ARCHIVER.2007-04-10_15.07.00 > 10-Apr 15:07 epicure-sd: Wrote label to prelabeled Volume "archives-29copie" > on device "Drive-1" (/dev/nst0) > 10-Apr 15:33 epicure-dir: ARCHIVER.2007-04-10_15.07.00 Fatal error: > sql_create.c:142 sql_create.c:142 insert INSERT INTO JobMedia > (JobId,MediaId,FirstIndex,LastIndex,StartFile,EndFile,StartBlock,EndBlock,Vo > lIndex,Copy) VALUES (45,41,12141,12158,47,47,0,15499,48,0) failed: > Duplicate entry '45-41' for key 2 > 10-Apr 15:33 epicure-dir: ARCHIVER.2007-04-10_15.07.00 Fatal error: Catalog > error creating JobMedia record. sql_create.c:144 Create JobMedia record > INSERT INTO JobMedia > (JobId,MediaId,FirstIndex,LastIndex,StartFile,EndFile,StartBlock,EndBlock,Vo > lIndex,Copy) VALUES (45,41,12141,12158,47,47,0,15499,48,0) failed: > ERR=Duplicate entry '45-41' for key 2 > 10-Apr 15:33 epicure-sd: ARCHIVER.2007-04-10_15.07.00 Fatal error: Error > creating JobMedia record: 1991 Update JobMedia error
Your MySQL database is broken, because none of the values that are inserted are required to be unique -- in fact, they are definitely NOT unique. Either the tables were not created correctly, you modified how they are created, or the database is corrupted in some way. If you have not fooled with the table creation process, try running the mysql table repair program. If you have modified the table definitions provided, then something went wrong. > > 10-Apr 15:33 epicure-sd: ARCHIVER.2007-04-10_15.07.00 Fatal error: Could not > create JobMedia record for Volume="archives-29copie" > Job=ARCHIVER.2007-04-10_15.07.00 > 10-Apr 15:33 epicure-sd: Job write elapsed time = 00:26:39, Transfer rate = > 29.99 M bytes/second > 10-Apr 15:33 epicure-fd: ARCHIVER.2007-04-10_15.07.00 Fatal error: > backup.c:860 Network send error to SD. ERR=Connection reset by peer > 10-Apr 15:33 epicure-fd: ARCHIVER.2007-04-10_15.07.00 Error: bnet.c:439 > Write error sending 65536 bytes to Storage daemon:experience:9103: > ERR=Connection reset by peer > 10-Apr 15:33 epicure-dir: ARCHIVER.2007-04-10_15.07.00 Error: Bacula 2.0.2 > (28Jan07): 10-Apr-2007 15:33:58 > JobId: 45 > Job: ARCHIVER.2007-04-10_15.07.00 > Backup Level: Full > Client: "epicure-fd" 2.0.2 (28Jan07) > i686-suse-linux-gnu,suse,10.0 > FileSet: "archives" 2007-04-06 16:44:05 > Pool: "Archives" (From Job resource) > Storage: "EpicureUltrium" (From command line) > Scheduled time: 10-Apr-2007 15:04:50 > Start time: 10-Apr-2007 15:07:04 > End time: 10-Apr-2007 15:33:58 > Elapsed time: 26 mins 54 secs > Priority: 10 > FD Files Written: 12,158 > SD Files Written: 12,158 > FD Bytes Written: 47,959,261,086 (47.95 GB) > SD Bytes Written: 47,961,105,153 (47.96 GB) > Rate: 29714.5 KB/s > Software Compression: None > VSS: no > Encryption: no > Volume name(s): archives-29copie > Volume Session Id: 1 > Volume Session Time: 1176197537 > Last Volume Bytes: 47,996,928,000 (47.99 GB) > Non-fatal FD errors: 1 > SD Errors: 0 > FD termination status: Error > SD termination status: Error > Termination: *** Backup Error *** > > > > > -----Message d'origine----- > De : [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] De la part de Arno > Lehmann > Envoyé : mercredi 11 avril 2007 17:57 > À : bacula-users@lists.sourceforge.net > Objet : Re: [Bacula-users] Last Volume Bytes, Back up Error > > Hi, > > On 4/11/2007 12:29 PM, Christian Bille wrote: > > Hi > > while we are in newbie questions :)) > > And while we are at it: Please provide some basic system information: > Bacula version, relevant configuration, relevant job output etc. > > > i'm listening the list since february but didn't post any question yet. > > could answer to them quite myself, but this one is too astonishing for me. > > > > i did backup some archives on two tapes (lto-2 200gb 400gb compressed) > works > > fine friday. since tuesday i want to backup a second time the archives > what > > is the backup policy here (all tapes are in double) but since tuesday all > my > > tries fail at the same point. > > > > Last Volume Bytes : 47,996,928,000 (47,99GB) > > Non fatal Errors : 1 > > SD Errors : 0 > > FD termination status : Error > > SD termination status : Error > > Termination : *** Backup Error *** > > > > I tried different tapes, looked for faults in configuration files, i do > not > > understand where this error comes from. > > Look at the whole of the job report - there should be a detailed error > message (from Baculas point of view). > > In your case, you need to supply the complete job output, not only the > fact that there was an error. Versions, OS, catalog database, > configuration are not important now, but please try to provide some > useful information. Many list users will not ask for necessary > information, I try to do so, but even my time is limited :-) > > Arno > > > Thanks in advance for your help > > > > Christian > > > > > > > > ------------------------------------------------------------------------- > > Take Surveys. Earn Cash. Influence the Future of IT > > Join SourceForge.net's Techsay panel and you'll get the chance to share > your > > opinions on IT & business topics through brief surveys-and earn cash > > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV > > _______________________________________________ > > Bacula-users mailing list > > Bacula-users@lists.sourceforge.net > > https://lists.sourceforge.net/lists/listinfo/bacula-users > > -- > IT-Service Lehmann [EMAIL PROTECTED] > Arno Lehmann http://www.its-lehmann.de > > ------------------------------------------------------------------------- > Take Surveys. Earn Cash. Influence the Future of IT > Join SourceForge.net's Techsay panel and you'll get the chance to share your > opinions on IT & business topics through brief surveys-and earn cash > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV > _______________________________________________ > Bacula-users mailing list > Bacula-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/bacula-users > > > __________ Information NOD32 2181 (20070411) __________ > > Ce message a ete verifie par NOD32 Antivirus System. > http://www.nod32.com > > > > ------------------------------------------------------------------------- > Take Surveys. Earn Cash. Influence the Future of IT > Join SourceForge.net's Techsay panel and you'll get the chance to share your > opinions on IT & business topics through brief surveys-and earn cash > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV > _______________________________________________ > Bacula-users mailing list > Bacula-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/bacula-users > ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys-and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
