Hi Myroslav, any recommendations? Should I re-run ambari setup?
2015-09-21 9:44 GMT+02:00 <[email protected]>: > Hey, > > I'm upgrading from Ambari 2.0 to 2.1. There are no custom/modified > stacks in use. > > The "stack" table looks like this: > https://dl.dropboxusercontent.com/u/13919777/stack.gif > > Clusters: > https://dl.dropboxusercontent.com/u/13919777/cluster.gif > > > 2015-09-20 17:33 GMT+02:00 Myroslav Papyrkovskyy > <[email protected]>: >> Hello, can you post some additional info, like which version are you >> upgrading from and to? >> It looks like something went wrong and you have no data in "stack" table >> which had to be filled. >> Did you use custom/modified stacks? >> Can you share content of "clusters" and "stack" tables? >> >> -----Original Message----- >> From: [email protected] [mailto:[email protected]] >> Sent: Saturday, September 19, 2015 12:33 PM >> To: [email protected] >> Subject: Re: Oracle DB privileges >> >> Hi Myroslav, >> >> thanks for your help! The upgrade is still quite fiddly.. after setting the >> permissions, we had some trouble with the following >> errors: >> >> At first: >> 18 Sep 2015 15:13:39,913 ERROR [main] DBAccessorImpl:697 - Error executing >> query: ALTER TABLE hosts ADD CONSTRAINT UQ_hosts_host_name UNIQUE (host_name) >> java.sql.SQLSyntaxErrorException: ORA-02261: such unique or primary key >> already exists in the table >> >>> We were able to solve this by removing the unique attribute manually. >> >> Afterwards: >> 18 Sep 2015 15:14:12,973 ERROR [main] DBAccessorImpl:697 - Error executing >> query: ALTER TABLE repo_version DROP COLUMN stack >> java.sql.SQLException: ORA-12991: column is referenced in a multi-column >> constraint >> >>> We were able to solve this by removing the constraints manually. >> >> The upgrade went through a few more steps after solving this issue, but >> stopped with a NPE (which I don't know how to fix): >> >> 18 Sep 2015 15:35:26,601 INFO [main] >> AmbariManagementControllerImpl:286 - Initializing the >> AmbariManagementControllerImpl >> 18 Sep 2015 15:35:26,660 ERROR [main] SchemaUpgradeHelper:222 - Upgrade >> failed. >> java.lang.NullPointerException >> at org.apache.ambari.server.state.StackId.<init>(StackId.java:54) >> at >> org.apache.ambari.server.state.cluster.ClusterImpl.<init>(ClusterImpl.java:268) >> at >> org.apache.ambari.server.state.cluster.ClusterImpl$$EnhancerByGuice$$4f8773ad.<init>(<generated>) >> at >> org.apache.ambari.server.state.cluster.ClusterImpl$$EnhancerByGuice$$4f8773ad$$FastClassByGuice$$7964699e.newInstance(<generated>) >> at >> com.google.inject.internal.cglib.reflect.$FastConstructor.newInstance(FastConstructor.java:40) >> at >> com.google.inject.internal.ProxyFactory$ProxyConstructor.newInstance(ProxyFactory.java:260) >> at >> com.google.inject.internal.ConstructorInjector.construct(ConstructorInjector.java:85) >> at >> com.google.inject.internal.ConstructorBindingImpl$Factory.get(ConstructorBindingImpl.java:254) >> at com.google.inject.internal.InjectorImpl$4$1.call(InjectorImpl.java:978) >> at >> com.google.inject.internal.InjectorImpl.callInContext(InjectorImpl.java:1024) >> at com.google.inject.internal.InjectorImpl$4.get(InjectorImpl.java:974) >> at >> com.google.inject.assistedinject.FactoryProvider2.invoke(FactoryProvider2.java:632) >> at com.sun.proxy.$Proxy10.create(Unknown Source) at >> org.apache.ambari.server.state.cluster.ClustersImpl.loadClustersAndHosts(ClustersImpl.java:180) >> at >> org.apache.ambari.server.state.cluster.ClustersImpl.checkLoaded(ClustersImpl.java:168) >> at >> org.apache.ambari.server.state.cluster.ClustersImpl.getClusters(ClustersImpl.java:594) >> at >> org.apache.ambari.server.upgrade.AbstractUpgradeCatalog.addNewConfigurationsFromXml(AbstractUpgradeCatalog.java:266) >> at >> org.apache.ambari.server.upgrade.UpgradeCatalog210.executeDMLUpdates(UpgradeCatalog210.java:994) >> at >> org.apache.ambari.server.upgrade.AbstractUpgradeCatalog.upgradeData(AbstractUpgradeCatalog.java:536) >> at >> org.apache.ambari.server.upgrade.SchemaUpgradeHelper.executeDMLUpdates(SchemaUpgradeHelper.java:220) >> at >> org.apache.ambari.server.upgrade.SchemaUpgradeHelper.main(SchemaUpgradeHelper.java:297) >> >> >> We see some WARNs for multiple columns in the logs beforehand.. but I have >> no idea if this is connected: >> >> 18 Sep 2015 15:35:21,760 WARN [main] DBAccessorImpl:700 - Error executing >> query: ALTER TABLE repo_version ADD CONSTRAINT fk_repoversion_stack_id >> FOREIGN KEY (stack_id) REFERENCES stack (stack_id), errorCode = 2298, >> message = ORA-02298: cannot validate >> (F123.FK_REPOVERSION_STACK_ID) - parent keys not found >> >> Any idea how to fix this? Should I file a bug report? Please let me know if >> you need the log file. >> >> - Seb >> >> 2015-09-18 13:12 GMT+02:00 Myroslav Papyrkovskyy >> <[email protected]>: >>> Hello Seb. >>> Just took a look at docs, they seem to be outdated a bit. >>> Try following set of roles and privileges: >>> >>> CREATE TABLE, CREATE SEQUENCE, CREATE PROCEDURE, CREATE TRIGGER, >>> CREATE SESSION, UNLIMITED TABLESPACE >>> >>> SELECT_CATALOG_ROLE >>> >>> CONNECT, RESOURCE >>> >>> >>> I understand that some of them overlaps, but this set was verified to work. >>> IMO 1st 5 privileges can be dropped. >>> >>> -- >>> Regards, >>> Myroslav Papirkovskyi >>> ________________________________ >>> Від: [email protected] <[email protected]> >>> Надіслано: 18 вересня 2015 р. 12:47 >>> Кому: [email protected] >>> Тема: Oracle DB privileges >>> >>> >>> Hi, >>> >>> I am currently trying to Upgrade HDP 2.2 to 2.3 which starts with >>> upgrading Ambari to v2.1 beforehand. >>> I am using an Oracle 11g database which seems to be pretty >>> troublesome. The HDP docs state the following privileges: >>> >>> GRANT create session to <AMBARIUSER>; >>> GRANT create TABLE to <AMBARIUSER>; >>> GRANT create SEQUENCE to <AMBARIUSER>; >>> >>> But (at least for the upgrade process) these are not sufficient. I >>> needed to grant "drop any index" and "create any index" to the ambari >>> db user and I'm still having some issues. >>> >>> Is there a complete list which privileges are really necessary for >>> ambari to run/upgrade properly? I can't find anything in the docs. >>> >>> Thanks! >>> >>> - Seb >>
