---------- Forwarded message ---------- From: John Drescher <[EMAIL PROTECTED]> Date: Jul 20, 2006 10:31 AM Subject: Re: [Bacula-users] Restore says no full backup To: Dan Langille <[EMAIL PROTECTED]>
Yes, In this case I have to do a manual restore because most of the menu options for restore will not work well for my situation. # bconsole Connecting to Director fileserver:9101 1000 OK: fileserver-dir Version: 1.38.11 (28 June 2006) Enter a period to cancel a command. *restore client="fileserver-fd" fileset="CleanPendingImages" storage="DLT-IV" select Using default Catalog name=HBCatalog DB=bacula No Full backup before 2006-07-20 10:29:41 found. * On 7/20/06, Dan Langille <[EMAIL PROTECTED]> wrote: > On 20 Jul 2006 at 10:07, John Drescher wrote: > > > A few weeks after moving my bacula database from a postgresql 7 server > > to a new postgresql 8 server by using pg_dump, I am having problems > > with selecting files for restores although my database looks mostly > > ok. I did have a problem in which all clients were listed twice in the > > client table and bacula really did not like this so I deleted the > > duplicate rows (using knoda) but I see this was somehow messed up as > > only a few of my clients are listed now not all ~17. > > > > The problem is that in a gnome-console or wx-console when I ask for > > all the backups for a client for a single job it returns either > > Improper date format because there is no date to select or "No Full > > backup before 2006-07-20 09:33:33 found." But I do have several full > > backups for that client, job and pool. > > Do you have the same problem with bconsole? > > > # select jobid,job,poolid,clientid,level,jobstatus from job where > > name='CleanImages'; > > jobid | job | poolid | clientid | level | > > jobstatus > > -------+---------------------------------+--------+----------+-------+----------- > > 1179 | CleanImages.2006-03-01_14.39.49 | | | F | C > > 1185 | CleanImages.2006-03-01_14.59.13 | 2 | 3 | F | T > > 1360 | CleanImages.2006-04-25_14.58.13 | 12 | 3 | F | f > > 1361 | CleanImages.2006-04-25_15.04.31 | 12 | | F | T > > 1470 | CleanImages.2006-05-25_17.42.36 | 12 | | F | T > > 1578 | CleanImages.2006-06-23_14.03.19 | 12 | | F | T > > (6 rows) > > > > > > Could it be that the clientid is not filled in?? > > > > Or could it be the problem with the client table? > > > > # select * from client; > > clientid | name | uname | > > autoprune | fileretention | jobretention > > ----------+---------------+-----------------------------------+-----------+---------------+-------------- > > 21 | dev2-fd | Windows XP,MVS,NT 5.1.2600 | > > 0 | 5184000 | 15552000 > > 19 | datastore0-fd | x86_64-pc-linux-gnu,gentoo,1.6.14 | > > 0 | 5184000 | 15552000 > > 20 | dev4-fd | x86_64-pc-linux-gnu,gentoo,1.6.13 | > > 0 | 5184000 | 15552000 > > 18 | fileserver-fd | x86_64-pc-linux-gnu,gentoo,1.6.14 | > > 0 | 5184000 | 15552000 > > (4 rows) > > > > The correct client for all the CleanImages jobs was fileserver-fd. > > > > I believe I have to restore/fix the client table to fix this problem. > > Is this true?? I still have access to the old server. > > > > BTW, I am running the bacula-1.38.11 on an amd64 gentoo box. > > fileserver is the bacula director and the database is on a different > > amd64 gentoo box if that makes a difference. > > I didn't spend much time analyzing the above. I wanted to know about > bconsole first. > > -- > Dan Langille : Software Developer looking for work > my resume: http://www.freebsddiary.org/dan_langille.php > > > ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys -- and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users