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] [Updated] (AMBARI-1057) Can't reset ambari-server due to fail drop/create database DDLs
Date Fri, 07 Dec 2012 21:23:20 GMT

     [ 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

Mime
View raw message