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:
Automatically selected FileSet: helpdesk_fileset
+-------+-------+----------+---------------+---------------------+------------+
| JobId | Level | JobFiles | JobBytes | StartTime | VolumeName |
+-------+-------+----------+---------------+---------------------+------------+
| 8,518 | F | 53,265 | 3,209,269,371 | 2010-03-13 10:07:17 | 000026L4 |
| 8,529 | D | 417 | 1,426,524,684 | 2010-03-13 11:09:14 | 000020L4 |
| 8,550 | I | 132 | 1,286,991,462 | 2010-03-14 00:14:50 | 000020L4 |
| 8,571 | I | 318 | 1,394,149,909 | 2010-03-14 23:40:37 | 000020L4 |
| 8,593 | I | 261 | 1,290,652,644 | 2010-03-15 23:43:57 | 000020L4 |
| 8,613 | I | 5,638 | 1,523,482,045 | 2010-03-17 00:48:46 | 000020L4 |
+-------+-------+----------+---------------+---------------------+------------+
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:
SELECT Path.Path, Filename.Name, Temp.FileIndex, Temp.JobId, LStat,
MD5 FROM ( SELECT FileId, Job.JobId AS JobId, FileIndex, File.PathId
AS PathId, File.FilenameId AS FilenameId, LStat, MD5 FROM Job, File, (
SELECT MAX(JobTDate) AS JobTDate, PathId, FilenameId FROM ( SELECT
JobTDate, PathId, FilenameId FROM File JOIN Job USING (JobId) WHERE
File.JobId IN (8518,8529,8550,8571,8593,8613) UNION ALL SELECT
JobTDate, PathId, FilenameId FROM BaseFiles JOIN File USING (FileId)
JOIN Job ON (BaseJobId = Job.JobId) WHERE BaseFiles.JobId IN
(8518,8529,8550,8571,8593,8613) ) AS tmp GROUP BY PathId, FilenameId )
AS T1 WHERE (Job.JobId IN ( SELECT DISTINCT BaseJobId FROM BaseFiles
WHERE JobId IN (8518,8529,8550,8571,8593,8613)) OR Job.JobId IN
(8518,8529,8550,8571,8593,8613)) AND T1.JobTDate = Job.JobTDate AND
Job.JobId = File.JobId AND T1.PathId = File.PathId AND T1.FilenameId =
File.FilenameId ) AS Temp JOIN Filename ON (Filename.FilenameId =
Temp.FilenameId) JOIN Path ON (Path.PathId = Temp.PathId) WHERE
FileIndex > 0 ORDER BY Temp.JobId, FileIndex ASC
I have checked & double checked having the right indexes, here are a
few, if I'm missing one please let me know and I will list it:
1.
mysql> show index from File;
2.
+-------+------------+----------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
3.
| Table | Non_unique | Key_name | Seq_in_index |
Column_name | Collation | Cardinality | Sub_part | Packed | Null |
Index_type | Comment |
4.
+-------+------------+----------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
5.
| File | 0 | PRIMARY | 1 | FileId
| A | 109205565 | NULL | NULL | | BTREE |
|
6.
| File | 1 | JobId | 1 | JobId
| A | 645 | NULL | NULL | | BTREE |
|
7.
| File | 1 | JobId | 2 | PathId
| A | 4200214 | NULL | NULL | | BTREE |
|
8.
| File | 1 | JobId | 3 |
FilenameId | A | 109205565 | NULL | NULL | |
BTREE | |
9.
| File | 1 | idxPathId | 1 | PathId
| A | 1050053 | NULL | NULL | | BTREE |
|
10.
| File | 1 | idxFilenameId | 1 |
FilenameId | A | 2800142 | NULL | NULL | |
BTREE | |
11.
| File | 1 | file_jobid_idx | 1 | JobId
| A | 645 | NULL | NULL | | BTREE |
|
12.
+-------+------------+----------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
13.
mysql> show index from Path;
14.
+-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
15.
| Table | Non_unique | Key_name | Seq_in_index | Column_name |
Collation | Cardinality | Sub_part | Packed | Null | Index_type |
Comment |
16.
+-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
17.
| Path | 0 | PRIMARY | 1 | PathId | A
| 3086385 | NULL | NULL | | BTREE |
|
18.
| Path | 1 | Path | 1 | Path | A
| 3086385 | 255 | NULL | | BTREE |
|
19.
+-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
20.
2 rows in set (0.00 sec)
21.
mysql> show index from Filename;
22.
+----------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
23.
| Table | Non_unique | Key_name | Seq_in_index | Column_name
| Collation | Cardinality | Sub_part | Packed | Null | Index_type |
Comment |
24.
+----------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
25.
| Filename | 0 | PRIMARY | 1 | FilenameId
| A | 3768881 | NULL | NULL | | BTREE |
|
26.
| Filename | 1 | Name | 1 | Name
| A | 3768881 | 255 | NULL | | BTREE |
|
27.
+----------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
28.
2 rows in set (0.00 sec)
Does anyone have any idea where to look next to solve this?
------------------------------------------------------------------------------
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
