----------------------------------------------------------- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/32578/#review78072 -----------------------------------------------------------
Ship it! Ship It! - Myroslav Papirkovskyy On Березень 27, 2015, 6:37 після полудня, Andrew Onischuk wrote: > > ----------------------------------------------------------- > This is an automatically generated e-mail. To reply, visit: > https://reviews.apache.org/r/32578/ > ----------------------------------------------------------- > > (Updated Березень 27, 2015, 6:37 після полудня) > > > Review request for Ambari and Myroslav Papirkovskyy. > > > Bugs: AMBARI-10246 > https://issues.apache.org/jira/browse/AMBARI-10246 > > > Repository: ambari > > > Description > ------- > > 1. Setup ambari-server with postgres_external DB > 2. There is a warning for postgres embedded, setup perfomes successfully, > ambari-server does not start. > **WARNING: Before starting Ambari Server, you must run the following DDL > against the database to create the schema: > /var/lib/ambari-server/resources/Ambari-DDL-Postgres-EMBEDDED-CREATE.sql** > The job example : <http://linux-jenkins.qe.hortonworks.com:8080/job/Run- > Ambari-Setup/1385/console> > Pay attention to these errors while filling DB: > > > > BEGIN > psql:/tmp/Ambari-DDL-Postgres-CREATE.sql:893: ERROR: duplicate key value > violates unique constraint "ambari_sequences_pkey" > DETAIL: Key (sequence_name)=(upgrade_group_id_seq) already exists. > psql:/tmp/Ambari-DDL-Postgres-CREATE.sql:900: ERROR: current transaction > is aborted, commands ignored until end of transaction block > psql:/tmp/Ambari-DDL-Postgres-CREATE.sql:903: ERROR: current transaction > is aborted, commands ignored until end of transaction block > psql:/tmp/Ambari-DDL-Postgres-CREATE.sql:908: ERROR: current transaction > is aborted, commands ignored until end of transaction block > psql:/tmp/Ambari-DDL-Postgres-CREATE.sql:911: ERROR: current transaction > is aborted, commands ignored until end of transaction block > psql:/tmp/Ambari-DDL-Postgres-CREATE.sql:914: ERROR: current transaction > is aborted, commands ignored until end of transaction block > psql:/tmp/Ambari-DDL-Postgres-CREATE.sql:923: ERROR: current transaction > is aborted, commands ignored until end of transaction block > psql:/tmp/Ambari-DDL-Postgres-CREATE.sql:926: ERROR: current transaction > is aborted, commands ignored until end of transaction block > psql:/tmp/Ambari-DDL-Postgres-CREATE.sql:929: ERROR: current transaction > is aborted, commands ignored until end of transaction block > ROLLBACK > > > The db output : <http://pastebin.com/9ntw9CC3> > > > > ssh -o StrictHostKeyChecking=no -o UserKnownHostsFile=/dev/null -q -i > /grid/0/jenkins/workspace/Run-Ambari-Setup/build-utils/openstack-utils/accounts/hw-qe-keypair.pem > [email protected] "ambari-server setup --database=postgres > --databasehost=us-rare-mon-rhe6-5013-re-4.novalocal --databaseport=5432 > --databasename=ambari --databaseusername=ambari --databasepassword=bigdata > --java-home=/usr/lib/jvm/java-1.7.0-openjdk.x86_64 -s" > Using python /usr/bin/python2.6 > Setup ambari-server > Checking SELinux... > SELinux status is 'enabled' > SELinux mode is 'enforcing' > Temporarily disabling SELinux > WARNING: SELinux is set to 'permissive' mode and temporarily disabled. > OK to continue [y/n] (y)? > Customize user account for ambari-server daemon [y/n] (n)? > Adjusting ambari-server permissions and ownership... > Checking firewall status... > Checking JDK... > WARNING: JAVA_HOME /usr/lib/jvm/java-1.7.0-openjdk.x86_64 must be valid > on ALL hosts > WARNING: JCE Policy files are required for configuring Kerberos security. > If you plan to use Kerberos,please make sure JCE Unlimited Strength > Jurisdiction Policy Files are valid on all hosts. > Completing setup... > Configuring database... > Configuring database... > Configuring ambari database... > Configuring remote database connection properties... > WARNING: Before starting Ambari Server, you must run the following DDL > against the database to create the schema: > /var/lib/ambari-server/resources/Ambari-DDL-Postgres-EMBEDDED-CREATE.sql > Proceed with configuring remote database connection properties [y/n] (y)? > Extracting system views... > .ambari-admin-2.1.0.19.jar > .. > Adjusting ambari-server permissions and ownership... > Ambari Server 'setup' completed successfully. > > > > Starting ambari-server > Ambari Server running with administrator privileges. > Organizing resource files at /var/lib/ambari-server/resources... > Server PID at: /var/run/ambari-server/ambari-server.pid > Server out at: /var/log/ambari-server/ambari-server.out > Server log at: /var/log/ambari-server/ambari-server.log > Waiting for server start.................... > ERROR: Exiting with exit code -1. > > > Diffs > ----- > > ambari-server/src/main/resources/Ambari-DDL-Postgres-CREATE.sql cd4427f > > Diff: https://reviews.apache.org/r/32578/diff/ > > > Testing > ------- > > mvn clean test > > > Thanks, > > Andrew Onischuk > >
