You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ambari.apache.org by "Tom Beerbower (JIRA)" <ji...@apache.org> on 2012/12/07 22:23:20 UTC
[jira] [Updated] (AMBARI-1057) Can't reset ambari-server due to
fail drop/create database DDLs
[ https://issues.apache.org/jira/browse/AMBARI-1057?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Tom Beerbower updated AMBARI-1057:
----------------------------------
Attachment: AMBARI-1057.patch
> Can't reset ambari-server due to fail drop/create database DDLs
> ----------------------------------------------------------------
>
> Key: AMBARI-1057
> URL: https://issues.apache.org/jira/browse/AMBARI-1057
> Project: Ambari
> Issue Type: Sub-task
> Reporter: Tom Beerbower
> Assignee: Tom Beerbower
> Attachments: AMBARI-1057.patch
>
>
> 1. Perform install
> 2. Stop ambari server
> 3. ambari-server reset (which calls drop and create DDLs)
> 4. setup and start ambari-server
> 5. Can't login, says invalid username/database combo
> If I run the drop script directly on the DB, I get the following errors. So it isn't successfully dropping the database, and doesn't successfully create after, leaving server db in invalid state. Think need to CASCADE to the DROP TABLE commands...for example: DROP TABLE ambari.clusters CASCADE; I tested after adding CASCADE manually and was able to drop the database tables.
> {code}
> ambarirca=> \i /var/lib/ambari-server/resources/Ambari-DDL-Postgres-DROP.sql;
> psql (8.4.13)
> You are now connected to database "ambari".
> psql:/var/lib/ambari-server/resources/Ambari-DDL-Postgres-DROP.sql:2: ERROR: must be owner of relation clusterconfig
> psql:/var/lib/ambari-server/resources/Ambari-DDL-Postgres-DROP.sql:3: ERROR: must be owner of relation clusterservices
> ALTER TABLE
> ALTER TABLE
> ALTER TABLE
> psql:/var/lib/ambari-server/resources/Ambari-DDL-Postgres-DROP.sql:7: ERROR: must be owner of relation hostcomponentdesiredconfigmapping
> psql:/var/lib/ambari-server/resources/Ambari-DDL-Postgres-DROP.sql:8: ERROR: must be owner of relation hostcomponentdesiredconfigmapping
> psql:/var/lib/ambari-server/resources/Ambari-DDL-Postgres-DROP.sql:9: ERROR: must be owner of relation hostcomponentdesiredstate
> psql:/var/lib/ambari-server/resources/Ambari-DDL-Postgres-DROP.sql:10: ERROR: must be owner of relation hostcomponentdesiredstate
> ALTER TABLE
> ALTER TABLE
> ALTER TABLE
> psql:/var/lib/ambari-server/resources/Ambari-DDL-Postgres-DROP.sql:14: ERROR: must be owner of relation servicecomponentdesiredstate
> ALTER TABLE
> ALTER TABLE
> ALTER TABLE
> ALTER TABLE
> ALTER TABLE
> ALTER TABLE
> ALTER TABLE
> ALTER TABLE
> ALTER TABLE
> psql:/var/lib/ambari-server/resources/Ambari-DDL-Postgres-DROP.sql:24: ERROR: constraint "fk_user_roles_ldap_user" of relation "user_roles" does not exist
> ALTER TABLE
> psql:/var/lib/ambari-server/resources/Ambari-DDL-Postgres-DROP.sql:26: ERROR: cannot drop table ambari.clusters because other objects depend on it
> DETAIL: constraint fk_clusterconfig_cluster_id on table ambari.clusterconfig depends on table ambari.clusters
> constraint fk_clusterservices_cluster_id on table ambari.clusterservices depends on table ambari.clusters
> HINT: Use DROP ... CASCADE to drop the dependent objects too.
> psql:/var/lib/ambari-server/resources/Ambari-DDL-Postgres-DROP.sql:27: ERROR: cannot drop table ambari.clusterservices because other objects depend on it
> DETAIL: constraint fk_servicecomponentdesiredstate_service_name on table ambari.servicecomponentdesiredstate depends on table ambari.clusterservices
> HINT: Use DROP ... CASCADE to drop the dependent objects too.
> DROP TABLE
> DROP TABLE
> DROP TABLE
> psql:/var/lib/ambari-server/resources/Ambari-DDL-Postgres-DROP.sql:31: ERROR: cannot drop table ambari.hostcomponentdesiredstate because other objects depend on it
> DETAIL: constraint fk_hostcomponentdesiredconfigmapping_cluster_id on table ambari.hostcomponentdesiredconfigmapping depends on table ambari.hostcomponentdesiredstate
> HINT: Use DROP ... CASCADE to drop the dependent objects too.
> DROP TABLE
> psql:/var/lib/ambari-server/resources/Ambari-DDL-Postgres-DROP.sql:33: ERROR: cannot drop table ambari.hosts because other objects depend on it
> DETAIL: constraint fk_hostcomponentdesiredstate_host_name on table ambari.hostcomponentdesiredstate depends on table ambari.hosts
> HINT: Use DROP ... CASCADE to drop the dependent objects too.
> DROP TABLE
> psql:/var/lib/ambari-server/resources/Ambari-DDL-Postgres-DROP.sql:35: ERROR: cannot drop table ambari.servicecomponentdesiredstate because other objects depend on it
> DETAIL: constraint fk_hostcomponentdesiredstate_component_name on table ambari.hostcomponentdesiredstate depends on table ambari.servicecomponentdesiredstate
> HINT: Use DROP ... CASCADE to drop the dependent objects too.
> DROP TABLE
> DROP TABLE
> DROP TABLE
> psql:/var/lib/ambari-server/resources/Ambari-DDL-Postgres-DROP.sql:39: ERROR: cannot drop table ambari.users because other objects depend on it
> DETAIL: constraint fk_user_roles_user_id on table ambari.user_roles depends on table ambari.users
> HINT: Use DROP ... CASCADE to drop the dependent objects too.
> DROP TABLE
> DROP TABLE
> DROP TABLE
> DROP TABLE
> DROP TABLE
> psql:/var/lib/ambari-server/resources/Ambari-DDL-Postgres-DROP.sql:45: ERROR: cannot drop table ambari.clusterconfig because other objects depend on it
> DETAIL: constraint fk_hostcomponentdesiredconfigmapping_config_tag on table ambari.hostcomponentdesiredconfigmapping depends on table ambari.clusterconfig
> HINT: Use DROP ... CASCADE to drop the dependent objects too.
> DROP TABLE
> DROP SEQUENCE
> DROP SEQUENCE
> psql (8.4.13)
> You are now connected to database "ambarirca".
> psql:/var/lib/ambari-server/resources/Ambari-DDL-Postgres-DROP.sql:51: ERROR: must be owner of relation job
> psql:/var/lib/ambari-server/resources/Ambari-DDL-Postgres-DROP.sql:52: ERROR: must be owner of relation task
> psql:/var/lib/ambari-server/resources/Ambari-DDL-Postgres-DROP.sql:53: ERROR: must be owner of relation taskattempt
> psql:/var/lib/ambari-server/resources/Ambari-DDL-Postgres-DROP.sql:54: ERROR: must be owner of relation taskattempt
> psql:/var/lib/ambari-server/resources/Ambari-DDL-Postgres-DROP.sql:55: ERROR: must be owner of relation workflow
> psql:/var/lib/ambari-server/resources/Ambari-DDL-Postgres-DROP.sql:56: ERROR: must be owner of relation job
> psql:/var/lib/ambari-server/resources/Ambari-DDL-Postgres-DROP.sql:57: ERROR: must be owner of relation task
> psql:/var/lib/ambari-server/resources/Ambari-DDL-Postgres-DROP.sql:58: ERROR: must be owner of relation taskattempt
> psql:/var/lib/ambari-server/resources/Ambari-DDL-Postgres-DROP.sql:59: ERROR: must be owner of relation hdfsevent
> psql:/var/lib/ambari-server/resources/Ambari-DDL-Postgres-DROP.sql:60: ERROR: must be owner of relation mapreduceevent
> psql:/var/lib/ambari-server/resources/Ambari-DDL-Postgres-DROP.sql:61: ERROR: must be owner of relation clusterevent
> {code}
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira