You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ambari.apache.org by "Myroslav Papirkovskyy (JIRA)" <ji...@apache.org> on 2014/06/19 22:41:25 UTC

[jira] [Resolved] (AMBARI-6210) Schema upgrade failed on CentOS 5

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

Myroslav Papirkovskyy resolved AMBARI-6210.
-------------------------------------------

    Resolution: Fixed

pushed to trunk

> Schema upgrade failed on CentOS 5
> ---------------------------------
>
>                 Key: AMBARI-6210
>                 URL: https://issues.apache.org/jira/browse/AMBARI-6210
>             Project: Ambari
>          Issue Type: Bug
>          Components: controller
>    Affects Versions: 1.6.1
>            Reporter: Myroslav Papirkovskyy
>            Assignee: Myroslav Papirkovskyy
>            Priority: Blocker
>             Fix For: 1.6.1
>
>
> Upgrade failing with postgres 8.1 due to different UPDATE syntax
> {noformat}
> 15:21:07,615  WARN [main] DBAccessorImpl:468 - Error executing query: UPDATE viewinstancedata AS vid SET view_instance_id = vi.view_instance_id FROM viewinstance AS vi WHERE vi.name = vid.view_instance_name AND vi.view_name = vid.view_name
> org.postgresql.util.PSQLException: ERROR: syntax error at or near "AS"
> {noformat}



--
This message was sent by Atlassian JIRA
(v6.2#6252)