Hello,
I am new to Bacula, but I am slowing getting it working. I am using
Bacula 9.4.4 on Solaris and a remote MySQL server as the back end.
I have a couple of problem but will start with just the one for now. "SD
despooling Attributes" is taking forever for a full backup. I come from
using Networker software so am I expect to much?
For example the last tape write finished at 06:18:20 and 5hours later it
is still waiting...
*status dir
cronus-dir Version: 9.4.4 (28 May 2019) x86_64-pc-solaris2.11 solaris 5.11
Daemon started 25-Feb-20 15:42, conf reloaded 25-Feb-2020 15:42:25
Jobs: run=2, running=1 mode=0,0
Heap: heap=1,490,944 smbytes=184,229 max_bytes=196,057 bufs=548
max_bufs=607
Res: njobs=6 nclients=4 nstores=2 npools=3 ncats=1 nfsets=6 nscheds=2
Scheduled Jobs:
Level Type Pri Scheduled Job Name Volume
===================================================================================
Incremental Backup 10 26-Feb-20 23:05 BackupFilesrv IEF978
Incremental Backup 10 26-Feb-20 23:05 BackupEos IEF978
Incremental Backup 10 26-Feb-20 23:05 BackupPC-AW1 IEF978
====
Running Jobs:
Console connected at 26-Feb-20 11:14
JobId Type Level Files Bytes Name Status
======================================================================
15 Back Full 3,677,950 634.9 G BackupFilesrv SD despooling
Attributes
====
Terminated Jobs:
JobId Level Files Bytes Status Finished Name
====================================================================
14 Incr 1,406 639.2 M OK 25-Feb-20 00:45 BackupPC-AW1
17 Incr 318 62.03 M OK 26-Feb-20 00:34 BackupPC-AW1
16 Full 361,807 117.0 G OK 26-Feb-20 00:45 BackupEos
====
On MySQL Server I can see the inserts happening...
mysql> show processlist;
+-------+------------+--------------+----------+-------------+-------+---------------------------------------------------------------+------------------------------------------------------------------------------------------------------+
| Id | User | Host | db | Command | Time |
State | Info |
+-------+------------+--------------+----------+-------------+-------+---------------------------------------------------------------+------------------------------------------------------------------------------------------------------+
| 46212 | bacula | cronus:57598 | baculadb | Query | 0 | Sending
to client | INSERT INTO File
(FileIndex,JobId,PathId,FilenameId,LStat,MD5,DeltaSeq) VALUES
(2923256,15,469886,14 |
| 48920 | slave_user | apollo:56851 | NULL | Binlog Dump | 18402 |
Master has sent all binlog to slave; waiting for more updates | NULL |
| 51226 | root | localhost | NULL | Query | 0 |
starting | show
processlist |
+-------+------------+--------------+----------+-------------+-------+---------------------------------------------------------------+------------------------------------------------------------------------------------------------------+
3 rows in set (0.00 sec)
I think I have batch inserts on:
src/config.h:#define USE_BATCH_FILE_INSERT 1
But, HAVE_MYSQL_THREAD_SAFE is not set, but not sure if this is a
problem. Solaris does not use libmysqlclient_r.a so I have to use
MYSQL_LIBS="-L/usr/mysql/5.7/lib/amd64 -lmysqlclient"
src/config.h:/* #undef HAVE_MYSQL_THREAD_SAFE */
Any ideas?
Thanks,
Andrew
--
Andrew Watkins * Birkbeck, University of London * Computer Science *
* http://notallmicrosoft.blogspot.com *
* tel: 020 7631 6720 *
::e-mails are only read & actioned between 0900 and 1730 hours (Monday - Friday)
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
