Bacula-users

Re: [Bacula-users] Bacula director consumes all CPU after full backup

2012-11-05 05:16:57
Subject: Re: [Bacula-users] Bacula director consumes all CPU after full backup
From: Marco van Wieringen <mvw AT planets.elm DOT net>
To: bacula-users AT lists.sourceforge DOT net
Date: Mon, 5 Nov 2012 10:12:04 +0000 (UTC)
Felix Schwarz <felix.schwarz <at> oss.schwarz.eu> writes:

> "\r\0\0\0\3\0\241\0\2\335\1\277\0\241\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"...,
1024) = 1024
> [pid  1827] lseek(10, 40020992, SEEK_SET <unfinished ...>
> [pid  2636] <... nanosleep resumed> NULL) = 0
> [pid  1827] <... lseek resumed> )       = 40020992
> [pid  1468] <... nanosleep resumed> NULL) = 0
> [pid  2636] access("/var/spool/bacula/bacula.db-journal", F_OK <unfinished 
> ...>
> [pid  1827] read(10,  <unfinished ...>
> [pid  1468] access("/var/spool/bacula/bacula.db-journal", F_OK <unfinished 
> ...>
> [pid  2636] <... access resumed> )      = 0
> [pid  1827] <... read resumed>
> "\r\0\0\0\3\0\226\0\2\340\1\275\0\226\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"...,
1024) = 1024
> [pid  1468] <... access resumed> )      = 0
> 
Looks like its busy updating the sqlite database with backup info.
You probably have configured the system with attribute spooling which
means that after the backup is done the director needs to update the 
database with all the file data to be able to restore your backup.

First of all sqlite is just a proof of concept and should not be
used for production use a proper database like mysql or postgresql.
the SQLite code is also not very smart when it comes to doing lots
of updates and those databases are known to need some bandwidth of
your disks. Looking at the fact is also using a journal it could very
well be some severe contention on that journal when inserting lots of
files.

Marco


------------------------------------------------------------------------------
LogMeIn Central: Instant, anywhere, Remote PC access and management.
Stay in control, update software, and manage PCs from one command center
Diagnose problems and improve visibility into emerging IT issues
Automate, monitor and manage. Do more in less time with Central
http://p.sf.net/sfu/logmein12331_d2d
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users