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.m...@dass-it.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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
