ambari-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Tom Beerbower (JIRA)" <j...@apache.org>
Subject [jira] [Created] (AMBARI-1057) Can't reset ambari-server due to fail drop/create database DDLs
Date Fri, 07 Dec 2012 21:19:20 GMT
Tom Beerbower created AMBARI-1057:
-------------------------------------

             Summary: 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


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

Mime
View raw message