Bacula-users

Re: [Bacula-users] Quick fix for Dir Inserting Attributes

2012-11-30 05:40:17
Subject: Re: [Bacula-users] Quick fix for Dir Inserting Attributes
From: Julien Cochennec <julien.cochennec AT mnhn DOT fr>
To: bacula-users AT lists.sourceforge DOT net
Date: Fri, 30 Nov 2012 11:37:28 +0100
On 30/11/2012 10:53, lst_hoe02 AT kwsoft DOT de wrote:
> Zitat von Julien Cochennec <julien.cochennec AT mnhn DOT fr>:
>
>> Hi Everybody,
>> I have a Dir Inserting Attribute (it's been 2 days now) so all my
>> backups are stuck because of this.
>> Is there a "quick fix", or even a "dirty fix" to get rid of this?
>> I saw solutions about compiling again without a batch-insert option, but
>> I really don't want to do that.
>> I can configure anything on mysql server to make things go faster.
>> Thanks.
> You really should be more specific about your problem:
> - Which Bacula version?
> - Installed from scratch or has it worked before?
> - What kind of Jobs are failing?
> - Any errror in the Bacula/Db/Systemlog?
>
> and so on...

Bacula version is 5.0.1
It worked since many month, almost one year, first time I get this problem.
The First Job that is "hanging" is many To (almost 4 To) and the others 
seem to be waiting for this one (?)
Mysqladmin processlist shows this :
| 1772 | bacula | localhost:58412 | bacula | Query   | 105617 | Sending 
data | INSERT INTO Path (Path) SELECT a.Path FROM (SELECT DISTINCT Path 
FROM batch) AS a WHERE NOT EXISTS ( |
| 1950 | bacula | localhost:58825 | bacula | Query   | 100362 | 
Locked       | LOCK TABLES Path write, batch write, Path as p write

Where is the /bacula/Db/Systemlog? I found no file like this on my server.

Thanks for your help.

>
> Normally inserting attributes, even many of them is not a problem so
> there is no "dirty fix" to apply.
>
> Regards
>
> Andreas
>
>
>
> ------------------------------------------------------------------------------
> Keep yourself connected to Go Parallel:
> TUNE You got it built. Now make it sing. Tune shows you how.
> http://goparallel.sourceforge.net
> _______________________________________________
> Bacula-users mailing list
> Bacula-users AT lists.sourceforge DOT net
> https://lists.sourceforge.net/lists/listinfo/bacula-users
>


------------------------------------------------------------------------------
Keep yourself connected to Go Parallel: 
TUNE You got it built. Now make it sing. Tune shows you how.
http://goparallel.sourceforge.net
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users