0003953: Firebird 2.5 trying to recreate existing tables (metadata problem with Jaybird 3.x driver) - SymmetricDS

ID	Project	Category	View Status	Date Submitted	Last Update

0003953	SymmetricDS	Bug	public	2019-05-10 19:20	2019-06-25 18:06

Reporter	enwony	Assigned To	elong
Priority	normal
Status	closed	Resolution	fixed
Product Version	3.10.2
Target Version	3.10.3	Fixed in Version	3.10.3

Summary	0003953: Firebird 2.5 trying to recreate existing tables (metadata problem with Jaybird 3.x driver)
Description	It looks like lower-case table name used for searching while upper-case name created initally. Part of logfile from second restart, all tables already exists in database: 2019-05-11 05:06:37,739 INFO [server] [Firebird21SymmetricDialect] [symmetric-engine-startup-1] Checking if SymmetricDS tables need created or altered 2019-05-11 05:06:38,145 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_CHANNEL needs to be added ... 2019-05-11 05:06:38,176 INFO [server] [Firebird21SymmetricDialect] [symmetric-engine-startup-1] There are SymmetricDS tables that needed altered 2019-05-11 05:06:38,192 WARN [server] [Firebird21SymmetricDialect] [symmetric-engine-startup-1] DDL failed: CREATE TABLE "SYM_CHANNEL"( ... I found message on sourceforge that may rely to this (first message mention same situation, but it refer to older versions) https://sourceforge.net/p/symmetricds/discussion/739236/thread/02bddf3b/ PS: reproduced even if I specify encoding in server.properties
Steps To Reproduce	1. Installed JRE1.8.0.211 2. Installed firebird 2.5.8.27089 3. Installed Symmetrics DS 3.10.2 4. Tuned conf/log4j.xml for extended logging 5. Tuned one engine file (attached). 6. Created empty local DB in firebird. 7. Started symmetricds server, wait 1 min to populate database with Sym_* tables. 8. Restart symmetricds server, got error in log (unsuccessful metadata update; Table SYM_CHANNEL already exists) and no longer in-sync Expected: symmetricsds server continue work after restart.
Tags	dialect: firebird, install

enwony 2019-05-10 19:20 reporter	server.properties (265 bytes) symmetric.log (166,848 bytes) 2019-05-11 05:06:00,664 INFO [startup] [AbstractCommandLauncher] [main] Option: name=max-idle-time, value={90000} 2019-05-11 05:06:00,664 INFO [startup] [AbstractCommandLauncher] [main] Option: name=no-log-console, value={} 2019-05-11 05:06:00,929 INFO [startup] [SymmetricUtils] [main] _____ __ _ ____ _____ / ___/ __ _____ __ ___ __ ___ _/ /_ ____(_)___ / __ \| / ___/ \__ \ / / / / _ `_ \/ _ `_ \/ _ \/_ __// __/ / __/ / / / / \__ \ ___/ // /_/ / // // / // // / __// / / / / / /_ / /_/ / ___/ / /____/ \__ /_//_//_/_//_//_/\___/ \_/ /_/ /_/\__/ /_____/ /____/ /____/ +-----------------------------------------------------------------+ \| Copyright (C) 2007-2019 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 \| +-----------------------------------------------------------------+ 2019-05-11 05:06:00,976 INFO [startup] [SymmetricWebServer] [main] About to start SymmetricDS web server on host:port 0.0.0.0:31415 2019-05-11 05:06:01,726 INFO [server] [AbstractSymmetricEngine] [symmetric-engine-startup-1] Initializing connection to database 2019-05-11 05:06:02,023 WARN [server] [FBManagedConnection] [symmetric-engine-startup-1] WARNING: No connection character set specified (property lc_ctype, encoding, charSet or localEncoding), defaulting to character set NONE 2019-05-11 05:06:02,336 WARN [server] [FBManagedConnection] [symmetric-engine-startup-1] WARNING: No connection character set specified (property lc_ctype, encoding, charSet or localEncoding), defaulting to character set NONE 2019-05-11 05:06:02,382 WARN [server] [FBManagedConnection] [symmetric-engine-startup-1] WARNING: No connection character set specified (property lc_ctype, encoding, charSet or localEncoding), defaulting to character set NONE 2019-05-11 05:06:02,429 WARN [server] [FBManagedConnection] [symmetric-engine-startup-1] WARNING: No connection character set specified (property lc_ctype, encoding, charSet or localEncoding), defaulting to character set NONE 2019-05-11 05:06:02,461 WARN [server] [FBManagedConnection] [symmetric-engine-startup-1] WARNING: No connection character set specified (property lc_ctype, encoding, charSet or localEncoding), defaulting to character set NONE 2019-05-11 05:06:02,523 WARN [server] [FBManagedConnection] [symmetric-engine-startup-1] WARNING: No connection character set specified (property lc_ctype, encoding, charSet or localEncoding), defaulting to character set NONE 2019-05-11 05:06:02,664 INFO [server] [JdbcDatabasePlatformFactory] [symmetric-engine-startup-1] Detected database 'Firebird 2.5', version '2', protocol 'firebirdsql' 2019-05-11 05:06:02,679 INFO [server] [JdbcDatabasePlatformFactory] [symmetric-engine-startup-1] The IDatabasePlatform being used is org.jumpmind.db.platform.firebird.FirebirdDatabasePlatform 2019-05-11 05:06:02,820 INFO [server] [Firebird21SymmetricDialect] [symmetric-engine-startup-1] The DbDialect being used is org.jumpmind.symmetric.db.firebird.Firebird21SymmetricDialect 2019-05-11 05:06:02,836 INFO [server] [StagingManager] [symmetric-engine-startup-1] The staging directory was initialized at the following location: tmp\server 2019-05-11 05:06:03,976 INFO [server] [ClientExtensionService] [symmetric-engine-startup-1] Found 7 extension points from spring that will be registered 2019-05-11 05:06:03,992 INFO [server] [AbstractSymmetricEngine] [symmetric-engine-startup-1] Initializing SymmetricDS database 2019-05-11 05:06:03,992 INFO [server] [Firebird21SymmetricDialect] [symmetric-engine-startup-1] Checking if SymmetricDS tables need created or altered 2019-05-11 05:06:04,226 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_CHANNEL needs to be added 2019-05-11 05:06:04,226 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_CONFLICT needs to be added 2019-05-11 05:06:04,226 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_CONTEXT needs to be added 2019-05-11 05:06:04,226 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_DATA needs to be added 2019-05-11 05:06:04,226 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_DATA_EVENT needs to be added 2019-05-11 05:06:04,226 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_DATA_GAP needs to be added 2019-05-11 05:06:04,226 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_EXTENSION needs to be added 2019-05-11 05:06:04,226 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_EXTRACT_REQUEST needs to be added 2019-05-11 05:06:04,226 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_FILE_INCOMING needs to be added 2019-05-11 05:06:04,226 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_FILE_SNAPSHOT needs to be added 2019-05-11 05:06:04,226 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_FILE_TRIGGER needs to be added 2019-05-11 05:06:04,226 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_FILE_TRIGGER_ROUTER needs to be added 2019-05-11 05:06:04,226 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_GROUPLET needs to be added 2019-05-11 05:06:04,226 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_GROUPLET_LINK needs to be added 2019-05-11 05:06:04,226 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_INCOMING_BATCH needs to be added 2019-05-11 05:06:04,226 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_INCOMING_ERROR needs to be added 2019-05-11 05:06:04,226 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_JOB needs to be added 2019-05-11 05:06:04,226 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_LOAD_FILTER needs to be added 2019-05-11 05:06:04,226 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_LOCK needs to be added 2019-05-11 05:06:04,226 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_NODE needs to be added 2019-05-11 05:06:04,226 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_NODE_COMMUNICATION needs to be added 2019-05-11 05:06:04,226 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_NODE_CHANNEL_CTL needs to be added 2019-05-11 05:06:04,226 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_NODE_GROUP needs to be added 2019-05-11 05:06:04,226 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_NODE_GROUP_CHANNEL_WND needs to be added 2019-05-11 05:06:04,226 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_NODE_GROUP_LINK needs to be added 2019-05-11 05:06:04,226 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_NODE_HOST needs to be added 2019-05-11 05:06:04,226 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_NODE_HOST_CHANNEL_STATS needs to be added 2019-05-11 05:06:04,226 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_NODE_HOST_JOB_STATS needs to be added 2019-05-11 05:06:04,226 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_NODE_HOST_STATS needs to be added 2019-05-11 05:06:04,226 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_NODE_IDENTITY needs to be added 2019-05-11 05:06:04,226 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_NODE_SECURITY needs to be added 2019-05-11 05:06:04,226 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_MONITOR needs to be added 2019-05-11 05:06:04,226 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_MONITOR_EVENT needs to be added 2019-05-11 05:06:04,226 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_NOTIFICATION needs to be added 2019-05-11 05:06:04,226 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_OUTGOING_BATCH needs to be added 2019-05-11 05:06:04,226 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_PARAMETER needs to be added 2019-05-11 05:06:04,226 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_REGISTRATION_REDIRECT needs to be added 2019-05-11 05:06:04,226 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_REGISTRATION_REQUEST needs to be added 2019-05-11 05:06:04,226 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_ROUTER needs to be added 2019-05-11 05:06:04,226 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_SEQUENCE needs to be added 2019-05-11 05:06:04,226 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_TABLE_RELOAD_REQUEST needs to be added 2019-05-11 05:06:04,226 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_TABLE_RELOAD_STATUS needs to be added 2019-05-11 05:06:04,226 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_TRANSFORM_TABLE needs to be added 2019-05-11 05:06:04,226 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_TRANSFORM_COLUMN needs to be added 2019-05-11 05:06:04,226 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_TRIGGER needs to be added 2019-05-11 05:06:04,226 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_TRIGGER_HIST needs to be added 2019-05-11 05:06:04,226 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_TRIGGER_ROUTER needs to be added 2019-05-11 05:06:04,226 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_TRIGGER_ROUTER_GROUPLET needs to be added 2019-05-11 05:06:04,226 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_CHANNEL needs to be added 2019-05-11 05:06:04,226 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_CONFLICT needs to be added 2019-05-11 05:06:04,226 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_CONTEXT needs to be added 2019-05-11 05:06:04,226 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_DATA needs to be added 2019-05-11 05:06:04,226 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_DATA_EVENT needs to be added 2019-05-11 05:06:04,226 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_DATA_GAP needs to be added 2019-05-11 05:06:04,226 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_EXTENSION needs to be added 2019-05-11 05:06:04,226 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_EXTRACT_REQUEST needs to be added 2019-05-11 05:06:04,226 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_FILE_INCOMING needs to be added 2019-05-11 05:06:04,226 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_FILE_SNAPSHOT needs to be added 2019-05-11 05:06:04,226 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_FILE_TRIGGER needs to be added 2019-05-11 05:06:04,226 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_FILE_TRIGGER_ROUTER needs to be added 2019-05-11 05:06:04,226 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_GROUPLET needs to be added 2019-05-11 05:06:04,226 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_GROUPLET_LINK needs to be added 2019-05-11 05:06:04,226 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_INCOMING_BATCH needs to be added 2019-05-11 05:06:04,226 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_INCOMING_ERROR needs to be added 2019-05-11 05:06:04,226 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_JOB needs to be added 2019-05-11 05:06:04,226 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_LOAD_FILTER needs to be added 2019-05-11 05:06:04,226 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_LOCK needs to be added 2019-05-11 05:06:04,226 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_NODE needs to be added 2019-05-11 05:06:04,226 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_NODE_COMMUNICATION needs to be added 2019-05-11 05:06:04,226 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_NODE_CHANNEL_CTL needs to be added 2019-05-11 05:06:04,226 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_NODE_GROUP needs to be added 2019-05-11 05:06:04,226 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_NODE_GROUP_CHANNEL_WND needs to be added 2019-05-11 05:06:04,226 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_NODE_GROUP_LINK needs to be added 2019-05-11 05:06:04,226 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_NODE_HOST needs to be added 2019-05-11 05:06:04,242 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_NODE_HOST_CHANNEL_STATS needs to be added 2019-05-11 05:06:04,242 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_NODE_HOST_JOB_STATS needs to be added 2019-05-11 05:06:04,242 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_NODE_HOST_STATS needs to be added 2019-05-11 05:06:04,242 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_NODE_IDENTITY needs to be added 2019-05-11 05:06:04,242 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_NODE_SECURITY needs to be added 2019-05-11 05:06:04,242 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_MONITOR needs to be added 2019-05-11 05:06:04,242 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_MONITOR_EVENT needs to be added 2019-05-11 05:06:04,242 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_NOTIFICATION needs to be added 2019-05-11 05:06:04,242 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_OUTGOING_BATCH needs to be added 2019-05-11 05:06:04,242 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_PARAMETER needs to be added 2019-05-11 05:06:04,242 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_REGISTRATION_REDIRECT needs to be added 2019-05-11 05:06:04,242 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_REGISTRATION_REQUEST needs to be added 2019-05-11 05:06:04,242 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_ROUTER needs to be added 2019-05-11 05:06:04,242 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_SEQUENCE needs to be added 2019-05-11 05:06:04,242 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_TABLE_RELOAD_REQUEST needs to be added 2019-05-11 05:06:04,242 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_TABLE_RELOAD_STATUS needs to be added 2019-05-11 05:06:04,242 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_TRANSFORM_TABLE needs to be added 2019-05-11 05:06:04,242 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_TRANSFORM_COLUMN needs to be added 2019-05-11 05:06:04,242 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_TRIGGER needs to be added 2019-05-11 05:06:04,242 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_TRIGGER_HIST needs to be added 2019-05-11 05:06:04,242 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_TRIGGER_ROUTER needs to be added 2019-05-11 05:06:04,242 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_TRIGGER_ROUTER_GROUPLET needs to be added 2019-05-11 05:06:04,257 INFO [server] [Firebird21SymmetricDialect] [symmetric-engine-startup-1] There are SymmetricDS tables that needed altered 2019-05-11 05:06:04,414 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (157ms.) CREATE TABLE "SYM_CHANNEL"( "CHANNEL_ID" VARCHAR(128) NOT NULL, "PROCESSING_ORDER" INTEGER DEFAULT 1 NOT NULL, "MAX_BATCH_SIZE" INTEGER DEFAULT 1000 NOT NULL, "MAX_BATCH_TO_SEND" INTEGER DEFAULT 60 NOT NULL, "MAX_DATA_TO_ROUTE" INTEGER DEFAULT 100000 NOT NULL, "EXTRACT_PERIOD_MILLIS" INTEGER DEFAULT 0 NOT NULL, "ENABLED" SMALLINT DEFAULT 1 NOT NULL, "USE_OLD_DATA_TO_ROUTE" SMALLINT DEFAULT 1 NOT NULL, "USE_ROW_DATA_TO_ROUTE" SMALLINT DEFAULT 1 NOT NULL, "USE_PK_DATA_TO_ROUTE" SMALLINT DEFAULT 1 NOT NULL, "RELOAD_FLAG" SMALLINT DEFAULT 0 NOT NULL, "FILE_SYNC_FLAG" SMALLINT DEFAULT 0 NOT NULL, "CONTAINS_BIG_LOB" SMALLINT DEFAULT 0 NOT NULL, "BATCH_ALGORITHM" VARCHAR(50) DEFAULT 'default' NOT NULL, "DATA_LOADER_TYPE" VARCHAR(50) DEFAULT 'default' NOT NULL, "DESCRIPTION" VARCHAR(255), "QUEUE" VARCHAR(25) DEFAULT 'default' NOT NULL, "MAX_NETWORK_KBPS" DECIMAL(10,3) DEFAULT 0.000 NOT NULL, "DATA_EVENT_ACTION" CHAR(1), "CREATE_TIME" TIMESTAMP, "LAST_UPDATE_BY" VARCHAR(50), "LAST_UPDATE_TIME" TIMESTAMP, PRIMARY KEY ("CHANNEL_ID") ) 2019-05-11 05:06:04,414 INFO [server] [Firebird21SymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "SYM_CHANNEL"( "CHANNEL_ID" VARCHAR(128) NOT NULL, "PROCESSING_ORDER" INTEGER DEFAULT 1 NOT NULL, "MAX_BATCH_SIZE" INTEGER DEFAULT 1000 NOT NULL, "MAX_BATCH_TO_SEND" INTEGER DEFAULT 60 NOT NULL, "MAX_DATA_TO_ROUTE" INTEGER DEFAULT 100000 NOT NULL, "EXTRACT_PERIOD_MILLIS" INTEGER DEFAULT 0 NOT NULL, "ENABLED" SMALLINT DEFAULT 1 NOT NULL, "USE_OLD_DATA_TO_ROUTE" SMALLINT DEFAULT 1 NOT NULL, "USE_ROW_DATA_TO_ROUTE" SMALLINT DEFAULT 1 NOT NULL, "USE_PK_DATA_TO_ROUTE" SMALLINT DEFAULT 1 NOT NULL, "RELOAD_FLAG" SMALLINT DEFAULT 0 NOT NULL, "FILE_SYNC_FLAG" SMALLINT DEFAULT 0 NOT NULL, "CONTAINS_BIG_LOB" SMALLINT DEFAULT 0 NOT NULL, "BATCH_ALGORITHM" VARCHAR(50) DEFAULT 'default' NOT NULL, "DATA_LOADER_TYPE" VARCHAR(50) DEFAULT 'default' NOT NULL, "DESCRIPTION" VARCHAR(255), "QUEUE" VARCHAR(25) DEFAULT 'default' NOT NULL, "MAX_NETWORK_KBPS" DECIMAL(10,3) DEFAULT 0.000 NOT NULL, "DATA_EVENT_ACTION" CHAR(1), "CREATE_TIME" TIMESTAMP, "LAST_UPDATE_BY" VARCHAR(50), "LAST_UPDATE_TIME" TIMESTAMP, PRIMARY KEY ("CHANNEL_ID") ) 2019-05-11 05:06:04,429 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (15ms.) CREATE TABLE "SYM_CONFLICT"( "CONFLICT_ID" VARCHAR(50) NOT NULL, "SOURCE_NODE_GROUP_ID" VARCHAR(50) NOT NULL, "TARGET_NODE_GROUP_ID" VARCHAR(50) NOT NULL, "TARGET_CHANNEL_ID" VARCHAR(128), "TARGET_CATALOG_NAME" VARCHAR(255), "TARGET_SCHEMA_NAME" VARCHAR(255), "TARGET_TABLE_NAME" VARCHAR(255), "DETECT_TYPE" VARCHAR(128) NOT NULL, "DETECT_EXPRESSION" BLOB SUB_TYPE TEXT, "RESOLVE_TYPE" VARCHAR(128) NOT NULL, "PING_BACK" VARCHAR(128) NOT NULL, "RESOLVE_CHANGES_ONLY" SMALLINT DEFAULT 0, "RESOLVE_ROW_ONLY" SMALLINT DEFAULT 0, "CREATE_TIME" TIMESTAMP NOT NULL, "LAST_UPDATE_BY" VARCHAR(50), "LAST_UPDATE_TIME" TIMESTAMP NOT NULL, PRIMARY KEY ("CONFLICT_ID") ) 2019-05-11 05:06:04,429 INFO [server] [Firebird21SymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "SYM_CONFLICT"( "CONFLICT_ID" VARCHAR(50) NOT NULL, "SOURCE_NODE_GROUP_ID" VARCHAR(50) NOT NULL, "TARGET_NODE_GROUP_ID" VARCHAR(50) NOT NULL, "TARGET_CHANNEL_ID" VARCHAR(128), "TARGET_CATALOG_NAME" VARCHAR(255), "TARGET_SCHEMA_NAME" VARCHAR(255), "TARGET_TABLE_NAME" VARCHAR(255), "DETECT_TYPE" VARCHAR(128) NOT NULL, "DETECT_EXPRESSION" BLOB SUB_TYPE TEXT, "RESOLVE_TYPE" VARCHAR(128) NOT NULL, "PING_BACK" VARCHAR(128) NOT NULL, "RESOLVE_CHANGES_ONLY" SMALLINT DEFAULT 0, "RESOLVE_ROW_ONLY" SMALLINT DEFAULT 0, "CREATE_TIME" TIMESTAMP NOT NULL, "LAST_UPDATE_BY" VARCHAR(50), "LAST_UPDATE_TIME" TIMESTAMP NOT NULL, PRIMARY KEY ("CONFLICT_ID") ) 2019-05-11 05:06:04,445 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (16ms.) CREATE TABLE "SYM_CONTEXT"( "NAME" VARCHAR(80) NOT NULL, "CONTEXT_VALUE" BLOB SUB_TYPE TEXT, "CREATE_TIME" TIMESTAMP, "LAST_UPDATE_TIME" TIMESTAMP, PRIMARY KEY ("NAME") ) 2019-05-11 05:06:04,445 INFO [server] [Firebird21SymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "SYM_CONTEXT"( "NAME" VARCHAR(80) NOT NULL, "CONTEXT_VALUE" BLOB SUB_TYPE TEXT, "CREATE_TIME" TIMESTAMP, "LAST_UPDATE_TIME" TIMESTAMP, PRIMARY KEY ("NAME") ) 2019-05-11 05:06:04,461 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (16ms.) CREATE TABLE "SYM_DATA"( "DATA_ID" BIGINT NOT NULL , "TABLE_NAME" VARCHAR(255) NOT NULL, "EVENT_TYPE" CHAR(1) NOT NULL, "ROW_DATA" BLOB SUB_TYPE TEXT, "PK_DATA" BLOB SUB_TYPE TEXT, "OLD_DATA" BLOB SUB_TYPE TEXT, "TRIGGER_HIST_ID" INTEGER NOT NULL, "CHANNEL_ID" VARCHAR(128), "TRANSACTION_ID" VARCHAR(255), "SOURCE_NODE_ID" VARCHAR(50), "EXTERNAL_DATA" VARCHAR(50), "NODE_LIST" VARCHAR(255), "IS_PREROUTED" SMALLINT DEFAULT 0 NOT NULL, "CREATE_TIME" TIMESTAMP, PRIMARY KEY ("DATA_ID") ) 2019-05-11 05:06:04,461 INFO [server] [Firebird21SymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "SYM_DATA"( "DATA_ID" BIGINT NOT NULL , "TABLE_NAME" VARCHAR(255) NOT NULL, "EVENT_TYPE" CHAR(1) NOT NULL, "ROW_DATA" BLOB SUB_TYPE TEXT, "PK_DATA" BLOB SUB_TYPE TEXT, "OLD_DATA" BLOB SUB_TYPE TEXT, "TRIGGER_HIST_ID" INTEGER NOT NULL, "CHANNEL_ID" VARCHAR(128), "TRANSACTION_ID" VARCHAR(255), "SOURCE_NODE_ID" VARCHAR(50), "EXTERNAL_DATA" VARCHAR(50), "NODE_LIST" VARCHAR(255), "IS_PREROUTED" SMALLINT DEFAULT 0 NOT NULL, "CREATE_TIME" TIMESTAMP, PRIMARY KEY ("DATA_ID") ) 2019-05-11 05:06:04,476 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (15ms.) CREATE INDEX "SYM_IDX_D_CHANNEL_ID" ON "SYM_DATA" ("DATA_ID", "CHANNEL_ID") 2019-05-11 05:06:04,476 INFO [server] [Firebird21SymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE INDEX "SYM_IDX_D_CHANNEL_ID" ON "SYM_DATA" ("DATA_ID", "CHANNEL_ID") 2019-05-11 05:06:04,476 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (0ms.) CREATE GENERATOR "GEN_SYM_DATA_DATA_ID" 2019-05-11 05:06:04,476 INFO [server] [Firebird21SymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE GENERATOR "GEN_SYM_DATA_DATA_ID" 2019-05-11 05:06:04,492 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (16ms.) CREATE TRIGGER "TRG_SYM_DATA_DATA_ID" FOR "SYM_DATA" ACTIVE BEFORE INSERT POSITION 0 AS BEGIN IF (NEW."DATA_ID" IS NULL) THEN NEW."DATA_ID" = GEN_ID("GEN_SYM_DATA_DATA_ID", 1); END 2019-05-11 05:06:04,492 INFO [server] [Firebird21SymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TRIGGER "TRG_SYM_DATA_DATA_ID" FOR "SYM_DATA" ACTIVE BEFORE INSERT POSITION 0 AS BEGIN IF (NEW."DATA_ID" IS NULL) THEN NEW."DATA_ID" = GEN_ID("GEN_SYM_DATA_DATA_ID", 1); END 2019-05-11 05:06:04,507 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (15ms.) CREATE TABLE "SYM_DATA_EVENT"( "DATA_ID" BIGINT NOT NULL, "BATCH_ID" BIGINT NOT NULL, "ROUTER_ID" VARCHAR(50) NOT NULL, "CREATE_TIME" TIMESTAMP, PRIMARY KEY ("DATA_ID", "BATCH_ID", "ROUTER_ID") ) 2019-05-11 05:06:04,507 INFO [server] [Firebird21SymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "SYM_DATA_EVENT"( "DATA_ID" BIGINT NOT NULL, "BATCH_ID" BIGINT NOT NULL, "ROUTER_ID" VARCHAR(50) NOT NULL, "CREATE_TIME" TIMESTAMP, PRIMARY KEY ("DATA_ID", "BATCH_ID", "ROUTER_ID") ) 2019-05-11 05:06:04,711 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (204ms.) CREATE INDEX "SYM_IDX_DE_BATCHID" ON "SYM_DATA_EVENT" ("BATCH_ID") 2019-05-11 05:06:04,711 INFO [server] [Firebird21SymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE INDEX "SYM_IDX_DE_BATCHID" ON "SYM_DATA_EVENT" ("BATCH_ID") 2019-05-11 05:06:04,711 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (0ms.) CREATE TABLE "SYM_DATA_GAP"( "START_ID" BIGINT NOT NULL, "END_ID" BIGINT NOT NULL, "CREATE_TIME" TIMESTAMP NOT NULL, "LAST_UPDATE_HOSTNAME" VARCHAR(255), PRIMARY KEY ("START_ID", "END_ID") ) 2019-05-11 05:06:04,726 INFO [server] [Firebird21SymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "SYM_DATA_GAP"( "START_ID" BIGINT NOT NULL, "END_ID" BIGINT NOT NULL, "CREATE_TIME" TIMESTAMP NOT NULL, "LAST_UPDATE_HOSTNAME" VARCHAR(255), PRIMARY KEY ("START_ID", "END_ID") ) 2019-05-11 05:06:04,726 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (0ms.) CREATE TABLE "SYM_EXTENSION"( "EXTENSION_ID" VARCHAR(50) NOT NULL, "EXTENSION_TYPE" VARCHAR(10) NOT NULL, "INTERFACE_NAME" VARCHAR(255), "NODE_GROUP_ID" VARCHAR(50) NOT NULL, "ENABLED" SMALLINT DEFAULT 1 NOT NULL, "EXTENSION_ORDER" INTEGER DEFAULT 1 NOT NULL, "EXTENSION_TEXT" BLOB SUB_TYPE TEXT, "CREATE_TIME" TIMESTAMP, "LAST_UPDATE_BY" VARCHAR(50), "LAST_UPDATE_TIME" TIMESTAMP, PRIMARY KEY ("EXTENSION_ID") ) 2019-05-11 05:06:04,726 INFO [server] [Firebird21SymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "SYM_EXTENSION"( "EXTENSION_ID" VARCHAR(50) NOT NULL, "EXTENSION_TYPE" VARCHAR(10) NOT NULL, "INTERFACE_NAME" VARCHAR(255), "NODE_GROUP_ID" VARCHAR(50) NOT NULL, "ENABLED" SMALLINT DEFAULT 1 NOT NULL, "EXTENSION_ORDER" INTEGER DEFAULT 1 NOT NULL, "EXTENSION_TEXT" BLOB SUB_TYPE TEXT, "CREATE_TIME" TIMESTAMP, "LAST_UPDATE_BY" VARCHAR(50), "LAST_UPDATE_TIME" TIMESTAMP, PRIMARY KEY ("EXTENSION_ID") ) 2019-05-11 05:06:04,757 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (31ms.) CREATE TABLE "SYM_EXTRACT_REQUEST"( "REQUEST_ID" BIGINT NOT NULL, "NODE_ID" VARCHAR(50) NOT NULL, "QUEUE" VARCHAR(128), "STATUS" CHAR(2), "START_BATCH_ID" BIGINT NOT NULL, "END_BATCH_ID" BIGINT NOT NULL, "TRIGGER_ID" VARCHAR(128) NOT NULL, "ROUTER_ID" VARCHAR(50) NOT NULL, "LOAD_ID" BIGINT, "TABLE_NAME" VARCHAR(255), "EXTRACTED_ROWS" BIGINT DEFAULT 0 NOT NULL, "EXTRACTED_MILLIS" BIGINT DEFAULT 0 NOT NULL, "TRANSFERRED_ROWS" BIGINT DEFAULT 0 NOT NULL, "TRANSFERRED_MILLIS" BIGINT DEFAULT 0 NOT NULL, "LAST_TRANSFERRED_BATCH_ID" BIGINT, "LOADED_ROWS" BIGINT DEFAULT 0 NOT NULL, "LOADED_MILLIS" BIGINT DEFAULT 0 NOT NULL, "LAST_LOADED_BATCH_ID" BIGINT, "TOTAL_ROWS" BIGINT, "LOADED_TIME" TIMESTAMP, "PARENT_REQUEST_ID" BIGINT DEFAULT 0 NOT NULL, "LAST_UPDATE_TIME" TIMESTAMP, "CREATE_TIME" TIMESTAMP, PRIMARY KEY ("REQUEST_ID") ) 2019-05-11 05:06:04,757 INFO [server] [Firebird21SymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "SYM_EXTRACT_REQUEST"( "REQUEST_ID" BIGINT NOT NULL, "NODE_ID" VARCHAR(50) NOT NULL, "QUEUE" VARCHAR(128), "STATUS" CHAR(2), "START_BATCH_ID" BIGINT NOT NULL, "END_BATCH_ID" BIGINT NOT NULL, "TRIGGER_ID" VARCHAR(128) NOT NULL, "ROUTER_ID" VARCHAR(50) NOT NULL, "LOAD_ID" BIGINT, "TABLE_NAME" VARCHAR(255), "EXTRACTED_ROWS" BIGINT DEFAULT 0 NOT NULL, "EXTRACTED_MILLIS" BIGINT DEFAULT 0 NOT NULL, "TRANSFERRED_ROWS" BIGINT DEFAULT 0 NOT NULL, "TRANSFERRED_MILLIS" BIGINT DEFAULT 0 NOT NULL, "LAST_TRANSFERRED_BATCH_ID" BIGINT, "LOADED_ROWS" BIGINT DEFAULT 0 NOT NULL, "LOADED_MILLIS" BIGINT DEFAULT 0 NOT NULL, "LAST_LOADED_BATCH_ID" BIGINT, "TOTAL_ROWS" BIGINT, "LOADED_TIME" TIMESTAMP, "PARENT_REQUEST_ID" BIGINT DEFAULT 0 NOT NULL, "LAST_UPDATE_TIME" TIMESTAMP, "CREATE_TIME" TIMESTAMP, PRIMARY KEY ("REQUEST_ID") ) 2019-05-11 05:06:04,757 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (0ms.) CREATE TABLE "SYM_FILE_INCOMING"( "RELATIVE_DIR" VARCHAR(255) NOT NULL, "FILE_NAME" VARCHAR(128) NOT NULL, "LAST_EVENT_TYPE" CHAR(1) NOT NULL, "NODE_ID" VARCHAR(50) NOT NULL, "FILE_MODIFIED_TIME" BIGINT, PRIMARY KEY ("RELATIVE_DIR", "FILE_NAME") ) 2019-05-11 05:06:04,757 INFO [server] [Firebird21SymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "SYM_FILE_INCOMING"( "RELATIVE_DIR" VARCHAR(255) NOT NULL, "FILE_NAME" VARCHAR(128) NOT NULL, "LAST_EVENT_TYPE" CHAR(1) NOT NULL, "NODE_ID" VARCHAR(50) NOT NULL, "FILE_MODIFIED_TIME" BIGINT, PRIMARY KEY ("RELATIVE_DIR", "FILE_NAME") ) 2019-05-11 05:06:04,773 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (16ms.) CREATE TABLE "SYM_FILE_SNAPSHOT"( "TRIGGER_ID" VARCHAR(128) NOT NULL, "ROUTER_ID" VARCHAR(50) NOT NULL, "RELATIVE_DIR" VARCHAR(255) NOT NULL, "FILE_NAME" VARCHAR(128) NOT NULL, "CHANNEL_ID" VARCHAR(128) DEFAULT 'filesync' NOT NULL, "RELOAD_CHANNEL_ID" VARCHAR(128) DEFAULT 'filesync_reload' NOT NULL, "LAST_EVENT_TYPE" CHAR(1) NOT NULL, "CRC32_CHECKSUM" BIGINT, "FILE_SIZE" BIGINT, "FILE_MODIFIED_TIME" BIGINT, "LAST_UPDATE_TIME" TIMESTAMP NOT NULL, "LAST_UPDATE_BY" VARCHAR(50), "CREATE_TIME" TIMESTAMP NOT NULL, PRIMARY KEY ("TRIGGER_ID", "ROUTER_ID", "RELATIVE_DIR", "FILE_NAME") ) 2019-05-11 05:06:04,789 INFO [server] [Firebird21SymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "SYM_FILE_SNAPSHOT"( "TRIGGER_ID" VARCHAR(128) NOT NULL, "ROUTER_ID" VARCHAR(50) NOT NULL, "RELATIVE_DIR" VARCHAR(255) NOT NULL, "FILE_NAME" VARCHAR(128) NOT NULL, "CHANNEL_ID" VARCHAR(128) DEFAULT 'filesync' NOT NULL, "RELOAD_CHANNEL_ID" VARCHAR(128) DEFAULT 'filesync_reload' NOT NULL, "LAST_EVENT_TYPE" CHAR(1) NOT NULL, "CRC32_CHECKSUM" BIGINT, "FILE_SIZE" BIGINT, "FILE_MODIFIED_TIME" BIGINT, "LAST_UPDATE_TIME" TIMESTAMP NOT NULL, "LAST_UPDATE_BY" VARCHAR(50), "CREATE_TIME" TIMESTAMP NOT NULL, PRIMARY KEY ("TRIGGER_ID", "ROUTER_ID", "RELATIVE_DIR", "FILE_NAME") ) 2019-05-11 05:06:04,789 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (0ms.) CREATE INDEX "SYM_IDX_F_SNPSHT_CHID" ON "SYM_FILE_SNAPSHOT" ("RELOAD_CHANNEL_ID") 2019-05-11 05:06:04,789 INFO [server] [Firebird21SymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE INDEX "SYM_IDX_F_SNPSHT_CHID" ON "SYM_FILE_SNAPSHOT" ("RELOAD_CHANNEL_ID") 2019-05-11 05:06:04,804 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (15ms.) CREATE TABLE "SYM_FILE_TRIGGER"( "TRIGGER_ID" VARCHAR(128) NOT NULL, "CHANNEL_ID" VARCHAR(128) DEFAULT 'filesync' NOT NULL, "RELOAD_CHANNEL_ID" VARCHAR(128) DEFAULT 'filesync_reload' NOT NULL, "BASE_DIR" VARCHAR(255) NOT NULL, "RECURSE" SMALLINT DEFAULT 1 NOT NULL, "INCLUDES_FILES" VARCHAR(255), "EXCLUDES_FILES" VARCHAR(255), "SYNC_ON_CREATE" SMALLINT DEFAULT 1 NOT NULL, "SYNC_ON_MODIFIED" SMALLINT DEFAULT 1 NOT NULL, "SYNC_ON_DELETE" SMALLINT DEFAULT 1 NOT NULL, "SYNC_ON_CTL_FILE" SMALLINT DEFAULT 0 NOT NULL, "DELETE_AFTER_SYNC" SMALLINT DEFAULT 0 NOT NULL, "BEFORE_COPY_SCRIPT" BLOB SUB_TYPE TEXT, "AFTER_COPY_SCRIPT" BLOB SUB_TYPE TEXT, "CREATE_TIME" TIMESTAMP NOT NULL, "LAST_UPDATE_BY" VARCHAR(50), "LAST_UPDATE_TIME" TIMESTAMP NOT NULL, "DESCRIPTION" BLOB SUB_TYPE TEXT, PRIMARY KEY ("TRIGGER_ID") ) 2019-05-11 05:06:04,804 INFO [server] [Firebird21SymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "SYM_FILE_TRIGGER"( "TRIGGER_ID" VARCHAR(128) NOT NULL, "CHANNEL_ID" VARCHAR(128) DEFAULT 'filesync' NOT NULL, "RELOAD_CHANNEL_ID" VARCHAR(128) DEFAULT 'filesync_reload' NOT NULL, "BASE_DIR" VARCHAR(255) NOT NULL, "RECURSE" SMALLINT DEFAULT 1 NOT NULL, "INCLUDES_FILES" VARCHAR(255), "EXCLUDES_FILES" VARCHAR(255), "SYNC_ON_CREATE" SMALLINT DEFAULT 1 NOT NULL, "SYNC_ON_MODIFIED" SMALLINT DEFAULT 1 NOT NULL, "SYNC_ON_DELETE" SMALLINT DEFAULT 1 NOT NULL, "SYNC_ON_CTL_FILE" SMALLINT DEFAULT 0 NOT NULL, "DELETE_AFTER_SYNC" SMALLINT DEFAULT 0 NOT NULL, "BEFORE_COPY_SCRIPT" BLOB SUB_TYPE TEXT, "AFTER_COPY_SCRIPT" BLOB SUB_TYPE TEXT, "CREATE_TIME" TIMESTAMP NOT NULL, "LAST_UPDATE_BY" VARCHAR(50), "LAST_UPDATE_TIME" TIMESTAMP NOT NULL, "DESCRIPTION" BLOB SUB_TYPE TEXT, PRIMARY KEY ("TRIGGER_ID") ) 2019-05-11 05:06:04,820 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (16ms.) CREATE TABLE "SYM_FILE_TRIGGER_ROUTER"( "TRIGGER_ID" VARCHAR(128) NOT NULL, "ROUTER_ID" VARCHAR(50) NOT NULL, "ENABLED" SMALLINT DEFAULT 1 NOT NULL, "INITIAL_LOAD_ENABLED" SMALLINT DEFAULT 1 NOT NULL, "TARGET_BASE_DIR" VARCHAR(255), "CONFLICT_STRATEGY" VARCHAR(128) DEFAULT 'source_wins' NOT NULL, "CREATE_TIME" TIMESTAMP NOT NULL, "LAST_UPDATE_BY" VARCHAR(50), "LAST_UPDATE_TIME" TIMESTAMP NOT NULL, "DESCRIPTION" BLOB SUB_TYPE TEXT, PRIMARY KEY ("TRIGGER_ID", "ROUTER_ID") ) 2019-05-11 05:06:04,820 INFO [server] [Firebird21SymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "SYM_FILE_TRIGGER_ROUTER"( "TRIGGER_ID" VARCHAR(128) NOT NULL, "ROUTER_ID" VARCHAR(50) NOT NULL, "ENABLED" SMALLINT DEFAULT 1 NOT NULL, "INITIAL_LOAD_ENABLED" SMALLINT DEFAULT 1 NOT NULL, "TARGET_BASE_DIR" VARCHAR(255), "CONFLICT_STRATEGY" VARCHAR(128) DEFAULT 'source_wins' NOT NULL, "CREATE_TIME" TIMESTAMP NOT NULL, "LAST_UPDATE_BY" VARCHAR(50), "LAST_UPDATE_TIME" TIMESTAMP NOT NULL, "DESCRIPTION" BLOB SUB_TYPE TEXT, PRIMARY KEY ("TRIGGER_ID", "ROUTER_ID") ) 2019-05-11 05:06:04,836 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (16ms.) CREATE TABLE "SYM_GROUPLET"( "GROUPLET_ID" VARCHAR(50) NOT NULL, "GROUPLET_LINK_POLICY" CHAR(1) DEFAULT 'I' NOT NULL, "DESCRIPTION" VARCHAR(255), "CREATE_TIME" TIMESTAMP NOT NULL, "LAST_UPDATE_BY" VARCHAR(50), "LAST_UPDATE_TIME" TIMESTAMP NOT NULL, PRIMARY KEY ("GROUPLET_ID") ) 2019-05-11 05:06:04,836 INFO [server] [Firebird21SymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "SYM_GROUPLET"( "GROUPLET_ID" VARCHAR(50) NOT NULL, "GROUPLET_LINK_POLICY" CHAR(1) DEFAULT 'I' NOT NULL, "DESCRIPTION" VARCHAR(255), "CREATE_TIME" TIMESTAMP NOT NULL, "LAST_UPDATE_BY" VARCHAR(50), "LAST_UPDATE_TIME" TIMESTAMP NOT NULL, PRIMARY KEY ("GROUPLET_ID") ) 2019-05-11 05:06:04,914 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (78ms.) CREATE TABLE "SYM_GROUPLET_LINK"( "GROUPLET_ID" VARCHAR(50) NOT NULL, "EXTERNAL_ID" VARCHAR(255) NOT NULL, "CREATE_TIME" TIMESTAMP NOT NULL, "LAST_UPDATE_BY" VARCHAR(50), "LAST_UPDATE_TIME" TIMESTAMP NOT NULL, PRIMARY KEY ("GROUPLET_ID", "EXTERNAL_ID") ) 2019-05-11 05:06:04,914 INFO [server] [Firebird21SymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "SYM_GROUPLET_LINK"( "GROUPLET_ID" VARCHAR(50) NOT NULL, "EXTERNAL_ID" VARCHAR(255) NOT NULL, "CREATE_TIME" TIMESTAMP NOT NULL, "LAST_UPDATE_BY" VARCHAR(50), "LAST_UPDATE_TIME" TIMESTAMP NOT NULL, PRIMARY KEY ("GROUPLET_ID", "EXTERNAL_ID") ) 2019-05-11 05:06:04,929 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (15ms.) CREATE TABLE "SYM_INCOMING_BATCH"( "BATCH_ID" BIGINT NOT NULL, "NODE_ID" VARCHAR(50) NOT NULL, "CHANNEL_ID" VARCHAR(128), "STATUS" CHAR(2), "ERROR_FLAG" SMALLINT DEFAULT 0, "SQL_STATE" VARCHAR(10), "SQL_CODE" INTEGER DEFAULT 0 NOT NULL, "SQL_MESSAGE" BLOB SUB_TYPE TEXT, "LAST_UPDATE_HOSTNAME" VARCHAR(255), "LAST_UPDATE_TIME" TIMESTAMP, "CREATE_TIME" TIMESTAMP, "SUMMARY" VARCHAR(255), "IGNORE_COUNT" INTEGER DEFAULT 0 NOT NULL, "BYTE_COUNT" BIGINT DEFAULT 0 NOT NULL, "LOAD_FLAG" SMALLINT DEFAULT 0, "EXTRACT_COUNT" INTEGER DEFAULT 0 NOT NULL, "SENT_COUNT" INTEGER DEFAULT 0 NOT NULL, "LOAD_COUNT" INTEGER DEFAULT 0 NOT NULL, "RELOAD_ROW_COUNT" INTEGER DEFAULT 0 NOT NULL, "OTHER_ROW_COUNT" INTEGER DEFAULT 0 NOT NULL, "DATA_ROW_COUNT" INTEGER DEFAULT 0 NOT NULL, "EXTRACT_ROW_COUNT" INTEGER DEFAULT 0 NOT NULL, "LOAD_ROW_COUNT" INTEGER DEFAULT 0 NOT NULL, "DATA_INSERT_ROW_COUNT" INTEGER DEFAULT 0 NOT NULL, "DATA_UPDATE_ROW_COUNT" INTEGER DEFAULT 0 NOT NULL, "DATA_DELETE_ROW_COUNT" INTEGER DEFAULT 0 NOT NULL, "EXTRACT_INSERT_ROW_COUNT" INTEGER DEFAULT 0 NOT NULL, "EXTRACT_UPDATE_ROW_COUNT" INTEGER DEFAULT 0 NOT NULL, "EXTRACT_DELETE_ROW_COUNT" INTEGER DEFAULT 0 NOT NULL, "LOAD_INSERT_ROW_COUNT" INTEGER DEFAULT 0 NOT NULL, "LOAD_UPDATE_ROW_COUNT" INTEGER DEFAULT 0 NOT NULL, "LOAD_DELETE_ROW_COUNT" INTEGER DEFAULT 0 NOT NULL, "NETWORK_MILLIS" INTEGER DEFAULT 0 NOT NULL, "FILTER_MILLIS" INTEGER DEFAULT 0 NOT NULL, "LOAD_MILLIS" INTEGER DEFAULT 0 NOT NULL, "ROUTER_MILLIS" INTEGER DEFAULT 0 NOT NULL, "EXTRACT_MILLIS" INTEGER DEFAULT 0 NOT NULL, "TRANSFORM_EXTRACT_MILLIS" INTEGER DEFAULT 0 NOT NULL, "TRANSFORM_LOAD_MILLIS" INTEGER DEFAULT 0 NOT NULL, "LOAD_ID" BIGINT, "COMMON_FLAG" SMALLINT DEFAULT 0, "FALLBACK_INSERT_COUNT" INTEGER DEFAULT 0 NOT NULL, "FALLBACK_UPDATE_COUNT" INTEGER DEFAULT 0 NOT NULL, "IGNORE_ROW_COUNT" INTEGER DEFAULT 0 NOT NULL, "MISSING_DELETE_COUNT" INTEGER DEFAULT 0 NOT NULL, "SKIP_COUNT" INTEGER DEFAULT 0 NOT NULL, "FAILED_ROW_NUMBER" INTEGER DEFAULT 0 NOT NULL, "FAILED_LINE_NUMBER" INTEGER DEFAULT 0 NOT NULL, "FAILED_DATA_ID" BIGINT DEFAULT 0 NOT NULL, PRIMARY KEY ("BATCH_ID", "NODE_ID") ) 2019-05-11 05:06:04,929 INFO [server] [Firebird21SymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "SYM_INCOMING_BATCH"( "BATCH_ID" BIGINT NOT NULL, "NODE_ID" VARCHAR(50) NOT NULL, "CHANNEL_ID" VARCHAR(128), "STATUS" CHAR(2), "ERROR_FLAG" SMALLINT DEFAULT 0, "SQL_STATE" VARCHAR(10), "SQL_CODE" INTEGER DEFAULT 0 NOT NULL, "SQL_MESSAGE" BLOB SUB_TYPE TEXT, "LAST_UPDATE_HOSTNAME" VARCHAR(255), "LAST_UPDATE_TIME" TIMESTAMP, "CREATE_TIME" TIMESTAMP, "SUMMARY" VARCHAR(255), "IGNORE_COUNT" INTEGER DEFAULT 0 NOT NULL, "BYTE_COUNT" BIGINT DEFAULT 0 NOT NULL, "LOAD_FLAG" SMALLINT DEFAULT 0, "EXTRACT_COUNT" INTEGER DEFAULT 0 NOT NULL, "SENT_COUNT" INTEGER DEFAULT 0 NOT NULL, "LOAD_COUNT" INTEGER DEFAULT 0 NOT NULL, "RELOAD_ROW_COUNT" INTEGER DEFAULT 0 NOT NULL, "OTHER_ROW_COUNT" INTEGER DEFAULT 0 NOT NULL, "DATA_ROW_COUNT" INTEGER DEFAULT 0 NOT NULL, "EXTRACT_ROW_COUNT" INTEGER DEFAULT 0 NOT NULL, "LOAD_ROW_COUNT" INTEGER DEFAULT 0 NOT NULL, "DATA_INSERT_ROW_COUNT" INTEGER DEFAULT 0 NOT NULL, "DATA_UPDATE_ROW_COUNT" INTEGER DEFAULT 0 NOT NULL, "DATA_DELETE_ROW_COUNT" INTEGER DEFAULT 0 NOT NULL, "EXTRACT_INSERT_ROW_COUNT" INTEGER DEFAULT 0 NOT NULL, "EXTRACT_UPDATE_ROW_COUNT" INTEGER DEFAULT 0 NOT NULL, "EXTRACT_DELETE_ROW_COUNT" INTEGER DEFAULT 0 NOT NULL, "LOAD_INSERT_ROW_COUNT" INTEGER DEFAULT 0 NOT NULL, "LOAD_UPDATE_ROW_COUNT" INTEGER DEFAULT 0 NOT NULL, "LOAD_DELETE_ROW_COUNT" INTEGER DEFAULT 0 NOT NULL, "NETWORK_MILLIS" INTEGER DEFAULT 0 NOT NULL, "FILTER_MILLIS" INTEGER DEFAULT 0 NOT NULL, "LOAD_MILLIS" INTEGER DEFAULT 0 NOT NULL, "ROUTER_MILLIS" INTEGER DEFAULT 0 NOT NULL, "EXTRACT_MILLIS" INTEGER DEFAULT 0 NOT NULL, "TRANSFORM_EXTRACT_MILLIS" INTEGER DEFAULT 0 NOT NULL, "TRANSFORM_LOAD_MILLIS" INTEGER DEFAULT 0 NOT NULL, "LOAD_ID" BIGINT, "COMMON_FLAG" SMALLINT DEFAULT 0, "FALLBACK_INSERT_COUNT" INTEGER DEFAULT 0 NOT NULL, "FALLBACK_UPDATE_COUNT" INTEGER DEFAULT 0 NOT NULL, "IGNORE_ROW_COUNT" INTEGER DEFAULT 0 NOT NULL, "MISSING_DELETE_COUNT" INTEGER DEFAULT 0 NOT NULL, "SKIP_COUNT" INTEGER DEFAULT 0 NOT NULL, "FAILED_ROW_NUMBER" INTEGER DEFAULT 0 NOT NULL, "FAILED_LINE_NUMBER" INTEGER DEFAULT 0 NOT NULL, "FAILED_DATA_ID" BIGINT DEFAULT 0 NOT NULL, PRIMARY KEY ("BATCH_ID", "NODE_ID") ) 2019-05-11 05:06:04,945 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (16ms.) CREATE INDEX "SYM_IDX_IB_TIME_STATUS" ON "SYM_INCOMING_BATCH" ("CREATE_TIME", "STATUS") 2019-05-11 05:06:04,945 INFO [server] [Firebird21SymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE INDEX "SYM_IDX_IB_TIME_STATUS" ON "SYM_INCOMING_BATCH" ("CREATE_TIME", "STATUS") 2019-05-11 05:06:04,961 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (16ms.) CREATE INDEX "SYM_IDX_IB_IN_ERROR" ON "SYM_INCOMING_BATCH" ("ERROR_FLAG") 2019-05-11 05:06:04,961 INFO [server] [Firebird21SymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE INDEX "SYM_IDX_IB_IN_ERROR" ON "SYM_INCOMING_BATCH" ("ERROR_FLAG") 2019-05-11 05:06:04,976 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (15ms.) CREATE TABLE "SYM_INCOMING_ERROR"( "BATCH_ID" BIGINT NOT NULL, "NODE_ID" VARCHAR(50) NOT NULL, "FAILED_ROW_NUMBER" BIGINT NOT NULL, "FAILED_LINE_NUMBER" BIGINT DEFAULT 0 NOT NULL, "TARGET_CATALOG_NAME" VARCHAR(255), "TARGET_SCHEMA_NAME" VARCHAR(255), "TARGET_TABLE_NAME" VARCHAR(255) NOT NULL, "EVENT_TYPE" CHAR(1) NOT NULL, "BINARY_ENCODING" VARCHAR(10) DEFAULT 'HEX' NOT NULL, "COLUMN_NAMES" BLOB SUB_TYPE TEXT NOT NULL, "PK_COLUMN_NAMES" BLOB SUB_TYPE TEXT NOT NULL, "ROW_DATA" BLOB SUB_TYPE TEXT, "OLD_DATA" BLOB SUB_TYPE TEXT, "CUR_DATA" BLOB SUB_TYPE TEXT, "RESOLVE_DATA" BLOB SUB_TYPE TEXT, "RESOLVE_IGNORE" SMALLINT DEFAULT 0, "CONFLICT_ID" VARCHAR(50), "CREATE_TIME" TIMESTAMP, "LAST_UPDATE_BY" VARCHAR(50), "LAST_UPDATE_TIME" TIMESTAMP NOT NULL, PRIMARY KEY ("BATCH_ID", "NODE_ID", "FAILED_ROW_NUMBER") ) 2019-05-11 05:06:04,976 INFO [server] [Firebird21SymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "SYM_INCOMING_ERROR"( "BATCH_ID" BIGINT NOT NULL, "NODE_ID" VARCHAR(50) NOT NULL, "FAILED_ROW_NUMBER" BIGINT NOT NULL, "FAILED_LINE_NUMBER" BIGINT DEFAULT 0 NOT NULL, "TARGET_CATALOG_NAME" VARCHAR(255), "TARGET_SCHEMA_NAME" VARCHAR(255), "TARGET_TABLE_NAME" VARCHAR(255) NOT NULL, "EVENT_TYPE" CHAR(1) NOT NULL, "BINARY_ENCODING" VARCHAR(10) DEFAULT 'HEX' NOT NULL, "COLUMN_NAMES" BLOB SUB_TYPE TEXT NOT NULL, "PK_COLUMN_NAMES" BLOB SUB_TYPE TEXT NOT NULL, "ROW_DATA" BLOB SUB_TYPE TEXT, "OLD_DATA" BLOB SUB_TYPE TEXT, "CUR_DATA" BLOB SUB_TYPE TEXT, "RESOLVE_DATA" BLOB SUB_TYPE TEXT, "RESOLVE_IGNORE" SMALLINT DEFAULT 0, "CONFLICT_ID" VARCHAR(50), "CREATE_TIME" TIMESTAMP, "LAST_UPDATE_BY" VARCHAR(50), "LAST_UPDATE_TIME" TIMESTAMP NOT NULL, PRIMARY KEY ("BATCH_ID", "NODE_ID", "FAILED_ROW_NUMBER") ) 2019-05-11 05:06:05,351 INFO [startup] [SymmetricWebServer] [main] Starting JMX HTTP console on port 31416 2019-05-11 05:06:05,382 INFO [startup] [SymmetricWebServer] [main] Joining the web server main thread 2019-05-11 05:06:05,398 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (422ms.) CREATE TABLE "SYM_JOB"( "JOB_NAME" VARCHAR(50) NOT NULL, "JOB_TYPE" VARCHAR(10) NOT NULL, "REQUIRES_REGISTRATION" SMALLINT DEFAULT 1 NOT NULL, "JOB_EXPRESSION" BLOB SUB_TYPE TEXT, "DESCRIPTION" VARCHAR(255), "DEFAULT_SCHEDULE" VARCHAR(50), "DEFAULT_AUTO_START" SMALLINT DEFAULT 1 NOT NULL, "NODE_GROUP_ID" VARCHAR(50) NOT NULL, "CREATE_BY" VARCHAR(50), "CREATE_TIME" TIMESTAMP, "LAST_UPDATE_BY" VARCHAR(50), "LAST_UPDATE_TIME" TIMESTAMP, PRIMARY KEY ("JOB_NAME") ) 2019-05-11 05:06:05,398 INFO [server] [Firebird21SymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "SYM_JOB"( "JOB_NAME" VARCHAR(50) NOT NULL, "JOB_TYPE" VARCHAR(10) NOT NULL, "REQUIRES_REGISTRATION" SMALLINT DEFAULT 1 NOT NULL, "JOB_EXPRESSION" BLOB SUB_TYPE TEXT, "DESCRIPTION" VARCHAR(255), "DEFAULT_SCHEDULE" VARCHAR(50), "DEFAULT_AUTO_START" SMALLINT DEFAULT 1 NOT NULL, "NODE_GROUP_ID" VARCHAR(50) NOT NULL, "CREATE_BY" VARCHAR(50), "CREATE_TIME" TIMESTAMP, "LAST_UPDATE_BY" VARCHAR(50), "LAST_UPDATE_TIME" TIMESTAMP, PRIMARY KEY ("JOB_NAME") ) 2019-05-11 05:06:05,429 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (31ms.) CREATE TABLE "SYM_LOAD_FILTER"( "LOAD_FILTER_ID" VARCHAR(50) NOT NULL, "LOAD_FILTER_TYPE" VARCHAR(10) NOT NULL, "SOURCE_NODE_GROUP_ID" VARCHAR(50) NOT NULL, "TARGET_NODE_GROUP_ID" VARCHAR(50) NOT NULL, "TARGET_CATALOG_NAME" VARCHAR(255), "TARGET_SCHEMA_NAME" VARCHAR(255), "TARGET_TABLE_NAME" VARCHAR(255), "FILTER_ON_UPDATE" SMALLINT DEFAULT 1 NOT NULL, "FILTER_ON_INSERT" SMALLINT DEFAULT 1 NOT NULL, "FILTER_ON_DELETE" SMALLINT DEFAULT 1 NOT NULL, "BEFORE_WRITE_SCRIPT" BLOB SUB_TYPE TEXT, "AFTER_WRITE_SCRIPT" BLOB SUB_TYPE TEXT, "BATCH_COMPLETE_SCRIPT" BLOB SUB_TYPE TEXT, "BATCH_COMMIT_SCRIPT" BLOB SUB_TYPE TEXT, "BATCH_ROLLBACK_SCRIPT" BLOB SUB_TYPE TEXT, "HANDLE_ERROR_SCRIPT" BLOB SUB_TYPE TEXT, "CREATE_TIME" TIMESTAMP NOT NULL, "LAST_UPDATE_BY" VARCHAR(50), "LAST_UPDATE_TIME" TIMESTAMP NOT NULL, "LOAD_FILTER_ORDER" INTEGER DEFAULT 1 NOT NULL, "FAIL_ON_ERROR" SMALLINT DEFAULT 0 NOT NULL, PRIMARY KEY ("LOAD_FILTER_ID") ) 2019-05-11 05:06:05,429 INFO [server] [Firebird21SymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "SYM_LOAD_FILTER"( "LOAD_FILTER_ID" VARCHAR(50) NOT NULL, "LOAD_FILTER_TYPE" VARCHAR(10) NOT NULL, "SOURCE_NODE_GROUP_ID" VARCHAR(50) NOT NULL, "TARGET_NODE_GROUP_ID" VARCHAR(50) NOT NULL, "TARGET_CATALOG_NAME" VARCHAR(255), "TARGET_SCHEMA_NAME" VARCHAR(255), "TARGET_TABLE_NAME" VARCHAR(255), "FILTER_ON_UPDATE" SMALLINT DEFAULT 1 NOT NULL, "FILTER_ON_INSERT" SMALLINT DEFAULT 1 NOT NULL, "FILTER_ON_DELETE" SMALLINT DEFAULT 1 NOT NULL, "BEFORE_WRITE_SCRIPT" BLOB SUB_TYPE TEXT, "AFTER_WRITE_SCRIPT" BLOB SUB_TYPE TEXT, "BATCH_COMPLETE_SCRIPT" BLOB SUB_TYPE TEXT, "BATCH_COMMIT_SCRIPT" BLOB SUB_TYPE TEXT, "BATCH_ROLLBACK_SCRIPT" BLOB SUB_TYPE TEXT, "HANDLE_ERROR_SCRIPT" BLOB SUB_TYPE TEXT, "CREATE_TIME" TIMESTAMP NOT NULL, "LAST_UPDATE_BY" VARCHAR(50), "LAST_UPDATE_TIME" TIMESTAMP NOT NULL, "LOAD_FILTER_ORDER" INTEGER DEFAULT 1 NOT NULL, "FAIL_ON_ERROR" SMALLINT DEFAULT 0 NOT NULL, PRIMARY KEY ("LOAD_FILTER_ID") ) 2019-05-11 05:06:05,445 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (16ms.) CREATE TABLE "SYM_LOCK"( "LOCK_ACTION" VARCHAR(50) NOT NULL, "LOCK_TYPE" VARCHAR(50) NOT NULL, "LOCKING_SERVER_ID" VARCHAR(255), "LOCK_TIME" TIMESTAMP, "SHARED_COUNT" INTEGER DEFAULT 0 NOT NULL, "SHARED_ENABLE" INTEGER DEFAULT 0 NOT NULL, "LAST_LOCK_TIME" TIMESTAMP, "LAST_LOCKING_SERVER_ID" VARCHAR(255), PRIMARY KEY ("LOCK_ACTION") ) 2019-05-11 05:06:05,445 INFO [server] [Firebird21SymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "SYM_LOCK"( "LOCK_ACTION" VARCHAR(50) NOT NULL, "LOCK_TYPE" VARCHAR(50) NOT NULL, "LOCKING_SERVER_ID" VARCHAR(255), "LOCK_TIME" TIMESTAMP, "SHARED_COUNT" INTEGER DEFAULT 0 NOT NULL, "SHARED_ENABLE" INTEGER DEFAULT 0 NOT NULL, "LAST_LOCK_TIME" TIMESTAMP, "LAST_LOCKING_SERVER_ID" VARCHAR(255), PRIMARY KEY ("LOCK_ACTION") ) 2019-05-11 05:06:05,461 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (16ms.) CREATE TABLE "SYM_NODE"( "NODE_ID" VARCHAR(50) NOT NULL, "NODE_GROUP_ID" VARCHAR(50) NOT NULL, "EXTERNAL_ID" VARCHAR(255) NOT NULL, "SYNC_ENABLED" SMALLINT DEFAULT 0, "SYNC_URL" VARCHAR(255), "SCHEMA_VERSION" VARCHAR(50), "SYMMETRIC_VERSION" VARCHAR(50), "CONFIG_VERSION" VARCHAR(50), "DATABASE_TYPE" VARCHAR(50), "DATABASE_VERSION" VARCHAR(50), "BATCH_TO_SEND_COUNT" INTEGER DEFAULT 0, "BATCH_IN_ERROR_COUNT" INTEGER DEFAULT 0, "CREATED_AT_NODE_ID" VARCHAR(50), "DEPLOYMENT_TYPE" VARCHAR(50), "DEPLOYMENT_SUB_TYPE" VARCHAR(50), PRIMARY KEY ("NODE_ID") ) 2019-05-11 05:06:05,461 INFO [server] [Firebird21SymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "SYM_NODE"( "NODE_ID" VARCHAR(50) NOT NULL, "NODE_GROUP_ID" VARCHAR(50) NOT NULL, "EXTERNAL_ID" VARCHAR(255) NOT NULL, "SYNC_ENABLED" SMALLINT DEFAULT 0, "SYNC_URL" VARCHAR(255), "SCHEMA_VERSION" VARCHAR(50), "SYMMETRIC_VERSION" VARCHAR(50), "CONFIG_VERSION" VARCHAR(50), "DATABASE_TYPE" VARCHAR(50), "DATABASE_VERSION" VARCHAR(50), "BATCH_TO_SEND_COUNT" INTEGER DEFAULT 0, "BATCH_IN_ERROR_COUNT" INTEGER DEFAULT 0, "CREATED_AT_NODE_ID" VARCHAR(50), "DEPLOYMENT_TYPE" VARCHAR(50), "DEPLOYMENT_SUB_TYPE" VARCHAR(50), PRIMARY KEY ("NODE_ID") ) 2019-05-11 05:06:05,539 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (78ms.) CREATE TABLE "SYM_NODE_COMMUNICATION"( "NODE_ID" VARCHAR(50) NOT NULL, "QUEUE" VARCHAR(25) DEFAULT 'default' NOT NULL, "COMMUNICATION_TYPE" VARCHAR(10) NOT NULL, "LOCK_TIME" TIMESTAMP, "LOCKING_SERVER_ID" VARCHAR(255), "LAST_LOCK_TIME" TIMESTAMP, "LAST_LOCK_MILLIS" BIGINT DEFAULT 0, "SUCCESS_COUNT" BIGINT DEFAULT 0, "FAIL_COUNT" BIGINT DEFAULT 0, "SKIP_COUNT" BIGINT DEFAULT 0, "TOTAL_SUCCESS_COUNT" BIGINT DEFAULT 0, "TOTAL_FAIL_COUNT" BIGINT DEFAULT 0, "TOTAL_SUCCESS_MILLIS" BIGINT DEFAULT 0, "TOTAL_FAIL_MILLIS" BIGINT DEFAULT 0, "BATCH_TO_SEND_COUNT" BIGINT DEFAULT 0, "NODE_PRIORITY" INTEGER DEFAULT 0, PRIMARY KEY ("NODE_ID", "QUEUE", "COMMUNICATION_TYPE") ) 2019-05-11 05:06:05,539 INFO [server] [Firebird21SymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "SYM_NODE_COMMUNICATION"( "NODE_ID" VARCHAR(50) NOT NULL, "QUEUE" VARCHAR(25) DEFAULT 'default' NOT NULL, "COMMUNICATION_TYPE" VARCHAR(10) NOT NULL, "LOCK_TIME" TIMESTAMP, "LOCKING_SERVER_ID" VARCHAR(255), "LAST_LOCK_TIME" TIMESTAMP, "LAST_LOCK_MILLIS" BIGINT DEFAULT 0, "SUCCESS_COUNT" BIGINT DEFAULT 0, "FAIL_COUNT" BIGINT DEFAULT 0, "SKIP_COUNT" BIGINT DEFAULT 0, "TOTAL_SUCCESS_COUNT" BIGINT DEFAULT 0, "TOTAL_FAIL_COUNT" BIGINT DEFAULT 0, "TOTAL_SUCCESS_MILLIS" BIGINT DEFAULT 0, "TOTAL_FAIL_MILLIS" BIGINT DEFAULT 0, "BATCH_TO_SEND_COUNT" BIGINT DEFAULT 0, "NODE_PRIORITY" INTEGER DEFAULT 0, PRIMARY KEY ("NODE_ID", "QUEUE", "COMMUNICATION_TYPE") ) 2019-05-11 05:06:05,539 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (0ms.) CREATE TABLE "SYM_NODE_CHANNEL_CTL"( "NODE_ID" VARCHAR(50) NOT NULL, "CHANNEL_ID" VARCHAR(128) NOT NULL, "SUSPEND_ENABLED" SMALLINT DEFAULT 0, "IGNORE_ENABLED" SMALLINT DEFAULT 0, "LAST_EXTRACT_TIME" TIMESTAMP, PRIMARY KEY ("NODE_ID", "CHANNEL_ID") ) 2019-05-11 05:06:05,539 INFO [server] [Firebird21SymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "SYM_NODE_CHANNEL_CTL"( "NODE_ID" VARCHAR(50) NOT NULL, "CHANNEL_ID" VARCHAR(128) NOT NULL, "SUSPEND_ENABLED" SMALLINT DEFAULT 0, "IGNORE_ENABLED" SMALLINT DEFAULT 0, "LAST_EXTRACT_TIME" TIMESTAMP, PRIMARY KEY ("NODE_ID", "CHANNEL_ID") ) 2019-05-11 05:06:05,554 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (15ms.) CREATE TABLE "SYM_NODE_GROUP"( "NODE_GROUP_ID" VARCHAR(50) NOT NULL, "DESCRIPTION" VARCHAR(255), "CREATE_TIME" TIMESTAMP, "LAST_UPDATE_BY" VARCHAR(50), "LAST_UPDATE_TIME" TIMESTAMP, PRIMARY KEY ("NODE_GROUP_ID") ) 2019-05-11 05:06:05,554 INFO [server] [Firebird21SymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "SYM_NODE_GROUP"( "NODE_GROUP_ID" VARCHAR(50) NOT NULL, "DESCRIPTION" VARCHAR(255), "CREATE_TIME" TIMESTAMP, "LAST_UPDATE_BY" VARCHAR(50), "LAST_UPDATE_TIME" TIMESTAMP, PRIMARY KEY ("NODE_GROUP_ID") ) 2019-05-11 05:06:05,586 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (32ms.) CREATE TABLE "SYM_NODE_GROUP_CHANNEL_WND"( "NODE_GROUP_ID" VARCHAR(50) NOT NULL, "CHANNEL_ID" VARCHAR(128) NOT NULL, "START_TIME" TIMESTAMP NOT NULL, "END_TIME" TIMESTAMP NOT NULL, "ENABLED" SMALLINT DEFAULT 0 NOT NULL, PRIMARY KEY ("NODE_GROUP_ID", "CHANNEL_ID", "START_TIME", "END_TIME") ) 2019-05-11 05:06:05,586 INFO [server] [Firebird21SymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "SYM_NODE_GROUP_CHANNEL_WND"( "NODE_GROUP_ID" VARCHAR(50) NOT NULL, "CHANNEL_ID" VARCHAR(128) NOT NULL, "START_TIME" TIMESTAMP NOT NULL, "END_TIME" TIMESTAMP NOT NULL, "ENABLED" SMALLINT DEFAULT 0 NOT NULL, PRIMARY KEY ("NODE_GROUP_ID", "CHANNEL_ID", "START_TIME", "END_TIME") ) 2019-05-11 05:06:05,617 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (31ms.) CREATE TABLE "SYM_NODE_GROUP_LINK"( "SOURCE_NODE_GROUP_ID" VARCHAR(50) NOT NULL, "TARGET_NODE_GROUP_ID" VARCHAR(50) NOT NULL, "DATA_EVENT_ACTION" CHAR(1) DEFAULT 'W' NOT NULL, "SYNC_CONFIG_ENABLED" SMALLINT DEFAULT 1 NOT NULL, "IS_REVERSIBLE" SMALLINT DEFAULT 0 NOT NULL, "CREATE_TIME" TIMESTAMP, "LAST_UPDATE_BY" VARCHAR(50), "LAST_UPDATE_TIME" TIMESTAMP, PRIMARY KEY ("SOURCE_NODE_GROUP_ID", "TARGET_NODE_GROUP_ID") ) 2019-05-11 05:06:05,632 INFO [server] [Firebird21SymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "SYM_NODE_GROUP_LINK"( "SOURCE_NODE_GROUP_ID" VARCHAR(50) NOT NULL, "TARGET_NODE_GROUP_ID" VARCHAR(50) NOT NULL, "DATA_EVENT_ACTION" CHAR(1) DEFAULT 'W' NOT NULL, "SYNC_CONFIG_ENABLED" SMALLINT DEFAULT 1 NOT NULL, "IS_REVERSIBLE" SMALLINT DEFAULT 0 NOT NULL, "CREATE_TIME" TIMESTAMP, "LAST_UPDATE_BY" VARCHAR(50), "LAST_UPDATE_TIME" TIMESTAMP, PRIMARY KEY ("SOURCE_NODE_GROUP_ID", "TARGET_NODE_GROUP_ID") ) 2019-05-11 05:06:05,648 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (16ms.) CREATE TABLE "SYM_NODE_HOST"( "NODE_ID" VARCHAR(50) NOT NULL, "HOST_NAME" VARCHAR(60) NOT NULL, "INSTANCE_ID" VARCHAR(60), "IP_ADDRESS" VARCHAR(50), "OS_USER" VARCHAR(50), "OS_NAME" VARCHAR(50), "OS_ARCH" VARCHAR(50), "OS_VERSION" VARCHAR(50), "AVAILABLE_PROCESSORS" INTEGER DEFAULT 0, "FREE_MEMORY_BYTES" BIGINT DEFAULT 0, "TOTAL_MEMORY_BYTES" BIGINT DEFAULT 0, "MAX_MEMORY_BYTES" BIGINT DEFAULT 0, "JAVA_VERSION" VARCHAR(50), "JAVA_VENDOR" VARCHAR(255), "JDBC_VERSION" VARCHAR(255), "SYMMETRIC_VERSION" VARCHAR(50), "TIMEZONE_OFFSET" VARCHAR(6), "HEARTBEAT_TIME" TIMESTAMP, "LAST_RESTART_TIME" TIMESTAMP NOT NULL, "CREATE_TIME" TIMESTAMP NOT NULL, PRIMARY KEY ("NODE_ID", "HOST_NAME") ) 2019-05-11 05:06:05,648 INFO [server] [Firebird21SymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "SYM_NODE_HOST"( "NODE_ID" VARCHAR(50) NOT NULL, "HOST_NAME" VARCHAR(60) NOT NULL, "INSTANCE_ID" VARCHAR(60), "IP_ADDRESS" VARCHAR(50), "OS_USER" VARCHAR(50), "OS_NAME" VARCHAR(50), "OS_ARCH" VARCHAR(50), "OS_VERSION" VARCHAR(50), "AVAILABLE_PROCESSORS" INTEGER DEFAULT 0, "FREE_MEMORY_BYTES" BIGINT DEFAULT 0, "TOTAL_MEMORY_BYTES" BIGINT DEFAULT 0, "MAX_MEMORY_BYTES" BIGINT DEFAULT 0, "JAVA_VERSION" VARCHAR(50), "JAVA_VENDOR" VARCHAR(255), "JDBC_VERSION" VARCHAR(255), "SYMMETRIC_VERSION" VARCHAR(50), "TIMEZONE_OFFSET" VARCHAR(6), "HEARTBEAT_TIME" TIMESTAMP, "LAST_RESTART_TIME" TIMESTAMP NOT NULL, "CREATE_TIME" TIMESTAMP NOT NULL, PRIMARY KEY ("NODE_ID", "HOST_NAME") ) 2019-05-11 05:06:05,664 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (16ms.) CREATE TABLE "SYM_NODE_HOST_CHANNEL_STATS"( "NODE_ID" VARCHAR(50) NOT NULL, "HOST_NAME" VARCHAR(60) NOT NULL, "CHANNEL_ID" VARCHAR(128) NOT NULL, "START_TIME" TIMESTAMP NOT NULL, "END_TIME" TIMESTAMP NOT NULL, "DATA_ROUTED" BIGINT DEFAULT 0, "DATA_UNROUTED" BIGINT DEFAULT 0, "DATA_EVENT_INSERTED" BIGINT DEFAULT 0, "DATA_EXTRACTED" BIGINT DEFAULT 0, "DATA_BYTES_EXTRACTED" BIGINT DEFAULT 0, "DATA_EXTRACTED_ERRORS" BIGINT DEFAULT 0, "DATA_BYTES_SENT" BIGINT DEFAULT 0, "DATA_SENT" BIGINT DEFAULT 0, "DATA_SENT_ERRORS" BIGINT DEFAULT 0, "DATA_LOADED" BIGINT DEFAULT 0, "DATA_BYTES_LOADED" BIGINT DEFAULT 0, "DATA_LOADED_ERRORS" BIGINT DEFAULT 0, "DATA_LOADED_OUTGOING" BIGINT DEFAULT 0, "DATA_BYTES_LOADED_OUTGOING" BIGINT DEFAULT 0, "DATA_LOADED_OUTGOING_ERRORS" BIGINT DEFAULT 0, PRIMARY KEY ("NODE_ID", "HOST_NAME", "CHANNEL_ID", "START_TIME", "END_TIME") ) 2019-05-11 05:06:05,664 INFO [server] [Firebird21SymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "SYM_NODE_HOST_CHANNEL_STATS"( "NODE_ID" VARCHAR(50) NOT NULL, "HOST_NAME" VARCHAR(60) NOT NULL, "CHANNEL_ID" VARCHAR(128) NOT NULL, "START_TIME" TIMESTAMP NOT NULL, "END_TIME" TIMESTAMP NOT NULL, "DATA_ROUTED" BIGINT DEFAULT 0, "DATA_UNROUTED" BIGINT DEFAULT 0, "DATA_EVENT_INSERTED" BIGINT DEFAULT 0, "DATA_EXTRACTED" BIGINT DEFAULT 0, "DATA_BYTES_EXTRACTED" BIGINT DEFAULT 0, "DATA_EXTRACTED_ERRORS" BIGINT DEFAULT 0, "DATA_BYTES_SENT" BIGINT DEFAULT 0, "DATA_SENT" BIGINT DEFAULT 0, "DATA_SENT_ERRORS" BIGINT DEFAULT 0, "DATA_LOADED" BIGINT DEFAULT 0, "DATA_BYTES_LOADED" BIGINT DEFAULT 0, "DATA_LOADED_ERRORS" BIGINT DEFAULT 0, "DATA_LOADED_OUTGOING" BIGINT DEFAULT 0, "DATA_BYTES_LOADED_OUTGOING" BIGINT DEFAULT 0, "DATA_LOADED_OUTGOING_ERRORS" BIGINT DEFAULT 0, PRIMARY KEY ("NODE_ID", "HOST_NAME", "CHANNEL_ID", "START_TIME", "END_TIME") ) 2019-05-11 05:06:05,679 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (15ms.) CREATE INDEX "SYM_IDX_ND_HST_CHNL_STS" ON "SYM_NODE_HOST_CHANNEL_STATS" ("NODE_ID", "START_TIME", "END_TIME") 2019-05-11 05:06:05,679 INFO [server] [Firebird21SymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE INDEX "SYM_IDX_ND_HST_CHNL_STS" ON "SYM_NODE_HOST_CHANNEL_STATS" ("NODE_ID", "START_TIME", "END_TIME") 2019-05-11 05:06:05,695 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (16ms.) CREATE TABLE "SYM_NODE_HOST_JOB_STATS"( "NODE_ID" VARCHAR(50) NOT NULL, "HOST_NAME" VARCHAR(60) NOT NULL, "JOB_NAME" VARCHAR(50) NOT NULL, "START_TIME" TIMESTAMP NOT NULL, "END_TIME" TIMESTAMP NOT NULL, "PROCESSED_COUNT" BIGINT DEFAULT 0, "TARGET_NODE_ID" VARCHAR(50), "TARGET_NODE_COUNT" INTEGER DEFAULT 0, PRIMARY KEY ("NODE_ID", "HOST_NAME", "JOB_NAME", "START_TIME", "END_TIME") ) 2019-05-11 05:06:05,711 INFO [server] [Firebird21SymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "SYM_NODE_HOST_JOB_STATS"( "NODE_ID" VARCHAR(50) NOT NULL, "HOST_NAME" VARCHAR(60) NOT NULL, "JOB_NAME" VARCHAR(50) NOT NULL, "START_TIME" TIMESTAMP NOT NULL, "END_TIME" TIMESTAMP NOT NULL, "PROCESSED_COUNT" BIGINT DEFAULT 0, "TARGET_NODE_ID" VARCHAR(50), "TARGET_NODE_COUNT" INTEGER DEFAULT 0, PRIMARY KEY ("NODE_ID", "HOST_NAME", "JOB_NAME", "START_TIME", "END_TIME") ) 2019-05-11 05:06:05,711 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (0ms.) CREATE INDEX "SYM_IDX_ND_HST_JOB" ON "SYM_NODE_HOST_JOB_STATS" ("NODE_ID", "START_TIME", "END_TIME") 2019-05-11 05:06:05,711 INFO [server] [Firebird21SymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE INDEX "SYM_IDX_ND_HST_JOB" ON "SYM_NODE_HOST_JOB_STATS" ("NODE_ID", "START_TIME", "END_TIME") 2019-05-11 05:06:05,726 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (15ms.) CREATE TABLE "SYM_NODE_HOST_STATS"( "NODE_ID" VARCHAR(50) NOT NULL, "HOST_NAME" VARCHAR(60) NOT NULL, "START_TIME" TIMESTAMP NOT NULL, "END_TIME" TIMESTAMP NOT NULL, "RESTARTED" BIGINT DEFAULT 0 NOT NULL, "NODES_PULLED" BIGINT DEFAULT 0, "TOTAL_NODES_PULL_TIME" BIGINT DEFAULT 0, "NODES_PUSHED" BIGINT DEFAULT 0, "TOTAL_NODES_PUSH_TIME" BIGINT DEFAULT 0, "NODES_REJECTED" BIGINT DEFAULT 0, "NODES_REGISTERED" BIGINT DEFAULT 0, "NODES_LOADED" BIGINT DEFAULT 0, "NODES_DISABLED" BIGINT DEFAULT 0, "PURGED_DATA_ROWS" BIGINT DEFAULT 0, "PURGED_DATA_EVENT_ROWS" BIGINT DEFAULT 0, "PURGED_BATCH_OUTGOING_ROWS" BIGINT DEFAULT 0, "PURGED_BATCH_INCOMING_ROWS" BIGINT DEFAULT 0, "TRIGGERS_CREATED_COUNT" BIGINT, "TRIGGERS_REBUILT_COUNT" BIGINT, "TRIGGERS_REMOVED_COUNT" BIGINT, PRIMARY KEY ("NODE_ID", "HOST_NAME", "START_TIME", "END_TIME") ) 2019-05-11 05:06:05,726 INFO [server] [Firebird21SymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "SYM_NODE_HOST_STATS"( "NODE_ID" VARCHAR(50) NOT NULL, "HOST_NAME" VARCHAR(60) NOT NULL, "START_TIME" TIMESTAMP NOT NULL, "END_TIME" TIMESTAMP NOT NULL, "RESTARTED" BIGINT DEFAULT 0 NOT NULL, "NODES_PULLED" BIGINT DEFAULT 0, "TOTAL_NODES_PULL_TIME" BIGINT DEFAULT 0, "NODES_PUSHED" BIGINT DEFAULT 0, "TOTAL_NODES_PUSH_TIME" BIGINT DEFAULT 0, "NODES_REJECTED" BIGINT DEFAULT 0, "NODES_REGISTERED" BIGINT DEFAULT 0, "NODES_LOADED" BIGINT DEFAULT 0, "NODES_DISABLED" BIGINT DEFAULT 0, "PURGED_DATA_ROWS" BIGINT DEFAULT 0, "PURGED_DATA_EVENT_ROWS" BIGINT DEFAULT 0, "PURGED_BATCH_OUTGOING_ROWS" BIGINT DEFAULT 0, "PURGED_BATCH_INCOMING_ROWS" BIGINT DEFAULT 0, "TRIGGERS_CREATED_COUNT" BIGINT, "TRIGGERS_REBUILT_COUNT" BIGINT, "TRIGGERS_REMOVED_COUNT" BIGINT, PRIMARY KEY ("NODE_ID", "HOST_NAME", "START_TIME", "END_TIME") ) 2019-05-11 05:06:05,742 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (16ms.) CREATE INDEX "SYM_IDX_ND_HST_STS" ON "SYM_NODE_HOST_STATS" ("NODE_ID", "START_TIME", "END_TIME") 2019-05-11 05:06:05,742 INFO [server] [Firebird21SymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE INDEX "SYM_IDX_ND_HST_STS" ON "SYM_NODE_HOST_STATS" ("NODE_ID", "START_TIME", "END_TIME") 2019-05-11 05:06:05,742 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (0ms.) CREATE TABLE "SYM_NODE_IDENTITY"( "NODE_ID" VARCHAR(50) NOT NULL, PRIMARY KEY ("NODE_ID") ) 2019-05-11 05:06:05,742 INFO [server] [Firebird21SymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "SYM_NODE_IDENTITY"( "NODE_ID" VARCHAR(50) NOT NULL, PRIMARY KEY ("NODE_ID") ) 2019-05-11 05:06:05,773 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (31ms.) CREATE TABLE "SYM_NODE_SECURITY"( "NODE_ID" VARCHAR(50) NOT NULL, "NODE_PASSWORD" VARCHAR(50) NOT NULL, "REGISTRATION_ENABLED" SMALLINT DEFAULT 0, "REGISTRATION_TIME" TIMESTAMP, "INITIAL_LOAD_ENABLED" SMALLINT DEFAULT 0, "INITIAL_LOAD_TIME" TIMESTAMP, "INITIAL_LOAD_ID" BIGINT, "INITIAL_LOAD_CREATE_BY" VARCHAR(255), "REV_INITIAL_LOAD_ENABLED" SMALLINT DEFAULT 0, "REV_INITIAL_LOAD_TIME" TIMESTAMP, "REV_INITIAL_LOAD_ID" BIGINT, "REV_INITIAL_LOAD_CREATE_BY" VARCHAR(255), "CREATED_AT_NODE_ID" VARCHAR(50), PRIMARY KEY ("NODE_ID") ) 2019-05-11 05:06:05,773 INFO [server] [Firebird21SymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "SYM_NODE_SECURITY"( "NODE_ID" VARCHAR(50) NOT NULL, "NODE_PASSWORD" VARCHAR(50) NOT NULL, "REGISTRATION_ENABLED" SMALLINT DEFAULT 0, "REGISTRATION_TIME" TIMESTAMP, "INITIAL_LOAD_ENABLED" SMALLINT DEFAULT 0, "INITIAL_LOAD_TIME" TIMESTAMP, "INITIAL_LOAD_ID" BIGINT, "INITIAL_LOAD_CREATE_BY" VARCHAR(255), "REV_INITIAL_LOAD_ENABLED" SMALLINT DEFAULT 0, "REV_INITIAL_LOAD_TIME" TIMESTAMP, "REV_INITIAL_LOAD_ID" BIGINT, "REV_INITIAL_LOAD_CREATE_BY" VARCHAR(255), "CREATED_AT_NODE_ID" VARCHAR(50), PRIMARY KEY ("NODE_ID") ) 2019-05-11 05:06:05,804 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (31ms.) CREATE TABLE "SYM_MONITOR"( "MONITOR_ID" VARCHAR(128) NOT NULL, "NODE_GROUP_ID" VARCHAR(50) DEFAULT 'ALL' NOT NULL, "EXTERNAL_ID" VARCHAR(255) DEFAULT 'ALL' NOT NULL, "TYPE" VARCHAR(50) NOT NULL, "EXPRESSION" BLOB SUB_TYPE TEXT, "THRESHOLD" BIGINT DEFAULT 0 NOT NULL, "RUN_PERIOD" INTEGER DEFAULT 0 NOT NULL, "RUN_COUNT" INTEGER DEFAULT 0 NOT NULL, "SEVERITY_LEVEL" INTEGER DEFAULT 0 NOT NULL, "ENABLED" SMALLINT DEFAULT 0 NOT NULL, "CREATE_TIME" TIMESTAMP, "LAST_UPDATE_BY" VARCHAR(50), "LAST_UPDATE_TIME" TIMESTAMP, PRIMARY KEY ("MONITOR_ID") ) 2019-05-11 05:06:05,804 INFO [server] [Firebird21SymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "SYM_MONITOR"( "MONITOR_ID" VARCHAR(128) NOT NULL, "NODE_GROUP_ID" VARCHAR(50) DEFAULT 'ALL' NOT NULL, "EXTERNAL_ID" VARCHAR(255) DEFAULT 'ALL' NOT NULL, "TYPE" VARCHAR(50) NOT NULL, "EXPRESSION" BLOB SUB_TYPE TEXT, "THRESHOLD" BIGINT DEFAULT 0 NOT NULL, "RUN_PERIOD" INTEGER DEFAULT 0 NOT NULL, "RUN_COUNT" INTEGER DEFAULT 0 NOT NULL, "SEVERITY_LEVEL" INTEGER DEFAULT 0 NOT NULL, "ENABLED" SMALLINT DEFAULT 0 NOT NULL, "CREATE_TIME" TIMESTAMP, "LAST_UPDATE_BY" VARCHAR(50), "LAST_UPDATE_TIME" TIMESTAMP, PRIMARY KEY ("MONITOR_ID") ) 2019-05-11 05:06:05,820 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (16ms.) CREATE TABLE "SYM_MONITOR_EVENT"( "MONITOR_ID" VARCHAR(128) NOT NULL, "NODE_ID" VARCHAR(50) NOT NULL, "EVENT_TIME" TIMESTAMP NOT NULL, "HOST_NAME" VARCHAR(60), "TYPE" VARCHAR(50) NOT NULL, "THRESHOLD" BIGINT DEFAULT 0 NOT NULL, "EVENT_VALUE" BIGINT DEFAULT 0 NOT NULL, "EVENT_COUNT" INTEGER DEFAULT 0 NOT NULL, "SEVERITY_LEVEL" INTEGER DEFAULT 0 NOT NULL, "IS_RESOLVED" SMALLINT DEFAULT 0 NOT NULL, "IS_NOTIFIED" SMALLINT DEFAULT 0 NOT NULL, "DETAILS" BLOB SUB_TYPE TEXT, "LAST_UPDATE_TIME" TIMESTAMP, PRIMARY KEY ("MONITOR_ID", "NODE_ID", "EVENT_TIME") ) 2019-05-11 05:06:05,820 INFO [server] [Firebird21SymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "SYM_MONITOR_EVENT"( "MONITOR_ID" VARCHAR(128) NOT NULL, "NODE_ID" VARCHAR(50) NOT NULL, "EVENT_TIME" TIMESTAMP NOT NULL, "HOST_NAME" VARCHAR(60), "TYPE" VARCHAR(50) NOT NULL, "THRESHOLD" BIGINT DEFAULT 0 NOT NULL, "EVENT_VALUE" BIGINT DEFAULT 0 NOT NULL, "EVENT_COUNT" INTEGER DEFAULT 0 NOT NULL, "SEVERITY_LEVEL" INTEGER DEFAULT 0 NOT NULL, "IS_RESOLVED" SMALLINT DEFAULT 0 NOT NULL, "IS_NOTIFIED" SMALLINT DEFAULT 0 NOT NULL, "DETAILS" BLOB SUB_TYPE TEXT, "LAST_UPDATE_TIME" TIMESTAMP, PRIMARY KEY ("MONITOR_ID", "NODE_ID", "EVENT_TIME") ) 2019-05-11 05:06:05,836 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (16ms.) CREATE TABLE "SYM_NOTIFICATION"( "NOTIFICATION_ID" VARCHAR(128) NOT NULL, "NODE_GROUP_ID" VARCHAR(50) DEFAULT 'ALL' NOT NULL, "EXTERNAL_ID" VARCHAR(255) DEFAULT 'ALL' NOT NULL, "SEVERITY_LEVEL" INTEGER DEFAULT 0 NOT NULL, "TYPE" VARCHAR(50) NOT NULL, "EXPRESSION" BLOB SUB_TYPE TEXT, "ENABLED" SMALLINT DEFAULT 0 NOT NULL, "CREATE_TIME" TIMESTAMP, "LAST_UPDATE_BY" VARCHAR(50), "LAST_UPDATE_TIME" TIMESTAMP, PRIMARY KEY ("NOTIFICATION_ID") ) 2019-05-11 05:06:05,836 INFO [server] [Firebird21SymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "SYM_NOTIFICATION"( "NOTIFICATION_ID" VARCHAR(128) NOT NULL, "NODE_GROUP_ID" VARCHAR(50) DEFAULT 'ALL' NOT NULL, "EXTERNAL_ID" VARCHAR(255) DEFAULT 'ALL' NOT NULL, "SEVERITY_LEVEL" INTEGER DEFAULT 0 NOT NULL, "TYPE" VARCHAR(50) NOT NULL, "EXPRESSION" BLOB SUB_TYPE TEXT, "ENABLED" SMALLINT DEFAULT 0 NOT NULL, "CREATE_TIME" TIMESTAMP, "LAST_UPDATE_BY" VARCHAR(50), "LAST_UPDATE_TIME" TIMESTAMP, PRIMARY KEY ("NOTIFICATION_ID") ) 2019-05-11 05:06:05,851 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (15ms.) CREATE TABLE "SYM_OUTGOING_BATCH"( "BATCH_ID" BIGINT NOT NULL, "NODE_ID" VARCHAR(50) NOT NULL, "CHANNEL_ID" VARCHAR(128), "STATUS" CHAR(2), "ERROR_FLAG" SMALLINT DEFAULT 0, "SQL_STATE" VARCHAR(10), "SQL_CODE" INTEGER DEFAULT 0 NOT NULL, "SQL_MESSAGE" BLOB SUB_TYPE TEXT, "LAST_UPDATE_HOSTNAME" VARCHAR(255), "LAST_UPDATE_TIME" TIMESTAMP, "CREATE_TIME" TIMESTAMP, "SUMMARY" VARCHAR(255), "IGNORE_COUNT" INTEGER DEFAULT 0 NOT NULL, "BYTE_COUNT" BIGINT DEFAULT 0 NOT NULL, "LOAD_FLAG" SMALLINT DEFAULT 0, "EXTRACT_COUNT" INTEGER DEFAULT 0 NOT NULL, "SENT_COUNT" INTEGER DEFAULT 0 NOT NULL, "LOAD_COUNT" INTEGER DEFAULT 0 NOT NULL, "RELOAD_ROW_COUNT" INTEGER DEFAULT 0 NOT NULL, "OTHER_ROW_COUNT" INTEGER DEFAULT 0 NOT NULL, "DATA_ROW_COUNT" INTEGER DEFAULT 0 NOT NULL, "EXTRACT_ROW_COUNT" INTEGER DEFAULT 0 NOT NULL, "LOAD_ROW_COUNT" INTEGER DEFAULT 0 NOT NULL, "DATA_INSERT_ROW_COUNT" INTEGER DEFAULT 0 NOT NULL, "DATA_UPDATE_ROW_COUNT" INTEGER DEFAULT 0 NOT NULL, "DATA_DELETE_ROW_COUNT" INTEGER DEFAULT 0 NOT NULL, "EXTRACT_INSERT_ROW_COUNT" INTEGER DEFAULT 0 NOT NULL, "EXTRACT_UPDATE_ROW_COUNT" INTEGER DEFAULT 0 NOT NULL, "EXTRACT_DELETE_ROW_COUNT" INTEGER DEFAULT 0 NOT NULL, "LOAD_INSERT_ROW_COUNT" INTEGER DEFAULT 0 NOT NULL, "LOAD_UPDATE_ROW_COUNT" INTEGER DEFAULT 0 NOT NULL, "LOAD_DELETE_ROW_COUNT" INTEGER DEFAULT 0 NOT NULL, "NETWORK_MILLIS" INTEGER DEFAULT 0 NOT NULL, "FILTER_MILLIS" INTEGER DEFAULT 0 NOT NULL, "LOAD_MILLIS" INTEGER DEFAULT 0 NOT NULL, "ROUTER_MILLIS" INTEGER DEFAULT 0 NOT NULL, "EXTRACT_MILLIS" INTEGER DEFAULT 0 NOT NULL, "TRANSFORM_EXTRACT_MILLIS" INTEGER DEFAULT 0 NOT NULL, "TRANSFORM_LOAD_MILLIS" INTEGER DEFAULT 0 NOT NULL, "LOAD_ID" BIGINT, "COMMON_FLAG" SMALLINT DEFAULT 0, "FALLBACK_INSERT_COUNT" INTEGER DEFAULT 0 NOT NULL, "FALLBACK_UPDATE_COUNT" INTEGER DEFAULT 0 NOT NULL, "IGNORE_ROW_COUNT" INTEGER DEFAULT 0 NOT NULL, "MISSING_DELETE_COUNT" INTEGER DEFAULT 0 NOT NULL, "SKIP_COUNT" INTEGER DEFAULT 0 NOT NULL, "TOTAL_EXTRACT_MILLIS" INTEGER DEFAULT 0 NOT NULL, "TOTAL_LOAD_MILLIS" INTEGER DEFAULT 0 NOT NULL, "EXTRACT_JOB_FLAG" SMALLINT DEFAULT 0, "EXTRACT_START_TIME" TIMESTAMP, "TRANSFER_START_TIME" TIMESTAMP, "LOAD_START_TIME" TIMESTAMP, "FAILED_DATA_ID" BIGINT DEFAULT 0 NOT NULL, "FAILED_LINE_NUMBER" BIGINT DEFAULT 0 NOT NULL, "CREATE_BY" VARCHAR(255), PRIMARY KEY ("BATCH_ID", "NODE_ID") ) 2019-05-11 05:06:05,867 INFO [server] [Firebird21SymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "SYM_OUTGOING_BATCH"( "BATCH_ID" BIGINT NOT NULL, "NODE_ID" VARCHAR(50) NOT NULL, "CHANNEL_ID" VARCHAR(128), "STATUS" CHAR(2), "ERROR_FLAG" SMALLINT DEFAULT 0, "SQL_STATE" VARCHAR(10), "SQL_CODE" INTEGER DEFAULT 0 NOT NULL, "SQL_MESSAGE" BLOB SUB_TYPE TEXT, "LAST_UPDATE_HOSTNAME" VARCHAR(255), "LAST_UPDATE_TIME" TIMESTAMP, "CREATE_TIME" TIMESTAMP, "SUMMARY" VARCHAR(255), "IGNORE_COUNT" INTEGER DEFAULT 0 NOT NULL, "BYTE_COUNT" BIGINT DEFAULT 0 NOT NULL, "LOAD_FLAG" SMALLINT DEFAULT 0, "EXTRACT_COUNT" INTEGER DEFAULT 0 NOT NULL, "SENT_COUNT" INTEGER DEFAULT 0 NOT NULL, "LOAD_COUNT" INTEGER DEFAULT 0 NOT NULL, "RELOAD_ROW_COUNT" INTEGER DEFAULT 0 NOT NULL, "OTHER_ROW_COUNT" INTEGER DEFAULT 0 NOT NULL, "DATA_ROW_COUNT" INTEGER DEFAULT 0 NOT NULL, "EXTRACT_ROW_COUNT" INTEGER DEFAULT 0 NOT NULL, "LOAD_ROW_COUNT" INTEGER DEFAULT 0 NOT NULL, "DATA_INSERT_ROW_COUNT" INTEGER DEFAULT 0 NOT NULL, "DATA_UPDATE_ROW_COUNT" INTEGER DEFAULT 0 NOT NULL, "DATA_DELETE_ROW_COUNT" INTEGER DEFAULT 0 NOT NULL, "EXTRACT_INSERT_ROW_COUNT" INTEGER DEFAULT 0 NOT NULL, "EXTRACT_UPDATE_ROW_COUNT" INTEGER DEFAULT 0 NOT NULL, "EXTRACT_DELETE_ROW_COUNT" INTEGER DEFAULT 0 NOT NULL, "LOAD_INSERT_ROW_COUNT" INTEGER DEFAULT 0 NOT NULL, "LOAD_UPDATE_ROW_COUNT" INTEGER DEFAULT 0 NOT NULL, "LOAD_DELETE_ROW_COUNT" INTEGER DEFAULT 0 NOT NULL, "NETWORK_MILLIS" INTEGER DEFAULT 0 NOT NULL, "FILTER_MILLIS" INTEGER DEFAULT 0 NOT NULL, "LOAD_MILLIS" INTEGER DEFAULT 0 NOT NULL, "ROUTER_MILLIS" INTEGER DEFAULT 0 NOT NULL, "EXTRACT_MILLIS" INTEGER DEFAULT 0 NOT NULL, "TRANSFORM_EXTRACT_MILLIS" INTEGER DEFAULT 0 NOT NULL, "TRANSFORM_LOAD_MILLIS" INTEGER DEFAULT 0 NOT NULL, "LOAD_ID" BIGINT, "COMMON_FLAG" SMALLINT DEFAULT 0, "FALLBACK_INSERT_COUNT" INTEGER DEFAULT 0 NOT NULL, "FALLBACK_UPDATE_COUNT" INTEGER DEFAULT 0 NOT NULL, "IGNORE_ROW_COUNT" INTEGER DEFAULT 0 NOT NULL, "MISSING_DELETE_COUNT" INTEGER DEFAULT 0 NOT NULL, "SKIP_COUNT" INTEGER DEFAULT 0 NOT NULL, "TOTAL_EXTRACT_MILLIS" INTEGER DEFAULT 0 NOT NULL, "TOTAL_LOAD_MILLIS" INTEGER DEFAULT 0 NOT NULL, "EXTRACT_JOB_FLAG" SMALLINT DEFAULT 0, "EXTRACT_START_TIME" TIMESTAMP, "TRANSFER_START_TIME" TIMESTAMP, "LOAD_START_TIME" TIMESTAMP, "FAILED_DATA_ID" BIGINT DEFAULT 0 NOT NULL, "FAILED_LINE_NUMBER" BIGINT DEFAULT 0 NOT NULL, "CREATE_BY" VARCHAR(255), PRIMARY KEY ("BATCH_ID", "NODE_ID") ) 2019-05-11 05:06:05,867 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (0ms.) CREATE INDEX "SYM_IDX_OB_NODE_STATUS" ON "SYM_OUTGOING_BATCH" ("NODE_ID", "STATUS") 2019-05-11 05:06:05,867 INFO [server] [Firebird21SymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE INDEX "SYM_IDX_OB_NODE_STATUS" ON "SYM_OUTGOING_BATCH" ("NODE_ID", "STATUS") 2019-05-11 05:06:05,867 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (0ms.) CREATE INDEX "SYM_IDX_OB_STATUS" ON "SYM_OUTGOING_BATCH" ("STATUS") 2019-05-11 05:06:05,867 INFO [server] [Firebird21SymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE INDEX "SYM_IDX_OB_STATUS" ON "SYM_OUTGOING_BATCH" ("STATUS") 2019-05-11 05:06:05,882 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (15ms.) CREATE INDEX "SYM_IDX_OB_IN_ERROR" ON "SYM_OUTGOING_BATCH" ("ERROR_FLAG") 2019-05-11 05:06:05,882 INFO [server] [Firebird21SymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE INDEX "SYM_IDX_OB_IN_ERROR" ON "SYM_OUTGOING_BATCH" ("ERROR_FLAG") 2019-05-11 05:06:05,929 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (47ms.) CREATE TABLE "SYM_PARAMETER"( "EXTERNAL_ID" VARCHAR(255) NOT NULL, "NODE_GROUP_ID" VARCHAR(50) NOT NULL, "PARAM_KEY" VARCHAR(80) NOT NULL, "PARAM_VALUE" BLOB SUB_TYPE TEXT, "CREATE_TIME" TIMESTAMP, "LAST_UPDATE_BY" VARCHAR(50), "LAST_UPDATE_TIME" TIMESTAMP, PRIMARY KEY ("EXTERNAL_ID", "NODE_GROUP_ID", "PARAM_KEY") ) 2019-05-11 05:06:05,929 INFO [server] [Firebird21SymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "SYM_PARAMETER"( "EXTERNAL_ID" VARCHAR(255) NOT NULL, "NODE_GROUP_ID" VARCHAR(50) NOT NULL, "PARAM_KEY" VARCHAR(80) NOT NULL, "PARAM_VALUE" BLOB SUB_TYPE TEXT, "CREATE_TIME" TIMESTAMP, "LAST_UPDATE_BY" VARCHAR(50), "LAST_UPDATE_TIME" TIMESTAMP, PRIMARY KEY ("EXTERNAL_ID", "NODE_GROUP_ID", "PARAM_KEY") ) 2019-05-11 05:06:05,929 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (0ms.) CREATE TABLE "SYM_REGISTRATION_REDIRECT"( "REGISTRANT_EXTERNAL_ID" VARCHAR(255) NOT NULL, "REGISTRATION_NODE_ID" VARCHAR(50) NOT NULL, PRIMARY KEY ("REGISTRANT_EXTERNAL_ID") ) 2019-05-11 05:06:05,929 INFO [server] [Firebird21SymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "SYM_REGISTRATION_REDIRECT"( "REGISTRANT_EXTERNAL_ID" VARCHAR(255) NOT NULL, "REGISTRATION_NODE_ID" VARCHAR(50) NOT NULL, PRIMARY KEY ("REGISTRANT_EXTERNAL_ID") ) 2019-05-11 05:06:05,961 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (32ms.) CREATE TABLE "SYM_REGISTRATION_REQUEST"( "NODE_GROUP_ID" VARCHAR(50) NOT NULL, "EXTERNAL_ID" VARCHAR(255) NOT NULL, "STATUS" CHAR(2) NOT NULL, "HOST_NAME" VARCHAR(60) NOT NULL, "IP_ADDRESS" VARCHAR(50) NOT NULL, "ATTEMPT_COUNT" INTEGER DEFAULT 0, "REGISTERED_NODE_ID" VARCHAR(50), "ERROR_MESSAGE" BLOB SUB_TYPE TEXT, "CREATE_TIME" TIMESTAMP NOT NULL, "LAST_UPDATE_BY" VARCHAR(50), "LAST_UPDATE_TIME" TIMESTAMP NOT NULL, PRIMARY KEY ("NODE_GROUP_ID", "EXTERNAL_ID", "CREATE_TIME") ) 2019-05-11 05:06:05,961 INFO [server] [Firebird21SymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "SYM_REGISTRATION_REQUEST"( "NODE_GROUP_ID" VARCHAR(50) NOT NULL, "EXTERNAL_ID" VARCHAR(255) NOT NULL, "STATUS" CHAR(2) NOT NULL, "HOST_NAME" VARCHAR(60) NOT NULL, "IP_ADDRESS" VARCHAR(50) NOT NULL, "ATTEMPT_COUNT" INTEGER DEFAULT 0, "REGISTERED_NODE_ID" VARCHAR(50), "ERROR_MESSAGE" BLOB SUB_TYPE TEXT, "CREATE_TIME" TIMESTAMP NOT NULL, "LAST_UPDATE_BY" VARCHAR(50), "LAST_UPDATE_TIME" TIMESTAMP NOT NULL, PRIMARY KEY ("NODE_GROUP_ID", "EXTERNAL_ID", "CREATE_TIME") ) 2019-05-11 05:06:05,976 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (15ms.) CREATE INDEX "SYM_IDX_REG_REQ_1" ON "SYM_REGISTRATION_REQUEST" ("NODE_GROUP_ID", "EXTERNAL_ID", "STATUS", "HOST_NAME", "IP_ADDRESS") 2019-05-11 05:06:05,976 INFO [server] [Firebird21SymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE INDEX "SYM_IDX_REG_REQ_1" ON "SYM_REGISTRATION_REQUEST" ("NODE_GROUP_ID", "EXTERNAL_ID", "STATUS", "HOST_NAME", "IP_ADDRESS") 2019-05-11 05:06:05,992 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (16ms.) CREATE INDEX "SYM_IDX_REG_REQ_2" ON "SYM_REGISTRATION_REQUEST" ("STATUS") 2019-05-11 05:06:05,992 INFO [server] [Firebird21SymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE INDEX "SYM_IDX_REG_REQ_2" ON "SYM_REGISTRATION_REQUEST" ("STATUS") 2019-05-11 05:06:06,007 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (15ms.) CREATE TABLE "SYM_ROUTER"( "ROUTER_ID" VARCHAR(50) NOT NULL, "TARGET_CATALOG_NAME" VARCHAR(255), "TARGET_SCHEMA_NAME" VARCHAR(255), "TARGET_TABLE_NAME" VARCHAR(255), "SOURCE_NODE_GROUP_ID" VARCHAR(50) NOT NULL, "TARGET_NODE_GROUP_ID" VARCHAR(50) NOT NULL, "ROUTER_TYPE" VARCHAR(50), "ROUTER_EXPRESSION" BLOB SUB_TYPE TEXT, "SYNC_ON_UPDATE" SMALLINT DEFAULT 1 NOT NULL, "SYNC_ON_INSERT" SMALLINT DEFAULT 1 NOT NULL, "SYNC_ON_DELETE" SMALLINT DEFAULT 1 NOT NULL, "USE_SOURCE_CATALOG_SCHEMA" SMALLINT DEFAULT 1 NOT NULL, "CREATE_TIME" TIMESTAMP NOT NULL, "LAST_UPDATE_BY" VARCHAR(50), "LAST_UPDATE_TIME" TIMESTAMP NOT NULL, "DESCRIPTION" BLOB SUB_TYPE TEXT, PRIMARY KEY ("ROUTER_ID") ) 2019-05-11 05:06:06,007 INFO [server] [Firebird21SymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "SYM_ROUTER"( "ROUTER_ID" VARCHAR(50) NOT NULL, "TARGET_CATALOG_NAME" VARCHAR(255), "TARGET_SCHEMA_NAME" VARCHAR(255), "TARGET_TABLE_NAME" VARCHAR(255), "SOURCE_NODE_GROUP_ID" VARCHAR(50) NOT NULL, "TARGET_NODE_GROUP_ID" VARCHAR(50) NOT NULL, "ROUTER_TYPE" VARCHAR(50), "ROUTER_EXPRESSION" BLOB SUB_TYPE TEXT, "SYNC_ON_UPDATE" SMALLINT DEFAULT 1 NOT NULL, "SYNC_ON_INSERT" SMALLINT DEFAULT 1 NOT NULL, "SYNC_ON_DELETE" SMALLINT DEFAULT 1 NOT NULL, "USE_SOURCE_CATALOG_SCHEMA" SMALLINT DEFAULT 1 NOT NULL, "CREATE_TIME" TIMESTAMP NOT NULL, "LAST_UPDATE_BY" VARCHAR(50), "LAST_UPDATE_TIME" TIMESTAMP NOT NULL, "DESCRIPTION" BLOB SUB_TYPE TEXT, PRIMARY KEY ("ROUTER_ID") ) 2019-05-11 05:06:06,023 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (16ms.) CREATE TABLE "SYM_SEQUENCE"( "SEQUENCE_NAME" VARCHAR(50) NOT NULL, "CURRENT_VALUE" BIGINT DEFAULT 0 NOT NULL, "INCREMENT_BY" INTEGER DEFAULT 1 NOT NULL, "MIN_VALUE" BIGINT DEFAULT 1 NOT NULL, "MAX_VALUE" BIGINT DEFAULT 9999999999 NOT NULL, "CYCLE_FLAG" SMALLINT DEFAULT 0, "CACHE_SIZE" INTEGER DEFAULT 0 NOT NULL, "CREATE_TIME" TIMESTAMP, "LAST_UPDATE_BY" VARCHAR(50), "LAST_UPDATE_TIME" TIMESTAMP NOT NULL, PRIMARY KEY ("SEQUENCE_NAME") ) 2019-05-11 05:06:06,023 INFO [server] [Firebird21SymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "SYM_SEQUENCE"( "SEQUENCE_NAME" VARCHAR(50) NOT NULL, "CURRENT_VALUE" BIGINT DEFAULT 0 NOT NULL, "INCREMENT_BY" INTEGER DEFAULT 1 NOT NULL, "MIN_VALUE" BIGINT DEFAULT 1 NOT NULL, "MAX_VALUE" BIGINT DEFAULT 9999999999 NOT NULL, "CYCLE_FLAG" SMALLINT DEFAULT 0, "CACHE_SIZE" INTEGER DEFAULT 0 NOT NULL, "CREATE_TIME" TIMESTAMP, "LAST_UPDATE_BY" VARCHAR(50), "LAST_UPDATE_TIME" TIMESTAMP NOT NULL, PRIMARY KEY ("SEQUENCE_NAME") ) 2019-05-11 05:06:06,039 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (16ms.) CREATE TABLE "SYM_TABLE_RELOAD_REQUEST"( "TARGET_NODE_ID" VARCHAR(50) NOT NULL, "SOURCE_NODE_ID" VARCHAR(50) NOT NULL, "TRIGGER_ID" VARCHAR(128) NOT NULL, "ROUTER_ID" VARCHAR(50) NOT NULL, "CREATE_TIME" TIMESTAMP NOT NULL, "CREATE_TABLE" SMALLINT DEFAULT 0 NOT NULL, "DELETE_FIRST" SMALLINT DEFAULT 0 NOT NULL, "RELOAD_SELECT" BLOB SUB_TYPE TEXT, "BEFORE_CUSTOM_SQL" BLOB SUB_TYPE TEXT, "RELOAD_TIME" TIMESTAMP, "LOAD_ID" BIGINT, "PROCESSED" SMALLINT DEFAULT 0 NOT NULL, "CHANNEL_ID" VARCHAR(128), "LAST_UPDATE_BY" VARCHAR(50), "LAST_UPDATE_TIME" TIMESTAMP NOT NULL, PRIMARY KEY ("TARGET_NODE_ID", "SOURCE_NODE_ID", "TRIGGER_ID", "ROUTER_ID", "CREATE_TIME") ) 2019-05-11 05:06:06,039 INFO [server] [Firebird21SymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "SYM_TABLE_RELOAD_REQUEST"( "TARGET_NODE_ID" VARCHAR(50) NOT NULL, "SOURCE_NODE_ID" VARCHAR(50) NOT NULL, "TRIGGER_ID" VARCHAR(128) NOT NULL, "ROUTER_ID" VARCHAR(50) NOT NULL, "CREATE_TIME" TIMESTAMP NOT NULL, "CREATE_TABLE" SMALLINT DEFAULT 0 NOT NULL, "DELETE_FIRST" SMALLINT DEFAULT 0 NOT NULL, "RELOAD_SELECT" BLOB SUB_TYPE TEXT, "BEFORE_CUSTOM_SQL" BLOB SUB_TYPE TEXT, "RELOAD_TIME" TIMESTAMP, "LOAD_ID" BIGINT, "PROCESSED" SMALLINT DEFAULT 0 NOT NULL, "CHANNEL_ID" VARCHAR(128), "LAST_UPDATE_BY" VARCHAR(50), "LAST_UPDATE_TIME" TIMESTAMP NOT NULL, PRIMARY KEY ("TARGET_NODE_ID", "SOURCE_NODE_ID", "TRIGGER_ID", "ROUTER_ID", "CREATE_TIME") ) 2019-05-11 05:06:06,054 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (15ms.) CREATE TABLE "SYM_TABLE_RELOAD_STATUS"( "LOAD_ID" BIGINT NOT NULL, "SOURCE_NODE_ID" VARCHAR(50) NOT NULL, "TARGET_NODE_ID" VARCHAR(50) NOT NULL, "START_TIME" TIMESTAMP, "END_TIME" TIMESTAMP, "COMPLETED" SMALLINT DEFAULT 0 NOT NULL, "CANCELLED" SMALLINT DEFAULT 0 NOT NULL, "START_DATA_BATCH_ID" BIGINT, "END_DATA_BATCH_ID" BIGINT, "SETUP_BATCH_COUNT" BIGINT DEFAULT 0 NOT NULL, "DATA_BATCH_COUNT" BIGINT DEFAULT 0 NOT NULL, "FINALIZE_BATCH_COUNT" BIGINT DEFAULT 0 NOT NULL, "SETUP_BATCH_LOADED" BIGINT DEFAULT 0 NOT NULL, "DATA_BATCH_LOADED" BIGINT DEFAULT 0 NOT NULL, "FINALIZE_BATCH_LOADED" BIGINT DEFAULT 0 NOT NULL, "TABLE_COUNT" BIGINT DEFAULT 0 NOT NULL, "ROWS_LOADED" BIGINT DEFAULT 0 NOT NULL, "ROWS_COUNT" BIGINT DEFAULT 0 NOT NULL, "ERROR_FLAG" SMALLINT DEFAULT 0 NOT NULL, "SQL_STATE" VARCHAR(10), "SQL_CODE" INTEGER DEFAULT 0 NOT NULL, "SQL_MESSAGE" BLOB SUB_TYPE TEXT, "LAST_UPDATE_BY" VARCHAR(50), "LAST_UPDATE_TIME" TIMESTAMP NOT NULL, PRIMARY KEY ("LOAD_ID", "SOURCE_NODE_ID") ) 2019-05-11 05:06:06,054 INFO [server] [Firebird21SymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "SYM_TABLE_RELOAD_STATUS"( "LOAD_ID" BIGINT NOT NULL, "SOURCE_NODE_ID" VARCHAR(50) NOT NULL, "TARGET_NODE_ID" VARCHAR(50) NOT NULL, "START_TIME" TIMESTAMP, "END_TIME" TIMESTAMP, "COMPLETED" SMALLINT DEFAULT 0 NOT NULL, "CANCELLED" SMALLINT DEFAULT 0 NOT NULL, "START_DATA_BATCH_ID" BIGINT, "END_DATA_BATCH_ID" BIGINT, "SETUP_BATCH_COUNT" BIGINT DEFAULT 0 NOT NULL, "DATA_BATCH_COUNT" BIGINT DEFAULT 0 NOT NULL, "FINALIZE_BATCH_COUNT" BIGINT DEFAULT 0 NOT NULL, "SETUP_BATCH_LOADED" BIGINT DEFAULT 0 NOT NULL, "DATA_BATCH_LOADED" BIGINT DEFAULT 0 NOT NULL, "FINALIZE_BATCH_LOADED" BIGINT DEFAULT 0 NOT NULL, "TABLE_COUNT" BIGINT DEFAULT 0 NOT NULL, "ROWS_LOADED" BIGINT DEFAULT 0 NOT NULL, "ROWS_COUNT" BIGINT DEFAULT 0 NOT NULL, "ERROR_FLAG" SMALLINT DEFAULT 0 NOT NULL, "SQL_STATE" VARCHAR(10), "SQL_CODE" INTEGER DEFAULT 0 NOT NULL, "SQL_MESSAGE" BLOB SUB_TYPE TEXT, "LAST_UPDATE_BY" VARCHAR(50), "LAST_UPDATE_TIME" TIMESTAMP NOT NULL, PRIMARY KEY ("LOAD_ID", "SOURCE_NODE_ID") ) 2019-05-11 05:06:06,070 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (16ms.) CREATE TABLE "SYM_TRANSFORM_TABLE"( "TRANSFORM_ID" VARCHAR(50) NOT NULL, "SOURCE_NODE_GROUP_ID" VARCHAR(50) NOT NULL, "TARGET_NODE_GROUP_ID" VARCHAR(50) NOT NULL, "TRANSFORM_POINT" VARCHAR(10) NOT NULL, "SOURCE_CATALOG_NAME" VARCHAR(255), "SOURCE_SCHEMA_NAME" VARCHAR(255), "SOURCE_TABLE_NAME" VARCHAR(255) NOT NULL, "TARGET_CATALOG_NAME" VARCHAR(255), "TARGET_SCHEMA_NAME" VARCHAR(255), "TARGET_TABLE_NAME" VARCHAR(255), "UPDATE_FIRST" SMALLINT DEFAULT 0, "UPDATE_ACTION" VARCHAR(255) DEFAULT 'UPDATE_COL' NOT NULL, "DELETE_ACTION" VARCHAR(10) NOT NULL, "TRANSFORM_ORDER" INTEGER DEFAULT 1 NOT NULL, "COLUMN_POLICY" VARCHAR(10) DEFAULT 'SPECIFIED' NOT NULL, "CREATE_TIME" TIMESTAMP, "LAST_UPDATE_BY" VARCHAR(50), "LAST_UPDATE_TIME" TIMESTAMP, "DESCRIPTION" BLOB SUB_TYPE TEXT, PRIMARY KEY ("TRANSFORM_ID", "SOURCE_NODE_GROUP_ID", "TARGET_NODE_GROUP_ID") ) 2019-05-11 05:06:06,070 INFO [server] [Firebird21SymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "SYM_TRANSFORM_TABLE"( "TRANSFORM_ID" VARCHAR(50) NOT NULL, "SOURCE_NODE_GROUP_ID" VARCHAR(50) NOT NULL, "TARGET_NODE_GROUP_ID" VARCHAR(50) NOT NULL, "TRANSFORM_POINT" VARCHAR(10) NOT NULL, "SOURCE_CATALOG_NAME" VARCHAR(255), "SOURCE_SCHEMA_NAME" VARCHAR(255), "SOURCE_TABLE_NAME" VARCHAR(255) NOT NULL, "TARGET_CATALOG_NAME" VARCHAR(255), "TARGET_SCHEMA_NAME" VARCHAR(255), "TARGET_TABLE_NAME" VARCHAR(255), "UPDATE_FIRST" SMALLINT DEFAULT 0, "UPDATE_ACTION" VARCHAR(255) DEFAULT 'UPDATE_COL' NOT NULL, "DELETE_ACTION" VARCHAR(10) NOT NULL, "TRANSFORM_ORDER" INTEGER DEFAULT 1 NOT NULL, "COLUMN_POLICY" VARCHAR(10) DEFAULT 'SPECIFIED' NOT NULL, "CREATE_TIME" TIMESTAMP, "LAST_UPDATE_BY" VARCHAR(50), "LAST_UPDATE_TIME" TIMESTAMP, "DESCRIPTION" BLOB SUB_TYPE TEXT, PRIMARY KEY ("TRANSFORM_ID", "SOURCE_NODE_GROUP_ID", "TARGET_NODE_GROUP_ID") ) 2019-05-11 05:06:06,086 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (16ms.) CREATE TABLE "SYM_TRANSFORM_COLUMN"( "TRANSFORM_ID" VARCHAR(50) NOT NULL, "INCLUDE_ON" CHAR(1) DEFAULT '' NOT NULL, "TARGET_COLUMN_NAME" VARCHAR(128) NOT NULL, "SOURCE_COLUMN_NAME" VARCHAR(128), "PK" SMALLINT DEFAULT 0, "TRANSFORM_TYPE" VARCHAR(50) DEFAULT 'copy', "TRANSFORM_EXPRESSION" BLOB SUB_TYPE TEXT, "TRANSFORM_ORDER" INTEGER DEFAULT 1 NOT NULL, "CREATE_TIME" TIMESTAMP, "LAST_UPDATE_BY" VARCHAR(50), "LAST_UPDATE_TIME" TIMESTAMP, "DESCRIPTION" BLOB SUB_TYPE TEXT, PRIMARY KEY ("TRANSFORM_ID", "INCLUDE_ON", "TARGET_COLUMN_NAME") ) 2019-05-11 05:06:06,086 INFO [server] [Firebird21SymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "SYM_TRANSFORM_COLUMN"( "TRANSFORM_ID" VARCHAR(50) NOT NULL, "INCLUDE_ON" CHAR(1) DEFAULT '' NOT NULL, "TARGET_COLUMN_NAME" VARCHAR(128) NOT NULL, "SOURCE_COLUMN_NAME" VARCHAR(128), "PK" SMALLINT DEFAULT 0, "TRANSFORM_TYPE" VARCHAR(50) DEFAULT 'copy', "TRANSFORM_EXPRESSION" BLOB SUB_TYPE TEXT, "TRANSFORM_ORDER" INTEGER DEFAULT 1 NOT NULL, "CREATE_TIME" TIMESTAMP, "LAST_UPDATE_BY" VARCHAR(50), "LAST_UPDATE_TIME" TIMESTAMP, "DESCRIPTION" BLOB SUB_TYPE TEXT, PRIMARY KEY ("TRANSFORM_ID", "INCLUDE_ON", "TARGET_COLUMN_NAME") ) 2019-05-11 05:06:06,117 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (31ms.) CREATE TABLE "SYM_TRIGGER"( "TRIGGER_ID" VARCHAR(128) NOT NULL, "SOURCE_CATALOG_NAME" VARCHAR(255), "SOURCE_SCHEMA_NAME" VARCHAR(255), "SOURCE_TABLE_NAME" VARCHAR(255) NOT NULL, "CHANNEL_ID" VARCHAR(128) NOT NULL, "RELOAD_CHANNEL_ID" VARCHAR(128) DEFAULT 'reload' NOT NULL, "SYNC_ON_UPDATE" SMALLINT DEFAULT 1 NOT NULL, "SYNC_ON_INSERT" SMALLINT DEFAULT 1 NOT NULL, "SYNC_ON_DELETE" SMALLINT DEFAULT 1 NOT NULL, "SYNC_ON_INCOMING_BATCH" SMALLINT DEFAULT 0 NOT NULL, "NAME_FOR_UPDATE_TRIGGER" VARCHAR(255), "NAME_FOR_INSERT_TRIGGER" VARCHAR(255), "NAME_FOR_DELETE_TRIGGER" VARCHAR(255), "SYNC_ON_UPDATE_CONDITION" BLOB SUB_TYPE TEXT, "SYNC_ON_INSERT_CONDITION" BLOB SUB_TYPE TEXT, "SYNC_ON_DELETE_CONDITION" BLOB SUB_TYPE TEXT, "CUSTOM_BEFORE_UPDATE_TEXT" BLOB SUB_TYPE TEXT, "CUSTOM_BEFORE_INSERT_TEXT" BLOB SUB_TYPE TEXT, "CUSTOM_BEFORE_DELETE_TEXT" BLOB SUB_TYPE TEXT, "CUSTOM_ON_UPDATE_TEXT" BLOB SUB_TYPE TEXT, "CUSTOM_ON_INSERT_TEXT" BLOB SUB_TYPE TEXT, "CUSTOM_ON_DELETE_TEXT" BLOB SUB_TYPE TEXT, "EXTERNAL_SELECT" BLOB SUB_TYPE TEXT, "TX_ID_EXPRESSION" BLOB SUB_TYPE TEXT, "CHANNEL_EXPRESSION" BLOB SUB_TYPE TEXT, "EXCLUDED_COLUMN_NAMES" BLOB SUB_TYPE TEXT, "INCLUDED_COLUMN_NAMES" BLOB SUB_TYPE TEXT, "SYNC_KEY_NAMES" BLOB SUB_TYPE TEXT, "USE_STREAM_LOBS" SMALLINT DEFAULT 0 NOT NULL, "USE_CAPTURE_LOBS" SMALLINT DEFAULT 0 NOT NULL, "USE_CAPTURE_OLD_DATA" SMALLINT DEFAULT 1 NOT NULL, "USE_HANDLE_KEY_UPDATES" SMALLINT DEFAULT 1 NOT NULL, "STREAM_ROW" SMALLINT DEFAULT 0 NOT NULL, "CREATE_TIME" TIMESTAMP NOT NULL, "LAST_UPDATE_BY" VARCHAR(50), "LAST_UPDATE_TIME" TIMESTAMP NOT NULL, "DESCRIPTION" BLOB SUB_TYPE TEXT, PRIMARY KEY ("TRIGGER_ID") ) 2019-05-11 05:06:06,117 INFO [server] [Firebird21SymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "SYM_TRIGGER"( "TRIGGER_ID" VARCHAR(128) NOT NULL, "SOURCE_CATALOG_NAME" VARCHAR(255), "SOURCE_SCHEMA_NAME" VARCHAR(255), "SOURCE_TABLE_NAME" VARCHAR(255) NOT NULL, "CHANNEL_ID" VARCHAR(128) NOT NULL, "RELOAD_CHANNEL_ID" VARCHAR(128) DEFAULT 'reload' NOT NULL, "SYNC_ON_UPDATE" SMALLINT DEFAULT 1 NOT NULL, "SYNC_ON_INSERT" SMALLINT DEFAULT 1 NOT NULL, "SYNC_ON_DELETE" SMALLINT DEFAULT 1 NOT NULL, "SYNC_ON_INCOMING_BATCH" SMALLINT DEFAULT 0 NOT NULL, "NAME_FOR_UPDATE_TRIGGER" VARCHAR(255), "NAME_FOR_INSERT_TRIGGER" VARCHAR(255), "NAME_FOR_DELETE_TRIGGER" VARCHAR(255), "SYNC_ON_UPDATE_CONDITION" BLOB SUB_TYPE TEXT, "SYNC_ON_INSERT_CONDITION" BLOB SUB_TYPE TEXT, "SYNC_ON_DELETE_CONDITION" BLOB SUB_TYPE TEXT, "CUSTOM_BEFORE_UPDATE_TEXT" BLOB SUB_TYPE TEXT, "CUSTOM_BEFORE_INSERT_TEXT" BLOB SUB_TYPE TEXT, "CUSTOM_BEFORE_DELETE_TEXT" BLOB SUB_TYPE TEXT, "CUSTOM_ON_UPDATE_TEXT" BLOB SUB_TYPE TEXT, "CUSTOM_ON_INSERT_TEXT" BLOB SUB_TYPE TEXT, "CUSTOM_ON_DELETE_TEXT" BLOB SUB_TYPE TEXT, "EXTERNAL_SELECT" BLOB SUB_TYPE TEXT, "TX_ID_EXPRESSION" BLOB SUB_TYPE TEXT, "CHANNEL_EXPRESSION" BLOB SUB_TYPE TEXT, "EXCLUDED_COLUMN_NAMES" BLOB SUB_TYPE TEXT, "INCLUDED_COLUMN_NAMES" BLOB SUB_TYPE TEXT, "SYNC_KEY_NAMES" BLOB SUB_TYPE TEXT, "USE_STREAM_LOBS" SMALLINT DEFAULT 0 NOT NULL, "USE_CAPTURE_LOBS" SMALLINT DEFAULT 0 NOT NULL, "USE_CAPTURE_OLD_DATA" SMALLINT DEFAULT 1 NOT NULL, "USE_HANDLE_KEY_UPDATES" SMALLINT DEFAULT 1 NOT NULL, "STREAM_ROW" SMALLINT DEFAULT 0 NOT NULL, "CREATE_TIME" TIMESTAMP NOT NULL, "LAST_UPDATE_BY" VARCHAR(50), "LAST_UPDATE_TIME" TIMESTAMP NOT NULL, "DESCRIPTION" BLOB SUB_TYPE TEXT, PRIMARY KEY ("TRIGGER_ID") ) 2019-05-11 05:06:06,148 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (16ms.) CREATE TABLE "SYM_TRIGGER_HIST"( "TRIGGER_HIST_ID" INTEGER NOT NULL, "TRIGGER_ID" VARCHAR(128) NOT NULL, "SOURCE_TABLE_NAME" VARCHAR(255) NOT NULL, "SOURCE_CATALOG_NAME" VARCHAR(255), "SOURCE_SCHEMA_NAME" VARCHAR(255), "NAME_FOR_UPDATE_TRIGGER" VARCHAR(255), "NAME_FOR_INSERT_TRIGGER" VARCHAR(255), "NAME_FOR_DELETE_TRIGGER" VARCHAR(255), "TABLE_HASH" BIGINT DEFAULT 0 NOT NULL, "TRIGGER_ROW_HASH" BIGINT DEFAULT 0 NOT NULL, "TRIGGER_TEMPLATE_HASH" BIGINT DEFAULT 0 NOT NULL, "COLUMN_NAMES" BLOB SUB_TYPE TEXT NOT NULL, "PK_COLUMN_NAMES" BLOB SUB_TYPE TEXT NOT NULL, "LAST_TRIGGER_BUILD_REASON" CHAR(1) NOT NULL, "ERROR_MESSAGE" BLOB SUB_TYPE TEXT, "CREATE_TIME" TIMESTAMP NOT NULL, "INACTIVE_TIME" TIMESTAMP, PRIMARY KEY ("TRIGGER_HIST_ID") ) 2019-05-11 05:06:06,148 INFO [server] [Firebird21SymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "SYM_TRIGGER_HIST"( "TRIGGER_HIST_ID" INTEGER NOT NULL, "TRIGGER_ID" VARCHAR(128) NOT NULL, "SOURCE_TABLE_NAME" VARCHAR(255) NOT NULL, "SOURCE_CATALOG_NAME" VARCHAR(255), "SOURCE_SCHEMA_NAME" VARCHAR(255), "NAME_FOR_UPDATE_TRIGGER" VARCHAR(255), "NAME_FOR_INSERT_TRIGGER" VARCHAR(255), "NAME_FOR_DELETE_TRIGGER" VARCHAR(255), "TABLE_HASH" BIGINT DEFAULT 0 NOT NULL, "TRIGGER_ROW_HASH" BIGINT DEFAULT 0 NOT NULL, "TRIGGER_TEMPLATE_HASH" BIGINT DEFAULT 0 NOT NULL, "COLUMN_NAMES" BLOB SUB_TYPE TEXT NOT NULL, "PK_COLUMN_NAMES" BLOB SUB_TYPE TEXT NOT NULL, "LAST_TRIGGER_BUILD_REASON" CHAR(1) NOT NULL, "ERROR_MESSAGE" BLOB SUB_TYPE TEXT, "CREATE_TIME" TIMESTAMP NOT NULL, "INACTIVE_TIME" TIMESTAMP, PRIMARY KEY ("TRIGGER_HIST_ID") ) 2019-05-11 05:06:06,148 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (0ms.) CREATE INDEX "SYM_IDX_TRIGG_HIST_1" ON "SYM_TRIGGER_HIST" ("TRIGGER_ID", "INACTIVE_TIME") 2019-05-11 05:06:06,148 INFO [server] [Firebird21SymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE INDEX "SYM_IDX_TRIGG_HIST_1" ON "SYM_TRIGGER_HIST" ("TRIGGER_ID", "INACTIVE_TIME") 2019-05-11 05:06:06,164 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (16ms.) CREATE TABLE "SYM_TRIGGER_ROUTER"( "TRIGGER_ID" VARCHAR(128) NOT NULL, "ROUTER_ID" VARCHAR(50) NOT NULL, "ENABLED" SMALLINT DEFAULT 1 NOT NULL, "INITIAL_LOAD_ORDER" INTEGER DEFAULT 1 NOT NULL, "INITIAL_LOAD_SELECT" BLOB SUB_TYPE TEXT, "INITIAL_LOAD_DELETE_STMT" BLOB SUB_TYPE TEXT, "PING_BACK_ENABLED" SMALLINT DEFAULT 0 NOT NULL, "CREATE_TIME" TIMESTAMP NOT NULL, "LAST_UPDATE_BY" VARCHAR(50), "LAST_UPDATE_TIME" TIMESTAMP NOT NULL, "DESCRIPTION" BLOB SUB_TYPE TEXT, PRIMARY KEY ("TRIGGER_ID", "ROUTER_ID") ) 2019-05-11 05:06:06,164 INFO [server] [Firebird21SymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "SYM_TRIGGER_ROUTER"( "TRIGGER_ID" VARCHAR(128) NOT NULL, "ROUTER_ID" VARCHAR(50) NOT NULL, "ENABLED" SMALLINT DEFAULT 1 NOT NULL, "INITIAL_LOAD_ORDER" INTEGER DEFAULT 1 NOT NULL, "INITIAL_LOAD_SELECT" BLOB SUB_TYPE TEXT, "INITIAL_LOAD_DELETE_STMT" BLOB SUB_TYPE TEXT, "PING_BACK_ENABLED" SMALLINT DEFAULT 0 NOT NULL, "CREATE_TIME" TIMESTAMP NOT NULL, "LAST_UPDATE_BY" VARCHAR(50), "LAST_UPDATE_TIME" TIMESTAMP NOT NULL, "DESCRIPTION" BLOB SUB_TYPE TEXT, PRIMARY KEY ("TRIGGER_ID", "ROUTER_ID") ) 2019-05-11 05:06:06,179 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (15ms.) CREATE TABLE "SYM_TRIGGER_ROUTER_GROUPLET"( "GROUPLET_ID" VARCHAR(50) NOT NULL, "TRIGGER_ID" VARCHAR(128) NOT NULL, "ROUTER_ID" VARCHAR(50) NOT NULL, "APPLIES_WHEN" CHAR(1) NOT NULL, "CREATE_TIME" TIMESTAMP NOT NULL, "LAST_UPDATE_BY" VARCHAR(50), "LAST_UPDATE_TIME" TIMESTAMP NOT NULL, PRIMARY KEY ("GROUPLET_ID", "TRIGGER_ID", "ROUTER_ID", "APPLIES_WHEN") ) 2019-05-11 05:06:06,179 INFO [server] [Firebird21SymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "SYM_TRIGGER_ROUTER_GROUPLET"( "GROUPLET_ID" VARCHAR(50) NOT NULL, "TRIGGER_ID" VARCHAR(128) NOT NULL, "ROUTER_ID" VARCHAR(50) NOT NULL, "APPLIES_WHEN" CHAR(1) NOT NULL, "CREATE_TIME" TIMESTAMP NOT NULL, "LAST_UPDATE_BY" VARCHAR(50), "LAST_UPDATE_TIME" TIMESTAMP NOT NULL, PRIMARY KEY ("GROUPLET_ID", "TRIGGER_ID", "ROUTER_ID", "APPLIES_WHEN") ) 2019-05-11 05:06:06,195 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (16ms.) ALTER TABLE "SYM_CONFLICT" ADD CONSTRAINT "SYM_FK_CF_2_GRP_LNK" FOREIGN KEY ("SOURCE_NODE_GROUP_ID", "TARGET_NODE_GROUP_ID") REFERENCES "SYM_NODE_GROUP_LINK" ("SOURCE_NODE_GROUP_ID", "TARGET_NODE_GROUP_ID") 2019-05-11 05:06:06,195 INFO [server] [Firebird21SymmetricDialect] [symmetric-engine-startup-1] DDL applied: ALTER TABLE "SYM_CONFLICT" ADD CONSTRAINT "SYM_FK_CF_2_GRP_LNK" FOREIGN KEY ("SOURCE_NODE_GROUP_ID", "TARGET_NODE_GROUP_ID") REFERENCES "SYM_NODE_GROUP_LINK" ("SOURCE_NODE_GROUP_ID", "TARGET_NODE_GROUP_ID") 2019-05-11 05:06:06,211 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (16ms.) ALTER TABLE "SYM_FILE_TRIGGER_ROUTER" ADD CONSTRAINT "SYM_FK_FTR_2_FTRG" FOREIGN KEY ("TRIGGER_ID") REFERENCES "SYM_FILE_TRIGGER" ("TRIGGER_ID") 2019-05-11 05:06:06,211 INFO [server] [Firebird21SymmetricDialect] [symmetric-engine-startup-1] DDL applied: ALTER TABLE "SYM_FILE_TRIGGER_ROUTER" ADD CONSTRAINT "SYM_FK_FTR_2_FTRG" FOREIGN KEY ("TRIGGER_ID") REFERENCES "SYM_FILE_TRIGGER" ("TRIGGER_ID") 2019-05-11 05:06:06,211 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (0ms.) ALTER TABLE "SYM_FILE_TRIGGER_ROUTER" ADD CONSTRAINT "SYM_FK_FTR_2_RTR" FOREIGN KEY ("ROUTER_ID") REFERENCES "SYM_ROUTER" ("ROUTER_ID") 2019-05-11 05:06:06,226 INFO [server] [Firebird21SymmetricDialect] [symmetric-engine-startup-1] DDL applied: ALTER TABLE "SYM_FILE_TRIGGER_ROUTER" ADD CONSTRAINT "SYM_FK_FTR_2_RTR" FOREIGN KEY ("ROUTER_ID") REFERENCES "SYM_ROUTER" ("ROUTER_ID") 2019-05-11 05:06:06,226 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (0ms.) ALTER TABLE "SYM_GROUPLET_LINK" ADD CONSTRAINT "SYM_FK_GPLTLNK_2_GPLT" FOREIGN KEY ("GROUPLET_ID") REFERENCES "SYM_GROUPLET" ("GROUPLET_ID") 2019-05-11 05:06:06,226 INFO [server] [Firebird21SymmetricDialect] [symmetric-engine-startup-1] DDL applied: ALTER TABLE "SYM_GROUPLET_LINK" ADD CONSTRAINT "SYM_FK_GPLTLNK_2_GPLT" FOREIGN KEY ("GROUPLET_ID") REFERENCES "SYM_GROUPLET" ("GROUPLET_ID") 2019-05-11 05:06:06,242 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (16ms.) ALTER TABLE "SYM_NODE_GROUP_LINK" ADD CONSTRAINT "SYM_FK_LNK_2_GRP_SRC" FOREIGN KEY ("SOURCE_NODE_GROUP_ID") REFERENCES "SYM_NODE_GROUP" ("NODE_GROUP_ID") 2019-05-11 05:06:06,242 INFO [server] [Firebird21SymmetricDialect] [symmetric-engine-startup-1] DDL applied: ALTER TABLE "SYM_NODE_GROUP_LINK" ADD CONSTRAINT "SYM_FK_LNK_2_GRP_SRC" FOREIGN KEY ("SOURCE_NODE_GROUP_ID") REFERENCES "SYM_NODE_GROUP" ("NODE_GROUP_ID") 2019-05-11 05:06:06,242 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (0ms.) ALTER TABLE "SYM_NODE_GROUP_LINK" ADD CONSTRAINT "SYM_FK_LNK_2_GRP_TGT" FOREIGN KEY ("TARGET_NODE_GROUP_ID") REFERENCES "SYM_NODE_GROUP" ("NODE_GROUP_ID") 2019-05-11 05:06:06,242 INFO [server] [Firebird21SymmetricDialect] [symmetric-engine-startup-1] DDL applied: ALTER TABLE "SYM_NODE_GROUP_LINK" ADD CONSTRAINT "SYM_FK_LNK_2_GRP_TGT" FOREIGN KEY ("TARGET_NODE_GROUP_ID") REFERENCES "SYM_NODE_GROUP" ("NODE_GROUP_ID") 2019-05-11 05:06:06,273 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (31ms.) ALTER TABLE "SYM_NODE_IDENTITY" ADD CONSTRAINT "SYM_FK_IDENT_2_NODE" FOREIGN KEY ("NODE_ID") REFERENCES "SYM_NODE" ("NODE_ID") 2019-05-11 05:06:06,273 INFO [server] [Firebird21SymmetricDialect] [symmetric-engine-startup-1] DDL applied: ALTER TABLE "SYM_NODE_IDENTITY" ADD CONSTRAINT "SYM_FK_IDENT_2_NODE" FOREIGN KEY ("NODE_ID") REFERENCES "SYM_NODE" ("NODE_ID") 2019-05-11 05:06:06,289 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (16ms.) ALTER TABLE "SYM_NODE_SECURITY" ADD CONSTRAINT "SYM_FK_SEC_2_NODE" FOREIGN KEY ("NODE_ID") REFERENCES "SYM_NODE" ("NODE_ID") 2019-05-11 05:06:06,289 INFO [server] [Firebird21SymmetricDialect] [symmetric-engine-startup-1] DDL applied: ALTER TABLE "SYM_NODE_SECURITY" ADD CONSTRAINT "SYM_FK_SEC_2_NODE" FOREIGN KEY ("NODE_ID") REFERENCES "SYM_NODE" ("NODE_ID") 2019-05-11 05:06:06,289 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (0ms.) ALTER TABLE "SYM_ROUTER" ADD CONSTRAINT "SYM_FK_RT_2_GRP_LNK" FOREIGN KEY ("SOURCE_NODE_GROUP_ID", "TARGET_NODE_GROUP_ID") REFERENCES "SYM_NODE_GROUP_LINK" ("SOURCE_NODE_GROUP_ID", "TARGET_NODE_GROUP_ID") 2019-05-11 05:06:06,304 INFO [server] [Firebird21SymmetricDialect] [symmetric-engine-startup-1] DDL applied: ALTER TABLE "SYM_ROUTER" ADD CONSTRAINT "SYM_FK_RT_2_GRP_LNK" FOREIGN KEY ("SOURCE_NODE_GROUP_ID", "TARGET_NODE_GROUP_ID") REFERENCES "SYM_NODE_GROUP_LINK" ("SOURCE_NODE_GROUP_ID", "TARGET_NODE_GROUP_ID") 2019-05-11 05:06:06,304 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (0ms.) ALTER TABLE "SYM_TRANSFORM_TABLE" ADD CONSTRAINT "SYM_FK_TT_2_GRP_LNK" FOREIGN KEY ("SOURCE_NODE_GROUP_ID", "TARGET_NODE_GROUP_ID") REFERENCES "SYM_NODE_GROUP_LINK" ("SOURCE_NODE_GROUP_ID", "TARGET_NODE_GROUP_ID") 2019-05-11 05:06:06,304 INFO [server] [Firebird21SymmetricDialect] [symmetric-engine-startup-1] DDL applied: ALTER TABLE "SYM_TRANSFORM_TABLE" ADD CONSTRAINT "SYM_FK_TT_2_GRP_LNK" FOREIGN KEY ("SOURCE_NODE_GROUP_ID", "TARGET_NODE_GROUP_ID") REFERENCES "SYM_NODE_GROUP_LINK" ("SOURCE_NODE_GROUP_ID", "TARGET_NODE_GROUP_ID") 2019-05-11 05:06:06,367 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (63ms.) ALTER TABLE "SYM_TRIGGER" ADD CONSTRAINT "SYM_FK_TRG_2_CHNL" FOREIGN KEY ("CHANNEL_ID") REFERENCES "SYM_CHANNEL" ("CHANNEL_ID") 2019-05-11 05:06:06,367 INFO [server] [Firebird21SymmetricDialect] [symmetric-engine-startup-1] DDL applied: ALTER TABLE "SYM_TRIGGER" ADD CONSTRAINT "SYM_FK_TRG_2_CHNL" FOREIGN KEY ("CHANNEL_ID") REFERENCES "SYM_CHANNEL" ("CHANNEL_ID") 2019-05-11 05:06:06,367 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (0ms.) ALTER TABLE "SYM_TRIGGER" ADD CONSTRAINT "SYM_FK_TRG_2_RLD_CHNL" FOREIGN KEY ("RELOAD_CHANNEL_ID") REFERENCES "SYM_CHANNEL" ("CHANNEL_ID") 2019-05-11 05:06:06,367 INFO [server] [Firebird21SymmetricDialect] [symmetric-engine-startup-1] DDL applied: ALTER TABLE "SYM_TRIGGER" ADD CONSTRAINT "SYM_FK_TRG_2_RLD_CHNL" FOREIGN KEY ("RELOAD_CHANNEL_ID") REFERENCES "SYM_CHANNEL" ("CHANNEL_ID") 2019-05-11 05:06:06,382 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (15ms.) ALTER TABLE "SYM_TRIGGER_ROUTER" ADD CONSTRAINT "SYM_FK_TR_2_TRG" FOREIGN KEY ("TRIGGER_ID") REFERENCES "SYM_TRIGGER" ("TRIGGER_ID") 2019-05-11 05:06:06,382 INFO [server] [Firebird21SymmetricDialect] [symmetric-engine-startup-1] DDL applied: ALTER TABLE "SYM_TRIGGER_ROUTER" ADD CONSTRAINT "SYM_FK_TR_2_TRG" FOREIGN KEY ("TRIGGER_ID") REFERENCES "SYM_TRIGGER" ("TRIGGER_ID") 2019-05-11 05:06:06,414 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (32ms.) ALTER TABLE "SYM_TRIGGER_ROUTER" ADD CONSTRAINT "SYM_FK_TR_2_RTR" FOREIGN KEY ("ROUTER_ID") REFERENCES "SYM_ROUTER" ("ROUTER_ID") 2019-05-11 05:06:06,414 INFO [server] [Firebird21SymmetricDialect] [symmetric-engine-startup-1] DDL applied: ALTER TABLE "SYM_TRIGGER_ROUTER" ADD CONSTRAINT "SYM_FK_TR_2_RTR" FOREIGN KEY ("ROUTER_ID") REFERENCES "SYM_ROUTER" ("ROUTER_ID") 2019-05-11 05:06:06,429 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (15ms.) ALTER TABLE "SYM_TRIGGER_ROUTER_GROUPLET" ADD CONSTRAINT "SYM_FK_TRGPLT_2_GPLT" FOREIGN KEY ("GROUPLET_ID") REFERENCES "SYM_GROUPLET" ("GROUPLET_ID") 2019-05-11 05:06:06,429 INFO [server] [Firebird21SymmetricDialect] [symmetric-engine-startup-1] DDL applied: ALTER TABLE "SYM_TRIGGER_ROUTER_GROUPLET" ADD CONSTRAINT "SYM_FK_TRGPLT_2_GPLT" FOREIGN KEY ("GROUPLET_ID") REFERENCES "SYM_GROUPLET" ("GROUPLET_ID") 2019-05-11 05:06:06,445 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (16ms.) ALTER TABLE "SYM_TRIGGER_ROUTER_GROUPLET" ADD CONSTRAINT "SYM_FK_TRGPLT_2_TR" FOREIGN KEY ("TRIGGER_ID", "ROUTER_ID") REFERENCES "SYM_TRIGGER_ROUTER" ("TRIGGER_ID", "ROUTER_ID") 2019-05-11 05:06:06,445 INFO [server] [Firebird21SymmetricDialect] [symmetric-engine-startup-1] DDL applied: ALTER TABLE "SYM_TRIGGER_ROUTER_GROUPLET" ADD CONSTRAINT "SYM_FK_TRGPLT_2_TR" FOREIGN KEY ("TRIGGER_ID", "ROUTER_ID") REFERENCES "SYM_TRIGGER_ROUTER" ("TRIGGER_ID", "ROUTER_ID") 2019-05-11 05:06:06,476 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (31ms.) select c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version from sym_node c inner join sym_node_identity i on c.node_id = i.node_id 2019-05-11 05:06:06,476 INFO [server] [Firebird21SymmetricDialect] [symmetric-engine-startup-1] Done with auto update of SymmetricDS tables 2019-05-11 05:06:06,523 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (0ms.) select count() from rdb$functions where rdb$function_name = upper('sym_hex') 2019-05-11 05:06:06,523 INFO [server] [Firebird21SymmetricDialect] [symmetric-engine-startup-1] Installing SymmetricDS database object: declare external function sym_hex blob returns cstring(32660) free_it entry_point 'sym_hex' module_name 'sym_udf' 2019-05-11 05:06:06,523 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (0ms.) declare external function sym_hex blob returns cstring(32660) free_it entry_point 'sym_hex' module_name 'sym_udf' 2019-05-11 05:06:06,523 INFO [server] [Firebird21SymmetricDialect] [symmetric-engine-startup-1] Just installed sym_hex 2019-05-11 05:06:06,539 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (16ms.) select c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version from sym_node c inner join sym_node_identity i on c.node_id = i.node_id 2019-05-11 05:06:06,539 INFO [server] [ConfigurationService] [symmetric-engine-startup-1] Auto-configuring config channel 2019-05-11 05:06:06,554 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (0ms.) update sym_channel set processing_order=0, max_batch_size=2000, max_batch_to_send=100, max_data_to_route=500000, use_old_data_to_route=1, use_row_data_to_route=1, use_pk_data_to_route=1, contains_big_lob=1, enabled=1, batch_algorithm='default', extract_period_millis=0, data_loader_type='default', last_update_time={ts '2019-05-11 05:06:06.539'}, last_update_by=null, reload_flag=0, file_sync_flag=0, queue='default', max_network_kbps = 0, data_event_action=null where channel_id='config' 2019-05-11 05:06:06,570 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (0ms.) insert into sym_channel (channel_id, processing_order, max_batch_size, max_batch_to_send, max_data_to_route, use_old_data_to_route, use_row_data_to_route, use_pk_data_to_route, contains_big_lob, enabled, batch_algorithm, description, extract_period_millis, data_loader_type, last_update_time, last_update_by, create_time, reload_flag, file_sync_flag, queue, max_network_kbps, data_event_action) values ('config', 0, 2000, 100, 500000, 1, 1, 1, 1, 1, 'default', null, 0, 'default', {ts '2019-05-11 05:06:06.539'}, null, {ts '2019-05-11 05:06:06.570'}, 0, 0, 'default', 0, null) 2019-05-11 05:06:06,570 INFO [server] [ConfigurationService] [symmetric-engine-startup-1] Auto-configuring reload channel 2019-05-11 05:06:06,586 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (0ms.) update sym_channel set processing_order=1, max_batch_size=10000, max_batch_to_send=100, max_data_to_route=500000, use_old_data_to_route=1, use_row_data_to_route=1, use_pk_data_to_route=1, contains_big_lob=0, enabled=1, batch_algorithm='default', extract_period_millis=0, data_loader_type='default', last_update_time={ts '2019-05-11 05:06:06.570'}, last_update_by=null, reload_flag=1, file_sync_flag=0, queue='default', max_network_kbps = 0, data_event_action=null where channel_id='reload' 2019-05-11 05:06:06,601 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (0ms.) insert into sym_channel (channel_id, processing_order, max_batch_size, max_batch_to_send, max_data_to_route, use_old_data_to_route, use_row_data_to_route, use_pk_data_to_route, contains_big_lob, enabled, batch_algorithm, description, extract_period_millis, data_loader_type, last_update_time, last_update_by, create_time, reload_flag, file_sync_flag, queue, max_network_kbps, data_event_action) values ('reload', 1, 10000, 100, 500000, 1, 1, 1, 0, 1, 'default', null, 0, 'default', {ts '2019-05-11 05:06:06.570'}, null, {ts '2019-05-11 05:06:06.586'}, 1, 0, 'default', 0, null) 2019-05-11 05:06:06,601 INFO [server] [ConfigurationService] [symmetric-engine-startup-1] Auto-configuring monitor channel 2019-05-11 05:06:06,617 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (0ms.) update sym_channel set processing_order=2, max_batch_size=100, max_batch_to_send=100, max_data_to_route=500000, use_old_data_to_route=1, use_row_data_to_route=1, use_pk_data_to_route=1, contains_big_lob=1, enabled=1, batch_algorithm='default', extract_period_millis=0, data_loader_type='default', last_update_time={ts '2019-05-11 05:06:06.601'}, last_update_by=null, reload_flag=0, file_sync_flag=0, queue='default', max_network_kbps = 0, data_event_action=null where channel_id='monitor' 2019-05-11 05:06:06,617 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (0ms.) insert into sym_channel (channel_id, processing_order, max_batch_size, max_batch_to_send, max_data_to_route, use_old_data_to_route, use_row_data_to_route, use_pk_data_to_route, contains_big_lob, enabled, batch_algorithm, description, extract_period_millis, data_loader_type, last_update_time, last_update_by, create_time, reload_flag, file_sync_flag, queue, max_network_kbps, data_event_action) values ('monitor', 2, 100, 100, 500000, 1, 1, 1, 1, 1, 'default', null, 0, 'default', {ts '2019-05-11 05:06:06.601'}, null, {ts '2019-05-11 05:06:06.617'}, 0, 0, 'default', 0, null) 2019-05-11 05:06:06,617 INFO [server] [ConfigurationService] [symmetric-engine-startup-1] Auto-configuring heartbeat channel 2019-05-11 05:06:06,632 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (15ms.) update sym_channel set processing_order=2, max_batch_size=100, max_batch_to_send=100, max_data_to_route=500000, use_old_data_to_route=1, use_row_data_to_route=1, use_pk_data_to_route=1, contains_big_lob=0, enabled=1, batch_algorithm='default', extract_period_millis=0, data_loader_type='default', last_update_time={ts '2019-05-11 05:06:06.617'}, last_update_by=null, reload_flag=0, file_sync_flag=0, queue='default', max_network_kbps = 0, data_event_action=null where channel_id='heartbeat' 2019-05-11 05:06:06,632 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (0ms.) insert into sym_channel (channel_id, processing_order, max_batch_size, max_batch_to_send, max_data_to_route, use_old_data_to_route, use_row_data_to_route, use_pk_data_to_route, contains_big_lob, enabled, batch_algorithm, description, extract_period_millis, data_loader_type, last_update_time, last_update_by, create_time, reload_flag, file_sync_flag, queue, max_network_kbps, data_event_action) values ('heartbeat', 2, 100, 100, 500000, 1, 1, 1, 0, 1, 'default', null, 0, 'default', {ts '2019-05-11 05:06:06.617'}, null, {ts '2019-05-11 05:06:06.632'}, 0, 0, 'default', 0, null) 2019-05-11 05:06:06,632 INFO [server] [ConfigurationService] [symmetric-engine-startup-1] Auto-configuring default channel 2019-05-11 05:06:06,648 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (0ms.) update sym_channel set processing_order=500000, max_batch_size=1000, max_batch_to_send=100, max_data_to_route=500000, use_old_data_to_route=1, use_row_data_to_route=1, use_pk_data_to_route=1, contains_big_lob=0, enabled=1, batch_algorithm='default', extract_period_millis=0, data_loader_type='default', last_update_time={ts '2019-05-11 05:06:06.632'}, last_update_by=null, reload_flag=0, file_sync_flag=0, queue='default', max_network_kbps = 0, data_event_action=null where channel_id='default' 2019-05-11 05:06:06,648 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (0ms.) insert into sym_channel (channel_id, processing_order, max_batch_size, max_batch_to_send, max_data_to_route, use_old_data_to_route, use_row_data_to_route, use_pk_data_to_route, contains_big_lob, enabled, batch_algorithm, description, extract_period_millis, data_loader_type, last_update_time, last_update_by, create_time, reload_flag, file_sync_flag, queue, max_network_kbps, data_event_action) values ('default', 500000, 1000, 100, 500000, 1, 1, 1, 0, 1, 'default', null, 0, 'default', {ts '2019-05-11 05:06:06.632'}, null, {ts '2019-05-11 05:06:06.648'}, 0, 0, 'default', 0, null) 2019-05-11 05:06:06,648 INFO [server] [ConfigurationService] [symmetric-engine-startup-1] Auto-configuring dynamic channel 2019-05-11 05:06:06,664 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (0ms.) update sym_channel set processing_order=99999, max_batch_size=1000, max_batch_to_send=100, max_data_to_route=500000, use_old_data_to_route=1, use_row_data_to_route=1, use_pk_data_to_route=1, contains_big_lob=0, enabled=1, batch_algorithm='default', extract_period_millis=0, data_loader_type='default', last_update_time={ts '2019-05-11 05:06:06.648'}, last_update_by=null, reload_flag=0, file_sync_flag=0, queue='default', max_network_kbps = 0, data_event_action=null where channel_id='dynamic' 2019-05-11 05:06:06,664 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (0ms.) insert into sym_channel (channel_id, processing_order, max_batch_size, max_batch_to_send, max_data_to_route, use_old_data_to_route, use_row_data_to_route, use_pk_data_to_route, contains_big_lob, enabled, batch_algorithm, description, extract_period_millis, data_loader_type, last_update_time, last_update_by, create_time, reload_flag, file_sync_flag, queue, max_network_kbps, data_event_action) values ('dynamic', 99999, 1000, 100, 500000, 1, 1, 1, 0, 1, 'default', null, 0, 'default', {ts '2019-05-11 05:06:06.648'}, null, {ts '2019-05-11 05:06:06.664'}, 0, 0, 'default', 0, null) 2019-05-11 05:06:06,679 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (0ms.) select c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version from sym_node c inner join sym_node_identity i on c.node_id = i.node_id 2019-05-11 05:06:06,695 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (16ms.) select node_id, host_name, instance_id, ip_address, os_user, os_name, os_arch, os_version, available_processors, free_memory_bytes, total_memory_bytes, max_memory_bytes, java_version, java_vendor, jdbc_version, symmetric_version, timezone_offset, heartbeat_time, last_restart_time, create_time from sym_node_host h where node_id=null order by heartbeat_time desc 2019-05-11 05:06:06,711 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (16ms.) select sequence_name,current_value,increment_by,min_value,max_value,cycle_flag,cache_size,create_time,last_update_by,last_update_time from sym_sequence 2019-05-11 05:06:06,711 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (0ms.) insert into sym_sequence (sequence_name, current_value, increment_by, min_value, max_value, cycle_flag, cache_size, create_time, last_update_by, last_update_time) values('outgoing_batch_load_id',1,1,1,9999999999,0,0,current_timestamp,'system',current_timestamp) 2019-05-11 05:06:06,711 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (0ms.) select max(batch_id)+1 from sym_outgoing_batch 2019-05-11 05:06:06,757 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (15ms.) insert into sym_sequence (sequence_name, current_value, increment_by, min_value, max_value, cycle_flag, cache_size, create_time, last_update_by, last_update_time) values('outgoing_batch',1,1,1,9999999999,0,10,current_timestamp,'system',current_timestamp) 2019-05-11 05:06:06,757 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (0ms.) select max(trigger_hist_id)+1 from sym_trigger_hist 2019-05-11 05:06:06,757 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (0ms.) insert into sym_sequence (sequence_name, current_value, increment_by, min_value, max_value, cycle_flag, cache_size, create_time, last_update_by, last_update_time) values('trigger_hist',1,1,1,9999999999,0,0,current_timestamp,'system',current_timestamp) 2019-05-11 05:06:06,773 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (0ms.) select max(request_id)+1 from sym_extract_request 2019-05-11 05:06:06,773 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (0ms.) insert into sym_sequence (sequence_name, current_value, increment_by, min_value, max_value, cycle_flag, cache_size, create_time, last_update_by, last_update_time) values('extract_request',1,1,1,9999999999,0,0,current_timestamp,'system',current_timestamp) 2019-05-11 05:06:06,789 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (16ms.) select c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version from sym_node c inner join sym_node_identity i on c.node_id = i.node_id 2019-05-11 05:06:06,804 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (15ms.) select c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version from sym_node c inner join sym_node_identity i on c.node_id = i.node_id 2019-05-11 05:06:06,820 INFO [server] [AbstractSymmetricEngine] [symmetric-engine-startup-1] Inserting rows for node, security, identity and group for registration server 2019-05-11 05:06:06,820 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (0ms.) update sym_node set node_group_id='server', external_id='main', database_type='Firebird 2.5', database_version='2.5', schema_version='?', symmetric_version='3.10.2', sync_url='http://localhost:31415/sync/server', sync_enabled=1, batch_to_send_count=0, batch_in_error_count=0, created_at_node_id=null, deployment_type=null, deployment_sub_type=null, config_version = '3.10.2' where node_id = 'main' 2019-05-11 05:06:06,836 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (16ms.) insert into sym_node (node_group_id, external_id, database_type, database_version, schema_version, symmetric_version, sync_url,sync_enabled, batch_to_send_count, batch_in_error_count, created_at_node_id, deployment_type, deployment_sub_type, config_version, node_id) values ('server','main','Firebird 2.5','2.5','?','3.10.2','http://localhost:31415/sync/server',1,0,0,null,null,null,'3.10.2','main') 2019-05-11 05:06:06,836 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (0ms.) insert into sym_node_identity values('main') 2019-05-11 05:06:06,851 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (15ms.) select c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version from sym_node c inner join sym_node_identity i on c.node_id = i.node_id 2019-05-11 05:06:06,851 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (0ms.) select count() from sym_node_group where node_group_id='server' 2019-05-11 05:06:06,867 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (0ms.) insert into sym_node_group (description, node_group_id) values(null, 'server') 2019-05-11 05:06:06,867 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (0ms.) select node_id, node_password, registration_enabled, registration_time, initial_load_enabled, initial_load_time, created_at_node_id, rev_initial_load_enabled, rev_initial_load_time, initial_load_id, initial_load_create_by, rev_initial_load_id, rev_initial_load_create_by from sym_node_security where node_id = 'main' 2019-05-11 05:06:06,882 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (0ms.) insert into sym_node_security (node_id, node_password, created_at_node_id) values ('main', 'FgU6OgXkIs25UFQ5u7TEAOBl1YAC9r', null) 2019-05-11 05:06:06,882 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (0ms.) select node_id, node_password, registration_enabled, registration_time, initial_load_enabled, initial_load_time, created_at_node_id, rev_initial_load_enabled, rev_initial_load_time, initial_load_id, initial_load_create_by, rev_initial_load_id, rev_initial_load_create_by from sym_node_security 2019-05-11 05:06:06,898 DEBUG [server] [JdbcSqlTransaction] [symmetric-engine-startup-1] (0ms.) update sym_node_security set node_password = 'FgU6OgXkIs25UFQ5u7TEAOBl1YAC9r', registration_enabled = 0, registration_time = {ts '2019-05-11 05:06:06.882'}, initial_load_enabled = 0, initial_load_time = {ts '2019-05-11 05:06:06.882'}, created_at_node_id = null, rev_initial_load_enabled=0, rev_initial_load_time=null, initial_load_id=0, initial_load_create_by=null, rev_initial_load_id=0, rev_initial_load_create_by=null where node_id = 'main' 2019-05-11 05:06:06,898 INFO [server] [AbstractSymmetricEngine] [symmetric-engine-startup-1] Done initializing SymmetricDS database 2019-05-11 05:06:06,898 INFO [server] [AbstractSymmetricEngine] [symmetric-engine-startup-1] SymmetricDS database version : 3.10.2 2019-05-11 05:06:06,898 INFO [server] [AbstractSymmetricEngine] [symmetric-engine-startup-1] SymmetricDS software version : 3.10.2 2019-05-11 05:06:06,914 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (16ms.) select param_key, param_value from sym_parameter where external_id='ALL' and node_group_id='ALL' 2019-05-11 05:06:06,914 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (0ms.) select param_key, param_value from sym_parameter where external_id='ALL' and node_group_id='server' 2019-05-11 05:06:06,914 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (0ms.) select param_key, param_value from sym_parameter where external_id='main' and node_group_id='server' 2019-05-11 05:06:06,914 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (0ms.) select param_key, param_value, external_id, node_group_id from sym_parameter where param_key='node.offline' order by node_group_id, external_id 2019-05-11 05:06:06,929 INFO [server] [AbstractSymmetricEngine] [symmetric-engine-startup-1] Starting registered node [group=server, id=main, nodeId=main] 2019-05-11 05:06:06,929 INFO [server] [ClusterService] [symmetric-engine-startup-1] This node picked a server id of ADMINISTRATORPC 2019-05-11 05:06:06,929 INFO [server] [TriggerRouterService] [symmetric-engine-startup-1] Synchronizing triggers 2019-05-11 05:06:06,945 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (16ms.) select tr.trigger_id, tr.router_id, tr.create_time, tr.last_update_time, tr.last_update_by, tr.initial_load_order, tr.initial_load_select, tr.initial_load_delete_stmt, tr.ping_back_enabled, tr.enabled from sym_trigger_router tr inner join sym_trigger t on tr.trigger_id=t.trigger_id inner join sym_router r on tr.router_id=r.router_id where r.source_node_group_id = 'server' 2019-05-11 05:06:06,945 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (0ms.) select source_node_group_id, target_node_group_id, data_event_action, sync_config_enabled, is_reversible, last_update_time, last_update_by, create_time from sym_node_group_link order by source_node_group_id 2019-05-11 05:06:06,945 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (0ms.) select r.sync_on_insert as r_sync_on_insert,r.sync_on_update as r_sync_on_update,r.sync_on_delete as r_sync_on_delete, r.target_catalog_name,r.source_node_group_id,r.target_schema_name,r.target_table_name,r.target_node_group_id,r.router_expression, r.router_type,r.router_id,r.create_time as r_create_time,r.last_update_time as r_last_update_time,r.last_update_by as r_last_update_by, r.use_source_catalog_schema from sym_router r order by r.router_id 2019-05-11 05:06:06,961 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (16ms.) select t.trigger_id,t.channel_id,t.reload_channel_id,t.source_table_name,t.source_schema_name,t.source_catalog_name, t.sync_on_insert,t.sync_on_update,t.sync_on_delete,t.sync_on_incoming_batch,t.use_stream_lobs, t.use_capture_lobs,t.use_capture_old_data,t.use_handle_key_updates, t.excluded_column_names, t.included_column_names, t.sync_key_names, t.name_for_delete_trigger,t.name_for_insert_trigger,t.name_for_update_trigger, t.sync_on_insert_condition,t.sync_on_update_condition,t.sync_on_delete_condition, t.custom_on_insert_text,t.custom_on_update_text,t.custom_on_delete_text, t.tx_id_expression,t.external_select,t.channel_expression, t.stream_row, t.create_time as t_create_time, t.last_update_time as t_last_update_time, t.last_update_by as t_last_update_by from sym_trigger t order by trigger_id asc 2019-05-11 05:06:06,961 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (0ms.) select node_id, node_password, registration_enabled, registration_time, initial_load_enabled, initial_load_time, created_at_node_id, rev_initial_load_enabled, rev_initial_load_time, initial_load_id, initial_load_create_by, rev_initial_load_id, rev_initial_load_create_by from sym_node_security where node_id = 'main' 2019-05-11 05:06:06,976 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (15ms.) select trigger_hist_id,trigger_id,source_table_name,table_hash,create_time,pk_column_names,column_names,last_trigger_build_reason,name_for_delete_trigger,name_for_insert_trigger,name_for_update_trigger,source_schema_name,source_catalog_name,trigger_row_hash,trigger_template_hash,error_message from sym_trigger_hist where inactive_time is null 2019-05-11 05:06:06,976 INFO [server] [TriggerRouterService] [symmetric-engine-startup-1] Done synchronizing triggers 2019-05-11 05:06:06,976 DEBUG [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] (0ms.) select * from sym_job order by job_type, job_name 2019-05-11 05:06:07,007 INFO [server] [RouterJob] [symmetric-engine-startup-1] Starting Routing on periodic schedule: every 10000ms with the first run at Sat May 11 05:06:11 VLAT 2019 2019-05-11 05:06:07,007 INFO [server] [PushJob] [symmetric-engine-startup-1] Starting Push on periodic schedule: every 60000ms with the first run at Sat May 11 05:06:11 VLAT 2019 2019-05-11 05:06:07,007 INFO [server] [PullJob] [symmetric-engine-startup-1] Starting Pull on periodic schedule: every 60000ms with the first run at Sat May 11 05:06:11 VLAT 2019 2019-05-11 05:06:07,007 INFO [server] [JobManager] [symmetric-engine-startup-1] Job Offline Push not configured for auto start 2019-05-11 05:06:07,007 INFO [server] [JobManager] [symmetric-engine-startup-1] Job Offline Pull not configured for auto start 2019-05-11 05:06:07,007 INFO [server] [OutgoingPurgeJob] [symmetric-engine-startup-1] Starting job 'Purge Outgoing' with cron expression: '0 0 /4 * ' 2019-05-11 05:06:07,023 INFO [server] [IncomingPurgeJob] [symmetric-engine-startup-1] Starting job 'Purge Incoming' with cron expression: '0 0 /4 * * ' 2019-05-11 05:06:07,023 INFO [server] [StatisticFlushJob] [symmetric-engine-startup-1] Starting job 'Stat Flush' with cron expression: '0 0/5 * * ' 2019-05-11 05:06:07,023 INFO [server] [SyncTriggersJob] [symmetric-engine-startup-1] Starting job 'SyncTriggers' with cron expression: '0 0 0 * ' 2019-05-11 05:06:07,023 INFO [server] [HeartbeatJob] [symmetric-engine-startup-1] Starting Heartbeat on periodic schedule: every 900000ms with the first run at Sat May 11 05:06:11 VLAT 2019 2019-05-11 05:06:07,023 INFO [server] [WatchdogJob] [symmetric-engine-startup-1] Starting Watchdog on periodic schedule: every 3600000ms with the first run at Sat May 11 05:06:11 VLAT 2019 2019-05-11 05:06:07,023 INFO [server] [StageManagementJob] [symmetric-engine-startup-1] Starting job 'Stage Management' with cron expression: '0 0 * * ' 2019-05-11 05:06:07,023 INFO [server] [JobManager] [symmetric-engine-startup-1] Job Refresh Cache not configured for auto start 2019-05-11 05:06:07,023 INFO [server] [JobManager] [symmetric-engine-startup-1] Job File Sync Tracker not configured for auto start 2019-05-11 05:06:07,023 INFO [server] [JobManager] [symmetric-engine-startup-1] Job File Sync Pull not configured for auto start 2019-05-11 05:06:07,023 INFO [server] [JobManager] [symmetric-engine-startup-1] Job File Sync Push not configured for auto start 2019-05-11 05:06:07,023 INFO [server] [InitialLoadExtractorJob] [symmetric-engine-startup-1] Starting Initial Load Extract on periodic schedule: every 10000ms with the first run at Sat May 11 05:06:11 VLAT 2019 2019-05-11 05:06:07,023 INFO [server] [MonitorJob] [symmetric-engine-startup-1] Starting Monitor on periodic schedule: every 60000ms with the first run at Sat May 11 05:06:11 VLAT 2019 2019-05-11 05:06:07,023 INFO [server] [JobManager] [symmetric-engine-startup-1] Job Report Status not configured for auto start 2019-05-11 05:06:07,023 INFO [server] [AbstractSymmetricEngine] [symmetric-engine-startup-1] SymmetricDS Node STARTED: nodeId=main groupId=server type=server subType=null name=server softwareVersion=3.10.2 databaseName=Firebird 2.5 databaseVersion=2.5 driverName=Jaybird JCA/JDBC driver driverVersion=3.0 uptime=0 sec. 2019-05-11 05:06:11,164 INFO [server] [PushHeartbeatListener] [server-job-4] Some attribute(s) of node changed. Recording changes 2019-05-11 05:06:11,164 INFO [server] [PushHeartbeatListener] [server-job-4] Updating my node configuration info according to the symmetric properties 2019-05-11 05:06:11,164 DEBUG [server] [JdbcSqlTemplate] [server-job-4] (0ms.) update sym_node set node_group_id='server', external_id='main', database_type='Firebird 2.5', database_version='2.5', schema_version='?', symmetric_version='3.10.2', sync_url='http://localhost:31415/sync/server', sync_enabled=1, batch_to_send_count=-1, batch_in_error_count=-1, created_at_node_id=null, deployment_type='server', deployment_sub_type=null, config_version = '3.10.2' where node_id = 'main' 2019-05-11 05:06:11,179 DEBUG [server] [JdbcSqlTemplate] [server-job-4] (0ms.) select count() from sym_outgoing_batch b inner join sym_data_event e on e.batch_id = b.batch_id inner join sym_data d on d.data_id = e.data_id where b.channel_id = 'heartbeat' and b.status != 'OK' and d.source_node_id is null 2019-05-11 05:06:11,179 DEBUG [server] [JdbcSqlTemplate] [server-job-3] (0ms.) select c.channel_id, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, c.extract_period_millis, c.data_loader_type, c.last_update_time, c.last_update_by, c.create_time, c.reload_flag, c.file_sync_flag, c.queue, c.max_network_kbps, c.data_event_action from sym_channel c order by c.processing_order asc, c.channel_id 2019-05-11 05:06:11,195 DEBUG [server] [JdbcSqlTemplate] [server-job-1] (0ms.) select count(*) from sym_outgoing_batch where status = 'RT' 2019-05-11 05:06:11,211 DEBUG [server] [JdbcSqlTemplate] [server-job-1] (0ms.) select max(data_id) from sym_data 2019-05-11 05:06:11,211 DEBUG [server] [JdbcSqlTemplate] [server-job-1] (0ms.) select start_id, end_id, create_time from sym_data_gap order by start_id asc 2019-05-11 05:06:11,226 DEBUG [server] [JdbcSqlTemplate] [server-job-3] (15ms.) select c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version from sym_node c inner join sym_node_group_link d on c.node_group_id = d.source_node_group_id where d.target_node_group_id = 'server' and (d.data_event_action = 'W' or d.is_reversible = 1) and c.node_id not in (select node_id from sym_node_identity) 2019-05-11 05:06:11,226 INFO [server] [NodeCommunicationService] [server-job-3] pull will use 10 threads 2019-05-11 05:06:11,226 DEBUG [server] [JdbcSqlTemplate] [server-job-5] (0ms.) select monitor_id, external_id, node_group_id, type, expression, enabled, threshold, run_period, run_count, severity_level, create_time, last_update_by, last_update_time from sym_monitor where (node_group_id = 'server' or node_group_id = 'ALL') and (external_id = 'main' or external_id = 'ALL') and enabled = 1 2019-05-11 05:06:11,242 DEBUG [server] [JdbcSqlTemplate] [server-job-5] (0ms.) select monitor_id, node_id, event_time, type, event_value, event_count, threshold, severity_level, host_name, is_resolved, is_notified, details, last_update_time from sym_monitor_event where node_id = 'main' and is_resolved = 0 2019-05-11 05:06:11,242 DEBUG [server] [JdbcSqlTemplate] [server-job-1] (0ms.) select max(data_id) from sym_data_event 2019-05-11 05:06:11,257 DEBUG [server] [JdbcSqlTemplate] [server-job-5] (15ms.) select notification_id, node_group_id, external_id, severity_level, type, expression, enabled, create_time, last_update_by, last_update_time from sym_notification where (node_group_id = 'server' or node_group_id = 'ALL') and (external_id = 'main' or external_id = 'ALL') and enabled = 1 2019-05-11 05:06:11,257 DEBUG [server] [JdbcSqlTemplate] [server-job-1] (0ms.) select min(data_id) from sym_data 2019-05-11 05:06:11,257 INFO [server] [DataService] [server-job-1] Inserting missing last data gap: { startId: 1, endId: 50000001, createTime: "Sat May 11 05:06:11 VLAT 2019" } 2019-05-11 05:06:11,273 DEBUG [server] [JdbcSqlTemplate] [server-job-2] (16ms.) select c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.deployment_sub_type, c.config_version from sym_node c inner join sym_node_group_link d on c.node_group_id = d.target_node_group_id where d.source_node_group_id = 'server' and (d.data_event_action = 'P' or d.is_reversible = 1) and c.node_id not in (select node_id from sym_node_identity) 2019-05-11 05:06:11,257 DEBUG [server] [JdbcSqlTransaction] [server-job-1] (0ms.) insert into sym_data_gap (last_update_hostname, start_id, end_id, create_time) values('ADMINISTRATORPC', 1, 50000001, {ts '2019-05-11 05:06:11.257'}) 2019-05-11 05:06:11,273 DEBUG [server] [JdbcSqlTemplate] [server-job-1] (0ms.) select start_id, end_id, create_time from sym_data_gap order by start_id asc 2019-05-11 05:06:11,320 DEBUG [server] [JdbcSqlTemplate] [server-job-1] (31ms.) select node_id, node_password, registration_enabled, registration_time, initial_load_enabled, initial_load_time, created_at_node_id, rev_initial_load_enabled, rev_initial_load_time, initial_load_id, initial_load_create_by, rev_initial_load_id, rev_initial_load_create_by from sym_node_security 2019-05-11 05:06:11,336 DEBUG [server] [JdbcSqlTemplate] [server-job-1] (0ms.) select target_node_id, create_table, delete_first, reload_select, before_custom_sql, reload_time, channel_id, create_time, last_update_by, last_update_time, trigger_id, router_id from sym_table_reload_request where source_node_id='main' and processed = 0 order by create_time, target_node_id 2019-05-11 05:06:11,336 INFO [server] [DataGapFastDetector] [server-job-1] Full gap analysis is running 2019-05-11 05:06:11,351 DEBUG [server] [JdbcSqlTemplate] [server-job-1] (15ms.) select start_id, end_id, create_time from sym_data_gap order by start_id asc 2019-05-11 05:06:11,351 DEBUG [server] [JdbcSqlTemplate] [server-job-1] (0ms.) select distinct(data_id) from sym_data_event where data_id >=1 and data_id <= 50000001 order by data_id asc 2019-05-11 05:06:11,351 INFO [server] [DataGapFastDetector] [server-job-1] Querying data in gaps from database took 15 ms 2019-05-11 05:06:11,351 INFO [server] [DataGapFastDetector] [server-job-1] Full gap analysis is done after 15 ms 2019-05-11 05:06:11,351 DEBUG [server] [JdbcSqlTemplate] [server-job-1] (0ms.) select c.channel_id, c.processing_order, c.max_batch_size, c.enabled, c.max_batch_to_send, c.max_data_to_route, c.use_old_data_to_route, c.use_row_data_to_route, c.use_pk_data_to_route, c.contains_big_lob, c.batch_algorithm, c.extract_period_millis, c.data_loader_type, last_update_time, last_update_by, create_time, c.reload_flag, c.file_sync_flag, c.queue, c.max_network_kbps, c.data_event_action from sym_channel c order by c.processing_order asc, c.channel_id 2019-05-11 05:06:11,367 DEBUG [server] [JdbcSqlTemplate] [server-job-1] (0ms.) select channel_id, last_extract_time, suspend_enabled, ignore_enabled from sym_node_channel_ctl where node_id = 'main' order by channel_id 2019-05-11 05:06:11,367 DEBUG [server] [JdbcSqlTemplate] [server-job-1] (0ms.) select distinct channel_id from sym_data where ((data_id between 1 and 50000001)) 2019-05-11 05:06:11,382 DEBUG [server] [JdbcSqlTemplate] [server-job-6] (31ms.) select node_id, queue from sym_extract_request where status='NE' and parent_request_id=0 group by node_id, queue 2019-05-11 05:06:11,507 DEBUG [server] [JdbcSqlTemplate] [server-job-4] (0ms.) update sym_node_host set ip_address='10.0.2.15', instance_id='ADMINISTRATORPC-fe5c0090-31ab-4f78-956c-f9b8d23a1c2b', os_user='ADMINISTRATORPC$', os_name='Windows 7', os_arch='x86', os_version='6.1', available_processors=1, free_memory_bytes=189178664, total_memory_bytes=259653632, max_memory_bytes=1037959168, java_version='1.8.0_211', java_vendor='Oracle Corporation', jdbc_version='3.0', symmetric_version='3.10.2', timezone_offset='+10:00', heartbeat_time={ts '2019-05-11 05:06:11.000'}, last_restart_time={ts '2019-05-11 05:06:11.195'} where node_id='main' and host_name='ADMINISTRATORPC' 2019-05-11 05:06:11,523 DEBUG [server] [JdbcSqlTemplate] [server-job-4] (0ms.) insert into sym_node_host (ip_address, instance_id, os_user, os_name, os_arch, os_version, available_processors, free_memory_bytes, total_memory_bytes, max_memory_bytes, java_version, java_vendor, jdbc_version, symmetric_version, timezone_offset, heartbeat_time, last_restart_time, create_time, node_id, host_name) values('10.0.2.15','ADMINISTRATORPC-fe5c0090-31ab-4f78-956c-f9b8d23a1c2b','ADMINISTRATORPC$','Windows 7','x86','6.1',1,189178664,259653632,1037959168,'1.8.0_211','Oracle Corporation','3.0','3.10.2','+10:00',{ts '2019-05-11 05:06:11.000'},{ts '2019-05-11 05:06:11.195'}, current_timestamp,'main','ADMINISTRATORPC') 2019-05-11 05:06:21,382 DEBUG [server] [JdbcSqlTemplate] [server-job-10] (0ms.) select target_node_id, create_table, delete_first, reload_select, before_custom_sql, reload_time, channel_id, create_time, last_update_by, last_update_time, trigger_id, router_id from sym_table_reload_request where source_node_id='main' and processed = 0 order by create_time, target_node_id 2019-05-11 05:06:21,382 DEBUG [server] [JdbcSqlTemplate] [server-job-10] (0ms.) select distinct channel_id from sym_data where ((data_id between 1 and 50000001)) 2019-05-11 05:06:21,398 DEBUG [server] [JdbcSqlTemplate] [server-job-10] (0ms.) select node_id, queue from sym_extract_request where status='NE' and parent_request_id=0 group by node_id, queue 2019-05-11 05:06:34,395 INFO [startup] [AbstractCommandLauncher] [main] Option: name=max-idle-time, value={90000} 2019-05-11 05:06:34,395 INFO [startup] [AbstractCommandLauncher] [main] Option: name=no-log-console, value={} 2019-05-11 05:06:34,676 INFO [startup] [SymmetricUtils] [main] _____ __ _ ____ _____ / ___/ __ _____ __ ___ __ ___ _/ /_ ____(_)___ / __ \| / ___/ \__ \ / / / / _ `_ \/ _ `_ \/ _ \/_ __// __/ / __/ / / / / \__ \ ___/ // /_/ / // // / // // / __// / / / / / /_ / /_/ / ___/ / /____/ \__ /_//_//_/_//_//_/\___/ \_/ /_/ /_/\__/ /_____/ /____/ /____/ +-----------------------------------------------------------------+ \| Copyright (C) 2007-2019 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 \| +-----------------------------------------------------------------+ 2019-05-11 05:06:34,723 INFO [startup] [SymmetricWebServer] [main] About to start SymmetricDS web server on host:port 0.0.0.0:31415 2019-05-11 05:06:35,879 INFO [server] [AbstractSymmetricEngine] [symmetric-engine-startup-1] Initializing connection to database 2019-05-11 05:06:35,989 WARN [server] [FBManagedConnection] [symmetric-engine-startup-1] WARNING: No connection character set specified (property lc_ctype, encoding, charSet or localEncoding), defaulting to character set NONE 2019-05-11 05:06:36,239 WARN [server] [FBManagedConnection] [symmetric-engine-startup-1] WARNING: No connection character set specified (property lc_ctype, encoding, charSet or localEncoding), defaulting to character set NONE 2019-05-11 05:06:36,286 WARN [server] [FBManagedConnection] [symmetric-engine-startup-1] WARNING: No connection character set specified (property lc_ctype, encoding, charSet or localEncoding), defaulting to character set NONE 2019-05-11 05:06:36,286 WARN [server] [FBManagedConnection] [symmetric-engine-startup-1] WARNING: No connection character set specified (property lc_ctype, encoding, charSet or localEncoding), defaulting to character set NONE 2019-05-11 05:06:36,348 WARN [server] [FBManagedConnection] [symmetric-engine-startup-1] WARNING: No connection character set specified (property lc_ctype, encoding, charSet or localEncoding), defaulting to character set NONE 2019-05-11 05:06:36,395 WARN [server] [FBManagedConnection] [symmetric-engine-startup-1] WARNING: No connection character set specified (property lc_ctype, encoding, charSet or localEncoding), defaulting to character set NONE 2019-05-11 05:06:36,536 INFO [server] [JdbcDatabasePlatformFactory] [symmetric-engine-startup-1] Detected database 'Firebird 2.5', version '2', protocol 'firebirdsql' 2019-05-11 05:06:36,551 INFO [server] [JdbcDatabasePlatformFactory] [symmetric-engine-startup-1] The IDatabasePlatform being used is org.jumpmind.db.platform.firebird.FirebirdDatabasePlatform 2019-05-11 05:06:36,739 INFO [server] [Firebird21SymmetricDialect] [symmetric-engine-startup-1] The DbDialect being used is org.jumpmind.symmetric.db.firebird.Firebird21SymmetricDialect 2019-05-11 05:06:36,770 INFO [server] [StagingManager] [symmetric-engine-startup-1] The staging directory was initialized at the following location: tmp\server 2019-05-11 05:06:37,723 INFO [server] [ClientExtensionService] [symmetric-engine-startup-1] Found 7 extension points from spring that will be registered 2019-05-11 05:06:37,739 INFO [server] [AbstractSymmetricEngine] [symmetric-engine-startup-1] Initializing SymmetricDS database 2019-05-11 05:06:37,739 INFO [server] [Firebird21SymmetricDialect] [symmetric-engine-startup-1] Checking if SymmetricDS tables need created or altered 2019-05-11 05:06:38,145 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_CHANNEL needs to be added 2019-05-11 05:06:38,145 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_CONFLICT needs to be added 2019-05-11 05:06:38,145 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_CONTEXT needs to be added 2019-05-11 05:06:38,145 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_DATA needs to be added 2019-05-11 05:06:38,145 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_DATA_EVENT needs to be added 2019-05-11 05:06:38,145 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_DATA_GAP needs to be added 2019-05-11 05:06:38,145 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_EXTENSION needs to be added 2019-05-11 05:06:38,145 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_EXTRACT_REQUEST needs to be added 2019-05-11 05:06:38,145 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_FILE_INCOMING needs to be added 2019-05-11 05:06:38,145 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_FILE_SNAPSHOT needs to be added 2019-05-11 05:06:38,145 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_FILE_TRIGGER needs to be added 2019-05-11 05:06:38,145 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_FILE_TRIGGER_ROUTER needs to be added 2019-05-11 05:06:38,145 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_GROUPLET needs to be added 2019-05-11 05:06:38,145 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_GROUPLET_LINK needs to be added 2019-05-11 05:06:38,145 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_INCOMING_BATCH needs to be added 2019-05-11 05:06:38,145 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_INCOMING_ERROR needs to be added 2019-05-11 05:06:38,145 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_JOB needs to be added 2019-05-11 05:06:38,145 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_LOAD_FILTER needs to be added 2019-05-11 05:06:38,145 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_LOCK needs to be added 2019-05-11 05:06:38,145 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_NODE needs to be added 2019-05-11 05:06:38,145 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_NODE_COMMUNICATION needs to be added 2019-05-11 05:06:38,145 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_NODE_CHANNEL_CTL needs to be added 2019-05-11 05:06:38,145 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_NODE_GROUP needs to be added 2019-05-11 05:06:38,145 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_NODE_GROUP_CHANNEL_WND needs to be added 2019-05-11 05:06:38,145 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_NODE_GROUP_LINK needs to be added 2019-05-11 05:06:38,145 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_NODE_HOST needs to be added 2019-05-11 05:06:38,145 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_NODE_HOST_CHANNEL_STATS needs to be added 2019-05-11 05:06:38,145 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_NODE_HOST_JOB_STATS needs to be added 2019-05-11 05:06:38,145 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_NODE_HOST_STATS needs to be added 2019-05-11 05:06:38,145 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_NODE_IDENTITY needs to be added 2019-05-11 05:06:38,145 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_NODE_SECURITY needs to be added 2019-05-11 05:06:38,145 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_MONITOR needs to be added 2019-05-11 05:06:38,145 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_MONITOR_EVENT needs to be added 2019-05-11 05:06:38,145 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_NOTIFICATION needs to be added 2019-05-11 05:06:38,145 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_OUTGOING_BATCH needs to be added 2019-05-11 05:06:38,145 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_PARAMETER needs to be added 2019-05-11 05:06:38,145 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_REGISTRATION_REDIRECT needs to be added 2019-05-11 05:06:38,145 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_REGISTRATION_REQUEST needs to be added 2019-05-11 05:06:38,145 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_ROUTER needs to be added 2019-05-11 05:06:38,145 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_SEQUENCE needs to be added 2019-05-11 05:06:38,145 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_TABLE_RELOAD_REQUEST needs to be added 2019-05-11 05:06:38,145 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_TABLE_RELOAD_STATUS needs to be added 2019-05-11 05:06:38,145 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_TRANSFORM_TABLE needs to be added 2019-05-11 05:06:38,145 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_TRANSFORM_COLUMN needs to be added 2019-05-11 05:06:38,145 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_TRIGGER needs to be added 2019-05-11 05:06:38,145 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_TRIGGER_HIST needs to be added 2019-05-11 05:06:38,145 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_TRIGGER_ROUTER needs to be added 2019-05-11 05:06:38,145 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_TRIGGER_ROUTER_GROUPLET needs to be added 2019-05-11 05:06:38,161 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_CHANNEL needs to be added 2019-05-11 05:06:38,161 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_CONFLICT needs to be added 2019-05-11 05:06:38,161 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_CONTEXT needs to be added 2019-05-11 05:06:38,161 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_DATA needs to be added 2019-05-11 05:06:38,161 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_DATA_EVENT needs to be added 2019-05-11 05:06:38,161 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_DATA_GAP needs to be added 2019-05-11 05:06:38,161 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_EXTENSION needs to be added 2019-05-11 05:06:38,161 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_EXTRACT_REQUEST needs to be added 2019-05-11 05:06:38,161 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_FILE_INCOMING needs to be added 2019-05-11 05:06:38,161 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_FILE_SNAPSHOT needs to be added 2019-05-11 05:06:38,161 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_FILE_TRIGGER needs to be added 2019-05-11 05:06:38,161 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_FILE_TRIGGER_ROUTER needs to be added 2019-05-11 05:06:38,161 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_GROUPLET needs to be added 2019-05-11 05:06:38,161 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_GROUPLET_LINK needs to be added 2019-05-11 05:06:38,161 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_INCOMING_BATCH needs to be added 2019-05-11 05:06:38,161 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_INCOMING_ERROR needs to be added 2019-05-11 05:06:38,161 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_JOB needs to be added 2019-05-11 05:06:38,161 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_LOAD_FILTER needs to be added 2019-05-11 05:06:38,161 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_LOCK needs to be added 2019-05-11 05:06:38,161 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_NODE needs to be added 2019-05-11 05:06:38,161 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_NODE_COMMUNICATION needs to be added 2019-05-11 05:06:38,161 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_NODE_CHANNEL_CTL needs to be added 2019-05-11 05:06:38,161 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_NODE_GROUP needs to be added 2019-05-11 05:06:38,161 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_NODE_GROUP_CHANNEL_WND needs to be added 2019-05-11 05:06:38,161 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_NODE_GROUP_LINK needs to be added 2019-05-11 05:06:38,161 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_NODE_HOST needs to be added 2019-05-11 05:06:38,161 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_NODE_HOST_CHANNEL_STATS needs to be added 2019-05-11 05:06:38,161 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_NODE_HOST_JOB_STATS needs to be added 2019-05-11 05:06:38,161 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_NODE_HOST_STATS needs to be added 2019-05-11 05:06:38,161 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_NODE_IDENTITY needs to be added 2019-05-11 05:06:38,161 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_NODE_SECURITY needs to be added 2019-05-11 05:06:38,161 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_MONITOR needs to be added 2019-05-11 05:06:38,161 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_MONITOR_EVENT needs to be added 2019-05-11 05:06:38,161 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_NOTIFICATION needs to be added 2019-05-11 05:06:38,161 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_OUTGOING_BATCH needs to be added 2019-05-11 05:06:38,161 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_PARAMETER needs to be added 2019-05-11 05:06:38,161 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_REGISTRATION_REDIRECT needs to be added 2019-05-11 05:06:38,161 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_REGISTRATION_REQUEST needs to be added 2019-05-11 05:06:38,161 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_ROUTER needs to be added 2019-05-11 05:06:38,161 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_SEQUENCE needs to be added 2019-05-11 05:06:38,161 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_TABLE_RELOAD_REQUEST needs to be added 2019-05-11 05:06:38,161 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_TABLE_RELOAD_STATUS needs to be added 2019-05-11 05:06:38,161 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_TRANSFORM_TABLE needs to be added 2019-05-11 05:06:38,161 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_TRANSFORM_COLUMN needs to be added 2019-05-11 05:06:38,161 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_TRIGGER needs to be added 2019-05-11 05:06:38,161 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_TRIGGER_HIST needs to be added 2019-05-11 05:06:38,161 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_TRIGGER_ROUTER needs to be added 2019-05-11 05:06:38,161 DEBUG [server] [ModelComparator] [symmetric-engine-startup-1] Table SYM_TRIGGER_ROUTER_GROUPLET needs to be added 2019-05-11 05:06:38,176 INFO [server] [Firebird21SymmetricDialect] [symmetric-engine-startup-1] There are SymmetricDS tables that needed altered 2019-05-11 05:06:38,192 WARN [server] [Firebird21SymmetricDialect] [symmetric-engine-startup-1] DDL failed: CREATE TABLE "SYM_CHANNEL"( "CHANNEL_ID" VARCHAR(128) NOT NULL, "PROCESSING_ORDER" INTEGER DEFAULT 1 NOT NULL, "MAX_BATCH_SIZE" INTEGER DEFAULT 1000 NOT NULL, "MAX_BATCH_TO_SEND" INTEGER DEFAULT 60 NOT NULL, "MAX_DATA_TO_ROUTE" INTEGER DEFAULT 100000 NOT NULL, "EXTRACT_PERIOD_MILLIS" INTEGER DEFAULT 0 NOT NULL, "ENABLED" SMALLINT DEFAULT 1 NOT NULL, "USE_OLD_DATA_TO_ROUTE" SMALLINT DEFAULT 1 NOT NULL, "USE_ROW_DATA_TO_ROUTE" SMALLINT DEFAULT 1 NOT NULL, "USE_PK_DATA_TO_ROUTE" SMALLINT DEFAULT 1 NOT NULL, "RELOAD_FLAG" SMALLINT DEFAULT 0 NOT NULL, "FILE_SYNC_FLAG" SMALLINT DEFAULT 0 NOT NULL, "CONTAINS_BIG_LOB" SMALLINT DEFAULT 0 NOT NULL, "BATCH_ALGORITHM" VARCHAR(50) DEFAULT 'default' NOT NULL, "DATA_LOADER_TYPE" VARCHAR(50) DEFAULT 'default' NOT NULL, "DESCRIPTION" VARCHAR(255), "QUEUE" VARCHAR(25) DEFAULT 'default' NOT NULL, "MAX_NETWORK_KBPS" DECIMAL(10,3) DEFAULT 0.000 NOT NULL, "DATA_EVENT_ACTION" CHAR(1), "CREATE_TIME" TIMESTAMP, "LAST_UPDATE_BY" VARCHAR(50), "LAST_UPDATE_TIME" TIMESTAMP, PRIMARY KEY ("CHANNEL_ID") ) 2019-05-11 05:06:38,208 WARN [server] [JdbcSqlTemplate] [symmetric-engine-startup-1] unsuccessful metadata update; Table SYM_CHANNEL already exists [SQLState:42000, ISC error code:335544351]. Failed to execute: CREATE TABLE "SYM_CHANNEL"( "CHANNEL_ID" VARCHAR(128) NOT NULL, "PROCESSING_ORDER" INTEGER DEFAULT 1 NOT NULL, "MAX_BATCH_SIZE" INTEGER DEFAULT 1000 NOT NULL, "MAX_BATCH_TO_SEND" INTEGER DEFAULT 60 NOT NULL, "MAX_DATA_TO_ROUTE" INTEGER DEFAULT 100000 NOT NULL, "EXTRACT_PERIOD_MILLIS" INTEGER DEFAULT 0 NOT NULL, "ENABLED" SMALLINT DEFAULT 1 NOT NULL, "USE_OLD_DATA_TO_ROUTE" SMALLINT DEFAULT 1 NOT NULL, "USE_ROW_DATA_TO_ROUTE" SMALLINT DEFAULT 1 NOT NULL, "USE_PK_DATA_TO_ROUTE" SMALLINT DEFAULT 1 NOT NULL, "RELOAD_FLAG" SMALLINT DEFAULT 0 NOT NULL, "FILE_SYNC_FLAG" SMALLINT DEFAULT 0 NOT NULL, "CONTAINS_BIG_LOB" SMALLINT DEFAULT 0 NOT NULL, "BATCH_ALGORITHM" VARCHAR(50) DEFAULT 'default' NOT NULL, "DATA_LOADER_TYPE" VARCHAR(50) DEFAULT 'default' NOT NULL, "DESCRIPTION" VARCHAR(255), "QUEUE" VARCHAR(25) DEFAULT 'default' NOT NULL, "MAX_NETWORK_KBPS" DECIMAL(10,3) DEFAULT 0.000 NOT NULL, "DATA_EVENT_ACTION" CHAR(1), "CREATE_TIME" TIMESTAMP, "LAST_UPDATE_BY" VARCHAR(50), "LAST_UPDATE_TIME" TIMESTAMP, PRIMARY KEY ("CHANNEL_ID") ) 2019-05-11 05:06:38,208 ERROR [server] [AbstractSymmetricEngine] [symmetric-engine-startup-1] An error occurred while starting SymmetricDS StackTraceKey.init [SqlException:3366919038] org.jumpmind.db.sql.SqlException: unsuccessful metadata update; Table SYM_CHANNEL already exists [SQLState:42000, ISC error code:335544351] at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:302) at org.jumpmind.db.platform.firebird.FirebirdJdbcSqlTemplate.translate(FirebirdJdbcSqlTemplate.java:62) at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:291) at org.jumpmind.db.sql.JdbcSqlTemplate.execute(JdbcSqlTemplate.java:513) at org.jumpmind.db.sql.JdbcSqlTemplate.update(JdbcSqlTemplate.java:421) at org.jumpmind.db.sql.SqlScript.execute(SqlScript.java:115) at org.jumpmind.symmetric.db.AbstractSymmetricDialect.createOrAlterTablesIfNecessary(AbstractSymmetricDialect.java:546) at org.jumpmind.symmetric.db.AbstractSymmetricDialect.initTablesAndDatabaseObjects(AbstractSymmetricDialect.java:160) at org.jumpmind.symmetric.AbstractSymmetricEngine.setupDatabase(AbstractSymmetricEngine.java:502) at org.jumpmind.symmetric.AbstractSymmetricEngine.setup(AbstractSymmetricEngine.java:476) at org.jumpmind.symmetric.AbstractSymmetricEngine.start(AbstractSymmetricEngine.java:646) at org.jumpmind.symmetric.AbstractSymmetricEngine.start(AbstractSymmetricEngine.java:635) at org.jumpmind.symmetric.ClientSymmetricEngine.start(ClientSymmetricEngine.java:276) at org.jumpmind.symmetric.web.SymmetricEngineHolder$EngineStarter.run(SymmetricEngineHolder.java:602) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) Caused by: java.sql.SQLSyntaxErrorException: unsuccessful metadata update; Table SYM_CHANNEL already exists [SQLState:42000, ISC error code:335544351] at org.firebirdsql.gds.ng.FbExceptionBuilder$Type$1.createSQLException(FbExceptionBuilder.java:527) at org.firebirdsql.gds.ng.FbExceptionBuilder.toFlatSQLException(FbExceptionBuilder.java:302) at org.firebirdsql.gds.ng.jna.JnaConnection.processStatusVector(JnaConnection.java:146) at org.firebirdsql.gds.ng.jna.JnaDatabase.processStatusVector(JnaDatabase.java:483) at org.firebirdsql.gds.ng.jna.JnaStatement.processStatusVector(JnaStatement.java:437) at org.firebirdsql.gds.ng.jna.JnaStatement.execute(JnaStatement.java:194) at org.firebirdsql.jdbc.FBStatement.internalExecute(FBStatement.java:1355) at org.firebirdsql.jdbc.FBStatement.executeImpl(FBStatement.java:840) at org.firebirdsql.jdbc.FBStatement.execute(FBStatement.java:826) 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:436) at org.jumpmind.db.sql.JdbcSqlTemplate$6.execute(JdbcSqlTemplate.java:421) at org.jumpmind.db.sql.JdbcSqlTemplate.execute(JdbcSqlTemplate.java:511) ... 13 more Caused by: org.firebirdsql.jdbc.FBSQLExceptionInfo: unsuccessful metadata update 2019-05-11 05:06:38,239 INFO [server] [AbstractSymmetricEngine] [symmetric-engine-startup-1] Stopping SymmetricDS externalId=main version=3.10.2 database=Firebird 2.5 2019-05-11 05:06:38,239 INFO [server] [AbstractSymmetricEngine] [symmetric-engine-startup-1] 2019-05-11 05:06:38,739 INFO [startup] [SymmetricWebServer] [main] Starting JMX HTTP console on port 31416 2019-05-11 05:06:38,770 INFO [startup] [SymmetricWebServer] [main] Joining the web server main thread 2019-05-11 05:10:35,956 WARN [server] [FBManagedConnection] [Timer-0] WARNING: No connection character set specified (property lc_ctype, encoding, charSet or localEncoding), defaulting to character set NONE 2019-05-11 05:10:35,972 WARN [server] [FBManagedConnection] [Timer-0] WARNING: No connection character set specified (property lc_ctype, encoding, charSet or localEncoding), defaulting to character set NONE 2019-05-11 05:10:35,972 WARN [server] [FBManagedConnection] [Timer-0] WARNING: No connection character set specified (property lc_ctype, encoding, charSet or localEncoding), defaulting to character set NONE 2019-05-11 05:10:35,972 WARN [server] [FBManagedConnection] [Timer-0] WARNING: No connection character set specified (property lc_ctype, encoding, charSet or localEncoding), defaulting to character set NONE 2019-05-11 05:10:35,972 WARN [server] [FBManagedConnection] [Timer-0] WARNING: No connection character set specified (property lc_ctype, encoding, charSet or localEncoding), defaulting to character set NONE 2019-05-11 05:14:35,956 WARN [server] [FBManagedConnection] [Timer-0] WARNING: No connection character set specified (property lc_ctype, encoding, charSet or localEncoding), defaulting to character set NONE 2019-05-11 05:14:35,956 WARN [server] [FBManagedConnection] [Timer-0] WARNING: No connection character set specified (property lc_ctype, encoding, charSet or localEncoding), defaulting to character set NONE 2019-05-11 05:14:35,972 WARN [server] [FBManagedConnection] [Timer-0] WARNING: No connection character set specified (property lc_ctype, encoding, charSet or localEncoding), defaulting to character set NONE 2019-05-11 05:14:35,972 WARN [server] [FBManagedConnection] [Timer-0] WARNING: No connection character set specified (property lc_ctype, encoding, charSet or localEncoding), defaulting to character set NONE 2019-05-11 05:14:35,972 WARN [server] [FBManagedConnection] [Timer-0] WARNING: No connection character set specified (property lc_ctype, encoding, charSet or localEncoding), defaulting to character set NONE symmetric.log (166,848 bytes)

elong 2019-05-13 17:28 developer ~0001468	Does it work if you remove the "native" from the db.url? That's how the unit tests run, using the pure Java driver.

enwony 2019-05-13 18:34 reporter ~0001470	I set driver as java (db.url=jdbc:firebirdsql://localhost/C:/TestSync/mydb.fdb) in server.properties and restarted server, same error message appear.

elong 2019-05-13 19:55 developer ~0001473	Reproduced using SymmetricDS 3.10.2 and Firebird 2.5 on Windows. Needs to be running on Windows to reproduce. Using SymmetricDS 3.9.20 works fine.

elong 2019-05-13 20:09 developer ~0001474	It appears to be the Jaybird JDBC driver. If I take the jaybird 2.1.6 JDBC driver from SymmetricDS 3.9 and use it with SymmetricDS 3.10, then everything is working.

enwony 2019-05-16 16:19 reporter ~0001491	Original problematic Jaybird version is 3.0.5; after deleting lib/jaybird-jdk18-3.0.5.jar and placing lib/jaybird-2.1.6.jar from symmetric-server-3.10.2.zip everything work fine (can be used as workaround). Anyway, what is source of that? Issue reproduced with jaybird 2.2.15. As I understood, issue depends on things described in p. 3.4.5 of https://www.firebirdsql.org/file/documentation/drivers_documentation/java/2.2.15/release_notes.html (changes since 2.2 release in jaybird). It states that In Jaybird 3.0 meta data methods will no longer do the following: * Remove quotes around object names * Trying the uppercase value, when the original parameter value failed to produce results in order to follow stricter JDBC compliance In log I can see application uses create query with quoted identifiers (CREATE TABLE "SYM_CHANNEL" ...), so should it check existance also uppercased?

Date Modified	Username	Field	Change
2019-05-10 19:20	enwony	New Issue
2019-05-10 19:20	enwony	File Added: server.properties
2019-05-10 19:20	enwony	File Added: symmetric.log
2019-05-10 20:46	elong	Tag Attached: dialect: firebird
2019-05-10 20:46	elong	Tag Attached: install
2019-05-13 17:28	elong	Note Added: 0001468
2019-05-13 17:29	elong	Status	new => feedback
2019-05-13 18:34	enwony	Note Added: 0001470
2019-05-13 18:34	enwony	Status	feedback => new
2019-05-13 19:55	elong	Status	new => confirmed
2019-05-13 19:55	elong	Note Added: 0001473
2019-05-13 20:09	elong	Note Added: 0001474
2019-05-16 16:19	enwony	Note Added: 0001491
2019-05-17 17:20	elong	Summary	Firebird 2.5 trying to recreate existing tables (error in case-sensivity?) => Firebird 2.5 trying to recreate existing tables (metadata problem with Jaybird 3.x driver)
2019-05-17 17:20	elong	Description Updated	View Revisions
2019-05-17 17:20	elong	Steps to Reproduce Updated	View Revisions
2019-05-17 17:25	elong	Assigned To	=> elong
2019-05-17 17:25	elong	Status	confirmed => resolved
2019-05-17 17:25	elong	Resolution	open => fixed
2019-05-17 17:25	elong	Fixed in Version	=> 3.10.3
2019-05-17 17:25	elong	Target Version	=> 3.10.3
2019-06-25 18:06	admin	Status	resolved => closed

View Issue Details

Activities

Issue History