Re: [Bacula-users] HP MSL2024 Autochanger "ERR=Device or resource busy."
> Thanks Brian, I added this and it seems to indicate things are working > OK without adding any sleep, so I need to keep looking. > > The following is the sequence as I attempt to label a tape after having > deleted the Volume record, manually rewound the tape and done an "mt -f > /dev/nst0 weof" and placed it back in Slot 1. > > Start bacula. > Do a "status" on the SD: > > Device status: > Autochanger "HP_MSL2024" with devices: > "Drive-1" (/dev/nst0) > Device "Drive-1" (/dev/nst0) is not open. > Drive 0 status unknown. > > Do an "automount off" > Do a "label": > > Connecting to Storage daemon HP_MSL2024 at library1.sauce.co.nz:9103 ... > Sending label command for Volume "GQJ800L4" Slot 1 ... > 3301 Issuing autochanger "loaded? drive 0" command. > 3302 Autochanger "loaded? drive 0", result: nothing loaded. > 3304 Issuing autochanger "load slot 1, drive 0" command. > 3305 Autochanger "load slot 1, drive 0", status is OK. > block.c:1010 Read error on fd=5 at file:blk 0:0 on device "Drive-1" > (/dev/nst0). ERR=Device or resource busy. The read error is normal for a brand new tape. What is not not normal is the ERR=Device or resource busy Have you tried to stop bacula-sd and then execute the mtx-changer script directly from the shell? You will probably have to look at the code for the parameters. John -- This SF.Net email is sponsored by the Verizon Developer Community Take advantage of Verizon's best-in-class app development support A streamlined, 14 day to market process makes app distribution fast and easy Join now and get one step closer to millions of Verizon customers http://p.sf.net/sfu/verizon-dev2dev ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Backup Failed - Volume "daily-jan2010-2" not in catalogue.
On Fri, Jan 8, 2010 at 5:12 AM, stuartb wrote: > > Hi All, > > New to Bacula so please be gentle... > > I have set up a full backup system to run every night -> backing up to a Sony > AIT-3 tape system. > > So far everything seems to work, but I would like to run a tape log rotation > system (tape a tape home each night and replace with another tape, 3 in > total). > > However, after the first tape has been labeled and inserted into the > catalogue, attempting to insert a new tape, mount, label and then backup, > fails. > > The system fails with the following error: > > Current Volume "daily-jan2010-2" is not acceptable because: > 1997 Volume "daily-jan2010-2" not in catalog. > > Now I have searched Google for "bacula add new tape to catalog", and nothing > comes up even remotely close. > labeling puts a volume in the catalog. What version of bacula are you using? John -- This SF.Net email is sponsored by the Verizon Developer Community Take advantage of Verizon's best-in-class app development support A streamlined, 14 day to market process makes app distribution fast and easy Join now and get one step closer to millions of Verizon customers http://p.sf.net/sfu/verizon-dev2dev ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] HP MSL2024 Autochanger "ERR=Device or resource busy."
Brian Debelius wrote: > Try turning on debug in mtx-changer. Modify the wait_for_drive() > function to add another debug statement to confirm that the device is > ready, and that the function did not just time out. > > wait_for_drive() { > i=0 > while [ $i -le 300 ]; do # Wait max 300 seconds > if mt -f $1 status 2>&1 | grep "${ready}" >/dev/null 2>&1; then > -->> debug "Device $1 - READY!" > break > fi > debug "Device $1 - not ready, retrying..." > sleep 1 > i=`expr $i + 1` > done > } Thanks Brian, I added this and it seems to indicate things are working OK without adding any sleep, so I need to keep looking. The following is the sequence as I attempt to label a tape after having deleted the Volume record, manually rewound the tape and done an "mt -f /dev/nst0 weof" and placed it back in Slot 1. Start bacula. Do a "status" on the SD: Device status: Autochanger "HP_MSL2024" with devices: "Drive-1" (/dev/nst0) Device "Drive-1" (/dev/nst0) is not open. Drive 0 status unknown. Do an "automount off" Do a "label": Connecting to Storage daemon HP_MSL2024 at library1.sauce.co.nz:9103 ... Sending label command for Volume "GQJ800L4" Slot 1 ... 3301 Issuing autochanger "loaded? drive 0" command. 3302 Autochanger "loaded? drive 0", result: nothing loaded. 3304 Issuing autochanger "load slot 1, drive 0" command. 3305 Autochanger "load slot 1, drive 0", status is OK. block.c:1010 Read error on fd=5 at file:blk 0:0 on device "Drive-1" (/dev/nst0). ERR=Device or resource busy. 3000 OK label. VolBytes=1024 DVD=0 Volume="GQJ800L4" Device="Drive-1" (/dev/nst0) Catalog record for Volume "GQJ800L4", Slot 1 successfully created. Do not forget to mount the drive!!! Tailing the mtx.log showed the "Device /dev/nst0 - READY!" up at the same time as "3305" above then there was a pause of a few seconds, presumably as the tape threads up and then the "Read error" At this point another "status" on the SD: Device status: Autochanger "HP_MSL2024" with devices: "Drive-1" (/dev/nst0) Device "Drive-1" (/dev/nst0) is not open. Slot 1 is loaded in drive 0. I run "mt -f /dev/nst0 status" at this point with bacula still running: SCSI 2 tape drive: File number=1, block number=0, partition=0. Tape block size 0 bytes. Density code 0x46 (LTO-4). Soft error count since last status=0 General status bits on (8101): EOF ONLINE IM_REP_EN Do a "mount" and after about 20 seconds: block.c:1010 Read error on fd=5 at file:blk 0:0 on device "Drive-1" (/dev/nst0). ERR=Device or resource busy. 3902 Cannot mount Volume on Storage Device "Drive-1" (/dev/nst0) because: Requested Volume "" on "Drive-1" (/dev/nst0) is not a Bacula labeled Volume, because: ERR=block.c:1010 Read error on fd=5 at file:blk 0:0 on device "Drive-1" (/dev/nst0). ERR=Device or resource busy. 3905 Device "Drive-1" (/dev/nst0) open but no Bacula volume is mounted. If this is not a blank tape, try unmounting and remounting the Volume. Do a "status" on SD: Device status: Autochanger "HP_MSL2024" with devices: "Drive-1" (/dev/nst0) Device "Drive-1" (/dev/nst0) open but no Bacula volume is currently mounted. Slot 1 is loaded in drive 0. Total Bytes Read=0 Blocks Read=0 Bytes/block=0 Positioned at File=0 Block=0 Do an "mt -f /dev/nst0 status": /dev/nst0: Device or resource busy Which is fair, as bacula now has the device open. So I really do not know what the drive's problem is during the "label" - why is it busy? Regards, Richard -- This SF.Net email is sponsored by the Verizon Developer Community Take advantage of Verizon's best-in-class app development support A streamlined, 14 day to market process makes app distribution fast and easy Join now and get one step closer to millions of Verizon customers http://p.sf.net/sfu/verizon-dev2dev ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Backup Failed - Volume "daily-jan2010-2" not in catalogue.
Hi All, New to Bacula so please be gentle... I have set up a full backup system to run every night -> backing up to a Sony AIT-3 tape system. So far everything seems to work, but I would like to run a tape log rotation system (tape a tape home each night and replace with another tape, 3 in total). However, after the first tape has been labeled and inserted into the catalogue, attempting to insert a new tape, mount, label and then backup, fails. The system fails with the following error: Current Volume "daily-jan2010-2" is not acceptable because: 1997 Volume "daily-jan2010-2" not in catalog. Now I have searched Google for "bacula add new tape to catalog", and nothing comes up even remotely close. Hoping you can help! Many thanks, +-- |This was sent by stu...@buckhill.co.uk via Backup Central. |Forward SPAM to ab...@backupcentral.com. +-- -- This SF.Net email is sponsored by the Verizon Developer Community Take advantage of Verizon's best-in-class app development support A streamlined, 14 day to market process makes app distribution fast and easy Join now and get one step closer to millions of Verizon customers http://p.sf.net/sfu/verizon-dev2dev ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Fully Qualified Name?
I am setting up bacula at home and my network connection is a cable modem using dhcp. Up until now that hasn't been a problem. I really don't need to set up clients for now, I just want to experiement using bacula to backup the machine its installed on. I brought up webacula and when I try to select things I keep getting connection errors. The bacula ports are open, at least through the firewall gui on Fedora. Not absolutely sure though, since nmap map doesn't show them. So my quest is do I need a FQDM ? Thanks. greg -- This SF.Net email is sponsored by the Verizon Developer Community Take advantage of Verizon's best-in-class app development support A streamlined, 14 day to market process makes app distribution fast and easy Join now and get one step closer to millions of Verizon customers http://p.sf.net/sfu/verizon-dev2dev ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] [Bacula-devel] Bacula 3.0.3 deadlock : Job is waiting for execution
Hello Arno and Renaud, I can believe that there might be a bug in the lock manager software, but I am very surprised that it is turned on. It should only be turned on for developers, and thus though this patch may be correct (I don't think so, but Eric can answer more definitively), it should never be needed in a production system, and won't work in a production system because of the lock manager being turned off. Can you explain why the lock manager code is turned on? If this is a problem with a misconfigured mail daemon, then it is very likely that this problem has already shown up and has a very different solution. The problem I just mentioned is fixed in the current development version, and the workaround for version 3.0.x is to ensure that either email is turned off or you point to a valid smtp server. Regards, Kern On Friday 08 January 2010 21:32:18 Arno Lehmann wrote: > Hello, > > this is just forwarding your mail to bacula-devel, where it's more > likely to be picked up, looked at, and perhaps integrated into the > code base :-) > > Cheers, and thanks for not only analyzing the problem, but also > providing a possible fix! > > Arno > > 07.01.2010 16:34, Renaud Marquet wrote: > > Hi, > > > > I'm using bacula 3.0.3 and the director's job queue was stuck after > > running the first job. The others were waiting indefinitely for > > execution. If the director was restarted, I could run only one job, and > > so on. > > > > Googling around I found these 2 posts without satisfying anwsers : > > http://www.backupcentral.com/phpBB2/two-way-mirrors-of-external-mailing-l > >ists-3/bacula-25/upgrade-to-3-0-3-job-is-waiting-for-execution-102156/ > > http://www.backupcentral.com/phpBB2/two-way-mirrors-of-external-mailing-l > >ists-3/bacula-25/job-is-waiting-for-execuition-101508/ > > > > I then looked at the code and found there is a deadlock happening in > > message handling. > > > > The problem is located in close_msg(JCR *) function in message.c. When > > it encounters an error while sending an e-mail, it calls the macro Jmsg1 > > (line 485) to report it. This macro calls dispatch_message, which tries > > to acquire fides_mutex (line 738). Unfortunatly, this mutex was already > > acquired in close_msg (line 431), thus resulting in a deadlock (as > > stated in mutex documentation for PTHREAD_MUTEX_INITIALIZER kind). > > > > This problem was affecting me because mail daemon was not properly > > configured on my server. > > > > It could be interesting to review these parts of the code to avoid such > > situation. > > > > However I wrote a quick patch for lockmgr.c which simply upgrades > > mutexes to PTHREAD_MUTEX_ERRORCHECK_NP kind and resolves this error. > > > > Hope this would help someone, > > Renaud > > > > patch : > > > > diff -rupN bacula-3.0.3.vanilla/src/lib/lockmgr.c > > bacula-3.0.3.patched/src/lib/lockmgr.c > > --- bacula-3.0.3.vanilla/src/lib/lockmgr.c 2009-10-18 11:10:16.0 > > +0200 > > +++ bacula-3.0.3.patched/src/lib/lockmgr.c 2009-12-31 18:05:59.0 > > +0100 > > @@ -616,6 +616,15 @@ void lmgr_cleanup_main() > > */ > > int lmgr_mutex_lock(pthread_mutex_t *m, const char *file, int line) > > { > > + /* Patch to avoid deadlock if mutex is locked more than once */ > > + /* There's some performance hit which makes it probably not > > acceptable */ > > + /* for large system usage. */ > > + if(*m == PTHREAD_MUTEX_INITIALIZER) { > > + pthread_mutexattr_t attr; > > + pthread_mutexattr_settype( &attr, PTHREAD_MUTEX_ERRORCHECK_NP ); > > + pthread_mutex_init( m, &attr ); > > + } > > + > > int ret; > > lmgr_thread_t *self = lmgr_get_thread_info(); > > self->pre_P(m, file, line); > > > > > > > > - > >- This SF.Net email is sponsored by the Verizon Developer Community > > Take advantage of Verizon's best-in-class app development support A > > streamlined, 14 day to market process makes app distribution fast and > > easy Join now and get one step closer to millions of Verizon customers > > http://p.sf.net/sfu/verizon-dev2dev > > ___ > > Bacula-users mailing list > > Bacula-users@lists.sourceforge.net > > https://lists.sourceforge.net/lists/listinfo/bacula-users -- This SF.Net email is sponsored by the Verizon Developer Community Take advantage of Verizon's best-in-class app development support A streamlined, 14 day to market process makes app distribution fast and easy Join now and get one step closer to millions of Verizon customers http://p.sf.net/sfu/verizon-dev2dev ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Is a Verify Job reliable on Windows ?
> On Thu, 7 Jan 2010 21:29:55 +0100, Guillaume Laurès said: > > Hello fellow bacula users, > > I ran on a small issue today, using a Verify Job for the first time. > I backed up 6000+ files, around 55 Gb (a Windows whole drive). Then I > changed the letter of the drive, and restored all the files on a new > partition under the original letter. Restore went okay, except for a > minor a file number discrepancy (mark * "trap" ?). > I need to wipe the original partition, and I don't remember if the > restore job does a SHA1 check after restore against the Catalog, so I > wanted to do one by myself before erasing the original data. > Strangely enough running a Verify Job shows SHA1 differences for > around 50 files :-( > The oddity is that when I check-summed an original big zip file > against the restored one with the file checksum utility from > Microsoft, I found the very same SHA1 sig for both files. Note that > this one is far from being equal to either one Bacula reports for this > zip file... Some very small text files containing SHA1/MD5 cheksums > where reported incorrect too, whereas they are indeed identical. > > Setup : > - server is Ubuntu 8.04.3 LTS backup, with 3.0.3 installed from > sources, virtualized in ESXi 3.5 (yes, I ran btape tests for several > hours, ran fine albeit slower than drive official speed) > - client is Windows 2003 Server 32bit, with 3.0.3a installed from the > sourceforge binary > - device is DLT-7000 with hardware compression turned off. > > Fileset used to backup : > FileSet { >Name = "Donnees serveur" >Include { > Options { >Signature = SHA1 >Compression = GZIP6 > } > File = "E:/" >} > } > > The one used for the Verify Job (w/ Type = Disk to Catalog) just adds > "Verify = pinsug1" in the options under Compression. > > Any idea why Bacula thinks it's wrong whereas it's not ? I think the checksum includes everything returned by the BackupRead function on Windows, so possible something is slightly different in the meta data. __Martin -- This SF.Net email is sponsored by the Verizon Developer Community Take advantage of Verizon's best-in-class app development support A streamlined, 14 day to market process makes app distribution fast and easy Join now and get one step closer to millions of Verizon customers http://p.sf.net/sfu/verizon-dev2dev ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Bacula 3.0.3 deadlock : Job is waiting for execution
Hello, this is just forwarding your mail to bacula-devel, where it's more likely to be picked up, looked at, and perhaps integrated into the code base :-) Cheers, and thanks for not only analyzing the problem, but also providing a possible fix! Arno 07.01.2010 16:34, Renaud Marquet wrote: > Hi, > > I'm using bacula 3.0.3 and the director's job queue was stuck after > running the first job. The others were waiting indefinitely for > execution. If the director was restarted, I could run only one job, and > so on. > > Googling around I found these 2 posts without satisfying anwsers : > http://www.backupcentral.com/phpBB2/two-way-mirrors-of-external-mailing-lists-3/bacula-25/upgrade-to-3-0-3-job-is-waiting-for-execution-102156/ > http://www.backupcentral.com/phpBB2/two-way-mirrors-of-external-mailing-lists-3/bacula-25/job-is-waiting-for-execuition-101508/ > > I then looked at the code and found there is a deadlock happening in > message handling. > > The problem is located in close_msg(JCR *) function in message.c. When > it encounters an error while sending an e-mail, it calls the macro Jmsg1 > (line 485) to report it. This macro calls dispatch_message, which tries > to acquire fides_mutex (line 738). Unfortunatly, this mutex was already > acquired in close_msg (line 431), thus resulting in a deadlock (as > stated in mutex documentation for PTHREAD_MUTEX_INITIALIZER kind). > > This problem was affecting me because mail daemon was not properly > configured on my server. > > It could be interesting to review these parts of the code to avoid such > situation. > > However I wrote a quick patch for lockmgr.c which simply upgrades > mutexes to PTHREAD_MUTEX_ERRORCHECK_NP kind and resolves this error. > > Hope this would help someone, > Renaud > > patch : > > diff -rupN bacula-3.0.3.vanilla/src/lib/lockmgr.c > bacula-3.0.3.patched/src/lib/lockmgr.c > --- bacula-3.0.3.vanilla/src/lib/lockmgr.c2009-10-18 11:10:16.0 > +0200 > +++ bacula-3.0.3.patched/src/lib/lockmgr.c2009-12-31 18:05:59.0 > +0100 > @@ -616,6 +616,15 @@ void lmgr_cleanup_main() > */ > int lmgr_mutex_lock(pthread_mutex_t *m, const char *file, int line) > { > + /* Patch to avoid deadlock if mutex is locked more than once */ > + /* There's some performance hit which makes it probably not > acceptable */ > + /* for large system usage. */ > + if(*m == PTHREAD_MUTEX_INITIALIZER) { > + pthread_mutexattr_t attr; > + pthread_mutexattr_settype( &attr, PTHREAD_MUTEX_ERRORCHECK_NP ); > + pthread_mutex_init( m, &attr ); > + } > + > int ret; > lmgr_thread_t *self = lmgr_get_thread_info(); > self->pre_P(m, file, line); > > > > -- > This SF.Net email is sponsored by the Verizon Developer Community > Take advantage of Verizon's best-in-class app development support > A streamlined, 14 day to market process makes app distribution fast and easy > Join now and get one step closer to millions of Verizon customers > http://p.sf.net/sfu/verizon-dev2dev > ___ > Bacula-users mailing list > Bacula-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/bacula-users > -- Arno Lehmann IT-Service Lehmann Sandstr. 6, 49080 Osnabrück www.its-lehmann.de -- This SF.Net email is sponsored by the Verizon Developer Community Take advantage of Verizon's best-in-class app development support A streamlined, 14 day to market process makes app distribution fast and easy Join now and get one step closer to millions of Verizon customers http://p.sf.net/sfu/verizon-dev2dev ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] LTO3 tape capacity lower than expected
Wow. Since setting the Maximum Block Size to 262144, and the Maximum File Size to 4G, I am now getting 35MB/s which is up from 15-18MB/s. Now I am not spooling, these are copy jobs, so I don't know if this makes a difference. On 1/7/2010 4:46 PM, Jesper Krogh wrote: > 05-Jan 00:37 bacula-sd JobId 33734: Despooling elapsed time = 00:00:58, > Transfer rate = 172.4 M bytes/second > > On LTO3 tapes in the LTO4 drive it tops at around 120MB/s. > > -- This SF.Net email is sponsored by the Verizon Developer Community Take advantage of Verizon's best-in-class app development support A streamlined, 14 day to market process makes app distribution fast and easy Join now and get one step closer to millions of Verizon customers http://p.sf.net/sfu/verizon-dev2dev ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Windows XP encryption and Bacula
On 01/08/10 09:13, Brian C. Huffman wrote: > All, > > I'm having trouble backing up a Windows XP machine that has a directory > (and everything below it) selected for encryption (properties on the > directory). I'm getting "ERR=Access is denied" for the files. It's > confusing, b/c it's still reading the full directory structure and > encryption shouldn't stop "reading" of the file, only decrypting would > be an issue. > > The server is running 2.4.2 and the client is also running a 2.4 version > (may be higher minor rev). > > Does anyone have any experience with this sort of situation or thoughts? > I could be wrong, but afaik reading a file that is "encrypted" using Windows' built-in folder&file encryption reuires that windows decrypts the file upon reading. Furthermore, if the bacula-fd service is running as a different user than the user who has encrypted the file, it will not be able to access it. This is probably why you are seeing "Access is denied". -- This SF.Net email is sponsored by the Verizon Developer Community Take advantage of Verizon's best-in-class app development support A streamlined, 14 day to market process makes app distribution fast and easy Join now and get one step closer to millions of Verizon customers http://p.sf.net/sfu/verizon-dev2dev ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Windows XP encryption and Bacula
> I'm having trouble backing up a Windows XP machine that has a directory > (and everything below it) selected for encryption (properties on the > directory). I'm getting "ERR=Access is denied" for the files. It's > confusing, b/c it's still reading the full directory structure and > encryption shouldn't stop "reading" of the file, only decrypting would > be an issue. > > The server is running 2.4.2 and the client is also running a 2.4 version > (may be higher minor rev). > > Does anyone have any experience with this sort of situation or thoughts? > Probably has to be backed up as whatever user can unencrypt the data. The SYSTEM user will not work. John -- This SF.Net email is sponsored by the Verizon Developer Community Take advantage of Verizon's best-in-class app development support A streamlined, 14 day to market process makes app distribution fast and easy Join now and get one step closer to millions of Verizon customers http://p.sf.net/sfu/verizon-dev2dev ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Windows XP encryption and Bacula
All, I'm having trouble backing up a Windows XP machine that has a directory (and everything below it) selected for encryption (properties on the directory). I'm getting "ERR=Access is denied" for the files. It's confusing, b/c it's still reading the full directory structure and encryption shouldn't stop "reading" of the file, only decrypting would be an issue. The server is running 2.4.2 and the client is also running a 2.4 version (may be higher minor rev). Does anyone have any experience with this sort of situation or thoughts? Thanks, Brian -- This SF.Net email is sponsored by the Verizon Developer Community Take advantage of Verizon's best-in-class app development support A streamlined, 14 day to market process makes app distribution fast and easy Join now and get one step closer to millions of Verizon customers http://p.sf.net/sfu/verizon-dev2dev ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Windows Sd write on dat
Hi all, i'm using bacula for backup all my network. I have two storage server debian based. Now i want to add a new server for a new department. I like to reuse a windows 2003 server with an HP storage works DAT 40. It's compatible with bacula sd? someone can send me a link or a suggestions for the better configuration? Thank you Ghido -- View this message in context: http://old.nabble.com/Windows-Sd--write-on-dat-tp27074384p27074384.html Sent from the Bacula - Users mailing list archive at Nabble.com. -- This SF.Net email is sponsored by the Verizon Developer Community Take advantage of Verizon's best-in-class app development support A streamlined, 14 day to market process makes app distribution fast and easy Join now and get one step closer to millions of Verizon customers http://p.sf.net/sfu/verizon-dev2dev ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] No constraints in bacula database
> On Wed, 06 Jan 2010 11:37:18 +0100, Marek Simon said: > > Hi, > I do some experiments with bacula database and I found that there is no > foreign key constraint between jobmedia and job, jobmedia and media, job > and file and many similar logicaly connected tables. Why? Constraints > prevent arising void references (File with empty job, File with empty > filename, jobmedia record with empty job or media) > I have bacula-dir version 2.4.4, postgres variant, and postgres 8.3, > default instalation. Bacula inserts huge numbers of records into the File table during backups, so any constraints on that table could be very bad for performance. __Martin -- This SF.Net email is sponsored by the Verizon Developer Community Take advantage of Verizon's best-in-class app development support A streamlined, 14 day to market process makes app distribution fast and easy Join now and get one step closer to millions of Verizon customers http://p.sf.net/sfu/verizon-dev2dev ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users