> -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf > Of Kern Sibbald > Sent: 19 February 2007 17:10 > To: bacula-users@lists.sourceforge.net > Cc: Andrew Paterson > Subject: Re: [Bacula-users] Upgrading from 1.36.1 - 2.0.2 - > not goingsmoothly. > > My best guess is that the indexes did not get properly > generated some where > along the line. Whether the indexes were not there in 1.36.1 > or they got > lost or need rebuilding when upgrading I am not sure -- this > seems to have > happened to other users. > > I recommend that you read the MySQL chapter in the current > online manual. It > tells you which indexes you should have, and in the > make_mysql_tables script, > there are some comments which suggest additional indexes you > may want to add > depending on your site setup. > One word of warning that I found when I added the appropriate indexes... Mysql is a bit funny about adding indexes and instead of creating a new index alongside the existing data it clones the table schema (with the new index added) and then copies the entire data from the old table to the new (hidden) copy. Once it has finished copying it renames the new table and gets rid of the old copy.
The upshot is: a) specify all of the changes in one SQL statement (the online mysql manual for altering tables gives you the syntax) b) make sure that you have enough space in your database partition for 2 copies of the tables that you are adding indexes to. Richard > MySQL is relatively fault tolerant, so if you find that you > are missing > indexes, I would be inclined to stop the Director, build the > appropriate > ones, and try again. > > Also take a look at your my.ini file -- depending on your > system size, you > might want to modify it (I think the manual has something on this). > > On Monday 19 February 2007 17:44, Andrew Paterson wrote: > > Hi All, > > Solaris 9 (sun4u) Bacula-1.36.1 working (worked!) fine > -> upgrading to > > bacula-2.0.2. [Mysql 4.0.21 Solaris 8,9,10, Linux 2.6 (FC5 > & GENTOO), > > WIN-32 (WIN-XP) Clients.] > > > > (Bacula built from source). > > > > Upgrading initially just the backup server - > > comprising director on a dedicated Solaris 9 box with > bacula-sd (driving a > > storedge (HP) autoloader) and Mysql DB (& of course bacula-client & > > bconsole). > > > > [database version when running 1.36.1 was 8] > > Ran updatedb/update_mysql_tables_8_to_9 .................. - ok > > Ran /etc/bacula/update_mysql_tables [updated tables to V10] - ok > > > > Bacula-dir starts OK (initial problem with "Accept Any > Volume = yes" in > > Pool directive - commented it out). > > > > bconsole starts & connects - ok > > - "status stor" - works fine. > > - But when I do "status dir" > > bconsole gets as far as > > %<--------- > > Scheduled Jobs: > > Level Type Pri Scheduled > Name > > Volume > > > ============================================================== > ============= > >===== %<---------- > > And appears to hang. (4 hrs so far!) > > > > mysql administrator shows DB server running a query "DELETE > FROM File WHERE > > JobId=9032" trouble is it shows "processing time" as the > same all the > > time!!. > > Actually, to be honset JobId has changed at last so maybe > its just a little > > slow. Why should it take so long? Is it blowing away my > backup database > > (which I have to admit is pretty big!). Maybe I am just > being impatient > > (neurotic) since usually the DB pruning is done early in > the morning whilst > > I am blissfuly unconcious! However, when I run the director > with debugging > > on (-d10) the log (/var/bacula/working/log in my case) > shows absolutely > > nothing additional. Where does the tracing go? > > > > However, what throws me the most is that since the director is > > multi-threading, does the channel to bconsole have o be > locked out because > > the director is doing a purge database operation? how about a "busy" > > response then?. > > > > Any suggestions/clue requests/enlightenments to calm my > jangling nerves > > ????? > > > > Andrew R Paterson > > DS Ltd. > > Cedar Office Park > > Cobham Road > > Ferndown > > Dorset BH21 7SB > > > > Tel: +44 (0) 1202 877188 > > Fax: +44 (0) 1202 871297 > > www.ds.co.uk > > > > > -------------------------------------------------------------- > ----------- > > 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 > ------------------------------------------------------------------------- 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
