2022-12-02 11:50:53 (UTC-0700),663 INFO [eng-m-site1] [AbstractSymmetricEngine] [symmetric-engine-startup-1] 2022-12-05 12:08:51 (UTC-0700),187 INFO [] [AbstractSymmetricEngine] [Thread-9] Stopping SymmetricDS externalId=m-site1 version=3.14.2 database=PostgreSQL 2022-12-05 12:10:10 (UTC-0700),297 INFO [startup] [AbstractCommandLauncher] [main] Option: name=secure-port, value={8080} 2022-12-05 12:10:10 (UTC-0700),303 INFO [startup] [AbstractCommandLauncher] [main] Option: name=secure-server, value={} 2022-12-05 12:10:10 (UTC-0700),593 INFO [startup] [SymmetricUtils] [main] _____ __ _ ____ _____ / ___/ __ _____ __ ___ __ ___ _/ /_ ____(_)___ / __ | / ___/ \__ \ / / / / _ `_ \/ _ `_ \/ _ \/_ __// __/ / __/ / / / / \__ \ ___/ // /_/ / // // / // // / __// / / / / / /_ / /_/ / ___/ / /____/ \__ /_//_//_/_//_//_/\___/ \_/ /_/ /_/\__/ /_____/ /____/ /____/ +-----------------------------------------------------------------+ | Copyright (C) 2007-2022 JumpMind, Inc. | | | | Licensed under the GNU General Public License version 3. | | This software comes with ABSOLUTELY NO WARRANTY. | | See http://www.gnu.org/licenses/gpl.html | +-----------------------------------------------------------------+ 2022-12-05 12:10:10 (UTC-0700),701 INFO [startup] [SymmetricWebServer] [main] About to start SymmetricDS web server on 0.0.0.0:8080:HTTPS/1.1 2022-12-05 12:10:11 (UTC-0700),082 INFO [startup] [SymmetricEngineHolder] [main] Current directory is /opt/symdb 2022-12-05 12:10:11 (UTC-0700),082 INFO [startup] [SymmetricEngineHolder] [main] Starting in single-server mode 2022-12-05 12:10:11 (UTC-0700),180 INFO [eng-m-site1] [ClientSymmetricEngine] [symmetric-engine-startup-1] Initializing connection to database 2022-12-05 12:10:11 (UTC-0700),905 INFO [eng-m-site1] [JdbcDatabasePlatformFactory] [symmetric-engine-startup-1] Detected database 'postgres95', version '10', protocol 'postgresql' 2022-12-05 12:10:11 (UTC-0700),927 INFO [eng-m-site1] [JdbcDatabasePlatformFactory] [symmetric-engine-startup-1] The IDatabasePlatform being used is org.jumpmind.db.platform.postgresql.PostgreSql95DatabasePlatform 2022-12-05 12:10:12 (UTC-0700),138 INFO [eng-m-site1] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] The DbDialect being used is org.jumpmind.symmetric.db.postgresql.PostgreSqlSymmetricDialect 2022-12-05 12:10:12 (UTC-0700),211 INFO [eng-m-site1] [ExtensionService] [symmetric-engine-startup-1] Found 0 extension points from the database that will be registered 2022-12-05 12:10:12 (UTC-0700),227 INFO [eng-m-site1] [StagingManager] [symmetric-engine-startup-1] The staging directory was initialized at the following location: /opt/symdb/tmp/eng-m-site1 2022-12-05 12:10:12 (UTC-0700),791 INFO [startup] [SymmetricWebServer] [main] Joining the web server main thread 2022-12-05 12:10:13 (UTC-0700),019 INFO [eng-m-site1] [ExtensionService] [symmetric-engine-startup-1] Found 0 extension points from the database that will be registered 2022-12-05 12:10:13 (UTC-0700),019 INFO [eng-m-site1] [ClientExtensionService] [symmetric-engine-startup-1] Found 7 extension points from spring that will be registered 2022-12-05 12:10:13 (UTC-0700),032 INFO [eng-m-site1] [AbstractSymmetricEngine] [symmetric-engine-startup-1] Initializing SymmetricDS database 2022-12-05 12:10:13 (UTC-0700),052 INFO [eng-m-site1] [AbstractSymmetricEngine] [symmetric-engine-startup-1] Checking tables and objects 2022-12-05 12:10:13 (UTC-0700),102 INFO [eng-m-site1] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] Checking if SymmetricDS tables need created or altered 2022-12-05 12:10:14 (UTC-0700),892 INFO [eng-m-site1] [DatabaseUpgradeListener] [symmetric-engine-startup-1] Detected upgrade from pre-3.12 version. 2022-12-05 12:10:14 (UTC-0700),892 INFO [eng-m-site1] [DatabaseUpgradeListener] [symmetric-engine-startup-1] Before upgrade, fixing router_type 2022-12-05 12:10:14 (UTC-0700),895 INFO [eng-m-site1] [DatabaseUpgradeListener] [symmetric-engine-startup-1] Detected upgrade from pre-3.12.5 version. 2022-12-05 12:10:14 (UTC-0700),895 INFO [eng-m-site1] [DatabaseUpgradeListener] [symmetric-engine-startup-1] Detected upgrade from pre-3.14 version. 2022-12-05 12:10:14 (UTC-0700),929 INFO [eng-m-site1] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] Dropping SYM_ON_I_FOR_SYM_JB_GMST1 trigger for sym_job 2022-12-05 12:10:15 (UTC-0700),065 INFO [eng-m-site1] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] Dropping SYM_ON_D_FOR_SYM_JB_GMST1 trigger for sym_job 2022-12-05 12:10:15 (UTC-0700),080 INFO [eng-m-site1] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] Dropping SYM_ON_U_FOR_SYM_JB_GMST1 trigger for sym_job 2022-12-05 12:10:16 (UTC-0700),834 INFO [eng-m-site1] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] There are SymmetricDS tables that needed altered 2022-12-05 12:10:17 (UTC-0700),807 WARN [eng-m-site1] [LogSqlResultsListener] [symmetric-engine-startup-1] DDL failed: ALTER TABLE "sym_data_event" ADD CONSTRAINT "sym_data_event_PK" PRIMARY KEY ("data_id", "batch_id") 2022-12-05 12:10:17 (UTC-0700),808 WARN [eng-m-site1] [JdbcSqlTemplate] [symmetric-engine-startup-1] ERROR: could not create unique index "sym_data_event_PK" Detail: Key (data_id, batch_id)=(39135943, 90063) is duplicated.. Failed to execute: ALTER TABLE "sym_data_event" ADD CONSTRAINT "sym_data_event_PK" PRIMARY KEY ("data_id", "batch_id") 2022-12-05 12:10:17 (UTC-0700),808 ERROR [eng-m-site1] [AbstractSymmetricEngine] [symmetric-engine-startup-1] An error occurred while starting SymmetricDS StackTraceKey.init [UniqueKeyException:3293746136] org.jumpmind.db.sql.UniqueKeyException: org.postgresql.util.PSQLException: ERROR: could not create unique index "sym_data_event_PK" Detail: Key (data_id, batch_id)=(39135943, 90063) is duplicated. at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:302) at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:297) at org.jumpmind.db.sql.JdbcSqlTemplate.execute(JdbcSqlTemplate.java:494) at org.jumpmind.db.sql.JdbcSqlTemplate.update(JdbcSqlTemplate.java:405) at org.jumpmind.db.sql.SqlScript.execute(SqlScript.java:108) at org.jumpmind.symmetric.db.AbstractSymmetricDialect.createOrAlterTablesIfNecessary(AbstractSymmetricDialect.java:521) at org.jumpmind.symmetric.db.AbstractSymmetricDialect.initTablesAndDatabaseObjects(AbstractSymmetricDialect.java:181) at org.jumpmind.symmetric.AbstractSymmetricEngine.setupDatabase(AbstractSymmetricEngine.java:454) at org.jumpmind.symmetric.AbstractSymmetricEngine.setup(AbstractSymmetricEngine.java:427) at org.jumpmind.symmetric.AbstractSymmetricEngine.start(AbstractSymmetricEngine.java:612) at org.jumpmind.symmetric.AbstractSymmetricEngine.start(AbstractSymmetricEngine.java:600) at org.jumpmind.symmetric.ClientSymmetricEngine.start(ClientSymmetricEngine.java:259) at org.jumpmind.symmetric.web.SymmetricEngineStarter.run(SymmetricEngineStarter.java:42) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.base/java.lang.Thread.run(Unknown Source) Caused by: org.postgresql.util.PSQLException: ERROR: could not create unique index "sym_data_event_PK" Detail: Key (data_id, batch_id)=(39135943, 90063) is duplicated. at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2676) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2366) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:356) at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:496) at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:413) at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:333) at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:319) at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:295) at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:290) at org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:193) at org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:193) at org.jumpmind.db.sql.JdbcSqlTemplate$6.execute(JdbcSqlTemplate.java:420) at org.jumpmind.db.sql.JdbcSqlTemplate$6.execute(JdbcSqlTemplate.java:405) at org.jumpmind.db.sql.JdbcSqlTemplate.execute(JdbcSqlTemplate.java:492) ... 13 more 2022-12-05 12:10:17 (UTC-0700),813 INFO [eng-m-site1] [AbstractSymmetricEngine] [symmetric-engine-startup-1] Stopping SymmetricDS externalId=m-site1 version=3.14.3 database=PostgreSQL