Details
-
Bug
-
Status: Resolved
-
Blocker
-
Resolution: Fixed
-
2.5.1
-
None
Description
In DatabaseConsistencyCheckerHelper : There is a query that is executed to verify count of rows in hostcomponentstate and hostcomponentdesiredstate.
String GET_MERGED_TABLE_ROW_COUNT_QUERY = "select count FROM hostcomponentstate hcs " + "JOIN hostcomponentdesiredstate hcds ON hcs.service_name=hcds.service_name AND hcs.component_name=hcds.component_name AND hcs.host_id=hcds.host_id";
With service group changes, hostcomponentstate and hostcomponentdesiredstate has replaced service_name with service_id and added a column for service_group_id.
Fix: Use service_id and service_group_id in query.