Re: [Bacula-users] Bacula performance
On Wed, Aug 4, 2010 at 11:28 AM, rvent wrote: > Hello, > > I am new to Bacula and so far i really like it. > > I am testing Bacula and at the moment i am trying to backup to disk. > Everything seems to be working fine except that the file transfers from the > client to the server are not very fast. > > The server's interface is a 2Gbps card, the client's is 10/100mbps, the ports > on the switch where they both connect is 10/100 so i know i am not going to > get anything faster than 100mbps. However, i am not getting anywhere near > that. > > I found out i was using the default "Maximum Network Buffer Size" so i > changed that to 100mbps or 13107200 bytes, however, when the backup runs it > only gets to 1489510.4 bytes per second. If i copy the same amount of data > between the same server using "scp" i get 11MB/s. > > Is there anything i can check...? > > Thanks, bellow are the relevant config files. > > > bacula-dir.conf > > Job { > Name = test1 > Type = Backup > Level = Incremental > Client = client1-fd > FileSet = "wintest" > Schedule = "WeeklyCycle" > Storage = File > Messages = Standard > Pool = Default > Write Bootstrap = "/var/lib/bacula/%c.bsr" > Priority = 10 > } > > Client { > Name = client1-fd > Address = client1.domain.com > FDPort = 9102 > Catalog = MyCatalog > Password = "asdfsda" # password for FileDaemon > File Retention = 14 days # 30 > days > Job Retention = 1 months # > six months > AutoPrune = yes > # Prune expired Jobs/Files > } > > Storage { > Name = File > Address = server.domain.com > SDPort = 9103 > Password = "asdf" > Device = FileStorage > Media Type = File > } > > > bacula-sd.conf > > Device { > Name = FileStorage > Media Type = File > Archive Device = /bacula-staging/backups > LabelMedia = yes; > # lets Bacula label unlabeled media > Random Access = Yes; > AutomaticMount = yes; > # when device opened, read it > RemovableMedia = no; > Maximum Network Buffer Size = 13107200 > AlwaysOpen = no; > } > Turn off software compression and see if that helps. Also maybe turn on attribute spooling. John -- The Palm PDK Hot Apps Program offers developers who use the Plug-In Development Kit to bring their C/C++ apps to Palm for a share of $1 Million in cash or HP Products. Visit us here for more details: http://p.sf.net/sfu/dev2dev-palm ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] bacula make error (Installation error)
I am using Mac OS to install bacula. when ever i try to install bacula, make command doesnt work, though i m following all procedure from mannual, ./configure (options) works but make is not working, it gives following error - Administrators-MacBook-Pro-4:bacula administrator$ make ==>Entering directory /Users/administrator/documents/bacula/src make[1]: Nothing to be done for `all'. ==>Entering directory /Users/administrator/documents/bacula/scripts make[1]: Nothing to be done for `all'. ==>Entering directory /Users/administrator/documents/bacula/src/lib Compiling attr.c attr.c: In function int unpack_attributes_record(JCR*, int32_t, char*, ATTR*): attr.c:112: error: invalid conversion from int64_t* to intmax_t* attr.c:112: error: initializing argument 1 of int from_base64(intmax_t*, char*) make[1]: *** [attr.lo] Error 1 == Error in /Users/administrator/documents/bacula/src/lib == ==>Entering directory /Users/administrator/documents/bacula/src/findlib Compiling find.c Compiling match.c Compiling find_one.c Compiling attribs.c attribs.c: In function int decode_stat(char*, stat*, int32_t*): attribs.c:245: error: invalid conversion from int64_t* to intmax_t* attribs.c:245: error: initializing argument 1 of int from_base64(intmax_t*, char*) attribs.c:248: error: invalid conversion from int64_t* to intmax_t* attribs.c:248: error: initializing argument 1 of int from_base64(intmax_t*, char*) attribs.c:251: error: invalid conversion from int64_t* to intmax_t* attribs.c:251: error: initializing argument 1 of int from_base64(intmax_t*, char*) attribs.c:254: error: invalid conversion from int64_t* to intmax_t* attribs.c:254: error: initializing argument 1 of int from_base64(intmax_t*, char*) attribs.c:257: error: invalid conversion from int64_t* to intmax_t* attribs.c:257: error: initializing argument 1 of int from_base64(intmax_t*, char*) attribs.c:260: error: invalid conversion from int64_t* to intmax_t* attribs.c:260: error: initializing argument 1 of int from_base64(intmax_t*, char*) attribs.c:263: error: invalid conversion from int64_t* to intmax_t* attribs.c:263: error: initializing argument 1 of int from_base64(intmax_t*, char*) attribs.c:266: error: invalid conversion from int64_t* to intmax_t* attribs.c:266: error: initializing argument 1 of int from_base64(intmax_t*, char*) attribs.c:270: error: invalid conversion from int64_t* to intmax_t* attribs.c:270: error: initializing argument 1 of int from_base64(intmax_t*, char*) attribs.c:273: error: invalid conversion from int64_t* to intmax_t* attribs.c:273: error: initializing argument 1 of int from_base64(intmax_t*, char*) attribs.c:284: error: invalid conversion from int64_t* to intmax_t* attribs.c:284: error: initializing argument 1 of int from_base64(intmax_t*, char*) attribs.c:287: error: invalid conversion from int64_t* to intmax_t* attribs.c:287: error: initializing argument 1 of int from_base64(intmax_t*, char*) attribs.c:290: error: invalid conversion from int64_t* to intmax_t* attribs.c:290: error: initializing argument 1 of int from_base64(intmax_t*, char*) attribs.c:296: error: invalid conversion from int64_t* to intmax_t* attribs.c:296: error: initializing argument 1 of int from_base64(intmax_t*, char*) attribs.c:306: error: invalid conversion from int64_t* to intmax_t* attribs.c:306: error: initializing argument 1 of int from_base64(intmax_t*, char*) attribs.c:317: error: invalid conversion from int64_t* to intmax_t* attribs.c:317: error: initializing argument 1 of int from_base64(intmax_t*, char*) attribs.c: In function int32_t decode_LinkFI(char*, stat*): attribs.c:334: error: invalid conversion from int64_t* to intmax_t* attribs.c:334: error: initializing argument 1 of int from_base64(intmax_t*, char*) attribs.c:360: error: invalid conversion from int64_t* to intmax_t* attribs.c:360: error: initializing argument 1 of int from_base64(intmax_t*, char*) make[1]: *** [attribs.lo] Error 1 == Error in /Users/administrator/documents/bacula/src/findlib == ==>Entering directory /Users/administrator/documents/bacula/src/filed Compiling filed.c Compiling authenticate.c Compiling acl.c Compiling backup.c Compiling estimate.c Compiling fd_plugins.c Compiling accurate.c Compiling filed_conf.c Compiling heartbeat.c Compiling job.c Compiling pythonfd.c Compiling restore.c Compiling status.c Compiling verify.c Compiling verify_vol.c Compiling xattr.c make[1]: *** No rule to make target `../findlib/libbacfind.la', needed by `bacula-fd'. Stop. == Error in /Users/administrator/documents/bacula/src/filed == ==>Entering directory /Users/administrator/documents/bacula/src/console Compiling console.c Compiling console_conf.c Compiling authenticate.c Compiling conio.c make[1]: *** No rule to make target `../lib/lib
[Bacula-users] Bacula performance
Hello, I am new to Bacula and so far i really like it. I am testing Bacula and at the moment i am trying to backup to disk. Everything seems to be working fine except that the file transfers from the client to the server are not very fast. The server's interface is a 2Gbps card, the client's is 10/100mbps, the ports on the switch where they both connect is 10/100 so i know i am not going to get anything faster than 100mbps. However, i am not getting anywhere near that. I found out i was using the default "Maximum Network Buffer Size" so i changed that to 100mbps or 13107200 bytes, however, when the backup runs it only gets to 1489510.4 bytes per second. If i copy the same amount of data between the same server using "scp" i get 11MB/s. Is there anything i can check...? Thanks, bellow are the relevant config files. bacula-dir.conf Job { Name = test1 Type = Backup Level = Incremental Client = client1-fd FileSet = "wintest" Schedule = "WeeklyCycle" Storage = File Messages = Standard Pool = Default Write Bootstrap = "/var/lib/bacula/%c.bsr" Priority = 10 } Client { Name = client1-fd Address = client1.domain.com FDPort = 9102 Catalog = MyCatalog Password = "asdfsda" # password for FileDaemon File Retention = 14 days # 30 days Job Retention = 1 months # six months AutoPrune = yes # Prune expired Jobs/Files } Storage { Name = File Address = server.domain.com SDPort = 9103 Password = "asdf" Device = FileStorage Media Type = File } bacula-sd.conf Device { Name = FileStorage Media Type = File Archive Device = /bacula-staging/backups LabelMedia = yes; # lets Bacula label unlabeled media Random Access = Yes; AutomaticMount = yes; # when device opened, read it RemovableMedia = no; Maximum Network Buffer Size = 13107200 AlwaysOpen = no; } +-- |This was sent by rvent...@h-st.com via Backup Central. |Forward SPAM to ab...@backupcentral.com. +-- -- The Palm PDK Hot Apps Program offers developers who use the Plug-In Development Kit to bring their C/C++ apps to Palm for a share of $1 Million in cash or HP Products. Visit us here for more details: http://p.sf.net/sfu/dev2dev-palm ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Strategy question
Hello, Is is possible to have all the clients save their backups to their local drive (full, incremental, differential) and then back up those client backups to the server? Can i do this from one remote director? Or will every client have to be the director, storage and client? I think that this way if something happens to the network/server/storage/tapes at least the backups still happening. THanks +-- |This was sent by rvent...@h-st.com via Backup Central. |Forward SPAM to ab...@backupcentral.com. +-- -- The Palm PDK Hot Apps Program offers developers who use the Plug-In Development Kit to bring their C/C++ apps to Palm for a share of $1 Million in cash or HP Products. Visit us here for more details: http://p.sf.net/sfu/dev2dev-palm ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Bacula Autochanger Questions
On Thu, August 5, 2010 02:08, Alan Brown wrote: > John Drescher wrote: > >>> It does matter if they have data on them. >>> >> >> Agreed. If they were from some other backup program you need to erase >> them first. > > Or if they have last night's Bacula backups on them... > > "Label barcodes" is an extremely dangerous command and should be used > with extreme caution. > *Nonsense!!!* "Label barcodes" is perfectly safe, if any tapes in the autochanger are currently labelled they are ignored. To the OP - Have you put the barcode stickers (from HP) *on the tape cartridges the correct way up?* Cheers, GaryB-) -- The Palm PDK Hot Apps Program offers developers who use the Plug-In Development Kit to bring their C/C++ apps to Palm for a share of $1 Million in cash or HP Products. Visit us here for more details: http://p.sf.net/sfu/dev2dev-palm ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Bacula to Backup EMC Clariion cx4
Guys, Does anyone knows, briefly, how to backup data on the EMC Clariion cx4 storage, using Bacula? Regards, -- Heitor Medrado de Faria www.bacula.com.br Msn: hei...@bacula.com.br Gtalk: heitorfa...@gmail.com Skype: neocodeheitor + 55 71 9132-3349 +55 71 3381-6869 -- The Palm PDK Hot Apps Program offers developers who use the Plug-In Development Kit to bring their C/C++ apps to Palm for a share of $1 Million in cash or HP Products. Visit us here for more details: http://p.sf.net/sfu/dev2dev-palm ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Bacula + Postgres : copy batch problem
On 8/4/2010 6:50 AM, Rory Campbell-Lange wrote: > On 04/08/10, Dan Langille (d...@langille.org) wrote: > >> I think stored procedures would be a good idea. That way, we could >> improve the functionality without changing the application. >> >> That said, we do not at present use stored procedures. We'd have to >> proceed carefully. > > Fair enough. Can restores run off marked columns in database tables? > This exercise could be taken out of the main core of Bacula into a > little Django app (perhaps) and not affect the main body of Bacula at > all except for some way of executing restores. I have no idea what you mean by that question. -- Dan Langille - http://langille.org/ -- The Palm PDK Hot Apps Program offers developers who use the Plug-In Development Kit to bring their C/C++ apps to Palm for a share of $1 Million in cash or HP Products. Visit us here for more details: http://p.sf.net/sfu/dev2dev-palm ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] bacula confused about slots on autochanger
Message: 4 Date: Wed, 04 Aug 2010 10:37:21 -0400 From: Josh Fisher Subject: Re: [Bacula-users] bacula confused about slots on autochanger To: bacula-users@lists.sourceforge.net Message-ID: <4c597b21.2050...@pvct.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed On 8/3/2010 9:20 PM, Maria McKinley wrote: > > It seems that part of the problem I have been having with backup is that > > bacula is having communication problems with the autochanger. Bacula > > tells the autochanger to load slot 3, but instead slot 2 is loaded: On some systems, (BSD?) slot numbers are expected to begin at zero. Bacula (and Linux) expect slot numbers to begin at one. When Bacula sends a command to the autochanger to load slot 1, it is expecting the first slot to be loaded. But on systems that number from zero, when you use mtx to load slot 1 it will actually load the second slot. This can be worked around by changing your autochanger script to subtract 1 from the slot number on a load command and add 1 to slot numbers for the loaded and list commands. I am running linux, but this sounds like it would fix the problem. It isn't clear to me what to change. Here is the relevant bit from my script (3 is the input argument for slots). I don't think I can just change the setup argument to slot=$3+1, but not entirely sure why not: # Setup arguments ctl=$1 cmd="$2" slot=$3 device=$4 drive=$5 debug "Parms: $ctl $cmd $slot $device $drive" case $cmd in unload) debug "Doing mtx -f $ctl unload $slot $drive" # # enable the following line if you need to eject the cartridge # mt -f $device offline # sleep 10 ${MTX} -f $ctl unload $slot $drive ;; load) debug "Doing mtx -f $ctl load $slot $drive" ${MTX} -f $ctl load $slot $drive rtn=$? # # Increase the sleep time if you have a slow device # or remove the sleep and add the following: # sleep 15 wait_for_drive $device exit $rtn ;; list) debug "Doing mtx -f $ctl -- to list volumes" make_temp_file # Enable the following if you are using barcodes and need an inventory # ${MTX} -f $ctl inventory ${MTX} -f $ctl status >${TMPFILE} rtn=$? cat ${TMPFILE} | grep " Storage Element [0-9]*:.*Full" | awk "{print \$3 \$4}" | sed "s/Full *\(:VolumeTag=\)*//" # # If you have a VXA PacketLoader and the above does not work, try # turning it off and enabling the following line. # cat ${TMPFILE} | grep " *Storage Element [0-9]*:.*Full" | sed "s/ Storage Element //" | sed "s/Full :VolumeTag=//" # cat ${TMPFILE} | grep "^Data Transfer Element [0-9]*:Full (Storage Element [0-9]" | awk '{printf "%s:%s\n",$7,$10}' rm -f ${TMPFILE} >/dev/null 2>&1 exit $rtn ;; loaded) debug "Doing mtx -f $ctl $drive -- to find what is loaded" make_temp_file ${MTX} -f $ctl status >${TMPFILE} rtn=$? cat ${TMPFILE} | grep "^Data Transfer Element $drive:Full" | awk "{print \$7}" cat ${TMPFILE} | grep "^Data Transfer Element $drive:Empty" | awk "{print 0}" rm -f ${TMPFILE} >/dev/null 2>&1 exit $rtn ;; slots) debug "Doing mtx -f $ctl -- to get count of slots" ${MTX} -f $ctl status | grep " *Storage Changer" | awk "{print \$5}" ;; esac thanks, maria -- The Palm PDK Hot Apps Program offers developers who use the Plug-In Development Kit to bring their C/C++ apps to Palm for a share of $1 Million in cash or HP Products. Visit us here for more details: http://p.sf.net/sfu/dev2dev-palm ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] bacula confused about slots on autochanger
> Where would that be? I don't see it in /etc/bacula/, and I don't see a > reference to it in /etc/bacula/scripts/mtx-changer. Both mtx-changer and mtx-changer.conf should be in /usr/libexec/bacula at least they are on my system John -- The Palm PDK Hot Apps Program offers developers who use the Plug-In Development Kit to bring their C/C++ apps to Palm for a share of $1 Million in cash or HP Products. Visit us here for more details: http://p.sf.net/sfu/dev2dev-palm ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] issue with "delete pool"
When deleting a pool via bconsole, the volumes of that pool still exists in filesystem but are not known anymore to the director and needs to be deleted manually. When I use the label command: Connecting to Storage daemon daily_storage at 192.168.2.211:9103 ... Sending label command for Volume "" Slot 0 ... 3920 Cannot label Volume because it is already labeled: "" Label command failed for Volume . I wonder if this is by design? Also all jobs written to volumes of that pool still exists in database and are shown on "list jobs". You need to go and delete all jobs of that volume by hand. This can be much fun. -- The Palm PDK Hot Apps Program offers developers who use the Plug-In Development Kit to bring their C/C++ apps to Palm for a share of $1 Million in cash or HP Products. Visit us here for more details: http://p.sf.net/sfu/dev2dev-palm ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Upgrading Bacula
Thanks to all for your responses. I found the database table upgrade scripts in the source tree under updatedb. There I found the update_mysql_tables_10_to_11 which then allowed me to run the update_mysql_tables under the install directory. All of the daemons are up and running. My client machines are still running 2.2.5 which I will be upgrading soon but the server seems to be communicating fine with them. I tested the connections using the "status" command in bconsole. Thanks again for all of the help! Brian John Doe wrote: From: Brian White Phil Stracchino wrote: On 08/04/10 11:14, Brian White wrote: I've been using Bacula 2.2.5 as my primary backup software for several years now and am very happy. As we move to newer version of our linux operating system I'm having issues with the client so I've decided it's about time to upgrade. My plan is to upgrade to the latest stable version 5.0.2. I'm concerned about upgrading the database tables. I'm using MySql. I know there is a script to upgrade the tables in my database but the comments in the script talk about upgrading from 3.0 to 5.0. Can I just run this script or should I download a previous version of bacula, say 3.0.x, and run that database table upgrade script first? Your database has a Version table containing the current DB schema version. You need to find what version your current DB is, then obtain and run, in order, all of the single-version upgrade scripts necessary to bring it up to the current Version 12. Thanks. I don't know MySQL very well. Do you know how I would go about finding the current DB schema version? # mysql bacula mysql> select * from Version; JD -- The Palm PDK Hot Apps Program offers developers who use the Plug-In Development Kit to bring their C/C++ apps to Palm for a share of $1 Million in cash or HP Products. Visit us here for more details: http://p.sf.net/sfu/dev2dev-palm ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users signature.asc Description: OpenPGP digital signature -- The Palm PDK Hot Apps Program offers developers who use the Plug-In Development Kit to bring their C/C++ apps to Palm for a share of $1 Million in cash or HP Products. Visit us here for more details: http://p.sf.net/sfu/dev2dev-palm___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] bacula confused about slots on autochanger
On 8/4/10 4:40 AM, John Drescher wrote: > On Tue, Aug 3, 2010 at 9:20 PM, Maria McKinley wrote: >> It seems that part of the problem I have been having with backup is that >> bacula is having communication problems with the autochanger. Bacula >> tells the autochanger to load slot 3, but instead slot 2 is loaded: >> >> *messages >> 03-Aug 18:14 billie-sd JobId 1728: 3301 Issuing autochanger "loaded? >> drive 0" command. >> 03-Aug 18:14 billie-sd JobId 1728: 3302 Autochanger "loaded? drive 0", >> result: nothing loaded. >> 03-Aug 18:14 billie-sd JobId 1728: 3304 Issuing autochanger "load slot >> 3, drive 0" command. >> * >> 03-Aug 18:15 billie-sd JobId 1728: 3305 Autochanger "load slot 3, drive >> 0", status is OK. >> * >> 03-Aug 18:15 billie-sd JobId 1728: Warning: Director wanted Volume >> "A005". >> Current Volume "B005" not acceptable because: >> 1998 Volume "B005" status is Full, not in Pool. >> 03-Aug 18:15 billie-sd JobId 1728: Please mount Volume "A005" or >> label a new one for: >> Job: NightlySave.2010-08-01_01.05.00.32 >> Storage: "Drive-1" (/dev/nst0) >> Pool: Daily >> Media type: VXA-2 >> *exit >> billie:~# mtx -f /dev/sg2 status >>Storage Changer /dev/sg2:1 Drives, 10 Slots ( 0 Import/Export ) >> Data Transfer Element 0:Full (Storage Element 2 Loaded):VolumeTag = >> B005 >>Storage Element 1:Full :VolumeTag=A006 >> >>Storage Element 2:Empty:VolumeTag= >> >>Storage Element 3:Full :VolumeTag=A005 >> >>Storage Element 4:Full :VolumeTag=A004 >> >>Storage Element 5:Full :VolumeTag=B004 >> >>Storage Element 6:Full :VolumeTag=C005 >> >>Storage Element 7:Full :VolumeTag=A007 >> >>Storage Element 8:Full :VolumeTag=C006 >> >>Storage Element 9:Full :VolumeTag=A010 >> >>Storage Element 10:Full :VolumeTag=CLNA0001 >> >> Any ideas what is going on or how to fix it? >> > > You probably need to edit mtx-changer to get it to do the right thing. > Did you specify that you have a vxa changer in your mtx-changer.conf? > > John Where would that be? I don't see it in /etc/bacula/, and I don't see a reference to it in /etc/bacula/scripts/mtx-changer. thanks, maria -- The Palm PDK Hot Apps Program offers developers who use the Plug-In Development Kit to bring their C/C++ apps to Palm for a share of $1 Million in cash or HP Products. Visit us here for more details: http://p.sf.net/sfu/dev2dev-palm ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] bacula confused about slots on autochanger
Laurent HENRY (EHESS/CRI) wrote: > Hi, no clever idea for me, just basic thoughts. > > what is the output of an update slots command ? > > what happen when you ask a 'mount' request from slot 3 ? > > Through some trickery (loaded the tape into the drive from outside bacula, and then mounted in bacula), I was able to get it to use the tape in slot 3 for that backup, but I did not get so lucky with the next backup. Initially it could not eject the previous tape because of the confusion of slots. Then, once I manually loaded the correct tape outside of bacula and mounted, it did not recognize that it had the correct tape and attempted to eject it: *messages 04-Aug 08:40 billie-sd JobId 1729: 3307 Issuing autochanger "unload slot 7, drive 0" command. 04-Aug 08:40 billie-sd JobId 1729: 3995 Bad autochanger "unload slot 7, drive 0": ERR=Child exited with code 1 Results=Storage Element 6 is Already Full 04-Aug 08:40 billie-sd JobId 1729: 3301 Issuing autochanger "loaded? drive 0" command. 04-Aug 08:40 billie-sd JobId 1729: 3302 Autochanger "loaded? drive 0", result is Slot 7. 04-Aug 01:59 billie-sd JobId 1729: Please mount Volume "A007" or label a new one for: Job: MailBackup.2010-08-01_01.10.00.33 Storage: "Drive-1" (/dev/nst0) Pool: Servers Media type: VXA-2 *exit billie:~# mtx -f /dev/sg2 status Storage Changer /dev/sg2:1 Drives, 10 Slots ( 0 Import/Export ) Data Transfer Element 0:Full (Storage Element 3 Loaded):VolumeTag = A005 Storage Element 1:Full :VolumeTag=A006 Storage Element 2:Full :VolumeTag=B005 Storage Element 3:Empty:VolumeTag= Storage Element 4:Full :VolumeTag=A004 Storage Element 5:Full :VolumeTag=B004 Storage Element 6:Full :VolumeTag=C005 Storage Element 7:Full :VolumeTag=A007 Storage Element 8:Full :VolumeTag=C006 Storage Element 9:Full :VolumeTag=A010 Storage Element 10:Full :VolumeTag=CLNA0001 billie:~# mtx -f /dev/sg2 unload 3 Unloading drive 0 into Storage Element 3...done billie:~# mtx -f /dev/sg2 load 7 Loading media from Storage Element 7 into drive 0...done billie:~# bconsole Connecting to Director 127.0.0.1:9101 1000 OK: billie-dir Version: 2.4.4 (28 December 2008) Enter a period to cancel a command. *mount Automatically selected Catalog: MyCatalog Using Catalog "MyCatalog" The defined Storage resources are: 1: Exabyte 2: File Select Storage resource (1-2): 1 3001 OK mount. Device="Drive-1" (/dev/nst0) You have messages. *messages 04-Aug 08:40 billie-sd JobId 1729: 3301 Issuing autochanger "loaded? drive 0" command. 04-Aug 08:40 billie-sd JobId 1729: 3302 Autochanger "loaded? drive 0", result is Slot 7. 04-Aug 08:40 billie-sd JobId 1729: 3307 Issuing autochanger "unload slot 7, drive 0" command. 04-Aug 08:40 billie-sd JobId 1729: 3995 Bad autochanger "unload slot 7, drive 0": ERR=Child exited with code 1 Results=Storage Element 6 is Already Full *update slots Automatically selected Catalog: MyCatalog Using Catalog "MyCatalog" The defined Storage resources are: 1: Exabyte 2: File Select Storage resource (1-2): 1 Connecting to Storage daemon Exabyte at billie:9103 ... 3306 Issuing autochanger "slots" command. Device "Exabyte" has 10 slots. Connecting to Storage daemon Exabyte at billie:9103 ... 3306 Issuing autochanger "list" command. Catalog record for Volume "A006" updated to reference slot 1. Catalog record for Volume "B005" updated to reference slot 2. Catalog record for Volume "A005" updated to reference slot 3. Catalog record for Volume "A004" updated to reference slot 4. Catalog record for Volume "B004" updated to reference slot 5. Volume "C005" not found in catalog. Slot=6 InChanger set to zero. Catalog record for Volume "A007" updated to reference slot 7. Catalog record for Volume "C006" updated to reference slot 8. Catalog record for Volume "A010" updated to reference slot 9. Catalog record for Volume "CLNA0001" updated to reference slot 10. Ugh. thanks, maria -- The Palm PDK Hot Apps Program offers developers who use the Plug-In Development Kit to bring their C/C++ apps to Palm for a share of $1 Million in cash or HP Products. Visit us here for more details: http://p.sf.net/sfu/dev2dev-palm ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Bacula Autochanger Questions
On Wed, Aug 4, 2010 at 12:21 PM, sid009 wrote: > Following is the list of Volumes I have: > > > *list volumes > Pool: Default > +-++---+-+-+--+--+-+--+---+---+-+ > | MediaId | VolumeName | VolStatus | Enabled | VolBytes > | VolFiles | VolRetention | Recycle | Slot | InChanger | MediaType | > LastWritten | > +-++---+-+-+--+--+-+--+---+---+-+ > | 15 | Volume1 | Append | > 1 | 351,791,096,832 | 356 | > 31,536,000 | 1 | 1 | > 1 | LTO3 | 2010-07-31 > 22:01:22 | > | 16 | Volume2 | Append | > 1 | 64,512 | > 0 | 31,536,000 | 1 > | 2 | 1 | LTO3 > | -00-00 00:00:00 | > | 17 | Volume3 | Append | > 1 | 64,512 | > 0 | 31,536,000 | 1 > | 3 | 1 | LTO3 > | -00-00 00:00:00 | > | 18 | Volume4 | Append | > 1 | 64,512 | > 0 | 31,536,000 | 1 > | 4 | 1 | LTO3 > | -00-00 00:00:00 | > | 19 | Volume5 | Append | > 1 | 64,512 | > 0 | 31,536,000 | 1 > | 5 | 1 | LTO3 > | -00-00 00:00:00 | > | 20 | Volume6 | Append | > 1 | 64,512 | > 0 | 31,536,000 | 1 > | 6 | 1 | LTO3 > | -00-00 00:00:00 | > | 21 | Volume7 | Append | > 1 | 64,512 | > 0 | 31,536,000 | 1 > | 7 | 1 | LTO3 > | -00-00 00:00:00 | > | 22 | Volume8 | Recycle | > 1 | 381,886,654,464 | 385 | > 31,536,000 | 1 | 8 | > 1 | LTO3 | 2010-06-04 > 03:57:05 | > +-++---+-+-+--+--+-+--+---+---+-+ > > > Notice all volumes are appendable and Volume 1 is full. Is there a reason why > the tape does not pick up say Volume 2 automatically when Volume 1 is full. > On the mailing list your table above is not readable. I will try to look at the forum later. > p.s. I manually recycled Volume 8 when it filled up as I could not backup > anything else on to other tapes. > > Do you guys suggest I: > 1- Blank both tapes > 2- Delete the labels and re-create the labels > > Will this help the tapedrive to auto-select the next volume when one gets > filled up? > Having properly labeled barcode volumes will fix issues with your autochanger knowing what volumes exist in the changer without having to load every tape to figure that out. It will not fix any other problem. John -- The Palm PDK Hot Apps Program offers developers who use the Plug-In Development Kit to bring their C/C++ apps to Palm for a share of $1 Million in cash or HP Products. Visit us here for more details: http://p.sf.net/sfu/dev2dev-palm ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Bacula Autochanger Questions
Following is the list of Volumes I have: *list volumes Pool: Default +-++---+-+-+--+--+-+--+---+---+-+ | MediaId | VolumeName | VolStatus | Enabled | VolBytes | VolFiles | VolRetention | Recycle | Slot | InChanger | MediaType | LastWritten | +-++---+-+-+--+--+-+--+---+---+-+ | 15 | Volume1 | Append | 1 | 351,791,096,832 | 356 | 31,536,000 | 1 | 1 | 1 | LTO3 | 2010-07-31 22:01:22 | | 16 | Volume2 | Append | 1 | 64,512 | 0 | 31,536,000 | 1 | 2 | 1 | LTO3 | -00-00 00:00:00 | | 17 | Volume3 | Append | 1 | 64,512 | 0 | 31,536,000 | 1 | 3 | 1 | LTO3 | -00-00 00:00:00 | | 18 | Volume4 | Append | 1 | 64,512 | 0 | 31,536,000 | 1 | 4 | 1 | LTO3 | -00-00 00:00:00 | | 19 | Volume5 | Append | 1 | 64,512 | 0 | 31,536,000 | 1 | 5 | 1 | LTO3 | -00-00 00:00:00 | | 20 | Volume6 | Append | 1 | 64,512 | 0 | 31,536,000 | 1 | 6 | 1 | LTO3 | -00-00 00:00:00 | | 21 | Volume7 | Append | 1 | 64,512 | 0 | 31,536,000 | 1 | 7 | 1 | LTO3 | -00-00 00:00:00 | | 22 | Volume8 | Recycle | 1 | 381,886,654,464 | 385 | 31,536,000 | 1 | 8 | 1 | LTO3 | 2010-06-04 03:57:05 | +-++---+-+-+--+--+-+--+---+---+-+ Notice all volumes are appendable and Volume 1 is full. Is there a reason why the tape does not pick up say Volume 2 automatically when Volume 1 is full. p.s. I manually recycled Volume 8 when it filled up as I could not backup anything else on to other tapes. Do you guys suggest I: 1- Blank both tapes 2- Delete the labels and re-create the labels Will this help the tapedrive to auto-select the next volume when one gets filled up? Thanks for your help +-- |This was sent by s...@logicscope.com via Backup Central. |Forward SPAM to ab...@backupcentral.com. +-- -- The Palm PDK Hot Apps Program offers developers who use the Plug-In Development Kit to bring their C/C++ apps to Palm for a share of $1 Million in cash or HP Products. Visit us here for more details: http://p.sf.net/sfu/dev2dev-palm ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Bacula Autochanger Questions
On Wed, Aug 4, 2010 at 12:18 PM, John Drescher wrote: > On Wed, Aug 4, 2010 at 12:08 PM, Alan Brown wrote: >> John Drescher wrote: >> It does matter if they have data on them. >>> >>> Agreed. If they were from some other backup program you need to erase >>> them first. >> >> Or if they have last night's Bacula backups on them... >> >> "Label barcodes" is an extremely dangerous command and should be used with >> extreme caution. >> > > I use it every time I add tapes for the last 4 years. It does not harm > already written volumes at all. > It just ignores already written volumes. Here is the rest of the run from this morning: Media record for Slot 2 Volume "A7" already exists. Sending label command for Volume "A00086" Slot 3 ... 3307 Issuing autochanger "unload slot 1, drive 1" command. 3304 Issuing autochanger "load slot 3, drive 1" command. 3305 Autochanger "load slot 3, drive 1", status is OK. block.c:1016 Read error on fd=9 at file:blk 0:0 on device "LTO2-1" (/dev/nst1). ERR=Input/output error. 3000 OK label. VolBytes=64512 DVD=0 Volume="A00086" Device="LTO2-1" (/dev/nst1) Catalog record for Volume "A00086", Slot 3 successfully created. Media record for Slot 4 Volume "A00058" already exists. Media record for Slot 5 Volume "A00023" already exists. Media record for Slot 6 Volume "A6" already exists. Media record for Slot 7 Volume "A00072" already exists. Sending label command for Volume "A00085" Slot 8 ... 3307 Issuing autochanger "unload slot 3, drive 1" command. 3304 Issuing autochanger "load slot 8, drive 1" command. 3305 Autochanger "load slot 8, drive 1", status is OK. block.c:1016 Read error on fd=9 at file:blk 0:0 on device "LTO2-1" (/dev/nst1). ERR=Input/output error. 3000 OK label. VolBytes=64512 DVD=0 Volume="A00085" Device="LTO2-1" (/dev/nst1) Catalog record for Volume "A00085", Slot 8 successfully created. Media record for Slot 9 Volume "A00028" already exists. Sending label command for Volume "A00084" Slot 10 ... 3307 Issuing autochanger "unload slot 8, drive 1" command. 3304 Issuing autochanger "load slot 10, drive 1" command. 3305 Autochanger "load slot 10, drive 1", status is OK. block.c:1016 Read error on fd=9 at file:blk 0:0 on device "LTO2-1" (/dev/nst1). ERR=Input/output error. 3000 OK label. VolBytes=64512 DVD=0 Volume="A00084" Device="LTO2-1" (/dev/nst1) Catalog record for Volume "A00084", Slot 10 successfully created. Media record for Slot 11 Volume "A00054" already exists. Media record for Slot 12 Volume "A00039" already exists. Media record for Slot 13 Volume "A00073" already exists. Media record for Slot 14 Volume "A00012" already exists. Media record for Slot 15 Volume "A00037" already exists. Media record for Slot 16 Volume "A00053" already exists. Media record for Slot 17 Volume "A00074" already exists. Media record for Slot 18 Volume "A00052" already exists. Media record for Slot 19 Volume "A00030" already exists. Media record for Slot 20 Volume "A00081" already exists. Media record for Slot 21 Volume "A00082" already exists. Media record for Slot 22 Volume "A00063" already exists. Media record for Slot 23 Volume "A00083" already exists. John -- The Palm PDK Hot Apps Program offers developers who use the Plug-In Development Kit to bring their C/C++ apps to Palm for a share of $1 Million in cash or HP Products. Visit us here for more details: http://p.sf.net/sfu/dev2dev-palm ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Bacula Autochanger Questions
On Wed, Aug 4, 2010 at 12:08 PM, Alan Brown wrote: > John Drescher wrote: > >>> It does matter if they have data on them. >>> >> >> Agreed. If they were from some other backup program you need to erase >> them first. > > Or if they have last night's Bacula backups on them... > > "Label barcodes" is an extremely dangerous command and should be used with > extreme caution. > I use it every time I add tapes for the last 4 years. It does not harm already written volumes at all. John -- The Palm PDK Hot Apps Program offers developers who use the Plug-In Development Kit to bring their C/C++ apps to Palm for a share of $1 Million in cash or HP Products. Visit us here for more details: http://p.sf.net/sfu/dev2dev-palm ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Upgrading Bacula
From: Brian White >Phil Stracchino wrote: >On 08/04/10 11:14, Brian White wrote: >>I've been using Bacula 2.2.5 as my primary backup software for several >>>years now and am very happy. As we move to newer version of our linux >>>operating system I'm having issues with the client so I've decided it's >>>about time to upgrade. My plan is to upgrade to the latest stable >>>version 5.0.2. I'm concerned about upgrading the database tables. I'm >>>using MySql. I know there is a script to upgrade the tables in my >>>database but the comments in the script talk about upgrading from 3.0 to >>>5.0. Can I just run this script or should I download a previous version >>>of bacula, say 3.0.x, and run that database table upgrade script first? >>Your database has a Version table containing the current DB schema >>version. You need to find what version your current DB is, then obtain >>and run, in order, all of the single-version upgrade scripts necessary >>to bring it up to the current Version 12. > Thanks. I don't know MySQL very well. Do you know how I would go about > finding the current DB schema version? # mysql bacula mysql> select * from Version; JD -- The Palm PDK Hot Apps Program offers developers who use the Plug-In Development Kit to bring their C/C++ apps to Palm for a share of $1 Million in cash or HP Products. Visit us here for more details: http://p.sf.net/sfu/dev2dev-palm ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Bacula Autochanger Questions
John Drescher wrote: >> It does matter if they have data on them. >> > > Agreed. If they were from some other backup program you need to erase > them first. Or if they have last night's Bacula backups on them... "Label barcodes" is an extremely dangerous command and should be used with extreme caution. -- The Palm PDK Hot Apps Program offers developers who use the Plug-In Development Kit to bring their C/C++ apps to Palm for a share of $1 Million in cash or HP Products. Visit us here for more details: http://p.sf.net/sfu/dev2dev-palm ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Upgrading Bacula
Thanks. I don't know MySQL very well. Do you know how I would go about finding the current DB schema version? Thanks. Phil Stracchino wrote: On 08/04/10 11:14, Brian White wrote: I've been using Bacula 2.2.5 as my primary backup software for several years now and am very happy. As we move to newer version of our linux operating system I'm having issues with the client so I've decided it's about time to upgrade. My plan is to upgrade to the latest stable version 5.0.2. I'm concerned about upgrading the database tables. I'm using MySql. I know there is a script to upgrade the tables in my database but the comments in the script talk about upgrading from 3.0 to 5.0. Can I just run this script or should I download a previous version of bacula, say 3.0.x, and run that database table upgrade script first? Your database has a Version table containing the current DB schema version. You need to find what version your current DB is, then obtain and run, in order, all of the single-version upgrade scripts necessary to bring it up to the current Version 12. signature.asc Description: OpenPGP digital signature -- The Palm PDK Hot Apps Program offers developers who use the Plug-In Development Kit to bring their C/C++ apps to Palm for a share of $1 Million in cash or HP Products. Visit us here for more details: http://p.sf.net/sfu/dev2dev-palm___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Upgrading Bacula
On 08/04/10 11:14, Brian White wrote: > I've been using Bacula 2.2.5 as my primary backup software for several > years now and am very happy. As we move to newer version of our linux > operating system I'm having issues with the client so I've decided it's > about time to upgrade. My plan is to upgrade to the latest stable > version 5.0.2. I'm concerned about upgrading the database tables. I'm > using MySql. I know there is a script to upgrade the tables in my > database but the comments in the script talk about upgrading from 3.0 to > 5.0. Can I just run this script or should I download a previous version > of bacula, say 3.0.x, and run that database table upgrade script first? Your database has a Version table containing the current DB schema version. You need to find what version your current DB is, then obtain and run, in order, all of the single-version upgrade scripts necessary to bring it up to the current Version 12. -- Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355 ala...@caerllewys.net ala...@metrocast.net p...@co.ordinate.org Renaissance Man, Unix ronin, Perl hacker, Free Stater It's not the years, it's the mileage. -- The Palm PDK Hot Apps Program offers developers who use the Plug-In Development Kit to bring their C/C++ apps to Palm for a share of $1 Million in cash or HP Products. Visit us here for more details: http://p.sf.net/sfu/dev2dev-palm ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Upgrading Bacula
2010/8/4 Brian White : > I've been using Bacula 2.2.5 as my primary backup software for several > years now and am very happy. As we move to newer version of our linux > operating system I'm having issues with the client so I've decided it's > about time to upgrade. My plan is to upgrade to the latest stable > version 5.0.2. I'm concerned about upgrading the database tables. I'm > using MySql. I know there is a script to upgrade the tables in my > database but the comments in the script talk about upgrading from 3.0 to > 5.0. Can I just run this script or should I download a previous version > of bacula, say 3.0.x, and run that database table upgrade script first? > You need to to use the previous scripts first. I am not sure which you need to begin with. John -- The Palm PDK Hot Apps Program offers developers who use the Plug-In Development Kit to bring their C/C++ apps to Palm for a share of $1 Million in cash or HP Products. Visit us here for more details: http://p.sf.net/sfu/dev2dev-palm ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Bacula Autochanger Questions
On Wed, Aug 4, 2010 at 11:18 AM, Alan Brown wrote: > John Drescher wrote: It is not correct to manually label tapes in an autochanger if you have one that has a barcode reader. With a barcode reader you issue label barcodes from the console after you issue update slots. >>> >>> You assume you have a changer full of blank tapes. >>> >> >> It does not matter if some are already in pools. Only 4 of the 24 >> volumes in my changer are blank: > > It does matter if they have data on them. > Agreed. If they were from some other backup program you need to erase them first. John -- The Palm PDK Hot Apps Program offers developers who use the Plug-In Development Kit to bring their C/C++ apps to Palm for a share of $1 Million in cash or HP Products. Visit us here for more details: http://p.sf.net/sfu/dev2dev-palm ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Bacula Autochanger Questions
John Drescher wrote: >>> It is not correct to manually label tapes in an autochanger if you >>> have one that has a barcode reader. With a barcode reader you issue >>> label barcodes from the console after you issue update slots. >> You assume you have a changer full of blank tapes. >> > > It does not matter if some are already in pools. Only 4 of the 24 > volumes in my changer are blank: It does matter if they have data on them. > > *label barcodes > The defined Storage resources are: > 1: File > 2: DLT-IV > 3: DVD-FILESERVER > 4: DEV6-DLT-IV-0 > 5: DEV6-LTO-0 > 6: DEV6-LTO2-1 > 7: DEV6-Changer > Select Storage resource (1-7): 6 > Connecting to Storage daemon DEV6-LTO2-1 at dev6.radimg.pitt.edu:9103 ... > 3306 Issuing autochanger "slots" command. > Device "LTO2-1" has 24 slots. > Connecting to Storage daemon DEV6-LTO2-1 at dev6.radimg.pitt.edu:9103 ... > 3306 Issuing autochanger "list" command. > The following Volumes will be labeled: > Slot Volume > == >1 A00087 >2 A7 >3 A00086 >4 A00058 >5 A00023 >6 A6 >7 A00072 >8 A00085 >9 A00028 > 10 A00084 > 11 A00054 > 12 A00039 > 13 A00073 > 14 A00012 > 15 A00037 > 16 A00053 > 17 A00074 > 18 A00052 > 19 A00030 > 20 A00081 > 21 A00082 > 22 A00063 > 23 A00083 > Do you want to label these Volumes? (yes|no): yes > Defined Pools: > 1: Disk-Temp-Pool > 2: CleanImages > 3: TempBack > 4: PLuSS > 5: TMImages > 6: Unscrubbed > 7: System > 8: Other > 9: BackupCatalogs > 10: Temp-Disk-Pool > 11: DVD-Pool > 12: LTO2-Temp-Pool > 13: LTO2-Archived-Data > 14: LTO2-Archived-Data-Set2 > 15: LTO2-Test-Pool > 16: Scratch > 17: LTO2-System-Backups > 18: LTO2-Study-Backup > 19: Default > 20: Monthly > 21: Daily > 22: UserBackup > 23: UserBackup-LTO2 > 24: Images > Select the Pool (1-24): 16 > Connecting to Storage daemon DEV6-LTO2-1 at dev6.radimg.pitt.edu:9103 ... > Sending label command for Volume "A00087" Slot 1 ... > 3301 Issuing autochanger "loaded? drive 1" command. > 3302 Autochanger "loaded? drive 1", result: nothing loaded. > 3304 Issuing autochanger "load slot 1, drive 1" command. > 3305 Autochanger "load slot 1, drive 1", status is OK. > block.c:1016 Read error on fd=9 at file:blk 0:0 on device "LTO2-1" > (/dev/nst1). ERR=Input/output error. > 3000 OK label. VolBytes=64512 DVD=0 Volume="A00087" Device="LTO2-1" > (/dev/nst1) > Catalog record for Volume "A00087", Slot 1 successfully created. > Media record for Slot 2 Volume "A7" already exists. > Sending label command for Volume "A00086" Slot 3 ... > 3307 Issuing autochanger "unload slot 1, drive 1" command. > > > John > -- The Palm PDK Hot Apps Program offers developers who use the Plug-In Development Kit to bring their C/C++ apps to Palm for a share of $1 Million in cash or HP Products. Visit us here for more details: http://p.sf.net/sfu/dev2dev-palm ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Bacula Autochanger Questions
>> It is not correct to manually label tapes in an autochanger if you >> have one that has a barcode reader. With a barcode reader you issue >> label barcodes from the console after you issue update slots. > > You assume you have a changer full of blank tapes. > It does not matter if some are already in pools. Only 4 of the 24 volumes in my changer are blank: *label barcodes The defined Storage resources are: 1: File 2: DLT-IV 3: DVD-FILESERVER 4: DEV6-DLT-IV-0 5: DEV6-LTO-0 6: DEV6-LTO2-1 7: DEV6-Changer Select Storage resource (1-7): 6 Connecting to Storage daemon DEV6-LTO2-1 at dev6.radimg.pitt.edu:9103 ... 3306 Issuing autochanger "slots" command. Device "LTO2-1" has 24 slots. Connecting to Storage daemon DEV6-LTO2-1 at dev6.radimg.pitt.edu:9103 ... 3306 Issuing autochanger "list" command. The following Volumes will be labeled: Slot Volume == 1 A00087 2 A7 3 A00086 4 A00058 5 A00023 6 A6 7 A00072 8 A00085 9 A00028 10 A00084 11 A00054 12 A00039 13 A00073 14 A00012 15 A00037 16 A00053 17 A00074 18 A00052 19 A00030 20 A00081 21 A00082 22 A00063 23 A00083 Do you want to label these Volumes? (yes|no): yes Defined Pools: 1: Disk-Temp-Pool 2: CleanImages 3: TempBack 4: PLuSS 5: TMImages 6: Unscrubbed 7: System 8: Other 9: BackupCatalogs 10: Temp-Disk-Pool 11: DVD-Pool 12: LTO2-Temp-Pool 13: LTO2-Archived-Data 14: LTO2-Archived-Data-Set2 15: LTO2-Test-Pool 16: Scratch 17: LTO2-System-Backups 18: LTO2-Study-Backup 19: Default 20: Monthly 21: Daily 22: UserBackup 23: UserBackup-LTO2 24: Images Select the Pool (1-24): 16 Connecting to Storage daemon DEV6-LTO2-1 at dev6.radimg.pitt.edu:9103 ... Sending label command for Volume "A00087" Slot 1 ... 3301 Issuing autochanger "loaded? drive 1" command. 3302 Autochanger "loaded? drive 1", result: nothing loaded. 3304 Issuing autochanger "load slot 1, drive 1" command. 3305 Autochanger "load slot 1, drive 1", status is OK. block.c:1016 Read error on fd=9 at file:blk 0:0 on device "LTO2-1" (/dev/nst1). ERR=Input/output error. 3000 OK label. VolBytes=64512 DVD=0 Volume="A00087" Device="LTO2-1" (/dev/nst1) Catalog record for Volume "A00087", Slot 1 successfully created. Media record for Slot 2 Volume "A7" already exists. Sending label command for Volume "A00086" Slot 3 ... 3307 Issuing autochanger "unload slot 1, drive 1" command. John -- The Palm PDK Hot Apps Program offers developers who use the Plug-In Development Kit to bring their C/C++ apps to Palm for a share of $1 Million in cash or HP Products. Visit us here for more details: http://p.sf.net/sfu/dev2dev-palm ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Upgrading Bacula
I've been using Bacula 2.2.5 as my primary backup software for several years now and am very happy. As we move to newer version of our linux operating system I'm having issues with the client so I've decided it's about time to upgrade. My plan is to upgrade to the latest stable version 5.0.2. I'm concerned about upgrading the database tables. I'm using MySql. I know there is a script to upgrade the tables in my database but the comments in the script talk about upgrading from 3.0 to 5.0. Can I just run this script or should I download a previous version of bacula, say 3.0.x, and run that database table upgrade script first? Thanks for the help. Brian signature.asc Description: OpenPGP digital signature -- The Palm PDK Hot Apps Program offers developers who use the Plug-In Development Kit to bring their C/C++ apps to Palm for a share of $1 Million in cash or HP Products. Visit us here for more details: http://p.sf.net/sfu/dev2dev-palm___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Spooling
Dan Langille wrote: > Any failed jobs about that time? > Yes, but even with what was left in the spool directories the disk was nowhere near full, nor were the directories anywhere near the 100Gb mark. I've had it decide to start despooling at 60kB at times. Usually it's more like 5Mb to 8Gb. AB -- The Palm PDK Hot Apps Program offers developers who use the Plug-In Development Kit to bring their C/C++ apps to Palm for a share of $1 Million in cash or HP Products. Visit us here for more details: http://p.sf.net/sfu/dev2dev-palm ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] bacula confused about slots on autochanger
On 8/3/2010 9:20 PM, Maria McKinley wrote: > It seems that part of the problem I have been having with backup is that > bacula is having communication problems with the autochanger. Bacula > tells the autochanger to load slot 3, but instead slot 2 is loaded: On some systems, (BSD?) slot numbers are expected to begin at zero. Bacula (and Linux) expect slot numbers to begin at one. When Bacula sends a command to the autochanger to load slot 1, it is expecting the first slot to be loaded. But on systems that number from zero, when you use mtx to load slot 1 it will actually load the second slot. This can be worked around by changing your autochanger script to subtract 1 from the slot number on a load command and add 1 to slot numbers for the loaded and list commands. > *messages > 03-Aug 18:14 billie-sd JobId 1728: 3301 Issuing autochanger "loaded? > drive 0" command. > 03-Aug 18:14 billie-sd JobId 1728: 3302 Autochanger "loaded? drive 0", > result: nothing loaded. > 03-Aug 18:14 billie-sd JobId 1728: 3304 Issuing autochanger "load slot > 3, drive 0" command. > * > 03-Aug 18:15 billie-sd JobId 1728: 3305 Autochanger "load slot 3, drive > 0", status is OK. > * > 03-Aug 18:15 billie-sd JobId 1728: Warning: Director wanted Volume > "A005". > Current Volume "B005" not acceptable because: > 1998 Volume "B005" status is Full, not in Pool. > 03-Aug 18:15 billie-sd JobId 1728: Please mount Volume "A005" or > label a new one for: > Job: NightlySave.2010-08-01_01.05.00.32 > Storage: "Drive-1" (/dev/nst0) > Pool: Daily > Media type: VXA-2 > *exit > billie:~# mtx -f /dev/sg2 status > Storage Changer /dev/sg2:1 Drives, 10 Slots ( 0 Import/Export ) > Data Transfer Element 0:Full (Storage Element 2 Loaded):VolumeTag = > B005 > Storage Element 1:Full :VolumeTag=A006 > > Storage Element 2:Empty:VolumeTag= > > Storage Element 3:Full :VolumeTag=A005 > > Storage Element 4:Full :VolumeTag=A004 > > Storage Element 5:Full :VolumeTag=B004 > > Storage Element 6:Full :VolumeTag=C005 > > Storage Element 7:Full :VolumeTag=A007 > > Storage Element 8:Full :VolumeTag=C006 > > Storage Element 9:Full :VolumeTag=A010 > > Storage Element 10:Full :VolumeTag=CLNA0001 > > Any ideas what is going on or how to fix it? > > thanks, > maria > > -- > The Palm PDK Hot Apps Program offers developers who use the > Plug-In Development Kit to bring their C/C++ apps to Palm for a share > of $1 Million in cash or HP Products. Visit us here for more details: > http://p.sf.net/sfu/dev2dev-palm > ___ > Bacula-users mailing list > Bacula-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/bacula-users -- The Palm PDK Hot Apps Program offers developers who use the Plug-In Development Kit to bring their C/C++ apps to Palm for a share of $1 Million in cash or HP Products. Visit us here for more details: http://p.sf.net/sfu/dev2dev-palm ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Bacula Autochanger Questions
> It is not correct to manually label tapes in an autochanger if you > have one that has a barcode reader. With a barcode reader you issue > label barcodes from the console after you issue update slots. For the > label barcodes I put all new volumes in the Scratch pool. > Hi drescherjm Thanks for the advice. I manually labelled the tapes after having exhausted all options (at least the options I could think of), the barcode labelling didn't work either after several attempts so safe to assume the tapes do not have any codes? What is the best course of action now, I would really like the tape rotations going on a daily basis. How does my config look, is there something I need to add to it (I am sure there would be some, wish I could figure out what). Thanks & Regards +-- |This was sent by s...@logicscope.com via Backup Central. |Forward SPAM to ab...@backupcentral.com. +-- -- The Palm PDK Hot Apps Program offers developers who use the Plug-In Development Kit to bring their C/C++ apps to Palm for a share of $1 Million in cash or HP Products. Visit us here for more details: http://p.sf.net/sfu/dev2dev-palm ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Fwd: Problem with Volumes
-- Forwarded message -- From: John Drescher Date: Wed, Aug 4, 2010 at 8:50 AM Subject: Re: [Bacula-users] Problem with Volumes To: Carlo Filippetto On Wed, Aug 4, 2010 at 8:46 AM, Carlo Filippetto wrote: > AZZZ > I create the volumes and late I add thje 'Duration'!!! > > thank's very mutch!! > > now what I have to do?? > http://old.nabble.com/Re:-How-does-a-change-to-Volume-Use-Duration-take-effect--p15765197.html John -- John M. Drescher -- The Palm PDK Hot Apps Program offers developers who use the Plug-In Development Kit to bring their C/C++ apps to Palm for a share of $1 Million in cash or HP Products. Visit us here for more details: http://p.sf.net/sfu/dev2dev-palm ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Bacula Autochanger Questions
> Thanks for your prompt response. I looked at the link you just provided when > I was setting up Bacula. Just a bit more information, when I was labelling > the volumes, Bacula was not auto-labelling any of the tapes so I had to > simulate the barcodes by following the steps in "Simulating Barcodes in your > Autochanger" in the link you provided. My volumes are listed as Volume1, > Volume2, Volume3 ... Volume8 now. Please forgive my ignorance on the subject, > because I could write to a specific volume I assume labelling this way is > correct? > It is not correct to manually label tapes in an autochanger if you have one that has a barcode reader. With a barcode reader you issue label barcodes from the console after you issue update slots. For the label barcodes I put all new volumes in the Scratch pool. John -- The Palm PDK Hot Apps Program offers developers who use the Plug-In Development Kit to bring their C/C++ apps to Palm for a share of $1 Million in cash or HP Products. Visit us here for more details: http://p.sf.net/sfu/dev2dev-palm ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Bacula Autochanger Questions
Hi rory Thanks for your prompt response. I looked at the link you just provided when I was setting up Bacula. Just a bit more information, when I was labelling the volumes, Bacula was not auto-labelling any of the tapes so I had to simulate the barcodes by following the steps in "Simulating Barcodes in your Autochanger" in the link you provided. My volumes are listed as Volume1, Volume2, Volume3 ... Volume8 now. Please forgive my ignorance on the subject, because I could write to a specific volume I assume labelling this way is correct? I am not really getting any changer command errors I suspect I have missed something in the bacula-dir.conf file (perhaps the volume retention period?). Following is my configuration (mostly modified the default bacula-dir.conf) # # Default Bacula Director Configuration file # # The only thing that MUST be changed is to add one or more # file or directory names in the Include directive of the # FileSet resource. # # For Bacula release 5.0.1 (24 February 2010) -- redhat # # You might also want to change the default email address # from root to your address. See the "mail" and "operator" # directives in the Messages resource. # Director { # define myself Name = v-dir DIRport = 9101 # where we listen for UA connections QueryFile = "/etc/bacula/query.sql" WorkingDirectory = "/var/bacula" PidDirectory = "/var/run" Maximum Concurrent Jobs = 1 Password = "" # Console password Messages = Daemon } JobDefs { Name = "DefaultJob" Type = Backup Level = Incremental Client = v-fd FileSet = "Full Set" Schedule = "WeeklyCycle" Storage = File Messages = Standard Pool = File Priority = 10 Write Bootstrap = "/var/bacula/%c.bsr" } # # Define the main nightly save backup job # By default, this job will back up to disk in /tmp Job { Name = "BackupClient1" JobDefs = "DefaultJob" } # Backup the catalog database (after the nightly save) Job { Name = "BackupCatalog" JobDefs = "DefaultJob" Level = Full FileSet="Catalog" Schedule = "WeeklyCycleAfterBackup" # This creates an ASCII copy of the catalog # Arguments to make_catalog_backup.pl are: # make_catalog_backup.pl RunBeforeJob = "/etc/bacula/make_catalog_backup.pl MyCatalog" # This deletes the copy of the catalog RunAfterJob = "/etc/bacula/delete_catalog_backup" Write Bootstrap = "/var/bacula/%n.bsr" Priority = 11 # run after main backup } # # Standard Restore template, to be changed by Console program # Only one such job is needed for all Jobs/Clients/Storage ... # Job { Name = "RestoreFiles" Type = Restore Client=v-fd FileSet="Full Set" Storage = File Pool = Default Messages = Standard Where = /tmp/bacula-restores } # List of files to be backed up FileSet { Name = "Full Set" Include { Options { signature = MD5 } # Put your list of files here, preceded by 'File =', one per line # or include an external list with: # # File = \" -s \"Bacula: %t %e of %c %l\" %r" operatorcommand = "/usr/sbin/bsmtp -h localhost -f \"\(Bacula\) \<%r\>\" -s \"Bacula: Intervention needed for %j\" %r" mail = r...@localhost = all, !skipped operator = r...@localhost = mount console = all, !skipped, !saved # # WARNING! the following will create a file that you must cycle from # time to time as it will grow indefinitely. However, it will # also keep all your messages if they scroll off the console. # append = "/var/bacula/log" = all, !skipped catalog = all } # # Message delivery for daemon messages (no job). Messages { Name = Daemon mailcommand = "/usr/sbin/bsmtp -h localhost -f \"\(Bacula\) \<%r\>\" -s \"Bacula daemon message\" %r" mail = r...@localhost = all, !skipped console = all, !skipped, !saved append = "/var/bacula/log" = all, !skipped } # Default pool definition Pool { Name = Default Pool Type = Backup Recycle = yes # Bacula can automatically recycle Volumes AutoPrune = yes # Prune expired volumes Volume Retention = 365 days # one year } # File Pool definition Pool { Name = File Pool Type = Backup Recycle = yes # Bacula can automatically recycle Volumes AutoPrune = yes # Prune expired volumes Volume Retention = 365 days # one year Maximum Volume Bytes = 50G # Limit Volume size to something reasonable Maximum Volumes = 100 # Limit number of Volumes in Pool } # Scratch pool definition Pool { Name = Scratch Pool Type = Backup } # # Restricted console used by tray-monitor to get the status of the director # Console { Name = v-mon Password = "" CommandACL = status, .status } # Define job for v Job { Name = "v" Type = Backup Client = v-fd FileSet = "V" S
Re: [Bacula-users] bacula confused about slots on autochanger
On Tue, Aug 3, 2010 at 9:20 PM, Maria McKinley wrote: > It seems that part of the problem I have been having with backup is that > bacula is having communication problems with the autochanger. Bacula > tells the autochanger to load slot 3, but instead slot 2 is loaded: > > *messages > 03-Aug 18:14 billie-sd JobId 1728: 3301 Issuing autochanger "loaded? > drive 0" command. > 03-Aug 18:14 billie-sd JobId 1728: 3302 Autochanger "loaded? drive 0", > result: nothing loaded. > 03-Aug 18:14 billie-sd JobId 1728: 3304 Issuing autochanger "load slot > 3, drive 0" command. > * > 03-Aug 18:15 billie-sd JobId 1728: 3305 Autochanger "load slot 3, drive > 0", status is OK. > * > 03-Aug 18:15 billie-sd JobId 1728: Warning: Director wanted Volume > "A005". > Current Volume "B005" not acceptable because: > 1998 Volume "B005" status is Full, not in Pool. > 03-Aug 18:15 billie-sd JobId 1728: Please mount Volume "A005" or > label a new one for: > Job: NightlySave.2010-08-01_01.05.00.32 > Storage: "Drive-1" (/dev/nst0) > Pool: Daily > Media type: VXA-2 > *exit > billie:~# mtx -f /dev/sg2 status > Storage Changer /dev/sg2:1 Drives, 10 Slots ( 0 Import/Export ) > Data Transfer Element 0:Full (Storage Element 2 Loaded):VolumeTag = > B005 > Storage Element 1:Full :VolumeTag=A006 > > Storage Element 2:Empty:VolumeTag= > > Storage Element 3:Full :VolumeTag=A005 > > Storage Element 4:Full :VolumeTag=A004 > > Storage Element 5:Full :VolumeTag=B004 > > Storage Element 6:Full :VolumeTag=C005 > > Storage Element 7:Full :VolumeTag=A007 > > Storage Element 8:Full :VolumeTag=C006 > > Storage Element 9:Full :VolumeTag=A010 > > Storage Element 10:Full :VolumeTag=CLNA0001 > > Any ideas what is going on or how to fix it? > You probably need to edit mtx-changer to get it to do the right thing. Did you specify that you have a vxa changer in your mtx-changer.conf? John -- The Palm PDK Hot Apps Program offers developers who use the Plug-In Development Kit to bring their C/C++ apps to Palm for a share of $1 Million in cash or HP Products. Visit us here for more details: http://p.sf.net/sfu/dev2dev-palm ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Problem with Volumes
On Wed, Aug 4, 2010 at 3:51 AM, Carlo Filippetto wrote: > The problem is that! > > I have head made 5 volumes, I don't let Bacula to create them, I wold like > that every single volume contains only a 'daily' backup... In this > installation I have only 12 client, and I want that all the backup of this > night will go into that single volumes... > > The retention period is for recicle the volumes, I create 5 volumes to cover > from monday to wednesday, in the week-and will run the weekly jobs. The > retention is to let the volume recicle the next week > > > I tried to use > Volume Use Duration = 23h > but it don't work as I would like... > > > > In this page > http://www.bacula.org/fr/dev-manual/Basic_Volume_Management.html#DiskChapter > I can read this: > - > > Pool { > Name = File > Pool Type = Backup > Volume Use Duration = 23h > } > > then if you run a backup once a day (every 24 hours), Bacula will use a new > Volume for each backup, because each Volume it writes can only be used for > 23 hours after the first write > - > > > Wh it don't work for me? > Did you change the pool definition after you added the volumes? Did you change bacula-dir.conf without issuing the reload command in a bacula console? John -- The Palm PDK Hot Apps Program offers developers who use the Plug-In Development Kit to bring their C/C++ apps to Palm for a share of $1 Million in cash or HP Products. Visit us here for more details: http://p.sf.net/sfu/dev2dev-palm ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Bacula Autochanger Questions
On 04/08/10, sid009 (bacula-fo...@backupcentral.com) wrote: > I am new to Bacula and an average Linux user. I am trying to setup > Bacula to work with our HP LTO4 Autochanger (7 slots + 1 mail slot). I > have managed to label all the tapes and I can see all the volumes > listed via bconsole. The problem I am having is Auto-rotating the > tapes. Right now when a tape gets filled all the jobs either go into a > pending state or fail. Have you looked through the resource here?: http://www.bacula.org/manuals/en/concepts/concepts/Autochanger_Resource.html If so is the changer command failing? -- Rory Campbell-Lange r...@campbell-lange.net -- The Palm PDK Hot Apps Program offers developers who use the Plug-In Development Kit to bring their C/C++ apps to Palm for a share of $1 Million in cash or HP Products. Visit us here for more details: http://p.sf.net/sfu/dev2dev-palm ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Bacula Autochanger Questions
Hi Guys, I am new to Bacula and an average Linux user. I am trying to setup Bacula to work with our HP LTO4 Autochanger (7 slots + 1 mail slot). I have managed to label all the tapes and I can see all the volumes listed via bconsole. The problem I am having is Auto-rotating the tapes. Right now when a tape gets filled all the jobs either go into a pending state or fail. Ideally I would want a tape to be used per day (so 5 tapes for Monday - Friday) using incremental backups and a full backup on Saturday. After every successful back up I want the tape to be ejected to the mail slot to be take off site. Does anyone have any example configurations that I could use. Do I need to provide my bacula-dir.conf here? I have been struggling to make this work for weeks any help would be appreciated. Thanks +-- |This was sent by s...@logicscope.com via Backup Central. |Forward SPAM to ab...@backupcentral.com. +-- -- The Palm PDK Hot Apps Program offers developers who use the Plug-In Development Kit to bring their C/C++ apps to Palm for a share of $1 Million in cash or HP Products. Visit us here for more details: http://p.sf.net/sfu/dev2dev-palm ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Bacula + Postgres : copy batch problem
On 04/08/10, Dan Langille (d...@langille.org) wrote: > I think stored procedures would be a good idea. That way, we could > improve the functionality without changing the application. > > That said, we do not at present use stored procedures. We'd have to > proceed carefully. Fair enough. Can restores run off marked columns in database tables? This exercise could be taken out of the main core of Bacula into a little Django app (perhaps) and not affect the main body of Bacula at all except for some way of executing restores. -- Rory Campbell-Lange r...@campbell-lange.net -- The Palm PDK Hot Apps Program offers developers who use the Plug-In Development Kit to bring their C/C++ apps to Palm for a share of $1 Million in cash or HP Products. Visit us here for more details: http://p.sf.net/sfu/dev2dev-palm ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] DisktoCatalog difference verification
> On Wed, 4 Aug 2010 11:12:14 +0800, Ceejay Cervantes said: > > I'm using Bacula 5.0.2 on CentOS 5.5. I've created a DisktoCatalog level > verify job as a way to check things. I'm getting the warning below even > though they are on disk: > > Warning: The following files are in the Catalog but not on disk: > /usr/ > /var/ > /var/log/ > /var/log/audit/ > /home/ > /boot/ > ... > I tried listing files of the job using the bconsole and I saw two > entries of "/usr" and the rest mentioned on the warning. Is it safe to > ignore the warning or can it be removed? Are these mountpoints? If so, you can safely ignore the warnings because the directories are listed in the FileSet. I suggest reporting the warnings as a bug (see http://www.bacula.org/en/?page=bugs). __Martin -- The Palm PDK Hot Apps Program offers developers who use the Plug-In Development Kit to bring their C/C++ apps to Palm for a share of $1 Million in cash or HP Products. Visit us here for more details: http://p.sf.net/sfu/dev2dev-palm ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Bacula + Postgres : copy batch problem
On 8/4/2010 6:28 AM, Rory Campbell-Lange wrote: > On 03/08/10, Dan Langille (d...@langille.org) wrote: >> On 8/3/2010 7:09 PM, Rory Campbell-Lange wrote: > >>> Yes, a batch insert is faster than a specfic insert, but the latter >>> should be done at the "written-to-tape" transaction time, and could be >>> done asynchronously, but in a transaction. >> >> So... don't use batch-insert. Go the single insert approach. I dare >> you. ;) > > Yes, I'm trying! I'm trying to do it properly by recompiling debian > stable backports and I'm running into library dependancy problems. > >>> This is a cludge (with an inefficient correlated subquery!) that could >>> easily miss paths which exist from previous, unrelated backups. A >>> continuous insert process against a job and mediaid simply wouldn't need >>> to do this. > >> If you want to patch it, we'll certainly look at it. > > I'll look at some of the post batch insert queries and look to optimise > them somewhat with our database development team in the next month. > >>> More native support for postgres would also allow, for instance, faster >>> and more powerful searching of catalogues for retrieves, rather than the >>> strange restore procedure required through bconsole. > >> Sure, it would. We're always looking for more people to take on the >> heavy lifting. > > Would it be helpful if we developed some proof-of-concept plpgsql > functions for searching catalogues? We could also do a bit of work on > UTF8 conversion/support. I think stored procedures would be a good idea. That way, we could improve the functionality without changing the application. That said, we do not at present use stored procedures. We'd have to proceed carefully. -- Dan Langille - http://langille.org/ -- The Palm PDK Hot Apps Program offers developers who use the Plug-In Development Kit to bring their C/C++ apps to Palm for a share of $1 Million in cash or HP Products. Visit us here for more details: http://p.sf.net/sfu/dev2dev-palm ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Bacula + Postgres : copy batch problem
On 04/08/10, Marc Cousin (cousinm...@gmail.com) wrote: > > Changes to one part of Bacula has to be compatible with all other parts > > of Bacula. For example, given that we support SQLite, PostgreSQL, and > > MySQL, we have to keep each in mind. Yes, it's a compromise. > Moreover, yes, PostgreSQL is a robust DB. Capable of doing very high end > transactionnal work. But that's not what bacula requires. Bacula requires > very high throughput (some of us have to insert 50 millions rows a day) Touche -- I've been thinking too much of my single server backing itself up. > > The running out of space is a PostgreSQL issue. > I wouldn't say that. I would say that configuring a 10GB /var for the > database filesystem when doing 7TB backups is the issue. Give it more > space and stop wasting time. > ... > I totally agree with Dan : try the insert mode. And don't forget to > post your results back. OK. > > > This is a cludge (with an inefficient correlated subquery!) that could > > > easily miss paths which exist from previous, unrelated backups. A > > > continuous insert process against a job and mediaid simply wouldn't need > > > to do this. > > > > If you want to patch it, we'll certainly look at it. > Yes, so what ? Do you propose doing a transaction for every file > backed up ? It is used as a data dump, because that is what the > catalog is (for the tape part). And we have to be fast when inserting > there, there are some configurations with hundreds of client > spooling??? not juste one backup. Fair enough. Thanks for your comments. Regards Rory -- Rory Campbell-Lange r...@campbell-lange.net -- The Palm PDK Hot Apps Program offers developers who use the Plug-In Development Kit to bring their C/C++ apps to Palm for a share of $1 Million in cash or HP Products. Visit us here for more details: http://p.sf.net/sfu/dev2dev-palm ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Bacula + Postgres : copy batch problem
On 03/08/10, Dan Langille (d...@langille.org) wrote: > On 8/3/2010 7:09 PM, Rory Campbell-Lange wrote: > > Yes, a batch insert is faster than a specfic insert, but the latter > > should be done at the "written-to-tape" transaction time, and could be > > done asynchronously, but in a transaction. > > So... don't use batch-insert. Go the single insert approach. I dare > you. ;) Yes, I'm trying! I'm trying to do it properly by recompiling debian stable backports and I'm running into library dependancy problems. > > This is a cludge (with an inefficient correlated subquery!) that could > > easily miss paths which exist from previous, unrelated backups. A > > continuous insert process against a job and mediaid simply wouldn't need > > to do this. > If you want to patch it, we'll certainly look at it. I'll look at some of the post batch insert queries and look to optimise them somewhat with our database development team in the next month. > > More native support for postgres would also allow, for instance, faster > > and more powerful searching of catalogues for retrieves, rather than the > > strange restore procedure required through bconsole. > Sure, it would. We're always looking for more people to take on the > heavy lifting. Would it be helpful if we developed some proof-of-concept plpgsql functions for searching catalogues? We could also do a bit of work on UTF8 conversion/support. Rory -- Rory Campbell-Lange r...@campbell-lange.net -- The Palm PDK Hot Apps Program offers developers who use the Plug-In Development Kit to bring their C/C++ apps to Palm for a share of $1 Million in cash or HP Products. Visit us here for more details: http://p.sf.net/sfu/dev2dev-palm ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Problem with Volumes
The problem is that! I have head made 5 volumes, I don't let Bacula to create them, I wold like that every single volume contains only a 'daily' backup... In this installation I have only 12 client, and I want that all the backup of this night will go into that single volumes... The retention period is for recicle the volumes, I create 5 volumes to cover from monday to wednesday, in the week-and will run the weekly jobs. The retention is to let the volume recicle the next week I tried to use Volume Use Duration = 23h but it don't work as I would like... In this page http://www.bacula.org/fr/dev-manual/Basic_Volume_Management.html#DiskChapter I can read this: - Pool { Name = File Pool Type = Backup Volume Use Duration = 23h } then if you run a backup once a day (every 24 hours), Bacula will use a new Volume for each backup, because each Volume it writes can only be used for 23 hours after the first write - Wh it don't work for me? Thak's --- Carlo Filippetto 2010/8/3 John Drescher > On Tue, Aug 3, 2010 at 9:55 AM, Carlo Filippetto > wrote: > > Here it is > > > > *list media pool=P-daily > > > > Automatically selected Catalog: MyCatalog > > Using Catalog "MyCatalog" > > > +-+--+---+-++--+--+-+--+---+---+-+ > > | MediaId | VolumeName | VolStatus | Enabled | VolBytes | > VolFiles | > > VolRetention | Recycle | Slot | InChanger | MediaType | LastWritten > > | > > > +-+--+---+-++--+--+-+--+---+---+-+ > > | 237 | V-daily-0001 | Recycle | 1 | 21,978,673,815 | > 5 > > | 518,400 | 1 |0 | 0 | File | 2010-07-23 > > 21:14:14 | > > | 238 | V-daily-0002 | Append| 1 | 52,987,139,269 | > 12 > > | 518,400 | 1 |0 | 0 | File | 2010-08-02 > > 21:41:19 | > > | 239 | V-daily-0003 | Append| 1 | 0 | > 0 > > | 518,400 | 1 |2 | 0 | File | -00-00 > > 00:00:00 | > > | 240 | V-daily-0004 | Append| 1 | 0 | > 0 > > | 518,400 | 1 |3 | 0 | File | -00-00 > > 00:00:00 | > > | 241 | V-daily-0005 | Append| 1 | 0 | > 0 > > | 518,400 | 1 |4 | 0 | File | -00-00 > > 00:00:00 | > > > +-+--+---+-++--+--+-+--+---+---+-+ > > > > Your volumes show a 6 day retention. However you have only used 2 > volumes so there is not much I can tell you at this point. > > John > -- The Palm PDK Hot Apps Program offers developers who use the Plug-In Development Kit to bring their C/C++ apps to Palm for a share of $1 Million in cash or HP Products. Visit us here for more details: http://p.sf.net/sfu/dev2dev-palm___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users