Re: [Bacula-users] [Bacula-devel] Despooling attrs does not finish
Hi! I agree with Martin. It's no a Bacula error, it's a MySQL problem I'm pretty sure that your /tmp partition becomes full, specially if you share both Bacula Spool Directory (are you using SpoolData = yes?) and MySQL temporary filesystem (both of them in /tmp by default) Try changing the tmpdir param of your MySQL server (my.cnf) to a bigger partition (don't forget restart the service to commit the change) Example: # point the following paths to different dedicated disks # tmpdir= /tmp/ tmpdir = /var/tmp/mysql Doing a mysqlrepair to test database integrity will be a good idea Best regards! On Mon, Oct 20, 2014 at 12:57 PM, Martin Simmons mar...@lispworks.com wrote: On Sun, 19 Oct 2014 19:02:57 +0200, Ulrich Leodolter said: Hello Dan, On Sat, 2014-10-18 at 13:32 -0400, Dan Langille wrote: On Oct 18, 2014, at 4:03 AM, Ulrich Leodolter ulrich.leodol...@obvsg.at wrote: Hello, we have Win7 backup which does not come to an end within MaxRunTime=12h. server runs 7.0.5 (28 July 2014), the client has installed the bacula-enterprise-win64-7.0.5.exe. but the problem started about 2 months ago, at that time windows client 5.2.10 was installed on the machine. the backup itself is about 100GB compressed and seems to finish on the client after about 6 hours, below are the last messages of the job before it gets stuck. 2014-10-18 03:18:09 troll-sd JobId 635821: Committing spooled data to Volume Backup-0779. Despooling 1,692,736,419 bytes ... 2014-10-18 03:18:18 troll-sd JobId 635821: Despooling elapsed time = 00:00:09, Transfer rate = 188.0 M Bytes/second 2014-10-18 03:18:19 troll-sd JobId 635821: Elapsed time=06:11:45, Transfer rate=4.691 M Bytes/second 2014-10-18 03:18:22 troll-sd JobId 635821: Sending spooled attrs to the Director. Despooling 603,449,667 bytes . mysql status at the same time: # echo show full processlist | mysql IdUserHostdb Command TimeState Info 6854 bacula localhost bacula Sleep 522 NULL 6873 bacula localhost bacula Query 21143 Sending dataINSERT INTO File (FileIndex, JobId, PathId, FilenameId, LStat, MD5, DeltaSeq) SELECT batch.FileIndex, batch.JobId, Path.PathId, Filename.FilenameId,batch.LStat, batch.MD5, batch.DeltaSeq FROM batch JOIN Path ON (batch.Path = Path.Path) JOIN Filename ON (batch.Name = Filename.Name) 6899 rootlocalhost NULLQuery 0 NULL show full processlist we have a bunch of other clients (about 30), a mixture of linux, win7 and mac powerpc. all other backups run without problems for years now. there are even larger backups, in size and in number of files. does anyone have an idea why this single batch insert does not complete? do i need to analyze the attrs spool file itself ? yesterday i optimized the bacula database, but that doesn't help. there must be something special in the attrs spool file which the mysql server can't handle. the server runs on standard CentOS 6.5 x86_64. This is something which should be asked in the user mailing list, not the devel mailing list. I am replying to that list instead. Ok Is this a large number of files? about 75, not very large. I had something which took a while. I sped it up by giving PostgreSQL more memory. Perhaps MySQL can do the same. Here’s what I did: https://plus.google.com/+DanLangille/posts/AKXoRido3U1 the mysql database is already optimized and has enough memory. backups up 400 files and 700GB run without problems. below are last job messages of the last failed jobs, it was canceled after 12 hours max run time. 2014-10-19 02:49:15 troll-sd JobId 635915: Elapsed time=05:43:32, Transfer rate=5.095 M Bytes/second 2014-10-19 02:49:16 troll-sd JobId 635915: Sending spooled attrs to the Director. Despooling 603,418,522 bytes ... 2014-10-19 09:05:43 troll-dir JobId 635915: Fatal error: Max run time exceeded. Job canceled. 2014-10-19 09:41:17 troll-dir JobId 635915: Error: Bacula troll-dir 7.0.5 (28Jul14): the database shows already about 600k files for this jobs. mysql select count(*) from File where JobId = '635915' and LStat is not null; +--+ | count(*) | +--+ | 616848 | +--+ 1 row in set (0.00 sec) is it possible that some special file attr brings the mysql datebase into troubles ? i really cant imagine. the mysql database is almost idle after first 600k have been inserted. there is no io traffic and cpu usage is also low. it seems i have to dump spooled attrs files tomorrow and compare to database to see at which attrs have been inserted and at which one it stops. I think that will be difficult, because the
Re: [Bacula-users] Error on SD despooling Attributes
Hi! Maybe the partition use for spooling has not enough size Note, not only the data, but the metadata partition can return other error: Mysql example: tmpdir = /tmp/ (default) tmpdir = /var/tmp/mysql (in my case, for large backups) In your case, be sure having 255Gb for that purpose Best regards! On Thu, Feb 7, 2013 at 5:02 PM, Diego Rubert dprub...@prms.mpf.gov.brwrote: Hi, I've got some strange error when doing a full backup with data spooling enabled (specifically when despooling attributes) and a warning getmsg.c:176 bget_dirmsg: unknown bnet signal -169472939. Sometimes the error appears, sometimes don't. You can see the log bellow. Googled and found nothing... Any ideas? Regards, Diego 06-Feb 22:05 bacula-dir JobId 16599: No prior Full backup Job record found. 06-Feb 22:05 bacula-dir JobId 16599: No prior or suitable Full backup found in catalog. Doing FULL backup. 06-Feb 22:14 bacula-dir JobId 16599: Start Backup JobId 16599, Job=bkp-prms01.2013-02-06_22.05.00_17 06-Feb 22:14 bacula-dir JobId 16599: Using Device FileStorage 06-Feb 22:14 bacula-sd JobId 16599: Spooling data ... 07-Feb 02:25 bacula-sd JobId 16599: User specified spool size reached. 07-Feb 02:25 bacula-sd JobId 16599: Writing spooled data to Volume. Despooling 80,530,659,921 bytes ... 07-Feb 02:44 bacula-sd JobId 16599: Despooling elapsed time = 00:19:05, Transfer rate = 70.33 M Bytes/second 07-Feb 02:44 bacula-sd JobId 16599: Spooling data again ... 07-Feb 05:46 bacula-sd JobId 16599: Committing spooled data to Volume Vol0001. Despooling 51,859,698,621 bytes ... 07-Feb 05:58 bacula-sd JobId 16599: Despooling elapsed time = 00:12:29, Transfer rate = 69.23 M Bytes/second 07-Feb 05:58 bacula-sd JobId 16599: Elapsed time=07:44:20, Transfer rate=4.746 M Bytes/second 07-Feb 05:58 bacula-sd JobId 16599: Sending spooled attrs to the Director. Despooling 253,540,559 bytes ... 07-Feb 05:58 bacula-dir JobId 16599: Warning: getmsg.c:176 bget_dirmsg: unknown bnet signal -169472939 07-Feb 06:00 bacula-dir JobId 16599: Error: Bacula bacula-dir 5.2.12 (12Sep12): Build OS: x86_64-suse-linux-gnu suse 11 JobId: 16599 Job:bkp-prms01.2013-02-06_22.05.00_17 Backup Level: Full (upgraded from Incremental) Client: prms01 5.2.12 (12Sep12) x86_64-unknown-linux-gnu,suse,10 FileSet:FileServer Set 2013-02-06 22:05:00 Pool: File (From Job resource) Catalog:MyCatalog (From Client resource) Storage:FileStorage (From Pool resource) Scheduled time: 06-Feb-2013 22:05:00 Start time: 06-Feb-2013 22:14:12 End time: 07-Feb-2013 06:00:15 Elapsed time: 7 hours 46 mins 3 secs Priority: 10 FD Files Written: 680,288 SD Files Written: 0 FD Bytes Written: 132,099,285,441 (132.0 GB) SD Bytes Written: 0 (0 B) Rate: 4724.1 KB/s Software Compression: 14.6 % VSS:no Encryption: no Accurate: no Volume name(s): Vol0001 Volume Session Id: 126 Volume Session Time:135227 Last Volume Bytes: 372,117,630,887 (372.1 GB) Non-fatal FD errors:0 SD Errors: 0 FD termination status: OK SD termination status: SD despooling Attributes Termination:*** Backup Error *** -- -- Diego P. Rubert Coordenadoria de Informática Procuradoria da República no Estado de Mato Grosso do Sul Ministério Público Federal -- Free Next-Gen Firewall Hardware Offer Buy your Sophos next-gen firewall before the end March 2013 and get the hardware for free! Learn more. http://p.sf.net/sfu/sophos-d2d-feb ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users -- Free Next-Gen Firewall Hardware Offer Buy your Sophos next-gen firewall before the end March 2013 and get the hardware for free! Learn more. http://p.sf.net/sfu/sophos-d2d-feb___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] LTO-1 slow recording...
Hello! only a suggestion, as i've never used a scenario like yours: how are the disk partitioned and mounted? Maybe, using the same device for read to spool and send spool to LTO, read job is done twice. Then, spoolled attrs must be send to database And... look your report: Using tar: transfer rate near of 45Gb/hour, what is very good (+ or - 13.5M/s) Using bacula: Job write elapsed time = 00:55:25, Transfer rate = 14.57 M bytes/second It seems that disk performance is better in bacula! Hope it helps Best regards! I have a dedicated backup server using bacula with disk and LTO-1 storages. When I was using tar/star unix commands to record the tape I was getting a transfer rate near of 45Gb/hour, what is very good (+ or - 13.5M/s). I'm using bacula 2.2.6 with MySQL 5.0.41 and recording data from the same server. (bacula-fd, bacula-sd, bacula-dir, mysql and all backuped data is in same server). Check this lines: 21-Nov 03:25 bloo-sd JobId 688: Job write elapsed time = 00:55:25, Transfer rate = 14.57 M bytes/second -- * Alejandro Alfonso Fernandez Responsable Área Corporativa *[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.telecyl.com/ P - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] How Label Format count volumes?
Hello! I'm upgrading my old bacula instalations to bacula 2.2.x After some tries, i have a doubt about automatic label of File Devices Using LabelMedia = yes in Device, and Label Format = Server-, in Pool section, label suffix starts counting in sum of existing Volumes in ALL Pools (example: 2 volumes in Pool_A, 3 volumes in Pool_B: bacula create Server-0006, Server-0007, and so for Pool_C) I think in prior versions bacula counts the volumes ONLY in the asociated Pool (in an empty Pool, first Volume will be Server-0001) Should i start using someting like 'Label Format = Server-${NumVols:p/2/0/r}'? If i have to use Bacula Variables... how can i start counting in 1 in an empty Pool? Thanks in advance! Best regards! -- * Alejandro Alfonso Fernandez *[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.telecyl.com/ 4 - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Quantum Superloader3
Hi! What about mtx-changer script provided by bacula? Look at bacula-directory/etc, and use the script with internar variables used by bacula-dir Best regards! Hi, 11.10.2007 12:14,, GDS.Marshall wrote:: Is anyone using a Quantum Superloader 3 with Bacula? If so, do you know how to get bacula to eject the tape from the drive to the mailslot after the tape has been "Used" and the "Use Duration" has been passed? mtx eject just ejects the left carousel, and not the individual tape. mtx transfer ... should work. Arno Many thanks, Spencer - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users -- Patrocinador Oficial: Alejandro Alfonso Fernandez Responsable rea Corporativa [EMAIL PROTECTED] http://www.telecyl.com/ Procin 7, Portales 1-2 Edificio Amrica II 28023 Madrid Tfn: 902 60 25 55 - Fax: 91 452 18 08 Juan Garca Hortelano, 43 Edificio Telecyl 47014 Valladolid Tfn: 902 60 25 55 - Fax: 983 428 223 - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Mysql - INSERT INTO batch error
It's a bug... look at http://bugs.bacula.org (you must be registered), and then, search for http://bugs.bacula.org/view.php?id=965 Summary 965: Batch insert fails on some MySQL installations Description Batch insert fails on some MySQL installations, probably because the insert refers to the table columns in mixed case while the table was created with lower case characters. and here, the patch for bacula-2.2.4: http://bugs.bacula.org/file_download.php?file_id=604type=bug Kern also says: I've uploaded a patch to this bug report, which fixes the bug in all my tests. The patch applies to version 2.2.4, and the instructions for applying it are at the top of the patch file. I'll try it on weekend on Linux: mysql 5.0.44, bacula 2.2.4, gentoo 2007.0, kernel 2.6.22-gentoo-r5 Bye! Pd. I've used large baculas databases (2.2 Gb. after mysqldump) on smaller systems (PIII Dual, 1Gb Swap, 256Mb Ram) without problems (um... a litte slow, it's true :-) On Monday 01 October 2007 12:58:27 Alejandro Alfonso wrote: Thank you for the fast answer! Um... maybe the problem is related with my server? Its a big backup (about 1'7 Tb, many small files), and 770Gb of SQL sentences 01-Oct 04:05 poe-sd: Sending spooled attrs to the Director. Despooling *767,610,414* bytes ... 01-Oct 04:08 poe-dir: FileServerFull.2007-09-28_23.13.09 Fatal error: sql_create.c:730 sql_create.c:730 insert INSERT INTO batch VALUES My /tmp partition its like this: poe etc # df -h FilesystemSize Used Avail Use% Mounted on /dev/sda4 67G 8.9G 58G 14% / udev 505M 2.8M 502M 1% /dev /dev/sda2 976M 531M 446M 55% /tmp shm 505M 0 505M 0% /dev/shm And there's a problem in that partition: Incorrect key file for table '/tmp/#sql1439_10_0.MYI';try to repair it 01-Oct 04:08 poe-dir: FileServerFull.2007-09-28_23.13.09 Fatal error: The question is... that table was created by bacula or by mysql? temp tables are, I think, created in /tmp with mysql. So if you have to despool a lot of data, all will go into the temp table in /tmp. 500Mb free is probably much too small. It would explain why it says the table is corrupted and you have to repair it. I don't see a link with Bug #965. - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users -- Patrocinador Oficial: Alejandro Alfonso Fernandez Responsable rea Corporativa [EMAIL PROTECTED] http://www.telecyl.com/ Procin 7, Portales 1-2 Edificio Amrica II 28023 Madrid Tfn: 902 60 25 55 - Fax: 91 452 18 08 Juan Garca Hortelano, 43 Edificio Telecyl 47014 Valladolid Tfn: 902 60 25 55 - Fax: 983 428 223 - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now http://get.splunk.com/___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Mysql - INSERT INTO batch error
Hello! i've benn an idiot! I should search before in bugs.bacula.org http://bugs.bacula.org/view.php?id=965 Best regards! Bye! Hello, 01.10.2007 12:58,, Alejandro Alfonso wrote:: Thank you for the fast answer! Um... maybe the problem is related with my server? Its a big backup (about 1'7 Tb, many small files), and 770Gb of SQL sentences That's quite a size, but Bacula should be able to handle that. The catalog backend might be a bit under stress, though. 01-Oct 04:05 poe-sd: Sending spooled attrs to the Director. Despooling *767,610,414* bytes ... 01-Oct 04:08 poe-dir: FileServerFull.2007-09-28_23.13.09 Fatal error: sql_create.c:730 sql_create.c:730 insert INSERT INTO batch VALUES My /tmp partition its like this: poe etc # df -h FilesystemSize Used Avail Use% Mounted on /dev/sda4 67G 8.9G 58G 14% / udev 505M 2.8M 502M 1% /dev /dev/sda2 976M 531M 446M 55% /tmp So there's space left. shm 505M 0 505M 0% /dev/shm And there's a problem in that partition: Incorrect key file for table '/tmp/#sql1439_10_0.MYI';try to repair it 01-Oct 04:08 poe-dir: FileServerFull.2007-09-28_23.13.09 Fatal error: That's bad. The question is... that table was created by bacula or by mysql? This is a MySQL table, so MySQL created it. Of course it did because the DIR issued a statement like 'create temporary table blah...', but the work is done by MySQL. What about increase /tmp partition? That might help, but from what I can see above there's space on that partition, so this should not be the origin of this problem. Perhaps it would be better to start analyzing what MySQL does. A look into MySQLs log files might reveal a more basic problem. Arno Thanks again! Hi, 1) Table "batch" doesn't exists in "make_mysql_tables" script provided by bacula! Thanks in advance! 28-Sep 23:13 poe-dir: BeforeJob: run command "/usr/local/bacula/doSms.sh Inicio FileServerFull Traer_DAT Full" 28-Sep 23:13 poe-dir: Start Backup JobId 1, Job=FileServerFull.2007-09-28_23.13.09 28-Sep 23:18 poe-dir: Using Device "LTO3_DELL" 28-Sep 23:18 poe-sd: 3301 Issuing autochanger "loaded? drive 0" command. 28-Sep 23:18 poe-sd: 3302 Autochanger "loaded? drive 0", result is Slot 1. 28-Sep 23:18 poe-sd: Wrote label to prelabeled Volume "FileServerFull01" on device "LTO3_DELL" (/dev/nst0) 01-Oct 03:28 poe-sd: Spooling data again ... [...] 01-Oct 04:02 poe-sd: Job write elapsed time = 52:40:19, Transfer rate = 7.261 M bytes/second 01-Oct 04:02 poe-sd: Committing spooled data to Volume "FileServerFull03". Despooling 8,243,721,756 bytes ... 01-Oct 04:05 poe-sd: Despooling elapsed time = 00:02:50, Transfer rate = 48.49 M bytes/second 01-Oct 04:05 poe-sd: Sending spooled attrs to the Director. Despooling 767,610,414 bytes ... 01-Oct 04:08 poe-dir: FileServerFull.2007-09-28_23.13.09 Fatal error: sql_create.c:730 sql_create.c:730 insert INSERT INTO batch VALUES (2036153,1,'/raid/files/usuario01/ProyectoX/X/css/','071.css','gQ BADAp4 IHt B T6 Po A BBm BAA Q BG2xPz BG2xPz BG2yww A A C','FSzqZbiVCyGfAIdIkrTfsw') failed: Incorrect key file for table '/tmp/#sql1439_10_0.MYI'; try to repair it 01-Oct 04:08 poe-dir: FileServerFull.2007-09-28_23.13.09 Fatal error: catreq.c:478 Attribute create error. sql_update.c:454 Update failed: affected_rows=0 for UPDATE Media SET InChanger=0 WHERE Slot=3 AND StorageId=1 AND MediaId!=3 01-Oct 04:08 poe-dir: FileServerFull.2007-09-28_23.13.09 Fatal error: sql_create.c:730 sql_create.c:730 insert INSERT INTO batch VALUES (2036154,1,'/raid/files/usuario01/ProyectoX/X/css/','070.css','gQ BADAp5 IHt B T6 Po A BS0 BAA Q BG2xPz BG2xPz BG2yww A A C','nU4ZTR7fa5ULberAoYT3rg') failed: Incorrect key file for table '/tmp/#sql1439_10_0.MYI'; try to repair it 01-Oct 04:08 poe-dir: FileServerFull.2007-09-28_23.13.09 Fatal error: catreq.c:478 Attribute create error. sql_update.c:454 Update failed: affected_rows=0 for UPDATE Media SET InChanger=0 WHERE Slot=3 AND StorageId=1 AND MediaId!=3 01-Oct 04:08 poe-dir: FileServerFull.2007-09-28_23.13.09 Fatal error: sql_create.c:730 sql_create.c:730 insert INSERT INTO batch VALUES (2036155,1,'/raid/files/usuario01/ProyectoX/X/css/','069.css','gQ BADAp6 IHt B T6 Po A BJK BAA Q BG2xPz BG2xPz BG2yww A A C','EvsK8raW7YYwP14dxjgzug') failed: Incorrect key file for table '/tmp/#sql1439_10_0.MYI'; try to repair it 01-Oct 04:08 poe-dir: FileServerFull.2007-09-28_23.13.09 Fatal error: catreq.c:478 Attribute create error. sql_update.c:454 Update failed: affected_rows=0 for UPDATE Media SET InChanger=0 WHERE Slot=3 AND
[Bacula-users] Mysql - INSERT INTO batch error
8:49 Elapsed time: 2 days 4 hours 50 mins 8 secs Priority: 1 FD Files Written: 2,078,249 SD Files Written: 0 FD Bytes Written: 1,376,452,747,911 (1.376 TB) SD Bytes Written: 0 (0 B) Rate: 7236.6 KB/s Software Compression: None VSS: no Encryption: no Volume name(s): FileServerFull01|FileServerFull02|FileServerFull03 Volume Session Id: 1 Volume Session Time: 1191012478 Last Volume Bytes: 120,928,969,728 (120.9 GB) Non-fatal FD errors: 0 SD Errors: 0 FD termination status: OK SD termination status: Running Termination: *** Backup Error *** -- Patrocinador Oficial: Alejandro Alfonso Fernandez Responsable rea Corporativa [EMAIL PROTECTED] http://www.telecyl.com/ Procin 7, Portales 1-2 Edificio Amrica II 28023 Madrid Tfn: 902 60 25 55 - Fax: 91 452 18 08 Juan Garca Hortelano, 43 Edificio Telecyl 47014 Valladolid Tfn: 902 60 25 55 - Fax: 983 428 223 - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] Mysql - INSERT INTO batch error
: FileServerFull (From Job resource) Storage:LTO3_DELL (From Job resource) Scheduled time: 28-Sep-2007 23:13:06 Start time: 28-Sep-2007 23:18:41 End time: 01-Oct-2007 04:08:49 Elapsed time: 2 days 4 hours 50 mins 8 secs Priority: 1 FD Files Written: 2,078,249 SD Files Written: 0 FD Bytes Written: 1,376,452,747,911 (1.376 TB) SD Bytes Written: 0 (0 B) Rate: 7236.6 KB/s Software Compression: None VSS:no Encryption: no Volume name(s): FileServerFull01|FileServerFull02|FileServerFull03 Volume Session Id: 1 Volume Session Time:1191012478 Last Volume Bytes: 120,928,969,728 (120.9 GB) Non-fatal FD errors:0 SD Errors: 0 FD termination status: OK SD termination status: Running Termination:*** Backup Error *** -- * Alejandro Alfonso Fernandez Responsable Área Corporativa *[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.telecyl.com/ - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] Strange problem: sql_update.c:169 sql_get.c:287
d1)); } if (!QUERY_DB(jcr, mdb, mdb-cmd)) { db_unlock(mdb); return 0; /* failed */ } if ((row = sql_fetch_row(mdb)) == NULL) { Mmsg1(mdb-errmsg, _("No Job found for JobId %s\n"), edit_int64(jr-JobId, ed1)); sql_free_result(mdb); db_unlock(mdb); return 0; /* failed */ } Thanks in advance Best regards!!! Pd. I dosen't report to http://bugs.bacula.org/ because i thing its a particular problem -- Alejandro Alfonso Fernndez Dpto de Sistemas. rea Corporativa [EMAIL PROTECTED] http://www.telecyl.com/ Procin 7, Portales 1-2 Edificio Amrica II 28023 Madrid Tfn: 91 452 18 00 - Fax: 91 452 18 08 Juan Garca Hortelano, 43 Edificio Telecyl 47014 Valladolid Tfn: 983 428 200 - Fax: 983 428 223 ___ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] restore from windows
There isn't a graphical tool for bacula administration at this moment, and nothing seems will be one in the near future Otherwise, bconsole can be run from MS Windows, but command line and administrative password must be use Best regards! We are evaluating Bacula as a replacement for our out-of-contract NetBackup installation at an academic site. Everything seems very attractive, except for one thing: as far as I understand from the documentation, there is no way for Windows users to restore their files with a GUI tool. So either admin should do restore for them, or they should be taught to log into the backup server and initiate restore from the command-line. I would appreciate if someone on this list could confirm that. -- Alejandro Alfonso Fernndez Dpto de Sistemas. rea Corporativa [EMAIL PROTECTED] http://www.telecyl.com/ Procin 7, Portales 1-2 Edificio Amrica II 28023 Madrid Tfn: 91 452 18 00 - Fax: 91 452 18 08 Juan Garca Hortelano, 43 Edificio Telecyl 47014 Valladolid Tfn: 983 428 200 - Fax: 983 428 223
Re: [Bacula-users] Volume status error
Hello! Is there a script or utility I can use to verify the backup on the tape? Does bacula support hardware compression? How well does it work generally? Generally its safe to use your database frontend to manage some tape values. And its really faster to change a hign number of records. Use it with caution Bacula/Software compression its good for "File" devices. Tapes like DDS4 use hardware compression by default. Test it with: mt -f /dev/device compression 1 http://downloads.quantum.com/dlt1/DLT1Linux.pdf has some interesting information Best of wishes to incoming year -- Alejandro Alfonso Fernndez Dpto de Sistemas. rea Corporativa [EMAIL PROTECTED] http://www.telecyl.com/ Procin 7, Portales 1-2 Edificio Amrica II 28023 Madrid Tfn: 91 452 18 00 - Fax: 91 452 18 08 Juan Garca Hortelano, 43 Edificio Telecyl 47014 Valladolid Tfn: 983 428 200 - Fax: 983 428 223
Re: [Bacula-users] Retoring files very slow
Build a "restore enviroment" takes me about five minutes in a: Gentoo Linux 2.6.11 1) Bacula 1.38.0 2) Mysql 4.1 3) ~2.000.000 files in the job 4) 1'5Gb /var/lib/mysql Hardware... Pentium II (yes!!) 128Mb RAM (yes!!!) harddisk 8Gb SCSI2 Witch database do you use? Try to dump and then restore the databasefile to rebuild the Indexes Best regards Hi all, I'm using bacula for 2 months now and I'm doing some restore tests now that the volume of data is quite big. Actually, I'd like to restore a file but this takes an extremely long time, more than 2 hours to read the catalog. The catalog is 500Mo and the server is only backup server, 1.3Ghz PIII with 256 Mb or RAM. Do you think that this duration is normal or not ? Thanks in advance. -- Alejandro Alfonso Fernndez Dpto de Sistemas. rea Corporativa [EMAIL PROTECTED] http://www.telecyl.com/ Procin 7, Portales 1-2 Edificio Amrica II 28023 Madrid Tfn: 91 452 18 00 - Fax: 91 452 18 08 Juan Garca Hortelano, 43 Edificio Telecyl 47014 Valladolid Tfn: 983 428 200 - Fax: 983 428 223
[Bacula-users] add --enable-storage-only in Makefile?
Hello everybody, first off all, thanks kern for your job! our network has used bacula for 18 moths and we are so glad: more than a hundred TAPES, 10Gb stored each day... and everything working in armony! we use many clients (windows + linux) and a director (with three DATs). The director also has attached some tapes (DDS2, DDS4, DDS5, FileStorage) we have another system with a DDS4 tape used by bacula (bacula under gentoo under wmware) that only uses the storage daemon (bacula-sd) when compiling bacula from sources, we need a mysql instaled. But we only need the storage daemon. Could be possible to add a "--enable-storage-only" as the current "--enable-client-only" in the configure, that skip the need of mysql? thanks again! -- Alejandro Alfonso Fernndez Dpto de Sistemas. rea Corporativa [EMAIL PROTECTED] http://www.telecyl.com/ Procin 7, Portales 1-2 Edificio Amrica II 28023 Madrid Tfn: 91 452 18 00 - Fax: 91 452 18 08 Juan Garca Hortelano, 43 Edificio Telecyl 47014 Valladolid Tfn: 983 428 200 - Fax: 983 428 223
Re: [Bacula-users] restore
Hello! i'll use english to respond the cuestion, but we can talk in spanish in a private email my company uses a RAID5 disk... 400Gb. A full backup job takes about two days and near 13 tapes (more than 3 million files). An incremental backup only two hours. Make a 400Gb backup in a day with one tape its imposible in time parameters. My solution: slice the backups in two jobs, one per tape, and use incremental backups every nigth Regards! ok, I need to backup a lot of servers on my company. I have a server running bacula-dir and bacula-sd, and on this server i have two DDS-4 tape drives without autochargers. My problem is that i need to backup daily more than 400Gb. I want to use bacula to do this and i did the next aproach to the problem. "Nightly i backup the data to disk (i have no limations with disk space) and in the morning and evening y put this data on tapes changing it manually." is posible to use bcopy to copy de volumes on disk to tape?. I know is possible and it nor present to me to much problems. But, more important is posible restore the data from the tape? and how can i do that? -- Alejandro Alfonso Fernandez [EMAIL PROTECTED] Dpto. de Sistemas - Area Corporativa http://www.telecyl.com Ochandiano, 6-10 Ctr. Empr. "El Planto" Juan Garca Hortelano, 43 Edificio Telecyl 28023 Madrid 47014 Valladolid Tel.: 91 452 18 00 - Fax: 91 452 18 08 Tel.: 983 428 200 - Fax: 983 428 223 inline: firmaTelecyl.jpg