Hello,

Le 21. 10. 14 17:10, Blake Dunlap a écrit :
> This sounds like a bug in bacula actually. It shouldn't follow
> recursion into the same structure, simply store the link and move on.

This is exactly what Bacula is doing with links, it means that here it's 
not links, but real directories probably created by some buggy
program.

One thing about the MySQL catalog, default indexes are using only the 
first 255 characters of the Path string, it means that on this case, the 
database engine might not be able to use the index properly if 
directories were too long. If you are using recent version of MySQL
with Innodb for example, you might want to increase this number.

Best Regards,

Eric


> -Blake
>
> On Tue, Oct 21, 2014 at 4:17 AM, Ulrich Leodolter
> <ulrich.leodolter AT obvsg DOT at> wrote:
>> Hi all,
>>
>> i found the root cause of the problem, it was simply a mysql performance
>> problem because auf special filesystem hierarchy on the users desktop.
>>
>> there was one directory which was recursively repeated inside itself.
>>
>> C:/Users/name/Desktop/Exercise Files/CSS Core Concepts
>> C:/Users/name/Desktop/Exercise Files/CSS Core Concepts/Exercise Files/CSS 
>> Core Concepts/
>> ...
>>
>> there was only one file inside "CSS Core Concepts" and six empty sub 
>> directories
>> Chapter_01 to Chapter_06.  this hierarchy was repeated up to path length of 
>> 4834.
>> very strange, maybe a zip file containing symlinks pointing to .  was 
>> unzipped on desktop.
>>
>> the join on path in the batch insert seems to perform very badly comparing 
>> about 27000
>> long path names like that.
>>
>> INSERT 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)
>>
>>
>> now we removed the almost empty tree "C:/Users/name/Desktop/Exercise Files"
>> and i am sure tomorrow the backup will finish in time without problems.
>>
>> Best regards
>> Ulrich
>>

------------------------------------------------------------------------------
Comprehensive Server Monitoring with Site24x7.
Monitor 10 servers for $9/Month.
Get alerted through email, SMS, voice calls or mobile push notifications.
Take corrective actions from your mobile device.
http://p.sf.net/sfu/Zoho
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users