View Issue Details

IDProjectCategoryView StatusLast Update
0003953SymmetricDSBugpublic2019-06-25 18:06
Reporterenwony Assigned Toelong  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.10.2 
Target Version3.10.3Fixed in Version3.10.3 
Summary0003953: Firebird 2.5 trying to recreate existing tables (metadata problem with Jaybird 3.x driver)
DescriptionIt 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 Reproduce1. 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.
Tagsdialect: firebird, install

Activities

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?

Issue History

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