--- [EMAIL PROTECTED] wrote: > I recently ran a backup job that spanned 4 tapes > (DLT-IV) and since this is one of the first backups > on > this system (x86_64) I renamed the source directory > and tried to do a complete restore to verify that my > data is safe. When I ran the restore the job stopped > at the end of the first tape stating that there were > no more volumes to restore and the last file was the > wrong size. What am I doing wrong? I was running > bacula 1.34.6 to back up the data but this version > would not restore it at all (all output files were > zero bytes) so switched to version 1.36.3. Which I > ran > this restore job. > > Here is the last few lines from the gnome console: > > 02-Aug 20:35 dicom-sd: End of Volume at file 52 on > device /dev/st0, Volume "TMImages-0000" > 02-Aug 20:35 dicom-sd: > TMImagesRestore.2005-08-02_16.37.46 Warning: Wrong > Volume mounted on device /dev/st0: Wanted > TMImages-0001 have TMImages-0000 > 02-Aug 20:35 dicom-dir: > TMImagesRestore.2005-08-02_16.37.46 Fatal error: > sql_get.c:823 sql_get.c:823 query SELECT > MediaId,VolumeName,VolJobs,VolFiles,VolBlocks,VolBytes,VolMounts,VolErrors,VolWrites,MaxVolBytes,VolCapacityBytes,MediaType,VolStatus,PoolId,VolRetention,VolUseDuration,MaxVolJobs,MaxVolFiles,Recycle,Slot,FirstWritten,LastWritten,InChanger,EndFile,EndBlock > FROM Media WHERE VolumeName='TMImages-0001' failed: > ERROR: column "endfile" does not exist > > 02-Aug 20:35 dicom-sd: > TMImagesRestore.2005-08-02_16.37.46 Warning: > acquire.c:192 Error getting Volume info: 1997 Volume > "TMImages-0001" not in catalog. > > 02-Aug 20:35 dicom-sd: End of all volumes. > 02-Aug 20:35 dicom-fd: > TMImagesRestore.2005-08-02_16.37.46 Error: > attribs.c:339 File size of restored file > /mnt/md1/clean/images/TM/Original/Site1/Site001/00004606/7004582.img > not correct. Original 32559616, restored 23986176. > 02-Aug 20:35 dicom-dir: > TMImagesRestore.2005-08-02_16.37.46 Error: Bacula > 1.36.3 (22Apr05): 02-Aug-2005 20:35:44 > JobId: 719 > Job: > TMImagesRestore.2005-08-02_16.37.46 > Client: dicom-fd > Start time: 02-Aug-2005 16:37:49 > End time: 02-Aug-2005 20:35:44 > Files Expected: 9,315 > Files Restored: 4,524 > Bytes Restored: 51,707,737,523 > Rate: 3622.3 KB/s > FD Errors: 1 > FD termination status: Error > SD termination status: Error > Termination: *** Restore Error *** > > 02-Aug 20:35 dicom-dir: message.c:462 Mail prog: > bsmtp: bsmtp.c:276 Fatal connect error to localhost: > ERR=Connection refused > 02-Aug 20:35 dicom-dir: > TMImagesRestore.2005-08-02_16.37.46 Error: > message.c:473 Mail program terminated in error. > CMD=/usr/sbin/bsmtp -h localhost -f "(Bacula) > [EMAIL PROTECTED]" -s "Bacula: Restore Fatal Error of > dicom-fd Full" [EMAIL PROTECTED] > ERR=Child exited with code 1 > > Could this be a result of a bad upgrade of the > database? When I ran the upgrade script it said that > it ran seccusfully, however there were warnings that > user bacula was not the data base owner. I am using > a > postgresql database on a second linux box. > > Thanks in Advance, > John M. Drescher > > > ------------------------------------------------------- > SF.Net email is sponsored by: Discover Easy Linux > Migration Strategies > from IBM. Find simple to follow Roadmaps, > straightforward articles, > informative Webcasts and more! Get everything you > need to get up to > speed, fast. > http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click > _______________________________________________ > Bacula-users mailing list > Bacula-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/bacula-users > It looks like the database was indeed the problem. After examining the update script and the database I determined that the database was not fully updated because of the owner problem. The user bacula was not the owner so permissions were preventing the modification of the tables. After getting the proper username / password from the database admin I was able to fix the problem. I restarted the job and it appears to be working as I just remotely logged in and it was waiting for the second tape.
John ------------------------------------------------------- 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
