[Bacula-users] SQL errors from failed incremental backup - what happened?

2007-12-05 Thread Shon Stephens
All, I have a job which has failed the last few nights with the following errors: 03-Dec 20:00 mt-back4.director JobId 0: Fatal error: sql_create.c:489 sql_create.c:489 query SELECT ClientId,Uname FROM Client WHERE Name=' mt-back3.mentora' failed: Lost connection to MySQL server during query

Re: [Bacula-users] Recycle, full backup and tape append problem

2007-12-05 Thread Damian Brasher
Dan Langille wrote: Run the update volume command from bconsole. Set the number of files to be 201. background: the Catalog thinks there are 200 files on the Volume. The Volume actually has 201 files. You will be correcting this inconsistency with the above command. Thanks, this has

Re: [Bacula-users] Recycle, full backup and tape append problem

2007-12-05 Thread Dan Langille
On Wed, 5 Dec 2007, Damian Brasher wrote: I have a another issue on this list which is still unresolved as I am waiting for Gdb to pick up a re - occurrence of this separate error. This error has caused the problem above to be exasperated as bacula occasionally did not finish the last file of

[Bacula-users] mysql query for nextvol

2007-12-05 Thread tomasz dereszynski
hi all, i got quick question about it - can someone tell how to properly query mysql directly about next volume? mysql SELECT

Re: [Bacula-users] Bad response to Append Data command.

2007-12-05 Thread Martin Simmons
On Wed, 5 Dec 2007 11:36:33 -0500 (EST), Steve Thompson said: On Wed, 5 Dec 2007, [EMAIL PROTECTED] wrote: I am still experiencing this problem on a regular basis; not every job does this, but it seems a good 40% do each night. [...] 05-Dec 03:33 escabot-fd JobId 8219: Fatal error:

Re: [Bacula-users] Bad response to Append Data command.

2007-12-05 Thread Martin Simmons
On Wed, 5 Dec 2007 13:46:26 -0500 (EST), Steve Thompson said: On Wed, 5 Dec 2007, Dan Langille wrote: My first idea: different versions of SD and FD, with one trying to use a command the other does not recognize. What version is each of: bacula-dir, bacula-fd, bacula-sd They are

Re: [Bacula-users] Bad response to Append Data command.

2007-12-05 Thread marc . smith
On Wed, 5 Dec 2007, Steve Thompson wrote: On Wed, 5 Dec 2007, Martin Simmons wrote: On Wed, 5 Dec 2007 11:36:33 -0500 (EST), Steve Thompson said: I see this very often as well, and I am using disk exclusively. It also happens about 40% of the time, and has done since I started with bacula at

Re: [Bacula-users] Bad response to Append Data command.

2007-12-05 Thread Dan Langille
On Wed, 5 Dec 2007, Steve Thompson wrote: On Wed, 5 Dec 2007, Martin Simmons wrote: On Wed, 5 Dec 2007 11:36:33 -0500 (EST), Steve Thompson said: I see this very often as well, and I am using disk exclusively. It also happens about 40% of the time, and has done since I started with bacula at

Re: [Bacula-users] Email error message

2007-12-05 Thread jay
This was for Bacula 2.2.5 running on RHEL4 with MySQL 4.1. I do happen to have a pool named Monthly Pool. You are correct, there is a quoting error. If I adjust the quotes, I can get the query to work. Do I need to rename my pool? Jay On Dec 5, 2007 10:38 AM, Arno Lehmann [EMAIL PROTECTED]

[Bacula-users] Windows ACL's How To

2007-12-05 Thread Roy Vestal
I've been working with a local non-profit trying to get bacula working on their machines. I've been following the docs but the systems cannot connect to the file daemon. I'm wondering if someone has a simple how to on what the ACL's are and how they relate to the different conf files?

Re: [Bacula-users] Email error message

2007-12-05 Thread jay
The resource is Monthly Pool, with no quotes :-) Pool { Name = Monthly Pool Pool Type = Backup Recycle = no AutoPrune = yes Volume Retention = 1 years } On Dec 5, 2007 11:16 AM, Dan Langille [EMAIL PROTECTED] wrote: On Wed, 5 Dec 2007, Arno Lehmann wrote: Hi, 05.12.2007

Re: [Bacula-users] Email error message

2007-12-05 Thread Dan Langille
On Wed, 5 Dec 2007, Arno Lehmann wrote: Hi, 05.12.2007 17:59,, jay wrote:: This was for Bacula 2.2.5 running on RHEL4 with MySQL 4.1. Fairly recent... I do happen to have a pool named Monthly Pool. You meant, the pool is named with the quotes? I don't think Bacula supports that :-)

Re: [Bacula-users] Bad response to Append Data command.

2007-12-05 Thread Steve Thompson
On Wed, 5 Dec 2007, Martin Simmons wrote: On Wed, 5 Dec 2007 13:46:26 -0500 (EST), Steve Thompson said: They are all the same at 2.2.4. It happens even in the case where bacula-dir, bacula-fd and bacula-sd are running on the same machine. Everything was rebuilt from source by myself, and

Re: [Bacula-users] Recycle, full backup and tape append problem

2007-12-05 Thread Damian Brasher
Flak Magnet wrote: On Wednesday 05 December 2007 8:46:24 am Damian Brasher wrote: Thanks, this has started off last night missed jobs, however I have this message and still do not fully understand why the tape moves to the end of the last backup instead of starting from the beginning of

Re: [Bacula-users] Email error message

2007-12-05 Thread Arno Lehmann
Hi, 05.12.2007 17:59,, jay wrote:: This was for Bacula 2.2.5 running on RHEL4 with MySQL 4.1. Fairly recent... I do happen to have a pool named Monthly Pool. You meant, the pool is named with the quotes? I don't think Bacula supports that :-) You are correct, there is a quoting

Re: [Bacula-users] Bad response to Append Data command.

2007-12-05 Thread Steve Thompson
On Wed, 5 Dec 2007, Dan Langille wrote: My first idea: different versions of SD and FD, with one trying to use a command the other does not recognize. What version is each of: bacula-dir, bacula-fd, bacula-sd They are all the same at 2.2.4. It happens even in the case where bacula-dir,

Re: [Bacula-users] Bad response to Append Data command.

2007-12-05 Thread Steve Thompson
On Wed, 5 Dec 2007, [EMAIL PROTECTED] wrote: I am still experiencing this problem on a regular basis; not every job does this, but it seems a good 40% do each night. [...] 05-Dec 03:33 escabot-fd JobId 8219: Fatal error: job.c:1811 Bad response to Append Data command. Wanted 3000 OK data I

Re: [Bacula-users] Windows ACL's How To

2007-12-05 Thread John Drescher
On Dec 5, 2007 1:14 PM, Roy Vestal [EMAIL PROTECTED] wrote: I've been working with a local non-profit trying to get bacula working on their machines. I've been following the docs but the systems cannot connect to the file daemon. This is most likely caused by a firewall or a bad password. John

Re: [Bacula-users] Bad response to Append Data command.

2007-12-05 Thread marc . smith
On Wed, 5 Dec 2007, [EMAIL PROTECTED] wrote: I am still experiencing this problem on a regular basis; not every job does this, but it seems a good 40% do each night. [...] 05-Dec 03:33 escabot-fd JobId 8219: Fatal error: job.c:1811 Bad response to Append Data command. Wanted 3000 OK data

Re: [Bacula-users] Email error message

2007-12-05 Thread Arno Lehmann
Hi, 05.12.2007 15:10,, jay wrote:: All, I had an email sitting in my inbox this morning, that was generated by Bacula, but I'm not sure why or how. 04-Dec 11:32 cbtsscdb-dir JobId 0: Fatal error: sql_get.c:595 sql_get.c:595 query SELECT

Re: [Bacula-users] Recycle, full backup and tape append problem

2007-12-05 Thread Arno Lehmann
Hi, 05.12.2007 14:59,, Dan Langille wrote:: On Wed, 5 Dec 2007, Damian Brasher wrote: Dan Langille wrote: Run the update volume command from bconsole. Set the number of files to be 201. background: the Catalog thinks there are 200 files on the Volume. The Volume actually has 201 files.

Re: [Bacula-users] A question concerning backups to DVD

2007-12-05 Thread Kern Sibbald
Hello Georg, On Wednesday 05 December 2007 13:41, Georg C. F. Greve wrote: Hi all, allow me to ask one (potentially stupid) question about backing up to DVD, which I feel the urge to ask to avoid relying on a false understanding of how things work. I have a setup where a central server is

[Bacula-users] Slow Backup Speeds Using Bacula

2007-12-05 Thread Brad M
Hi there, I've been having some problems attempting to increase the write speed to my tape drive through Bacula. If I use the operating system to communicate directly with the tape drive, I get the appropriate read and write speeds but using Bacula, I get a third of the speed. I have tried

Re: [Bacula-users] Slow Backup Speeds Using Bacula

2007-12-05 Thread John Drescher
Hi there, I've been having some problems attempting to increase the write speed to my tape drive through Bacula. If I use the operating system to communicate directly with the tape drive, I get the appropriate read and write speeds but using Bacula, I get a third of the speed. I have

Re: [Bacula-users] auto labeling with python

2007-12-05 Thread Jason Joines
Jason Joines wrote: I'm using Bacula 2.2.5 and have tried auto labeling with LabelFormat but haven't had much luck. I don't know python but since LabelFormat is deprecated I thought I'd go ahead and give it a try. My goal is to get volume names ( and the corresponding file name on

[Bacula-users] Input/Ouput errors

2007-12-05 Thread Ed Davison
I get the following errors daily and cannot figure out where this is coming from. I have already resolved my earlier problem which was a bad IP address in the hosts file and services not running. A search of the archives showed a similar problem with a webserver with lots of little files and

[Bacula-users] performance issues

2007-12-05 Thread Bob Cregan
Hi We have just started to use bacula as our backup solution and are suffering some performance problems. The details are Server: Debian 4.0 running bacula 2.2.4 is multihomed as it backs up over two networks. Storage is Overland Arcvault24 on same host Database is mysql:

Re: [Bacula-users] Recycle, full backup and tape append problem

2007-12-05 Thread Flak Magnet
On Wednesday 05 December 2007 8:46:24 am Damian Brasher wrote: Thanks, this has started off last night missed jobs, however I have this message and still do not fully understand why the tape moves to the end of the last backup instead of starting from the beginning of the tape... I think it's

[Bacula-users] File records missing.

2007-12-05 Thread Ryszard Łach
Hi. I have a problem with missing file records. My configuration is as follows: disk-based backup, full backup run weekly, diff backup run daily, separate Pool records for Full and Diff backup for each client. File Retention = 60d Job Retention = 180d Diff Pool: AutoPrune = Yes

Re: [Bacula-users] Bad response to Append Data command.

2007-12-05 Thread marc . smith
I am still experiencing this problem on a regular basis; not every job does this, but it seems a good 40% do each night. I cleaned both of my tape drives last night, but I still get the fatal errors. Here is another example: 05-Dec 03:32 escabot-dir JobId 8219: BeforeJob: run command

[Bacula-users] Email error message

2007-12-05 Thread jay
All, I had an email sitting in my inbox this morning, that was generated by Bacula, but I'm not sure why or how. 04-Dec 11:32 cbtsscdb-dir JobId 0: Fatal error: sql_get.c:595 sql_get.c:595 query SELECT

[Bacula-users] Recycle, full backup and tape append problem

2007-12-05 Thread Damian Brasher
Hi List After a 2.2.5 rebuild I have a scenario where I am recycling tapes using a weekly cycle and pools for each day with more than one tape in the weekend pool. The problem I'm experiencing is that even using Volume Retention = 6 days in pool Def. my tapes are filling up, the tapes are