2015-08-11 10:54:34,062 INFO [] [AbstractCommandLauncher] [main] Option: name=engine, value={corp-000} 2015-08-11 10:54:34,064 INFO [] [AbstractCommandLauncher] [main] Option: name=format, value={XML} 2015-08-11 10:54:34,065 INFO [] [AbstractCommandLauncher] [main] Option: name=alter-case, value={} 2015-08-11 10:54:34,727 INFO [] [JdbcDatabasePlatformFactory] [main] Detected database 'Firebird 2.56LI-V2.5.4.26856 Firebird 2.5/tcp (host4.webdts.eu)/P10', version '2', protocol 'firebirdsql' 2015-08-11 10:54:34,767 INFO [] [JdbcDatabasePlatformFactory] [main] The IDatabasePlatform being used is org.jumpmind.db.platform.firebird.FirebirdDatabasePlatform 2015-08-11 10:54:34,877 INFO [] [DefaultDatabaseWriter] [main] About to create table using the following definition:
2015-08-11 10:54:34,993 INFO [] [DefaultDatabaseWriter] [main] About to create table using the following definition:
2015-08-11 10:54:35,158 INFO [] [DefaultDatabaseWriter] [main] About to create table using the following definition:
2015-08-11 10:54:35,271 INFO [] [DefaultDatabaseWriter] [main] About to create table using the following definition:
2015-08-11 11:00:32,674 INFO [] [AbstractCommandLauncher] [main] Option: name=engine, value={corp-000} 2015-08-11 11:00:32,680 INFO [] [AbstractCommandLauncher] [main] Option: name=format, value={XML} 2015-08-11 11:00:32,681 INFO [] [AbstractCommandLauncher] [main] Option: name=alter-case, value={} 2015-08-11 11:00:33,332 INFO [] [JdbcDatabasePlatformFactory] [main] Detected database 'Firebird 2.56LI-V2.5.4.26856 Firebird 2.5/tcp (host4.webdts.eu)/P10', version '2', protocol 'firebirdsql' 2015-08-11 11:00:33,372 INFO [] [JdbcDatabasePlatformFactory] [main] The IDatabasePlatform being used is org.jumpmind.db.platform.firebird.FirebirdDatabasePlatform 2015-08-11 11:00:33,594 INFO [] [DefaultDatabaseWriter] [main] About to create table using the following definition:
2015-08-11 11:00:33,631 WARN [] [JdbcSqlTemplate] [main] GDS Exception. 335544351. unsuccessful metadata update Table ITEM already exists null null. Failed to execute: CREATE TABLE "ITEM"( "ITEM_ID" INTEGER NOT NULL, "NAME" VARCHAR(100), PRIMARY KEY ("ITEM_ID") ) 2015-08-11 11:00:33,633 ERROR [] [DefaultDatabaseWriter] [main] Failed to alter table using the following xml:
2015-08-11 11:04:00,505 INFO [] [AbstractCommandLauncher] [main] Option: name=engine, value={corp-000} 2015-08-11 11:04:01,147 INFO [corp-000] [JdbcDatabasePlatformFactory] [main] Detected database 'Firebird 2.56LI-V2.5.4.26856 Firebird 2.5/tcp (host4.webdts.eu)/P10', version '2', protocol 'firebirdsql' 2015-08-11 11:04:01,163 INFO [corp-000] [JdbcDatabasePlatformFactory] [main] The IDatabasePlatform being used is org.jumpmind.db.platform.firebird.FirebirdDatabasePlatform 2015-08-11 11:04:01,239 INFO [corp-000] [Firebird21SymmetricDialect] [main] The DbDialect being used is org.jumpmind.symmetric.db.firebird.Firebird21SymmetricDialect 2015-08-11 11:04:01,296 INFO [corp-000] [StagingManager] [main] The staging directory was initialized at the following location: /web/symmetric-server-3.7.19/tmp/corp-000 2015-08-11 11:04:01,386 INFO [corp-000] [ClusterService] [main] This node picked a server id of host4.webdts.eu 2015-08-11 11:04:02,648 INFO [corp-000] [ClientExtensionService] [main] Found 8 extension points from spring that will be registered 2015-08-11 11:04:02,649 INFO [corp-000] [AbstractSymmetricEngine] [main] Initializing SymmetricDS database 2015-08-11 11:04:02,649 INFO [corp-000] [Firebird21SymmetricDialect] [main] Checking if SymmetricDS tables need created or altered 2015-08-11 11:04:03,713 INFO [corp-000] [Firebird21SymmetricDialect] [main] There are SymmetricDS tables that needed altered 2015-08-11 11:04:03,799 INFO [corp-000] [Firebird21SymmetricDialect] [main] 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), "CREATE_TIME" TIMESTAMP, "LAST_UPDATE_BY" VARCHAR(50), "LAST_UPDATE_TIME" TIMESTAMP, PRIMARY KEY ("CHANNEL_ID") ) 2015-08-11 11:04:03,881 INFO [corp-000] [Firebird21SymmetricDialect] [main] 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") ) 2015-08-11 11:04:04,009 INFO [corp-000] [Firebird21SymmetricDialect] [main] 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), "CREATE_TIME" TIMESTAMP, PRIMARY KEY ("DATA_ID") ) 2015-08-11 11:04:04,057 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: CREATE INDEX "SYM_IDX_D_CHANNEL_ID" ON "SYM_DATA" ("DATA_ID", "CHANNEL_ID") 2015-08-11 11:04:04,061 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: CREATE GENERATOR "GEN_SYM_DATA_DATA_ID" 2015-08-11 11:04:04,080 INFO [corp-000] [Firebird21SymmetricDialect] [main] 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 2015-08-11 11:04:04,138 INFO [corp-000] [Firebird21SymmetricDialect] [main] 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") ) 2015-08-11 11:04:04,187 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: CREATE INDEX "SYM_IDX_DE_BATCHID" ON "SYM_DATA_EVENT" ("BATCH_ID") 2015-08-11 11:04:04,252 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: CREATE TABLE "SYM_DATA_GAP"( "START_ID" BIGINT NOT NULL, "END_ID" BIGINT NOT NULL, "STATUS" CHAR(2), "CREATE_TIME" TIMESTAMP NOT NULL, "LAST_UPDATE_HOSTNAME" VARCHAR(255), "LAST_UPDATE_TIME" TIMESTAMP NOT NULL, PRIMARY KEY ("START_ID", "END_ID") ) 2015-08-11 11:04:04,274 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: CREATE INDEX "SYM_IDX_DG_STATUS" ON "SYM_DATA_GAP" ("STATUS") 2015-08-11 11:04:04,362 INFO [corp-000] [Firebird21SymmetricDialect] [main] 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") ) 2015-08-11 11:04:04,443 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: CREATE TABLE "SYM_EXTRACT_REQUEST"( "REQUEST_ID" BIGINT NOT NULL, "NODE_ID" VARCHAR(50) NOT NULL, "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, "LAST_UPDATE_TIME" TIMESTAMP, "CREATE_TIME" TIMESTAMP, PRIMARY KEY ("REQUEST_ID") ) 2015-08-11 11:04:04,559 INFO [corp-000] [Firebird21SymmetricDialect] [main] 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") ) 2015-08-11 11:04:04,666 INFO [corp-000] [Firebird21SymmetricDialect] [main] 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") ) 2015-08-11 11:04:04,675 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: CREATE INDEX "SYM_IDX_F_SNPSHT_CHID" ON "SYM_FILE_SNAPSHOT" ("RELOAD_CHANNEL_ID") 2015-08-11 11:04:04,745 INFO [corp-000] [Firebird21SymmetricDialect] [main] 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, PRIMARY KEY ("TRIGGER_ID") ) 2015-08-11 11:04:04,844 INFO [corp-000] [Firebird21SymmetricDialect] [main] 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, PRIMARY KEY ("TRIGGER_ID", "ROUTER_ID") ) 2015-08-11 11:04:04,992 INFO [corp-000] [Firebird21SymmetricDialect] [main] 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") ) 2015-08-11 11:04:05,049 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: CREATE TABLE "SYM_GROUPLET_LINK"( "GROUPLET_ID" VARCHAR(50) NOT NULL, "EXTERNAL_ID" VARCHAR(50) NOT NULL, "CREATE_TIME" TIMESTAMP NOT NULL, "LAST_UPDATE_BY" VARCHAR(50), "LAST_UPDATE_TIME" TIMESTAMP NOT NULL, PRIMARY KEY ("GROUPLET_ID", "EXTERNAL_ID") ) 2015-08-11 11:04:05,125 INFO [corp-000] [Firebird21SymmetricDialect] [main] 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, "NETWORK_MILLIS" BIGINT DEFAULT 0 NOT NULL, "FILTER_MILLIS" BIGINT DEFAULT 0 NOT NULL, "DATABASE_MILLIS" BIGINT DEFAULT 0 NOT NULL, "FAILED_ROW_NUMBER" BIGINT DEFAULT 0 NOT NULL, "FAILED_LINE_NUMBER" BIGINT DEFAULT 0 NOT NULL, "BYTE_COUNT" BIGINT DEFAULT 0 NOT NULL, "STATEMENT_COUNT" BIGINT DEFAULT 0 NOT NULL, "FALLBACK_INSERT_COUNT" BIGINT DEFAULT 0 NOT NULL, "FALLBACK_UPDATE_COUNT" BIGINT DEFAULT 0 NOT NULL, "IGNORE_COUNT" BIGINT DEFAULT 0 NOT NULL, "MISSING_DELETE_COUNT" BIGINT DEFAULT 0 NOT NULL, "SKIP_COUNT" BIGINT DEFAULT 0 NOT NULL, "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, PRIMARY KEY ("BATCH_ID", "NODE_ID") ) 2015-08-11 11:04:05,170 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: CREATE INDEX "SYM_IDX_IB_TIME_STATUS" ON "SYM_INCOMING_BATCH" ("CREATE_TIME", "STATUS") 2015-08-11 11:04:05,270 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: CREATE INDEX "SYM_IDX_IB_IN_ERROR" ON "SYM_INCOMING_BATCH" ("ERROR_FLAG") 2015-08-11 11:04:05,364 INFO [corp-000] [Firebird21SymmetricDialect] [main] 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") ) 2015-08-11 11:04:05,436 INFO [corp-000] [Firebird21SymmetricDialect] [main] 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") ) 2015-08-11 11:04:05,618 INFO [corp-000] [Firebird21SymmetricDialect] [main] 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") ) 2015-08-11 11:04:05,709 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: CREATE TABLE "SYM_NODE"( "NODE_ID" VARCHAR(50) NOT NULL, "NODE_GROUP_ID" VARCHAR(50) NOT NULL, "EXTERNAL_ID" VARCHAR(50) NOT NULL, "SYNC_ENABLED" SMALLINT DEFAULT 0, "SYNC_URL" VARCHAR(255), "SCHEMA_VERSION" VARCHAR(50), "SYMMETRIC_VERSION" VARCHAR(50), "DATABASE_TYPE" VARCHAR(50), "DATABASE_VERSION" VARCHAR(50), "HEARTBEAT_TIME" TIMESTAMP, "TIMEZONE_OFFSET" VARCHAR(6), "BATCH_TO_SEND_COUNT" INTEGER DEFAULT 0, "BATCH_IN_ERROR_COUNT" INTEGER DEFAULT 0, "CREATED_AT_NODE_ID" VARCHAR(50), "DEPLOYMENT_TYPE" VARCHAR(50), PRIMARY KEY ("NODE_ID") ) 2015-08-11 11:04:05,789 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: CREATE TABLE "SYM_NODE_COMMUNICATION"( "NODE_ID" VARCHAR(50) 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, "TOTAL_SUCCESS_COUNT" BIGINT DEFAULT 0, "TOTAL_FAIL_COUNT" BIGINT DEFAULT 0, "TOTAL_SUCCESS_MILLIS" BIGINT DEFAULT 0, "TOTAL_FAIL_MILLIS" BIGINT DEFAULT 0, PRIMARY KEY ("NODE_ID", "COMMUNICATION_TYPE") ) 2015-08-11 11:04:05,860 INFO [corp-000] [Firebird21SymmetricDialect] [main] 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") ) 2015-08-11 11:04:05,977 INFO [corp-000] [Firebird21SymmetricDialect] [main] 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") ) 2015-08-11 11:04:06,226 INFO [corp-000] [Firebird21SymmetricDialect] [main] 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") ) 2015-08-11 11:04:06,337 INFO [corp-000] [Firebird21SymmetricDialect] [main] 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, "CREATE_TIME" TIMESTAMP, "LAST_UPDATE_BY" VARCHAR(50), "LAST_UPDATE_TIME" TIMESTAMP, PRIMARY KEY ("SOURCE_NODE_GROUP_ID", "TARGET_NODE_GROUP_ID") ) 2015-08-11 11:04:06,376 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: CREATE TABLE "SYM_NODE_HOST"( "NODE_ID" VARCHAR(50) NOT NULL, "HOST_NAME" VARCHAR(60) NOT NULL, "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") ) 2015-08-11 11:04:06,415 INFO [corp-000] [Firebird21SymmetricDialect] [main] 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, PRIMARY KEY ("NODE_ID", "HOST_NAME", "CHANNEL_ID", "START_TIME", "END_TIME") ) 2015-08-11 11:04:06,425 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: CREATE INDEX "SYM_IDX_ND_HST_CHNL_STS" ON "SYM_NODE_HOST_CHANNEL_STATS" ("NODE_ID", "START_TIME", "END_TIME") 2015-08-11 11:04:06,597 INFO [corp-000] [Firebird21SymmetricDialect] [main] 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, PRIMARY KEY ("NODE_ID", "HOST_NAME", "JOB_NAME", "START_TIME", "END_TIME") ) 2015-08-11 11:04:06,663 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: CREATE INDEX "SYM_IDX_ND_HST_JOB" ON "SYM_NODE_HOST_JOB_STATS" ("NODE_ID", "START_TIME", "END_TIME") 2015-08-11 11:04:06,811 INFO [corp-000] [Firebird21SymmetricDialect] [main] 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") ) 2015-08-11 11:04:06,861 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: CREATE INDEX "SYM_IDX_ND_HST_STS" ON "SYM_NODE_HOST_STATS" ("NODE_ID", "START_TIME", "END_TIME") 2015-08-11 11:04:06,971 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: CREATE TABLE "SYM_NODE_IDENTITY"( "NODE_ID" VARCHAR(50) NOT NULL, PRIMARY KEY ("NODE_ID") ) 2015-08-11 11:04:07,048 INFO [corp-000] [Firebird21SymmetricDialect] [main] 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") ) 2015-08-11 11:04:07,301 INFO [corp-000] [Firebird21SymmetricDialect] [main] 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), "LOAD_ID" BIGINT, "EXTRACT_JOB_FLAG" SMALLINT DEFAULT 0, "LOAD_FLAG" SMALLINT DEFAULT 0, "ERROR_FLAG" SMALLINT DEFAULT 0, "COMMON_FLAG" SMALLINT DEFAULT 0, "IGNORE_COUNT" BIGINT DEFAULT 0 NOT NULL, "BYTE_COUNT" BIGINT DEFAULT 0 NOT NULL, "EXTRACT_COUNT" BIGINT DEFAULT 0 NOT NULL, "SENT_COUNT" BIGINT DEFAULT 0 NOT NULL, "LOAD_COUNT" BIGINT DEFAULT 0 NOT NULL, "DATA_EVENT_COUNT" BIGINT DEFAULT 0 NOT NULL, "RELOAD_EVENT_COUNT" BIGINT DEFAULT 0 NOT NULL, "INSERT_EVENT_COUNT" BIGINT DEFAULT 0 NOT NULL, "UPDATE_EVENT_COUNT" BIGINT DEFAULT 0 NOT NULL, "DELETE_EVENT_COUNT" BIGINT DEFAULT 0 NOT NULL, "OTHER_EVENT_COUNT" BIGINT DEFAULT 0 NOT NULL, "ROUTER_MILLIS" BIGINT DEFAULT 0 NOT NULL, "NETWORK_MILLIS" BIGINT DEFAULT 0 NOT NULL, "FILTER_MILLIS" BIGINT DEFAULT 0 NOT NULL, "LOAD_MILLIS" BIGINT DEFAULT 0 NOT NULL, "EXTRACT_MILLIS" BIGINT DEFAULT 0 NOT NULL, "TRANSFORM_EXTRACT_MILLIS" BIGINT DEFAULT 0 NOT NULL, "TRANSFORM_LOAD_MILLIS" BIGINT DEFAULT 0 NOT NULL, "TOTAL_EXTRACT_MILLIS" BIGINT DEFAULT 0 NOT NULL, "TOTAL_LOAD_MILLIS" BIGINT DEFAULT 0 NOT NULL, "SQL_STATE" VARCHAR(10), "SQL_CODE" INTEGER DEFAULT 0 NOT NULL, "SQL_MESSAGE" BLOB SUB_TYPE TEXT, "FAILED_DATA_ID" BIGINT DEFAULT 0 NOT NULL, "FAILED_LINE_NUMBER" BIGINT DEFAULT 0 NOT NULL, "LAST_UPDATE_HOSTNAME" VARCHAR(255), "LAST_UPDATE_TIME" TIMESTAMP, "CREATE_TIME" TIMESTAMP, "CREATE_BY" VARCHAR(255), PRIMARY KEY ("BATCH_ID", "NODE_ID") ) 2015-08-11 11:04:07,391 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: CREATE INDEX "SYM_IDX_OB_NODE_STATUS" ON "SYM_OUTGOING_BATCH" ("NODE_ID", "STATUS") 2015-08-11 11:04:07,407 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: CREATE INDEX "SYM_IDX_OB_STATUS" ON "SYM_OUTGOING_BATCH" ("STATUS") 2015-08-11 11:04:07,426 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: CREATE INDEX "SYM_IDX_OB_IN_ERROR" ON "SYM_OUTGOING_BATCH" ("ERROR_FLAG") 2015-08-11 11:04:07,485 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: CREATE TABLE "SYM_PARAMETER"( "EXTERNAL_ID" VARCHAR(50) 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") ) 2015-08-11 11:04:07,578 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: CREATE TABLE "SYM_REGISTRATION_REDIRECT"( "REGISTRANT_EXTERNAL_ID" VARCHAR(50) NOT NULL, "REGISTRATION_NODE_ID" VARCHAR(50) NOT NULL, PRIMARY KEY ("REGISTRANT_EXTERNAL_ID") ) 2015-08-11 11:04:07,675 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: CREATE TABLE "SYM_REGISTRATION_REQUEST"( "NODE_GROUP_ID" VARCHAR(50) NOT NULL, "EXTERNAL_ID" VARCHAR(50) 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") ) 2015-08-11 11:04:07,713 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: CREATE INDEX "SYM_IDX_REG_REQ_1" ON "SYM_REGISTRATION_REQUEST" ("NODE_GROUP_ID", "EXTERNAL_ID", "STATUS", "HOST_NAME", "IP_ADDRESS") 2015-08-11 11:04:07,769 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: CREATE INDEX "SYM_IDX_REG_REQ_2" ON "SYM_REGISTRATION_REQUEST" ("STATUS") 2015-08-11 11:04:07,829 INFO [corp-000] [Firebird21SymmetricDialect] [main] 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, PRIMARY KEY ("ROUTER_ID") ) 2015-08-11 11:04:07,901 INFO [corp-000] [Firebird21SymmetricDialect] [main] 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" SMALLINT DEFAULT 0, "CREATE_TIME" TIMESTAMP, "LAST_UPDATE_BY" VARCHAR(50), "LAST_UPDATE_TIME" TIMESTAMP NOT NULL, PRIMARY KEY ("SEQUENCE_NAME") ) 2015-08-11 11:04:08,116 INFO [corp-000] [Firebird21SymmetricDialect] [main] 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, "RELOAD_SELECT" BLOB SUB_TYPE TEXT, "RELOAD_DELETE_STMT" BLOB SUB_TYPE TEXT, "RELOAD_ENABLED" SMALLINT DEFAULT 0, "RELOAD_TIME" TIMESTAMP, "CREATE_TIME" TIMESTAMP, "LAST_UPDATE_BY" VARCHAR(50), "LAST_UPDATE_TIME" TIMESTAMP NOT NULL, PRIMARY KEY ("TARGET_NODE_ID", "SOURCE_NODE_ID", "TRIGGER_ID", "ROUTER_ID") ) 2015-08-11 11:04:08,267 INFO [corp-000] [Firebird21SymmetricDialect] [main] 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, "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, PRIMARY KEY ("TRANSFORM_ID", "SOURCE_NODE_GROUP_ID", "TARGET_NODE_GROUP_ID") ) 2015-08-11 11:04:08,425 INFO [corp-000] [Firebird21SymmetricDialect] [main] 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, PRIMARY KEY ("TRANSFORM_ID", "INCLUDE_ON", "TARGET_COLUMN_NAME") ) 2015-08-11 11:04:08,500 INFO [corp-000] [Firebird21SymmetricDialect] [main] 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_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, "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 0 NOT NULL, "CREATE_TIME" TIMESTAMP NOT NULL, "LAST_UPDATE_BY" VARCHAR(50), "LAST_UPDATE_TIME" TIMESTAMP NOT NULL, PRIMARY KEY ("TRIGGER_ID") ) 2015-08-11 11:04:08,590 INFO [corp-000] [Firebird21SymmetricDialect] [main] 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") ) 2015-08-11 11:04:08,993 INFO [corp-000] [Firebird21SymmetricDialect] [main] 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, "INITIAL_LOAD_BATCH_COUNT" INTEGER DEFAULT 1, "PING_BACK_ENABLED" SMALLINT DEFAULT 0 NOT NULL, "CREATE_TIME" TIMESTAMP NOT NULL, "LAST_UPDATE_BY" VARCHAR(50), "LAST_UPDATE_TIME" TIMESTAMP NOT NULL, PRIMARY KEY ("TRIGGER_ID", "ROUTER_ID") ) 2015-08-11 11:04:09,224 INFO [corp-000] [Firebird21SymmetricDialect] [main] 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") ) 2015-08-11 11:04:09,273 INFO [corp-000] [Firebird21SymmetricDialect] [main] 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") 2015-08-11 11:04:09,297 INFO [corp-000] [Firebird21SymmetricDialect] [main] 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") 2015-08-11 11:04:09,325 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: ALTER TABLE "SYM_FILE_TRIGGER_ROUTER" ADD CONSTRAINT "SYM_FK_FTR_2_RTR" FOREIGN KEY ("ROUTER_ID") REFERENCES "SYM_ROUTER" ("ROUTER_ID") 2015-08-11 11:04:09,339 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: ALTER TABLE "SYM_GROUPLET_LINK" ADD CONSTRAINT "SYM_FK_GPLTLNK_2_GPLT" FOREIGN KEY ("GROUPLET_ID") REFERENCES "SYM_GROUPLET" ("GROUPLET_ID") 2015-08-11 11:04:09,567 INFO [corp-000] [Firebird21SymmetricDialect] [main] 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") 2015-08-11 11:04:09,623 INFO [corp-000] [Firebird21SymmetricDialect] [main] 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") 2015-08-11 11:04:09,812 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: ALTER TABLE "SYM_NODE_IDENTITY" ADD CONSTRAINT "SYM_FK_IDENT_2_NODE" FOREIGN KEY ("NODE_ID") REFERENCES "SYM_NODE" ("NODE_ID") 2015-08-11 11:04:09,887 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: ALTER TABLE "SYM_NODE_SECURITY" ADD CONSTRAINT "SYM_FK_SEC_2_NODE" FOREIGN KEY ("NODE_ID") REFERENCES "SYM_NODE" ("NODE_ID") 2015-08-11 11:04:09,944 INFO [corp-000] [Firebird21SymmetricDialect] [main] 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") 2015-08-11 11:04:10,156 INFO [corp-000] [Firebird21SymmetricDialect] [main] 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") 2015-08-11 11:04:10,311 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: ALTER TABLE "SYM_TRIGGER" ADD CONSTRAINT "SYM_FK_TRG_2_CHNL" FOREIGN KEY ("CHANNEL_ID") REFERENCES "SYM_CHANNEL" ("CHANNEL_ID") 2015-08-11 11:04:10,463 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: ALTER TABLE "SYM_TRIGGER" ADD CONSTRAINT "SYM_FK_TRG_2_RLD_CHNL" FOREIGN KEY ("RELOAD_CHANNEL_ID") REFERENCES "SYM_CHANNEL" ("CHANNEL_ID") 2015-08-11 11:04:10,639 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: ALTER TABLE "SYM_TRIGGER_ROUTER" ADD CONSTRAINT "SYM_FK_TR_2_TRG" FOREIGN KEY ("TRIGGER_ID") REFERENCES "SYM_TRIGGER" ("TRIGGER_ID") 2015-08-11 11:04:10,728 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: ALTER TABLE "SYM_TRIGGER_ROUTER" ADD CONSTRAINT "SYM_FK_TR_2_RTR" FOREIGN KEY ("ROUTER_ID") REFERENCES "SYM_ROUTER" ("ROUTER_ID") 2015-08-11 11:04:10,818 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: ALTER TABLE "SYM_TRIGGER_ROUTER_GROUPLET" ADD CONSTRAINT "SYM_FK_TRGPLT_2_GPLT" FOREIGN KEY ("GROUPLET_ID") REFERENCES "SYM_GROUPLET" ("GROUPLET_ID") 2015-08-11 11:04:10,885 INFO [corp-000] [Firebird21SymmetricDialect] [main] 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") 2015-08-11 11:04:10,885 INFO [corp-000] [Firebird21SymmetricDialect] [main] Done with auto update of SymmetricDS tables 2015-08-11 11:04:11,242 INFO [corp-000] [Firebird21SymmetricDialect] [main] Installing SymmetricDS database object: declare external function sym_hex blob returns cstring(32660) free_it entry_point 'sym_hex' module_name 'sym_udf' 2015-08-11 11:33:08,045 INFO [] [AbstractCommandLauncher] [main] Option: name=engine, value={corp-000} 2015-08-11 11:33:08,053 INFO [] [AbstractCommandLauncher] [main] Option: name=format, value={XML} 2015-08-11 11:33:08,053 INFO [] [AbstractCommandLauncher] [main] Option: name=alter-case, value={} 2015-08-11 11:36:26,216 INFO [] [AbstractCommandLauncher] [main] Option: name=engine, value={corp-000} 2015-08-11 11:36:26,227 INFO [] [AbstractCommandLauncher] [main] Option: name=format, value={XML} 2015-08-11 11:36:26,227 INFO [] [AbstractCommandLauncher] [main] Option: name=alter-case, value={} 2015-08-11 11:36:26,793 INFO [] [JdbcDatabasePlatformFactory] [main] Detected database 'Firebird 2.56LI-V2.5.4.26856 Firebird 2.5/tcp (host4.webdts.eu)/P10', version '2', protocol 'firebirdsql' 2015-08-11 11:36:26,833 INFO [] [JdbcDatabasePlatformFactory] [main] The IDatabasePlatform being used is org.jumpmind.db.platform.firebird.FirebirdDatabasePlatform 2015-08-11 11:36:26,923 INFO [] [DefaultDatabaseWriter] [main] About to create table using the following definition:
2015-08-11 11:36:27,020 INFO [] [DefaultDatabaseWriter] [main] About to create table using the following definition:
2015-08-11 11:36:27,123 INFO [] [DefaultDatabaseWriter] [main] About to create table using the following definition:
2015-08-11 11:36:27,284 INFO [] [DefaultDatabaseWriter] [main] About to create table using the following definition:
2015-08-11 11:37:10,108 INFO [] [AbstractCommandLauncher] [main] Option: name=engine, value={corp-000} 2015-08-11 11:37:10,762 INFO [corp-000] [JdbcDatabasePlatformFactory] [main] Detected database 'Firebird 2.56LI-V2.5.4.26856 Firebird 2.5/tcp (host4.webdts.eu)/P10', version '2', protocol 'firebirdsql' 2015-08-11 11:37:10,778 INFO [corp-000] [JdbcDatabasePlatformFactory] [main] The IDatabasePlatform being used is org.jumpmind.db.platform.firebird.FirebirdDatabasePlatform 2015-08-11 11:37:10,839 INFO [corp-000] [Firebird21SymmetricDialect] [main] The DbDialect being used is org.jumpmind.symmetric.db.firebird.Firebird21SymmetricDialect 2015-08-11 11:37:10,865 INFO [corp-000] [StagingManager] [main] The staging directory was initialized at the following location: /web/symmetric-server-3.7.19/tmp/corp-000 2015-08-11 11:37:10,952 INFO [corp-000] [ClusterService] [main] This node picked a server id of host4.webdts.eu 2015-08-11 11:37:12,055 INFO [corp-000] [ClientExtensionService] [main] Found 8 extension points from spring that will be registered 2015-08-11 11:37:12,056 INFO [corp-000] [AbstractSymmetricEngine] [main] Initializing SymmetricDS database 2015-08-11 11:37:12,056 INFO [corp-000] [Firebird21SymmetricDialect] [main] Checking if SymmetricDS tables need created or altered 2015-08-11 11:37:12,559 INFO [corp-000] [Firebird21SymmetricDialect] [main] There are SymmetricDS tables that needed altered 2015-08-11 11:37:12,635 INFO [corp-000] [Firebird21SymmetricDialect] [main] 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), "CREATE_TIME" TIMESTAMP, "LAST_UPDATE_BY" VARCHAR(50), "LAST_UPDATE_TIME" TIMESTAMP, PRIMARY KEY ("CHANNEL_ID") ) 2015-08-11 11:37:12,712 INFO [corp-000] [Firebird21SymmetricDialect] [main] 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") ) 2015-08-11 11:37:12,793 INFO [corp-000] [Firebird21SymmetricDialect] [main] 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), "CREATE_TIME" TIMESTAMP, PRIMARY KEY ("DATA_ID") ) 2015-08-11 11:37:12,884 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: CREATE INDEX "SYM_IDX_D_CHANNEL_ID" ON "SYM_DATA" ("DATA_ID", "CHANNEL_ID") 2015-08-11 11:37:12,892 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: CREATE GENERATOR "GEN_SYM_DATA_DATA_ID" 2015-08-11 11:37:12,924 INFO [corp-000] [Firebird21SymmetricDialect] [main] 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 2015-08-11 11:37:12,967 INFO [corp-000] [Firebird21SymmetricDialect] [main] 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") ) 2015-08-11 11:37:12,976 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: CREATE INDEX "SYM_IDX_DE_BATCHID" ON "SYM_DATA_EVENT" ("BATCH_ID") 2015-08-11 11:37:12,999 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: CREATE TABLE "SYM_DATA_GAP"( "START_ID" BIGINT NOT NULL, "END_ID" BIGINT NOT NULL, "STATUS" CHAR(2), "CREATE_TIME" TIMESTAMP NOT NULL, "LAST_UPDATE_HOSTNAME" VARCHAR(255), "LAST_UPDATE_TIME" TIMESTAMP NOT NULL, PRIMARY KEY ("START_ID", "END_ID") ) 2015-08-11 11:37:13,008 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: CREATE INDEX "SYM_IDX_DG_STATUS" ON "SYM_DATA_GAP" ("STATUS") 2015-08-11 11:37:13,140 INFO [corp-000] [Firebird21SymmetricDialect] [main] 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") ) 2015-08-11 11:37:13,278 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: CREATE TABLE "SYM_EXTRACT_REQUEST"( "REQUEST_ID" BIGINT NOT NULL, "NODE_ID" VARCHAR(50) NOT NULL, "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, "LAST_UPDATE_TIME" TIMESTAMP, "CREATE_TIME" TIMESTAMP, PRIMARY KEY ("REQUEST_ID") ) 2015-08-11 11:37:13,383 INFO [corp-000] [Firebird21SymmetricDialect] [main] 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") ) 2015-08-11 11:37:13,488 INFO [corp-000] [Firebird21SymmetricDialect] [main] 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") ) 2015-08-11 11:37:13,538 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: CREATE INDEX "SYM_IDX_F_SNPSHT_CHID" ON "SYM_FILE_SNAPSHOT" ("RELOAD_CHANNEL_ID") 2015-08-11 11:37:13,646 INFO [corp-000] [Firebird21SymmetricDialect] [main] 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, PRIMARY KEY ("TRIGGER_ID") ) 2015-08-11 11:37:13,730 INFO [corp-000] [Firebird21SymmetricDialect] [main] 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, PRIMARY KEY ("TRIGGER_ID", "ROUTER_ID") ) 2015-08-11 11:37:13,761 INFO [corp-000] [Firebird21SymmetricDialect] [main] 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") ) 2015-08-11 11:37:13,857 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: CREATE TABLE "SYM_GROUPLET_LINK"( "GROUPLET_ID" VARCHAR(50) NOT NULL, "EXTERNAL_ID" VARCHAR(50) NOT NULL, "CREATE_TIME" TIMESTAMP NOT NULL, "LAST_UPDATE_BY" VARCHAR(50), "LAST_UPDATE_TIME" TIMESTAMP NOT NULL, PRIMARY KEY ("GROUPLET_ID", "EXTERNAL_ID") ) 2015-08-11 11:37:13,946 INFO [corp-000] [Firebird21SymmetricDialect] [main] 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, "NETWORK_MILLIS" BIGINT DEFAULT 0 NOT NULL, "FILTER_MILLIS" BIGINT DEFAULT 0 NOT NULL, "DATABASE_MILLIS" BIGINT DEFAULT 0 NOT NULL, "FAILED_ROW_NUMBER" BIGINT DEFAULT 0 NOT NULL, "FAILED_LINE_NUMBER" BIGINT DEFAULT 0 NOT NULL, "BYTE_COUNT" BIGINT DEFAULT 0 NOT NULL, "STATEMENT_COUNT" BIGINT DEFAULT 0 NOT NULL, "FALLBACK_INSERT_COUNT" BIGINT DEFAULT 0 NOT NULL, "FALLBACK_UPDATE_COUNT" BIGINT DEFAULT 0 NOT NULL, "IGNORE_COUNT" BIGINT DEFAULT 0 NOT NULL, "MISSING_DELETE_COUNT" BIGINT DEFAULT 0 NOT NULL, "SKIP_COUNT" BIGINT DEFAULT 0 NOT NULL, "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, PRIMARY KEY ("BATCH_ID", "NODE_ID") ) 2015-08-11 11:37:14,029 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: CREATE INDEX "SYM_IDX_IB_TIME_STATUS" ON "SYM_INCOMING_BATCH" ("CREATE_TIME", "STATUS") 2015-08-11 11:37:14,067 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: CREATE INDEX "SYM_IDX_IB_IN_ERROR" ON "SYM_INCOMING_BATCH" ("ERROR_FLAG") 2015-08-11 11:37:14,174 INFO [corp-000] [Firebird21SymmetricDialect] [main] 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") ) 2015-08-11 11:37:14,316 INFO [corp-000] [Firebird21SymmetricDialect] [main] 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") ) 2015-08-11 11:37:14,404 INFO [corp-000] [Firebird21SymmetricDialect] [main] 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") ) 2015-08-11 11:37:14,566 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: CREATE TABLE "SYM_NODE"( "NODE_ID" VARCHAR(50) NOT NULL, "NODE_GROUP_ID" VARCHAR(50) NOT NULL, "EXTERNAL_ID" VARCHAR(50) NOT NULL, "SYNC_ENABLED" SMALLINT DEFAULT 0, "SYNC_URL" VARCHAR(255), "SCHEMA_VERSION" VARCHAR(50), "SYMMETRIC_VERSION" VARCHAR(50), "DATABASE_TYPE" VARCHAR(50), "DATABASE_VERSION" VARCHAR(50), "HEARTBEAT_TIME" TIMESTAMP, "TIMEZONE_OFFSET" VARCHAR(6), "BATCH_TO_SEND_COUNT" INTEGER DEFAULT 0, "BATCH_IN_ERROR_COUNT" INTEGER DEFAULT 0, "CREATED_AT_NODE_ID" VARCHAR(50), "DEPLOYMENT_TYPE" VARCHAR(50), PRIMARY KEY ("NODE_ID") ) 2015-08-11 11:37:14,694 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: CREATE TABLE "SYM_NODE_COMMUNICATION"( "NODE_ID" VARCHAR(50) 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, "TOTAL_SUCCESS_COUNT" BIGINT DEFAULT 0, "TOTAL_FAIL_COUNT" BIGINT DEFAULT 0, "TOTAL_SUCCESS_MILLIS" BIGINT DEFAULT 0, "TOTAL_FAIL_MILLIS" BIGINT DEFAULT 0, PRIMARY KEY ("NODE_ID", "COMMUNICATION_TYPE") ) 2015-08-11 11:37:14,749 INFO [corp-000] [Firebird21SymmetricDialect] [main] 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") ) 2015-08-11 11:37:14,838 INFO [corp-000] [Firebird21SymmetricDialect] [main] 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") ) 2015-08-11 11:37:14,984 INFO [corp-000] [Firebird21SymmetricDialect] [main] 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") ) 2015-08-11 11:37:15,047 INFO [corp-000] [Firebird21SymmetricDialect] [main] 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, "CREATE_TIME" TIMESTAMP, "LAST_UPDATE_BY" VARCHAR(50), "LAST_UPDATE_TIME" TIMESTAMP, PRIMARY KEY ("SOURCE_NODE_GROUP_ID", "TARGET_NODE_GROUP_ID") ) 2015-08-11 11:37:15,161 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: CREATE TABLE "SYM_NODE_HOST"( "NODE_ID" VARCHAR(50) NOT NULL, "HOST_NAME" VARCHAR(60) NOT NULL, "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") ) 2015-08-11 11:37:15,276 INFO [corp-000] [Firebird21SymmetricDialect] [main] 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, PRIMARY KEY ("NODE_ID", "HOST_NAME", "CHANNEL_ID", "START_TIME", "END_TIME") ) 2015-08-11 11:37:15,347 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: CREATE INDEX "SYM_IDX_ND_HST_CHNL_STS" ON "SYM_NODE_HOST_CHANNEL_STATS" ("NODE_ID", "START_TIME", "END_TIME") 2015-08-11 11:37:15,472 INFO [corp-000] [Firebird21SymmetricDialect] [main] 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, PRIMARY KEY ("NODE_ID", "HOST_NAME", "JOB_NAME", "START_TIME", "END_TIME") ) 2015-08-11 11:37:15,509 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: CREATE INDEX "SYM_IDX_ND_HST_JOB" ON "SYM_NODE_HOST_JOB_STATS" ("NODE_ID", "START_TIME", "END_TIME") 2015-08-11 11:37:15,666 INFO [corp-000] [Firebird21SymmetricDialect] [main] 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") ) 2015-08-11 11:37:15,754 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: CREATE INDEX "SYM_IDX_ND_HST_STS" ON "SYM_NODE_HOST_STATS" ("NODE_ID", "START_TIME", "END_TIME") 2015-08-11 11:37:15,870 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: CREATE TABLE "SYM_NODE_IDENTITY"( "NODE_ID" VARCHAR(50) NOT NULL, PRIMARY KEY ("NODE_ID") ) 2015-08-11 11:37:15,923 INFO [corp-000] [Firebird21SymmetricDialect] [main] 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") ) 2015-08-11 11:37:16,075 INFO [corp-000] [Firebird21SymmetricDialect] [main] 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), "LOAD_ID" BIGINT, "EXTRACT_JOB_FLAG" SMALLINT DEFAULT 0, "LOAD_FLAG" SMALLINT DEFAULT 0, "ERROR_FLAG" SMALLINT DEFAULT 0, "COMMON_FLAG" SMALLINT DEFAULT 0, "IGNORE_COUNT" BIGINT DEFAULT 0 NOT NULL, "BYTE_COUNT" BIGINT DEFAULT 0 NOT NULL, "EXTRACT_COUNT" BIGINT DEFAULT 0 NOT NULL, "SENT_COUNT" BIGINT DEFAULT 0 NOT NULL, "LOAD_COUNT" BIGINT DEFAULT 0 NOT NULL, "DATA_EVENT_COUNT" BIGINT DEFAULT 0 NOT NULL, "RELOAD_EVENT_COUNT" BIGINT DEFAULT 0 NOT NULL, "INSERT_EVENT_COUNT" BIGINT DEFAULT 0 NOT NULL, "UPDATE_EVENT_COUNT" BIGINT DEFAULT 0 NOT NULL, "DELETE_EVENT_COUNT" BIGINT DEFAULT 0 NOT NULL, "OTHER_EVENT_COUNT" BIGINT DEFAULT 0 NOT NULL, "ROUTER_MILLIS" BIGINT DEFAULT 0 NOT NULL, "NETWORK_MILLIS" BIGINT DEFAULT 0 NOT NULL, "FILTER_MILLIS" BIGINT DEFAULT 0 NOT NULL, "LOAD_MILLIS" BIGINT DEFAULT 0 NOT NULL, "EXTRACT_MILLIS" BIGINT DEFAULT 0 NOT NULL, "TRANSFORM_EXTRACT_MILLIS" BIGINT DEFAULT 0 NOT NULL, "TRANSFORM_LOAD_MILLIS" BIGINT DEFAULT 0 NOT NULL, "TOTAL_EXTRACT_MILLIS" BIGINT DEFAULT 0 NOT NULL, "TOTAL_LOAD_MILLIS" BIGINT DEFAULT 0 NOT NULL, "SQL_STATE" VARCHAR(10), "SQL_CODE" INTEGER DEFAULT 0 NOT NULL, "SQL_MESSAGE" BLOB SUB_TYPE TEXT, "FAILED_DATA_ID" BIGINT DEFAULT 0 NOT NULL, "FAILED_LINE_NUMBER" BIGINT DEFAULT 0 NOT NULL, "LAST_UPDATE_HOSTNAME" VARCHAR(255), "LAST_UPDATE_TIME" TIMESTAMP, "CREATE_TIME" TIMESTAMP, "CREATE_BY" VARCHAR(255), PRIMARY KEY ("BATCH_ID", "NODE_ID") ) 2015-08-11 11:37:16,142 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: CREATE INDEX "SYM_IDX_OB_NODE_STATUS" ON "SYM_OUTGOING_BATCH" ("NODE_ID", "STATUS") 2015-08-11 11:37:16,167 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: CREATE INDEX "SYM_IDX_OB_STATUS" ON "SYM_OUTGOING_BATCH" ("STATUS") 2015-08-11 11:37:16,212 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: CREATE INDEX "SYM_IDX_OB_IN_ERROR" ON "SYM_OUTGOING_BATCH" ("ERROR_FLAG") 2015-08-11 11:37:16,268 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: CREATE TABLE "SYM_PARAMETER"( "EXTERNAL_ID" VARCHAR(50) 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") ) 2015-08-11 11:37:16,374 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: CREATE TABLE "SYM_REGISTRATION_REDIRECT"( "REGISTRANT_EXTERNAL_ID" VARCHAR(50) NOT NULL, "REGISTRATION_NODE_ID" VARCHAR(50) NOT NULL, PRIMARY KEY ("REGISTRANT_EXTERNAL_ID") ) 2015-08-11 11:37:16,590 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: CREATE TABLE "SYM_REGISTRATION_REQUEST"( "NODE_GROUP_ID" VARCHAR(50) NOT NULL, "EXTERNAL_ID" VARCHAR(50) 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") ) 2015-08-11 11:37:16,625 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: CREATE INDEX "SYM_IDX_REG_REQ_1" ON "SYM_REGISTRATION_REQUEST" ("NODE_GROUP_ID", "EXTERNAL_ID", "STATUS", "HOST_NAME", "IP_ADDRESS") 2015-08-11 11:37:16,650 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: CREATE INDEX "SYM_IDX_REG_REQ_2" ON "SYM_REGISTRATION_REQUEST" ("STATUS") 2015-08-11 11:37:16,737 INFO [corp-000] [Firebird21SymmetricDialect] [main] 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, PRIMARY KEY ("ROUTER_ID") ) 2015-08-11 11:37:16,887 INFO [corp-000] [Firebird21SymmetricDialect] [main] 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" SMALLINT DEFAULT 0, "CREATE_TIME" TIMESTAMP, "LAST_UPDATE_BY" VARCHAR(50), "LAST_UPDATE_TIME" TIMESTAMP NOT NULL, PRIMARY KEY ("SEQUENCE_NAME") ) 2015-08-11 11:37:16,955 INFO [corp-000] [Firebird21SymmetricDialect] [main] 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, "RELOAD_SELECT" BLOB SUB_TYPE TEXT, "RELOAD_DELETE_STMT" BLOB SUB_TYPE TEXT, "RELOAD_ENABLED" SMALLINT DEFAULT 0, "RELOAD_TIME" TIMESTAMP, "CREATE_TIME" TIMESTAMP, "LAST_UPDATE_BY" VARCHAR(50), "LAST_UPDATE_TIME" TIMESTAMP NOT NULL, PRIMARY KEY ("TARGET_NODE_ID", "SOURCE_NODE_ID", "TRIGGER_ID", "ROUTER_ID") ) 2015-08-11 11:37:17,048 INFO [corp-000] [Firebird21SymmetricDialect] [main] 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, "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, PRIMARY KEY ("TRANSFORM_ID", "SOURCE_NODE_GROUP_ID", "TARGET_NODE_GROUP_ID") ) 2015-08-11 11:37:17,157 INFO [corp-000] [Firebird21SymmetricDialect] [main] 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, PRIMARY KEY ("TRANSFORM_ID", "INCLUDE_ON", "TARGET_COLUMN_NAME") ) 2015-08-11 11:37:17,250 INFO [corp-000] [Firebird21SymmetricDialect] [main] 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_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, "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 0 NOT NULL, "CREATE_TIME" TIMESTAMP NOT NULL, "LAST_UPDATE_BY" VARCHAR(50), "LAST_UPDATE_TIME" TIMESTAMP NOT NULL, PRIMARY KEY ("TRIGGER_ID") ) 2015-08-11 11:37:17,311 INFO [corp-000] [Firebird21SymmetricDialect] [main] 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") ) 2015-08-11 11:37:17,680 INFO [corp-000] [Firebird21SymmetricDialect] [main] 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, "INITIAL_LOAD_BATCH_COUNT" INTEGER DEFAULT 1, "PING_BACK_ENABLED" SMALLINT DEFAULT 0 NOT NULL, "CREATE_TIME" TIMESTAMP NOT NULL, "LAST_UPDATE_BY" VARCHAR(50), "LAST_UPDATE_TIME" TIMESTAMP NOT NULL, PRIMARY KEY ("TRIGGER_ID", "ROUTER_ID") ) 2015-08-11 11:37:17,721 INFO [corp-000] [Firebird21SymmetricDialect] [main] 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") ) 2015-08-11 11:37:17,846 INFO [corp-000] [Firebird21SymmetricDialect] [main] 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") 2015-08-11 11:37:17,887 INFO [corp-000] [Firebird21SymmetricDialect] [main] 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") 2015-08-11 11:37:17,903 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: ALTER TABLE "SYM_FILE_TRIGGER_ROUTER" ADD CONSTRAINT "SYM_FK_FTR_2_RTR" FOREIGN KEY ("ROUTER_ID") REFERENCES "SYM_ROUTER" ("ROUTER_ID") 2015-08-11 11:37:17,920 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: ALTER TABLE "SYM_GROUPLET_LINK" ADD CONSTRAINT "SYM_FK_GPLTLNK_2_GPLT" FOREIGN KEY ("GROUPLET_ID") REFERENCES "SYM_GROUPLET" ("GROUPLET_ID") 2015-08-11 11:37:17,935 INFO [corp-000] [Firebird21SymmetricDialect] [main] 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") 2015-08-11 11:37:18,009 INFO [corp-000] [Firebird21SymmetricDialect] [main] 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") 2015-08-11 11:37:18,040 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: ALTER TABLE "SYM_NODE_IDENTITY" ADD CONSTRAINT "SYM_FK_IDENT_2_NODE" FOREIGN KEY ("NODE_ID") REFERENCES "SYM_NODE" ("NODE_ID") 2015-08-11 11:37:18,074 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: ALTER TABLE "SYM_NODE_SECURITY" ADD CONSTRAINT "SYM_FK_SEC_2_NODE" FOREIGN KEY ("NODE_ID") REFERENCES "SYM_NODE" ("NODE_ID") 2015-08-11 11:37:18,108 INFO [corp-000] [Firebird21SymmetricDialect] [main] 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") 2015-08-11 11:37:18,123 INFO [corp-000] [Firebird21SymmetricDialect] [main] 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") 2015-08-11 11:37:18,218 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: ALTER TABLE "SYM_TRIGGER" ADD CONSTRAINT "SYM_FK_TRG_2_CHNL" FOREIGN KEY ("CHANNEL_ID") REFERENCES "SYM_CHANNEL" ("CHANNEL_ID") 2015-08-11 11:37:18,288 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: ALTER TABLE "SYM_TRIGGER" ADD CONSTRAINT "SYM_FK_TRG_2_RLD_CHNL" FOREIGN KEY ("RELOAD_CHANNEL_ID") REFERENCES "SYM_CHANNEL" ("CHANNEL_ID") 2015-08-11 11:37:18,317 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: ALTER TABLE "SYM_TRIGGER_ROUTER" ADD CONSTRAINT "SYM_FK_TR_2_TRG" FOREIGN KEY ("TRIGGER_ID") REFERENCES "SYM_TRIGGER" ("TRIGGER_ID") 2015-08-11 11:37:18,339 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: ALTER TABLE "SYM_TRIGGER_ROUTER" ADD CONSTRAINT "SYM_FK_TR_2_RTR" FOREIGN KEY ("ROUTER_ID") REFERENCES "SYM_ROUTER" ("ROUTER_ID") 2015-08-11 11:37:18,379 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: ALTER TABLE "SYM_TRIGGER_ROUTER_GROUPLET" ADD CONSTRAINT "SYM_FK_TRGPLT_2_GPLT" FOREIGN KEY ("GROUPLET_ID") REFERENCES "SYM_GROUPLET" ("GROUPLET_ID") 2015-08-11 11:37:18,396 INFO [corp-000] [Firebird21SymmetricDialect] [main] 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") 2015-08-11 11:37:18,396 INFO [corp-000] [Firebird21SymmetricDialect] [main] Done with auto update of SymmetricDS tables 2015-08-11 11:37:18,672 INFO [corp-000] [Firebird21SymmetricDialect] [main] Installing SymmetricDS database object: declare external function sym_hex blob returns cstring(32660) free_it entry_point 'sym_hex' module_name 'sym_udf' 2015-08-11 12:00:04,867 INFO [] [AbstractCommandLauncher] [main] Option: name=engine, value={corp-000} 2015-08-11 12:00:05,465 INFO [corp-000] [JdbcDatabasePlatformFactory] [main] Detected database 'Firebird 2.56LI-V2.5.4.26856 Firebird 2.5/tcp (host4.webdts.eu)/P10', version '2', protocol 'firebirdsql' 2015-08-11 12:00:05,481 INFO [corp-000] [JdbcDatabasePlatformFactory] [main] The IDatabasePlatform being used is org.jumpmind.db.platform.firebird.FirebirdDatabasePlatform 2015-08-11 12:00:05,955 INFO [corp-000] [Firebird21SymmetricDialect] [main] The DbDialect being used is org.jumpmind.symmetric.db.firebird.Firebird21SymmetricDialect 2015-08-11 12:00:06,212 INFO [corp-000] [ExtensionService] [main] Found 0 extension points from the database that will be registered 2015-08-11 12:00:06,224 INFO [corp-000] [StagingManager] [main] The staging directory was initialized at the following location: /web/symmetric-server-3.7.19/tmp/corp-000 2015-08-11 12:00:06,363 INFO [corp-000] [ClusterService] [main] This node picked a server id of host4.webdts.eu 2015-08-11 12:00:07,465 INFO [corp-000] [ExtensionService] [main] Found 0 extension points from the database that will be registered 2015-08-11 12:00:07,465 INFO [corp-000] [ClientExtensionService] [main] Found 8 extension points from spring that will be registered 2015-08-11 12:00:07,467 INFO [corp-000] [AbstractSymmetricEngine] [main] Initializing SymmetricDS database 2015-08-11 12:00:07,467 INFO [corp-000] [Firebird21SymmetricDialect] [main] Checking if SymmetricDS tables need created or altered 2015-08-11 12:00:10,232 INFO [corp-000] [Firebird21SymmetricDialect] [main] Installing SymmetricDS database object: declare external function sym_hex blob returns cstring(32660) free_it entry_point 'sym_hex' module_name 'sym_udf'