<lst_hoe02 <at> kwsoft.de> writes: > >> > >> Officially the query should return two items I myself use the following > >> (which is a variation on the build in CopyUnCopiedJobs) > > > > I will try with two results from SQL query. From reading the manual > > i thouhgt we only need the jobid: > > > > SQLQuery > > The SQLQuery selection type, used the Selection Pattern Dir Job as > > an SQL query to obtain the JobIds to be migrated. The Selection > > Pattern must be a valid SELECT SQL statement for your SQL engine, > > and it must return the JobId as the first field of the SELECT. > > > > Adding the starttime to the select let the copy start as expected. Do > you need a traceback anyway? If yes i will try to revert the change > later and try to create a useful dump later. Ok great that it works it might indeed be interesting to see what happens when you don't give it that data. Its a bug indeed as it should behave correctly and not crash the SD but good that you have a working solution now.
At least make a bug report and if you have a trace great but you can also give in the bug report in way to reproduce the above info. > > Another question: Is it recommended/possible to use data spooling for > copy to tape? That kind of depends, for most situations its not faster, most people don't have faster spooling disks then there normal disks but I could imagine that SSDs would help there but they also may wear then faster. Currently spooling is not very elegant its kind of single threaded and as such halves your throughput e.g. read, write, read, write etc. It has some advantage that only one Job can despool at a time so if you use it things won't interleave your data on tape which is nicer when restoring etc from tape as then it doesn't have to read a lot of data and skip it as it doesn't belong to a certain backup. One day (famous last words) we hope to implement better spooling the design is kind of there only we didn't come to coding it. -- Marco van Wieringen [email protected] Bareos GmbH & Co. KG Phone: +49-221-63069389 http://www.bareos.com Sitz der Gesellschaft: Köln | Amtsgericht Köln: HRA 29646 Komplementär: Bareos Verwaltungs-GmbH Geschäftsführer: Stephan Dühr, M. Außendorf, J. Steffens, P. Storz, M. v. Wieringen -- You received this message because you are subscribed to the Google Groups "bareos-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. For more options, visit https://groups.google.com/d/optout.
