10:52 a.m.
Hello, I'm upgrade oVirt from 4.3.10.4 to 4.4.10.7-1
The update was successful, but I noticed that a couple of days before the update, the
"samples" tables stopped clearing.
DWH is configured in Basic
cat /etc/ovirt-engine-dwh/ovirt-engine-dwhd.conf.d/10-setup-scale.conf
DWH_TABLES_KEEP_SAMPLES=24
DWH_TABLES_KEEP_HOURLY=720
DWH_TABLES_KEEP_DAILY=0
cat /var/log/ovirt-engine-dwh/ovirt-engine-dwhd.log
...
2022-08-22 15:13:41|ETL Service Started
ovirtEngineDbDriverClass|org.postgresql.Driver
ovirtEngineHistoryDbJdbcConnection|jdbc:postgresql://localhost:5432/ovirt_engine_history?sslfactory=org.postgresql.ssl.NonValidatingFactory
hoursToKeepDaily|0
hoursToKeepHourly|720
ovirtEngineDbPassword|**********************
runDeleteTime|3
ovirtEngineDbJdbcConnection|jdbc:postgresql://localhost:5432/engine?sslfactory=org.postgresql.ssl.NonValidatingFactory
runInterleave|60
limitRows|limit 1000
ovirtEngineHistoryDbUser|ovirt_engine_history
ovirtEngineDbUser|engine
deleteIncrement|10
timeBetweenErrorEvents|300000
hoursToKeepSamples|24
deleteMultiplier|1000
lastErrorSent|2011-07-03 12:46:47.000000
etlVersion|4.4.10
dwhAggregationDebug|true
...
2022-08-22
15:00:00|lxnXpZ|fKyuLo|lvrfJZ|130277|OVIRT_ENGINE_DWH|SampleTimeKeepingJob|_FvEy8LzqEeCaj-T1n0SCFw|4.4|Default||begin||
2022-08-22 15:00:00 Statistics sync ended. Duration: 394 milliseconds
2022-08-22 15:00:00 Aggregation to Hourly ended.
2022-08-22
15:01:00|lxnXpZ|fKyuLo|lvrfJZ|130277|OVIRT_ENGINE_DWH|SampleTimeKeepingJob|_FvEy8LzqEeCaj-T1n0SCFw|4.4|Default||end|success|60000
2022-08-22
15:01:00|9mBhki|fKyuLo|lvrfJZ|130277|OVIRT_ENGINE_DWH|SampleTimeKeepingJob|_FvEy8LzqEeCaj-T1n0SCFw|4.4|Default||begin||
...
# select * from history_configuration;
var_name | var_value | var_datetime
-------------------+-----------+------------------------
default_language | en_US |
firstSync | false | 2016-12-17 07:35:00+03
lastDayAggr | | 2022-08-18 01:00:00+03
MinimalETLVersion | 4.4.7 |
lastHourAggr | | 2022-08-22 15:00:00+03
HourlyAggFailed | false |
# select min(history_datetime),max(history_datetime) from public.host_samples_history;
min | max
----------------------------+--------------------------
2022-08-17 03:09:31.797+03 | 2022-08-22 18:43:00.1+03
# select min(history_datetime),max(history_datetime) from public.host_hourly_history;
min | max
------------------------+------------------------
2022-07-19 04:00:00+03 | 2022-08-22 16:00:00+03
# select min(history_datetime),max(history_datetime) from public.host_daily_history;
min | max
------------+------------
2022-08-17 | 2022-08-18
I tried сonfigгку the start time with DWH_DELETE_JOB_HOUR (UTC), but there was no result.
By enabling DWH_AGGREGATION_DEBUG=true
According to the logs, aggregation is on the clock, but cleaning doesn't start...
I would delete the data manually, but I'm not worried about data relatedness.