Hi,
I made a base job, on a server which have above 200.000
files. After, I made a full backup for trying deduplication. The backup
works well and create a full backup with a big deduplication (above
90%).
But, at the end of the backup, normally bacula show a status
message, but the console is frozen and mysql is at 100% on CPU.
On
mysql I've got :
mysql> show
processlist;
+----+------+-----------+--------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+
|
Id | User | Host | db | Command | Time | State | Info
|
+----+------+-----------+--------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+
|
88 | root | localhost | bacula | Query | 2395 | COPYING TO TMP TABLE |
INSERT INTO BASEFILES (BASEJOBID, JOBID, FILEID, FILEINDEX) SELECT
B.JOBID AS BASEJOBID, 39 AS JOBID |
| 90 | root | localhost | bacula |
Sleep | 2395 | | NULL |
| 91 | root | localhost | NULL | Query | 0 |
NULL | show processlist
|
+----+------+-----------+--------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+
3
rows in set (0.00 sec)
Is it normal that the request is very long or
is it a bug ? Server is with Xeon 2Ghz CPU.
Thanks,
--
Nicolas
http://www.shivaserv.fr [1]
Links:
------
[1]
http://www.shivaserv.fr
------------------------------------------------------------------------------
This SF email is sponsosred by:
Try Windows Azure free for 90 days Click Here
http://p.sf.net/sfu/sfd2d-msazure
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users