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. Is this a large number of files? 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 — Dan Langille
signature.asc
Description: Message signed with OpenPGP using GPGMail
------------------------------------------------------------------------------ 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
