[Bacula-users] delete job files from a volume
Hi all, I have a question about volumes: is it possible to delete job files from a volume (storage is a hard disk). I mean yesterday a huge backup fails and now I have my storage full: I tryed to delete files just from that job but I can't. Do you have any suggestion? Thanks marco - Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Bacula doesn't backup to remote storage
Thank You for Your suggestions, but i still have the same problems.
And heartbeat seems doesn't help to prevent such situation.
What else i should check?
I just want mentioned these problems started when i added spooling and
concurrent jobs.
Thanks.
Victoria
On Tue, 2006-08-08 at 13:29 -0500, Erich Prinz wrote:
For a start, add the 'heartbeat' directive to keep the connection
alive on the FD. This is done in the FD .conf file.
From the Bacula manual:
Heartbeat Interval = time-interval
This record defines an interval of time. For each heartbeat that the
File daemon receives from the
Storage daemon, it will forward it to the Director. In addition, if no
heartbeat has been received from the Storage daemon and thus for-
warded the File daemon will send a heartbeat signal to the Director
and to the Storage daemon to keep the channels active. The default
interval is zero which disables the heartbeat. This feature is partic-
ularly useful if you have a router such as 3Com that does not follow
Internet standards and times out a valid connection after a short du-
ration despite the fact that keepalive is set.
Erich
On Aug 8, 2006, at 3:48 AM, victoria wrote:
Hello to everyone!
I have following situation on my backup servers. First, my backup
structure is like this:
Backup server and Storage server with MySQL database.
Backup director configuration on backup server looks following:
Director {
Name = backup-dir
DIRport = 9101
QueryFile = /opt/bacula/scripts/query.sql
WorkingDirectory = /var/bacula/working
PidDirectory = /var/run
Password = password
Maximum Concurrent Jobs = 10
Messages = Standard
FD Connect Timeout = 1
}
As you can see, i am using concurrent jobs.
And SD daemon on storage server.
When i'm trying backup something i got file on storage server:
[EMAIL PROTECTED] du -h /baculabk/robber0001
2.0G/baculabk/robber0001
But backup message is:
07-Aug 21:15 backup-dir: No prior Full backup Job record found.
07-Aug 21:15 backup-dir: No prior or suitable Full backup found. Doing
FULL backup.
07-Aug 21:15 backup-dir: Start Backup JobId 18,
Job=robber.2006-08-07_21.05.16
07-Aug 21:15 backup-dir: Created new Volume robber0001 in catalog.
07-Aug 17:53 backup-sd: Labeled new Volume robber0001 on device
robber (/baculabk).
07-Aug 17:53 backup-sd: Wrote label to prelabeled Volume
robber0001 on
device robber (/baculabk)
07-Aug 17:53 backup-sd: Spooling data ...
07-Aug 20:31 backup-sd: Committing spooled data to Volume
robber0001.
Despooling 2,104,893,735 bytes ...
07-Aug 20:33 backup-sd: Sending spooled attrs to the Director.
Despooling 108,212,728 bytes ...
08-Aug 01:15 backup-dir: robber.2006-08-07_21.05.16 Fatal error:
Network
error with FD during Backup: ERR=Connection reset by peer
08-Aug 01:15 backup-dir: robber.2006-08-07_21.05.16 Fatal error: No
Job
status returned from FD.
08-Aug 01:15 backup-dir: robber.2006-08-07_21.05.16 Error: Bacula
1.38.5
(18Jan06): 08-Aug-2006 01:15:58
JobId: 18
Job:robber.2006-08-07_21.05.16
Backup Level: Full (upgraded from Incremental)
Client: robber-fd sparc-sun-solaris2.8,solaris,5.8
FileSet:robber 2006-08-07 21:15:40
Pool: robber
Storage:robber
Scheduled time: 07-Aug-2006 21:05:15
Start time: 07-Aug-2006 21:15:40
End time: 08-Aug-2006 01:15:58
Priority: 10
FD Files Written: 0
SD Files Written: 345,527
FD Bytes Written: 0
SD Bytes Written: 2,095,004,109
Rate: 0.0 KB/s
Software Compression: None
Volume name(s): robber0001
Volume Session Id: 16
Volume Session Time:1154961001
Last Volume Bytes: 2,104,502,272
Non-fatal FD errors:0
SD Errors: 0
FD termination status: Error
SD termination status: OK
Termination:*** Backup Error ***
I can't restore nothing from this file.
Why it sends reset by peer? Please point me what is wrong.
Best Regards,
Victoria
--
---
Using Tomcat but need to do more? Need to support web services,
security?
Get stuff done quickly with pre-integrated technology to make your
job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache
Geronimo
http://sel.as-us.falkag.net/sel?
cmd=lnkkid=120709bid=263057dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Warning: sql_create.c:831 More than one Filename! 2 for file:
I don't think this made it to the list yesterday: Dominic Marks wrote: Frank Sweetser wrote: On Mon, Aug 07, 2006 at 11:24:55AM +0100, Dominic Marks wrote: Hello, I'm getting a lot of these messages when backing up certain systems. Can someone clarify exactly what the error is referring to? Sounds like you've got some bad data in your catalog database. Try using the dbcheck utility to verify this and clean out any duplicate or stale records. Thanks Frank, I'm running dbcheck now. I don't know how long is usual for a dbcheck run but it has had the cpu at 100% for about 10 hours so far. I opted to run all the checks and its currently checking for orphaned path entries. Our MySQL database is Output so far: Checking for Filenames with a trailing slash Found 0 bad Filename records. Checking for Paths without a trailing slash Found 1 bad Path records. Checking for duplicate Filename entries. Found 1 duplicate Filename records. Checking for duplicate Path entries. Found 0 duplicate Path records. Checking for orphaned JobMedia entries. Found 0 orphaned JobMedia records. Checking for orphaned File entries. This may take some time! Found 284456 orphaned File records. Checking for orphaned Path entries. This may take some time! I'll paste the rest of the output when dbcheck finishes. Anyway, dbcheck did something bad to MySQL over night and it had to be restarted because Bacula and the MySQL Server both stopped responding. I'm going to dump and archive the catalogue in its broken state and then start with a fresh one unless anyone has any great ideas? I'm open to all suggestions - but obviously I need to get the backup system back online ASAP. Thanks, Dominic Thanks, Dominic - Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] newbie to tapes question
Hi, Im having the following problem. Im tring to do a backup job (named jtgv-gsi) using 2 tapes labeled 01L3 and 02L3(which are added in a pool named TapePoolForSERVERS). When 01L3 go full, bacula asked me 02L3. I think it wasn't supposed to ask me for it since I'm using an auto charger and both tapes were in it. As you can seen below, I do a mount and still bacula is asking me for it. Tape 01L3 is unloaded from the drive and 02L3 is loaded in to the drive. Is it because 02L3 state is Recycle? Who can I force bacula to use it? Thank you. * *status dir isep-dir Version: 1.38.11 (28 June 2006) x86_64-redhat-linux-gnu redhat Enterprise release Daemon started 09-Aug-06 17:17, 6 Jobs run since started. Scheduled Jobs: Level Type Pri Scheduled Name Volume === Full Backup11 10-Aug-06 23:10BackupCatalog novoteste Running Jobs: JobId Level Name Status == 457 Fulljtgv-gsi.2006-08-10_10.11.48 is waiting for a mount request Terminated Jobs: JobId Level Files Bytes Status FinishedName 447 Incr 0 0 OK 07-Aug-06 23:05 Client1 448 Full 1 1,751,631 OK 07-Aug-06 23:10 BackupCatalog 450 Full 0 0 Error09-Aug-06 00:05 BackupCatalog 449 Incr 0 0 Error09-Aug-06 05:23 Client1 451 Full 11,123 88,265,557,275 OK 09-Aug-06 20:00 jtgv-gsi 452 Incr 0 0 Cancel 09-Aug-06 20:00 jtgv-gsi 453 Full 11,123 88,265,557,275 OK 09-Aug-06 22:18 jtgv-gsi 454 Full 11,123 88,265,557,275 OK 10-Aug-06 00:35 jtgv-gsi 455 Full 11,123 88,265,557,275 OK 10-Aug-06 02:53 jtgv-gsi 456 Full 1 6,972,676 OK 10-Aug-06 02:53 BackupCatalog *mount The defined Storage resources are: 1: File 2: IBM Ultrium 3 Select Storage resource (1-2): 2 3001 OK mount. Device=IBM Ultrium 3 (/dev/nst0) *messages 10-Aug 13:15 localhost-sd: 3301 Issuing autochanger loaded drive 0 command. 10-Aug 13:15 localhost-sd: 3302 Autochanger loaded drive 0, result is Slot 2. 10-Aug 13:15 localhost-sd: Please mount Volume 02L3 on Storage Device IBM Ultrium 3 (/dev/nst0) for Job jtgv-gsi.2006-08-10_10.11.48 *list volume Pool: Default +-++---+---+--+--+-+--+---+---+-+ | MediaId | VolumeName | VolStatus | VolBytes | VolFiles | VolRetention | Recycle | Slot | InChanger | MediaType | LastWritten | +-++---+---+--+--+-+--+---+---+-+ | 2 | novoteste | Append| 1,452,894,204 |0 | 31,536,000 | 1 |0 | 1 | File | 2006-08-10 02:53:05 | +-++---+---+--+--+-+--+---+---+-+ Pool: TapePoolForSERVERS +-++---+-+--+--+-+--+---+---+-+ | MediaId | VolumeName | VolStatus | VolBytes| VolFiles | VolRetention | Recycle | Slot | InChanger | MediaType | LastWritten | +-++---+-+--+--+-+--+---+---+-+ | 6 | 02L3 | Recycle | 1 |0 | 31,536,000 | 1 |2 | 1 | Ultrium 3 | -00-00 00:00:00 | | 7 | 01L3 | Full | 434,114,617,268 | 437 | 31,536,000 | 1 |1 | 1 | Ultrium 3 | 2006-08-10 12:20:06 | +-++---+-+--+--+-+--+---+---+-+ -- - Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] delete job files from a volume
I think you can use the purge jobs volume. Be cautioned while purging/deleting jobs. Marco Strullato wrote: Hi all, I have a question about volumes: is it possible to delete job files from a volume (storage is a hard disk). I mean yesterday a huge backup fails and now I have my storage full: I tryed to delete files just from that job but I can't. Do you have any suggestion? Thanks marco - Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users - Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] delete job files from a volume
Now I have /dev/mapper/SystemVG-lvbackup 55G 55G 0 100% /mnt/backup Then I tryed the following but anything has been deleted... Do you have any suggestion? [EMAIL PROTECTED] tmp]# /opt/bacula/etc/bconsole Connecting to Director shannon:9101 1000 OK: DirectorServer Version: 1.38.11 (28 June 2006) Enter a period to cancel a command. *purge Using default Catalog name=MyCatalog DB=bacula You have the following choices: 1: files 2: jobs 3: volume Choose item to purge (1-3): 2 The defined Client resources are: 12: Archidoc Select Client (File daemon) resource (1-12): 12 Begin purging jobs from Client Archidoc No Jobs found for client Archidoc to purge from MyCatalog catalog. *purge 1: files 2: jobs 3: volume Choose item to purge (1-3): 1 The defined Client resources are: 12: Archidoc Select Client (File daemon) resource (1-12): 12 Begin purging files for Client Archidoc No Files found for client Archidoc to purge from MyCatalog catalog. *purge 1: files 2: jobs 3: volume Choose item to purge (1-3): 2 The defined Client resources are: 12: Archidoc Select Client (File daemon) resource (1-12): 6 Begin purging jobs from Client Shannon No Jobs found for client Shannon to purge from MyCatalog catalog. 2006/8/10, Jaime Ventura [EMAIL PROTECTED]: I think you can use the purge jobs volume. Be cautioned while purging/deleting jobs. Marco Strullato wrote: Hi all, I have a question about volumes: is it possible to delete job files from a volume (storage is a hard disk). I mean yesterday a huge backup fails and now I have my storage full: I tryed to delete files just from that job but I can't. Do you have any suggestion? Thanks marco - Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users - Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Installation Issue
yes, i build on suse with suse mysql rpms and just pass the --with-mysql flag. -- michael On Wed, Aug 09, 2006 at 05:50:55PM +0100, Martin Simmons wrote: I think you need ./configure --with-mysql=/usr or maybe just ./configure --with-mysql - Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] delete job files from a volume
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 As I'm fairly sure is documented in the manual, purge allows the files to be reused. If you want to remove the volume files, you must do this at the filesystem level. =R _ _ _ _ ___ _ _ _ |Y#| | | |\/| | \ |\ | | |Ryan Novosielski - Systems Programmer III |$| |__| | | |__/ | \| _| |[EMAIL PROTECTED] - 973/972.0922 (2-0922) \__/ Univ. of Med. and Dent.|IST/AST - NJMS Medical Science Bldg - C630 Marco Strullato wrote: Now I have /dev/mapper/SystemVG-lvbackup 55G 55G 0 100% /mnt/backup Then I tryed the following but anything has been deleted... Do you have any suggestion? [EMAIL PROTECTED] tmp]# /opt/bacula/etc/bconsole Connecting to Director shannon:9101 1000 OK: DirectorServer Version: 1.38.11 (28 June 2006) Enter a period to cancel a command. *purge Using default Catalog name=MyCatalog DB=bacula You have the following choices: 1: files 2: jobs 3: volume Choose item to purge (1-3): 2 The defined Client resources are: 12: Archidoc Select Client (File daemon) resource (1-12): 12 Begin purging jobs from Client Archidoc No Jobs found for client Archidoc to purge from MyCatalog catalog. *purge 1: files 2: jobs 3: volume Choose item to purge (1-3): 1 The defined Client resources are: 12: Archidoc Select Client (File daemon) resource (1-12): 12 Begin purging files for Client Archidoc No Files found for client Archidoc to purge from MyCatalog catalog. *purge 1: files 2: jobs 3: volume Choose item to purge (1-3): 2 The defined Client resources are: 12: Archidoc Select Client (File daemon) resource (1-12): 6 Begin purging jobs from Client Shannon No Jobs found for client Shannon to purge from MyCatalog catalog. 2006/8/10, Jaime Ventura [EMAIL PROTECTED]: I think you can use the purge jobs volume. Be cautioned while purging/deleting jobs. Marco Strullato wrote: Hi all, I have a question about volumes: is it possible to delete job files from a volume (storage is a hard disk). I mean yesterday a huge backup fails and now I have my storage full: I tryed to delete files just from that job but I can't. Do you have any suggestion? Thanks marco - Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users - Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.2.2 (MingW32) iD8DBQFE2zqSmb+gadEcsb4RAm6mAJ9PIXgZi8vH1e0YR0K5joheYEEp6wCghGam oJqqQtI+D/nFwF8TW+uC4hk= =gjaq -END PGP SIGNATURE- - Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Slow Backup Performance on Windows 2003.
I've seen similar data on my backups, but generally, only with very small backup sizes (less than 1GB). When I back up over 1GB, the rates increase dramatically, although backup from the Windows server is still only about 1/2 to 1/3 the Linux server rate. Before you get too concerned, try a bigger backup (3-5GB) and see what the performance is. With your small backups, it is probably mostly due to the ratio of overhead to actual data. Mike pedro moreno wrote: Hi. I have been working with bacula for some months, i love this software, my current problem is this one: My Test Server. I'm running bacula server 1.38.11 on FreeBSD 6.1-p3 Mysql 4.1.20 Tape HP Storage Works 232 External 200GB Compress HD 200 IDE 7200 RPM AMD Duron 1.6 Ghz 512 RAM Clients: 2 Win NT 4 Client 1.38.4 1 Windows 2k3 Estandard Edition Client 1.38.4 1 Linux Red Hat 9 (bonding ON -- 2 NIC's) 1.38.4 My production server is: I'm running bacula server 1.38.5 on FreeBSD 5.4-p16 Mysql 5.0.21 Tape HP Storage Works 232 External 200GB Compress HD 80 IDE 5400 RPM AMD Duron 1.6 Ghz 512 RAM Im going to talk about the test server, because the production server has almost the same performance, this is one report from a backup for win2k3: JobId: 56 Job:MBXPDC.2006-08-09_15.39.26 Backup Level: Full Client: MBXPDC Windows Server 2003,MVS,NT 5.2.3790 FileSet:MBXPDC-FS 2006-08-02 15:58:32 Pool: MueblexFullTape Storage:LTO-1 Scheduled time: 09-Aug-2006 15:39:07 Start time: 09-Aug-2006 15:39:32 End time: 09-Aug-2006 15:42:36 Elapsed time: 3 mins 4 secs Priority: 12 FD Files Written: 686 SD Files Written: 686 FD Bytes Written: 145,029,656 (145.0 MB) SD Bytes Written: 145,138,453 (145.1 MB) Rate: 788.2 KB/s Software Compression: None Volume name(s): FullTape-0003 Volume Session Id: 4 Volume Session Time:1155162336 Last Volume Bytes: 2,969,478,620 (2.969 GB) Non-fatal FD errors:0 SD Errors: 0 FD termination status: OK SD termination status: OK Termination:Backup OK You can see the rate...? This is the problem, this is a new server Supermicro: Xeon 3Ghz (2 cpu) 2 GB RAM Raid 5(4 HD) The others serves are old computers and the Rate value is 1MB/s, i still cannot increase this value. Example: WinNT 4(A) --- Spool On --Net..Buffer Size = 65536 Rate 2319.7 Data Size 176MB WinNT 4(B) --- Spool On --Net..Buffer Size = 65536 Rate 2296.6 Data Size 339MB Linux --- Spool On --Net..Buffer Size = 65536 Rate 5536 Data Size 155MB FreeBSD---Spool On --Net..Buffer Size = 65536 Rate 1709.7 Data Size 8MB Win2k3 ---Spool On --Net..Buffer Size = 65536 Rate 788.2 Data Size 145MB VSS=yes WinNT 4(A) --- Spool OFF --Net..Buffer Size = 65536 Rate 2319.7 Data Size 176MB WinNT 4(B) --- Spool OFF --Net..Buffer Size = 65536 Rate 2296.6 Data Size 339MB Linux --- Spool OFF --Net..Buffer Size = 65536 Rate 5536 Data Size 155MB FreeBSD---Spool OFF --Net..Buffer Size = 65536 Rate 1709.7 Data Size 8MB Win2k3 ---Spool OFF --Net..Buffer Size = 65536 Rate 824 Data Size 145MB VSS=yes Now check thi: WinNT 4(A) --- Spool OFF--Net..Buffer Size = default Rate 1388.2 Data Size 176MB WinNT 4(B) --- Spool OFF --Net..Buffer Size = default Rate 1716 Data Size 339MB Linux --- Spool OFF --Net..Buffer Size = default Rate 6739.5 Data Size 155MB FreeBSD---Spool OFF --Net..Buffer Size = default Rate 1398.7 Data Size 8MB Win2k3 ---Spool OFF --Net..Buffer Size = default Rate 805.7 Data Size 145MB VSS=yes WinNT 4(A) --- Spool On --Net..Buffer Size = default Rate 2124.1 Data Size 176MB WinNT 4(B) --- Spool On --Net..Buffer Size = default Rate 1867.5 Data Size 339MB Linux --- Spool On --Net..Buffer Size = default Rate 4559 Data Size 155MB FreeBSD---Spool On --Net..Buffer Size = default Rate 1459.2 Data Size 8MB Win2k3 ---Spool On --Net..Buffer Size = default Rate 810.2 Data Size 145MB VSS=yes Them i disable the VSS=on, buffer = 65536 Win2k3 ---Spool On --Net..Buffer Size = default Rate 814 Data Size 145MB VSS=off I check my Indexes on mysql, reading the maillist they look correct: mysql SHOW index from File; +---++--+--+-+---+-+--++--++-+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment |
Re: [Bacula-users] newbie to tapes question
Thank you for reply.
Can you take a look on the sections you mentioned?
My autocharger is a Dell PowerVault 124T with only one drive.
I believe its correct.
Thanks
#
Autochanger {
Name = TapeLoader124T
Device = IBM Ultrium 3
Changer Command = /etc/bacula/mtx-changer %c %o %S %a %d
Changer Device = /dev/sg5
}
Device {
Name = IBM Ultrium 3
Drive Index = 0
Media Type = Ultrium 3
Archive Device = /dev/nst0
AutomaticMount = yes; # when device opened, read it
AlwaysOpen = yes;
RemovableMedia = yes;
RandomAccess = no;
AutoChanger = yes
# Enable the Alert command only if you have the mtx package loaded
Alert Command = sh -c 'tapeinfo -f %c |grep TapeAlert|cat'
}
Jaime Ventura
[Infra-estruturas e Comunicações]
Rua Dr. António Bernardino de Almeida, 431
4200 - 072 Porto
Telef: +351 22 834 05 00 (04) - ext. 1641
Fax: +351 22 832 11 59
e-mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
url:www.isep.ipp.pt http://www.isep.ipp.pt
Alan Brown wrote:
On Thu, 10 Aug 2006, Jaime Ventura wrote:
*mount
The defined Storage resources are:
1: File
2: IBM Ultrium 3
Judging from this, you have malconfigured your autochanger resource.
Please re-read the manual and ensure you have an autochanger section AND
a section for each tape drive in the autochanger.
AB
-
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] System crashing hard -- presumably Bacula is the culprit
I have been running bacula Version: 1.38.8 (compiled from source) for a few months now. I am running CentOS 4.3 on an x86_64 platform. I am backing up to disk (external USB storage). This has been running fine for the past few months. This week the system has crashed hard (no kernel panic) 2 times. I can not find anything of value in any of the system logs. It is a complete hang of the system. I am running VMware Workstation on this server. The reason I mention this is because the only significant change to the system this week is that more VM instances have been running on the server this week. All day long the Virtual Machines and the physical system plays nicely with one another. Then, within 2 minutes of seeing this bacula message Volume INCR-0003 previously written, moving to end of data, the system hangs. The above message is seen write after the script defined in the RunBeforeJob (for the physical system) directive is run (and completed successfully). It is a presumed 2 minutes because that is the time from the above message to the last message written to the /var/log/messages file. I can not find any other jobs running at that time then would be any different then the jobs running throughout the day. Anyone have any suggestions on things I could tune that would prevent the system from crashing? My bacula configurations are not all that complex or strange. Anyone else seen this type of behavior? Thanks. -- Scott - Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Warning: sql_create.c:831 More than one Filename! 2 for file:
Quoting Dominic Marks [EMAIL PROTECTED]: I don't think this made it to the list yesterday: [snip] Anyway, dbcheck did something bad to MySQL over night and it had to be restarted because Bacula and the MySQL Server both stopped responding. I'm going to dump and archive the catalogue in its broken state and then start with a fresh one unless anyone has any great ideas? I'm open to all suggestions - but obviously I need to get the backup system back online ASAP. On an unmodified Bacula system, dbcheck can run for days. And it locks the database so no backups or restores can be done until it finishes. Look in the archives for this list about adding indexes. There are two or three indexes that can be added. These additions cut the runtime for over two days on my SOHO system with 5 computers to a few minutes. HTH, Jeffrey - Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Client Run Before Job question
Brian McCann wrote: I haven't tried this yet, but I figured I'd ask. Is it possible to have multiple Client Run Before Job options for the Job directive? Thanks! --Brian I think that it will be easier to create a script or batch file that will do all the job and run it once. For example see database backup -- Hristo Benev IT Manager WAVEROAD Partners in Telecommunications 514-935-2020 x225 T 514-935-1001 F www.waveroad.ca [EMAIL PROTECTED] - Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] newbie to tapes question
On Thu, 10 Aug 2006, Jaime Ventura wrote: *mount The defined Storage resources are: 1: File 2: IBM Ultrium 3 Judging from this, you have malconfigured your autochanger resource. Please re-read the manual and ensure you have an autochanger section AND a section for each tape drive in the autochanger. AB - Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] System crashing hard -- presumably Bacula is the culprit
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Almost sounds like the beginnings of a hardware failure to me. _ _ _ _ ___ _ _ _ |Y#| | | |\/| | \ |\ | | |Ryan Novosielski - Systems Programmer III |$| |__| | | |__/ | \| _| |[EMAIL PROTECTED] - 973/972.0922 (2-0922) \__/ Univ. of Med. and Dent.|IST/AST - NJMS Medical Science Bldg - C630 Scott Ruckh wrote: I have been running bacula Version: 1.38.8 (compiled from source) for a few months now. I am running CentOS 4.3 on an x86_64 platform. I am backing up to disk (external USB storage). This has been running fine for the past few months. This week the system has crashed hard (no kernel panic) 2 times. I can not find anything of value in any of the system logs. It is a complete hang of the system. I am running VMware Workstation on this server. The reason I mention this is because the only significant change to the system this week is that more VM instances have been running on the server this week. All day long the Virtual Machines and the physical system plays nicely with one another. Then, within 2 minutes of seeing this bacula message Volume INCR-0003 previously written, moving to end of data, the system hangs. The above message is seen write after the script defined in the RunBeforeJob (for the physical system) directive is run (and completed successfully). It is a presumed 2 minutes because that is the time from the above message to the last message written to the /var/log/messages file. I can not find any other jobs running at that time then would be any different then the jobs running throughout the day. Anyone have any suggestions on things I could tune that would prevent the system from crashing? My bacula configurations are not all that complex or strange. Anyone else seen this type of behavior? Thanks. -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.2.2 (MingW32) iD8DBQFE213Wmb+gadEcsb4RAllfAKDILtInflt0ltJzyfT7WlLlgULYpQCeOfHV b4qcB26gz23radBpauXTmuw= =j3Lx -END PGP SIGNATURE- - Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] newbie to tapes question
On Thu, 10 Aug 2006, Jaime Ventura wrote:
Thank you for reply.
Can you take a look on the sections you mentioned?
My autocharger is a Dell PowerVault 124T with only one drive.
I believe its correct.
It looks mostly ok, but I would not use Whitespace in labels
Thanks
#
Autochanger {
Name = TapeLoader124T
Device = IBM Ultrium 3
Device = IBM-Ultrium-3
Changer Command = /etc/bacula/mtx-changer %c %o %S %a %d
Changer Device = /dev/sg5
}
Device {
Name = IBM Ultrium 3
Name = IBM-Ultrium-3
Drive Index = 0
Media Type = Ultrium 3
Media Type = Ultrium-3
Archive Device = /dev/nst0
AutomaticMount = yes; # when device opened, read it
AlwaysOpen = yes;
RemovableMedia = yes;
RandomAccess = no;
LabelMedia = yes; # lets Bacula label unlabeled media
Volume Poll Interval = 7200 # time between device rechecks
Spool Directory = /var/bacula/spool/ # read spooling section
Maximum Spool Size = 2000 # 200Gb # of manual.
Maximum Job Spool Size = 200 # 20Gb#
AutoChanger = yes
# Enable the Alert command only if you have the mtx package loaded
Alert Command = sh -c 'tapeinfo -f %c |grep TapeAlert|cat'
}
It looks mostly OK
Because of the speed of LTO3 media, you should always use spooling for
everything - except possibly full backups - otherwise the tape spends a
lot of time shoe-shining
What storage device are you calling in your -dir job{} entries?
What are your bacula-dir storage{} entries?
Jaime Ventura
[Infra-estruturas e Comunicações]
Rua Dr. António Bernardino de Almeida, 431
4200 - 072 Porto
Telef: +351 22 834 05 00 (04) - ext. 1641
Fax: +351 22 832 11 59
e-mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
url: www.isep.ipp.pt http://www.isep.ipp.pt
Alan Brown wrote:
On Thu, 10 Aug 2006, Jaime Ventura wrote:
*mount
The defined Storage resources are:
1: File
2: IBM Ultrium 3
Judging from this, you have malconfigured your autochanger resource.
Please re-read the manual and ensure you have an autochanger section AND
a section for each tape drive in the autochanger.
AB
-
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Warning: sql_create.c:831 More than one Filename! 2 for file:
On Thu, 10 Aug 2006, Jeffrey L. Taylor wrote: On an unmodified Bacula system, dbcheck can run for days. Literally. And it locks the database so no backups or restores can be done until it finishes. Look in the archives for this list about adding indexes. There are two or three indexes that can be added. Add these ones: idx_jobid, for JobId in File idx_pathid, for PathId in File idx_filenameid for FilenameId in File I know there's a 3-way index, but it doesn't seem to work. The queries for orphan files, paths and filenames will run ok once this is done (cut runtime down from 3 days to about 20 minutes for over 100 million entries) BUT: dbcheck generates a lit of entries to delete, then attempts to do them one at a time - this is _extremely_ slow. These additions cut the runtime for over two days on my SOHO system with 5 computers to a few minutes. The queries can be done manually, but you MUST have MySQL newer than 4.1.0 Checking orphan files: SELECT COUNT(*) FROM File WHERE JobId NOT IN ( SELECT JobId FROM Job ) deleting orphan files: DELETE FROM File WHERE JobId NOT IN ( SELECT JobId FROM Job) Checking orphan paths: SELECT COUNT(*) FROM Path WHERE PathId NOT IN ( SELECT PathId FROM File ) Deleting orphan paths: DELETE FROM Path WHERE PathId NOT IN ( SELECT PathId FROM File ) Checking orphaned filenames: SELECT COUNT(*) FROM Filename WHERE FilenameId NOT IN ( SELECT FilenameId FROM File ) Deleting orphaned filenames DELETE FROM Filename WHERE FilenameId NOT IN ( SELECT FilenameId FROM File ) These subselects are slightly slower than LEFT OUTER JOIN, however you can't use a LEFT OUTER JOIN in a DELETE statement. AB - Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Kernel panic from Bacula recovery CDs
Hi guys, Me and my guys have inherited a webserver running Debian 3.3.5 and bacula doing remote backups (the webserver is a bacula client). The previous admin left very little in the way of documentation so that is one of our first tasks. Along those line, we want to be able to do a bare metal restore of the webserver to another machine. So be the good little geeks that we are, we RTFBM and followed the procedure to create the Bacula CDs. The problem we are experiencing is a kernel panic when booting off the CD, the specific message is unable to mount root fs on unknown-block(3,1). Now, this tells me a couple of things: 1. Bacula is trying to mount a file system from the first partition of the first hard drive. Why? For all intents and purposes, it looks like a pivotroot is being executed, but I checked the linuxrc script and there is no pivotroot. I tried 'linux root=/dev/root' and got the same kernel panic on unknown-block(0,0). 2. The Bacula CD can't find a fs module to load. While the module in question (ext3) may not be built into the kernel, it is in the initrd image that gets loaded. So why isn't it being found? Any suggestions on how to get these CDs to boot? -- Regards, Faber Fedor President Linux New Jersey, Inc. 908-320-0357 800-706-0701 http://www.linuxnj.com - Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Warning: sql_create.c:831 More than one Filename! 2 for file:
In the message dated: Thu, 10 Aug 2006 18:14:04 BST, The pithy ruminations from Alan Brown on Re: [Bacula-users] Warning: sql_create.c:831 More than one Filename! 2 for fil e: were: = On Thu, 10 Aug 2006, Jeffrey L. Taylor wrote: = = On an unmodified Bacula system, dbcheck can run for days. = = Literally. Ah. Ok. So, my attempts to run dbcheck were actually working normally. = = And it = locks the database so no backups or restores can be done until it = finishes. Look in the archives for this list about adding indexes. = There are two or three indexes that can be added. = = Add these ones: = = idx_jobid, for JobId in File = idx_pathid, for PathId in File = idx_filenameid for FilenameId in File = = I know there's a 3-way index, but it doesn't seem to work. = = The queries for orphan files, paths and filenames will run ok once this is = done (cut runtime down from 3 days to about 20 minutes for over 100 = million entries) That's good to know. Do you know why those indicies aren't enabled by default? What's the overhead (CPU and disk space) needed to generate and maintain the indicies? Does having the indicies speed up other bacula operations? Are there any other hints you can offer regarding database tuning (particularly with mysql 5.0.22)? Thanks, Mark Mark Bergman [EMAIL PROTECTED] System Administrator Section of Biomedical Image Analysis 215-662-7310 Department of Radiology, University of Pennsylvania http://pgpkeys.pca.dfn.de:11371/pks/lookup?search=mark.bergman%40.uphs.upenn.edu The information contained in this e-mail message is intended only for the personal and confidential use of the recipient(s) named above. If the reader of this message is not the intended recipient or an agent responsible for delivering it to the intended recipient, you are hereby notified that you have received this document in error and that any review, dissemination, distribution, or copying of this message is strictly prohibited. If you have received this communication in error, please notify us immediately by e-mail, and delete the original message. - Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] System crashing hard -- presumably Bacula is the culprit
On Thu, 10 Aug 2006 08:41:10 -0700 (MST), Scott Ruckh said: I have been running bacula Version: 1.38.8 (compiled from source) for a few months now. I am running CentOS 4.3 on an x86_64 platform. I am backing up to disk (external USB storage). This has been running fine for the past few months. This week the system has crashed hard (no kernel panic) 2 times. I can not find anything of value in any of the system logs. It is a complete hang of the system. I am running VMware Workstation on this server. The reason I mention this is because the only significant change to the system this week is that more VM instances have been running on the server this week. All day long the Virtual Machines and the physical system plays nicely with one another. Then, within 2 minutes of seeing this bacula message Volume INCR-0003 previously written, moving to end of data, the system hangs. The above message is seen write after the script defined in the RunBeforeJob (for the physical system) directive is run (and completed successfully). It is a presumed 2 minutes because that is the time from the above message to the last message written to the /var/log/messages file. Perhaps you can configure syslogd to send these messages to the console as well? I can not find any other jobs running at that time then would be any different then the jobs running throughout the day. Anyone have any suggestions on things I could tune that would prevent the system from crashing? Is the USB disk for anything other than backups? If not, maybe the problem the problem is USB-related. Can you do a backup to a non-USB disk? __Martin - Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] System crashing hard -- presumably Bacula is the culprit
-- http://photo-gallery.gemneye.org:1115/Gallery2/ This is what you said Martin Simmons On Thu, 10 Aug 2006 08:41:10 -0700 (MST), Scott Ruckh said: I have been running bacula Version: 1.38.8 (compiled from source) for a few months now. I am running CentOS 4.3 on an x86_64 platform. I am backing up to disk (external USB storage). This has been running fine for the past few months. This week the system has crashed hard (no kernel panic) 2 times. I can not find anything of value in any of the system logs. It is a complete hang of the system. I am running VMware Workstation on this server. The reason I mention this is because the only significant change to the system this week is that more VM instances have been running on the server this week. All day long the Virtual Machines and the physical system plays nicely with one another. Then, within 2 minutes of seeing this bacula message Volume INCR-0003 previously written, moving to end of data, the system hangs. The above message is seen write after the script defined in the RunBeforeJob (for the physical system) directive is run (and completed successfully). It is a presumed 2 minutes because that is the time from the above message to the last message written to the /var/log/messages file. Perhaps you can configure syslogd to send these messages to the console as well? The screen is completely gone so I could not see any console messages and this server is not connected to a console server. I can not find any other jobs running at that time then would be any different then the jobs running throughout the day. Anyone have any suggestions on things I could tune that would prevent the system from crashing? Is the USB disk for anything other than backups? If not, maybe the problem the problem is USB-related. Can you do a backup to a non-USB disk? Thanks for the feedback. I do not really have that available disk space for backups on a non-USB device (this environment is for home office). When I am only running 1-2 virtual machines everything works fine, or at least has run fine in the past. The same has been true this week. Now twice this week when 3 Virtual machines were running the system crashed nearly at the same time (right after the RunBefore script has been completed). As backups seem to work when when more memory is available (less VM's running) it does not appear to be a USB issue (at least the USB Drive). Possibly a conflict with the USB sharing between physical machine and virtual machine. Also, as the only time the system crashes is at the start of the backup process, I do not think hardware is failing. Maybe conflicting as stated above. Thanks for the feedback. - Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] bacula-web for FreeBSD
On 8/8/06, Bill Moran [EMAIL PROTECTED] wrote: In response to Dan Langille [EMAIL PROTECTED]: There is now a bacula-web entry in the FreeBSD ports tree: http://www.freshports.org/www/bacula-web/Outstanding!Thanks, Dan!--Bill MoranCollaborative Fusion Inc.IMPORTANT: This message contains confidential information and is intended only for the individual named. If the reader of thismessage is not an intended recipient (or the individualresponsible for the delivery of this message to an intendedrecipient), please be advised that any re-use, dissemination, distribution or copying of this message is prohibited. Pleasenotify the sender immediately by e-mail if you have receivedthis e-mail by mistake and delete this e-mail from your system.E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost,destroyed, arrive late or incomplete, or contain viruses. Thesender therefore does not accept liability for any errors oromissions in the contents of this message, which arise as a result of e-mail transmission.-Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easierDownload IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642___Bacula-users mailing list Bacula-users@lists.sourceforge.nethttps://lists.sourceforge.net/lists/listinfo/bacula-usersI read this: required to run: databases/pear-DB , lang/php5, databases/php5-mysql required libraries: databases/mysql50-clientIf we are using mysql 4.X.Y same on other packages can work?Thanks. - Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnkkid=120709bid=263057dat=121642___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
