On Mon, Mar 22, 2010 at 01:25:38PM -0500, Jonathan R. Dundas wrote: > I have a RHEL 5 x86_64 patched-current install with bacula RPM's built > from the sourceforge src RPMs. I'm running MySQL community edition > 5.1.43-1 mysql.com RPMs. I have updated bacula and tried this same > operation with bacula 5.0.0, 5.0.1 and 5.0.2. When I try to restore a > backup, bconsole appears to hang here: > > [...] > > You have selected the following JobIds: 8518,8529,8550,8571,8593,8613 > Building directory tree for JobId(s) 8518,8529,8550,8571,8593,8613 ... > > and it stays there, never completing. > The MySQL database seems hung on this query:
It is probably not hung, but just very, very slow. We've had a same issue, with about 500 million records in File (and about 120GB on disk for File.ibd) on (mostly dedicated to mysql) machine (8gig RAM, 8x2.33 Xeon, different configurations with about 3-6GB for mysql buffers) -- it could take several hours for 5.0.1 until it completed and the system was ready for selecting few files to restore. :-( We switched from MyISAM to InnoDB, it didn't help. Greatly reducing the retention times did help (as it made mysql dataset much smaller). see there bacula wiki on http://tinyurl.com/yg37ujf or http://wiki.bacula.org/doku.php?id=faq#restore_takes_a_long_time_to_retrieve_sql_results_from_catalog for more info. And let the list and/or wiki know if you manage to fix it, please ! -- Opinions above are GNU-copylefted. ------------------------------------------------------------------------------ Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users