I'm having trouble resolving a slowdown after the end of a job.
So I check the status of the client, have the following return:
xxxxx.com.br Version: 5.0.3 (04 August 2010) x86_64-slackware-linux-gnu slackware Slackware 13.37.0 Daemon started 21-Dec-14 06:54. Jobs: run=20 running=0.
Heap: heap=270,336 smbytes=88,939 max_bytes=250,626 bufs=76 max_bufs=774
Sizeof: boffset_t=8 size_t=8 debug=0 trace=0
Running Jobs:
Director connected at: 05-Jan-15 11:26
No Jobs running.
====
Terminated Jobs:
JobId Level Files Bytes Status Finished Name
======================================================================
48948 Full 121,675 9.750 G OK 05-Jan-15 10:56 xxxxx_backup
But I see the following status to the Director:
Running Jobs:
Console connected at 05-Jan-15 11:23
JobId Level Name Status
======================================================================
48948 Full xxxxxx_backup.2015-01-05_10.27.58_03 Dir inserting Attributes
When checking in the Database
(mysql), I view the query below running for a long time: (30 minutes)
show processlist;
+----+--------+-----------+--------+---------+------+--------------+------------------------------------------------------------------------------------------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----+--------+-----------+--------+---------+------+--------------+------------------------------------------------------------------------------------------------------+
| 3 | bacula | localhost | bacula | Sleep | 523 | | NULL |
| 4 | bacula | localhost | bacula | Query | 1843 | Sending data | INSERT INTO Filename (Name) SELECT a.Name FROM (SELECT DISTINCT Name FROM batch) AS a WHERE NOT EXIS |
| 7 | root | localhost | NULL | Query | 0 | NULL | show processlist |
+----+--------+-----------+--------+---------+------+--------------+------------------------------------------------------------------------------------------------------+
3 rows in set (0.00 sec)
For information, this client is an email server with many files. But to perform the test put to make the Backup only in a specific directory (Approx 10Gb).
Performing the backup of all this Server (1.1TB). the message Dir inserting Attributes
is on Director
appears on for more than 30 hours.