[
https://issues.apache.org/jira/browse/AMBARI-17611?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15366598#comment-15366598
]
Hadoop QA commented on AMBARI-17611:
------------------------------------
{color:red}-1 overall{color}. Here are the results of testing the latest
attachment
http://issues.apache.org/jira/secure/attachment/12816677/AMBARI-17611.branch-2.4.patch
against trunk revision .
{color:red}-1 patch{color}. The patch command could not apply the patch.
Console output:
https://builds.apache.org/job/Ambari-trunk-test-patch/7731//console
This message is automatically generated.
> DB setup fails for SQLServer due to incorrect table schema definition for
> extensionlink
> ---------------------------------------------------------------------------------------
>
> Key: AMBARI-17611
> URL: https://issues.apache.org/jira/browse/AMBARI-17611
> Project: Ambari
> Issue Type: Bug
> Components: ambari-server
> Affects Versions: 2.4.0
> Reporter: Alejandro Fernandez
> Assignee: Alejandro Fernandez
> Priority: Critical
> Fix For: 2.4.0
>
> Attachments: AMBARI-17611.branch-2.4.patch, AMBARI-17611.trunk.patch
>
>
> Ambari db setup is failing on SQLServer,
> {code}
> 2016-07-06 22:54:54,209 - setup_ambari_db.py [2922] __main__ - INFO - Found
> ambari db related settings. jdbc connection string =
> jdbc:sqlserver://gy843wvttf.database.windows.net;databaseName=hdfspromdev60165c06b1904860934d820f20c3615dAmbariDb;user=hdfspromdev60165c06b1904860934d820f20c3615dambaridblo...@gy843wvttf.database.windows.net;password=**HIDDEN**;trustServerCertificate=false;encrypt=true;hostNameInCertificate=*.database.windows.net
> 2016-07-06 22:54:54,210 - setup_ambari_db.py [2922] __main__ - INFO - Running
> command: sudo java -jar /usr/lib/hdinsight-common/setup-ambari-db-1.0.jar
> **HIDDEN** /var/lib/ambari-server/resources/Ambari-DDL-SQLServer-CREATE.sql
> hdinsightwatchdog **HIDDEN** admin **HIDDEN**
> 2016-07-06 22:54:56,459 - setup_ambari_db.py [2922] __main__ - ERROR - Failed
> to execute command. exit code = 1
> , out=Starting setting up ambari db...
> Loading Sql JDBC driver
> Reading table creation sql file:
> /var/lib/ambari-server/resources/Ambari-DDL-SQLServer-CREATE.sql
> Finished loading file
> /var/lib/ambari-server/resources/Ambari-DDL-SQLServer-CREATE.sql
> Trying to create a jdbc connection
> Connection to db established
> Connection auto commit is disabled
> Check if ambari db (sql azure) schema has been set up ...
> Ambari db (sql azure) schema needs to be set up ...
> , error=com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax
> near ';'.
> at
> com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:215)
> at
> com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1635)
> at
> com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:865)
> at
> com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:762)
> at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5846)
> at
> com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1719)
> at
> com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:184)
> at
> com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:159)
> at
> com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServerStatement.java:735)
> at com.microsoft.SetupAmbariDb.executeQuery(Unknown Source)
> at com.microsoft.SetupAmbariDb.setupAmbariTables(Unknown Source)
> at com.microsoft.SetupAmbariDb.setup(Unknown Source)
> at com.microsoft.SetupAmbariDb.main(Unknown Source)
> Failed to setup Ambari Db
> com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near ';'.
> at
> com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:215)
> at
> com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1635)
> at
> com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:865)
> at
> com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:762)
> at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5846)
> at
> com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1719)
> at
> com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:184)
> at
> com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:159)
> at
> com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServerStatement.java:735)
> at com.microsoft.SetupAmbariDb.executeQuery(Unknown Source)
> at com.microsoft.SetupAmbariDb.setupAmbariTables(Unknown Source)
> at com.microsoft.SetupAmbariDb.setup(Unknown Source)
> at com.microsoft.SetupAmbariDb.main(Unknown Source)
> {code}
> Missing a ")" before the ";"
> {code}
> CREATE TABLE extensionlink(
> link_id BIGINT NOT NULL,
> stack_id BIGINT NOT NULL,
> extension_id BIGINT NOT NULL,
> CONSTRAINT PK_extensionlink PRIMARY KEY CLUSTERED (link_id),
> CONSTRAINT FK_extensionlink_stack_id FOREIGN KEY (stack_id) REFERENCES
> stack(stack_id),
> CONSTRAINT FK_extensionlink_extension_id FOREIGN KEY (extension_id)
> REFERENCES extension(extension_id),
> CONSTRAINT UQ_extension_link UNIQUE (stack_id, extension_id);
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
