Re: [Bacula-users] one full backup of a job always fails
On Monday 14 September 2009 16:08:19 Alan Brown wrote: On Mon, 14 Sep 2009, Silver Salonen wrote: Hello. I've got a problem in Bacula 3.0.2 - one backup of a server always fails with error: JobId 14638: Fatal error: sql_create.c:806 Fill Filename table Query failed: INSERT INTO Filename (Name) SELECT a.Name FROM (SELECT DISTINCT Name FROM batch) AS a WHERE NOT EXISTS (SELECT Name FROM Filename AS f WHERE f.Name = a.Name): ERR=Got error 28 from storage engine Google search: Mysql error 28 http://www.mysql.com/news-and-events/newsletter/2003-10/a000249.html What is error 28 and how can I avoid it? Using the command line tool perror you can find out, what the error 28 means. perror 28 Error code 28: No space left on device If you get his error, you need to check all filesystems where MySQL operates. It may be single filesystem or as we recommend you can have datadir, tmpdir and log files split into dedicated filesystems. MySQL often creates temporary tables for some queries - most of them are placed in tmpdir, but some into database directory (e.g. ALTER TABLE). You must ensure, that there is enough free disk space available for MySQL Yes, I did see this by googling, but I really doubted the server was out of disk space - there are several gigabytes free for MySQL DB and /tmp ain't full either. So I just couldn't believe it :) But well, after googling a bit more I set --tmpdir=/usr/mysql_tmp for MySQL as /usr has much more free space. And it fixed it, so it was about /tmp after all. -- Silver -- Come build with us! The BlackBerryreg; Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9#45;12, 2009. Register now#33; http://p.sf.net/sfu/devconf ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Device FileStorage with MediaType File requested by DIR not found in SD Device resources.
Martin Simmons schrieb: What does status storage=File print, in particular the Device status part? The Device Status Part of status storage=File prints out the following: Device status: Device File (/data/backup) is not open. Device LTO-2 (/dev/nst0) is not open. Device LTO-3 (/dev/nst1) is not open. Maybe the SD read a different config file I think not, because in the init.d Script i have the following: daemon /usr/sbin/bacula-sd $2 ${SD_OPTIONS} -c /etc/bacula/bacula-sd.conf And this config is the correct, with the snipped that i have posted. After a reboot now all backup jobs have this error, but i don't have changed anything at the config since some days. (Because i have Input/Output Errors on Device LTO-3, but this is another Error but i think problem with the Tape Drive, and i think not Part of this Problem). Greetings Roger Meier -- Come build with us! The BlackBerryreg; Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9#45;12, 2009. Register now#33; http://p.sf.net/sfu/devconf ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Repeated job failures
Hi, On 15/09/2009 16:54, Alan Brown wrote: 2.4.4 (not able to update yet) I keep getting errors like this on update slots and incremental updates of the bacula-dir server Subject: Bacula: Admin Fatal Error of UpdateSlots.2009-09-13_12.30.43 Full 14-Sep 18:24 msslay-dir JobId 104670: Fatal error: sql_update.c:122 Update failed: affected_rows=0 for UPDATE Job SET JobStatus='R',Level='F',StartTime='2009-09-14 18:24:29',ClientId=10,JobTDate=1252949069,PoolId=0 WHERE JobId=104670 The immediate failure is because the number of affected rows is zero. I'm not sure what the underlying cause could be (apart from the fact that JobId 104670 is not in the Job table - pruning or a bug?) But I vaguely remember a discussion about zero lines changed on bacula-devel. Looking at the code the test that reports the failure has changed between 2.4.4 and now (it tests affected_rows 1 in the latest code). I don't know if the failure that you are seeing is a real problem or whether it is just a symptom of normal behaviour. For reference the appropriate bits of code are: tag 2.4.4 See line2 202-209 of sql.c http://bacula.git.sourceforge.net/git/gitweb.cgi?p=bacula/bacula;a=blob;f=bacula/src/cats/sql.c;h=99503f7c8bd9452e5f7316078a98b1d37d864f7a;hb=82e9ab55205674c9b394a58ceb781970a6be24c9 Head line 258 of http://bacula.git.sourceforge.net/git/gitweb.cgi?p=bacula/bacula;a=blob;f=bacula/src/cats/sql.c;h=49e9762010fb35ba1743c2396bf137613c67f740;hb=HEAD 14-Sep 18:24 msslay-dir JobId 104670: Warning: Error updating job record. sql_update.c:194 Update failed: affected_rows=0 for UPDATE Job SET JobStatus='f',EndTime='2009-09-14 18:24:29',ClientId=10,JobBytes=0,JobFiles=0,JobErrors=0,VolSessionId=0,VolSessionTime=0,PoolId=NULL,FileSetId=NULL,JobTDate=1252949069,RealEndTime='2009-09-14 18:24:29',PriorJobId=0 WHERE JobId=104670 Same here affected_rows = 0 too. Regards Richard Any ideas? Cpu appears fine and there are tens of Gb of spare space where Mysql and Bacula have their respective temp directories. AB -- Come build with us! The BlackBerryreg; Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9#45;12, 2009. Register now#33; http://p.sf.net/sfu/devconf ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users -- Come build with us! The BlackBerryreg; Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9#45;12, 2009. Register now#33; http://p.sf.net/sfu/devconf ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Repeated job failures
On Wed, 16 Sep 2009, Richard Mortimer wrote: The immediate failure is because the number of affected rows is zero. I'm not sure what the underlying cause could be (apart from the fact that JobId 104670 is not in the Job table - pruning or a bug?) More likely bug than pruning. It's being run by the scheduler and then failing almost immediately. But I vaguely remember a discussion about zero lines changed on bacula-devel. Looking at the code the test that reports the failure has changed between 2.4.4 and now (it tests affected_rows 1 in the latest code). This happens about 1 in 10 runs, so it's not consistent. It also happens more often than not on various incremental/diff backups of the bacula server and there is _always_ at least one changed file each run (logfiles) AB -- Come build with us! The BlackBerryreg; Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9#45;12, 2009. Register now#33; http://p.sf.net/sfu/devconf ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] one full backup of a job always fails
On Wed, 16 Sep 2009, Silver Salonen wrote: Yes, I did see this by googling, but I really doubted the server was out of disk space - there are several gigabytes free for MySQL DB and /tmp ain't full either. So I just couldn't believe it :) As you've discovered: It's surprising how big the temp files can get. -- Come build with us! The BlackBerryreg; Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9#45;12, 2009. Register now#33; http://p.sf.net/sfu/devconf ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] scheduling problem
I stand corrected. I finally got through the full backup, swapping volumes as soon as I could once they were requested but the following 2 nights bacula scheduled another full backup (when it should have been incremental). If anyone has suggestions, I'd appreciate hearing them. Thanks in advance, Roy Roy Kidder wrote: Hello all, I'm hoping someone can help me. I'm having an issue with a backup schedule on a new install of bacula. I have a scheduled defined as: Schedule { Name = Monthly Run = Full 1st fri at 23:05 Run = Incremental 2nd-5th fri at 23:05 Run = Incremental sat-thu at 23:05 } and a host which uses that schedule: JobDefs { Name = nutbuster-job Type = Backup Level = Incremental Client = nutbuster-fd FileSet = nutbuster-set Schedule = Monthly Storage = DLT-7000 Messages = Standard Pool = Default Priority = 10 } The DLT-7000 is a single drive, not a jukebox and the file set is large so a full backup spans several volumes. As such, when the full backup starts on the 1st Friday of the month, Saturday is spent swapping volumes and the backup is still running into Sunday. So, another backup is scheduled by the scheduler on Saturday as a Full not an Incremental. At least this is the behavior I've seen, and I'm assuming it's because of the tape swapping delay. Can anyone confirm that I'm correct or otherwise point me in the right direction? Thanks in advance, Roy -- Come build with us! The BlackBerryreg; Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9#45;12, 2009. Register now#33; http://p.sf.net/sfu/devconf ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users -- Come build with us! The BlackBerryreg; Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9#45;12, 2009. Register now#33; http://p.sf.net/sfu/devconf ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Fileset manipulation by job
Is it possible to manipulate the fileset based on the job? For example, a RunScript parameter has a %l to pass the Job Level on, can the fileset somehow be manipulated like this as well? Thanks, jlc -- Come build with us! The BlackBerryreg; Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9#45;12, 2009. Register now#33; http://p.sf.net/sfu/devconf ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Creating a Volume on a tape times out
With lsscsi I never find a device for /dev/nst0 is why I went with /dev/sg0 is it possible bacula is expecting the latter and resolves it on its own somehow? This is the output from lsscsi -g [4:0:4:0]tapeHP Ultrium 4-SCSI W24W /dev/st0 /dev/sg0 [4:0:4:1]mediumx HP 1x8 G2 AUTOLDR 2.60 /dev/sch0 /dev/sg1 Is there something in the bacula manual on how to turn on logging in the mtx-changer script, how do I do that? This was very helpful thanks. Joe -Original Message- From: Mark Nienberg [mailto:gm...@tippingmar.com] Sent: Tuesday, September 15, 2009 12:12 PM To: bacula-users@lists.sourceforge.net Subject: Re: [Bacula-users] Creating a Volume on a tape times out Watson, Joe wrote: Trying to label the tapes I have with Label Barcodes on bconsole and it errors out every time. It times out every time I try labeling a volume on a tape. In the section: Device { Name = Ultrium 4-SCSI Look at the line: Archive Device = /dev/sg0 It is likely that it should be something like: Archive Device = /dev/nst0 If that isn't it, then enable logging for the mtx-changer script and see what the log file says about the failed load. You can test with mount and release, rather than attempting to label. -- Mark Nienberg Sent from an invalid address. Please reply to the group. -- Come build with us! The BlackBerryreg; Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9#45;12, 2009. Register now#33; http://p.sf.net/sfu/devconf ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users -- Come build with us! The BlackBerryreg; Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9#45;12, 2009. Register now#33; http://p.sf.net/sfu/devconf ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Creating a Volume on a tape times out
With lsscsi I never find a device for /dev/nst0 is why I went with /dev/sg0 is it possible bacula is expecting the latter and resolves it on its own somehow? This is the output from lsscsi -g [4:0:4:0]tapeHP Ultrium 4-SCSI W24W /dev/st0 /dev/sg0 [4:0:4:1]mediumx HP 1x8 G2 AUTOLDR 2.60 /dev/sch0 /dev/sg1 Is there something in the bacula manual on how to turn on logging in the mtx-changer script, how do I do that? This was very helpful thanks. Joe Ps sorry if this was twice sending this I got an undeliverable notice and didn't know if it got sent. -Original Message- From: Mark Nienberg [mailto:gm...@tippingmar.com] Sent: Tuesday, September 15, 2009 12:12 PM To: bacula-users@lists.sourceforge.net Subject: Re: [Bacula-users] Creating a Volume on a tape times out Watson, Joe wrote: Trying to label the tapes I have with Label Barcodes on bconsole and it errors out every time. It times out every time I try labeling a volume on a tape. In the section: Device { Name = Ultrium 4-SCSI Look at the line: Archive Device = /dev/sg0 It is likely that it should be something like: Archive Device = /dev/nst0 If that isn't it, then enable logging for the mtx-changer script and see what the log file says about the failed load. You can test with mount and release, rather than attempting to label. -- Mark Nienberg Sent from an invalid address. Please reply to the group. -- Come build with us! The BlackBerryreg; Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9#45;12, 2009. Register now#33; http://p.sf.net/sfu/devconf ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users -- Come build with us! The BlackBerryreg; Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9#45;12, 2009. Register now#33; http://p.sf.net/sfu/devconf ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Creating a Volume on a tape times out
Watson, Joe wrote: With lsscsi I never find a device for /dev/nst0 is why I went with /dev/sg0 is it possible bacula is expecting the latter and resolves it on its own somehow? This is the output from lsscsi -g [4:0:4:0]tapeHP Ultrium 4-SCSI W24W /dev/st0 /dev/sg0 [4:0:4:1]mediumx HP 1x8 G2 AUTOLDR 2.60 /dev/sch0 /dev/sg1 looks like your Ultrium uses /dev/st0 so try /dev/nst0 in your conf file. nst0 is the same as st0 except it does not rewind. Is there something in the bacula manual on how to turn on logging in the mtx-changer script, how do I do that? in recent versions of bacula, you set it in mtx-changer.conf in older versions you set it directly in the script (in your case /etc/bacula/scripts/mtx-changer) -- Mark Nienberg Sent from an invalid address. Please reply to the group. -- Come build with us! The BlackBerryreg; Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9#45;12, 2009. Register now#33; http://p.sf.net/sfu/devconf ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] quantum tape problems
hi i have a quantum LTO-4 drive connected via lsi sas hba (LSISAS1068E). Device { Name = LTO-4-Drive Description = QUANTUM LTO-4 Tape Drive Media Type = LTO-4 Archive Device = /dev/nst0 AutomaticMount = yes; # when device opened, read it AlwaysOpen = yes; RemovableMedia = yes; RandomAccess = no; Maximum File Size = 5GB Alert Command = sh -c 'smartctl -H -l error /dev/sg2' } tape drive basically works, i am running copy jobs from time to time using a script mt -f /dev/nst0 load ${BCONSOLE} EOT run job=CopyDiskToTape yes wait quit EOT mt -f /dev/nst0 eject problem: after tape is filled with 100-200GB (running above script 10-20 times successfully) copy jobs fail to write immediately after load and seeking to eof. tape is marked as full. btape test reports no problems btape rawfill writes about 800GB until end of tape is reached btape /dev/nst0 *rewind btape: btape.c:577 Rewound LTO-4-Drive (/dev/nst0) *cap Configured device capabilities: EOF BSR BSF FSR FSF FASTFSF !BSFATEOM EOM REM !RACCESS AUTOMOUNT ! LABEL !ANONVOLS ALWAYSOPEN MTIOCGET Device status: OPENED TAPE !LABEL !MALLOC APPEND !READ !EOT !WEOT !EOF !NEXTVOL !SHORT Device parameters: Device name: /dev/nst0 File=0 block=0 Min block=0 Max block=0 Status: Bacula status: file=0 block=0 Device status: BOT ONLINE IM_REP_EN file=0 block=0 btape: btape.c:2132 Device status: 645. ERR=block.c:1025 Read zero bytes at 4:0 on device LTO-4-Drive (/dev/nst0). maybe this ERR is a hint. someone using this tape drive successful on centos 5 ? any special device options needed ? thanks ulrich -- Come build with us! The BlackBerryreg; Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9#45;12, 2009. Register now#33; http://p.sf.net/sfu/devconf ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Creating a Volume on a tape times out
3995 Bad autochanger unload slot 2, drive 0: ERR=Child exited with code 1 Results=Unloading drive 0 into Storage Element 2...mtx: Request Sense: Long Report=yes mtx: Request Sense: Valid Residual=no mtx: Request Sense: Error Code=70 (Current) mtx: Request Sense: Sense Key=Illegal Request mtx: Request Sense: FileMark=no mtx: Request Sense: EOM=no mtx: Request Sense: ILI=no mtx: Request Sense: Additional Sense Code = 53 mtx: Request Sense: Additional Sense Qualifier = 03 mtx: Request Sense: BPV=no mtx: Req3301 Issuing autochanger loaded? drive 0 command. I get this when I try mounting it after I changed the tape to /dev/nst0 -Original Message- From: Mark Nienberg [mailto:gm...@tippingmar.com] Sent: Wednesday, September 16, 2009 12:55 PM To: bacula-users@lists.sourceforge.net Subject: Re: [Bacula-users] Creating a Volume on a tape times out Watson, Joe wrote: With lsscsi I never find a device for /dev/nst0 is why I went with /dev/sg0 is it possible bacula is expecting the latter and resolves it on its own somehow? This is the output from lsscsi -g [4:0:4:0]tapeHP Ultrium 4-SCSI W24W /dev/st0 /dev/sg0 [4:0:4:1]mediumx HP 1x8 G2 AUTOLDR 2.60 /dev/sch0 /dev/sg1 looks like your Ultrium uses /dev/st0 so try /dev/nst0 in your conf file. nst0 is the same as st0 except it does not rewind. Is there something in the bacula manual on how to turn on logging in the mtx-changer script, how do I do that? in recent versions of bacula, you set it in mtx-changer.conf in older versions you set it directly in the script (in your case /etc/bacula/scripts/mtx-changer) -- Mark Nienberg Sent from an invalid address. Please reply to the group. -- Come build with us! The BlackBerryreg; Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9#45;12, 2009. Register now#33; http://p.sf.net/sfu/devconf ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users -- Come build with us! The BlackBerryreg; Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9#45;12, 2009. Register now#33; http://p.sf.net/sfu/devconf ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Fileset manipulation by job
a RunScript parameter has a %l to pass the Job Level on Hey, that sounds interesting, I did note eaven know that, can you point me to the on line documentation where I could find more about that? Hannes, The area in the docs is under the Director Config Job Resource: http://www.bacula.org/3.0.x-manuals/en/install/install/Configuring_Director.html#SECTION0063 What I should have mentioned in my earlier email was that although bacula should be deciding what Job Level to perform, I had a special need that I resolved by changing the client script to make more sense. I'll keep an eye on how the next couple weeks go... Thanks, jlc -- Come build with us! The BlackBerryreg; Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9#45;12, 2009. Register now#33; http://p.sf.net/sfu/devconf ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Fileset manipulation by job
Juche Joseph, a RunScript parameter has a %l to pass the Job Level on Hey, that sounds interesting, I did note eaven know that, can you point me to the on line documentation where I could find more about that? Hannes -- Come build with us! The BlackBerryreg; Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9#45;12, 2009. Register now#33; http://p.sf.net/sfu/devconf ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Reports of saved files after a backup job
Hi people: Is it possible to send an email to some user containing the list of all files saved on a backup? The Messages resource only mentions notsaved files. Could someone point me to a possible solution for this? Thanks -- Come build with us! The BlackBerryreg; Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9#45;12, 2009. Register now#33; http://p.sf.net/sfu/devconf___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Restore only the contents of the last job
Hi all: I'm running Bacula 3.0.2 with a policy of 1 Full Backup per month and the rest of days Incremental backups. I'm pretending to offer some kind of archive acces to my end users like this: 1. Trough Samba publish the contents of user backups 2. Create a directory named with the current date that contains a backup of that day 3. Restore the backups of everyday on the directory corresponding with its date This would create something like this: /var/backups/mailserver/09-01-2009 (this contains a full backup. It should use around 100 MB) /var/backups/mailserver/09-02-2009 (this contains only the files of the incremental backup of that date. It should use around 5MB) /var/backups/mailserver/09-03-2009 (this contains only the files of the incremental backup of that date. It should use around 4MB) /var/backups/mailserver/09-04-2009 (this contains only the files of the incremental backup of that date. It should use around 6MB) I tought that I could just run restore jobs choosing a specific Job ID like this: * restore jobid=45 storage=FileDrive client=mailserver restore-client=samba-server regexwhere=!^!/var/backups/mailserver/DATE/! select all yes ... where: - 45 is the Job ID of an Incremental Backup (except the 1st day of a month that is a Full Backup) - samba-server is the target host of the restore backups (and the one that publishes the restores backups via Samba) OK, this works fine. I wrote a script that automatizes the procedure of restoring backups of everyday but I noted that Bacula is always choosing the last Full Backup (that is not what I want) and the specific incremental backup (this is right!). I would like that the procedure of restore an Incremental Backup not includes the last backup because this would not allow me to have published the files that changed everyday each of them inside its own directory. Is there a way to extract just the contents of an incremental backup but not the last full backup? I would want to restore all the directories structure necessary but only the files being restored from the incremental backup. I hope someone was able to understand me (Sorry, my english isn't good) and point me to a possible solution because I was reading a lot the documentation and searching around Google with no success. Thanks -- Come build with us! The BlackBerryreg; Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9#45;12, 2009. Register now#33; http://p.sf.net/sfu/devconf___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] upgade bacula from 1.38.11 to 2.4.4 brings Fatal error: Error getting Volume info: 1990 Invalid Catalog Request:
Hi, with all your informations, it seems you get the right package. It could be 2 things, a pb of right between the director and mysql. And trouble with right as bacula should run now director and sd as non root. Just check the /var/lib/bacula and dir where you store backup are owned by the bacula user. Next try to connect to mysql with bacula user to be sure the database doesn't reject connexion. ( it normally issue a error in this case ) su bacula; mysql bacula; mysqlselect * from Version; Otherwise, I don't have a idea ... Perharps starting daemon in foreground with some level of debug, would give more informations. Bartosz.C wrote: Just check if you have the right director ! Normally if the wrong ( using an empty sqlite db ) a list media should show empty dpkg -l | grep bacula ii bacula-common 2.4.4-1 network backup, recovery and verification - common support fil ii bacula-console2.4.4-1 network backup, recovery and verification - text console ii bacula-director-common2.4.4-1 network backup, recovery and verification - Director common fi ii bacula-director-mysql 2.4.4-1 network backup, recovery and verification - MySQL storage for ii bacula-fd 2.4.4-1 network backup, recovery and verification - file daemon ii bacula-sd 2.4.4-1 network backup, recovery and verification - storage daemon ii bacula-sd-mysql 2.4.4-1 network backup, recovery and verification - MySQL SD tools dpkg -l | grep mysql ii bacula-director-mysql 2.4.4-1 network backup, recovery and verification - MySQL storage for ii bacula-sd-mysql 2.4.4-1 network backup, recovery and verification - MySQL SD tools ii libdbd-mysql-perl 4.007-1 A Perl5 database interface to the MySQL database ii libmysqlclient15off 5.0.51a-24+lenny2MySQL database client library ii mysql-client-5.0 5.0.51a-24+lenny2MySQL database client binaries ii mysql-common 5.0.51a-24+lenny2MySQL database common files ii mysql-server 5.0.51a-24+lenny2MySQL database server (metapackage depending on the latest ver ii mysql-server-5.0 5.0.51a-24+lenny2MySQL database server binaries In etch-n-half distribution I had: dpkg -l | grep bacula ii bacula-common 1.38.11-8 Network backup, recovery and verification (C ii bacula-console 1.38.11-8 Network backup, recovery and verification (M ii bacula-director-common 1.38.11-8 Network backup, recovery and verification (D ii bacula-director-mysql 1.38.11-8 Network backup, recovery and verification (D ii bacula-fd 1.38.11-8 Network backup, recovery and verification (F It looks pretty the same like new one - except number of the versions. So your question confuse me now I really do not know, do I have a right bacula-director? :) Did you ensure that the database have been updated by the script a mysql sql select * from Version; should return 10 for a 2.4.4 version. No, the data base was not updated, I deleted it and created new one. I simply have changed distribution from etch-n-half to lenny so everything consider databases has been started from the beginning. And database is empty (or was empty since last Friday). Its really weird for me - cause all worked fine on previous version. (except bugs of course - which by the way help me to make decision to upgrade the backup system) I will be grateful for any clue. Bartosz. On Mon, Sep 14, 2009 at 5:06 PM, Bruno Friedmann br...@ioda-net.ch wrote: Hi Bartosz, Just two remarks, I've seen you are using the debian packages, and sometimes ago, another user have just made an update on this os. Result he was going from bacula-mysql to bacula-sqlite ... Just check if you have the right director ! Normally if the wrong ( using an empty sqlite db ) a list media should show empty ... Ok we admit you have the good director/mysql. Did you ensure that the database have been updated by the script a mysql sql select * from Version; should return 10 for a 2.4.4 version. If not, try to find the upgrade script update_bacula_tables normally in /usr/lib[64]/bacula Hope this help a bit Bartosz.C wrote: Hi, I have more or less working version of bacula 1.38.11 which looks like: pc1 - bacula-fd, bacula-console,bacula-director-mysql, mysql pc2 - bacula-sd pc5-10 - bacula-fd writing to pc2 pc3 - bacula-sd pc10-15 - bacula-fd writing to pc3 I decided to change it to 2.4.4 cause to many bugs in previous version and now it looks like