ambari-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Swapan Shridhar (JIRA)" <j...@apache.org>
Subject [jira] [Resolved] (AMBARI-21963) Ambari-server gives database consistency error : ERROR: column hcs.service_name does not exis
Date Fri, 15 Sep 2017 04:41:02 GMT

     [ https://issues.apache.org/jira/browse/AMBARI-21963?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Swapan Shridhar resolved AMBARI-21963.
--------------------------------------
    Resolution: Fixed

> 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)

Mime
View raw message