Hello Kern, On Sun, 2014-10-19 at 15:50 -0400, Kern Sibbald wrote: > 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? >
thanks, but i already got the client download links. actually, as i noticed below, the enterprise client is already installed, but the problem started weeks before i upgraded to bacula-enterprise-win64-7.0.5.exe. i think it's not a client issue, more likely a mysql or server issue. Best regards Ulrich > 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.leodol...@obvsg.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@lists.sourceforge.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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
