Zitat von Julien Cochennec <julien.cochennec AT mnhn DOT fr>:
> 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
Might be that MySQL is deadlocked, but i don't know MySQL enough to confirm...
> Where is the /bacula/Db/Systemlog? I found no file like this on my server.
This means search the Bacula log, the Database (MySQL) log and the OS
(Linux) system log for trouble. Your syslog configuration should tell
you where to find these log files.
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
|
