013-10-31 21:04:30,228 INFO [startup] [AbstractCommandLauncher] [main] Option: name=engine, value={store-001} 2013-10-31 21:04:30,228 INFO [startup] [AbstractCommandLauncher] [main] Option: name=port, value={9090} 2013-10-31 21:04:30,337 INFO [startup] [SymmetricWebServer] [main] About to start SymmetricDS web server on port 9090 2013-10-31 21:04:30,992 INFO [startup] [/] [main] Initializing Spring root WebApplicationContext 2013-10-31 21:04:31,679 INFO [store-001] [FirebirdSymmetricDialect] [symmetric-startup] The DbDialect being used is org.jumpmind.symmetric.db.firebird.FirebirdSymmetricDialect 2013-10-31 21:04:32,396 INFO [store-001] [ExtensionPointManager] [symmetric-startup] Found 6 extension points that will be registered 2013-10-31 21:04:32,396 INFO [startup] [/] [main] Initializing Spring FrameworkServlet 'rest' 2013-10-31 21:04:32,412 INFO [store-001] [AbstractSymmetricEngine] [symmetric-startup] Initializing SymmetricDS database 2013-10-31 21:04:32,412 INFO [store-001] [FirebirdSymmetricDialect] [symmetric-startup] Checking if SymmetricDS tables need created or altered 2013-10-31 21:04:32,739 INFO [startup] [SymmetricWebServer] [main] Joining the web server main thread 2013-10-31 21:04:32,864 INFO [store-001] [FirebirdSymmetricDialect] [symmetric-startup] There are SymmetricDS tables that needed altered 2013-10-31 21:04:32,911 WARN [store-001] [FirebirdSymmetricDialect] [symmetric-startup] DDL failed: CREATE TABLE "SYM_NODE" ( "NODE_ID" VARCHAR(50) NOT NULL, "NODE_GROUP_ID" VARCHAR(50) NOT NULL, "EXTERNAL_ID" VARCHAR(50) NOT NULL, "SYNC_ENABLED" SMALLINT DEFAULT 0, "SYNC_URL" VARCHAR(255), "SCHEMA_VERSION" VARCHAR(50), "SYMMETRIC_VERSION" VARCHAR(50), "DATABASE_TYPE" VARCHAR(50), "DATABASE_VERSION" VARCHAR(50), "HEARTBEAT_TIME" TIMESTAMP, "TIMEZONE_OFFSET" VARCHAR(6), "BATCH_TO_SEND_COUNT" INTEGER DEFAULT 0, "BATCH_IN_ERROR_COUNT" INTEGER DEFAULT 0, "CREATED_AT_NODE_ID" VARCHAR(50), "DEPLOYMENT_TYPE" VARCHAR(50), PRIMARY KEY ("NODE_ID") ) 2013-10-31 21:04:32,911 WARN [store-001] [JdbcSqlTemplate] [symmetric-startup] GDS Exception. 335544351. unsuccessful metadata update Table SYM_NODE already exists null null. Failed to execute: CREATE TABLE "SYM_NODE" ( "NODE_ID" VARCHAR(50) NOT NULL, "NODE_GROUP_ID" VARCHAR(50) NOT NULL, "EXTERNAL_ID" VARCHAR(50) NOT NULL, "SYNC_ENABLED" SMALLINT DEFAULT 0, "SYNC_URL" VARCHAR(255), "SCHEMA_VERSION" VARCHAR(50), "SYMMETRIC_VERSION" VARCHAR(50), "DATABASE_TYPE" VARCHAR(50), "DATABASE_VERSION" VARCHAR(50), "HEARTBEAT_TIME" TIMESTAMP, "TIMEZONE_OFFSET" VARCHAR(6), "BATCH_TO_SEND_COUNT" INTEGER DEFAULT 0, "BATCH_IN_ERROR_COUNT" INTEGER DEFAULT 0, "CREATED_AT_NODE_ID" VARCHAR(50), "DEPLOYMENT_TYPE" VARCHAR(50), PRIMARY KEY ("NODE_ID") ) 2013-10-31 21:04:32,927 ERROR [store-001] [AbstractSymmetricEngine] [symmetric-startup] An error occurred while starting SymmetricDS org.jumpmind.db.sql.SqlException: GDS Exception. 335544351. unsuccessful metadata update Table SYM_NODE already exists null null at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:288) at org.jumpmind.db.platform.firebird.FirebirdJdbcSqlTemplate.translate(FirebirdJdbcSqlTemplate.java:59) at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:279) at org.jumpmind.db.sql.JdbcSqlTemplate.execute(JdbcSqlTemplate.java:414) at org.jumpmind.db.sql.JdbcSqlTemplate.update(JdbcSqlTemplate.java:327) at org.jumpmind.db.sql.SqlScript.execute(SqlScript.java:107) at org.jumpmind.symmetric.db.AbstractSymmetricDialect.createOrAlterTablesIfNecessary(AbstractSymmetricDialect.java:483) at org.jumpmind.symmetric.db.AbstractSymmetricDialect.initTablesAndDatabaseObjects(AbstractSymmetricDialect.java:153) at org.jumpmind.symmetric.AbstractSymmetricEngine.setupDatabase(AbstractSymmetricEngine.java:364) at org.jumpmind.symmetric.AbstractSymmetricEngine.setup(AbstractSymmetricEngine.java:355) at org.jumpmind.symmetric.AbstractSymmetricEngine.start(AbstractSymmetricEngine.java:494) at org.jumpmind.symmetric.AbstractSymmetricEngine.start(AbstractSymmetricEngine.java:486) at org.jumpmind.symmetric.web.SymmetricEngineHolder$EngineStarter.run(SymmetricEngineHolder.java:427) Caused by: org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544351. unsuccessful metadata update Table SYM_NODE already exists null null at org.firebirdsql.jdbc.AbstractStatement.execute(AbstractStatement.java:869) at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264) at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264) at org.jumpmind.db.sql.JdbcSqlTemplate$6.execute(JdbcSqlTemplate.java:340) at org.jumpmind.db.sql.JdbcSqlTemplate$6.execute(JdbcSqlTemplate.java:327) at org.jumpmind.db.sql.JdbcSqlTemplate.execute(JdbcSqlTemplate.java:412) ... 9 more Caused by: org.firebirdsql.gds.GDSException: unsuccessful metadata update Table SYM_NODE already exists null null at org.firebirdsql.gds.impl.wire.AbstractJavaGDSImpl.readStatusVector(AbstractJavaGDSImpl.java:2214) at org.firebirdsql.gds.impl.wire.AbstractJavaGDSImpl.receiveResponse(AbstractJavaGDSImpl.java:2164) at org.firebirdsql.gds.impl.wire.AbstractJavaGDSImpl.iscDsqlExecute2(AbstractJavaGDSImpl.java:1213) at org.firebirdsql.gds.impl.GDSHelper.executeStatement(GDSHelper.java:227) at org.firebirdsql.jdbc.AbstractStatement.internalExecute(AbstractStatement.java:1424) at org.firebirdsql.jdbc.AbstractStatement.execute(AbstractStatement.java:867) ... 14 more 2013-10-31 21:04:33,036 INFO [store-001] [AbstractSymmetricEngine] [symmetric-startup] SymmetricDS: type=server, name=store-001, version=3.5.10, groupId=store, externalId=001, databaseName=Firebird 2.5, databaseVersion=2.5, driverName=Jaybird JCA/JDBC driver, driverVersion=2.2