ambari-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Nate Cole (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (AMBARI-17611) DB setup fails for SQLServer due to incorrect table schema definition for extensionlink
Date Thu, 07 Jul 2016 17:52:11 GMT

    [ https://issues.apache.org/jira/browse/AMBARI-17611?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15366488#comment-15366488
] 

Nate Cole commented on AMBARI-17611:
------------------------------------

+1

> 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=hdfspromdev60165c06b1904860934d820f20c3615dAmbariDbLogin@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)

Mime
View raw message