Re: [Bacula-users] Quick fix for Dir Inserting Attributes
2012-11-30 05:40:17
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
|
|
|