[pkg-bacula-devel] git push for 9.0.5 ready

[Sven Hartge]

Um 00:19 Uhr am 06.11.17 schrieb Sven Hartge:
> On 06.11.2017 00:09, Sven Hartge wrote:

>> Hmm. When I look at the databases directly I don't have
>> Pool.CacheRetention in my upgraded-9.0.5 database. But it should have
>> been there, if the correct upgrade script was used. It is in the 9.0.0
>> upgrade script for dbconfig in my 9.0.5 packages.
 
> I am retracing my steps again to make sure I didn't do anything 
> wrong/dumb/strange during my tests, including building a complete set of 
> new packages from scratch.

I think I need glasses. Pool.Cacheretention is there, just not where I 
looked for it:

Upgraded Database:

,----
| sqlite> .schema Pool
| CREATE TABLE Pool (
|    PoolId INTEGER,
|    Name VARCHAR(128) NOT NULL,
|    NumVols INTEGER UNSIGNED DEFAULT 0,
|    MaxVols INTEGER UNSIGNED DEFAULT 0,
|    UseOnce TINYINT DEFAULT 0,
|    UseCatalog TINYINT DEFAULT 1,
|    AcceptAnyVolume TINYINT DEFAULT 0,
|    VolRetention BIGINT UNSIGNED DEFAULT 0,
|    VolUseDuration BIGINT UNSIGNED DEFAULT 0,
|    MaxVolJobs INTEGER UNSIGNED DEFAULT 0,
|    MaxVolFiles INTEGER UNSIGNED DEFAULT 0,
|    MaxVolBytes BIGINT UNSIGNED DEFAULT 0,
|    AutoPrune TINYINT DEFAULT 0,
|    Recycle TINYINT DEFAULT 0,
|    ActionOnPurge     TINYINT    DEFAULT 0,
|    PoolType VARCHAR(20) NOT NULL,
|    LabelType TINYINT DEFAULT 0,
|    LabelFormat VARCHAR(128) NOT NULL,
|    Enabled TINYINT DEFAULT 1,
|    ScratchPoolId INTEGER UNSIGNED REFERENCES Pool DEFAULT 0,
|    RecyclePoolId INTEGER UNSIGNED REFERENCES Pool DEFAULT 0,
|    NextPoolId INTEGER UNSIGNED REFERENCES Pool DEFAULT 0,
|    MigrationHighBytes BIGINT UNSIGNED DEFAULT 0,
|    MigrationLowBytes BIGINT UNSIGNED DEFAULT 0,
|    MigrationTime BIGINT UNSIGNED DEFAULT 0, CacheRetention BIGINT UNSIGNED DEFAULT 0,
!!!-------------------------------------------^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
|    UNIQUE (Name),
|    PRIMARY KEY (PoolId)
|    );
| CREATE INDEX pool_name_idx on Pool (Name);
`----

There it is.

But in the freshly created database:

,----
| sqlite> .schema Pool
| CREATE TABLE Pool (
|    PoolId INTEGER,
|    Name VARCHAR(128) NOT NULL,
|    NumVols INTEGER UNSIGNED DEFAULT 0,
|    MaxVols INTEGER UNSIGNED DEFAULT 0,
|    UseOnce TINYINT DEFAULT 0,
|    UseCatalog TINYINT DEFAULT 1,
|    AcceptAnyVolume TINYINT DEFAULT 0,
|    CacheRetention BIGINT UNSIGNED DEFAULT 0,
!!!--^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
|    VolRetention BIGINT UNSIGNED DEFAULT 0,
|    VolUseDuration BIGINT UNSIGNED DEFAULT 0,
|    MaxVolJobs INTEGER UNSIGNED DEFAULT 0,
|    MaxVolFiles INTEGER UNSIGNED DEFAULT 0,
|    MaxVolBytes BIGINT UNSIGNED DEFAULT 0,
|    AutoPrune TINYINT DEFAULT 0,
|    Recycle TINYINT DEFAULT 0,
|    ActionOnPurge     TINYINT    DEFAULT 0,
|    PoolType VARCHAR(20) NOT NULL,
|    LabelType TINYINT DEFAULT 0,
|    LabelFormat VARCHAR(128) NOT NULL,
|    Enabled TINYINT DEFAULT 1,
|    ScratchPoolId INTEGER UNSIGNED REFERENCES Pool DEFAULT 0,
|    RecyclePoolId INTEGER UNSIGNED REFERENCES Pool DEFAULT 0,
|    NextPoolId INTEGER UNSIGNED REFERENCES Pool DEFAULT 0,
|    MigrationHighBytes BIGINT UNSIGNED DEFAULT 0,
|    MigrationLowBytes BIGINT UNSIGNED DEFAULT 0,
|    MigrationTime BIGINT UNSIGNED DEFAULT 0,
|    UNIQUE (Name),
|    PRIMARY KEY (PoolId)
|    );
| CREATE INDEX pool_name_idx on Pool (Name);
`----

Man, this is dumb.

Grüße,
Sven.