Subject Sweep isn't moving OIT
Author

Hi.

I'm having a problem while running manually sweep, it's not increasing OIT as expected.

Just to explain better:

I'm copying de DB as a backup, and I'm trying do sweep it, so I stopped Firebird, restarted, tried to sweep, stopped Fb again, tried to sweep with offline Fb server, tried gfix -mend, which found 3 warnings (0 fixed):


backup Thu Nov 14 18:27:53 2019
        Database: /db/db_no_sweep.fdb
        Validation started
        Warning: Relation has 2 orphan backversions {0 in use} in table CONTAS_A_RECEBER (247)
        Warning: Relation has 3 orphan backversions {0 in use} in table NFE_LOTE_DADOS (253)
        Warning: Relation has 8 orphan backversions {0 in use} in table NF_SAIDA_CAPA (575)
backup Thu Nov 14 18:53:44 2019
        Database: /db/db_no_sweep.fdb
        Validation finished: 0 errors, 3 warnings, 0 fixed

Tried to sweep again, but with no result too as you can see at Fb log:


backup Thu Nov 14 14:24:47 2019
        Sweep is started by SYSDBA
        OIT 54057265, OAT 104895361, OST 104895361, Next 104895361
backup Thu Nov 14 14:24:56 2019
        Sweep is finished
        OIT 54057265, OAT 104895361, OST 104895361, Next 104895362


I've got no error, no warning at all, any ideas?



Note: running gstat -data, I've got some tables with different number of swept pages from primary pages, example:

TDR$SYNC_NF_ENTRADA (604)
    Primary pointer page: 1297, Index root page: 1298
    Pointer pages: 5, data page slots: 13776
    Data pages: 13776, average fill: 83%
    Primary pages: 13776, secondary pages: 0, swept pages: 12609
    Empty pages: 7, full pages: 13645
    Fill distribution:
         0 - 19% = 7
        20 - 39% = 70
        40 - 59% = 21
        60 - 79% = 2107
        80 - 99% = 11571



Thanks!


Tracker: http://tracker.firebirdsql.org/browse/CORE-6188