>>>>> On Mon, 02 Oct 2006 09:15:07 -0400, Dan Langille said: > > On 2 Oct 2006 at 9:10, Todd R Davis wrote: > > > > > I am trying to move our DLT8000 library off one machine and on to another. > > At the same time I am wanting to upgrade bacula from ver. 1.34 to 1.38. I > > have used mysqldump to move the database over and everything seems to go > > successful. From bconsole I can view the previous ran jobs and so on but > > when I try to run a backup job or even do a "status dir" I receive many, > > although similar, error messages. They look like this: > > > > 02-Oct 08:49 debian0-dir: sql_get.c:857 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,VolParts,LabelType,LabelDate,StorageId > > FROM Media WHERE MediaId=71 > > 02-Oct 08:49 debian0-dir: *Console*.2006-10-02_08.49.24 Error: Media record > > for MediaId=71 not found in Catalog. > > > > This error repeats itself several times each with a different MediaId= # > > > > Old machine: > > SLES 9.2 > > mysql 4.0.24 > > bacula 1.34 > > > > New machine: > > Debian 31r3 > > mysql 4.0.24 > > bacula 1.38 > > > > I am wondering what this means and if there are more steps to take in > > upgrading from 1.34 to 1.38. I have tried to follow documentation. > > Thank you. > > I think you missed the database upgrade. Look for the script: > update_bacula_tables. > > Location will vary from OS to OS, and I don't know where Debian puts > it. For FreeBSD, look in /usr/local/share/bacula
I think he must have done that already, because otherwise bacula would fail on startup with a database version error. The problem may be that moving from 1.34 (database version 7) to 1.38 (database version 9) almost certainly requires two update scripts, 7_to_8 followed by 8_to_9. Only the 8_to_9 is installed as update_bacula_tables, so the 7_to_8 script has to be taken from the updatedb directory of the source tree. __Martin ------------------------------------------------------------------------- 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
