[
https://issues.apache.org/jira/browse/AMBARI-21963?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Swapan Shridhar updated AMBARI-21963:
-------------------------------------
Attachment: AMBARI-21963.patch
> Ambari-server gives database consistency error : ERROR: column
> hcs.service_name does not exis
> ---------------------------------------------------------------------------------------------
>
> Key: AMBARI-21963
> URL: https://issues.apache.org/jira/browse/AMBARI-21963
> Project: Ambari
> Issue Type: Bug
> Components: ambari-server
> Affects Versions: 2.5.1
> Reporter: Swapan Shridhar
> Assignee: Swapan Shridhar
> Priority: Blocker
> Fix For: 3.0.0
>
> Attachments: AMBARI-21963.patch
>
>
> In DatabaseConsistencyCheckerHelper : There is a query that is executed to
> verify count of rows in *hostcomponentstate* and *hostcomponentdesiredstate*.
> {code}
> 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";
> {code}
> 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.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
