[
https://issues.apache.org/jira/browse/AMBARI-17611?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Alejandro Fernandez updated AMBARI-17611:
-----------------------------------------
Attachment: AMBARI-17611.trunk.patch
> 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.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)
