2018-08-16 10:58:30,044 INFO [startup] [AbstractCommandLauncher] [main] Option: name=max-idle-time, value={90000} 2018-08-16 10:58:30,045 INFO [startup] [AbstractCommandLauncher] [main] Option: name=no-log-console, value={} 2018-08-16 10:58:30,156 INFO [startup] [SymmetricUtils] [main] _____ __ _ ____ _____ / ___/ __ _____ __ ___ __ ___ _/ /_ ____(_)___ / __ | / ___/ \__ \ / / / / _ `_ \/ _ `_ \/ _ \/_ __// __/ / __/ / / / / \__ \ ___/ // /_/ / // // / // // / __// / / / / / /_ / /_/ / ___/ / /____/ \__ /_//_//_/_//_//_/\___/ \_/ /_/ /_/\__/ /_____/ /____/ /____/ +-----------------------------------------------------------------+ | Copyright (C) 2007-2018 JumpMind, Inc. | | | | Licensed under one or more agreements from JumpMind, Inc. | | See doc/license.html | +-----------------------------------------------------------------+ 2018-08-16 10:58:30,228 INFO [startup] [SymmetricWebServer] [main] About to start SymmetricDS web server on host:port 0.0.0.0:31010 2018-08-16 10:58:33,240 INFO [startup] [SymmetricWebServer] [main] Joining the web server main thread 2018-08-16 10:58:57,260 INFO [startup] [SymmetricUtils] [main] _____ __ _ ____ _____ / ___/ __ _____ __ ___ __ ___ _/ /_ ____(_)___ / __ | / ___/ \__ \ / / / / _ `_ \/ _ `_ \/ _ \/_ __// __/ / __/ / / / / \__ \ ___/ // /_/ / // // / // // / __// / / / / / /_ / /_/ / ___/ / /____/ \__ /_//_//_/_//_//_/\___/ \_/ /_/ /_/\__/ /_____/ /____/ /____/ +-----------------------------------------------------------------+ | Copyright (C) 2007-2018 JumpMind, Inc. | | | | Licensed under one or more agreements from JumpMind, Inc. | | See doc/license.html | +-----------------------------------------------------------------+ 2018-08-16 10:58:57,315 INFO [startup] [SymmetricWebServer] [main] About to start SymmetricDS web server on host:port 0.0.0.0:31010 2018-08-16 10:59:00,076 INFO [startup] [SymmetricWebServer] [main] Joining the web server main thread 2018-08-16 10:59:24,618 INFO [startup] [JdbcDatabasePlatformFactory] [qtp90205195-14] Detected database 'H2', version '1', protocol 'h2' 2018-08-16 10:59:24,639 INFO [startup] [JdbcDatabasePlatformFactory] [qtp90205195-14] The IDatabasePlatform being used is org.jumpmind.db.platform.h2.H2DatabasePlatform 2018-08-16 10:59:24,672 INFO [startup] [H2SymmetricDialect] [qtp90205195-14] The DbDialect being used is org.jumpmind.symmetric.db.h2.H2SymmetricDialect 2018-08-16 10:59:25,973 INFO [SymmetricDS] [AbstractSymmetricEngine] [qtp90205195-13] Initializing connection to database 2018-08-16 10:59:25,977 INFO [SymmetricDS] [JdbcDatabasePlatformFactory] [qtp90205195-13] Detected database 'H2', version '1', protocol 'h2' 2018-08-16 10:59:25,978 INFO [SymmetricDS] [JdbcDatabasePlatformFactory] [qtp90205195-13] The IDatabasePlatform being used is org.jumpmind.db.platform.h2.H2DatabasePlatform 2018-08-16 10:59:25,993 INFO [SymmetricDS] [H2SymmetricDialect] [qtp90205195-13] The DbDialect being used is org.jumpmind.symmetric.db.h2.H2SymmetricDialect 2018-08-16 10:59:26,007 INFO [SymmetricDS] [StagingManager] [qtp90205195-13] The staging directory was initialized at the following location: /Users/mhanes/tmp/training-3.9/pro-store-001/tmp/SymmetricDS 2018-08-16 10:59:26,010 INFO [SymmetricDS] [EnhancedStagingManager] [qtp90205195-13] Compressed staging is enabled 2018-08-16 10:59:26,518 INFO [SymmetricDS] [ClientExtensionService] [qtp90205195-13] Found 12 extension points from spring that will be registered 2018-08-16 10:59:44,867 INFO [store-001] [AbstractSymmetricEngine] [background-refresher-1] Initializing connection to database 2018-08-16 10:59:44,872 INFO [store-001] [JdbcDatabasePlatformFactory] [background-refresher-1] Detected database 'H2', version '1', protocol 'h2' 2018-08-16 10:59:44,872 INFO [store-001] [JdbcDatabasePlatformFactory] [background-refresher-1] The IDatabasePlatform being used is org.jumpmind.db.platform.h2.H2DatabasePlatform 2018-08-16 10:59:44,884 INFO [store-001] [H2SymmetricDialect] [background-refresher-1] The DbDialect being used is org.jumpmind.symmetric.db.h2.H2SymmetricDialect 2018-08-16 10:59:44,894 INFO [store-001] [StagingManager] [background-refresher-1] The staging directory was initialized at the following location: /Users/mhanes/tmp/training-3.9/pro-store-001/tmp/store-001 2018-08-16 10:59:44,900 INFO [store-001] [EnhancedStagingManager] [background-refresher-1] Compressed staging is enabled 2018-08-16 10:59:45,340 INFO [store-001] [ClientExtensionService] [background-refresher-1] Found 14 extension points from spring that will be registered 2018-08-16 10:59:45,369 INFO [store-001] [AbstractSymmetricEngine] [background-refresher-1] Initializing SymmetricDS database 2018-08-16 10:59:45,369 INFO [store-001] [H2SymmetricDialect] [background-refresher-1] Checking if SymmetricDS tables need created or altered 2018-08-16 10:59:45,657 INFO [store-001] [H2SymmetricDialect] [background-refresher-1] There are SymmetricDS tables that needed altered 2018-08-16 10:59:45,666 INFO [store-001] [H2SymmetricDialect] [background-refresher-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" TINYINT DEFAULT 1 NOT NULL, "USE_OLD_DATA_TO_ROUTE" TINYINT DEFAULT 1 NOT NULL, "USE_ROW_DATA_TO_ROUTE" TINYINT DEFAULT 1 NOT NULL, "USE_PK_DATA_TO_ROUTE" TINYINT DEFAULT 1 NOT NULL, "RELOAD_FLAG" TINYINT DEFAULT 0 NOT NULL, "FILE_SYNC_FLAG" TINYINT DEFAULT 0 NOT NULL, "CONTAINS_BIG_LOB" TINYINT DEFAULT 0 NOT NULL, "BATCH_ALGORITHM" VARCHAR(50) DEFAULT 'default' NOT NULL, "DATA_LOADER_TYPE" VARCHAR(50) DEFAULT 'default' NOT NULL, "DESCRIPTION" VARCHAR(255) NULL, "QUEUE" VARCHAR(25) DEFAULT 'default' NOT NULL, "MAX_NETWORK_KBPS" DECIMAL(10,3) DEFAULT 0.000 NOT NULL, "DATA_EVENT_ACTION" CHAR(1) NULL, "CREATE_TIME" TIMESTAMP, "LAST_UPDATE_BY" VARCHAR(50) NULL, "LAST_UPDATE_TIME" TIMESTAMP, PRIMARY KEY ("CHANNEL_ID") ) 2018-08-16 10:59:45,670 INFO [store-001] [H2SymmetricDialect] [background-refresher-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) NULL, "TARGET_CATALOG_NAME" VARCHAR(255) NULL, "TARGET_SCHEMA_NAME" VARCHAR(255) NULL, "TARGET_TABLE_NAME" VARCHAR(255) NULL, "DETECT_TYPE" VARCHAR(128) NOT NULL, "DETECT_EXPRESSION" VARCHAR(2147483647) NULL, "RESOLVE_TYPE" VARCHAR(128) NOT NULL, "PING_BACK" VARCHAR(128) NOT NULL, "RESOLVE_CHANGES_ONLY" TINYINT DEFAULT 0, "RESOLVE_ROW_ONLY" TINYINT DEFAULT 0, "CREATE_TIME" TIMESTAMP NOT NULL, "LAST_UPDATE_BY" VARCHAR(50) NULL, "LAST_UPDATE_TIME" TIMESTAMP NOT NULL, PRIMARY KEY ("CONFLICT_ID") ) 2018-08-16 10:59:45,671 INFO [store-001] [H2SymmetricDialect] [background-refresher-1] DDL applied: CREATE TABLE "SYM_CONTEXT"( "NAME" VARCHAR(80) NOT NULL, "CONTEXT_VALUE" VARCHAR(2147483647) NULL, "CREATE_TIME" TIMESTAMP, "LAST_UPDATE_TIME" TIMESTAMP, PRIMARY KEY ("NAME") ) 2018-08-16 10:59:45,675 INFO [store-001] [H2SymmetricDialect] [background-refresher-1] DDL applied: CREATE TABLE "SYM_DATA"( "DATA_ID" BIGINT NOT NULL AUTO_INCREMENT, "TABLE_NAME" VARCHAR(255) NOT NULL, "EVENT_TYPE" CHAR(1) NOT NULL, "ROW_DATA" VARCHAR(2147483647) NULL, "PK_DATA" VARCHAR(2147483647) NULL, "OLD_DATA" VARCHAR(2147483647) NULL, "TRIGGER_HIST_ID" INTEGER NOT NULL, "CHANNEL_ID" VARCHAR(128) NULL, "TRANSACTION_ID" VARCHAR(255) NULL, "SOURCE_NODE_ID" VARCHAR(50) NULL, "EXTERNAL_DATA" VARCHAR(50) NULL, "NODE_LIST" VARCHAR(255) NULL, "CREATE_TIME" TIMESTAMP, PRIMARY KEY ("DATA_ID") ) 2018-08-16 10:59:45,676 INFO [store-001] [H2SymmetricDialect] [background-refresher-1] DDL applied: CREATE INDEX "SYM_IDX_D_CHANNEL_ID" ON "SYM_DATA" ("DATA_ID", "CHANNEL_ID") 2018-08-16 10:59:45,678 INFO [store-001] [H2SymmetricDialect] [background-refresher-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") ) 2018-08-16 10:59:45,679 INFO [store-001] [H2SymmetricDialect] [background-refresher-1] DDL applied: CREATE INDEX "SYM_IDX_DE_BATCHID" ON "SYM_DATA_EVENT" ("BATCH_ID") 2018-08-16 10:59:45,681 INFO [store-001] [H2SymmetricDialect] [background-refresher-1] DDL applied: CREATE TABLE "SYM_DATA_GAP"( "START_ID" BIGINT NOT NULL, "END_ID" BIGINT NOT NULL, "STATUS" CHAR(2) NULL, "CREATE_TIME" TIMESTAMP NOT NULL, "LAST_UPDATE_HOSTNAME" VARCHAR(255) NULL, "LAST_UPDATE_TIME" TIMESTAMP NOT NULL, PRIMARY KEY ("START_ID", "END_ID") ) 2018-08-16 10:59:45,682 INFO [store-001] [H2SymmetricDialect] [background-refresher-1] DDL applied: CREATE INDEX "SYM_IDX_DG_STATUS" ON "SYM_DATA_GAP" ("STATUS") 2018-08-16 10:59:45,685 INFO [store-001] [H2SymmetricDialect] [background-refresher-1] DDL applied: CREATE TABLE "SYM_EXTENSION"( "EXTENSION_ID" VARCHAR(50) NOT NULL, "EXTENSION_TYPE" VARCHAR(10) NOT NULL, "INTERFACE_NAME" VARCHAR(255) NULL, "NODE_GROUP_ID" VARCHAR(50) NOT NULL, "ENABLED" TINYINT DEFAULT 1 NOT NULL, "EXTENSION_ORDER" INTEGER DEFAULT 1 NOT NULL, "EXTENSION_TEXT" VARCHAR(2147483647) NULL, "CREATE_TIME" TIMESTAMP, "LAST_UPDATE_BY" VARCHAR(50) NULL, "LAST_UPDATE_TIME" TIMESTAMP, PRIMARY KEY ("EXTENSION_ID") ) 2018-08-16 10:59:45,687 INFO [store-001] [H2SymmetricDialect] [background-refresher-1] DDL applied: CREATE TABLE "SYM_EXTRACT_REQUEST"( "REQUEST_ID" BIGINT NOT NULL, "NODE_ID" VARCHAR(50) NOT NULL, "QUEUE" VARCHAR(128) NULL, "STATUS" CHAR(2) NULL, "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") ) 2018-08-16 10:59:45,688 INFO [store-001] [H2SymmetricDialect] [background-refresher-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") ) 2018-08-16 10:59:45,690 INFO [store-001] [H2SymmetricDialect] [background-refresher-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) NULL, "CREATE_TIME" TIMESTAMP NOT NULL, PRIMARY KEY ("TRIGGER_ID", "ROUTER_ID", "RELATIVE_DIR", "FILE_NAME") ) 2018-08-16 10:59:45,690 INFO [store-001] [H2SymmetricDialect] [background-refresher-1] DDL applied: CREATE INDEX "SYM_IDX_F_SNPSHT_CHID" ON "SYM_FILE_SNAPSHOT" ("RELOAD_CHANNEL_ID") 2018-08-16 10:59:45,692 INFO [store-001] [H2SymmetricDialect] [background-refresher-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" TINYINT DEFAULT 1 NOT NULL, "INCLUDES_FILES" VARCHAR(255) NULL, "EXCLUDES_FILES" VARCHAR(255) NULL, "SYNC_ON_CREATE" TINYINT DEFAULT 1 NOT NULL, "SYNC_ON_MODIFIED" TINYINT DEFAULT 1 NOT NULL, "SYNC_ON_DELETE" TINYINT DEFAULT 1 NOT NULL, "SYNC_ON_CTL_FILE" TINYINT DEFAULT 0 NOT NULL, "DELETE_AFTER_SYNC" TINYINT DEFAULT 0 NOT NULL, "BEFORE_COPY_SCRIPT" VARCHAR(2147483647) NULL, "AFTER_COPY_SCRIPT" VARCHAR(2147483647) NULL, "CREATE_TIME" TIMESTAMP NOT NULL, "LAST_UPDATE_BY" VARCHAR(50) NULL, "LAST_UPDATE_TIME" TIMESTAMP NOT NULL, "DESCRIPTION" VARCHAR(2147483647) NULL, PRIMARY KEY ("TRIGGER_ID") ) 2018-08-16 10:59:45,694 INFO [store-001] [H2SymmetricDialect] [background-refresher-1] DDL applied: CREATE TABLE "SYM_FILE_TRIGGER_ROUTER"( "TRIGGER_ID" VARCHAR(128) NOT NULL, "ROUTER_ID" VARCHAR(50) NOT NULL, "ENABLED" TINYINT DEFAULT 1 NOT NULL, "INITIAL_LOAD_ENABLED" TINYINT DEFAULT 1 NOT NULL, "TARGET_BASE_DIR" VARCHAR(255) NULL, "CONFLICT_STRATEGY" VARCHAR(128) DEFAULT 'source_wins' NOT NULL, "CREATE_TIME" TIMESTAMP NOT NULL, "LAST_UPDATE_BY" VARCHAR(50) NULL, "LAST_UPDATE_TIME" TIMESTAMP NOT NULL, "DESCRIPTION" VARCHAR(2147483647) NULL, PRIMARY KEY ("TRIGGER_ID", "ROUTER_ID") ) 2018-08-16 10:59:45,706 INFO [store-001] [H2SymmetricDialect] [background-refresher-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) NULL, "CREATE_TIME" TIMESTAMP NOT NULL, "LAST_UPDATE_BY" VARCHAR(50) NULL, "LAST_UPDATE_TIME" TIMESTAMP NOT NULL, PRIMARY KEY ("GROUPLET_ID") ) 2018-08-16 10:59:45,707 INFO [store-001] [H2SymmetricDialect] [background-refresher-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) NULL, "LAST_UPDATE_TIME" TIMESTAMP NOT NULL, PRIMARY KEY ("GROUPLET_ID", "EXTERNAL_ID") ) 2018-08-16 10:59:45,712 INFO [store-001] [H2SymmetricDialect] [background-refresher-1] DDL applied: CREATE TABLE "SYM_INCOMING_BATCH"( "BATCH_ID" BIGINT NOT NULL, "NODE_ID" VARCHAR(50) NOT NULL, "CHANNEL_ID" VARCHAR(128) NULL, "STATUS" CHAR(2) NULL, "ERROR_FLAG" TINYINT DEFAULT 0, "SQL_STATE" VARCHAR(10) NULL, "SQL_CODE" INTEGER DEFAULT 0 NOT NULL, "SQL_MESSAGE" VARCHAR(2147483647) NULL, "LAST_UPDATE_HOSTNAME" VARCHAR(255) NULL, "LAST_UPDATE_TIME" TIMESTAMP, "CREATE_TIME" TIMESTAMP, "SUMMARY" VARCHAR(255) NULL, "IGNORE_COUNT" INTEGER DEFAULT 0 NOT NULL, "BYTE_COUNT" BIGINT DEFAULT 0 NOT NULL, "LOAD_FLAG" TINYINT 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" TINYINT 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") ) 2018-08-16 10:59:45,714 INFO [store-001] [H2SymmetricDialect] [background-refresher-1] DDL applied: CREATE INDEX "SYM_IDX_IB_TIME_STATUS" ON "SYM_INCOMING_BATCH" ("CREATE_TIME", "STATUS") 2018-08-16 10:59:45,715 INFO [store-001] [H2SymmetricDialect] [background-refresher-1] DDL applied: CREATE INDEX "SYM_IDX_IB_IN_ERROR" ON "SYM_INCOMING_BATCH" ("ERROR_FLAG") 2018-08-16 10:59:45,718 INFO [store-001] [H2SymmetricDialect] [background-refresher-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) NULL, "TARGET_SCHEMA_NAME" VARCHAR(255) NULL, "TARGET_TABLE_NAME" VARCHAR(255) NOT NULL, "EVENT_TYPE" CHAR(1) NOT NULL, "BINARY_ENCODING" VARCHAR(10) DEFAULT 'HEX' NOT NULL, "COLUMN_NAMES" VARCHAR(2147483647) NOT NULL, "PK_COLUMN_NAMES" VARCHAR(2147483647) NOT NULL, "ROW_DATA" VARCHAR(2147483647) NULL, "OLD_DATA" VARCHAR(2147483647) NULL, "CUR_DATA" VARCHAR(2147483647) NULL, "RESOLVE_DATA" VARCHAR(2147483647) NULL, "RESOLVE_IGNORE" TINYINT DEFAULT 0, "CONFLICT_ID" VARCHAR(50) NULL, "CREATE_TIME" TIMESTAMP, "LAST_UPDATE_BY" VARCHAR(50) NULL, "LAST_UPDATE_TIME" TIMESTAMP NOT NULL, PRIMARY KEY ("BATCH_ID", "NODE_ID", "FAILED_ROW_NUMBER") ) 2018-08-16 10:59:45,721 INFO [store-001] [H2SymmetricDialect] [background-refresher-1] DDL applied: CREATE TABLE "SYM_JOB"( "JOB_NAME" VARCHAR(50) NOT NULL, "JOB_TYPE" VARCHAR(10) NOT NULL, "REQUIRES_REGISTRATION" TINYINT DEFAULT 1 NOT NULL, "JOB_EXPRESSION" VARCHAR(2147483647) NULL, "DESCRIPTION" VARCHAR(255) NULL, "DEFAULT_SCHEDULE" VARCHAR(50) NULL, "DEFAULT_AUTO_START" TINYINT DEFAULT 1 NOT NULL, "NODE_GROUP_ID" VARCHAR(50) NOT NULL, "CREATE_BY" VARCHAR(50) NULL, "CREATE_TIME" TIMESTAMP, "LAST_UPDATE_BY" VARCHAR(50) NULL, "LAST_UPDATE_TIME" TIMESTAMP, PRIMARY KEY ("JOB_NAME") ) 2018-08-16 10:59:45,722 INFO [store-001] [H2SymmetricDialect] [background-refresher-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) NULL, "TARGET_SCHEMA_NAME" VARCHAR(255) NULL, "TARGET_TABLE_NAME" VARCHAR(255) NULL, "FILTER_ON_UPDATE" TINYINT DEFAULT 1 NOT NULL, "FILTER_ON_INSERT" TINYINT DEFAULT 1 NOT NULL, "FILTER_ON_DELETE" TINYINT DEFAULT 1 NOT NULL, "BEFORE_WRITE_SCRIPT" VARCHAR(2147483647) NULL, "AFTER_WRITE_SCRIPT" VARCHAR(2147483647) NULL, "BATCH_COMPLETE_SCRIPT" VARCHAR(2147483647) NULL, "BATCH_COMMIT_SCRIPT" VARCHAR(2147483647) NULL, "BATCH_ROLLBACK_SCRIPT" VARCHAR(2147483647) NULL, "HANDLE_ERROR_SCRIPT" VARCHAR(2147483647) NULL, "CREATE_TIME" TIMESTAMP NOT NULL, "LAST_UPDATE_BY" VARCHAR(50) NULL, "LAST_UPDATE_TIME" TIMESTAMP NOT NULL, "LOAD_FILTER_ORDER" INTEGER DEFAULT 1 NOT NULL, "FAIL_ON_ERROR" TINYINT DEFAULT 0 NOT NULL, PRIMARY KEY ("LOAD_FILTER_ID") ) 2018-08-16 10:59:45,724 INFO [store-001] [H2SymmetricDialect] [background-refresher-1] DDL applied: CREATE TABLE "SYM_LOCK"( "LOCK_ACTION" VARCHAR(50) NOT NULL, "LOCK_TYPE" VARCHAR(50) NOT NULL, "LOCKING_SERVER_ID" VARCHAR(255) NULL, "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) NULL, PRIMARY KEY ("LOCK_ACTION") ) 2018-08-16 10:59:45,726 INFO [store-001] [H2SymmetricDialect] [background-refresher-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, "HEARTBEAT_TIME" TIMESTAMP, "TIMEZONE_OFFSET" VARCHAR(6) NULL, "SYNC_ENABLED" TINYINT DEFAULT 0, "SYNC_URL" VARCHAR(255) NULL, "SCHEMA_VERSION" VARCHAR(50) NULL, "SYMMETRIC_VERSION" VARCHAR(50) NULL, "CONFIG_VERSION" VARCHAR(50) NULL, "DATABASE_TYPE" VARCHAR(50) NULL, "DATABASE_VERSION" VARCHAR(50) NULL, "BATCH_TO_SEND_COUNT" INTEGER DEFAULT 0, "BATCH_IN_ERROR_COUNT" INTEGER DEFAULT 0, "CREATED_AT_NODE_ID" VARCHAR(50) NULL, "DEPLOYMENT_TYPE" VARCHAR(50) NULL, "DEPLOYMENT_SUB_TYPE" VARCHAR(50) NULL, PRIMARY KEY ("NODE_ID") ) 2018-08-16 10:59:45,728 INFO [store-001] [H2SymmetricDialect] [background-refresher-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) NULL, "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") ) 2018-08-16 10:59:45,729 INFO [store-001] [H2SymmetricDialect] [background-refresher-1] DDL applied: CREATE TABLE "SYM_NODE_CHANNEL_CTL"( "NODE_ID" VARCHAR(50) NOT NULL, "CHANNEL_ID" VARCHAR(128) NOT NULL, "SUSPEND_ENABLED" TINYINT DEFAULT 0, "IGNORE_ENABLED" TINYINT DEFAULT 0, "LAST_EXTRACT_TIME" TIMESTAMP, PRIMARY KEY ("NODE_ID", "CHANNEL_ID") ) 2018-08-16 10:59:45,731 INFO [store-001] [H2SymmetricDialect] [background-refresher-1] DDL applied: CREATE TABLE "SYM_NODE_GROUP"( "NODE_GROUP_ID" VARCHAR(50) NOT NULL, "DESCRIPTION" VARCHAR(255) NULL, "CREATE_TIME" TIMESTAMP, "LAST_UPDATE_BY" VARCHAR(50) NULL, "LAST_UPDATE_TIME" TIMESTAMP, PRIMARY KEY ("NODE_GROUP_ID") ) 2018-08-16 10:59:45,733 INFO [store-001] [H2SymmetricDialect] [background-refresher-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" TINYINT DEFAULT 0 NOT NULL, PRIMARY KEY ("NODE_GROUP_ID", "CHANNEL_ID", "START_TIME", "END_TIME") ) 2018-08-16 10:59:45,736 INFO [store-001] [H2SymmetricDialect] [background-refresher-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" TINYINT DEFAULT 1 NOT NULL, "IS_REVERSIBLE" TINYINT DEFAULT 0 NOT NULL, "CREATE_TIME" TIMESTAMP, "LAST_UPDATE_BY" VARCHAR(50) NULL, "LAST_UPDATE_TIME" TIMESTAMP, PRIMARY KEY ("SOURCE_NODE_GROUP_ID", "TARGET_NODE_GROUP_ID") ) 2018-08-16 10:59:45,738 INFO [store-001] [H2SymmetricDialect] [background-refresher-1] DDL applied: CREATE TABLE "SYM_NODE_HOST"( "NODE_ID" VARCHAR(50) NOT NULL, "HOST_NAME" VARCHAR(60) NOT NULL, "INSTANCE_ID" VARCHAR(60) NULL, "IP_ADDRESS" VARCHAR(50) NULL, "OS_USER" VARCHAR(50) NULL, "OS_NAME" VARCHAR(50) NULL, "OS_ARCH" VARCHAR(50) NULL, "OS_VERSION" VARCHAR(50) NULL, "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) NULL, "JAVA_VENDOR" VARCHAR(255) NULL, "JDBC_VERSION" VARCHAR(255) NULL, "SYMMETRIC_VERSION" VARCHAR(50) NULL, "TIMEZONE_OFFSET" VARCHAR(6) NULL, "HEARTBEAT_TIME" TIMESTAMP, "LAST_RESTART_TIME" TIMESTAMP NOT NULL, "CREATE_TIME" TIMESTAMP NOT NULL, PRIMARY KEY ("NODE_ID", "HOST_NAME") ) 2018-08-16 10:59:45,739 INFO [store-001] [H2SymmetricDialect] [background-refresher-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, PRIMARY KEY ("NODE_ID", "HOST_NAME", "CHANNEL_ID", "START_TIME", "END_TIME") ) 2018-08-16 10:59:45,740 INFO [store-001] [H2SymmetricDialect] [background-refresher-1] DDL applied: CREATE INDEX "SYM_IDX_ND_HST_CHNL_STS" ON "SYM_NODE_HOST_CHANNEL_STATS" ("NODE_ID", "START_TIME", "END_TIME") 2018-08-16 10:59:45,741 INFO [store-001] [H2SymmetricDialect] [background-refresher-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) NULL, "TARGET_NODE_COUNT" INTEGER DEFAULT 0, PRIMARY KEY ("NODE_ID", "HOST_NAME", "JOB_NAME", "START_TIME", "END_TIME") ) 2018-08-16 10:59:45,742 INFO [store-001] [H2SymmetricDialect] [background-refresher-1] DDL applied: CREATE INDEX "SYM_IDX_ND_HST_JOB" ON "SYM_NODE_HOST_JOB_STATS" ("NODE_ID", "START_TIME", "END_TIME") 2018-08-16 10:59:45,743 INFO [store-001] [H2SymmetricDialect] [background-refresher-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") ) 2018-08-16 10:59:45,748 INFO [store-001] [H2SymmetricDialect] [background-refresher-1] DDL applied: CREATE INDEX "SYM_IDX_ND_HST_STS" ON "SYM_NODE_HOST_STATS" ("NODE_ID", "START_TIME", "END_TIME") 2018-08-16 10:59:45,751 INFO [store-001] [H2SymmetricDialect] [background-refresher-1] DDL applied: CREATE TABLE "SYM_NODE_IDENTITY"( "NODE_ID" VARCHAR(50) NOT NULL, PRIMARY KEY ("NODE_ID") ) 2018-08-16 10:59:45,753 INFO [store-001] [H2SymmetricDialect] [background-refresher-1] DDL applied: CREATE TABLE "SYM_NODE_SECURITY"( "NODE_ID" VARCHAR(50) NOT NULL, "NODE_PASSWORD" VARCHAR(50) NOT NULL, "REGISTRATION_ENABLED" TINYINT DEFAULT 0, "REGISTRATION_TIME" TIMESTAMP, "INITIAL_LOAD_ENABLED" TINYINT DEFAULT 0, "INITIAL_LOAD_TIME" TIMESTAMP, "INITIAL_LOAD_ID" BIGINT, "INITIAL_LOAD_CREATE_BY" VARCHAR(255) NULL, "REV_INITIAL_LOAD_ENABLED" TINYINT DEFAULT 0, "REV_INITIAL_LOAD_TIME" TIMESTAMP, "REV_INITIAL_LOAD_ID" BIGINT, "REV_INITIAL_LOAD_CREATE_BY" VARCHAR(255) NULL, "CREATED_AT_NODE_ID" VARCHAR(50) NULL, PRIMARY KEY ("NODE_ID") ) 2018-08-16 10:59:45,756 INFO [store-001] [H2SymmetricDialect] [background-refresher-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" VARCHAR(2147483647) NULL, "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" TINYINT DEFAULT 0 NOT NULL, "CREATE_TIME" TIMESTAMP, "LAST_UPDATE_BY" VARCHAR(50) NULL, "LAST_UPDATE_TIME" TIMESTAMP, PRIMARY KEY ("MONITOR_ID") ) 2018-08-16 10:59:45,758 INFO [store-001] [H2SymmetricDialect] [background-refresher-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) NULL, "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" TINYINT DEFAULT 0 NOT NULL, "IS_NOTIFIED" TINYINT DEFAULT 0 NOT NULL, "DETAILS" VARCHAR(2147483647) NULL, "LAST_UPDATE_TIME" TIMESTAMP, PRIMARY KEY ("MONITOR_ID", "NODE_ID", "EVENT_TIME") ) 2018-08-16 10:59:45,760 INFO [store-001] [H2SymmetricDialect] [background-refresher-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" VARCHAR(2147483647) NULL, "ENABLED" TINYINT DEFAULT 0 NOT NULL, "CREATE_TIME" TIMESTAMP, "LAST_UPDATE_BY" VARCHAR(50) NULL, "LAST_UPDATE_TIME" TIMESTAMP, PRIMARY KEY ("NOTIFICATION_ID") ) 2018-08-16 10:59:45,766 INFO [store-001] [H2SymmetricDialect] [background-refresher-1] DDL applied: CREATE TABLE "SYM_OUTGOING_BATCH"( "BATCH_ID" BIGINT NOT NULL, "NODE_ID" VARCHAR(50) NOT NULL, "CHANNEL_ID" VARCHAR(128) NULL, "STATUS" CHAR(2) NULL, "ERROR_FLAG" TINYINT DEFAULT 0, "SQL_STATE" VARCHAR(10) NULL, "SQL_CODE" INTEGER DEFAULT 0 NOT NULL, "SQL_MESSAGE" VARCHAR(2147483647) NULL, "LAST_UPDATE_HOSTNAME" VARCHAR(255) NULL, "LAST_UPDATE_TIME" TIMESTAMP, "CREATE_TIME" TIMESTAMP, "SUMMARY" VARCHAR(255) NULL, "IGNORE_COUNT" INTEGER DEFAULT 0 NOT NULL, "BYTE_COUNT" BIGINT DEFAULT 0 NOT NULL, "LOAD_FLAG" TINYINT 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" TINYINT 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" TINYINT 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) NULL, PRIMARY KEY ("BATCH_ID", "NODE_ID") ) 2018-08-16 10:59:45,771 INFO [store-001] [H2SymmetricDialect] [background-refresher-1] DDL applied: CREATE INDEX "SYM_IDX_OB_NODE_STATUS" ON "SYM_OUTGOING_BATCH" ("NODE_ID", "STATUS") 2018-08-16 10:59:45,771 INFO [store-001] [H2SymmetricDialect] [background-refresher-1] DDL applied: CREATE INDEX "SYM_IDX_OB_STATUS" ON "SYM_OUTGOING_BATCH" ("STATUS") 2018-08-16 10:59:45,772 INFO [store-001] [H2SymmetricDialect] [background-refresher-1] DDL applied: CREATE INDEX "SYM_IDX_OB_IN_ERROR" ON "SYM_OUTGOING_BATCH" ("ERROR_FLAG") 2018-08-16 10:59:45,773 INFO [store-001] [H2SymmetricDialect] [background-refresher-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" VARCHAR(2147483647) NULL, "CREATE_TIME" TIMESTAMP, "LAST_UPDATE_BY" VARCHAR(50) NULL, "LAST_UPDATE_TIME" TIMESTAMP, PRIMARY KEY ("EXTERNAL_ID", "NODE_GROUP_ID", "PARAM_KEY") ) 2018-08-16 10:59:45,774 INFO [store-001] [H2SymmetricDialect] [background-refresher-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") ) 2018-08-16 10:59:45,775 INFO [store-001] [H2SymmetricDialect] [background-refresher-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) NULL, "ERROR_MESSAGE" VARCHAR(2147483647) NULL, "CREATE_TIME" TIMESTAMP NOT NULL, "LAST_UPDATE_BY" VARCHAR(50) NULL, "LAST_UPDATE_TIME" TIMESTAMP NOT NULL, PRIMARY KEY ("NODE_GROUP_ID", "EXTERNAL_ID", "CREATE_TIME") ) 2018-08-16 10:59:45,776 INFO [store-001] [H2SymmetricDialect] [background-refresher-1] DDL applied: CREATE INDEX "SYM_IDX_REG_REQ_1" ON "SYM_REGISTRATION_REQUEST" ("NODE_GROUP_ID", "EXTERNAL_ID", "STATUS", "HOST_NAME", "IP_ADDRESS") 2018-08-16 10:59:45,777 INFO [store-001] [H2SymmetricDialect] [background-refresher-1] DDL applied: CREATE INDEX "SYM_IDX_REG_REQ_2" ON "SYM_REGISTRATION_REQUEST" ("STATUS") 2018-08-16 10:59:45,778 INFO [store-001] [H2SymmetricDialect] [background-refresher-1] DDL applied: CREATE TABLE "SYM_ROUTER"( "ROUTER_ID" VARCHAR(50) NOT NULL, "TARGET_CATALOG_NAME" VARCHAR(255) NULL, "TARGET_SCHEMA_NAME" VARCHAR(255) NULL, "TARGET_TABLE_NAME" VARCHAR(255) NULL, "SOURCE_NODE_GROUP_ID" VARCHAR(50) NOT NULL, "TARGET_NODE_GROUP_ID" VARCHAR(50) NOT NULL, "ROUTER_TYPE" VARCHAR(50) NULL, "ROUTER_EXPRESSION" VARCHAR(2147483647) NULL, "SYNC_ON_UPDATE" TINYINT DEFAULT 1 NOT NULL, "SYNC_ON_INSERT" TINYINT DEFAULT 1 NOT NULL, "SYNC_ON_DELETE" TINYINT DEFAULT 1 NOT NULL, "USE_SOURCE_CATALOG_SCHEMA" TINYINT DEFAULT 1 NOT NULL, "CREATE_TIME" TIMESTAMP NOT NULL, "LAST_UPDATE_BY" VARCHAR(50) NULL, "LAST_UPDATE_TIME" TIMESTAMP NOT NULL, "DESCRIPTION" VARCHAR(2147483647) NULL, PRIMARY KEY ("ROUTER_ID") ) 2018-08-16 10:59:45,784 INFO [store-001] [H2SymmetricDialect] [background-refresher-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" TINYINT DEFAULT 0, "CACHE_SIZE" INTEGER DEFAULT 0 NOT NULL, "CREATE_TIME" TIMESTAMP, "LAST_UPDATE_BY" VARCHAR(50) NULL, "LAST_UPDATE_TIME" TIMESTAMP NOT NULL, PRIMARY KEY ("SEQUENCE_NAME") ) 2018-08-16 10:59:45,788 INFO [store-001] [H2SymmetricDialect] [background-refresher-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" TINYINT DEFAULT 0 NOT NULL, "DELETE_FIRST" TINYINT DEFAULT 0 NOT NULL, "RELOAD_SELECT" VARCHAR(2147483647) NULL, "BEFORE_CUSTOM_SQL" VARCHAR(2147483647) NULL, "RELOAD_TIME" TIMESTAMP, "LOAD_ID" BIGINT, "PROCESSED" TINYINT DEFAULT 0 NOT NULL, "CHANNEL_ID" VARCHAR(128) NULL, "LAST_UPDATE_BY" VARCHAR(50) NULL, "LAST_UPDATE_TIME" TIMESTAMP NOT NULL, PRIMARY KEY ("TARGET_NODE_ID", "SOURCE_NODE_ID", "TRIGGER_ID", "ROUTER_ID", "CREATE_TIME") ) 2018-08-16 10:59:45,790 INFO [store-001] [H2SymmetricDialect] [background-refresher-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) NULL, "SOURCE_SCHEMA_NAME" VARCHAR(255) NULL, "SOURCE_TABLE_NAME" VARCHAR(255) NOT NULL, "TARGET_CATALOG_NAME" VARCHAR(255) NULL, "TARGET_SCHEMA_NAME" VARCHAR(255) NULL, "TARGET_TABLE_NAME" VARCHAR(255) NULL, "UPDATE_FIRST" TINYINT 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) NULL, "LAST_UPDATE_TIME" TIMESTAMP, "DESCRIPTION" VARCHAR(2147483647) NULL, PRIMARY KEY ("TRANSFORM_ID", "SOURCE_NODE_GROUP_ID", "TARGET_NODE_GROUP_ID") ) 2018-08-16 10:59:45,792 INFO [store-001] [H2SymmetricDialect] [background-refresher-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) NULL, "PK" TINYINT DEFAULT 0, "TRANSFORM_TYPE" VARCHAR(50) DEFAULT 'copy' NULL, "TRANSFORM_EXPRESSION" VARCHAR(2147483647) NULL, "TRANSFORM_ORDER" INTEGER DEFAULT 1 NOT NULL, "CREATE_TIME" TIMESTAMP, "LAST_UPDATE_BY" VARCHAR(50) NULL, "LAST_UPDATE_TIME" TIMESTAMP, "DESCRIPTION" VARCHAR(2147483647) NULL, PRIMARY KEY ("TRANSFORM_ID", "INCLUDE_ON", "TARGET_COLUMN_NAME") ) 2018-08-16 10:59:45,800 INFO [store-001] [H2SymmetricDialect] [background-refresher-1] DDL applied: CREATE TABLE "SYM_TRIGGER"( "TRIGGER_ID" VARCHAR(128) NOT NULL, "SOURCE_CATALOG_NAME" VARCHAR(255) NULL, "SOURCE_SCHEMA_NAME" VARCHAR(255) NULL, "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" TINYINT DEFAULT 1 NOT NULL, "SYNC_ON_INSERT" TINYINT DEFAULT 1 NOT NULL, "SYNC_ON_DELETE" TINYINT DEFAULT 1 NOT NULL, "SYNC_ON_INCOMING_BATCH" TINYINT DEFAULT 0 NOT NULL, "NAME_FOR_UPDATE_TRIGGER" VARCHAR(255) NULL, "NAME_FOR_INSERT_TRIGGER" VARCHAR(255) NULL, "NAME_FOR_DELETE_TRIGGER" VARCHAR(255) NULL, "SYNC_ON_UPDATE_CONDITION" VARCHAR(2147483647) NULL, "SYNC_ON_INSERT_CONDITION" VARCHAR(2147483647) NULL, "SYNC_ON_DELETE_CONDITION" VARCHAR(2147483647) NULL, "CUSTOM_BEFORE_UPDATE_TEXT" VARCHAR(2147483647) NULL, "CUSTOM_BEFORE_INSERT_TEXT" VARCHAR(2147483647) NULL, "CUSTOM_BEFORE_DELETE_TEXT" VARCHAR(2147483647) NULL, "CUSTOM_ON_UPDATE_TEXT" VARCHAR(2147483647) NULL, "CUSTOM_ON_INSERT_TEXT" VARCHAR(2147483647) NULL, "CUSTOM_ON_DELETE_TEXT" VARCHAR(2147483647) NULL, "EXTERNAL_SELECT" VARCHAR(2147483647) NULL, "TX_ID_EXPRESSION" VARCHAR(2147483647) NULL, "CHANNEL_EXPRESSION" VARCHAR(2147483647) NULL, "EXCLUDED_COLUMN_NAMES" VARCHAR(2147483647) NULL, "INCLUDED_COLUMN_NAMES" VARCHAR(2147483647) NULL, "SYNC_KEY_NAMES" VARCHAR(2147483647) NULL, "USE_STREAM_LOBS" TINYINT DEFAULT 0 NOT NULL, "USE_CAPTURE_LOBS" TINYINT DEFAULT 0 NOT NULL, "USE_CAPTURE_OLD_DATA" TINYINT DEFAULT 1 NOT NULL, "USE_HANDLE_KEY_UPDATES" TINYINT DEFAULT 1 NOT NULL, "STREAM_ROW" TINYINT DEFAULT 0 NOT NULL, "CREATE_TIME" TIMESTAMP NOT NULL, "LAST_UPDATE_BY" VARCHAR(50) NULL, "LAST_UPDATE_TIME" TIMESTAMP NOT NULL, "DESCRIPTION" VARCHAR(2147483647) NULL, PRIMARY KEY ("TRIGGER_ID") ) 2018-08-16 10:59:45,806 INFO [store-001] [H2SymmetricDialect] [background-refresher-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) NULL, "SOURCE_SCHEMA_NAME" VARCHAR(255) NULL, "NAME_FOR_UPDATE_TRIGGER" VARCHAR(255) NULL, "NAME_FOR_INSERT_TRIGGER" VARCHAR(255) NULL, "NAME_FOR_DELETE_TRIGGER" VARCHAR(255) NULL, "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" VARCHAR(2147483647) NOT NULL, "PK_COLUMN_NAMES" VARCHAR(2147483647) NOT NULL, "LAST_TRIGGER_BUILD_REASON" CHAR(1) NOT NULL, "ERROR_MESSAGE" VARCHAR(2147483647) NULL, "CREATE_TIME" TIMESTAMP NOT NULL, "INACTIVE_TIME" TIMESTAMP, PRIMARY KEY ("TRIGGER_HIST_ID") ) 2018-08-16 10:59:45,806 INFO [store-001] [H2SymmetricDialect] [background-refresher-1] DDL applied: CREATE INDEX "SYM_IDX_TRIGG_HIST_1" ON "SYM_TRIGGER_HIST" ("TRIGGER_ID", "INACTIVE_TIME") 2018-08-16 10:59:45,816 INFO [store-001] [H2SymmetricDialect] [background-refresher-1] DDL applied: CREATE TABLE "SYM_TRIGGER_ROUTER"( "TRIGGER_ID" VARCHAR(128) NOT NULL, "ROUTER_ID" VARCHAR(50) NOT NULL, "ENABLED" TINYINT DEFAULT 1 NOT NULL, "INITIAL_LOAD_ORDER" INTEGER DEFAULT 1 NOT NULL, "INITIAL_LOAD_SELECT" VARCHAR(2147483647) NULL, "INITIAL_LOAD_DELETE_STMT" VARCHAR(2147483647) NULL, "PING_BACK_ENABLED" TINYINT DEFAULT 0 NOT NULL, "CREATE_TIME" TIMESTAMP NOT NULL, "LAST_UPDATE_BY" VARCHAR(50) NULL, "LAST_UPDATE_TIME" TIMESTAMP NOT NULL, "DESCRIPTION" VARCHAR(2147483647) NULL, PRIMARY KEY ("TRIGGER_ID", "ROUTER_ID") ) 2018-08-16 10:59:45,819 INFO [store-001] [H2SymmetricDialect] [background-refresher-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) NULL, "LAST_UPDATE_TIME" TIMESTAMP NOT NULL, PRIMARY KEY ("GROUPLET_ID", "TRIGGER_ID", "ROUTER_ID", "APPLIES_WHEN") ) 2018-08-16 10:59:45,821 INFO [store-001] [H2SymmetricDialect] [background-refresher-1] DDL applied: CREATE TABLE "SYM_CONSOLE_USER"( "USER_ID" VARCHAR(50) NOT NULL, "FIRST_NAME" VARCHAR(50) NOT NULL, "LAST_NAME" VARCHAR(50) NOT NULL, "EMAIL" VARCHAR(50) NULL, "HASHED_PASSWORD" VARCHAR(255) NULL, "SALT" VARCHAR(50) NULL, "ENCRYPT_METH" VARCHAR(50) NULL, "FAILED_LOGINS" TINYINT DEFAULT 0, "AUTH_METH" VARCHAR(50) DEFAULT 'INTERNAL' NULL, "USER_ROLE" VARCHAR(50) DEFAULT 'ADMIN' NULL, "CREATE_TIME" TIMESTAMP, "LAST_LOGIN_TIME" TIMESTAMP, "LAST_LOGIN_NODE_ID" VARCHAR(50) NULL, "LAST_UPDATE_BY" VARCHAR(50) NULL, "LAST_UPDATE_TIME" TIMESTAMP, "LAST_PASSWORD_TIME" TIMESTAMP, PRIMARY KEY ("USER_ID") ) 2018-08-16 10:59:45,823 INFO [store-001] [H2SymmetricDialect] [background-refresher-1] DDL applied: CREATE TABLE "SYM_CONSOLE_USER_HIST"( "HIST_ID" INTEGER NOT NULL, "USER_ID" VARCHAR(50) NOT NULL, "HASHED_PASSWORD" VARCHAR(255) NULL, "SALT" VARCHAR(50) NULL, "ENCRYPT_METH" VARCHAR(50) NULL, "AUTH_METH" VARCHAR(50) DEFAULT 'INTERNAL' NULL, PRIMARY KEY ("HIST_ID", "USER_ID") ) 2018-08-16 10:59:45,825 INFO [store-001] [H2SymmetricDialect] [background-refresher-1] DDL applied: CREATE TABLE "SYM_CONSOLE_EVENT"( "USER_ID" VARCHAR(50) NOT NULL, "EVENT_CODE" VARCHAR(25) NOT NULL, "CREATE_TIME" TIMESTAMP NOT NULL, "EVENT_NODE_ID" VARCHAR(50) NULL, "SOURCE_NODE_ID" VARCHAR(50) NULL, "TARGET_NODE_ID" VARCHAR(50) NULL, "EVENT_VALUE" VARCHAR(2147483647) NULL, PRIMARY KEY ("USER_ID", "EVENT_CODE", "CREATE_TIME") ) 2018-08-16 10:59:45,842 INFO [store-001] [H2SymmetricDialect] [background-refresher-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") 2018-08-16 10:59:45,844 INFO [store-001] [H2SymmetricDialect] [background-refresher-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") 2018-08-16 10:59:45,845 INFO [store-001] [H2SymmetricDialect] [background-refresher-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") 2018-08-16 10:59:45,848 INFO [store-001] [H2SymmetricDialect] [background-refresher-1] DDL applied: ALTER TABLE "SYM_GROUPLET_LINK" ADD CONSTRAINT "SYM_FK_GPLTLNK_2_GPLT" FOREIGN KEY ("GROUPLET_ID") REFERENCES "SYM_GROUPLET" ("GROUPLET_ID") 2018-08-16 10:59:45,860 INFO [store-001] [H2SymmetricDialect] [background-refresher-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") 2018-08-16 10:59:45,868 INFO [store-001] [H2SymmetricDialect] [background-refresher-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") 2018-08-16 10:59:45,870 INFO [store-001] [H2SymmetricDialect] [background-refresher-1] DDL applied: ALTER TABLE "SYM_NODE_IDENTITY" ADD CONSTRAINT "SYM_FK_IDENT_2_NODE" FOREIGN KEY ("NODE_ID") REFERENCES "SYM_NODE" ("NODE_ID") 2018-08-16 10:59:45,871 INFO [store-001] [H2SymmetricDialect] [background-refresher-1] DDL applied: ALTER TABLE "SYM_NODE_SECURITY" ADD CONSTRAINT "SYM_FK_SEC_2_NODE" FOREIGN KEY ("NODE_ID") REFERENCES "SYM_NODE" ("NODE_ID") 2018-08-16 10:59:45,873 INFO [store-001] [H2SymmetricDialect] [background-refresher-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") 2018-08-16 10:59:45,874 INFO [store-001] [H2SymmetricDialect] [background-refresher-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") 2018-08-16 10:59:45,876 INFO [store-001] [H2SymmetricDialect] [background-refresher-1] DDL applied: ALTER TABLE "SYM_TRIGGER" ADD CONSTRAINT "SYM_FK_TRG_2_CHNL" FOREIGN KEY ("CHANNEL_ID") REFERENCES "SYM_CHANNEL" ("CHANNEL_ID") 2018-08-16 10:59:45,878 INFO [store-001] [H2SymmetricDialect] [background-refresher-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") 2018-08-16 10:59:45,882 INFO [store-001] [H2SymmetricDialect] [background-refresher-1] DDL applied: ALTER TABLE "SYM_TRIGGER_ROUTER" ADD CONSTRAINT "SYM_FK_TR_2_TRG" FOREIGN KEY ("TRIGGER_ID") REFERENCES "SYM_TRIGGER" ("TRIGGER_ID") 2018-08-16 10:59:45,887 INFO [store-001] [H2SymmetricDialect] [background-refresher-1] DDL applied: ALTER TABLE "SYM_TRIGGER_ROUTER" ADD CONSTRAINT "SYM_FK_TR_2_RTR" FOREIGN KEY ("ROUTER_ID") REFERENCES "SYM_ROUTER" ("ROUTER_ID") 2018-08-16 10:59:45,889 INFO [store-001] [H2SymmetricDialect] [background-refresher-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") 2018-08-16 10:59:45,890 INFO [store-001] [H2SymmetricDialect] [background-refresher-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") 2018-08-16 10:59:45,893 INFO [store-001] [H2SymmetricDialect] [background-refresher-1] Done with auto update of SymmetricDS tables 2018-08-16 10:59:45,901 INFO [store-001] [H2SymmetricDialect] [background-refresher-1] Installing SymmetricDS database object: CREATE ALIAS IF NOT EXISTS SYM_BASE64_ENCODE for "org.jumpmind.symmetric.db.EmbeddedDbFunctions.encodeBase64"; 2018-08-16 10:59:45,907 INFO [store-001] [H2SymmetricDialect] [background-refresher-1] Just installed SYM_BASE64_ENCODE 2018-08-16 10:59:45,909 INFO [store-001] [ConfigurationService] [background-refresher-1] Auto-configuring config channel 2018-08-16 10:59:45,940 INFO [store-001] [ConfigurationService] [background-refresher-1] Auto-configuring reload channel 2018-08-16 10:59:45,944 INFO [store-001] [ConfigurationService] [background-refresher-1] Auto-configuring monitor channel 2018-08-16 10:59:45,948 INFO [store-001] [ConfigurationService] [background-refresher-1] Auto-configuring heartbeat channel 2018-08-16 10:59:45,953 INFO [store-001] [ConfigurationService] [background-refresher-1] Auto-configuring default channel 2018-08-16 10:59:45,955 INFO [store-001] [ConfigurationService] [background-refresher-1] Auto-configuring dynamic channel 2018-08-16 10:59:46,039 INFO [store-001] [AbstractSymmetricEngine] [background-refresher-1] Done initializing SymmetricDS database 2018-08-16 10:59:46,040 INFO [store-001] [AbstractSymmetricEngine] [background-refresher-1] SymmetricDS database version : null 2018-08-16 10:59:46,041 INFO [store-001] [AbstractSymmetricEngine] [background-refresher-1] SymmetricDS software version : 3.9.11 2018-08-16 10:59:46,123 INFO [store-001] [AbstractSymmetricEngine] [background-refresher-1] Starting unregistered node [group=store, externalId=001] 2018-08-16 10:59:46,160 INFO [store-001] [RouterJob] [background-refresher-1] Starting Routing on periodic schedule: every 10000ms with the first run at Thu Aug 16 10:59:53 EDT 2018 2018-08-16 10:59:46,170 INFO [store-001] [PushJob] [background-refresher-1] Starting Push on periodic schedule: every 60000ms with the first run at Thu Aug 16 10:59:53 EDT 2018 2018-08-16 10:59:46,170 INFO [store-001] [PullJob] [background-refresher-1] Starting Pull on periodic schedule: every 60000ms with the first run at Thu Aug 16 10:59:53 EDT 2018 2018-08-16 10:59:46,171 INFO [store-001] [JobManager] [background-refresher-1] Job Offline Push not configured for auto start 2018-08-16 10:59:46,171 INFO [store-001] [JobManager] [background-refresher-1] Job Offline Pull not configured for auto start 2018-08-16 10:59:46,177 INFO [store-001] [OutgoingPurgeJob] [background-refresher-1] Starting job 'Purge Outgoing' with cron expression: '0 0 0 * * *' 2018-08-16 10:59:46,182 INFO [store-001] [IncomingPurgeJob] [background-refresher-1] Starting job 'Purge Incoming' with cron expression: '0 0 0 * * *' 2018-08-16 10:59:46,182 INFO [store-001] [StatisticFlushJob] [background-refresher-1] Starting job 'Stat Flush' with cron expression: '0 0/5 * * * *' 2018-08-16 10:59:46,183 INFO [store-001] [SyncTriggersJob] [background-refresher-1] Starting job 'SyncTriggers' with cron expression: '0 0 0 * * *' 2018-08-16 10:59:46,184 INFO [store-001] [HeartbeatJob] [background-refresher-1] Starting Heartbeat on periodic schedule: every 900000ms with the first run at Thu Aug 16 10:59:53 EDT 2018 2018-08-16 10:59:46,184 INFO [store-001] [WatchdogJob] [background-refresher-1] Starting Watchdog on periodic schedule: every 3600000ms with the first run at Thu Aug 16 10:59:53 EDT 2018 2018-08-16 10:59:46,185 INFO [store-001] [StageManagementJob] [background-refresher-1] Starting job 'Stage Management' with cron expression: '0 0 * * * *' 2018-08-16 10:59:46,185 INFO [store-001] [JobManager] [background-refresher-1] Job Refresh Cache not configured for auto start 2018-08-16 10:59:46,185 INFO [store-001] [JobManager] [background-refresher-1] Job File Sync Tracker not configured for auto start 2018-08-16 10:59:46,185 INFO [store-001] [JobManager] [background-refresher-1] Job File Sync Pull not configured for auto start 2018-08-16 10:59:46,186 INFO [store-001] [JobManager] [background-refresher-1] Job File Sync Push not configured for auto start 2018-08-16 10:59:46,186 INFO [store-001] [InitialLoadExtractorJob] [background-refresher-1] Starting Initial Load Extract on periodic schedule: every 10000ms with the first run at Thu Aug 16 10:59:53 EDT 2018 2018-08-16 10:59:46,187 INFO [store-001] [MonitorJob] [background-refresher-1] Starting Monitor on periodic schedule: every 60000ms with the first run at Thu Aug 16 10:59:53 EDT 2018 2018-08-16 10:59:46,187 INFO [store-001] [JobManager] [background-refresher-1] Job Report Status not configured for auto start 2018-08-16 10:59:46,194 INFO [store-001] [ClusterService] [background-refresher-1] This node picked a server id of turing.loc 2018-08-16 10:59:46,199 INFO [store-001] [AbstractSymmetricEngine] [background-refresher-1] SymmetricDS Node STARTED: nodeId=001 groupId=store type=professional subType=null name=store-001 softwareVersion=3.9.11 databaseName=H2 databaseVersion=1.3 driverName=H2 JDBC Driver driverVersion=1.3.176 (2014-04-05) uptime=0 sec. 2018-08-16 10:59:53,538 INFO [store-001] [RouterJob] [store-001-job-1] Did not run the 'Routing' job because the engine is not registered. 2018-08-16 10:59:53,540 INFO [store-001] [PushJob] [store-001-job-3] Did not run the 'Push' job because the engine is not registered. 2018-08-16 10:59:53,552 INFO [store-001] [RegistrationService] [store-001-job-2] This node is unregistered. It will attempt to register using the registration.url 2018-08-16 10:59:53,556 INFO [store-001] [InitialLoadExtractorJob] [store-001-job-3] Did not run the 'Initial Load Extract' job because the engine is not registered. 2018-08-16 10:59:53,561 INFO [store-001] [MonitorJob] [store-001-job-6] Did not run the 'Monitor' job because the engine is not registered. 2018-08-16 10:59:53,573 INFO [store-001] [DataLoaderService] [store-001-job-2] Using registration URL of http://localhost:31000/sync/corp-000/registration?nodeGroupId=store&externalId=001&syncURL=http%3A%2F%2Flocalhost%3A31010%2Fsync%2Fstore-001&schemaVersion=%3F&databaseType=H2&databaseVersion=1.3&symmetricVersion=3.9.11&deploymentType=professional&hostName=turing.loc&ipAddress=192.168.42.134 2018-08-16 10:59:53,622 WARN [store-001] [RegistrationService] [store-001-job-2] Waiting for registration to be accepted by the server. Registration is not open. 2018-08-16 10:59:53,624 INFO [store-001] [RegistrationService] [store-001-job-2] Could not register. Sleeping for 6000ms before attempting again. 2018-08-16 10:59:59,631 INFO [store-001] [RegistrationService] [store-001-job-2] This node is unregistered. It will attempt to register using the registration.url 2018-08-16 10:59:59,642 INFO [store-001] [DataLoaderService] [store-001-job-2] Using registration URL of http://localhost:31000/sync/corp-000/registration?nodeGroupId=store&externalId=001&syncURL=http%3A%2F%2Flocalhost%3A31010%2Fsync%2Fstore-001&schemaVersion=%3F&databaseType=H2&databaseVersion=1.3&symmetricVersion=3.9.11&deploymentType=professional&hostName=turing.loc&ipAddress=192.168.42.134 2018-08-16 10:59:59,660 WARN [store-001] [RegistrationService] [store-001-job-2] Waiting for registration to be accepted by the server. Registration is not open. 2018-08-16 10:59:59,661 INFO [store-001] [RegistrationService] [store-001-job-2] Could not register. Sleeping for 17000ms before attempting again. 2018-08-16 11:00:00,003 INFO [store-001] [StageManagementJob] [store-001-job-8] Did not run the 'Stage Management' job because the engine is not registered. 2018-08-16 11:00:00,005 INFO [store-001] [StatisticFlushJob] [store-001-job-7] Did not run the 'Stat Flush' job because the engine is not registered. 2018-08-16 11:00:16,668 INFO [store-001] [RegistrationService] [store-001-job-2] This node is unregistered. It will attempt to register using the registration.url 2018-08-16 11:00:16,678 INFO [store-001] [DataLoaderService] [store-001-job-2] Using registration URL of http://localhost:31000/sync/corp-000/registration?nodeGroupId=store&externalId=001&syncURL=http%3A%2F%2Flocalhost%3A31010%2Fsync%2Fstore-001&schemaVersion=%3F&databaseType=H2&databaseVersion=1.3&symmetricVersion=3.9.11&deploymentType=professional&hostName=turing.loc&ipAddress=192.168.42.134 2018-08-16 11:00:17,656 INFO [store-001] [ConfigurationChangedDatabaseWriterFilter] [store-001-dataloader-1] Grouplets flushed because new grouplet config came through the data loader 2018-08-16 11:00:17,656 INFO [store-001] [ConfigurationChangedDatabaseWriterFilter] [store-001-dataloader-1] Load filters flushed because new filter config came through the data loader 2018-08-16 11:00:17,657 INFO [store-001] [ConfigurationChangedDatabaseWriterFilter] [store-001-dataloader-1] Channels flushed because new channels came through the data loader 2018-08-16 11:00:17,657 INFO [store-001] [ConfigurationChangedDatabaseWriterFilter] [store-001-dataloader-1] About to refresh the cache of conflict settings because new configuration came through the data loader 2018-08-16 11:00:17,657 INFO [store-001] [ConfigurationChangedDatabaseWriterFilter] [store-001-dataloader-1] About to refresh the cache of parameters because new configuration came through the data loader 2018-08-16 11:00:17,669 INFO [store-001] [ConfigurationChangedDatabaseWriterFilter] [store-001-dataloader-1] About to refresh the cache of node security because new configuration came through the data loader 2018-08-16 11:00:17,672 INFO [store-001] [ConfigurationChangedDatabaseWriterFilter] [store-001-job-2] About to refresh the cache of transformation because new configuration came through the data loader 2018-08-16 11:00:17,672 INFO [store-001] [ConfigurationChangedDatabaseWriterFilter] [store-001-job-2] About to clear the staging area because new transform configuration came through the data loader 2018-08-16 11:00:17,674 INFO [store-001] [StagingManager] [store-001-job-2] Purged 1 from stage, freeing 3 kbytes of space 2018-08-16 11:00:17,674 INFO [store-001] [ConfigurationChangedDatabaseWriterFilter] [store-001-job-2] About to restart jobs because new configuration came through the data loader 2018-08-16 11:00:17,675 INFO [store-001] [RouterJob] [store-001-job-2] The 'Routing' job has been cancelled 2018-08-16 11:00:17,675 INFO [store-001] [PushJob] [store-001-job-2] The 'Push' job has been cancelled 2018-08-16 11:00:17,675 INFO [store-001] [PullJob] [store-001-job-2] The 'Pull' job has been cancelled 2018-08-16 11:00:17,675 INFO [store-001] [OutgoingPurgeJob] [store-001-job-2] The 'Purge Outgoing' job has been cancelled 2018-08-16 11:00:17,675 INFO [store-001] [IncomingPurgeJob] [store-001-job-2] The 'Purge Incoming' job has been cancelled 2018-08-16 11:00:17,676 INFO [store-001] [StatisticFlushJob] [store-001-job-2] The 'Stat Flush' job has been cancelled 2018-08-16 11:00:17,676 INFO [store-001] [SyncTriggersJob] [store-001-job-2] The 'SyncTriggers' job has been cancelled 2018-08-16 11:00:17,676 INFO [store-001] [HeartbeatJob] [store-001-job-2] The 'Heartbeat' job has been cancelled 2018-08-16 11:00:17,676 INFO [store-001] [WatchdogJob] [store-001-job-2] The 'Watchdog' job has been cancelled 2018-08-16 11:00:17,676 INFO [store-001] [StageManagementJob] [store-001-job-2] The 'Stage Management' job has been cancelled 2018-08-16 11:00:17,676 INFO [store-001] [InitialLoadExtractorJob] [store-001-job-2] The 'Initial Load Extract' job has been cancelled 2018-08-16 11:00:17,676 INFO [store-001] [MonitorJob] [store-001-job-2] The 'Monitor' job has been cancelled 2018-08-16 11:00:17,678 INFO [store-001] [RouterJob] [store-001-job-2] Starting Routing on periodic schedule: every 10000ms with the first run at Thu Aug 16 11:00:25 EDT 2018 2018-08-16 11:00:17,678 INFO [store-001] [PushJob] [store-001-job-2] Starting Push on periodic schedule: every 10000ms with the first run at Thu Aug 16 11:00:25 EDT 2018 2018-08-16 11:00:17,678 INFO [store-001] [PullJob] [store-001-job-2] Starting Pull on periodic schedule: every 10000ms with the first run at Thu Aug 16 11:00:25 EDT 2018 2018-08-16 11:00:17,679 INFO [store-001] [OutgoingPurgeJob] [store-001-job-2] Starting job 'Purge Outgoing' with cron expression: '0 0 0 * * *' 2018-08-16 11:00:17,679 INFO [store-001] [IncomingPurgeJob] [store-001-job-2] Starting job 'Purge Incoming' with cron expression: '0 0 0 * * *' 2018-08-16 11:00:17,680 INFO [store-001] [StatisticFlushJob] [store-001-job-2] Starting job 'Stat Flush' with cron expression: '0 0/5 * * * *' 2018-08-16 11:00:17,680 INFO [store-001] [SyncTriggersJob] [store-001-job-2] Starting job 'SyncTriggers' with cron expression: '0 0 0 * * *' 2018-08-16 11:00:17,680 INFO [store-001] [HeartbeatJob] [store-001-job-2] Starting Heartbeat on periodic schedule: every 900000ms with the first run at Thu Aug 16 11:15:00 EDT 2018 2018-08-16 11:00:17,680 INFO [store-001] [WatchdogJob] [store-001-job-2] Starting Watchdog on periodic schedule: every 3600000ms with the first run at Thu Aug 16 12:00:00 EDT 2018 2018-08-16 11:00:17,680 INFO [store-001] [StageManagementJob] [store-001-job-2] Starting job 'Stage Management' with cron expression: '0 0 * * * *' 2018-08-16 11:00:17,681 INFO [store-001] [InitialLoadExtractorJob] [store-001-job-2] Starting Initial Load Extract on periodic schedule: every 10000ms with the first run at Thu Aug 16 11:00:25 EDT 2018 2018-08-16 11:00:17,681 INFO [store-001] [MonitorJob] [store-001-job-2] Starting Monitor on periodic schedule: every 60000ms with the first run at Thu Aug 16 11:00:25 EDT 2018 2018-08-16 11:00:17,681 INFO [store-001] [ConfigurationChangedDatabaseWriterFilter] [store-001-job-2] About to syncTriggers because new configuration came through the data loader 2018-08-16 11:00:17,681 INFO [store-001] [TriggerRouterService] [store-001-job-2] Synchronizing triggers 2018-08-16 11:00:17,701 INFO [store-001] [TriggerRouterService] [store-001-job-2] Done synchronizing triggers 2018-08-16 11:00:17,702 ERROR [store-001] [RegistrationService] [store-001-job-2] Unexpected error during registration: java.lang.InterruptedException StackTraceKey.init [RuntimeException:1494018447] java.lang.RuntimeException: java.lang.InterruptedException at org.jumpmind.symmetric.service.impl.TriggerRouterService.awaitTermination(TriggerRouterService.java:2234) at org.jumpmind.symmetric.service.impl.TriggerRouterService.updateOrCreateDatabaseTriggers(TriggerRouterService.java:1546) at org.jumpmind.symmetric.service.impl.TriggerRouterService.syncTriggers(TriggerRouterService.java:1215) at org.jumpmind.symmetric.service.impl.TriggerRouterService.syncTriggers(TriggerRouterService.java:1161) at org.jumpmind.symmetric.service.impl.TriggerRouterService.syncTriggers(TriggerRouterService.java:1157) at org.jumpmind.symmetric.load.ConfigurationChangedDatabaseWriterFilter.syncEnded(ConfigurationChangedDatabaseWriterFilter.java:331) at org.jumpmind.symmetric.service.impl.DataLoaderService.loadDataFromTransport(DataLoaderService.java:629) at org.jumpmind.symmetric.service.impl.DataLoaderService.loadDataFromPull(DataLoaderService.java:296) at org.jumpmind.symmetric.service.impl.DataLoaderService.loadDataFromPull(DataLoaderService.java:252) at org.jumpmind.symmetric.service.impl.RegistrationService.attemptToRegisterWithServer(RegistrationService.java:483) at org.jumpmind.symmetric.service.impl.RegistrationService.registerWithServer(RegistrationService.java:459) at org.jumpmind.symmetric.service.impl.PullService.pullData(PullService.java:89) at org.jumpmind.symmetric.job.PullJob.doJob(PullJob.java:48) at org.jumpmind.symmetric.job.AbstractJob.invoke(AbstractJob.java:226) at org.jumpmind.symmetric.job.AbstractJob.run(AbstractJob.java:297) at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745) Caused by: java.lang.InterruptedException at java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.awaitNanos(AbstractQueuedSynchronizer.java:2067) at java.util.concurrent.ThreadPoolExecutor.awaitTermination(ThreadPoolExecutor.java:1465) at org.jumpmind.symmetric.service.impl.TriggerRouterService.awaitTermination(TriggerRouterService.java:2223) ... 22 more 2018-08-16 11:00:17,717 INFO [store-001] [RegistrationService] [store-001-job-2] We registered, but were not able to acknowledge our registration. Sending a sql event to the node where we registered to indicate that we are alive and registered 2018-08-16 11:00:17,719 ERROR [store-001] [PullJob] [store-001-job-2] Exception while executing job 'Pull' StackTraceKey.init [NullPointerException:1666781840] java.lang.NullPointerException at org.jumpmind.symmetric.service.impl.DataService.insertSqlEvent(DataService.java:1179) at org.jumpmind.symmetric.service.impl.RegistrationService.checkRegistrationSuccessful(RegistrationService.java:539) at org.jumpmind.symmetric.service.impl.RegistrationService.attemptToRegisterWithServer(RegistrationService.java:525) at org.jumpmind.symmetric.service.impl.RegistrationService.registerWithServer(RegistrationService.java:459) at org.jumpmind.symmetric.service.impl.PullService.pullData(PullService.java:89) at org.jumpmind.symmetric.job.PullJob.doJob(PullJob.java:48) at org.jumpmind.symmetric.job.AbstractJob.invoke(AbstractJob.java:226) at org.jumpmind.symmetric.job.AbstractJob.run(AbstractJob.java:297) at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745) 2018-08-16 11:00:17,729 INFO [store-001] [H2SymmetricDialect] [store-001-sync-triggers-1] Creating SYM_ON_I_FOR_SYM_RTR_STR trigger for PRO-STORE-001.PUBLIC.SYM_ROUTER 2018-08-16 11:00:17,750 INFO [store-001] [H2SymmetricDialect] [store-001-sync-triggers-1] Creating SYM_ON_U_FOR_SYM_RTR_STR trigger for PRO-STORE-001.PUBLIC.SYM_ROUTER 2018-08-16 11:00:17,761 INFO [store-001] [H2SymmetricDialect] [store-001-sync-triggers-1] Creating SYM_ON_D_FOR_SYM_RTR_STR trigger for PRO-STORE-001.PUBLIC.SYM_ROUTER 2018-08-16 11:00:25,057 INFO [store-001] [DataService] [store-001-job-5] Inserting missing last data gap: { startId: 1, endId: 50000001, createTime: "Thu Aug 16 11:00:25 EDT 2018" } 2018-08-16 11:00:25,062 INFO [store-001] [NodeCommunicationService] [store-001-job-15] pull will use 10 threads 2018-08-16 11:00:25,063 INFO [store-001] [NodeCommunicationService] [store-001-job-14] push will use 10 threads 2018-08-16 11:00:25,090 INFO [store-001] [DataGapFastDetector] [store-001-job-5] Full gap analysis is running 2018-08-16 11:00:25,093 INFO [store-001] [DataGapFastDetector] [store-001-job-5] Querying data in gaps from database took 3 ms 2018-08-16 11:00:25,095 INFO [store-001] [DataGapFastDetector] [store-001-job-5] Full gap analysis is done after 5 ms 2018-08-16 11:00:25,710 INFO [store-001] [ConfigurationChangedDatabaseWriterFilter] [store-001-dataloader-2] Grouplets flushed because new grouplet config came through the data loader 2018-08-16 11:00:25,711 INFO [store-001] [ConfigurationChangedDatabaseWriterFilter] [store-001-dataloader-2] Load filters flushed because new filter config came through the data loader 2018-08-16 11:00:25,711 INFO [store-001] [ConfigurationChangedDatabaseWriterFilter] [store-001-dataloader-2] Channels flushed because new channels came through the data loader 2018-08-16 11:00:25,711 INFO [store-001] [ConfigurationChangedDatabaseWriterFilter] [store-001-dataloader-2] About to refresh the cache of conflict settings because new configuration came through the data loader 2018-08-16 11:00:25,712 INFO [store-001] [ConfigurationChangedDatabaseWriterFilter] [store-001-dataloader-2] About to refresh the cache of parameters because new configuration came through the data loader 2018-08-16 11:00:25,720 INFO [store-001] [ConfigurationChangedDatabaseWriterFilter] [store-001-dataloader-2] About to refresh the cache of node security because new configuration came through the data loader 2018-08-16 11:00:25,721 INFO [store-001] [ConfigurationChangedDatabaseWriterFilter] [store-001-pull-default-1] About to refresh the cache of transformation because new configuration came through the data loader 2018-08-16 11:00:25,721 INFO [store-001] [ConfigurationChangedDatabaseWriterFilter] [store-001-pull-default-1] About to clear the staging area because new transform configuration came through the data loader 2018-08-16 11:00:25,722 INFO [store-001] [StagingManager] [store-001-pull-default-1] Purged 1 from stage, freeing 3 kbytes of space 2018-08-16 11:00:25,722 INFO [store-001] [ConfigurationChangedDatabaseWriterFilter] [store-001-pull-default-1] About to restart jobs because new configuration came through the data loader 2018-08-16 11:00:25,722 INFO [store-001] [RouterJob] [store-001-pull-default-1] The 'Routing' job has been cancelled 2018-08-16 11:00:25,722 INFO [store-001] [PushJob] [store-001-pull-default-1] The 'Push' job has been cancelled 2018-08-16 11:00:25,722 INFO [store-001] [PullJob] [store-001-pull-default-1] The 'Pull' job has been cancelled 2018-08-16 11:00:25,722 INFO [store-001] [OutgoingPurgeJob] [store-001-pull-default-1] The 'Purge Outgoing' job has been cancelled 2018-08-16 11:00:25,722 INFO [store-001] [IncomingPurgeJob] [store-001-pull-default-1] The 'Purge Incoming' job has been cancelled 2018-08-16 11:00:25,722 INFO [store-001] [StatisticFlushJob] [store-001-pull-default-1] The 'Stat Flush' job has been cancelled 2018-08-16 11:00:25,723 INFO [store-001] [SyncTriggersJob] [store-001-pull-default-1] The 'SyncTriggers' job has been cancelled 2018-08-16 11:00:25,723 INFO [store-001] [HeartbeatJob] [store-001-pull-default-1] The 'Heartbeat' job has been cancelled 2018-08-16 11:00:25,723 INFO [store-001] [WatchdogJob] [store-001-pull-default-1] The 'Watchdog' job has been cancelled 2018-08-16 11:00:25,723 INFO [store-001] [StageManagementJob] [store-001-pull-default-1] The 'Stage Management' job has been cancelled 2018-08-16 11:00:25,723 INFO [store-001] [InitialLoadExtractorJob] [store-001-pull-default-1] The 'Initial Load Extract' job has been cancelled 2018-08-16 11:00:25,723 INFO [store-001] [MonitorJob] [store-001-pull-default-1] The 'Monitor' job has been cancelled 2018-08-16 11:00:25,724 INFO [store-001] [RouterJob] [store-001-pull-default-1] Starting Routing on periodic schedule: every 10000ms with the first run at Thu Aug 16 11:00:42 EDT 2018 2018-08-16 11:00:25,724 INFO [store-001] [PushJob] [store-001-pull-default-1] Starting Push on periodic schedule: every 10000ms with the first run at Thu Aug 16 11:00:33 EDT 2018 2018-08-16 11:00:25,725 INFO [store-001] [PullJob] [store-001-pull-default-1] Starting Pull on periodic schedule: every 10000ms with the first run at Thu Aug 16 11:00:33 EDT 2018 2018-08-16 11:00:25,725 INFO [store-001] [OutgoingPurgeJob] [store-001-pull-default-1] Starting job 'Purge Outgoing' with cron expression: '0 0 0 * * *' 2018-08-16 11:00:25,725 INFO [store-001] [IncomingPurgeJob] [store-001-pull-default-1] Starting job 'Purge Incoming' with cron expression: '0 0 0 * * *' 2018-08-16 11:00:25,725 INFO [store-001] [StatisticFlushJob] [store-001-pull-default-1] Starting job 'Stat Flush' with cron expression: '0 0/5 * * * *' 2018-08-16 11:00:25,726 INFO [store-001] [SyncTriggersJob] [store-001-pull-default-1] Starting job 'SyncTriggers' with cron expression: '0 0 0 * * *' 2018-08-16 11:00:25,726 INFO [store-001] [HeartbeatJob] [store-001-pull-default-1] Starting Heartbeat on periodic schedule: every 900000ms with the first run at Thu Aug 16 11:15:00 EDT 2018 2018-08-16 11:00:25,726 INFO [store-001] [WatchdogJob] [store-001-pull-default-1] Starting Watchdog on periodic schedule: every 3600000ms with the first run at Thu Aug 16 12:00:00 EDT 2018 2018-08-16 11:00:25,726 INFO [store-001] [StageManagementJob] [store-001-pull-default-1] Starting job 'Stage Management' with cron expression: '0 0 * * * *' 2018-08-16 11:00:25,727 INFO [store-001] [InitialLoadExtractorJob] [store-001-pull-default-1] Starting Initial Load Extract on periodic schedule: every 10000ms with the first run at Thu Aug 16 11:00:42 EDT 2018 2018-08-16 11:00:25,727 INFO [store-001] [MonitorJob] [store-001-pull-default-1] Starting Monitor on periodic schedule: every 60000ms with the first run at Thu Aug 16 11:01:32 EDT 2018 2018-08-16 11:00:25,727 INFO [store-001] [ConfigurationChangedDatabaseWriterFilter] [store-001-pull-default-1] About to syncTriggers because new configuration came through the data loader 2018-08-16 11:00:25,727 INFO [store-001] [TriggerRouterService] [store-001-pull-default-1] Synchronizing triggers 2018-08-16 11:00:25,784 INFO [store-001] [H2SymmetricDialect] [store-001-sync-triggers-1] Creating SYM_ON_I_FOR_SYM_TRNSFRM_TBL_STR trigger for PRO-STORE-001.PUBLIC.SYM_TRANSFORM_TABLE 2018-08-16 11:00:25,797 INFO [store-001] [H2SymmetricDialect] [store-001-sync-triggers-1] Creating SYM_ON_U_FOR_SYM_TRNSFRM_TBL_STR trigger for PRO-STORE-001.PUBLIC.SYM_TRANSFORM_TABLE 2018-08-16 11:00:25,810 INFO [store-001] [H2SymmetricDialect] [store-001-sync-triggers-1] Creating SYM_ON_D_FOR_SYM_TRNSFRM_TBL_STR trigger for PRO-STORE-001.PUBLIC.SYM_TRANSFORM_TABLE 2018-08-16 11:00:25,834 INFO [store-001] [H2SymmetricDialect] [store-001-sync-triggers-1] Creating SYM_ON_I_FOR_SYM_PRMTR_STR trigger for PRO-STORE-001.PUBLIC.SYM_PARAMETER 2018-08-16 11:00:25,844 INFO [store-001] [H2SymmetricDialect] [store-001-sync-triggers-1] Creating SYM_ON_U_FOR_SYM_PRMTR_STR trigger for PRO-STORE-001.PUBLIC.SYM_PARAMETER 2018-08-16 11:00:25,853 INFO [store-001] [H2SymmetricDialect] [store-001-sync-triggers-1] Creating SYM_ON_D_FOR_SYM_PRMTR_STR trigger for PRO-STORE-001.PUBLIC.SYM_PARAMETER 2018-08-16 11:00:25,870 INFO [store-001] [H2SymmetricDialect] [store-001-sync-triggers-1] Creating SYM_ON_I_FOR_SYM_FL_TRGGR_RTR_STR trigger for PRO-STORE-001.PUBLIC.SYM_FILE_TRIGGER_ROUTER 2018-08-16 11:00:25,877 INFO [store-001] [H2SymmetricDialect] [store-001-sync-triggers-1] Creating SYM_ON_U_FOR_SYM_FL_TRGGR_RTR_STR trigger for PRO-STORE-001.PUBLIC.SYM_FILE_TRIGGER_ROUTER 2018-08-16 11:00:25,887 INFO [store-001] [H2SymmetricDialect] [store-001-sync-triggers-1] Creating SYM_ON_D_FOR_SYM_FL_TRGGR_RTR_STR trigger for PRO-STORE-001.PUBLIC.SYM_FILE_TRIGGER_ROUTER 2018-08-16 11:00:25,909 INFO [store-001] [H2SymmetricDialect] [store-001-sync-triggers-1] Creating SYM_ON_I_FOR_SYM_CNSL_SR_HST_STR trigger for PRO-STORE-001.PUBLIC.SYM_CONSOLE_USER_HIST 2018-08-16 11:00:25,918 INFO [store-001] [H2SymmetricDialect] [store-001-sync-triggers-1] Creating SYM_ON_U_FOR_SYM_CNSL_SR_HST_STR trigger for PRO-STORE-001.PUBLIC.SYM_CONSOLE_USER_HIST 2018-08-16 11:00:25,926 INFO [store-001] [H2SymmetricDialect] [store-001-sync-triggers-1] Creating SYM_ON_D_FOR_SYM_CNSL_SR_HST_STR trigger for PRO-STORE-001.PUBLIC.SYM_CONSOLE_USER_HIST 2018-08-16 11:00:25,950 INFO [store-001] [H2SymmetricDialect] [store-001-sync-triggers-1] Creating SYM_ON_I_FOR_SYM_TBL_RLD_RQST_STR trigger for PRO-STORE-001.PUBLIC.SYM_TABLE_RELOAD_REQUEST 2018-08-16 11:00:25,965 INFO [store-001] [H2SymmetricDialect] [store-001-sync-triggers-1] Creating SYM_ON_U_FOR_SYM_TBL_RLD_RQST_STR trigger for PRO-STORE-001.PUBLIC.SYM_TABLE_RELOAD_REQUEST 2018-08-16 11:00:25,976 INFO [store-001] [H2SymmetricDialect] [store-001-sync-triggers-1] Creating SYM_ON_D_FOR_SYM_TBL_RLD_RQST_STR trigger for PRO-STORE-001.PUBLIC.SYM_TABLE_RELOAD_REQUEST 2018-08-16 11:00:26,022 INFO [store-001] [H2SymmetricDialect] [store-001-sync-triggers-1] Creating SYM_ON_I_FOR_SYM_GRPLT_LNK_STR trigger for PRO-STORE-001.PUBLIC.SYM_GROUPLET_LINK 2018-08-16 11:00:26,033 INFO [store-001] [H2SymmetricDialect] [store-001-sync-triggers-1] Creating SYM_ON_U_FOR_SYM_GRPLT_LNK_STR trigger for PRO-STORE-001.PUBLIC.SYM_GROUPLET_LINK 2018-08-16 11:00:26,039 INFO [store-001] [H2SymmetricDialect] [store-001-sync-triggers-1] Creating SYM_ON_D_FOR_SYM_GRPLT_LNK_STR trigger for PRO-STORE-001.PUBLIC.SYM_GROUPLET_LINK 2018-08-16 11:00:26,066 INFO [store-001] [H2SymmetricDialect] [store-001-sync-triggers-1] Creating SYM_ON_I_FOR_SYM_GRPLT_STR trigger for PRO-STORE-001.PUBLIC.SYM_GROUPLET 2018-08-16 11:00:26,075 INFO [store-001] [H2SymmetricDialect] [store-001-sync-triggers-1] Creating SYM_ON_U_FOR_SYM_GRPLT_STR trigger for PRO-STORE-001.PUBLIC.SYM_GROUPLET 2018-08-16 11:00:26,083 INFO [store-001] [H2SymmetricDialect] [store-001-sync-triggers-1] Creating SYM_ON_D_FOR_SYM_GRPLT_STR trigger for PRO-STORE-001.PUBLIC.SYM_GROUPLET 2018-08-16 11:00:26,113 INFO [store-001] [H2SymmetricDialect] [store-001-sync-triggers-1] Creating SYM_ON_I_FOR_SYM_FL_TRGGR_STR trigger for PRO-STORE-001.PUBLIC.SYM_FILE_TRIGGER 2018-08-16 11:00:26,126 INFO [store-001] [H2SymmetricDialect] [store-001-sync-triggers-1] Creating SYM_ON_U_FOR_SYM_FL_TRGGR_STR trigger for PRO-STORE-001.PUBLIC.SYM_FILE_TRIGGER 2018-08-16 11:00:26,138 INFO [store-001] [H2SymmetricDialect] [store-001-sync-triggers-1] Creating SYM_ON_D_FOR_SYM_FL_TRGGR_STR trigger for PRO-STORE-001.PUBLIC.SYM_FILE_TRIGGER 2018-08-16 11:00:26,155 INFO [store-001] [H2SymmetricDialect] [store-001-sync-triggers-1] Creating SYM_ON_I_FOR_SYM_TRNSFRM_CLMN_STR trigger for PRO-STORE-001.PUBLIC.SYM_TRANSFORM_COLUMN 2018-08-16 11:00:26,162 INFO [store-001] [H2SymmetricDialect] [store-001-sync-triggers-1] Creating SYM_ON_U_FOR_SYM_TRNSFRM_CLMN_STR trigger for PRO-STORE-001.PUBLIC.SYM_TRANSFORM_COLUMN 2018-08-16 11:00:26,171 INFO [store-001] [H2SymmetricDialect] [store-001-sync-triggers-1] Creating SYM_ON_D_FOR_SYM_TRNSFRM_CLMN_STR trigger for PRO-STORE-001.PUBLIC.SYM_TRANSFORM_COLUMN 2018-08-16 11:00:26,192 INFO [store-001] [H2SymmetricDialect] [store-001-sync-triggers-1] Creating SYM_ON_I_FOR_SYM_JB_STR trigger for PRO-STORE-001.PUBLIC.SYM_JOB 2018-08-16 11:00:26,201 INFO [store-001] [H2SymmetricDialect] [store-001-sync-triggers-1] Creating SYM_ON_U_FOR_SYM_JB_STR trigger for PRO-STORE-001.PUBLIC.SYM_JOB 2018-08-16 11:00:26,210 INFO [store-001] [H2SymmetricDialect] [store-001-sync-triggers-1] Creating SYM_ON_D_FOR_SYM_JB_STR trigger for PRO-STORE-001.PUBLIC.SYM_JOB 2018-08-16 11:00:26,232 INFO [store-001] [H2SymmetricDialect] [store-001-sync-triggers-1] Creating SYM_ON_I_FOR_SYM_TRGGR_RTR_STR trigger for PRO-STORE-001.PUBLIC.SYM_TRIGGER_ROUTER 2018-08-16 11:00:26,242 INFO [store-001] [H2SymmetricDialect] [store-001-sync-triggers-1] Creating SYM_ON_U_FOR_SYM_TRGGR_RTR_STR trigger for PRO-STORE-001.PUBLIC.SYM_TRIGGER_ROUTER 2018-08-16 11:00:26,254 INFO [store-001] [H2SymmetricDialect] [store-001-sync-triggers-1] Creating SYM_ON_D_FOR_SYM_TRGGR_RTR_STR trigger for PRO-STORE-001.PUBLIC.SYM_TRIGGER_ROUTER 2018-08-16 11:00:26,270 INFO [store-001] [H2SymmetricDialect] [store-001-sync-triggers-1] Creating SYM_ON_I_FOR_SYM_ND_STR trigger for PRO-STORE-001.PUBLIC.SYM_NODE 2018-08-16 11:00:26,280 INFO [store-001] [H2SymmetricDialect] [store-001-sync-triggers-1] Creating SYM_ON_U_FOR_SYM_ND_STR trigger for PRO-STORE-001.PUBLIC.SYM_NODE 2018-08-16 11:00:26,290 INFO [store-001] [H2SymmetricDialect] [store-001-sync-triggers-1] Creating SYM_ON_D_FOR_SYM_ND_STR trigger for PRO-STORE-001.PUBLIC.SYM_NODE 2018-08-16 11:00:26,318 INFO [store-001] [H2SymmetricDialect] [store-001-sync-triggers-1] Creating SYM_ON_I_FOR_SYM_ND_GRP_CHNNL_WND_STR trigger for PRO-STORE-001.PUBLIC.SYM_NODE_GROUP_CHANNEL_WND 2018-08-16 11:00:26,326 INFO [store-001] [H2SymmetricDialect] [store-001-sync-triggers-1] Creating SYM_ON_U_FOR_SYM_ND_GRP_CHNNL_WND_STR trigger for PRO-STORE-001.PUBLIC.SYM_NODE_GROUP_CHANNEL_WND 2018-08-16 11:00:26,333 INFO [store-001] [H2SymmetricDialect] [store-001-sync-triggers-1] Creating SYM_ON_D_FOR_SYM_ND_GRP_CHNNL_WND_STR trigger for PRO-STORE-001.PUBLIC.SYM_NODE_GROUP_CHANNEL_WND 2018-08-16 11:00:26,366 INFO [store-001] [H2SymmetricDialect] [store-001-sync-triggers-1] Creating SYM_ON_I_FOR_SYM_NTFCTN_STR trigger for PRO-STORE-001.PUBLIC.SYM_NOTIFICATION 2018-08-16 11:00:26,374 INFO [store-001] [H2SymmetricDialect] [store-001-sync-triggers-1] Creating SYM_ON_U_FOR_SYM_NTFCTN_STR trigger for PRO-STORE-001.PUBLIC.SYM_NOTIFICATION 2018-08-16 11:00:26,383 INFO [store-001] [H2SymmetricDialect] [store-001-sync-triggers-1] Creating SYM_ON_D_FOR_SYM_NTFCTN_STR trigger for PRO-STORE-001.PUBLIC.SYM_NOTIFICATION 2018-08-16 11:00:26,432 INFO [store-001] [H2SymmetricDialect] [store-001-sync-triggers-1] Creating SYM_ON_I_FOR_SYM_ND_GRP_LNK_STR trigger for PRO-STORE-001.PUBLIC.SYM_NODE_GROUP_LINK 2018-08-16 11:00:26,446 INFO [store-001] [H2SymmetricDialect] [store-001-sync-triggers-1] Creating SYM_ON_U_FOR_SYM_ND_GRP_LNK_STR trigger for PRO-STORE-001.PUBLIC.SYM_NODE_GROUP_LINK 2018-08-16 11:00:26,458 INFO [store-001] [H2SymmetricDialect] [store-001-sync-triggers-1] Creating SYM_ON_D_FOR_SYM_ND_GRP_LNK_STR trigger for PRO-STORE-001.PUBLIC.SYM_NODE_GROUP_LINK 2018-08-16 11:00:26,489 INFO [store-001] [H2SymmetricDialect] [store-001-sync-triggers-1] Creating SYM_ON_I_FOR_SYM_CNSL_SR_STR trigger for PRO-STORE-001.PUBLIC.SYM_CONSOLE_USER 2018-08-16 11:00:26,500 INFO [store-001] [H2SymmetricDialect] [store-001-sync-triggers-1] Creating SYM_ON_U_FOR_SYM_CNSL_SR_STR trigger for PRO-STORE-001.PUBLIC.SYM_CONSOLE_USER 2018-08-16 11:00:26,513 INFO [store-001] [H2SymmetricDialect] [store-001-sync-triggers-1] Creating SYM_ON_D_FOR_SYM_CNSL_SR_STR trigger for PRO-STORE-001.PUBLIC.SYM_CONSOLE_USER 2018-08-16 11:00:26,537 INFO [store-001] [H2SymmetricDialect] [store-001-sync-triggers-1] Creating SYM_ON_I_FOR_SYM_ND_GRP_STR trigger for PRO-STORE-001.PUBLIC.SYM_NODE_GROUP 2018-08-16 11:00:26,551 INFO [store-001] [H2SymmetricDialect] [store-001-sync-triggers-1] Creating SYM_ON_U_FOR_SYM_ND_GRP_STR trigger for PRO-STORE-001.PUBLIC.SYM_NODE_GROUP 2018-08-16 11:00:26,561 INFO [store-001] [H2SymmetricDialect] [store-001-sync-triggers-1] Creating SYM_ON_D_FOR_SYM_ND_GRP_STR trigger for PRO-STORE-001.PUBLIC.SYM_NODE_GROUP 2018-08-16 11:00:26,582 INFO [store-001] [H2SymmetricDialect] [store-001-sync-triggers-1] Creating SYM_ON_I_FOR_SYM_ND_SCRTY_STR trigger for PRO-STORE-001.PUBLIC.SYM_NODE_SECURITY 2018-08-16 11:00:26,592 INFO [store-001] [H2SymmetricDialect] [store-001-sync-triggers-1] Creating SYM_ON_U_FOR_SYM_ND_SCRTY_STR trigger for PRO-STORE-001.PUBLIC.SYM_NODE_SECURITY 2018-08-16 11:00:26,605 INFO [store-001] [H2SymmetricDialect] [store-001-sync-triggers-1] Creating SYM_ON_D_FOR_SYM_ND_SCRTY_STR trigger for PRO-STORE-001.PUBLIC.SYM_NODE_SECURITY 2018-08-16 11:00:26,630 INFO [store-001] [H2SymmetricDialect] [store-001-sync-triggers-1] Creating SYM_ON_I_FOR_SYM_LD_FLTR_STR trigger for PRO-STORE-001.PUBLIC.SYM_LOAD_FILTER 2018-08-16 11:00:26,641 INFO [store-001] [H2SymmetricDialect] [store-001-sync-triggers-1] Creating SYM_ON_U_FOR_SYM_LD_FLTR_STR trigger for PRO-STORE-001.PUBLIC.SYM_LOAD_FILTER 2018-08-16 11:00:26,652 INFO [store-001] [H2SymmetricDialect] [store-001-sync-triggers-1] Creating SYM_ON_D_FOR_SYM_LD_FLTR_STR trigger for PRO-STORE-001.PUBLIC.SYM_LOAD_FILTER 2018-08-16 11:00:26,679 INFO [store-001] [H2SymmetricDialect] [store-001-sync-triggers-1] Creating SYM_ON_I_FOR_SYM_MNTR_STR trigger for PRO-STORE-001.PUBLIC.SYM_MONITOR 2018-08-16 11:00:26,687 INFO [store-001] [H2SymmetricDialect] [store-001-sync-triggers-1] Creating SYM_ON_U_FOR_SYM_MNTR_STR trigger for PRO-STORE-001.PUBLIC.SYM_MONITOR 2018-08-16 11:00:26,696 INFO [store-001] [H2SymmetricDialect] [store-001-sync-triggers-1] Creating SYM_ON_D_FOR_SYM_MNTR_STR trigger for PRO-STORE-001.PUBLIC.SYM_MONITOR 2018-08-16 11:00:26,720 INFO [store-001] [H2SymmetricDialect] [store-001-sync-triggers-1] Creating SYM_ON_I_FOR_SYM_XTNSN_STR trigger for PRO-STORE-001.PUBLIC.SYM_EXTENSION 2018-08-16 11:00:26,729 INFO [store-001] [H2SymmetricDialect] [store-001-sync-triggers-1] Creating SYM_ON_U_FOR_SYM_XTNSN_STR trigger for PRO-STORE-001.PUBLIC.SYM_EXTENSION 2018-08-16 11:00:26,738 INFO [store-001] [H2SymmetricDialect] [store-001-sync-triggers-1] Creating SYM_ON_D_FOR_SYM_XTNSN_STR trigger for PRO-STORE-001.PUBLIC.SYM_EXTENSION 2018-08-16 11:00:26,761 INFO [store-001] [H2SymmetricDialect] [store-001-sync-triggers-1] Creating SYM_ON_I_FOR_SYM_CNFLCT_STR trigger for PRO-STORE-001.PUBLIC.SYM_CONFLICT 2018-08-16 11:00:26,773 INFO [store-001] [H2SymmetricDialect] [store-001-sync-triggers-1] Creating SYM_ON_U_FOR_SYM_CNFLCT_STR trigger for PRO-STORE-001.PUBLIC.SYM_CONFLICT 2018-08-16 11:00:26,782 INFO [store-001] [H2SymmetricDialect] [store-001-sync-triggers-1] Creating SYM_ON_D_FOR_SYM_CNFLCT_STR trigger for PRO-STORE-001.PUBLIC.SYM_CONFLICT 2018-08-16 11:00:26,801 INFO [store-001] [H2SymmetricDialect] [store-001-sync-triggers-1] Creating SYM_ON_I_FOR_SYM_TRGGR_STR trigger for PRO-STORE-001.PUBLIC.SYM_TRIGGER 2018-08-16 11:00:26,821 INFO [store-001] [H2SymmetricDialect] [store-001-sync-triggers-1] Creating SYM_ON_U_FOR_SYM_TRGGR_STR trigger for PRO-STORE-001.PUBLIC.SYM_TRIGGER 2018-08-16 11:00:26,836 INFO [store-001] [H2SymmetricDialect] [store-001-sync-triggers-1] Creating SYM_ON_D_FOR_SYM_TRGGR_STR trigger for PRO-STORE-001.PUBLIC.SYM_TRIGGER 2018-08-16 11:00:26,859 INFO [store-001] [H2SymmetricDialect] [store-001-sync-triggers-1] Creating SYM_ON_I_FOR_SYM_CHNNL_STR trigger for PRO-STORE-001.PUBLIC.SYM_CHANNEL 2018-08-16 11:00:26,869 INFO [store-001] [H2SymmetricDialect] [store-001-sync-triggers-1] Creating SYM_ON_U_FOR_SYM_CHNNL_STR trigger for PRO-STORE-001.PUBLIC.SYM_CHANNEL 2018-08-16 11:00:26,883 INFO [store-001] [H2SymmetricDialect] [store-001-sync-triggers-1] Creating SYM_ON_D_FOR_SYM_CHNNL_STR trigger for PRO-STORE-001.PUBLIC.SYM_CHANNEL 2018-08-16 11:00:26,905 INFO [store-001] [H2SymmetricDialect] [store-001-sync-triggers-1] Creating SYM_ON_I_FOR_SYM_TRGGR_RTR_GRPLT_STR trigger for PRO-STORE-001.PUBLIC.SYM_TRIGGER_ROUTER_GROUPLET 2018-08-16 11:00:26,912 INFO [store-001] [H2SymmetricDialect] [store-001-sync-triggers-1] Creating SYM_ON_U_FOR_SYM_TRGGR_RTR_GRPLT_STR trigger for PRO-STORE-001.PUBLIC.SYM_TRIGGER_ROUTER_GROUPLET 2018-08-16 11:00:26,921 INFO [store-001] [H2SymmetricDialect] [store-001-sync-triggers-1] Creating SYM_ON_D_FOR_SYM_TRGGR_RTR_GRPLT_STR trigger for PRO-STORE-001.PUBLIC.SYM_TRIGGER_ROUTER_GROUPLET 2018-08-16 11:00:26,943 INFO [store-001] [H2SymmetricDialect] [store-001-sync-triggers-1] Creating SYM_ON_I_FOR_SYM_ND_HST_STR trigger for PRO-STORE-001.PUBLIC.SYM_NODE_HOST 2018-08-16 11:00:26,958 INFO [store-001] [H2SymmetricDialect] [store-001-sync-triggers-1] Creating SYM_ON_U_FOR_SYM_ND_HST_STR trigger for PRO-STORE-001.PUBLIC.SYM_NODE_HOST 2018-08-16 11:00:26,973 INFO [store-001] [H2SymmetricDialect] [store-001-sync-triggers-1] Creating SYM_ON_D_FOR_SYM_ND_HST_STR trigger for PRO-STORE-001.PUBLIC.SYM_NODE_HOST 2018-08-16 11:00:26,982 INFO [store-001] [TriggerRouterService] [store-001-pull-default-1] Done synchronizing triggers 2018-08-16 11:00:26,995 INFO [store-001] [PullService] [store-001-pull-default-1] Pull data received from corp:000:000 on queue default. 68 rows and 1 batches were processed. (sym_console_user_hist, sym_console_user, sym_console_event, sym_job, sym_notification, sym_monitor, sym_extension, sym_node_identity, sym_file_trigger_router, sym_file_trigger, sym_trigger_router_grouplet, sym_grouplet_link, sym_grouplet, sym_table_reload_request, sym_conflict, sym_transform_column, sym_load_filter, sym_transform_table, sym_trigger_router, sym_router, sym_trigger, sym_node_group_channel_wnd, sym_channel, sym_parameter, sym_node_security, sym_node_host, sym_node, sym_node_group_link, sym_...) 2018-08-16 11:00:33,161 INFO [store-001] [PullService] [store-001-pull-default-2] Pull data received from corp:000:000 on queue default. 1 rows and 1 batches were processed. (sym_node) 2018-08-16 11:00:42,420 INFO [store-001] [RouterService] [store-001-job-19] The 'config' channel is NOT in common batch mode 2018-08-16 11:00:42,505 INFO [store-001] [ConfigurationChangedDataRouter] [store-001-job-19] About to refresh the cache of nodes because new configuration came through the data router 2018-08-16 11:00:42,506 INFO [store-001] [RouterService] [store-001-job-19] Routed 5 data events in 89 ms 2018-08-16 11:03:33,658 INFO [store-001] [PullService] [store-001-pull-default-10] Could not communicate with corp:000:000 at http://localhost:31000/sync/corp-000 because: Connection refused (Connection refused)