Hi I just upgraded to version 5 of bacula,
but I just tried yesterday to restore a job but as I did the following
procedure:
restore
->5 - Select the most recent backup for a client
-> choose my client:
Automatically selected FileSet: rom-server
+-------+-------+----------+-------------+---------------------+-------------+
| JobId | Level | JobFiles | JobBytes | StartTime | VolumeName |
+-------+-------+----------+-------------+---------------------+-------------+
| 2,085 | F | 82,326 | 604,102,927 | 2010-01-03 00:00:02 | server-0043 |
| 2,085 | F | 82,326 | 604,102,927 | 2010-01-03 00:00:02 | server-0509 |
| 2,354 | D | 5,962 | 102,853,494 | 2010-01-31 00:00:02 | server-0032 |
| 2,359 | I | 27,163 | 216,505,743 | 2010-02-01 00:00:02 | server-0034 |
+-------+-------+----------+-------------+---------------------+-------------+
You have selected the following JobIds: 2085,2354,2359
Building directory tree for JobId(s) 2085,2354,2359 ... Query failed: 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 (2085,2354,2359) UNION ALL SELECT
JobTDate, PathId, FilenameId FROM BaseFiles JOIN File USING (FileId) JOIN Job
ON (BaseJobId = Job.JobId) WHERE BaseFiles.JobId IN (2085,2354,2359) ) AS
tmp GROUP BY PathId, FilenameId ) AS T1 WHERE (Job.JobId IN ( SELECT DISTINCT
BaseJobId FROM BaseFiles WHERE JobId IN (2085,2354,2359)) OR Job.JobId IN
(2085,2354,2359)) 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: ERR=The
SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use
SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay
For one or more of the JobIds selected, no files were found,
so file selection is not possible.
Most likely your retention policy pruned the files.
Do you want to restore all the files? (yes|no): no
Regexp matching files to restore? (empty to abort):
If I want to restore the Catalog the file list can be created but not fuer
anyother Job. Where is my mistake ? I
Upgraded the tables, copied the exmaple query file to query.sql . If someone
would be so nice to help me it would be great.
Regards
Torsten
--
Torsten Maus torsten.maus AT dass-it DOT de
dass IT GmbH Phone: +49.221.3565666-98
http://www.dass-IT.de Fax: +49.221.3565666-10
Sitz der Gesellschaft: Köln | Amtsgericht Köln: HRB52500
Geschäftsführer: S. Dühr, M. Außendorf, J. Steffens, Philipp Storz
------------------------------------------------------------------------------
The Planet: dedicated and managed hosting, cloud storage, colocation
Stay online with enterprise data centers and the best network in the business
Choose flexible plans and management services without long-term contracts
Personal 24x7 support from experience hosting pros just a phone call away.
http://p.sf.net/sfu/theplanet-com
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
|