Alejandro Fernandez created AMBARI-17611:
--------------------------------------------
Summary: 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
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)
