[ovirt-users] ETL service aggregation to hourly tables has encountered an error. Please consult the service log for more details.
Dears, I have an a some error in Ovirt 4.2.7 In dash I see: ETL service aggregation to hourly tables has encountered an error. Please consult the service log for more details. In log ovirt engine server: 2019-01-14 15:59:59|rwL6AB|euUXph|wfcjQ7|OVIRT_ENGINE_DWH|HourlyTimeKeepingJob|Default|5|tWarn|tWarn_1|2019-01-14 15:59:59| ETL service aggregation to hourly tables has encountered an error. lastHourAgg value =Mon Jan 14 14:00:00 EET 2019 and runTime = Mon Jan 14 15:59:59 EET 2019 .Please consult the service log for more details.|42 In some sources people said the problem is in PostgreSQL DB, but I don't understand how can I fix this problem? Thanks ___ Users mailing list -- users@ovirt.org To unsubscribe send an email to users-le...@ovirt.org Privacy Statement: https://www.ovirt.org/site/privacy-policy/ oVirt Code of Conduct: https://www.ovirt.org/community/about/community-guidelines/ List Archives: https://lists.ovirt.org/archives/list/users@ovirt.org/message/AL37NHAJ44IMTGA4GLP7XIEYZUAUDCZ6/
[ovirt-users] Re: ETL service aggregation to hourly tables has encountered an error. Please consult the service log for more details.
2018-10-22 17:58:40|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|30 hoursToKeepSamples|24 deleteMultiplier|1000 lastErrorSent|2011-07-03 12:46:47.00 etlVersion|4.2.4.3 dwhAggregationDebug|false dwhUuid|69462636-22a6-4aae-9703-70ce55856985 ovirtEngineHistoryDbDriverClass|org.postgresql.Driver ovirtEngineHistoryDbPassword|** 2018-10-23 16:59:59|QUC3MI|Ho8HCn|yvpC89|OVIRT_ENGINE_DWH|HourlyTimeKeepingJob|Default|5|tWarn|tWarn_1|2018-10-23 16:59:59| ETL service aggregation to hourly tables has encountered an error. lastHourAgg value =Tue Oct 23 15:00:00 EEST 2018 and runTime = Tue Oct 23 16:59:59 EEST 2018 .Please consult the service log for more details.|42 2018-10-24 17:59:59|xMmYXu|Ho8HCn|yvpC89|OVIRT_ENGINE_DWH|HourlyTimeKeepingJob|Default|5|tWarn|tWarn_1|2018-10-24 17:59:59| ETL service aggregation to hourly tables has encountered an error. lastHourAgg value =Wed Oct 24 16:00:00 EEST 2018 and runTime = Wed Oct 24 17:59:59 EEST 2018 .Please consult the service log for more details.|42 2018-10-25 16:59:59|cUcnsD|Ho8HCn|yvpC89|OVIRT_ENGINE_DWH|HourlyTimeKeepingJob|Default|5|tWarn|tWarn_1|2018-10-25 16:59:59| ETL service aggregation to hourly tables has encountered an error. lastHourAgg value =Thu Oct 25 15:00:00 EEST 2018 and runTime = Thu Oct 25 16:59:59 EEST 2018 .Please consult the service log for more details.|42 2018-10-25 17:59:59|eJkgGv|Ho8HCn|yvpC89|OVIRT_ENGINE_DWH|HourlyTimeKeepingJob|Default|5|tWarn|tWarn_1|2018-10-25 17:59:59| ETL service aggregation to hourly tables has encountered an error. lastHourAgg value =Thu Oct 25 16:00:00 EEST 2018 and runTime = Thu Oct 25 17:59:59 EEST 2018 .Please consult the service log for more details.|42 2018-10-25 20:59:58|Sc5Lfp|Ho8HCn|yvpC89|OVIRT_ENGINE_DWH|HourlyTimeKeepingJob|Default|5|tWarn|tWarn_1|2018-10-25 20:59:58| ETL service aggregation to hourly tables has encountered an error. lastHourAgg value =Thu Oct 25 19:00:00 EEST 2018 and runTime = Thu Oct 25 20:59:58 EEST 2018 .Please consult the service log for more details.|42 2018-10-26 01:59:59|TQ4s8m|Ho8HCn|yvpC89|OVIRT_ENGINE_DWH|HourlyTimeKeepingJob|Default|5|tWarn|tWarn_1|2018-10-26 01:59:59| ETL service aggregation to hourly tables has encountered an error. lastHourAgg value =Fri Oct 26 00:00:00 EEST 2018 and runTime = Fri Oct 26 01:59:59 EEST 2018 .Please consult the service log for more details.|42 2018-10-26 15:59:55|Tiv1gZ|Ho8HCn|yvpC89|OVIRT_ENGINE_DWH|HourlyTimeKeepingJob|Default|5|tWarn|tWarn_1|2018-10-26 15:59:55| ETL service aggregation to hourly tables has encountered an error. lastHourAgg value =Fri Oct 26 14:00:00 EEST 2018 and runTime = Fri Oct 26 15:59:55 EEST 2018 .Please consult the service log for more details.|42 2018-10-27 22:59:59|tsRtk4|Ho8HCn|yvpC89|OVIRT_ENGINE_DWH|HourlyTimeKeepingJob|Default|5|tWarn|tWarn_1|2018-10-27 22:59:59| ETL service aggregation to hourly tables has encountered an error. lastHourAgg value =Sat Oct 27 21:00:00 EEST 2018 and runTime = Sat Oct 27 22:59:59 EEST 2018 .Please consult the service log for more details.|42 2018-10-28 03:00:00|We7dPQ|Ho8HCn|yvpC89|OVIRT_ENGINE_DWH|HourlyTimeKeepingJob|Default|5|tWarn|tWarn_1|2018-10-28 03:00:00| ETL service aggregation to hourly tables has encountered an error. lastHourAgg value =Sun Oct 28 03:00:00 EET 2018 and runTime = Sun Oct 28 03:00:00 EET 2018 .Please consult the service log for more details.|42 2018-10-28 03:00:14|c3NnXS|Ho8HCn|yvpC89|OVIRT_ENGINE_DWH|SampleTimeKeepingJob|Default|5|tWarn|tWarn_1|Can not sample data, oVirt Engine is not updating the statistics. Please check your oVirt Engine status.|9704 2018-10-28 03:01:19|3CFZLf|Ho8HCn|yvpC89|OVIRT_ENGINE_DWH|SampleTimeKeepingJob|Default|5|tWarn|tWarn_1|Can not sample data, oVirt Engine is not updating the statistics. Please check your oVirt Engine status.|9704 2018-10-28 03:02:24|gt6fSU|Ho8HCn|yvpC89|OVIRT_ENGINE_DWH|SampleTimeKeepingJob|Default|5|tWarn|tWarn_1|Can not sample data, oVirt Engine is not updating the statistics. Please check your oVirt Engine status.|9704 2018-10-28 03:03:29|TzjHed|Ho8HCn|yvpC89|OVIRT_ENGINE_DWH|SampleTimeKeepingJob|Default|5|tWarn|tWarn_1|Can not sample data, oVirt Engine is not updating the statistics. Please check your oVirt Engine status.|9704 2018-10-28 03:04:34|cK2IFe|Ho8HCn|yvpC89|OVIRT_ENGINE_DWH|SampleTimeKeepingJob|Default|5|tWarn|tWarn_1|Can not sample data, oVirt Engine is not updating the statistics. Please
[ovirt-users] Re: ETL service aggregation to hourly tables has encountered an error. Please consult the service log for more details.
Dears, Could you answer how can I fix my problem? Thanks ___ Users mailing list -- users@ovirt.org To unsubscribe send an email to users-le...@ovirt.org Privacy Statement: https://www.ovirt.org/site/privacy-policy/ oVirt Code of Conduct: https://www.ovirt.org/community/about/community-guidelines/ List Archives: https://lists.ovirt.org/archives/list/users@ovirt.org/message/VQ6MWBWX2NAR7MEH4KCK3AO4TAHK3A46/
[ovirt-users] Re: ETL service aggregation to hourly tables has encountered an error. Please consult the service log for more details.
All is works, thank you ___ Users mailing list -- users@ovirt.org To unsubscribe send an email to users-le...@ovirt.org Privacy Statement: https://www.ovirt.org/site/privacy-policy/ oVirt Code of Conduct: https://www.ovirt.org/community/about/community-guidelines/ List Archives: https://lists.ovirt.org/archives/list/users@ovirt.org/message/RDWH25IYNTX4YMRUEEHHNLSL5VNRU6RI/
[ovirt-users] Re: Nodes in CentOS 8.3 and oVirt 4.4.3.12-1.el8 but not able to update cluster version
Dears, I have the same problem, but another one error:
On my pre-production stand with one node in cluster, I was set hode to
maintenance, and after try update cluster to 4.5 i see: Error while executing
action: Cannot change Cluster compatibility version where there are no hosts in
the Cluster which support that version.
ENGINE LOG: 2020-12-11 15:48:26,338+02 INFO
[org.ovirt.engine.core.bll.UpdateClusterCommand] (default task-1)
[383d1f09-039d-4737-9e8d-9b2490717bd8] Updating cluster CPU flags and verb
according to the configuration of the Intel Westmere Family cpu
2020-12-11 15:48:26,347+02 INFO
[org.ovirt.engine.core.bll.UpdateClusterCommand] (default task-1)
[383d1f09-039d-4737-9e8d-9b2490717bd8] Lock Acquired to object
'EngineLock:{exclusiveLocks='[]',
sharedLocks='[9abc1d61-829e-470b-b6c8-ad5aec769869=VM]'}'
2020-12-11 15:48:26,389+02 WARN
[org.ovirt.engine.core.bll.UpdateClusterCommand] (default task-1)
[383d1f09-039d-4737-9e8d-9b2490717bd8] Validation of action 'UpdateCluster'
failed for user smelnyk@internal-authz. Reasons:
VAR__TYPE__CLUSTER,VAR__ACTION__UPDATE,CLUSTER_CANNOT_UPDATE_VERSION_WHEN_NO_HOST_SUPPORTS_THE_VERSION
2020-12-11 15:48:26,390+02 INFO
[org.ovirt.engine.core.bll.UpdateClusterCommand] (default task-1)
[383d1f09-039d-4737-9e8d-9b2490717bd8] Lock freed to object
'EngineLock:{exclusiveLocks='[]',
sharedLocks='[9abc1d61-829e-470b-b6c8-ad5aec769869=VM]'}'
HOST:
OS Version:
RHEL - 8.3 - 1.2011.el8
OS Description:
CentOS Linux 8
Kernel Version:
4.18.0 - 240.1.1.el8_3.x86_64
KVM Version:
4.2.0 - 34.module_el8.3.0+555+a55c8938
LIBVIRT Version:
libvirt-6.0.0-28.module_el8.3.0+555+a55c8938
VDSM Version:
vdsm-4.40.35.1-1.el8
SPICE Version:
0.14.3 - 3.el8
GlusterFS Version:
[N/A]
CEPH Version:
librbd1-12.2.7-9.el8
Open vSwitch Version:
[N/A]
Nmstate Version:
nmstate-0.3.6-2.el8
Kernel Features:
MDS: (Vulnerable: Clear CPU buffers attempted, no microcode; SMT vulnerable),
L1TF: (Mitigation: PTE Inversion; VMX: conditional cache flushes, SMT
vulnerable), SRBDS: (Not affected), MELTDOWN: (Mitigation: PTI), SPECTRE_V1:
(Mitigation: usercopy/swapgs barriers and __user pointer sanitization),
SPECTRE_V2: (Mitigation: Full generic retpoline, IBPB: conditional, IBRS_FW,
STIBP: conditional, RSB filling), ITLB_MULTIHIT: (KVM: Mitigation: Split huge
pages), TSX_ASYNC_ABORT: (Not affected), SPEC_STORE_BYPASS: (Mitigation:
Speculative Store Bypass disabled via prctl and seccomp)
VNC Encryption:
Disabled
FIPS mode enabled:
Disabled
___
Users mailing list -- users@ovirt.org
To unsubscribe send an email to users-le...@ovirt.org
Privacy Statement: https://www.ovirt.org/privacy-policy.html
oVirt Code of Conduct:
https://www.ovirt.org/community/about/community-guidelines/
List Archives:
https://lists.ovirt.org/archives/list/users@ovirt.org/message/EN3OFPDS4N2UAPHT2TT7MFT2EXHP4AUM/
[ovirt-users] Ovirt 4.4 ilo_ssh version HP ILO3. ERROR: Unable to connect/login to fencing device
Dears, I have a 3 nodes with HP blade servers G7 and ILO3. ILO3 with the latest firmware 1.93 from Aug 07 2020. I'm try to migrate from Ovirt 4.3 to 4.4 with Centos 8, but I had a problem with setup ssh ilo fence on this nodes. In Ovirt 4.3 with Centos 7 all is works. When I try to Test fence, I see ERROR: Unable to connect/login to fencing device. When I try to use /usr/sbin/fence_ilo_ssh I see the same error. So, I know where is a problem. The problem in an old ssh security keys HostKeyAlgorithms=+ssh-dss. When I add to /root/.ssh/config some exclude for use HostKeyAlgorithms=+ssh-dss I can connect to ilo over ssh from root with: /usr/sbin/fence_ilo_ssh -a 10.0.11.157 -l user -p passwordh -x -u 22 --login-timeout=10 -o status and see: Status: ON But when I try again setup ilo_ssh fence in Ovirt-engine UI I still have the same ERROR: Unable to connect/login to fencing device. How can I solve this problem in Ovirt? Thanks ___ Users mailing list -- users@ovirt.org To unsubscribe send an email to users-le...@ovirt.org Privacy Statement: https://www.ovirt.org/privacy-policy.html oVirt Code of Conduct: https://www.ovirt.org/community/about/community-guidelines/ List Archives: https://lists.ovirt.org/archives/list/users@ovirt.org/message/MXTHTG6QQNY762BJSARBF5SHHMVUH42Y/
[ovirt-users] Re: Ovirt 4.4 ilo_ssh version HP ILO3. ERROR: Unable to connect/login to fencing device
Dears, So, I found solution. Logically if Ovirt used user vdsm on hosts, and vdsm placed on host I find dir /var/lib/vdsm/.ssh Then I create in /var/lib/vdsm/.ssh file config with strings: Host * HostKeyAlgorithms=+ssh-dss And after this actions the test of ssh ilo fence is OK. I don't know is this solution correct? May be you know another, more correct way for solve this problem? Thanks ___ Users mailing list -- users@ovirt.org To unsubscribe send an email to users-le...@ovirt.org Privacy Statement: https://www.ovirt.org/privacy-policy.html oVirt Code of Conduct: https://www.ovirt.org/community/about/community-guidelines/ List Archives: https://lists.ovirt.org/archives/list/users@ovirt.org/message/VVUR33BTHPFZO65DZZX4FNZVLB65ASOM/
