Hello Ulrich,
Perhaps Bacula 7.0.5 is incompatible with such an old Windows binary --
I cannot imagine, but it is a possibility. Since you can get a free
Bacula Enterprise 7.0.5 Windows file daemon from Bacula Systems (because
you are listed in the AUTHORS file), why don't you try it?
Best regards,
Kern
On 14-10-19 01:02 PM, Ulrich Leodolter wrote:
> Hello Dan,
>
> On Sat, 2014-10-18 at 13:32 -0400, Dan Langille wrote:
>> On Oct 18, 2014,
>> at 4:03 AM, Ulrich Leodolter <ulrich.leodolter AT obvsg DOT at> wrote:
>>
>>> Hello,
>>>
>>> we have Win7 backup which does not come to an end within MaxRunTime=12h.
>>> server runs 7.0.5 (28 July 2014), the client has installed the
>>> bacula-enterprise-win64-7.0.5.exe. but the problem started about 2
>>> months ago, at that time windows client 5.2.10 was installed on the
>>> machine.
>>>
>>> the backup itself is about 100GB compressed and seems to finish
>>> on the client after about 6 hours, below are the last messages of
>>> the job before it gets stuck.
>>>
>>> 2014-10-18 03:18:09 troll-sd JobId 635821: Committing spooled data to
>>> Volume "Backup-0779". Despooling 1,692,736,419 bytes ...
>>> 2014-10-18 03:18:18 troll-sd JobId 635821: Despooling elapsed time =
>>> 00:00:09, Transfer rate = 188.0 M Bytes/second
>>> 2014-10-18 03:18:19 troll-sd JobId 635821: Elapsed time=06:11:45, Transfer
>>> rate=4.691 M Bytes/second
>>> 2014-10-18 03:18:22 troll-sd JobId 635821: Sending spooled attrs to the
>>> Director. Despooling 603,449,667 bytes .
>>>
>>> mysql status at the same time:
>>>
>>> # echo "show full processlist" | mysql
>>> Id User Host db Command Time State Info
>>> 6854 bacula localhost bacula Sleep 522 NULL
>>> 6873 bacula localhost bacula Query 21143 Sending data
>>> 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)
>>> 6899 root localhost NULL Query 0 NULL show
>>> full processlist
>>>
>>>
>>> we have a bunch of other clients (about 30), a mixture of linux, win7 and
>>> mac powerpc.
>>> all other backups run without problems for years now. there are even
>>> larger backups,
>>> in size and in number of files.
>>>
>>>
>>> does anyone have an idea why this single batch insert does not complete?
>>>
>>> do i need to analyze the attrs spool file itself ?
>>>
>>> yesterday i optimized the bacula database, but that doesn't help.
>>> there must be something special in the attrs spool file which the
>>> mysql server can't handle. the server runs on standard CentOS 6.5 x86_64.
>> This is something which should be asked in the user mailing list, not the
>> devel mailing list. I am replying to that list instead.
>>
> Ok
>
>> Is this a large number of files?
>>
> about 750000, not very large.
>
>> I had something which took a while. I sped it up by giving PostgreSQL more
>> memory. Perhaps MySQL can do the same.
>>
>> Here’s what I did: https://plus.google.com/+DanLangille/posts/AKXoRido3U1
>>
> the mysql database is already optimized and has enough memory.
> backups up 4000000 files and 700GB run without problems.
>
> below are last job messages of the last failed jobs, it was canceled
> after 12 hours max run time.
>
> 2014-10-19 02:49:15 troll-sd JobId 635915: Elapsed time=05:43:32, Transfer
> rate=5.095 M Bytes/second
> 2014-10-19 02:49:16 troll-sd JobId 635915: Sending spooled attrs to the
> Director. Despooling 603,418,522 bytes ...
> 2014-10-19 09:05:43 troll-dir JobId 635915: Fatal error: Max run time
> exceeded. Job canceled.
> 2014-10-19 09:41:17 troll-dir JobId 635915: Error: Bacula troll-dir 7.0.5
> (28Jul14):
>
> the database shows already about 600k files for this jobs.
>
> mysql> select count(*) from File where JobId = '635915' and LStat is not
> null;
> +----------+
> | count(*) |
> +----------+
> | 616848 |
> +----------+
> 1 row in set (0.00 sec)
>
>
> is it possible that some special file attr brings the mysql datebase
> into troubles ? i really cant imagine. the mysql database is almost
> idle after first 600k have been inserted. there is no io traffic and
> cpu usage is also low.
>
> it seems i have to dump spooled attrs files tomorrow and compare to
> database to see at which attrs have been inserted and at which one it
> stops.
>
> has anyone a better idea how to debug this problem?
> i am little bit lost :) because in the last 6 years since
> i am using bacula i never run into a problem like this.
>
>
> 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
------------------------------------------------------------------------------
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
|
