On Mon, 27 Aug 2018 18:29:17 +0200 Radosław
Korzeniewski wrote:
> Until you show your queries as I done above I cannot
> judge here. :)
Attached.
To avoid potential misunderstandings:
Incremental estimates for local* work fine.
Incremental estimates for remote* fall back to Full.
The <unrelated> incremental jobs also estimate fine
but I have hidden them to avoid visual clutter.
FWIW: I have no idea why FileSetId=64 exists (as well
as many other older records in FileSet table which I
have used in the past and don't exist any more).
--
George
MariaDB [bacula]> select ClientId from Client where name='local-fd';
+----------+
| ClientId |
+----------+
| 5 |
+----------+
1 row in set (0.00 sec)
MariaDB [bacula]> select ClientId from Client where name='remote-fd';
+----------+
| ClientId |
+----------+
| 1 |
+----------+
1 row in set (0.00 sec)
MariaDB [bacula]> select * from FileSet where fileset='local_FileSet';
+-----------+---------------+------------------------+---------------------+
| FileSetId | FileSet | MD5 | CreateTime |
+-----------+---------------+------------------------+---------------------+
| 60 | local_FileSet | ElA2mS+TR9/dNnhML8/E5B | 2016-01-07 00:47:55 |
+-----------+---------------+------------------------+---------------------+
1 row in set (0.00 sec)
MariaDB [bacula]> select * from FileSet where fileset='remote_FileSet';
+-----------+----------------+------------------------+---------------------+
| FileSetId | FileSet | MD5 | CreateTime |
+-----------+----------------+------------------------+---------------------+
| 64 | remote_FileSet | XW/0wB//49w0pSdx1ihdJB | 2016-01-10 01:57:55 |
| 65 | remote_FileSet | a6Eub7/EM4/JhR1At5l+0A | 2018-08-07 01:49:36 |
+-----------+----------------+------------------------+---------------------+
2 rows in set (0.00 sec)
MariaDB [bacula]> SELECT StartTime, Job FROM Job WHERE JobStatus IN ('T','W')
AND Type='B' AND Level='F' AND Name='local-fd' AND ClientId=5 and FileSetId=60;
Empty set (0.00 sec)
MariaDB [bacula]> SELECT StartTime, Job FROM Job WHERE JobStatus IN ('T','W')
AND Type='B' AND Level='F' AND Name='remote-fd' AND ClientId=1 AND FileSetId=65;
Empty set (0.00 sec)
MariaDB [bacula]> SELECT * FROM Job WHERE Name='local-fd' AND ClientId=5;
Empty set (0.00 sec)
MariaDB [bacula]> SELECT * FROM Job WHERE Name='remote-fd' AND ClientId=1;
Empty set (0.00 sec)
MariaDB [bacula]> SELECT * FROM Job WHERE Name='local-fd';
Empty set (0.00 sec)
MariaDB [bacula]> SELECT * FROM Job WHERE Name='remote-fd';
Empty set (0.00 sec)
MariaDB [bacula]> SELECT StartTime, Job FROM Job WHERE JobStatus IN ('T','W')
AND Type='B' AND Level='F' AND ClientId=1;
+---------------------+--------------------------------------+
| StartTime | Job |
+---------------------+--------------------------------------+
| 2018-07-15 17:39:53 | remote_Backup.2018-07-15_17.39.48_31 |
+---------------------+--------------------------------------+
1 row in set (0.00 sec)
MariaDB [bacula]> SELECT StartTime, Job FROM Job WHERE JobStatus IN ('T','W')
AND Type='B' AND Level='F' AND ClientId=5;
+---------------------+----------------------------------------+
| StartTime | Job |
+---------------------+----------------------------------------+
| <unrelated> | <unrelated> |
| <unrelated> | <unrelated> |
| 2018-07-15 15:11:19 | local_Backup.2018-07-15_15.11.15_11 |
| <unrelated> | <unrelated> |
| <unrelated> | <unrelated> |
| <unrelated> | <unrelated> |
+---------------------+----------------------------------------+
6 rows in set (0.00 sec)
MariaDB [bacula]> describe Job;
+-----------------+---------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra
|
+-----------------+---------------------+------+-----+---------+----------------+
| JobId | int(10) unsigned | NO | PRI | NULL | auto_increment
|
| Job | tinyblob | NO | | NULL |
|
| Name | tinyblob | NO | MUL | NULL |
|
| Type | binary(1) | NO | | NULL |
|
| Level | binary(1) | NO | | NULL |
|
| ClientId | int(11) | YES | | 0 |
|
| JobStatus | binary(1) | NO | | NULL |
|
| SchedTime | datetime | YES | | NULL |
|
| StartTime | datetime | YES | | NULL |
|
| EndTime | datetime | YES | | NULL |
|
| RealEndTime | datetime | YES | | NULL |
|
| JobTDate | bigint(20) unsigned | YES | MUL | 0 |
|
| VolSessionId | int(10) unsigned | YES | | 0 |
|
| VolSessionTime | int(10) unsigned | YES | | 0 |
|
| JobFiles | int(10) unsigned | YES | | 0 |
|
| JobBytes | bigint(20) unsigned | YES | | 0 |
|
| ReadBytes | bigint(20) unsigned | YES | | 0 |
|
| JobErrors | int(10) unsigned | YES | | 0 |
|
| JobMissingFiles | int(10) unsigned | YES | | 0 |
|
| PoolId | int(10) unsigned | YES | | 0 |
|
| FileSetId | int(10) unsigned | YES | | 0 |
|
| PriorJobId | int(10) unsigned | YES | | 0 |
|
| PurgedFiles | tinyint(4) | YES | | 0 |
|
| HasBase | tinyint(4) | YES | | 0 |
|
| HasCache | tinyint(4) | YES | | 0 |
|
| Reviewed | tinyint(4) | YES | | 0 |
|
| Comment | blob | YES | | NULL |
|
+-----------------+---------------------+------+-----+---------+----------------+
27 rows in set (0.00 sec)
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users