A test run of FRUEC using only data on 2019-09-20 showed a large discrepancy for Landing Page events and Banner Impressions between legacy and testing databases:
MariaDB [(none)]> select count(*) from pgehres.landingpageimpression_raw where timestamp >= '2019-09-20 20:00:00' and timestamp < '2019-09-20 22:00:00'; +----------+ | count(*) | +----------+ | 2401 | +----------+ 1 row in set (0.00 sec) MariaDB [(none)]> select count(*) from fruec.landingpageimpression_raw where timestamp >= '2019-09-20 20:00:00' and timestamp < '2019-09-20 22:00:00'; +----------+ | count(*) | +----------+ | 1076 | +----------+ 1 row in set (0.01 sec)
MariaDB [(none)]> select sum(count) from pgehres.bannerimpressions where timestamp >= '2019-09-20 20:00:00' and timestamp < '2019-09-20 22:00:00'; +------------+ | sum(count) | +------------+ | 720530 | +------------+ 1 row in set (0.03 sec) MariaDB [(none)]> select sum(count) from fruec.bannerimpressions where timestamp >= '2019-09-20 20:00:00' and timestamp < '2019-09-20 22:00:00'; +------------+ | sum(count) | +------------+ | 255530 | +------------+ 1 row in set (0.02 sec)
Both systems ingressed the same number of files for the period compared in the above queries:
MariaDB [(none)]> select count(*) from pgehres.squidlog where timestamp >= '2019-09-20 20:00:00' and timestamp < '2019-09-20 22:15:01'; +----------+ | count(*) | +----------+ | 18 | +----------+ 1 row in set (0.34 sec) MariaDB [(none)]> select count(*) from fruec.files where timestamp >= '2019-09-20 20:00:00' and timestamp < '2019-09-20 22:15:01'; +----------+ | count(*) | +----------+ | 18 | +----------+ 1 row in set (0.00 sec)