Subject | Sweep isn't moving OIT |
---|---|
Author | |
Post date | 2019-11-26T20:25:59Z |
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!