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] [Commented] (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:comment-tabpanel&focusedCommentId=16167316#comment-16167316
] 

Swapan Shridhar commented on AMBARI-21963:
------------------------------------------

Committed to branch : branch-feature-AMBARI-14714

{code}
commit 12bf5e46372d0fa91bf86c0581ad82f15b54740b
Author: Swapan Shridhar <sshridhar@hortonworks.com>
Date:   Thu Sep 14 20:51:57 2017 -0700

    AMBARI-21963. Ambari-server gives database consistency error : ERROR: column hcs.service_name
does not exist.
{code}

> 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