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

Reply via email to