Re: [Bacula-users] Restore hanging on "Building directory tree"

-------------------------------

Matija,

Thanks for the reply!

I read through that, and looked at my indexes on the File table and it
doesn't appear as if I have superfluous indexes.  The doc mentions:

"you need to drop all the indexes from File table except the primary
key and indexes on (`JobId`,`PathId`,`FilenameId`) and (`JobId`)"

However, unless I am missing something, those are all my indexes:

mysql> show index from File;
+-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | 
Cardinality | Sub_part | Packed | Null | Index_type | Comment |
+-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
| File  |          0 | PRIMARY  |            1 | FileId      | A         |     
9241817 |     NULL | NULL   |      | BTREE      |         |
| File  |          1 | JobId    |            1 | JobId       | A         |     
9241817 |     NULL | NULL   |      | BTREE      |         |
| File  |          1 | JobId_2  |            1 | JobId       | A         |     
9241817 |     NULL | NULL   |      | BTREE      |         |
| File  |          1 | JobId_2  |            2 | PathId      | A         |     
9241817 |     NULL | NULL   |      | BTREE      |         |
| File  |          1 | JobId_2  |            3 | FilenameId  | A         |     
9241817 |     NULL | NULL   |      | BTREE      |         |
+-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
5 rows in set (0.00 sec)

(Apologies for the wide lines...)

Jason

> On Tue, Apr 20, 2010 at 10:38:27AM -0600, Jason Hill wrote:
> > I am at my wit's end on this one, and I am hoping someone has had this
> > problem already.
> > 
> > I am running the following:
> > 
> > RHEL 5.5 (client, or workstation)
> > Bacula 5.0.1
> > MySQL 5.1
> > 
> > 
> > My problem is that when I attempt a restore for a large backup bacula
> > hangs on the "Building directory tree...".
> 
> Yes. See:
> http://wiki.bacula.org/doku.php?id=faq#restore_takes_a_long_time_to_retrieve_
> sql_results_from_mysql_catalog
> 
> (or http://tinyurl.com/y6334ht if your MUA breaks the link)
> 

-------------------------------

 Jason

------------------------------------------------------------------------------
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users