>>>>> On Wed, 02 Nov 2011 13:29:12 -0400, Phil Stracchino said: > > On 11/02/11 11:11, Martin Simmons wrote: > >>>>>> On Wed, 02 Nov 2011 07:43:36 -0400, Phil Stracchino said: > >> > >> The one issue I cannot seem to do anything about is that Bacula 5.2.1 > >> refuses to accept any 5.0.3 jobs as restore sources, saying it can find > >> no valid Full backups prior to the first 5.2.1 backup; yet bscan quite > >> happily read all of the 5.0.3 jobs into the Catalog, once I rebuilt > >> Bacula as 64-bit. > > > > What is the exact error message and the sequence of restore operations that > > cause it? > > > > Is it specific to 5.0.3 jobs that you reinserted using bscan? E.g. does it > > happen if you delete a 5.2.1 job and bscan it or if you restore from a 5.0.3 > > job that was inserted by bacula-dir (if you have any). > > Martin, > I no longer have any of the latter, because I dropped and rebuilt my > database using bscan to clear a multitude of duplicate-primary-key > errors in the PathHeirarchy table that were occurring after first > updating to 5.2.1. > > I will test the former scenario and report back. > > > Specific error: > If I use the BAT Restore button, select a Job, uncheck "Use most > recent", and select a date corresponding to a 5.0.3 backup, I get an > error popup reporting "No full backup before [timestamp] found." For > example: > > No Full backup before 2011-10-27 13:20:15 found. > > If I leave 'Use most recent' checked, then all proceeds as normal > through tree building etc. The restore tree is built from ONLY the > three most recent jobs, run on 5.2.1, JobIDs 168, 173, 178. No 5.0.3 > jobs appear in the list of available jobs to build the tree from. > However, if I go to Jobs Run, the oldest listed backup for this client > is JobID 1, 2011-09-05 04:30:24. 'list files JobId=1' yields the > expected results, file list plus the following summary: > > +-------+-----------------+---------------------+------+-------+----------+----------------+-----------+ > | JobId | Name | StartTime | Type | Level | > JobFiles | JobBytes | JobStatus | > +-------+-----------------+---------------------+------+-------+----------+----------------+-----------+ > | 1 | Babylon5 Backup | 2011-09-05 04:30:24 | B | F | > 474,957 | 15,906,563,359 | T | > +-------+-----------------+---------------------+------+-------+----------+----------------+-----------+ > > The jobs list shows a total of 44 jobs for this client, three of those > Full (two 5.0.3, one 5.2.1).
The SQL queries to find the jobs are compilicated and parameterized, so the best option is probably to turn on query logging in the database while you do the restore and then try to repeat those queries outside bacula. It will probably create a temporary table and fill it before doing the query that returns no results. > Also, I received another error from this BAT session: After closing a > couple of tabs, BAT became unresponsive. After killing it and > restarting, I found the following error message displayed in the > Director console: Is this BAT from the 5.2.1 sources? __Martin ------------------------------------------------------------------------------ RSA(R) Conference 2012 Save $700 by Nov 18 Register now http://p.sf.net/sfu/rsa-sfdev2dev1 _______________________________________________ Bacula-devel mailing list Bacula-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-devel
