Torsten Maus wrote: > 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:
[ snip ] > 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. The error message suggests that the query returns too many rows, and further suggests some settings you can change in the database to allow bigger queries to run. Most likely this is an "idiot limit" to stop people running huge queries that will cripple the database performance - I'm not suggesting you are an idiot, just that the database maybe thinks bacula is an idiot ;-) Either this is due to a bug in bacula, or you are hitting some limit in your database configuration. If the latter, then you may need to make some changes to allow this to run. -- Mike Holden http://www.by-ang.com - the place to shop for all manner of hand crafted items, including Jewellery, Greetings Cards and Gifts ------------------------------------------------------------------------------ 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