The qos_processor probe is logging the following over and over:
Oct 07 09:51:20:380 [Qos Monitor Database Updater #13, qos_processor] Monitor update failed for '1007CE3033E3C02F23D8A0AFEFE3515942BB475E-hostname'
Release : 20.4
Excecute the following query - it should return no results:
select CONVERT(VARCHAR(41),HashBytes('SHA1', convert(varchar(1024), CONCAT(qos_data.qos,'#',qos_data.source,'#',qos_data.target,'#',qos_data.origin))),2), *
FROM S_QOS_DATA qos_data
INNER JOIN S_QOS_DATA T on qos_data.table_id = T.table_id
and T.checksum!=CONVERT(VARCHAR(41),HashBytes('SHA1', convert(varchar(1024),
CONCAT(qos_data.qos,'#',qos_data.source,'#',qos_data.target,'#',qos_data.origin))),2)
order by qos_data.created desc;
If it in fact returns results this indicates that a script which was intended to update checksums as part of the 8.51->9.02 upgrade had failed.
Run the following query to correct the issue:
- stop data_engine
- execute query:
update qos_data
set checksum = CONVERT(VARCHAR(41),HashBytes('SHA1', convert(varchar(1024),
CONCAT(qos_data.qos,'#',qos_data.source,'#',qos_data.target,'#',qos_data.origin))),2)
FROM S_QOS_DATA qos_data
INNER JOIN S_QOS_DATA T on qos_data.table_id = T.table_id
and T.checksum!=CONVERT(VARCHAR(41),HashBytes('SHA1', convert(varchar(1024),
CONCAT(qos_data.qos,'#',qos_data.source,'#',qos_data.target,'#',qos_data.origin))),2);
- start data_engine
This will fix the checksums and resolve the errors.