[jira] [Created] (AMBARI-1057) Can't reset ambari-server due to fail drop/create database DDLs

["Tom Beerbower (JIRA)" <ji...@apache.org>]

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