[Bacula-users] exclude day from schedule
Hi, I read the docs but couldn't find any info. Is it possible to exclude from schedule? My schedule is as follows: Schedule { Name = "MultipleRUN" Run = Level=Full Pool=Daily mon-sun at 3:17 Run = Level=Full Pool=Weekly sun at 9:05 Run = Level=Incremental Pool=Weekly mon-sat at 19:05 Run = Level=Full Pool=Monthly 1st sat at 2:05 Run = Level=Full Pool=Offsite 1st fri at 2:05 } What I'm trying to do is to prevent Daily full backup from running when thereis a Monthly full backup is scheduled for the same day. Is the following possible? Run = Level=Full Pool=Daily mon-sun at 3:17 *not 1 st sat* Thanksfor your time. -- Get your SQL database under version control now! Version control is standard for application code, but databases havent caught up. So what steps can you take to put your SQL databases under version control? Why should you start doing it? Read more to find out. http://pubads.g.doubleclick.net/gampad/clk?id=49501711&iu=/4140/ostg.clktrk___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Pool : Unknow for LTO3 storage device
Dear, After a bad power-off bacula server, the storage is not able to see correct pool-volumes assignment for LTO3 device: Device status: Autochanger "TSM3500" with devices: "ULT3580-TD3" (/dev/nst0) "ULT3580-TD5" (/dev/nst1) Device "FileStorage" is not open or does not exist. Device "ULT3580-TD3" (/dev/nst0) is mounted with: Volume: L30001L3 Pool:*unknown* Media type: LTO-3 Slot 3 is loaded in drive 1. Total Bytes Read=0 Blocks Read=0 Bytes/block=0 Positioned at File=0 Block=0 Device "ULT3580-TD5" (/dev/nst1) is mounted with: Volume: B00692LV Pool:Pool1 Media type: LTO-5 Slot 40 is loaded in drive 0. Total Bytes=1,024 Blocks=0 Bytes/block=1,024 Positioned at File=0 Block=0 But the volumes from pool are correctly showed: *list volume pool=Incr +-++---+-+-+--+--+-+--+---+---+-+ | MediaId | VolumeName | VolStatus | Enabled | VolBytes| VolFiles | VolRetention | Recycle | Slot | InChanger | MediaType | LastWritten | +-++---+-+-+--+--+-+--+---+---+-+ | 10 | L30016L3 | Full | 1 | 430,674,056,192 | 910 | 31,536,000 | 1 | 17 | 1 | LTO-3 | 2013-07-21 09:40:44 | | 61 | L30006L3 | Append| 1 | 18,680,747,008 | 21 | 31,536,000 | 1 |7 | 1 | LTO-3 | 2013-07-27 18:08:20 | | 67 | L30010L3 | Append| 1 | 1,024 |0 |7,776,000 | 1 | 11 | 1 | LTO-3 | -00-00 00:00:00 | | 68 | L30017L3 | Append| 1 | 37,661,717,504 | 46 |7,776,000 | 1 | 18 | 1 | LTO-3 | 2013-07-31 19:56:15 | +-++---+-+-+--+--+-+--+---+---+-+ Any idea? Is the anything wrong on DB? Regards, -- Bertrand Russell: *"El problema con el mundo es que los estúpidos están seguros de todo y los inteligentes están llenos de dudas*" -- Get your SQL database under version control now! Version control is standard for application code, but databases havent caught up. So what steps can you take to put your SQL databases under version control? Why should you start doing it? Read more to find out. http://pubads.g.doubleclick.net/gampad/clk?id=49501711&iu=/4140/ostg.clktrk___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Pool : Unknow for LTO3 storage device
On Fri, Aug 2, 2013 at 6:16 AM, Iban Cabrillo wrote: > Dear, >After a bad power-off bacula server, the storage is not able to see > correct pool-volumes assignment for LTO3 device: > > Device status: > Autochanger "TSM3500" with devices: >"ULT3580-TD3" (/dev/nst0) >"ULT3580-TD5" (/dev/nst1) > Device "FileStorage" is not open or does not exist. > Device "ULT3580-TD3" (/dev/nst0) is mounted with: > Volume: L30001L3 > Pool:*unknown* > Media type: LTO-3 > Slot 3 is loaded in drive 1. > Total Bytes Read=0 Blocks Read=0 Bytes/block=0 > Positioned at File=0 Block=0 > Device "ULT3580-TD5" (/dev/nst1) is mounted with: > Volume: B00692LV > Pool:Pool1 > Media type: LTO-5 > Slot 40 is loaded in drive 0. > Total Bytes=1,024 Blocks=0 Bytes/block=1,024 > Positioned at File=0 Block=0 > > But the volumes from pool are correctly showed: > > *list volume pool=Incr > +-++---+-+-+--+--+-+--+---+---+-+ > | MediaId | VolumeName | VolStatus | Enabled | VolBytes| VolFiles | > VolRetention | Recycle | Slot | InChanger | MediaType | LastWritten > | > +-++---+-+-+--+--+-+--+---+---+-+ > | 10 | L30016L3 | Full | 1 | 430,674,056,192 | 910 | > 31,536,000 | 1 | 17 | 1 | LTO-3 | 2013-07-21 09:40:44 | > | 61 | L30006L3 | Append| 1 | 18,680,747,008 | 21 | > 31,536,000 | 1 |7 | 1 | LTO-3 | 2013-07-27 18:08:20 | > | 67 | L30010L3 | Append| 1 | 1,024 |0 | > 7,776,000 | 1 | 11 | 1 | LTO-3 | -00-00 00:00:00 | > | 68 | L30017L3 | Append| 1 | 37,661,717,504 | 46 | > 7,776,000 | 1 | 18 | 1 | LTO-3 | 2013-07-31 19:56:15 | > +-++---+-+-+--+--+-+--+---+---+-+ > > Any idea? Is the anything wrong on DB? > Is this causing you a real problem? Unknown in for the pool happens if a tape is loaded in a drive but no jobs have run on that tape. John -- Get your SQL database under version control now! Version control is standard for application code, but databases havent caught up. So what steps can you take to put your SQL databases under version control? Why should you start doing it? Read more to find out. http://pubads.g.doubleclick.net/gampad/clk?id=49501711&iu=/4140/ostg.clktrk ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] exclude day from schedule
On Fri, Aug 2, 2013 at 3:12 AM, Süleyman Kuran wrote: > Hi, > > I read the docs but couldn't find any info. Is it possible to exclude from > schedule? My schedule is as follows: > > Schedule { > Name = "MultipleRUN" > Run = Level=Full Pool=Daily mon-sun at 3:17 > Run = Level=Full Pool=Weekly sun at 9:05 > Run = Level=Incremental Pool=Weekly mon-sat at 19:05 > Run = Level=Full Pool=Monthly 1st sat at 2:05 > Run = Level=Full Pool=Offsite 1st fri at 2:05 > } > > What I'm trying to do is to prevent Daily full backup from running when > there is a Monthly full backup is scheduled for the same day. > > > Is the following possible? > > Run = Level=Full Pool=Daily mon-sun at 3:17 not 1 st sat > > Thanks for your time. > Maybe use a day range to schedule the daily full on days 2 to 31. John -- Get your SQL database under version control now! Version control is standard for application code, but databases havent caught up. So what steps can you take to put your SQL databases under version control? Why should you start doing it? Read more to find out. http://pubads.g.doubleclick.net/gampad/clk?id=49501711&iu=/4140/ostg.clktrk ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] exclude day from schedule
On Fri, Aug 2, 2013 at 8:38 AM, John Drescher wrote: > On Fri, Aug 2, 2013 at 3:12 AM, Süleyman Kuran wrote: >> Hi, >> >> I read the docs but couldn't find any info. Is it possible to exclude from >> schedule? My schedule is as follows: >> >> Schedule { >> Name = "MultipleRUN" >> Run = Level=Full Pool=Daily mon-sun at 3:17 >> Run = Level=Full Pool=Weekly sun at 9:05 >> Run = Level=Incremental Pool=Weekly mon-sat at 19:05 >> Run = Level=Full Pool=Monthly 1st sat at 2:05 >> Run = Level=Full Pool=Offsite 1st fri at 2:05 >> } >> >> What I'm trying to do is to prevent Daily full backup from running when >> there is a Monthly full backup is scheduled for the same day. >> >> >> Is the following possible? >> >> Run = Level=Full Pool=Daily mon-sun at 3:17 not 1 st sat >> >> Thanks for your time. >> > > Maybe use a day range to schedule the daily full on days 2 to 31. > Oops. Not going to work with 1st sat. John -- Get your SQL database under version control now! Version control is standard for application code, but databases havent caught up. So what steps can you take to put your SQL databases under version control? Why should you start doing it? Read more to find out. http://pubads.g.doubleclick.net/gampad/clk?id=49501711&iu=/4140/ostg.clktrk ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] exclude day from schedule
>> Maybe use a day range to schedule the daily full on days 2 to 31. >> > Oops. Not going to work with 1st sat. Although I guess you could do a 1st mon 2nd mon 3rd mon 4th mon 5th mon 1st tue 2nd tue ... and exclude 1st sat. Ugly but it should work. John -- Get your SQL database under version control now! Version control is standard for application code, but databases havent caught up. So what steps can you take to put your SQL databases under version control? Why should you start doing it? Read more to find out. http://pubads.g.doubleclick.net/gampad/clk?id=49501711&iu=/4140/ostg.clktrk ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] exclude day from schedule
Hi Something like Run = Level=Full Pool=Daily mon-fri,sun at 3:17 Run = Level=Full Pool=Daily on 2nd-5th sat at 3:17 maybe. Greg. Le 02/08/2013 09:12, Süleyman Kuran a écrit : > Hi, > > I read the docs but couldn't find any info. Is it possible to exclude > from schedule? My schedule is as follows: > > Schedule { > Name = "MultipleRUN" > Run = Level=Full Pool=Daily mon-sun at 3:17 > Run = Level=Full Pool=Weekly sun at 9:05 > Run = Level=Incremental Pool=Weekly mon-sat at 19:05 > Run = Level=Full Pool=Monthly 1st sat at 2:05 > Run = Level=Full Pool=Offsite 1st fri at 2:05 > } > > What I'm trying to do is to prevent Daily full backup from running when > thereis a Monthly full backup is scheduled for the same day. > > > Is the following possible? > > Run = Level=Full Pool=Daily mon-sun at 3:17 *not 1 st sat* > > Thanksfor your time. > > > > > > > -- > Get your SQL database under version control now! > Version control is standard for application code, but databases havent > caught up. So what steps can you take to put your SQL databases under > version control? Why should you start doing it? Read more to find out. > http://pubads.g.doubleclick.net/gampad/clk?id=49501711&iu=/4140/ostg.clktrk > > > > ___ > Bacula-users mailing list > Bacula-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/bacula-users > -- Get your SQL database under version control now! Version control is standard for application code, but databases havent caught up. So what steps can you take to put your SQL databases under version control? Why should you start doing it? Read more to find out. http://pubads.g.doubleclick.net/gampad/clk?id=49501711&iu=/4140/ostg.clktrk ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] exclude day from schedule
> Something like > > Run = Level=Full Pool=Daily mon-fri,sun at 3:17 > Run = Level=Full Pool=Daily on 2nd-5th sat at 3:17 > > maybe. > That looks much simpler than my 1st 2nd ... approach. John -- Get your SQL database under version control now! Version control is standard for application code, but databases havent caught up. So what steps can you take to put your SQL databases under version control? Why should you start doing it? Read more to find out. http://pubads.g.doubleclick.net/gampad/clk?id=49501711&iu=/4140/ostg.clktrk ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] exclude day from schedule
On Fri, Aug 2, 2013 at 8:45 AM, John Drescher wrote: >>> Maybe use a day range to schedule the daily full on days 2 to 31. >>> >> Oops. Not going to work with 1st sat. > > Although I guess you could do a 1st mon 2nd mon 3rd mon 4th mon 5th > mon 1st tue 2nd tue ... and exclude 1st sat. Ugly but it should work. A second path would be automatically canceling the second job via Allow Duplicate Jobs = no in the job resource. Then have the monthly start a few minutes before the dailies. John -- Get your SQL database under version control now! Version control is standard for application code, but databases havent caught up. So what steps can you take to put your SQL databases under version control? Why should you start doing it? Read more to find out. http://pubads.g.doubleclick.net/gampad/clk?id=49501711&iu=/4140/ostg.clktrk ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Fwd: exclude day from schedule
That's how I would do it: Run = Level=Incremental Pool=Weekly mon-fri at 19:05 Run = Level=Incremental Pool=Weekly 2th-5th sat at 19:05 Run = Level=Full Pool=Monthly 1st sat at 2:05 -- Get your SQL database under version control now! Version control is standard for application code, but databases havent caught up. So what steps can you take to put your SQL databases under version control? Why should you start doing it? Read more to find out. http://pubads.g.doubleclick.net/gampad/clk?id=49501711&iu=/4140/ostg.clktrk ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Fwd: exclude day from schedule
Just pointing out that the first pool should be "daily" and the second one, for saturday, the "weekly" pool. Something like: Run = Level=Incremental Pool=Daily mon-fri at 19:05 Run = Level=Incremental Pool=Weekly 2th-5th sat at 19:05 Run = Level=Full Pool=Monthly 1st sat at 2:05 Regards, Ana On Fri, Aug 2, 2013 at 11:03 AM, John Drescher wrote: > That's how I would do it: > > Run = Level=Incremental Pool=Weekly mon-fri at 19:05 > Run = Level=Incremental Pool=Weekly 2th-5th sat at 19:05 > Run = Level=Full Pool=Monthly 1st sat at 2:05 > > > -- > Get your SQL database under version control now! > Version control is standard for application code, but databases havent > caught up. So what steps can you take to put your SQL databases under > version control? Why should you start doing it? Read more to find out. > http://pubads.g.doubleclick.net/gampad/clk?id=49501711&iu=/4140/ostg.clktrk > ___ > Bacula-users mailing list > Bacula-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/bacula-users > -- Get your SQL database under version control now! Version control is standard for application code, but databases havent caught up. So what steps can you take to put your SQL databases under version control? Why should you start doing it? Read more to find out. http://pubads.g.doubleclick.net/gampad/clk?id=49501711&iu=/4140/ostg.clktrk___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] exclude day from schedule
> On Fri, 02 Aug 2013 10:12:03 +0300, Süleyman Kuran said: > > Hi, > > I read the docs but couldn't find any info. Is it possible to exclude > from schedule? My schedule is as follows: > > Schedule { >Name = "MultipleRUN" >Run = Level=Full Pool=Daily mon-sun at 3:17 >Run = Level=Full Pool=Weekly sun at 9:05 >Run = Level=Incremental Pool=Weekly mon-sat at 19:05 >Run = Level=Full Pool=Monthly 1st sat at 2:05 >Run = Level=Full Pool=Offsite 1st fri at 2:05 > } This schedule looks strange to me, because incremental jobs are always relative to the last full job, but you are sending them all to the Weekly pool. On Monday it will be relative to the Pool=Daily full and on the 1st Friday it will be relative to the Pool=Offsite full. __Martin -- Get your SQL database under version control now! Version control is standard for application code, but databases havent caught up. So what steps can you take to put your SQL databases under version control? Why should you start doing it? Read more to find out. http://pubads.g.doubleclick.net/gampad/clk?id=49501711&iu=/4140/ostg.clktrk ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] exclude day from schedule
On 02/08/13 12:25 PM, Martin Simmons wrote: >> On Fri, 02 Aug 2013 10:12:03 +0300, Süleyman Kuran said: >> Hi, >> >> I read the docs but couldn't find any info. Is it possible to exclude >> from schedule? My schedule is as follows: >> >> Schedule { >> Name = "MultipleRUN" >> Run = Level=Full Pool=Daily mon-sun at 3:17 >> Run = Level=Full Pool=Weekly sun at 9:05 >> Run = Level=Incremental Pool=Weekly mon-sat at 19:05 >> Run = Level=Full Pool=Monthly 1st sat at 2:05 >> Run = Level=Full Pool=Offsite 1st fri at 2:05 >> } > This schedule looks strange to me, because incremental jobs are always > relative to the last full job, but you are sending them all to the Weekly > pool. On Monday it will be relative to the Pool=Daily full and on the 1st > Friday it will be relative to the Pool=Offsite full. > > __Martin > I thought incrementals were relative to the last backup job and differentials relative to the last full backup. He does a full on Sunday to the weekly pool and incrementals the rest of the week. Each incremental should have just the day's changes. What I find strange is that he's running the Offsite a day before the Monthly while the Weekly full is 31 hours after the Monthly. Given that the month doesn't always start on the same day of the week, the various backups could be done on different weeks (e.g. the first Saturday may be before or after the first Sunday). Another strange thing is that he's running both full and incremental backups each day, with two full backups on Sunday. I don't understand why anyone would do this. -- Get your SQL database under version control now! Version control is standard for application code, but databases havent caught up. So what steps can you take to put your SQL databases under version control? Why should you start doing it? Read more to find out. http://pubads.g.doubleclick.net/gampad/clk?id=49501711&iu=/4140/ostg.clktrk ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] What might prevent auto-recycling?
I'm on bacula 3.0.1, btw. Thanks. It's confusing, b/c with these same settings it's no auto-recycling again. I don't see how 'MaxVols' would effect things, b/c I don't think things are setup to automatically add new volumes. And 'Recycle Oldest Volume' seems to only consider job and file retention times, which in my case are much greater than my volume retention period. I could change those of course. But I'm trying to leave things as they were setup when I inherited this system. -M On Thu, Aug 1, 2013 at 9:56 AM, Uwe Schuerkamp wrote: > On Wed, Jul 31, 2013 at 03:34:50PM -0400, Michael Stauffer wrote: > > > > PoolId: 6 > > Name: Differential > > NumVols: 6 > > MaxVols: 0 > > Wouldn't you want to set the "maxvols" parameter in your pool > definition too together with "recycle oldest volume" to force bacula > to recycle the oldest volume? > > Cheers, Uwe > > -- > NIONEX --- Ein Unternehmen der Bertelsmann SE & Co. KGaA > > > -- Get your SQL database under version control now! Version control is standard for application code, but databases havent caught up. So what steps can you take to put your SQL databases under version control? Why should you start doing it? Read more to find out. http://pubads.g.doubleclick.net/gampad/clk?id=49501711&iu=/4140/ostg.clktrk___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] What might prevent auto-recycling?
> Message: 7 > Date: Thu, 1 Aug 2013 14:58:57 +0100 > From: Martin Simmons > Subject: Re: [Bacula-users] What might prevent auto-recycling? > To: bacula-users@lists.sourceforge.net > Message-ID: <201308011358.r71dwvmd021...@higson.cam.lispworks.com> > > > On Wed, 31 Jul 2013 15:34:50 -0400, Michael Stauffer said: > > > > Hi, > > > > I had some jobs stall b/c of no volumes available for recycling. But > there > > were two volumes in the pool (Differential) that were last written to > > beyond the 7 day volume retention period. Volumes in the pool are set to > > recycle. Below is the info on volumes and the Differential pool. As far > as > > I can tell, the pool and volumes are properly setup for automatic > recycling > > after 7 days. > > > > Why might volumes L50023 and L50024 not been automatically recycled? > > You probably need to use a 6 day volume retention period rather than 7, > because the last written time is the end of the job, not the start. > > __Martin > > Thanks Martin. I was looking at the last-written time for the volumes and it older than 7 days for both. But my info might have been confusing b/c the 1st of the two volumes in question was manually recycled by the time I wrote this. And as I said in my other reply today, things seem to be automatically recycling again today - strange. -M -- Get your SQL database under version control now! Version control is standard for application code, but databases havent caught up. So what steps can you take to put your SQL databases under version control? Why should you start doing it? Read more to find out. http://pubads.g.doubleclick.net/gampad/clk?id=49501711&iu=/4140/ostg.clktrk___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] bacula-dir run failure on Ubuntu 12.04.02
Hi folks, For what it's worth, I tried compiling Bacula 5.0.3 on Ubuntu 12.0.4 today. I currently have Bacula 5.0.3 running on Ubuntu 10.0.4 on another server. The compilation failed on 12.0.4 for the director though the SD and FD both compiled. I played around a bit but then decided just for kicks to reinstall this new machine back to 10.0.4 and try that. After that, I did an update, and then loaded the build-essential, libncurses5-dev, and libmysqlclient-dev packages. I then built 5.2.13 and it builds and runs with no problem. So whatever is going on must be related to something happening with Ubuntu packaging at 12.0.4 that causes Bacula to not link in everything it needs. Since my primary goal is to get moved to different hardware, I'm just going to continue running on 10.0.4 on the new hardware with the 5.2.13 Bacula since 10.0.4 is supported until midway through 2015. After I get everything migrated and stabilized, maybe I'll play with debugging this 12.0.4 problem again in a virtual machine or something in my spare time. Thanks again for the ideas, I learned a bit more about digging around in the symbols on linux so it was worth that anyway. If I do get back to it and find a solid answer, I'll update the list. Mike On 8/1/2013 10:21 PM, uhog-v...@spamex.com wrote: > > > > On 8/1/2013 10:12 AM, Martin Simmons wrote: >>> On Wed, 31 Jul 2013 13:52:10 -0400, uhog-v9e4 said: >>> >>> On 7/31/2013 10:33 AM, Martin Simmons wrote: > On Tue, 30 Jul 2013 11:55:43 -0400, uhog-v9e4 said: > > Hi folks, > > I'm trying to build and run Bacula 5.2.13 on Ubuntu server 12.04.02. I > have downloaded source and bacula builds with no problem but the director > fails to start with the following error: > > node1:~# /opt/bacula/bin/bacula-dir -f > /opt/bacula/bin/bacula-dir: symbol lookup error: > /opt/bacula/lib/libbaccats-5.2.13.so: undefined symbol: mysql_thread_safe > node1:~# dpkg --list |grep libmysqlclient > ii libmysqlclient-dev 5.5.32-0ubuntu0.12.04.1 > MySQL database development files > ii libmysqlclient18 5.5.32-0ubuntu0.12.04.1 > MySQL database client library > node1:~# What is the output of ldd /opt/bacula/lib/libbaccats-5.2.13.so It might be an Ubuntu packaging bug like this one: https://bugs.launchpad.net/ubuntu/+source/bacula/+bug/949508 __Martin >>> >>> Hi Martin, >>> >>> Thanks. I believe this is the problem, but I'm not sure how to fix it. >> >> Is the machine fully updated? >> > Yes, the machine was installed via the Ubuntu server CD with LAMPs, then I > added build-essential, libmysqlclient-dev, and xubuntu-desktop just to get a > basic gui. Then apt-update and apt-get dist-upgrade to get it all current. > Then I downloaded the bacula 5.2.13 tar ball and did the configure and build. > >> >>> node1:~# ldd /opt/bacula/lib/libbaccats-5.2.13.so >>> linux-gate.so.1 => (0xb7772000) >>> libstdc++.so.6 => /usr/lib/i386-linux-gnu/libstdc++.so.6 >>> (0xb7675000) >>> libc.so.6 => /lib/i386-linux-gnu/libc.so.6 (0xb74cc000) >>> libm.so.6 => /lib/i386-linux-gnu/libm.so.6 (0xb749f000) >>> /lib/ld-linux.so.2 (0xb7773000) >>> libgcc_s.so.1 => /lib/i386-linux-gnu/libgcc_s.so.1 (0xb7481000) >>> node1:~# >>> >>> So there is no mysql library here. I found the mysql_thread_safe symbol >>> defined in /usr/lib/i386-linux-gnu/libmysqlclient_r.a on my system but the >>> libmysqlclient.so file is stripped. >>> >>> node1:~# find /usr -name libmysqlclient.so*|xargs ls -l >>> lrwxrwxrwx 1 root root 20 Jul 24 01:32 >>> /usr/lib/i386-linux-gnu/libmysqlclient.so -> libmysqlclient.so.18 >>> lrwxrwxrwx 1 root root 24 Jul 24 01:32 >>> /usr/lib/i386-linux-gnu/libmysqlclient.so.18 -> libmysqlclient.so.18.0.0 >>> -rw-r--r-- 1 root root 3237128 Jul 24 01:32 >>> /usr/lib/i386-linux-gnu/libmysqlclient.so.18.0.0 >>> node1:~# nm /usr/lib/i386-linux-gnu/libmysqlclient.so.18.0.0 >>> nm: /usr/lib/i386-linux-gnu/libmysqlclient.so.18.0.0: no symbols >>> node1:~# file /usr/lib/i386-linux-gnu/libmysqlclient.so.18.0.0 >>> /usr/lib/i386-linux-gnu/libmysqlclient.so.18.0.0: ELF 32-bit LSB shared >>> object, Intel 80386, version 1 (SYSV), dynamically linked, >>> BuildID[sha1]=0x23cf2ee7f1d6d66c6095cedf7fb067708cc9c5eb, stripped >> >> Stripped is normal -- try objdump -T to see the dynamic symbols. >> > > Looks good. > > node1:~# objdump -T /usr/lib/i386-linux-gnu/libmysqlclient.so.18.0.0|grep > thread_safe 0001c990 gDF .text 000a Basemysql_thread_safe > node1:~# > >> >>> >>> And I can see this in the bacula config.log >>> --- >>> configure:24471: checking for mysql_thread_safe in -lmysqlclient_r >>> configure:24496: gcc -o conftest -g -O2 -Wall -L/usr/lib conftest.c >>> -lmysqlclient_r -ldl -ldl -lz >&5 >>> configure:2
Re: [Bacula-users] exclude day from schedule
I export the Offsite media on Friday morning from the library and move it to another location. Because there is no monthly backup in the library I also schedule a job a day after the offsite backupin case I need to recover from a montly backup immediately. 1stsat is always 1 day after the 1st friday, or am i wrong? You are right that I have two full backups on sunday, it is a mistake. I should remove daily backup on sundays. On 02/08/13 19:53, Gary Dale wrote: On 02/08/13 12:25 PM, Martin Simmons wrote: On Fri, 02 Aug 2013 10:12:03 +0300, Süleyman Kuran said: Hi, I read the docs but couldn't find any info. Is it possible to exclude from schedule? My schedule is as follows: Schedule { Name = "MultipleRUN" Run = Level=Full Pool=Daily mon-sun at 3:17 Run = Level=Full Pool=Weekly sun at 9:05 Run = Level=Incremental Pool=Weekly mon-sat at 19:05 Run = Level=Full Pool=Monthly 1st sat at 2:05 Run = Level=Full Pool=Offsite 1st fri at 2:05 } This schedule looks strange to me, because incremental jobs are always relative to the last full job, but you are sending them all to the Weekly pool. On Monday it will be relative to the Pool=Daily full and on the 1st Friday it will be relative to the Pool=Offsite full. __Martin I thought incrementals were relative to the last backup job and differentials relative to the last full backup. He does a full on Sunday to the weekly pool and incrementals the rest of the week. Each incremental should have just the day's changes. What I find strange is that he's running the Offsite a day before the Monthly while the Weekly full is 31 hours after the Monthly. Given that the month doesn't always start on the same day of the week, the various backups could be done on different weeks (e.g. the first Saturday may be before or after the first Sunday). Another strange thing is that he's running both full and incremental backups each day, with two full backups on Sunday. I don't understand why anyone would do this. -- Get your SQL database under version control now! Version control is standard for application code, but databases havent caught up. So what steps can you take to put your SQL databases under version control? Why should you start doing it? Read more to find out. http://pubads.g.doubleclick.net/gampad/clk?id=49501711&iu=/4140/ostg.clktrk ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users -- Get your SQL database under version control now! Version control is standard for application code, but databases havent caught up. So what steps can you take to put your SQL databases under version control? Why should you start doing it? Read more to find out. http://pubads.g.doubleclick.net/gampad/clk?id=49501711&iu=/4140/ostg.clktrk___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] exclude day from schedule
Hi! About "1st sat is always 1 day after the 1st friday". It´s not always true. You will have a 1st saturday before the 1st fridat happening on february, 2014. Regards, Ana On Fri, Aug 2, 2013 at 6:56 PM, Süleyman Kuran wrote: > I export the Offsite media on Friday morning from the library and move > it to another location. Because there is no monthly backup in the library > I also schedule a job a day after the offsite backup in case I need to > recover from a montly backup immediately. 1st sat is always 1 day after > the 1st friday, or am i wrong? > > You are right that I have two full backups on sunday, it is a mistake. I > should remove daily backup on sundays. > > > > On 02/08/13 19:53, Gary Dale wrote: > > On 02/08/13 12:25 PM, Martin Simmons wrote: > >On Fri, 02 Aug 2013 10:12:03 +0300, Süleyman Kuran said: > > Hi, > > I read the docs but couldn't find any info. Is it possible to exclude > from schedule? My schedule is as follows: > > Schedule { > Name = "MultipleRUN" > Run = Level=Full Pool=Daily mon-sun at 3:17 > Run = Level=Full Pool=Weekly sun at 9:05 > Run = Level=Incremental Pool=Weekly mon-sat at 19:05 > Run = Level=Full Pool=Monthly 1st sat at 2:05 > Run = Level=Full Pool=Offsite 1st fri at 2:05 > } > > This schedule looks strange to me, because incremental jobs are always > relative to the last full job, but you are sending them all to the Weekly > pool. On Monday it will be relative to the Pool=Daily full and on the 1st > Friday it will be relative to the Pool=Offsite full. > > __Martin > > > I thought incrementals were relative to the last backup job and > differentials relative to the last full backup. He does a full on Sunday > to the weekly pool and incrementals the rest of the week. Each > incremental should have just the day's changes. > > What I find strange is that he's running the Offsite a day before the > Monthly while the Weekly full is 31 hours after the Monthly. Given that > the month doesn't always start on the same day of the week, the various > backups could be done on different weeks (e.g. the first Saturday may be > before or after the first Sunday). > > Another strange thing is that he's running both full and incremental > backups each day, with two full backups on Sunday. I don't understand > why anyone would do this. > > > -- > Get your SQL database under version control now! > Version control is standard for application code, but databases havent > caught up. So what steps can you take to put your SQL databases under > version control? Why should you start doing it? Read more to find > out.http://pubads.g.doubleclick.net/gampad/clk?id=49501711&iu=/4140/ostg.clktrk > ___ > Bacula-users mailing > listBacula-users@lists.sourceforge.nethttps://lists.sourceforge.net/lists/listinfo/bacula-users > > > > > -- > Get your SQL database under version control now! > Version control is standard for application code, but databases havent > caught up. So what steps can you take to put your SQL databases under > version control? Why should you start doing it? Read more to find out. > http://pubads.g.doubleclick.net/gampad/clk?id=49501711&iu=/4140/ostg.clktrk > ___ > Bacula-users mailing list > Bacula-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/bacula-users > > -- Get your SQL database under version control now! Version control is standard for application code, but databases havent caught up. So what steps can you take to put your SQL databases under version control? Why should you start doing it? Read more to find out. http://pubads.g.doubleclick.net/gampad/clk?id=49501711&iu=/4140/ostg.clktrk___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] [bacula] problem with the db
Hello list i use bacula in version 5.2.6 with postgres 9.2.4. in my postgres log i have a lot of : 2013-08-03 03:00:04 CEST bacula 14043 0 INSTRUCTION : DROP TABLE DelCandidates 2013-08-03 03:00:04 CEST bacula 14043 0 ERREUR: la table << delcandidates >> n'existe pas (table 'delcandidates' don t exist) have you a idea? thx philippe signature.asc Description: OpenPGP digital signature -- Get your SQL database under version control now! Version control is standard for application code, but databases havent caught up. So what steps can you take to put your SQL databases under version control? Why should you start doing it? Read more to find out. http://pubads.g.doubleclick.net/gampad/clk?id=49501711&iu=/4140/ostg.clktrk___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] exclude day from schedule
On 02/08/13 05:56 PM, Süleyman Kuran wrote: > I export the Offsite media on Friday morning from the library and move > it to another location. Because there is no monthly backup in the > library I also schedule a job a day after the offsite backupin case I > need to recover from a montly backup immediately. 1stsat is always 1 > day after the 1st friday, or am i wrong? > > You are right that I have two full backups on sunday, it is a mistake. > I should remove daily backup on sundays. > The really strange thing is that you are running a full backup to the Daily pool at 3:17 each morning and an incremental each day except Sunday at 19:05 to the Weekly pool. Assuming normal business hours, that means you are doing an incremental followed by a full each day. Do you need two backups each day? The sample schedule looks pretty good and appears to do what you want: Schedule { Name = "ScheduleTest" Run = Full 1st sun at 23:05 Run = Differential 2nd-5th sun at 23:05 Run = Incremental mon-sat at 23:05 } In fact, you could even simplify it to running a full every Sunday and incrementals in between. Schedule { Name = "ScheduleTest2" Run = Full sun at 23:05 Run = Incremental mon-sat at 23:05 } If you put the incrementals into a different pool from the full/differential then you keep the size of the pool you want offsite manageable. If you are backing up the catalogue (a common practise) along with the files, then you don't need to run a full backup to an Offsite pool. I just copy the Weekly pool to a removable drive/media each week after the weekly Full or Differential backup finishes. This can be done as a RunAfterJob script or as a cron job. Should you need to restore the pool, just copy it back to your disk drive. -- Get your SQL database under version control now! Version control is standard for application code, but databases havent caught up. So what steps can you take to put your SQL databases under version control? Why should you start doing it? Read more to find out. http://pubads.g.doubleclick.net/gampad/clk?id=49501711&iu=/4140/ostg.clktrk ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] bacula-dir run failure on Ubuntu 12.04.02
Zitat von uhog-v...@spamex.com: > Hi folks, > > For what it's worth, I tried compiling Bacula 5.0.3 on Ubuntu 12.0.4 > today. I currently have Bacula 5.0.3 running on Ubuntu 10.0.4 on > another server. The compilation failed on 12.0.4 for the director > though the SD and FD both compiled. I played around a bit but then > decided just for kicks to reinstall this new machine back to 10.0.4 > and try that. After that, I did an update, and then loaded the > build-essential, libncurses5-dev, and libmysqlclient-dev packages. I > then built 5.2.13 and it builds and runs with no problem. So > whatever is going on must be related to something happening with > Ubuntu packaging at 12.0.4 that causes Bacula to not link in > everything it needs. > > Since my primary goal is to get moved to different hardware, I'm > just going to continue running on 10.0.4 on the new hardware with > the 5.2.13 Bacula since 10.0.4 is supported until midway through > 2015. After I get everything migrated and stabilized, maybe I'll > play with debugging this 12.0.4 problem again in a virtual machine > or something in my spare time. > > Thanks again for the ideas, I learned a bit more about digging > around in the symbols on linux so it was worth that anyway. If I do > get back to it and find a solid answer, I'll update the list. > > Mike Some time ago i build 5.2.13 the Debian/Ubuntu way as .deb packages on Ubuntu 12.04. I can provide you a link for download without any warranty of course. Maybe i can even dig out the thing which have to be done to get the deb compiled. Regards Andreas -- Get your SQL database under version control now! Version control is standard for application code, but databases havent caught up. So what steps can you take to put your SQL databases under version control? Why should you start doing it? Read more to find out. http://pubads.g.doubleclick.net/gampad/clk?id=49501711&iu=/4140/ostg.clktrk ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users