[jira] [Created] (AMBARI-6643) Error upgrading from 1.6.0 to 1.6.1 using external Postgres DB

["Alejandro Fernandez (JIRA)" <ji...@apache.org>]

Alejandro Fernandez created AMBARI-6643:
-------------------------------------------

             Summary: Error upgrading from 1.6.0 to 1.6.1 using external Postgres DB
                 Key: AMBARI-6643
                 URL: https://issues.apache.org/jira/browse/AMBARI-6643
             Project: Ambari
          Issue Type: Bug
    Affects Versions: 1.6.1
            Reporter: Alejandro Fernandez
            Assignee: Alejandro Fernandez
             Fix For: 1.7.0


If a user has an external postgres database either without a schema, or a schema whose name is different from the database name, then running "ambari-server upgrade" fails.

The most common case is for an embedded postgres database, in which the database and schema name are the same, so this is not an issue.
However,  when using an external postgres database, it's likely that the schema is empty, so the upgrade fails due to a bug in which it expects the schema name to be the same as the database name.

{code}
14:16:57,584 INFO [main] SchemaUpgradeHelper:224 - Upgrading schema to target version = 1.6.1 
14:16:57,620 INFO [main] SchemaUpgradeHelper:233 - Upgrading schema from source version = 1.6.0 
14:16:57,623 INFO [main] SchemaUpgradeHelper:142 - Upgrade path: [{ ugradeCatalog: sourceVersion = 1.6.0, targetVersion = 1.6.1 }] 
14:16:57,623 INFO [main] SchemaUpgradeHelper:173 - Executing DDL upgrade... 
14:16:57,630 INFO [main] DBAccessorImpl:472 - Executing query: ALTER SCHEMA postgres OWNER TO "sc_ambari"; 
14:16:57,645 WARN [main] DBAccessorImpl:478 - Error executing query: ALTER SCHEMA postgres OWNER TO "sc_ambari"; 
org.postgresql.util.PSQLException: ERROR: schema "postgres" does not exist 
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2161) 
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1890) 
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) 
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:559) 
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:403) 
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:395) 
at org.apache.ambari.server.orm.DBAccessorImpl.executeQuery(DBAccessorImpl.java:475) 
at org.apache.ambari.server.orm.DBAccessorImpl.executeQuery(DBAccessorImpl.java:461) 
at org.apache.ambari.server.upgrade.AbstractUpgradeCatalog.changePostgresSearchPath(AbstractUpgradeCatalog.java:169) 
at org.apache.ambari.server.upgrade.AbstractUpgradeCatalog.upgradeSchema(AbstractUpgradeCatalog.java:252) 
at org.apache.ambari.server.upgrade.SchemaUpgradeHelper.executeUpgrade(SchemaUpgradeHelper.java:178) 
at org.apache.ambari.server.upgrade.SchemaUpgradeHelper.main(SchemaUpgradeHelper.java:238)
{code}

_ambari.properties_ had roughly the following values
{code}
server.jdbc.database=postgres 
server.jdbc.driver=org.postgresql.Driver 
server.jdbc.hostname=server 
server.jdbc.port=5432 
server.jdbc.properties.sslmode=verify-full 
server.jdbc.properties.ssl=true 
server.jdbc.rca.driver=org.postgresql.Driver 
server.jdbc.rca.url=jdbc:postgresql://server:5432/ambari?ssl=true;sslmode=verify-full 
server.jdbc.rca.user.name=sc_ambari 
server.jdbc.rca.user.passwd=/etc/ambari-server/conf/password.dat 
server.jdbc.schema=ambari 
server.jdbc.url=jdbc:postgresql://server:5432/ambari?ssl=true;sslmode=verify-full 
server.jdbc.user.name=sc_ambari 
server.jdbc.user.passwd=/etc/ambari-server/conf/password.dat 
{code}



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