2018-10-12 10:50:28,859 INFO [startup] [AbstractCommandLauncher] [main] Option: name=max-idle-time, value={90000} 2018-10-12 10:50:28,860 INFO [startup] [AbstractCommandLauncher] [main] Option: name=no-log-console, value={} 2018-10-12 10:50:28,931 INFO [startup] [SymmetricUtils] [main] _____ __ _ ____ _____ / ___/ __ _____ __ ___ __ ___ _/ /_ ____(_)___ / __ | / ___/ \__ \ / / / / _ `_ \/ _ `_ \/ _ \/_ __// __/ / __/ / / / / \__ \ ___/ // /_/ / // // / // // / __// / / / / / /_ / /_/ / ___/ / /____/ \__ /_//_//_/_//_//_/\___/ \_/ /_/ /_/\__/ /_____/ /____/ /____/ +-----------------------------------------------------------------+ | Copyright (C) 2007-2018 JumpMind, Inc. | | | | Licensed under the GNU General Public License version 3. | | This software comes with ABSOLUTELY NO WARRANTY. | | See http://www.gnu.org/licenses/gpl.html | +-----------------------------------------------------------------+ 2018-10-12 10:50:28,976 INFO [startup] [SymmetricWebServer] [main] About to start SymmetricDS web server on host:port 0.0.0.0:31415 2018-10-12 10:50:29,495 INFO [MSSQL01] [AbstractSymmetricEngine] [symmetric-engine-startup-2] Initializing connection to database 2018-10-12 10:50:29,495 INFO [MYSQL01] [AbstractSymmetricEngine] [symmetric-engine-startup-1] Initializing connection to database 2018-10-12 10:50:29,669 INFO [MSSQL01] [JdbcDatabasePlatformFactory] [symmetric-engine-startup-2] Detected database 'Microsoft SQL Server', version '12', protocol 'jtds' 2018-10-12 10:50:29,687 INFO [MSSQL01] [JdbcDatabasePlatformFactory] [symmetric-engine-startup-2] The IDatabasePlatform being used is org.jumpmind.db.platform.mssql.MsSql2008DatabasePlatform 2018-10-12 10:50:29,844 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] The DbDialect being used is org.jumpmind.symmetric.db.mssql.MsSqlSymmetricDialect 2018-10-12 10:50:29,879 INFO [MSSQL01] [StagingManager] [symmetric-engine-startup-2] The staging directory was initialized at the following location: tmp/MSSQL01 2018-10-12 10:50:29,960 INFO [MYSQL01] [JdbcDatabasePlatformFactory] [symmetric-engine-startup-1] Detected database 'MySQL', version '8', protocol 'mysql' 2018-10-12 10:50:29,963 INFO [MYSQL01] [JdbcDatabasePlatformFactory] [symmetric-engine-startup-1] The IDatabasePlatform being used is org.jumpmind.db.platform.mysql.MySqlDatabasePlatform 2018-10-12 10:50:29,991 INFO [MYSQL01] [MySqlSymmetricDialect] [symmetric-engine-startup-1] The DbDialect being used is org.jumpmind.symmetric.db.mysql.MySqlSymmetricDialect 2018-10-12 10:50:30,000 INFO [MYSQL01] [StagingManager] [symmetric-engine-startup-1] The staging directory was initialized at the following location: tmp/MYSQL01 2018-10-12 10:50:30,650 INFO [MYSQL01] [ClientExtensionService] [symmetric-engine-startup-1] Found 7 extension points from spring that will be registered 2018-10-12 10:50:30,655 INFO [MSSQL01] [ClientExtensionService] [symmetric-engine-startup-2] Found 7 extension points from spring that will be registered 2018-10-12 10:50:30,663 INFO [MYSQL01] [AbstractSymmetricEngine] [symmetric-engine-startup-1] Initializing SymmetricDS database 2018-10-12 10:50:30,663 INFO [MYSQL01] [MySqlSymmetricDialect] [symmetric-engine-startup-1] Checking if SymmetricDS tables need created or altered 2018-10-12 10:50:30,665 INFO [MSSQL01] [AbstractSymmetricEngine] [symmetric-engine-startup-2] Initializing SymmetricDS database 2018-10-12 10:50:30,665 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] Checking if SymmetricDS tables need created or altered 2018-10-12 10:50:30,997 INFO [MYSQL01] [MySqlSymmetricDialect] [symmetric-engine-startup-1] There are SymmetricDS tables that needed altered 2018-10-12 10:50:31,071 INFO [startup] [SymmetricWebServer] [main] Starting JMX HTTP console on port 31416 2018-10-12 10:50:31,072 INFO [MYSQL01] [MySqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE `sym_channel`( `channel_id` VARCHAR(128) NOT NULL, `processing_order` INTEGER DEFAULT 1 NOT NULL, `max_batch_size` INTEGER DEFAULT 1000 NOT NULL, `max_batch_to_send` INTEGER DEFAULT 60 NOT NULL, `max_data_to_route` INTEGER DEFAULT 100000 NOT NULL, `extract_period_millis` INTEGER DEFAULT 0 NOT NULL, `enabled` SMALLINT DEFAULT 1 NOT NULL, `use_old_data_to_route` SMALLINT DEFAULT 1 NOT NULL, `use_row_data_to_route` SMALLINT DEFAULT 1 NOT NULL, `use_pk_data_to_route` SMALLINT DEFAULT 1 NOT NULL, `reload_flag` SMALLINT DEFAULT 0 NOT NULL, `file_sync_flag` SMALLINT DEFAULT 0 NOT NULL, `contains_big_lob` SMALLINT DEFAULT 0 NOT NULL, `batch_algorithm` VARCHAR(50) DEFAULT 'default' NOT NULL, `data_loader_type` VARCHAR(50) DEFAULT 'default' NOT NULL, `description` VARCHAR(255) 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` DATETIME, `last_update_by` VARCHAR(50) NULL, `last_update_time` DATETIME, PRIMARY KEY (`channel_id`) ) 2018-10-12 10:50:31,081 INFO [MYSQL01] [MySqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE `sym_conflict`( `conflict_id` VARCHAR(50) NOT NULL, `source_node_group_id` VARCHAR(50) NOT NULL, `target_node_group_id` VARCHAR(50) NOT NULL, `target_channel_id` VARCHAR(128) 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` MEDIUMTEXT NULL, `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` DATETIME NOT NULL, `last_update_by` VARCHAR(50) NULL, `last_update_time` DATETIME NOT NULL, PRIMARY KEY (`conflict_id`) ) 2018-10-12 10:50:31,086 INFO [MYSQL01] [MySqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE `sym_context`( `name` VARCHAR(80) NOT NULL, `context_value` MEDIUMTEXT NULL, `create_time` DATETIME, `last_update_time` DATETIME, PRIMARY KEY (`name`) ) 2018-10-12 10:50:31,093 INFO [MYSQL01] [MySqlSymmetricDialect] [symmetric-engine-startup-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` MEDIUMTEXT NULL, `pk_data` MEDIUMTEXT NULL, `old_data` MEDIUMTEXT 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` DATETIME, PRIMARY KEY (`data_id`) ) 2018-10-12 10:50:31,093 INFO [startup] [SymmetricWebServer] [main] Joining the web server main thread 2018-10-12 10:50:31,103 INFO [MYSQL01] [MySqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE INDEX `sym_idx_d_channel_id` ON `sym_data` (`data_id`, `channel_id`) 2018-10-12 10:50:31,108 INFO [MYSQL01] [MySqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE `sym_data_event`( `data_id` BIGINT NOT NULL, `batch_id` BIGINT NOT NULL, `router_id` VARCHAR(50) NOT NULL, `create_time` DATETIME, PRIMARY KEY (`data_id`, `batch_id`, `router_id`) ) 2018-10-12 10:50:31,114 INFO [MYSQL01] [MySqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE INDEX `sym_idx_de_batchid` ON `sym_data_event` (`batch_id`) 2018-10-12 10:50:31,119 INFO [MYSQL01] [MySqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE `sym_data_gap`( `start_id` BIGINT NOT NULL, `end_id` BIGINT NOT NULL, `status` CHAR(2) NULL, `create_time` DATETIME NOT NULL, `last_update_hostname` VARCHAR(255) NULL, `last_update_time` DATETIME NOT NULL, PRIMARY KEY (`start_id`, `end_id`) ) 2018-10-12 10:50:31,125 INFO [MYSQL01] [MySqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE INDEX `sym_idx_dg_status` ON `sym_data_gap` (`status`) 2018-10-12 10:50:31,130 INFO [MYSQL01] [MySqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE `sym_extension`( `extension_id` VARCHAR(50) NOT NULL, `extension_type` VARCHAR(10) NOT NULL, `interface_name` VARCHAR(255) NULL, `node_group_id` VARCHAR(50) NOT NULL, `enabled` SMALLINT DEFAULT 1 NOT NULL, `extension_order` INTEGER DEFAULT 1 NOT NULL, `extension_text` MEDIUMTEXT NULL, `create_time` DATETIME, `last_update_by` VARCHAR(50) NULL, `last_update_time` DATETIME, PRIMARY KEY (`extension_id`) ) 2018-10-12 10:50:31,136 INFO [MYSQL01] [MySqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE `sym_extract_request`( `request_id` BIGINT NOT NULL, `node_id` VARCHAR(50) NOT NULL, `queue` VARCHAR(128) 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` DATETIME, `create_time` DATETIME, PRIMARY KEY (`request_id`) ) 2018-10-12 10:50:31,141 INFO [MYSQL01] [MySqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE `sym_file_incoming`( `relative_dir` VARCHAR(255) NOT NULL, `file_name` VARCHAR(128) NOT NULL, `last_event_type` CHAR(1) NOT NULL, `node_id` VARCHAR(50) NOT NULL, `file_modified_time` BIGINT, PRIMARY KEY (`relative_dir`, `file_name`) ) 2018-10-12 10:50:31,147 INFO [MYSQL01] [MySqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE `sym_file_snapshot`( `trigger_id` VARCHAR(128) NOT NULL, `router_id` VARCHAR(50) NOT NULL, `relative_dir` VARCHAR(255) NOT NULL, `file_name` VARCHAR(128) NOT NULL, `channel_id` VARCHAR(128) DEFAULT 'filesync' NOT NULL, `reload_channel_id` VARCHAR(128) DEFAULT 'filesync_reload' NOT NULL, `last_event_type` CHAR(1) NOT NULL, `crc32_checksum` BIGINT, `file_size` BIGINT, `file_modified_time` BIGINT, `last_update_time` DATETIME NOT NULL, `last_update_by` VARCHAR(50) NULL, `create_time` DATETIME NOT NULL, PRIMARY KEY (`trigger_id`, `router_id`, `relative_dir`, `file_name`) ) 2018-10-12 10:50:31,155 INFO [MYSQL01] [MySqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE INDEX `sym_idx_f_snpsht_chid` ON `sym_file_snapshot` (`reload_channel_id`) 2018-10-12 10:50:31,162 INFO [MYSQL01] [MySqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE `sym_file_trigger`( `trigger_id` VARCHAR(128) NOT NULL, `channel_id` VARCHAR(128) DEFAULT 'filesync' NOT NULL, `reload_channel_id` VARCHAR(128) DEFAULT 'filesync_reload' NOT NULL, `base_dir` VARCHAR(255) NOT NULL, `recurse` SMALLINT DEFAULT 1 NOT NULL, `includes_files` VARCHAR(255) NULL, `excludes_files` VARCHAR(255) NULL, `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` MEDIUMTEXT NULL, `after_copy_script` MEDIUMTEXT NULL, `create_time` DATETIME NOT NULL, `last_update_by` VARCHAR(50) NULL, `last_update_time` DATETIME NOT NULL, `description` MEDIUMTEXT NULL, PRIMARY KEY (`trigger_id`) ) 2018-10-12 10:50:31,168 INFO [MYSQL01] [MySqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE `sym_file_trigger_router`( `trigger_id` VARCHAR(128) NOT NULL, `router_id` VARCHAR(50) NOT NULL, `enabled` SMALLINT DEFAULT 1 NOT NULL, `initial_load_enabled` SMALLINT DEFAULT 1 NOT NULL, `target_base_dir` VARCHAR(255) NULL, `conflict_strategy` VARCHAR(128) DEFAULT 'source_wins' NOT NULL, `create_time` DATETIME NOT NULL, `last_update_by` VARCHAR(50) NULL, `last_update_time` DATETIME NOT NULL, `description` MEDIUMTEXT NULL, PRIMARY KEY (`trigger_id`, `router_id`) ) 2018-10-12 10:50:31,174 INFO [MYSQL01] [MySqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE `sym_grouplet`( `grouplet_id` VARCHAR(50) NOT NULL, `grouplet_link_policy` CHAR(1) DEFAULT 'I' NOT NULL, `description` VARCHAR(255) NULL, `create_time` DATETIME NOT NULL, `last_update_by` VARCHAR(50) NULL, `last_update_time` DATETIME NOT NULL, PRIMARY KEY (`grouplet_id`) ) 2018-10-12 10:50:31,178 INFO [MYSQL01] [MySqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE `sym_grouplet_link`( `grouplet_id` VARCHAR(50) NOT NULL, `external_id` VARCHAR(255) NOT NULL, `create_time` DATETIME NOT NULL, `last_update_by` VARCHAR(50) NULL, `last_update_time` DATETIME NOT NULL, PRIMARY KEY (`grouplet_id`, `external_id`) ) 2018-10-12 10:50:31,189 INFO [MYSQL01] [MySqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE `sym_incoming_batch`( `batch_id` BIGINT NOT NULL, `node_id` VARCHAR(50) NOT NULL, `channel_id` VARCHAR(128) NULL, `status` CHAR(2) NULL, `error_flag` SMALLINT DEFAULT 0, `sql_state` VARCHAR(10) NULL, `sql_code` INTEGER DEFAULT 0 NOT NULL, `sql_message` MEDIUMTEXT NULL, `last_update_hostname` VARCHAR(255) NULL, `last_update_time` DATETIME, `create_time` DATETIME, `summary` VARCHAR(255) NULL, `ignore_count` INTEGER DEFAULT 0 NOT NULL, `byte_count` BIGINT DEFAULT 0 NOT NULL, `load_flag` SMALLINT DEFAULT 0, `extract_count` INTEGER DEFAULT 0 NOT NULL, `sent_count` INTEGER DEFAULT 0 NOT NULL, `load_count` INTEGER DEFAULT 0 NOT NULL, `reload_row_count` INTEGER DEFAULT 0 NOT NULL, `other_row_count` INTEGER DEFAULT 0 NOT NULL, `data_row_count` INTEGER DEFAULT 0 NOT NULL, `extract_row_count` INTEGER DEFAULT 0 NOT NULL, `load_row_count` INTEGER DEFAULT 0 NOT NULL, `data_insert_row_count` INTEGER DEFAULT 0 NOT NULL, `data_update_row_count` INTEGER DEFAULT 0 NOT NULL, `data_delete_row_count` INTEGER DEFAULT 0 NOT NULL, `extract_insert_row_count` INTEGER DEFAULT 0 NOT NULL, `extract_update_row_count` INTEGER DEFAULT 0 NOT NULL, `extract_delete_row_count` INTEGER DEFAULT 0 NOT NULL, `load_insert_row_count` INTEGER DEFAULT 0 NOT NULL, `load_update_row_count` INTEGER DEFAULT 0 NOT NULL, `load_delete_row_count` INTEGER DEFAULT 0 NOT NULL, `network_millis` INTEGER DEFAULT 0 NOT NULL, `filter_millis` INTEGER DEFAULT 0 NOT NULL, `load_millis` INTEGER DEFAULT 0 NOT NULL, `router_millis` INTEGER DEFAULT 0 NOT NULL, `extract_millis` INTEGER DEFAULT 0 NOT NULL, `transform_extract_millis` INTEGER DEFAULT 0 NOT NULL, `transform_load_millis` INTEGER DEFAULT 0 NOT NULL, `load_id` BIGINT, `common_flag` SMALLINT DEFAULT 0, `fallback_insert_count` INTEGER DEFAULT 0 NOT NULL, `fallback_update_count` INTEGER DEFAULT 0 NOT NULL, `ignore_row_count` INTEGER DEFAULT 0 NOT NULL, `missing_delete_count` INTEGER DEFAULT 0 NOT NULL, `skip_count` INTEGER DEFAULT 0 NOT NULL, `failed_row_number` INTEGER DEFAULT 0 NOT NULL, `failed_line_number` INTEGER DEFAULT 0 NOT NULL, `failed_data_id` BIGINT DEFAULT 0 NOT NULL, PRIMARY KEY (`batch_id`, `node_id`) ) 2018-10-12 10:50:31,208 INFO [MYSQL01] [MySqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE INDEX `sym_idx_ib_time_status` ON `sym_incoming_batch` (`create_time`, `status`) 2018-10-12 10:50:31,222 INFO [MYSQL01] [MySqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE INDEX `sym_idx_ib_in_error` ON `sym_incoming_batch` (`error_flag`) 2018-10-12 10:50:31,230 INFO [MYSQL01] [MySqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE `sym_incoming_error`( `batch_id` BIGINT NOT NULL, `node_id` VARCHAR(50) NOT NULL, `failed_row_number` BIGINT NOT NULL, `failed_line_number` BIGINT DEFAULT 0 NOT NULL, `target_catalog_name` VARCHAR(255) 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` MEDIUMTEXT NOT NULL, `pk_column_names` MEDIUMTEXT NOT NULL, `row_data` MEDIUMTEXT NULL, `old_data` MEDIUMTEXT NULL, `cur_data` MEDIUMTEXT NULL, `resolve_data` MEDIUMTEXT NULL, `resolve_ignore` SMALLINT DEFAULT 0, `conflict_id` VARCHAR(50) NULL, `create_time` DATETIME, `last_update_by` VARCHAR(50) NULL, `last_update_time` DATETIME NOT NULL, PRIMARY KEY (`batch_id`, `node_id`, `failed_row_number`) ) 2018-10-12 10:50:31,236 INFO [MYSQL01] [MySqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE `sym_job`( `job_name` VARCHAR(50) NOT NULL, `job_type` VARCHAR(10) NOT NULL, `requires_registration` SMALLINT DEFAULT 1 NOT NULL, `job_expression` MEDIUMTEXT NULL, `description` VARCHAR(255) NULL, `default_schedule` VARCHAR(50) NULL, `default_auto_start` SMALLINT DEFAULT 1 NOT NULL, `node_group_id` VARCHAR(50) NOT NULL, `create_by` VARCHAR(50) NULL, `create_time` DATETIME, `last_update_by` VARCHAR(50) NULL, `last_update_time` DATETIME, PRIMARY KEY (`job_name`) ) 2018-10-12 10:50:31,244 INFO [MYSQL01] [MySqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE `sym_load_filter`( `load_filter_id` VARCHAR(50) NOT NULL, `load_filter_type` VARCHAR(10) NOT NULL, `source_node_group_id` VARCHAR(50) NOT NULL, `target_node_group_id` VARCHAR(50) NOT NULL, `target_catalog_name` VARCHAR(255) NULL, `target_schema_name` VARCHAR(255) NULL, `target_table_name` VARCHAR(255) NULL, `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` MEDIUMTEXT NULL, `after_write_script` MEDIUMTEXT NULL, `batch_complete_script` MEDIUMTEXT NULL, `batch_commit_script` MEDIUMTEXT NULL, `batch_rollback_script` MEDIUMTEXT NULL, `handle_error_script` MEDIUMTEXT NULL, `create_time` DATETIME NOT NULL, `last_update_by` VARCHAR(50) NULL, `last_update_time` DATETIME NOT NULL, `load_filter_order` INTEGER DEFAULT 1 NOT NULL, `fail_on_error` SMALLINT DEFAULT 0 NOT NULL, PRIMARY KEY (`load_filter_id`) ) 2018-10-12 10:50:31,249 INFO [MYSQL01] [MySqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE `sym_lock`( `lock_action` VARCHAR(50) NOT NULL, `lock_type` VARCHAR(50) NOT NULL, `locking_server_id` VARCHAR(255) NULL, `lock_time` DATETIME, `shared_count` INTEGER DEFAULT 0 NOT NULL, `shared_enable` INTEGER DEFAULT 0 NOT NULL, `last_lock_time` DATETIME, `last_locking_server_id` VARCHAR(255) NULL, PRIMARY KEY (`lock_action`) ) 2018-10-12 10:50:31,255 INFO [MYSQL01] [MySqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE `sym_node`( `node_id` VARCHAR(50) NOT NULL, `node_group_id` VARCHAR(50) NOT NULL, `external_id` VARCHAR(255) NOT NULL, `heartbeat_time` DATETIME, `timezone_offset` VARCHAR(6) NULL, `sync_enabled` SMALLINT 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-10-12 10:50:31,261 INFO [MYSQL01] [MySqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE `sym_node_communication`( `node_id` VARCHAR(50) NOT NULL, `queue` VARCHAR(25) DEFAULT 'default' NOT NULL, `communication_type` VARCHAR(10) NOT NULL, `lock_time` DATETIME, `locking_server_id` VARCHAR(255) NULL, `last_lock_time` DATETIME, `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-10-12 10:50:31,266 INFO [MYSQL01] [MySqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE `sym_node_channel_ctl`( `node_id` VARCHAR(50) NOT NULL, `channel_id` VARCHAR(128) NOT NULL, `suspend_enabled` SMALLINT DEFAULT 0, `ignore_enabled` SMALLINT DEFAULT 0, `last_extract_time` DATETIME, PRIMARY KEY (`node_id`, `channel_id`) ) 2018-10-12 10:50:31,272 INFO [MYSQL01] [MySqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE `sym_node_group`( `node_group_id` VARCHAR(50) NOT NULL, `description` VARCHAR(255) NULL, `create_time` DATETIME, `last_update_by` VARCHAR(50) NULL, `last_update_time` DATETIME, PRIMARY KEY (`node_group_id`) ) 2018-10-12 10:50:31,278 INFO [MYSQL01] [MySqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE `sym_node_group_channel_wnd`( `node_group_id` VARCHAR(50) NOT NULL, `channel_id` VARCHAR(128) NOT NULL, `start_time` DATETIME NOT NULL, `end_time` DATETIME NOT NULL, `enabled` SMALLINT DEFAULT 0 NOT NULL, PRIMARY KEY (`node_group_id`, `channel_id`, `start_time`, `end_time`) ) 2018-10-12 10:50:31,283 INFO [MYSQL01] [MySqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE `sym_node_group_link`( `source_node_group_id` VARCHAR(50) NOT NULL, `target_node_group_id` VARCHAR(50) NOT NULL, `data_event_action` CHAR(1) DEFAULT 'W' NOT NULL, `sync_config_enabled` SMALLINT DEFAULT 1 NOT NULL, `is_reversible` SMALLINT DEFAULT 0 NOT NULL, `create_time` DATETIME, `last_update_by` VARCHAR(50) NULL, `last_update_time` DATETIME, PRIMARY KEY (`source_node_group_id`, `target_node_group_id`) ) 2018-10-12 10:50:31,285 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] There are SymmetricDS tables that needed altered 2018-10-12 10:50:31,286 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on 2018-10-12 10:50:31,286 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on 2018-10-12 10:50:31,291 INFO [MYSQL01] [MySqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE `sym_node_host`( `node_id` VARCHAR(50) NOT NULL, `host_name` VARCHAR(60) NOT NULL, `instance_id` VARCHAR(60) 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` DATETIME, `last_restart_time` DATETIME NOT NULL, `create_time` DATETIME NOT NULL, PRIMARY KEY (`node_id`, `host_name`) ) 2018-10-12 10:50:31,297 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: CREATE TABLE "sym_channel"( "channel_id" VARCHAR(128) NOT NULL, "processing_order" INT DEFAULT 1 NOT NULL, "max_batch_size" INT DEFAULT 1000 NOT NULL, "max_batch_to_send" INT DEFAULT 60 NOT NULL, "max_data_to_route" INT DEFAULT 100000 NOT NULL, "extract_period_millis" INT DEFAULT 0 NOT NULL, "enabled" SMALLINT DEFAULT 1 NOT NULL, "use_old_data_to_route" SMALLINT DEFAULT 1 NOT NULL, "use_row_data_to_route" SMALLINT DEFAULT 1 NOT NULL, "use_pk_data_to_route" SMALLINT DEFAULT 1 NOT NULL, "reload_flag" SMALLINT DEFAULT 0 NOT NULL, "file_sync_flag" SMALLINT DEFAULT 0 NOT NULL, "contains_big_lob" SMALLINT DEFAULT 0 NOT NULL, "batch_algorithm" VARCHAR(50) DEFAULT 'default' NOT NULL, "data_loader_type" VARCHAR(50) DEFAULT 'default' NOT NULL, "description" VARCHAR(255), "queue" VARCHAR(25) DEFAULT 'default' NOT NULL, "max_network_kbps" DECIMAL(10,3) DEFAULT 0.000 NOT NULL, "data_event_action" CHAR(1), "create_time" DATETIME2, "last_update_by" VARCHAR(50), "last_update_time" DATETIME2, PRIMARY KEY ("channel_id") ) 2018-10-12 10:50:31,297 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on 2018-10-12 10:50:31,298 INFO [MYSQL01] [MySqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE `sym_node_host_channel_stats`( `node_id` VARCHAR(50) NOT NULL, `host_name` VARCHAR(60) NOT NULL, `channel_id` VARCHAR(128) NOT NULL, `start_time` DATETIME NOT NULL, `end_time` DATETIME 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-10-12 10:50:31,302 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] 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" 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" DATETIME2 NOT NULL, "last_update_by" VARCHAR(50), "last_update_time" DATETIME2 NOT NULL, PRIMARY KEY ("conflict_id") ) 2018-10-12 10:50:31,303 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on 2018-10-12 10:50:31,306 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: CREATE TABLE "sym_context"( "name" VARCHAR(80) NOT NULL, "context_value" TEXT, "create_time" DATETIME2, "last_update_time" DATETIME2, PRIMARY KEY ("name") ) 2018-10-12 10:50:31,306 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on 2018-10-12 10:50:31,308 INFO [MYSQL01] [MySqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE INDEX `sym_idx_nd_hst_chnl_sts` ON `sym_node_host_channel_stats` (`node_id`, `start_time`, `end_time`) 2018-10-12 10:50:31,310 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: CREATE TABLE "sym_data"( "data_id" BIGINT NOT NULL IDENTITY (1,1) , "table_name" VARCHAR(255) NOT NULL, "event_type" CHAR(1) NOT NULL, "row_data" TEXT, "pk_data" TEXT, "old_data" TEXT, "trigger_hist_id" INT 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" DATETIME2, PRIMARY KEY ("data_id") ) 2018-10-12 10:50:31,312 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: CREATE INDEX "sym_idx_d_channel_id" ON "sym_data" ("data_id", "channel_id") 2018-10-12 10:50:31,312 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on 2018-10-12 10:50:31,313 INFO [MYSQL01] [MySqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE `sym_node_host_job_stats`( `node_id` VARCHAR(50) NOT NULL, `host_name` VARCHAR(60) NOT NULL, `job_name` VARCHAR(50) NOT NULL, `start_time` DATETIME NOT NULL, `end_time` DATETIME 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-10-12 10:50:31,315 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] 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" DATETIME2, PRIMARY KEY ("data_id", "batch_id", "router_id") ) 2018-10-12 10:50:31,318 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: CREATE INDEX "sym_idx_de_batchid" ON "sym_data_event" ("batch_id") 2018-10-12 10:50:31,319 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on 2018-10-12 10:50:31,321 INFO [MYSQL01] [MySqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE INDEX `sym_idx_nd_hst_job` ON `sym_node_host_job_stats` (`node_id`, `start_time`, `end_time`) 2018-10-12 10:50:31,322 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: CREATE TABLE "sym_data_gap"( "start_id" BIGINT NOT NULL, "end_id" BIGINT NOT NULL, "status" CHAR(2), "create_time" DATETIME2 NOT NULL, "last_update_hostname" VARCHAR(255), "last_update_time" DATETIME2 NOT NULL, PRIMARY KEY ("start_id", "end_id") ) 2018-10-12 10:50:31,324 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: CREATE INDEX "sym_idx_dg_status" ON "sym_data_gap" ("status") 2018-10-12 10:50:31,324 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on 2018-10-12 10:50:31,328 INFO [MYSQL01] [MySqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE `sym_node_host_stats`( `node_id` VARCHAR(50) NOT NULL, `host_name` VARCHAR(60) NOT NULL, `start_time` DATETIME NOT NULL, `end_time` DATETIME 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-10-12 10:50:31,328 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] 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" INT DEFAULT 1 NOT NULL, "extension_text" TEXT, "create_time" DATETIME2, "last_update_by" VARCHAR(50), "last_update_time" DATETIME2, PRIMARY KEY ("extension_id") ) 2018-10-12 10:50:31,329 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on 2018-10-12 10:50:31,332 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: CREATE TABLE "sym_extract_request"( "request_id" BIGINT NOT NULL, "node_id" VARCHAR(50) NOT NULL, "queue" VARCHAR(128), "status" CHAR(2), "start_batch_id" BIGINT NOT NULL, "end_batch_id" BIGINT NOT NULL, "trigger_id" VARCHAR(128) NOT NULL, "router_id" VARCHAR(50) NOT NULL, "last_update_time" DATETIME2, "create_time" DATETIME2, PRIMARY KEY ("request_id") ) 2018-10-12 10:50:31,332 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on 2018-10-12 10:50:31,335 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] 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-10-12 10:50:31,336 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on 2018-10-12 10:50:31,337 INFO [MYSQL01] [MySqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE INDEX `sym_idx_nd_hst_sts` ON `sym_node_host_stats` (`node_id`, `start_time`, `end_time`) 2018-10-12 10:50:31,341 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] 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" DATETIME2 NOT NULL, "last_update_by" VARCHAR(50), "create_time" DATETIME2 NOT NULL, PRIMARY KEY ("trigger_id", "router_id", "relative_dir", "file_name") ) 2018-10-12 10:50:31,341 INFO [MYSQL01] [MySqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE `sym_node_identity`( `node_id` VARCHAR(50) NOT NULL, PRIMARY KEY (`node_id`) ) 2018-10-12 10:50:31,343 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: CREATE INDEX "sym_idx_f_snpsht_chid" ON "sym_file_snapshot" ("reload_channel_id") 2018-10-12 10:50:31,344 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on 2018-10-12 10:50:31,348 INFO [MYSQL01] [MySqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE `sym_node_security`( `node_id` VARCHAR(50) NOT NULL, `node_password` VARCHAR(50) NOT NULL, `registration_enabled` SMALLINT DEFAULT 0, `registration_time` DATETIME, `initial_load_enabled` SMALLINT DEFAULT 0, `initial_load_time` DATETIME, `initial_load_id` BIGINT, `initial_load_create_by` VARCHAR(255) NULL, `rev_initial_load_enabled` SMALLINT DEFAULT 0, `rev_initial_load_time` DATETIME, `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-10-12 10:50:31,349 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] 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" TEXT, "after_copy_script" TEXT, "create_time" DATETIME2 NOT NULL, "last_update_by" VARCHAR(50), "last_update_time" DATETIME2 NOT NULL, "description" TEXT, PRIMARY KEY ("trigger_id") ) 2018-10-12 10:50:31,349 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on 2018-10-12 10:50:31,353 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] 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" DATETIME2 NOT NULL, "last_update_by" VARCHAR(50), "last_update_time" DATETIME2 NOT NULL, "description" TEXT, PRIMARY KEY ("trigger_id", "router_id") ) 2018-10-12 10:50:31,353 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on 2018-10-12 10:50:31,354 INFO [MYSQL01] [MySqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE `sym_monitor`( `monitor_id` VARCHAR(128) NOT NULL, `node_group_id` VARCHAR(50) DEFAULT 'ALL' NOT NULL, `external_id` VARCHAR(255) DEFAULT 'ALL' NOT NULL, `type` VARCHAR(50) NOT NULL, `expression` MEDIUMTEXT 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` SMALLINT DEFAULT 0 NOT NULL, `create_time` DATETIME, `last_update_by` VARCHAR(50) NULL, `last_update_time` DATETIME, PRIMARY KEY (`monitor_id`) ) 2018-10-12 10:50:31,357 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] 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" DATETIME2 NOT NULL, "last_update_by" VARCHAR(50), "last_update_time" DATETIME2 NOT NULL, PRIMARY KEY ("grouplet_id") ) 2018-10-12 10:50:31,358 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on 2018-10-12 10:50:31,360 INFO [MYSQL01] [MySqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE `sym_monitor_event`( `monitor_id` VARCHAR(128) NOT NULL, `node_id` VARCHAR(50) NOT NULL, `event_time` DATETIME 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` SMALLINT DEFAULT 0 NOT NULL, `is_notified` SMALLINT DEFAULT 0 NOT NULL, `details` MEDIUMTEXT NULL, `last_update_time` DATETIME, PRIMARY KEY (`monitor_id`, `node_id`, `event_time`) ) 2018-10-12 10:50:31,362 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: CREATE TABLE "sym_grouplet_link"( "grouplet_id" VARCHAR(50) NOT NULL, "external_id" VARCHAR(255) NOT NULL, "create_time" DATETIME2 NOT NULL, "last_update_by" VARCHAR(50), "last_update_time" DATETIME2 NOT NULL, PRIMARY KEY ("grouplet_id", "external_id") ) 2018-10-12 10:50:31,362 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on 2018-10-12 10:50:31,365 INFO [MYSQL01] [MySqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE `sym_notification`( `notification_id` VARCHAR(128) NOT NULL, `node_group_id` VARCHAR(50) DEFAULT 'ALL' NOT NULL, `external_id` VARCHAR(255) DEFAULT 'ALL' NOT NULL, `severity_level` INTEGER DEFAULT 0 NOT NULL, `type` VARCHAR(50) NOT NULL, `expression` MEDIUMTEXT NULL, `enabled` SMALLINT DEFAULT 0 NOT NULL, `create_time` DATETIME, `last_update_by` VARCHAR(50) NULL, `last_update_time` DATETIME, PRIMARY KEY (`notification_id`) ) 2018-10-12 10:50:31,377 INFO [MYSQL01] [MySqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE `sym_outgoing_batch`( `batch_id` BIGINT NOT NULL, `node_id` VARCHAR(50) NOT NULL, `channel_id` VARCHAR(128) NULL, `status` CHAR(2) NULL, `error_flag` SMALLINT DEFAULT 0, `sql_state` VARCHAR(10) NULL, `sql_code` INTEGER DEFAULT 0 NOT NULL, `sql_message` MEDIUMTEXT NULL, `last_update_hostname` VARCHAR(255) NULL, `last_update_time` DATETIME, `create_time` DATETIME, `summary` VARCHAR(255) NULL, `ignore_count` INTEGER DEFAULT 0 NOT NULL, `byte_count` BIGINT DEFAULT 0 NOT NULL, `load_flag` SMALLINT DEFAULT 0, `extract_count` INTEGER DEFAULT 0 NOT NULL, `sent_count` INTEGER DEFAULT 0 NOT NULL, `load_count` INTEGER DEFAULT 0 NOT NULL, `reload_row_count` INTEGER DEFAULT 0 NOT NULL, `other_row_count` INTEGER DEFAULT 0 NOT NULL, `data_row_count` INTEGER DEFAULT 0 NOT NULL, `extract_row_count` INTEGER DEFAULT 0 NOT NULL, `load_row_count` INTEGER DEFAULT 0 NOT NULL, `data_insert_row_count` INTEGER DEFAULT 0 NOT NULL, `data_update_row_count` INTEGER DEFAULT 0 NOT NULL, `data_delete_row_count` INTEGER DEFAULT 0 NOT NULL, `extract_insert_row_count` INTEGER DEFAULT 0 NOT NULL, `extract_update_row_count` INTEGER DEFAULT 0 NOT NULL, `extract_delete_row_count` INTEGER DEFAULT 0 NOT NULL, `load_insert_row_count` INTEGER DEFAULT 0 NOT NULL, `load_update_row_count` INTEGER DEFAULT 0 NOT NULL, `load_delete_row_count` INTEGER DEFAULT 0 NOT NULL, `network_millis` INTEGER DEFAULT 0 NOT NULL, `filter_millis` INTEGER DEFAULT 0 NOT NULL, `load_millis` INTEGER DEFAULT 0 NOT NULL, `router_millis` INTEGER DEFAULT 0 NOT NULL, `extract_millis` INTEGER DEFAULT 0 NOT NULL, `transform_extract_millis` INTEGER DEFAULT 0 NOT NULL, `transform_load_millis` INTEGER DEFAULT 0 NOT NULL, `load_id` BIGINT, `common_flag` SMALLINT DEFAULT 0, `fallback_insert_count` INTEGER DEFAULT 0 NOT NULL, `fallback_update_count` INTEGER DEFAULT 0 NOT NULL, `ignore_row_count` INTEGER DEFAULT 0 NOT NULL, `missing_delete_count` INTEGER DEFAULT 0 NOT NULL, `skip_count` INTEGER DEFAULT 0 NOT NULL, `total_extract_millis` INTEGER DEFAULT 0 NOT NULL, `total_load_millis` INTEGER DEFAULT 0 NOT NULL, `extract_job_flag` SMALLINT DEFAULT 0, `extract_start_time` DATETIME, `transfer_start_time` DATETIME, `load_start_time` DATETIME, `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-10-12 10:50:31,394 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: CREATE TABLE "sym_incoming_batch"( "batch_id" BIGINT NOT NULL, "node_id" VARCHAR(50) NOT NULL, "channel_id" VARCHAR(128), "status" CHAR(2), "error_flag" SMALLINT DEFAULT 0, "sql_state" VARCHAR(10), "sql_code" INT DEFAULT 0 NOT NULL, "sql_message" TEXT, "last_update_hostname" VARCHAR(255), "last_update_time" DATETIME2, "create_time" DATETIME2, "summary" VARCHAR(255), "ignore_count" INT DEFAULT 0 NOT NULL, "byte_count" BIGINT DEFAULT 0 NOT NULL, "load_flag" SMALLINT DEFAULT 0, "extract_count" INT DEFAULT 0 NOT NULL, "sent_count" INT DEFAULT 0 NOT NULL, "load_count" INT DEFAULT 0 NOT NULL, "reload_row_count" INT DEFAULT 0 NOT NULL, "other_row_count" INT DEFAULT 0 NOT NULL, "data_row_count" INT DEFAULT 0 NOT NULL, "extract_row_count" INT DEFAULT 0 NOT NULL, "load_row_count" INT DEFAULT 0 NOT NULL, "data_insert_row_count" INT DEFAULT 0 NOT NULL, "data_update_row_count" INT DEFAULT 0 NOT NULL, "data_delete_row_count" INT DEFAULT 0 NOT NULL, "extract_insert_row_count" INT DEFAULT 0 NOT NULL, "extract_update_row_count" INT DEFAULT 0 NOT NULL, "extract_delete_row_count" INT DEFAULT 0 NOT NULL, "load_insert_row_count" INT DEFAULT 0 NOT NULL, "load_update_row_count" INT DEFAULT 0 NOT NULL, "load_delete_row_count" INT DEFAULT 0 NOT NULL, "network_millis" INT DEFAULT 0 NOT NULL, "filter_millis" INT DEFAULT 0 NOT NULL, "load_millis" INT DEFAULT 0 NOT NULL, "router_millis" INT DEFAULT 0 NOT NULL, "extract_millis" INT DEFAULT 0 NOT NULL, "transform_extract_millis" INT DEFAULT 0 NOT NULL, "transform_load_millis" INT DEFAULT 0 NOT NULL, "load_id" BIGINT, "common_flag" SMALLINT DEFAULT 0, "fallback_insert_count" INT DEFAULT 0 NOT NULL, "fallback_update_count" INT DEFAULT 0 NOT NULL, "ignore_row_count" INT DEFAULT 0 NOT NULL, "missing_delete_count" INT DEFAULT 0 NOT NULL, "skip_count" INT DEFAULT 0 NOT NULL, "failed_row_number" INT DEFAULT 0 NOT NULL, "failed_line_number" INT DEFAULT 0 NOT NULL, "failed_data_id" BIGINT DEFAULT 0 NOT NULL, PRIMARY KEY ("batch_id", "node_id") ) 2018-10-12 10:50:31,396 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: CREATE INDEX "sym_idx_ib_time_status" ON "sym_incoming_batch" ("create_time", "status") 2018-10-12 10:50:31,397 INFO [MYSQL01] [MySqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE INDEX `sym_idx_ob_node_status` ON `sym_outgoing_batch` (`node_id`, `status`) 2018-10-12 10:50:31,399 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: CREATE INDEX "sym_idx_ib_in_error" ON "sym_incoming_batch" ("error_flag") 2018-10-12 10:50:31,399 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on 2018-10-12 10:50:31,404 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] 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" TEXT NOT NULL, "pk_column_names" TEXT NOT NULL, "row_data" TEXT, "old_data" TEXT, "cur_data" TEXT, "resolve_data" TEXT, "resolve_ignore" SMALLINT DEFAULT 0, "conflict_id" VARCHAR(50), "create_time" DATETIME2, "last_update_by" VARCHAR(50), "last_update_time" DATETIME2 NOT NULL, PRIMARY KEY ("batch_id", "node_id", "failed_row_number") ) 2018-10-12 10:50:31,405 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on 2018-10-12 10:50:31,413 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: CREATE TABLE "sym_job"( "job_name" VARCHAR(50) NOT NULL, "job_type" VARCHAR(10) NOT NULL, "requires_registration" SMALLINT DEFAULT 1 NOT NULL, "job_expression" TEXT, "description" VARCHAR(255), "default_schedule" VARCHAR(50), "default_auto_start" SMALLINT DEFAULT 1 NOT NULL, "node_group_id" VARCHAR(50) NOT NULL, "create_by" VARCHAR(50), "create_time" DATETIME2, "last_update_by" VARCHAR(50), "last_update_time" DATETIME2, PRIMARY KEY ("job_name") ) 2018-10-12 10:50:31,414 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on 2018-10-12 10:50:31,416 INFO [MYSQL01] [MySqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE INDEX `sym_idx_ob_status` ON `sym_outgoing_batch` (`status`) 2018-10-12 10:50:31,420 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] 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" TEXT, "after_write_script" TEXT, "batch_complete_script" TEXT, "batch_commit_script" TEXT, "batch_rollback_script" TEXT, "handle_error_script" TEXT, "create_time" DATETIME2 NOT NULL, "last_update_by" VARCHAR(50), "last_update_time" DATETIME2 NOT NULL, "load_filter_order" INT DEFAULT 1 NOT NULL, "fail_on_error" SMALLINT DEFAULT 0 NOT NULL, PRIMARY KEY ("load_filter_id") ) 2018-10-12 10:50:31,421 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on 2018-10-12 10:50:31,426 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] 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" DATETIME2, "shared_count" INT DEFAULT 0 NOT NULL, "shared_enable" INT DEFAULT 0 NOT NULL, "last_lock_time" DATETIME2, "last_locking_server_id" VARCHAR(255), PRIMARY KEY ("lock_action") ) 2018-10-12 10:50:31,426 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on 2018-10-12 10:50:31,431 INFO [MYSQL01] [MySqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE INDEX `sym_idx_ob_in_error` ON `sym_outgoing_batch` (`error_flag`) 2018-10-12 10:50:31,431 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] 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" DATETIME2, "timezone_offset" VARCHAR(6), "sync_enabled" SMALLINT DEFAULT 0, "sync_url" VARCHAR(255), "schema_version" VARCHAR(50), "symmetric_version" VARCHAR(50), "config_version" VARCHAR(50), "database_type" VARCHAR(50), "database_version" VARCHAR(50), "batch_to_send_count" INT DEFAULT 0, "batch_in_error_count" INT DEFAULT 0, "created_at_node_id" VARCHAR(50), "deployment_type" VARCHAR(50), "deployment_sub_type" VARCHAR(50), PRIMARY KEY ("node_id") ) 2018-10-12 10:50:31,432 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on 2018-10-12 10:50:31,438 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] 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" DATETIME2, "locking_server_id" VARCHAR(255), "last_lock_time" DATETIME2, "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" INT DEFAULT 0, PRIMARY KEY ("node_id", "queue", "communication_type") ) 2018-10-12 10:50:31,438 INFO [MYSQL01] [MySqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE `sym_parameter`( `external_id` VARCHAR(255) NOT NULL, `node_group_id` VARCHAR(50) NOT NULL, `param_key` VARCHAR(80) NOT NULL, `param_value` MEDIUMTEXT NULL, `create_time` DATETIME, `last_update_by` VARCHAR(50) NULL, `last_update_time` DATETIME, PRIMARY KEY (`external_id`, `node_group_id`, `param_key`) ) 2018-10-12 10:50:31,439 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on 2018-10-12 10:50:31,443 INFO [MYSQL01] [MySqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE `sym_registration_redirect`( `registrant_external_id` VARCHAR(255) NOT NULL, `registration_node_id` VARCHAR(50) NOT NULL, PRIMARY KEY (`registrant_external_id`) ) 2018-10-12 10:50:31,449 INFO [MYSQL01] [MySqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE `sym_registration_request`( `node_group_id` VARCHAR(50) NOT NULL, `external_id` VARCHAR(255) NOT NULL, `status` CHAR(2) NOT NULL, `host_name` VARCHAR(60) NOT NULL, `ip_address` VARCHAR(50) NOT NULL, `attempt_count` INTEGER DEFAULT 0, `registered_node_id` VARCHAR(50) NULL, `error_message` MEDIUMTEXT NULL, `create_time` DATETIME NOT NULL, `last_update_by` VARCHAR(50) NULL, `last_update_time` DATETIME NOT NULL, PRIMARY KEY (`node_group_id`, `external_id`, `create_time`) ) 2018-10-12 10:50:31,449 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] 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" DATETIME2, PRIMARY KEY ("node_id", "channel_id") ) 2018-10-12 10:50:31,450 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on 2018-10-12 10:50:31,453 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: CREATE TABLE "sym_node_group"( "node_group_id" VARCHAR(50) NOT NULL, "description" VARCHAR(255), "create_time" DATETIME2, "last_update_by" VARCHAR(50), "last_update_time" DATETIME2, PRIMARY KEY ("node_group_id") ) 2018-10-12 10:50:31,454 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on 2018-10-12 10:50:31,457 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: CREATE TABLE "sym_node_group_channel_wnd"( "node_group_id" VARCHAR(50) NOT NULL, "channel_id" VARCHAR(128) NOT NULL, "start_time" DATETIME2 NOT NULL, "end_time" DATETIME2 NOT NULL, "enabled" SMALLINT DEFAULT 0 NOT NULL, PRIMARY KEY ("node_group_id", "channel_id", "start_time", "end_time") ) 2018-10-12 10:50:31,457 INFO [MYSQL01] [MySqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE INDEX `sym_idx_reg_req_1` ON `sym_registration_request` (`node_group_id`, `external_id`, `status`, `host_name`, `ip_address`) 2018-10-12 10:50:31,457 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on 2018-10-12 10:50:31,461 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: CREATE TABLE "sym_node_group_link"( "source_node_group_id" VARCHAR(50) NOT NULL, "target_node_group_id" VARCHAR(50) NOT NULL, "data_event_action" CHAR(1) DEFAULT 'W' NOT NULL, "sync_config_enabled" SMALLINT DEFAULT 1 NOT NULL, "is_reversible" SMALLINT DEFAULT 0 NOT NULL, "create_time" DATETIME2, "last_update_by" VARCHAR(50), "last_update_time" DATETIME2, PRIMARY KEY ("source_node_group_id", "target_node_group_id") ) 2018-10-12 10:50:31,462 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on 2018-10-12 10:50:31,465 INFO [MYSQL01] [MySqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE INDEX `sym_idx_reg_req_2` ON `sym_registration_request` (`status`) 2018-10-12 10:50:31,466 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: CREATE TABLE "sym_node_host"( "node_id" VARCHAR(50) NOT NULL, "host_name" VARCHAR(60) NOT NULL, "instance_id" VARCHAR(60), "ip_address" VARCHAR(50), "os_user" VARCHAR(50), "os_name" VARCHAR(50), "os_arch" VARCHAR(50), "os_version" VARCHAR(50), "available_processors" INT 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" DATETIME2, "last_restart_time" DATETIME2 NOT NULL, "create_time" DATETIME2 NOT NULL, PRIMARY KEY ("node_id", "host_name") ) 2018-10-12 10:50:31,466 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on 2018-10-12 10:50:31,471 INFO [MYSQL01] [MySqlSymmetricDialect] [symmetric-engine-startup-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` MEDIUMTEXT 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, `use_source_catalog_schema` SMALLINT DEFAULT 1 NOT NULL, `create_time` DATETIME NOT NULL, `last_update_by` VARCHAR(50) NULL, `last_update_time` DATETIME NOT NULL, `description` MEDIUMTEXT NULL, PRIMARY KEY (`router_id`) ) 2018-10-12 10:50:31,473 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] 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" DATETIME2 NOT NULL, "end_time" DATETIME2 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-10-12 10:50:31,476 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: CREATE INDEX "sym_idx_nd_hst_chnl_sts" ON "sym_node_host_channel_stats" ("node_id", "start_time", "end_time") 2018-10-12 10:50:31,476 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on 2018-10-12 10:50:31,477 INFO [MYSQL01] [MySqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE `sym_sequence`( `sequence_name` VARCHAR(50) NOT NULL, `current_value` BIGINT DEFAULT 0 NOT NULL, `increment_by` INTEGER DEFAULT 1 NOT NULL, `min_value` BIGINT DEFAULT 1 NOT NULL, `max_value` BIGINT DEFAULT 9999999999 NOT NULL, `cycle_flag` SMALLINT DEFAULT 0, `cache_size` INTEGER DEFAULT 0 NOT NULL, `create_time` DATETIME, `last_update_by` VARCHAR(50) NULL, `last_update_time` DATETIME NOT NULL, PRIMARY KEY (`sequence_name`) ) 2018-10-12 10:50:31,480 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] 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" DATETIME2 NOT NULL, "end_time" DATETIME2 NOT NULL, "processed_count" BIGINT DEFAULT 0, "target_node_id" VARCHAR(50), "target_node_count" INT DEFAULT 0, PRIMARY KEY ("node_id", "host_name", "job_name", "start_time", "end_time") ) 2018-10-12 10:50:31,484 INFO [MYSQL01] [MySqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE `sym_table_reload_request`( `target_node_id` VARCHAR(50) NOT NULL, `source_node_id` VARCHAR(50) NOT NULL, `trigger_id` VARCHAR(128) NOT NULL, `router_id` VARCHAR(50) NOT NULL, `create_time` DATETIME NOT NULL, `create_table` SMALLINT DEFAULT 0 NOT NULL, `delete_first` SMALLINT DEFAULT 0 NOT NULL, `reload_select` MEDIUMTEXT NULL, `before_custom_sql` MEDIUMTEXT NULL, `reload_time` DATETIME, `load_id` BIGINT, `processed` SMALLINT DEFAULT 0 NOT NULL, `channel_id` VARCHAR(128) NULL, `last_update_by` VARCHAR(50) NULL, `last_update_time` DATETIME NOT NULL, PRIMARY KEY (`target_node_id`, `source_node_id`, `trigger_id`, `router_id`, `create_time`) ) 2018-10-12 10:50:31,486 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: CREATE INDEX "sym_idx_nd_hst_job" ON "sym_node_host_job_stats" ("node_id", "start_time", "end_time") 2018-10-12 10:50:31,486 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on 2018-10-12 10:50:31,491 INFO [MYSQL01] [MySqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE `sym_transform_table`( `transform_id` VARCHAR(50) NOT NULL, `source_node_group_id` VARCHAR(50) NOT NULL, `target_node_group_id` VARCHAR(50) NOT NULL, `transform_point` VARCHAR(10) NOT NULL, `source_catalog_name` VARCHAR(255) 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` SMALLINT DEFAULT 0, `update_action` VARCHAR(255) DEFAULT 'UPDATE_COL' NOT NULL, `delete_action` VARCHAR(10) NOT NULL, `transform_order` INTEGER DEFAULT 1 NOT NULL, `column_policy` VARCHAR(10) DEFAULT 'SPECIFIED' NOT NULL, `create_time` DATETIME, `last_update_by` VARCHAR(50) NULL, `last_update_time` DATETIME, `description` MEDIUMTEXT NULL, PRIMARY KEY (`transform_id`, `source_node_group_id`, `target_node_group_id`) ) 2018-10-12 10:50:31,495 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: CREATE TABLE "sym_node_host_stats"( "node_id" VARCHAR(50) NOT NULL, "host_name" VARCHAR(60) NOT NULL, "start_time" DATETIME2 NOT NULL, "end_time" DATETIME2 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-10-12 10:50:31,497 INFO [MYSQL01] [MySqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE `sym_transform_column`( `transform_id` VARCHAR(50) NOT NULL, `include_on` CHAR(1) DEFAULT '*' NOT NULL, `target_column_name` VARCHAR(128) NOT NULL, `source_column_name` VARCHAR(128) NULL, `pk` SMALLINT DEFAULT 0, `transform_type` VARCHAR(50) DEFAULT 'copy' NULL, `transform_expression` MEDIUMTEXT NULL, `transform_order` INTEGER DEFAULT 1 NOT NULL, `create_time` DATETIME, `last_update_by` VARCHAR(50) NULL, `last_update_time` DATETIME, `description` MEDIUMTEXT NULL, PRIMARY KEY (`transform_id`, `include_on`, `target_column_name`) ) 2018-10-12 10:50:31,498 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: CREATE INDEX "sym_idx_nd_hst_sts" ON "sym_node_host_stats" ("node_id", "start_time", "end_time") 2018-10-12 10:50:31,498 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on 2018-10-12 10:50:31,502 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: CREATE TABLE "sym_node_identity"( "node_id" VARCHAR(50) NOT NULL, PRIMARY KEY ("node_id") ) 2018-10-12 10:50:31,502 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on 2018-10-12 10:50:31,508 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] 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" DATETIME2, "initial_load_enabled" SMALLINT DEFAULT 0, "initial_load_time" DATETIME2, "initial_load_id" BIGINT, "initial_load_create_by" VARCHAR(255), "rev_initial_load_enabled" SMALLINT DEFAULT 0, "rev_initial_load_time" DATETIME2, "rev_initial_load_id" BIGINT, "rev_initial_load_create_by" VARCHAR(255), "created_at_node_id" VARCHAR(50), PRIMARY KEY ("node_id") ) 2018-10-12 10:50:31,508 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on 2018-10-12 10:50:31,509 INFO [MYSQL01] [MySqlSymmetricDialect] [symmetric-engine-startup-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` 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) NULL, `name_for_insert_trigger` VARCHAR(255) NULL, `name_for_delete_trigger` VARCHAR(255) NULL, `sync_on_update_condition` MEDIUMTEXT NULL, `sync_on_insert_condition` MEDIUMTEXT NULL, `sync_on_delete_condition` MEDIUMTEXT NULL, `custom_before_update_text` MEDIUMTEXT NULL, `custom_before_insert_text` MEDIUMTEXT NULL, `custom_before_delete_text` MEDIUMTEXT NULL, `custom_on_update_text` MEDIUMTEXT NULL, `custom_on_insert_text` MEDIUMTEXT NULL, `custom_on_delete_text` MEDIUMTEXT NULL, `external_select` MEDIUMTEXT NULL, `tx_id_expression` MEDIUMTEXT NULL, `channel_expression` MEDIUMTEXT NULL, `excluded_column_names` MEDIUMTEXT NULL, `included_column_names` MEDIUMTEXT NULL, `sync_key_names` MEDIUMTEXT NULL, `use_stream_lobs` SMALLINT DEFAULT 0 NOT NULL, `use_capture_lobs` SMALLINT DEFAULT 0 NOT NULL, `use_capture_old_data` SMALLINT DEFAULT 1 NOT NULL, `use_handle_key_updates` SMALLINT DEFAULT 1 NOT NULL, `stream_row` SMALLINT DEFAULT 0 NOT NULL, `create_time` DATETIME NOT NULL, `last_update_by` VARCHAR(50) NULL, `last_update_time` DATETIME NOT NULL, `description` MEDIUMTEXT NULL, PRIMARY KEY (`trigger_id`) ) 2018-10-12 10:50:31,514 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] 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" TEXT, "threshold" BIGINT DEFAULT 0 NOT NULL, "run_period" INT DEFAULT 0 NOT NULL, "run_count" INT DEFAULT 0 NOT NULL, "severity_level" INT DEFAULT 0 NOT NULL, "enabled" SMALLINT DEFAULT 0 NOT NULL, "create_time" DATETIME2, "last_update_by" VARCHAR(50), "last_update_time" DATETIME2, PRIMARY KEY ("monitor_id") ) 2018-10-12 10:50:31,515 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on 2018-10-12 10:50:31,516 INFO [MYSQL01] [MySqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE `sym_trigger_hist`( `trigger_hist_id` INTEGER NOT NULL, `trigger_id` VARCHAR(128) NOT NULL, `source_table_name` VARCHAR(255) NOT NULL, `source_catalog_name` VARCHAR(255) 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` MEDIUMTEXT NOT NULL, `pk_column_names` MEDIUMTEXT NOT NULL, `last_trigger_build_reason` CHAR(1) NOT NULL, `error_message` MEDIUMTEXT NULL, `create_time` DATETIME NOT NULL, `inactive_time` DATETIME, PRIMARY KEY (`trigger_hist_id`) ) 2018-10-12 10:50:31,519 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: CREATE TABLE "sym_monitor_event"( "monitor_id" VARCHAR(128) NOT NULL, "node_id" VARCHAR(50) NOT NULL, "event_time" DATETIME2 NOT NULL, "host_name" VARCHAR(60), "type" VARCHAR(50) NOT NULL, "threshold" BIGINT DEFAULT 0 NOT NULL, "event_value" BIGINT DEFAULT 0 NOT NULL, "event_count" INT DEFAULT 0 NOT NULL, "severity_level" INT DEFAULT 0 NOT NULL, "is_resolved" SMALLINT DEFAULT 0 NOT NULL, "is_notified" SMALLINT DEFAULT 0 NOT NULL, "details" TEXT, "last_update_time" DATETIME2, PRIMARY KEY ("monitor_id", "node_id", "event_time") ) 2018-10-12 10:50:31,519 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on 2018-10-12 10:50:31,526 INFO [MYSQL01] [MySqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE INDEX `sym_idx_trigg_hist_1` ON `sym_trigger_hist` (`trigger_id`, `inactive_time`) 2018-10-12 10:50:31,529 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] 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" INT DEFAULT 0 NOT NULL, "type" VARCHAR(50) NOT NULL, "expression" TEXT, "enabled" SMALLINT DEFAULT 0 NOT NULL, "create_time" DATETIME2, "last_update_by" VARCHAR(50), "last_update_time" DATETIME2, PRIMARY KEY ("notification_id") ) 2018-10-12 10:50:31,529 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on 2018-10-12 10:50:31,531 INFO [MYSQL01] [MySqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE `sym_trigger_router`( `trigger_id` VARCHAR(128) NOT NULL, `router_id` VARCHAR(50) NOT NULL, `enabled` SMALLINT DEFAULT 1 NOT NULL, `initial_load_order` INTEGER DEFAULT 1 NOT NULL, `initial_load_select` MEDIUMTEXT NULL, `initial_load_delete_stmt` MEDIUMTEXT NULL, `ping_back_enabled` SMALLINT DEFAULT 0 NOT NULL, `create_time` DATETIME NOT NULL, `last_update_by` VARCHAR(50) NULL, `last_update_time` DATETIME NOT NULL, `description` MEDIUMTEXT NULL, PRIMARY KEY (`trigger_id`, `router_id`) ) 2018-10-12 10:50:31,537 INFO [MYSQL01] [MySqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE `sym_trigger_router_grouplet`( `grouplet_id` VARCHAR(50) NOT NULL, `trigger_id` VARCHAR(128) NOT NULL, `router_id` VARCHAR(50) NOT NULL, `applies_when` CHAR(1) NOT NULL, `create_time` DATETIME NOT NULL, `last_update_by` VARCHAR(50) NULL, `last_update_time` DATETIME NOT NULL, PRIMARY KEY (`grouplet_id`, `trigger_id`, `router_id`, `applies_when`) ) 2018-10-12 10:50:31,555 INFO [MYSQL01] [MySqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: ALTER TABLE `sym_conflict` ADD CONSTRAINT `sym_fk_cf_2_grp_lnk` FOREIGN KEY (`source_node_group_id`, `target_node_group_id`) REFERENCES `sym_node_group_link` (`source_node_group_id`, `target_node_group_id`) 2018-10-12 10:50:31,565 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: CREATE TABLE "sym_outgoing_batch"( "batch_id" BIGINT NOT NULL, "node_id" VARCHAR(50) NOT NULL, "channel_id" VARCHAR(128), "status" CHAR(2), "error_flag" SMALLINT DEFAULT 0, "sql_state" VARCHAR(10), "sql_code" INT DEFAULT 0 NOT NULL, "sql_message" TEXT, "last_update_hostname" VARCHAR(255), "last_update_time" DATETIME2, "create_time" DATETIME2, "summary" VARCHAR(255), "ignore_count" INT DEFAULT 0 NOT NULL, "byte_count" BIGINT DEFAULT 0 NOT NULL, "load_flag" SMALLINT DEFAULT 0, "extract_count" INT DEFAULT 0 NOT NULL, "sent_count" INT DEFAULT 0 NOT NULL, "load_count" INT DEFAULT 0 NOT NULL, "reload_row_count" INT DEFAULT 0 NOT NULL, "other_row_count" INT DEFAULT 0 NOT NULL, "data_row_count" INT DEFAULT 0 NOT NULL, "extract_row_count" INT DEFAULT 0 NOT NULL, "load_row_count" INT DEFAULT 0 NOT NULL, "data_insert_row_count" INT DEFAULT 0 NOT NULL, "data_update_row_count" INT DEFAULT 0 NOT NULL, "data_delete_row_count" INT DEFAULT 0 NOT NULL, "extract_insert_row_count" INT DEFAULT 0 NOT NULL, "extract_update_row_count" INT DEFAULT 0 NOT NULL, "extract_delete_row_count" INT DEFAULT 0 NOT NULL, "load_insert_row_count" INT DEFAULT 0 NOT NULL, "load_update_row_count" INT DEFAULT 0 NOT NULL, "load_delete_row_count" INT DEFAULT 0 NOT NULL, "network_millis" INT DEFAULT 0 NOT NULL, "filter_millis" INT DEFAULT 0 NOT NULL, "load_millis" INT DEFAULT 0 NOT NULL, "router_millis" INT DEFAULT 0 NOT NULL, "extract_millis" INT DEFAULT 0 NOT NULL, "transform_extract_millis" INT DEFAULT 0 NOT NULL, "transform_load_millis" INT DEFAULT 0 NOT NULL, "load_id" BIGINT, "common_flag" SMALLINT DEFAULT 0, "fallback_insert_count" INT DEFAULT 0 NOT NULL, "fallback_update_count" INT DEFAULT 0 NOT NULL, "ignore_row_count" INT DEFAULT 0 NOT NULL, "missing_delete_count" INT DEFAULT 0 NOT NULL, "skip_count" INT DEFAULT 0 NOT NULL, "total_extract_millis" INT DEFAULT 0 NOT NULL, "total_load_millis" INT DEFAULT 0 NOT NULL, "extract_job_flag" SMALLINT DEFAULT 0, "extract_start_time" DATETIME2, "transfer_start_time" DATETIME2, "load_start_time" DATETIME2, "failed_data_id" BIGINT DEFAULT 0 NOT NULL, "failed_line_number" BIGINT DEFAULT 0 NOT NULL, "create_by" VARCHAR(255), PRIMARY KEY ("batch_id", "node_id") ) 2018-10-12 10:50:31,567 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: CREATE INDEX "sym_idx_ob_node_status" ON "sym_outgoing_batch" ("node_id", "status") 2018-10-12 10:50:31,570 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: CREATE INDEX "sym_idx_ob_status" ON "sym_outgoing_batch" ("status") 2018-10-12 10:50:31,572 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: CREATE INDEX "sym_idx_ob_in_error" ON "sym_outgoing_batch" ("error_flag") 2018-10-12 10:50:31,572 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on 2018-10-12 10:50:31,574 INFO [MYSQL01] [MySqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: ALTER TABLE `sym_file_trigger_router` ADD CONSTRAINT `sym_fk_ftr_2_ftrg` FOREIGN KEY (`trigger_id`) REFERENCES `sym_file_trigger` (`trigger_id`) 2018-10-12 10:50:31,575 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] 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" TEXT, "create_time" DATETIME2, "last_update_by" VARCHAR(50), "last_update_time" DATETIME2, PRIMARY KEY ("external_id", "node_group_id", "param_key") ) 2018-10-12 10:50:31,576 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on 2018-10-12 10:50:31,580 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] 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-10-12 10:50:31,580 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on 2018-10-12 10:50:31,583 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] 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" INT DEFAULT 0, "registered_node_id" VARCHAR(50), "error_message" TEXT, "create_time" DATETIME2 NOT NULL, "last_update_by" VARCHAR(50), "last_update_time" DATETIME2 NOT NULL, PRIMARY KEY ("node_group_id", "external_id", "create_time") ) 2018-10-12 10:50:31,585 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: CREATE INDEX "sym_idx_reg_req_1" ON "sym_registration_request" ("node_group_id", "external_id", "status", "host_name", "ip_address") 2018-10-12 10:50:31,594 INFO [MYSQL01] [MySqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: ALTER TABLE `sym_file_trigger_router` ADD CONSTRAINT `sym_fk_ftr_2_rtr` FOREIGN KEY (`router_id`) REFERENCES `sym_router` (`router_id`) 2018-10-12 10:50:31,595 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: CREATE INDEX "sym_idx_reg_req_2" ON "sym_registration_request" ("status") 2018-10-12 10:50:31,596 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on 2018-10-12 10:50:31,602 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] 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" 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" DATETIME2 NOT NULL, "last_update_by" VARCHAR(50), "last_update_time" DATETIME2 NOT NULL, "description" TEXT, PRIMARY KEY ("router_id") ) 2018-10-12 10:50:31,602 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on 2018-10-12 10:50:31,608 INFO [MYSQL01] [MySqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: ALTER TABLE `sym_grouplet_link` ADD CONSTRAINT `sym_fk_gpltlnk_2_gplt` FOREIGN KEY (`grouplet_id`) REFERENCES `sym_grouplet` (`grouplet_id`) 2018-10-12 10:50:31,609 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: CREATE TABLE "sym_sequence"( "sequence_name" VARCHAR(50) NOT NULL, "current_value" BIGINT DEFAULT 0 NOT NULL, "increment_by" INT DEFAULT 1 NOT NULL, "min_value" BIGINT DEFAULT 1 NOT NULL, "max_value" BIGINT DEFAULT 9999999999 NOT NULL, "cycle_flag" SMALLINT DEFAULT 0, "cache_size" INT DEFAULT 0 NOT NULL, "create_time" DATETIME2, "last_update_by" VARCHAR(50), "last_update_time" DATETIME2 NOT NULL, PRIMARY KEY ("sequence_name") ) 2018-10-12 10:50:31,609 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on 2018-10-12 10:50:31,613 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] 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" DATETIME2 NOT NULL, "create_table" SMALLINT DEFAULT 0 NOT NULL, "delete_first" SMALLINT DEFAULT 0 NOT NULL, "reload_select" TEXT, "before_custom_sql" TEXT, "reload_time" DATETIME2, "load_id" BIGINT, "processed" SMALLINT DEFAULT 0 NOT NULL, "channel_id" VARCHAR(128), "last_update_by" VARCHAR(50), "last_update_time" DATETIME2 NOT NULL, PRIMARY KEY ("target_node_id", "source_node_id", "trigger_id", "router_id", "create_time") ) 2018-10-12 10:50:31,613 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on 2018-10-12 10:50:31,617 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: CREATE TABLE "sym_transform_table"( "transform_id" VARCHAR(50) NOT NULL, "source_node_group_id" VARCHAR(50) NOT NULL, "target_node_group_id" VARCHAR(50) NOT NULL, "transform_point" VARCHAR(10) NOT NULL, "source_catalog_name" VARCHAR(255), "source_schema_name" VARCHAR(255), "source_table_name" VARCHAR(255) NOT NULL, "target_catalog_name" VARCHAR(255), "target_schema_name" VARCHAR(255), "target_table_name" VARCHAR(255), "update_first" SMALLINT DEFAULT 0, "update_action" VARCHAR(255) DEFAULT 'UPDATE_COL' NOT NULL, "delete_action" VARCHAR(10) NOT NULL, "transform_order" INT DEFAULT 1 NOT NULL, "column_policy" VARCHAR(10) DEFAULT 'SPECIFIED' NOT NULL, "create_time" DATETIME2, "last_update_by" VARCHAR(50), "last_update_time" DATETIME2, "description" TEXT, PRIMARY KEY ("transform_id", "source_node_group_id", "target_node_group_id") ) 2018-10-12 10:50:31,618 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on 2018-10-12 10:50:31,623 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] 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" TEXT, "transform_order" INT DEFAULT 1 NOT NULL, "create_time" DATETIME2, "last_update_by" VARCHAR(50), "last_update_time" DATETIME2, "description" TEXT, PRIMARY KEY ("transform_id", "include_on", "target_column_name") ) 2018-10-12 10:50:31,623 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on 2018-10-12 10:50:31,628 INFO [MYSQL01] [MySqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: ALTER TABLE `sym_node_group_link` ADD CONSTRAINT `sym_fk_lnk_2_grp_src` FOREIGN KEY (`source_node_group_id`) REFERENCES `sym_node_group` (`node_group_id`) 2018-10-12 10:50:31,629 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] 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" TEXT, "sync_on_insert_condition" TEXT, "sync_on_delete_condition" TEXT, "custom_before_update_text" TEXT, "custom_before_insert_text" TEXT, "custom_before_delete_text" TEXT, "custom_on_update_text" TEXT, "custom_on_insert_text" TEXT, "custom_on_delete_text" TEXT, "external_select" TEXT, "tx_id_expression" TEXT, "channel_expression" TEXT, "excluded_column_names" TEXT, "included_column_names" TEXT, "sync_key_names" TEXT, "use_stream_lobs" SMALLINT DEFAULT 0 NOT NULL, "use_capture_lobs" SMALLINT DEFAULT 0 NOT NULL, "use_capture_old_data" SMALLINT DEFAULT 1 NOT NULL, "use_handle_key_updates" SMALLINT DEFAULT 1 NOT NULL, "stream_row" SMALLINT DEFAULT 0 NOT NULL, "create_time" DATETIME2 NOT NULL, "last_update_by" VARCHAR(50), "last_update_time" DATETIME2 NOT NULL, "description" TEXT, PRIMARY KEY ("trigger_id") ) 2018-10-12 10:50:31,630 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on 2018-10-12 10:50:31,634 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: CREATE TABLE "sym_trigger_hist"( "trigger_hist_id" INT 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" TEXT NOT NULL, "pk_column_names" TEXT NOT NULL, "last_trigger_build_reason" CHAR(1) NOT NULL, "error_message" TEXT, "create_time" DATETIME2 NOT NULL, "inactive_time" DATETIME2, PRIMARY KEY ("trigger_hist_id") ) 2018-10-12 10:50:31,636 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: CREATE INDEX "sym_idx_trigg_hist_1" ON "sym_trigger_hist" ("trigger_id", "inactive_time") 2018-10-12 10:50:31,636 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on 2018-10-12 10:50:31,642 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] 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" INT DEFAULT 1 NOT NULL, "initial_load_select" TEXT, "initial_load_delete_stmt" TEXT, "ping_back_enabled" SMALLINT DEFAULT 0 NOT NULL, "create_time" DATETIME2 NOT NULL, "last_update_by" VARCHAR(50), "last_update_time" DATETIME2 NOT NULL, "description" TEXT, PRIMARY KEY ("trigger_id", "router_id") ) 2018-10-12 10:50:31,642 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on 2018-10-12 10:50:31,645 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] 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" DATETIME2 NOT NULL, "last_update_by" VARCHAR(50), "last_update_time" DATETIME2 NOT NULL, PRIMARY KEY ("grouplet_id", "trigger_id", "router_id", "applies_when") ) 2018-10-12 10:50:31,648 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] 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-10-12 10:50:31,649 INFO [MYSQL01] [MySqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: ALTER TABLE `sym_node_group_link` ADD CONSTRAINT `sym_fk_lnk_2_grp_tgt` FOREIGN KEY (`target_node_group_id`) REFERENCES `sym_node_group` (`node_group_id`) 2018-10-12 10:50:31,651 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] 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-10-12 10:50:31,653 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] 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-10-12 10:50:31,656 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "sym_grouplet_link" ADD CONSTRAINT "sym_fk_gpltlnk_2_gplt" FOREIGN KEY ("grouplet_id") REFERENCES "sym_grouplet" ("grouplet_id") 2018-10-12 10:50:31,658 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] 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-10-12 10:50:31,661 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] 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-10-12 10:50:31,663 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "sym_node_identity" ADD CONSTRAINT "sym_fk_ident_2_node" FOREIGN KEY ("node_id") REFERENCES "sym_node" ("node_id") 2018-10-12 10:50:31,663 INFO [MYSQL01] [MySqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: ALTER TABLE `sym_node_identity` ADD CONSTRAINT `sym_fk_ident_2_node` FOREIGN KEY (`node_id`) REFERENCES `sym_node` (`node_id`) 2018-10-12 10:50:31,665 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "sym_node_security" ADD CONSTRAINT "sym_fk_sec_2_node" FOREIGN KEY ("node_id") REFERENCES "sym_node" ("node_id") 2018-10-12 10:50:31,668 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] 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-10-12 10:50:31,671 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] 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-10-12 10:50:31,673 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "sym_trigger" ADD CONSTRAINT "sym_fk_trg_2_chnl" FOREIGN KEY ("channel_id") REFERENCES "sym_channel" ("channel_id") 2018-10-12 10:50:31,676 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] 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-10-12 10:50:31,679 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "sym_trigger_router" ADD CONSTRAINT "sym_fk_tr_2_trg" FOREIGN KEY ("trigger_id") REFERENCES "sym_trigger" ("trigger_id") 2018-10-12 10:50:31,680 INFO [MYSQL01] [MySqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: ALTER TABLE `sym_node_security` ADD CONSTRAINT `sym_fk_sec_2_node` FOREIGN KEY (`node_id`) REFERENCES `sym_node` (`node_id`) 2018-10-12 10:50:31,683 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "sym_trigger_router" ADD CONSTRAINT "sym_fk_tr_2_rtr" FOREIGN KEY ("router_id") REFERENCES "sym_router" ("router_id") 2018-10-12 10:50:31,685 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] 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-10-12 10:50:31,688 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] 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-10-12 10:50:31,694 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] Done with auto update of SymmetricDS tables 2018-10-12 10:50:31,703 INFO [MYSQL01] [MySqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: ALTER TABLE `sym_router` ADD CONSTRAINT `sym_fk_rt_2_grp_lnk` FOREIGN KEY (`source_node_group_id`, `target_node_group_id`) REFERENCES `sym_node_group_link` (`source_node_group_id`, `target_node_group_id`) 2018-10-12 10:50:31,725 INFO [MYSQL01] [MySqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: ALTER TABLE `sym_transform_table` ADD CONSTRAINT `sym_fk_tt_2_grp_lnk` FOREIGN KEY (`source_node_group_id`, `target_node_group_id`) REFERENCES `sym_node_group_link` (`source_node_group_id`, `target_node_group_id`) 2018-10-12 10:50:31,733 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] Updating indexes to prevent lock escalation 2018-10-12 10:50:31,756 INFO [MYSQL01] [MySqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: ALTER TABLE `sym_trigger` ADD CONSTRAINT `sym_fk_trg_2_chnl` FOREIGN KEY (`channel_id`) REFERENCES `sym_channel` (`channel_id`) 2018-10-12 10:50:31,786 INFO [MYSQL01] [MySqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: ALTER TABLE `sym_trigger` ADD CONSTRAINT `sym_fk_trg_2_rld_chnl` FOREIGN KEY (`reload_channel_id`) REFERENCES `sym_channel` (`channel_id`) 2018-10-12 10:50:31,791 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] Installing SymmetricDS database object: create function dbo.sym_base64_encode(@data varbinary(max)) returns varchar(max) with schemabinding, returns null on null input begin return ( select [text()] = @data for xml path('') ) end 2018-10-12 10:50:31,795 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] Just installed sym_base64_encode 2018-10-12 10:50:31,797 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] Installing SymmetricDS database object: create function dbo.sym_triggers_disabled() returns smallint begin declare @disabled varchar(1); set @disabled = coalesce(replace(substring(cast(context_info() as varchar), 1, 1), 0x0, ''), ''); if @disabled is null or @disabled != '1' return 0; return 1; end 2018-10-12 10:50:31,799 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] Just installed sym_triggers_disabled 2018-10-12 10:50:31,801 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] Installing SymmetricDS database object: create function dbo.sym_node_disabled() returns varchar(50) begin declare @node varchar(50); set @node = coalesce(replace(substring(cast(context_info() as varchar) collate SQL_Latin1_General_CP1_CI_AS, 2, 50), 0x0, ''), ''); return @node; end 2018-10-12 10:50:31,804 INFO [MYSQL01] [MySqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: ALTER TABLE `sym_trigger_router` ADD CONSTRAINT `sym_fk_tr_2_trg` FOREIGN KEY (`trigger_id`) REFERENCES `sym_trigger` (`trigger_id`) 2018-10-12 10:50:31,805 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] Just installed sym_node_disabled 2018-10-12 10:50:31,806 INFO [MSSQL01] [ConfigurationService] [symmetric-engine-startup-2] Auto-configuring config channel 2018-10-12 10:50:31,817 INFO [MSSQL01] [ConfigurationService] [symmetric-engine-startup-2] Auto-configuring reload channel 2018-10-12 10:50:31,820 INFO [MSSQL01] [ConfigurationService] [symmetric-engine-startup-2] Auto-configuring monitor channel 2018-10-12 10:50:31,823 INFO [MSSQL01] [ConfigurationService] [symmetric-engine-startup-2] Auto-configuring heartbeat channel 2018-10-12 10:50:31,823 INFO [MYSQL01] [MySqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: ALTER TABLE `sym_trigger_router` ADD CONSTRAINT `sym_fk_tr_2_rtr` FOREIGN KEY (`router_id`) REFERENCES `sym_router` (`router_id`) 2018-10-12 10:50:31,826 INFO [MSSQL01] [ConfigurationService] [symmetric-engine-startup-2] Auto-configuring default channel 2018-10-12 10:50:31,829 INFO [MSSQL01] [ConfigurationService] [symmetric-engine-startup-2] Auto-configuring dynamic channel 2018-10-12 10:50:31,838 INFO [MYSQL01] [MySqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: ALTER TABLE `sym_trigger_router_grouplet` ADD CONSTRAINT `sym_fk_trgplt_2_gplt` FOREIGN KEY (`grouplet_id`) REFERENCES `sym_grouplet` (`grouplet_id`) 2018-10-12 10:50:31,855 INFO [MYSQL01] [MySqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: ALTER TABLE `sym_trigger_router_grouplet` ADD CONSTRAINT `sym_fk_trgplt_2_tr` FOREIGN KEY (`trigger_id`, `router_id`) REFERENCES `sym_trigger_router` (`trigger_id`, `router_id`) 2018-10-12 10:50:31,863 INFO [MYSQL01] [MySqlSymmetricDialect] [symmetric-engine-startup-1] Done with auto update of SymmetricDS tables 2018-10-12 10:50:31,864 INFO [MYSQL01] [MySqlSymmetricDialect] [symmetric-engine-startup-1] Installing SymmetricDS database object: create function sym_transaction_id_post_5_7_6() returns varchar(50) NOT DETERMINISTIC READS SQL DATA begin declare done int default 0; declare comm_value varchar(50); declare comm_cur cursor for select TRX_ID from INFORMATION_SCHEMA.INNODB_TRX where TRX_MYSQL_THREAD_ID = CONNECTION_ID(); declare continue handler for not found set done = 1; open comm_cur; fetch comm_cur into comm_value; close comm_cur; return concat(concat(connection_id(), '.'), comm_value); end 2018-10-12 10:50:31,867 INFO [MYSQL01] [MySqlSymmetricDialect] [symmetric-engine-startup-1] Just installed sym_transaction_id_post_5_7_6 2018-10-12 10:50:31,869 INFO [MYSQL01] [ConfigurationService] [symmetric-engine-startup-1] Auto-configuring config channel 2018-10-12 10:50:31,876 INFO [MYSQL01] [ConfigurationService] [symmetric-engine-startup-1] Auto-configuring reload channel 2018-10-12 10:50:31,880 INFO [MYSQL01] [ConfigurationService] [symmetric-engine-startup-1] Auto-configuring monitor channel 2018-10-12 10:50:31,883 INFO [MYSQL01] [ConfigurationService] [symmetric-engine-startup-1] Auto-configuring heartbeat channel 2018-10-12 10:50:31,887 INFO [MYSQL01] [ConfigurationService] [symmetric-engine-startup-1] Auto-configuring default channel 2018-10-12 10:50:31,890 INFO [MYSQL01] [ConfigurationService] [symmetric-engine-startup-1] Auto-configuring dynamic channel 2018-10-12 10:50:31,892 INFO [MSSQL01] [AbstractSymmetricEngine] [symmetric-engine-startup-2] Inserting rows for node, security, identity and group for registration server 2018-10-12 10:50:31,918 INFO [MYSQL01] [AbstractSymmetricEngine] [symmetric-engine-startup-1] Done initializing SymmetricDS database 2018-10-12 10:50:31,920 INFO [MYSQL01] [AbstractSymmetricEngine] [symmetric-engine-startup-1] SymmetricDS database version : null 2018-10-12 10:50:31,920 INFO [MYSQL01] [AbstractSymmetricEngine] [symmetric-engine-startup-1] SymmetricDS software version : 3.9.14 2018-10-12 10:50:31,933 INFO [MSSQL01] [AbstractSymmetricEngine] [symmetric-engine-startup-2] Done initializing SymmetricDS database 2018-10-12 10:50:31,933 INFO [MSSQL01] [AbstractSymmetricEngine] [symmetric-engine-startup-2] SymmetricDS database version : 3.9.14 2018-10-12 10:50:31,933 INFO [MSSQL01] [AbstractSymmetricEngine] [symmetric-engine-startup-2] SymmetricDS software version : 3.9.14 2018-10-12 10:50:31,963 INFO [MYSQL01] [AbstractSymmetricEngine] [symmetric-engine-startup-1] Starting unregistered node [group=dest, externalId=001] 2018-10-12 10:50:31,983 INFO [MYSQL01] [RouterJob] [symmetric-engine-startup-1] Starting Routing on periodic schedule: every 10000ms with the first run at Fri Oct 12 10:50:39 UTC 2018 2018-10-12 10:50:31,985 INFO [MYSQL01] [PushJob] [symmetric-engine-startup-1] Starting Push on periodic schedule: every 60000ms with the first run at Fri Oct 12 10:50:39 UTC 2018 2018-10-12 10:50:31,986 INFO [MYSQL01] [PullJob] [symmetric-engine-startup-1] Starting Pull on periodic schedule: every 60000ms with the first run at Fri Oct 12 10:50:39 UTC 2018 2018-10-12 10:50:31,986 INFO [MYSQL01] [JobManager] [symmetric-engine-startup-1] Job Offline Push not configured for auto start 2018-10-12 10:50:31,986 INFO [MYSQL01] [JobManager] [symmetric-engine-startup-1] Job Offline Pull not configured for auto start 2018-10-12 10:50:31,988 INFO [MYSQL01] [OutgoingPurgeJob] [symmetric-engine-startup-1] Starting job 'Purge Outgoing' with cron expression: '0 0 0 * * *' 2018-10-12 10:50:31,990 INFO [MYSQL01] [IncomingPurgeJob] [symmetric-engine-startup-1] Starting job 'Purge Incoming' with cron expression: '0 0 0 * * *' 2018-10-12 10:50:31,990 INFO [MYSQL01] [StatisticFlushJob] [symmetric-engine-startup-1] Starting job 'Stat Flush' with cron expression: '0 0/5 * * * *' 2018-10-12 10:50:31,991 INFO [MYSQL01] [SyncTriggersJob] [symmetric-engine-startup-1] Starting job 'SyncTriggers' with cron expression: '0 0 0 * * *' 2018-10-12 10:50:31,991 INFO [MYSQL01] [HeartbeatJob] [symmetric-engine-startup-1] Starting Heartbeat on periodic schedule: every 900000ms with the first run at Fri Oct 12 10:50:39 UTC 2018 2018-10-12 10:50:31,992 INFO [MYSQL01] [WatchdogJob] [symmetric-engine-startup-1] Starting Watchdog on periodic schedule: every 3600000ms with the first run at Fri Oct 12 10:50:39 UTC 2018 2018-10-12 10:50:31,992 INFO [MYSQL01] [StageManagementJob] [symmetric-engine-startup-1] Starting job 'Stage Management' with cron expression: '0 0 * * * *' 2018-10-12 10:50:31,993 INFO [MYSQL01] [JobManager] [symmetric-engine-startup-1] Job Refresh Cache not configured for auto start 2018-10-12 10:50:31,993 INFO [MYSQL01] [JobManager] [symmetric-engine-startup-1] Job File Sync Tracker not configured for auto start 2018-10-12 10:50:31,993 INFO [MYSQL01] [JobManager] [symmetric-engine-startup-1] Job File Sync Pull not configured for auto start 2018-10-12 10:50:31,993 INFO [MYSQL01] [JobManager] [symmetric-engine-startup-1] Job File Sync Push not configured for auto start 2018-10-12 10:50:31,993 INFO [MYSQL01] [InitialLoadExtractorJob] [symmetric-engine-startup-1] Starting Initial Load Extract on periodic schedule: every 10000ms with the first run at Fri Oct 12 10:50:39 UTC 2018 2018-10-12 10:50:31,993 INFO [MYSQL01] [MonitorJob] [symmetric-engine-startup-1] Starting Monitor on periodic schedule: every 60000ms with the first run at Fri Oct 12 10:50:39 UTC 2018 2018-10-12 10:50:31,994 INFO [MYSQL01] [JobManager] [symmetric-engine-startup-1] Job Report Status not configured for auto start 2018-10-12 10:50:31,996 INFO [MYSQL01] [ClusterService] [symmetric-engine-startup-1] This node picked a server id of SDS01 2018-10-12 10:50:31,998 INFO [MYSQL01] [AbstractSymmetricEngine] [symmetric-engine-startup-1] SymmetricDS Node STARTED: nodeId=001 groupId=dest type=server subType=null name=MYSQL01 softwareVersion=3.9.14 databaseName=MySQL databaseVersion=8.0 driverName=MySQL Connector Java driverVersion=mysql-connector-java-5.1.45 ( Revision: 9131eefa398531c7dc98776e8a3fe839e544c5b2 ) uptime=0 sec. 2018-10-12 10:50:32,295 INFO [MSSQL01] [AbstractSymmetricEngine] [symmetric-engine-startup-2] Starting registered node [group=src, id=000, nodeId=000] 2018-10-12 10:50:32,300 INFO [MSSQL01] [ClusterService] [symmetric-engine-startup-2] This node picked a server id of SDS01 2018-10-12 10:50:32,300 INFO [MSSQL01] [TriggerRouterService] [symmetric-engine-startup-2] Synchronizing triggers 2018-10-12 10:50:32,344 INFO [MSSQL01] [TriggerRouterService] [symmetric-engine-startup-2] Done synchronizing triggers 2018-10-12 10:50:32,350 INFO [MSSQL01] [RouterJob] [symmetric-engine-startup-2] Starting Routing on periodic schedule: every 10000ms with the first run at Fri Oct 12 10:50:42 UTC 2018 2018-10-12 10:50:32,351 INFO [MSSQL01] [PushJob] [symmetric-engine-startup-2] Starting Push on periodic schedule: every 60000ms with the first run at Fri Oct 12 10:50:42 UTC 2018 2018-10-12 10:50:32,351 INFO [MSSQL01] [PullJob] [symmetric-engine-startup-2] Starting Pull on periodic schedule: every 60000ms with the first run at Fri Oct 12 10:50:42 UTC 2018 2018-10-12 10:50:32,351 INFO [MSSQL01] [JobManager] [symmetric-engine-startup-2] Job Offline Push not configured for auto start 2018-10-12 10:50:32,351 INFO [MSSQL01] [JobManager] [symmetric-engine-startup-2] Job Offline Pull not configured for auto start 2018-10-12 10:50:32,352 INFO [MSSQL01] [OutgoingPurgeJob] [symmetric-engine-startup-2] Starting job 'Purge Outgoing' with cron expression: '0 0 0 * * *' 2018-10-12 10:50:32,352 INFO [MSSQL01] [IncomingPurgeJob] [symmetric-engine-startup-2] Starting job 'Purge Incoming' with cron expression: '0 0 0 * * *' 2018-10-12 10:50:32,353 INFO [MSSQL01] [StatisticFlushJob] [symmetric-engine-startup-2] Starting job 'Stat Flush' with cron expression: '0 0/5 * * * *' 2018-10-12 10:50:32,353 INFO [MSSQL01] [SyncTriggersJob] [symmetric-engine-startup-2] Starting job 'SyncTriggers' with cron expression: '0 0 0 * * *' 2018-10-12 10:50:32,354 INFO [MSSQL01] [HeartbeatJob] [symmetric-engine-startup-2] Starting Heartbeat on periodic schedule: every 900000ms with the first run at Fri Oct 12 10:50:42 UTC 2018 2018-10-12 10:50:32,354 INFO [MSSQL01] [WatchdogJob] [symmetric-engine-startup-2] Starting Watchdog on periodic schedule: every 3600000ms with the first run at Fri Oct 12 10:50:42 UTC 2018 2018-10-12 10:50:32,355 INFO [MSSQL01] [StageManagementJob] [symmetric-engine-startup-2] Starting job 'Stage Management' with cron expression: '0 0 * * * *' 2018-10-12 10:50:32,355 INFO [MSSQL01] [JobManager] [symmetric-engine-startup-2] Job Refresh Cache not configured for auto start 2018-10-12 10:50:32,355 INFO [MSSQL01] [JobManager] [symmetric-engine-startup-2] Job File Sync Tracker not configured for auto start 2018-10-12 10:50:32,355 INFO [MSSQL01] [JobManager] [symmetric-engine-startup-2] Job File Sync Pull not configured for auto start 2018-10-12 10:50:32,355 INFO [MSSQL01] [JobManager] [symmetric-engine-startup-2] Job File Sync Push not configured for auto start 2018-10-12 10:50:32,356 INFO [MSSQL01] [InitialLoadExtractorJob] [symmetric-engine-startup-2] Starting Initial Load Extract on periodic schedule: every 10000ms with the first run at Fri Oct 12 10:50:42 UTC 2018 2018-10-12 10:50:32,356 INFO [MSSQL01] [MonitorJob] [symmetric-engine-startup-2] Starting Monitor on periodic schedule: every 60000ms with the first run at Fri Oct 12 10:50:42 UTC 2018 2018-10-12 10:50:32,356 INFO [MSSQL01] [JobManager] [symmetric-engine-startup-2] Job Report Status not configured for auto start 2018-10-12 10:50:32,357 INFO [MSSQL01] [AbstractSymmetricEngine] [symmetric-engine-startup-2] SymmetricDS Node STARTED: nodeId=000 groupId=src type=server subType=null name=MSSQL01 softwareVersion=3.9.14 databaseName=Microsoft SQL Server databaseVersion=12.0 driverName=jTDS Type 4 JDBC Driver for MS SQL Server and Sybase driverVersion=1.2.8 uptime=0 sec. 2018-10-12 10:50:34,731 INFO [] [AbstractCommandLauncher] [main] Option: name=engine, value={MSSQL01} 2018-10-12 10:50:35,065 INFO [] [SymmetricUtils] [main] _____ __ _ ____ _____ / ___/ __ _____ __ ___ __ ___ _/ /_ ____(_)___ / __ | / ___/ \__ \ / / / / _ `_ \/ _ `_ \/ _ \/_ __// __/ / __/ / / / / \__ \ ___/ // /_/ / // // / // // / __// / / / / / /_ / /_/ / ___/ / /____/ \__ /_//_//_/_//_//_/\___/ \_/ /_/ /_/\__/ /_____/ /____/ /____/ +-----------------------------------------------------------------+ | Copyright (C) 2007-2018 JumpMind, Inc. | | | | Licensed under the GNU General Public License version 3. | | This software comes with ABSOLUTELY NO WARRANTY. | | See http://www.gnu.org/licenses/gpl.html | +-----------------------------------------------------------------+ 2018-10-12 10:50:35,078 INFO [MSSQL01] [AbstractSymmetricEngine] [main] Initializing connection to database 2018-10-12 10:50:35,122 INFO [MSSQL01] [JdbcDatabasePlatformFactory] [main] Detected database 'Microsoft SQL Server', version '12', protocol 'jtds' 2018-10-12 10:50:35,149 INFO [MSSQL01] [JdbcDatabasePlatformFactory] [main] The IDatabasePlatform being used is org.jumpmind.db.platform.mssql.MsSql2008DatabasePlatform 2018-10-12 10:50:35,285 INFO [MSSQL01] [MsSqlSymmetricDialect] [main] The DbDialect being used is org.jumpmind.symmetric.db.mssql.MsSqlSymmetricDialect 2018-10-12 10:50:35,326 INFO [MSSQL01] [ExtensionService] [main] Found 0 extension points from the database that will be registered 2018-10-12 10:50:35,332 INFO [MSSQL01] [StagingManager] [main] The staging directory was initialized at the following location: /opt/symmetric-server/tmp/MSSQL01 2018-10-12 10:50:36,232 INFO [MSSQL01] [ExtensionService] [main] Found 0 extension points from the database that will be registered 2018-10-12 10:50:36,232 INFO [MSSQL01] [ClientExtensionService] [main] Found 7 extension points from spring that will be registered 2018-10-12 10:50:36,294 INFO [MSSQL01] [RegistrationService] [main] Just opened registration for external id of 001 and a node group of dest and a node id of 001 2018-10-12 10:50:36,918 INFO [] [AbstractCommandLauncher] [main] Option: name=engine, value={MSSQL01} 2018-10-12 10:50:36,930 INFO [] [AbstractSymmetricEngine] [main] Initializing connection to database 2018-10-12 10:50:37,175 INFO [] [JdbcDatabasePlatformFactory] [main] Detected database 'Microsoft SQL Server', version '12', protocol 'jtds' 2018-10-12 10:50:37,201 INFO [] [JdbcDatabasePlatformFactory] [main] The IDatabasePlatform being used is org.jumpmind.db.platform.mssql.MsSql2008DatabasePlatform 2018-10-12 10:50:39,895 INFO [startup] [AbstractCommandLauncher] [main] Option: name=max-idle-time, value={90000} 2018-10-12 10:50:39,896 INFO [startup] [AbstractCommandLauncher] [main] Option: name=no-log-console, value={} 2018-10-12 10:50:39,974 INFO [startup] [SymmetricUtils] [main] _____ __ _ ____ _____ / ___/ __ _____ __ ___ __ ___ _/ /_ ____(_)___ / __ | / ___/ \__ \ / / / / _ `_ \/ _ `_ \/ _ \/_ __// __/ / __/ / / / / \__ \ ___/ // /_/ / // // / // // / __// / / / / / /_ / /_/ / ___/ / /____/ \__ /_//_//_/_//_//_/\___/ \_/ /_/ /_/\__/ /_____/ /____/ /____/ +-----------------------------------------------------------------+ | Copyright (C) 2007-2018 JumpMind, Inc. | | | | Licensed under the GNU General Public License version 3. | | This software comes with ABSOLUTELY NO WARRANTY. | | See http://www.gnu.org/licenses/gpl.html | +-----------------------------------------------------------------+ 2018-10-12 10:50:40,026 INFO [startup] [SymmetricWebServer] [main] About to start SymmetricDS web server on host:port 0.0.0.0:31415 2018-10-12 10:50:40,560 INFO [MYSQL01] [AbstractSymmetricEngine] [symmetric-engine-startup-1] Initializing connection to database 2018-10-12 10:50:40,560 INFO [MSSQL01] [AbstractSymmetricEngine] [symmetric-engine-startup-2] Initializing connection to database 2018-10-12 10:50:40,968 INFO [MYSQL01] [JdbcDatabasePlatformFactory] [symmetric-engine-startup-1] Detected database 'MySQL', version '8', protocol 'mysql' 2018-10-12 10:50:40,992 INFO [MYSQL01] [JdbcDatabasePlatformFactory] [symmetric-engine-startup-1] The IDatabasePlatform being used is org.jumpmind.db.platform.mysql.MySqlDatabasePlatform 2018-10-12 10:50:41,039 INFO [MSSQL01] [JdbcDatabasePlatformFactory] [symmetric-engine-startup-2] Detected database 'Microsoft SQL Server', version '12', protocol 'jtds' 2018-10-12 10:50:41,047 INFO [MSSQL01] [JdbcDatabasePlatformFactory] [symmetric-engine-startup-2] The IDatabasePlatform being used is org.jumpmind.db.platform.mssql.MsSql2008DatabasePlatform 2018-10-12 10:50:41,130 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] The DbDialect being used is org.jumpmind.symmetric.db.mssql.MsSqlSymmetricDialect 2018-10-12 10:50:41,164 INFO [MSSQL01] [ExtensionService] [symmetric-engine-startup-2] Found 0 extension points from the database that will be registered 2018-10-12 10:50:41,172 INFO [MSSQL01] [StagingManager] [symmetric-engine-startup-2] The staging directory was initialized at the following location: tmp/MSSQL01 2018-10-12 10:50:41,202 INFO [MYSQL01] [MySqlSymmetricDialect] [symmetric-engine-startup-1] The DbDialect being used is org.jumpmind.symmetric.db.mysql.MySqlSymmetricDialect 2018-10-12 10:50:41,244 INFO [MYSQL01] [ExtensionService] [symmetric-engine-startup-1] Found 0 extension points from the database that will be registered 2018-10-12 10:50:41,246 INFO [MYSQL01] [StagingManager] [symmetric-engine-startup-1] The staging directory was initialized at the following location: tmp/MYSQL01 2018-10-12 10:50:41,917 INFO [MYSQL01] [ExtensionService] [symmetric-engine-startup-1] Found 0 extension points from the database that will be registered 2018-10-12 10:50:41,918 INFO [MYSQL01] [ClientExtensionService] [symmetric-engine-startup-1] Found 7 extension points from spring that will be registered 2018-10-12 10:50:41,919 INFO [MSSQL01] [ExtensionService] [symmetric-engine-startup-2] Found 0 extension points from the database that will be registered 2018-10-12 10:50:41,919 INFO [MSSQL01] [ClientExtensionService] [symmetric-engine-startup-2] Found 7 extension points from spring that will be registered 2018-10-12 10:50:41,929 INFO [MYSQL01] [AbstractSymmetricEngine] [symmetric-engine-startup-1] Initializing SymmetricDS database 2018-10-12 10:50:41,930 INFO [MYSQL01] [MySqlSymmetricDialect] [symmetric-engine-startup-1] Checking if SymmetricDS tables need created or altered 2018-10-12 10:50:41,931 INFO [MSSQL01] [AbstractSymmetricEngine] [symmetric-engine-startup-2] Initializing SymmetricDS database 2018-10-12 10:50:41,931 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] Checking if SymmetricDS tables need created or altered 2018-10-12 10:50:42,166 INFO [startup] [SymmetricWebServer] [main] Starting JMX HTTP console on port 31416 2018-10-12 10:50:42,190 INFO [startup] [SymmetricWebServer] [main] Joining the web server main thread 2018-10-12 10:50:42,764 INFO [MYSQL01] [ConfigurationService] [symmetric-engine-startup-1] Auto-configuring config channel 2018-10-12 10:50:42,778 INFO [MYSQL01] [ConfigurationService] [symmetric-engine-startup-1] Auto-configuring reload channel 2018-10-12 10:50:42,780 INFO [MYSQL01] [ConfigurationService] [symmetric-engine-startup-1] Auto-configuring monitor channel 2018-10-12 10:50:42,782 INFO [MYSQL01] [ConfigurationService] [symmetric-engine-startup-1] Auto-configuring heartbeat channel 2018-10-12 10:50:42,783 INFO [MYSQL01] [ConfigurationService] [symmetric-engine-startup-1] Auto-configuring default channel 2018-10-12 10:50:42,785 INFO [MYSQL01] [ConfigurationService] [symmetric-engine-startup-1] Auto-configuring dynamic channel 2018-10-12 10:50:42,817 INFO [MYSQL01] [AbstractSymmetricEngine] [symmetric-engine-startup-1] Done initializing SymmetricDS database 2018-10-12 10:50:42,819 INFO [MYSQL01] [AbstractSymmetricEngine] [symmetric-engine-startup-1] SymmetricDS database version : null 2018-10-12 10:50:42,819 INFO [MYSQL01] [AbstractSymmetricEngine] [symmetric-engine-startup-1] SymmetricDS software version : 3.9.14 2018-10-12 10:50:42,831 INFO [MYSQL01] [AbstractSymmetricEngine] [symmetric-engine-startup-1] Starting unregistered node [group=dest, externalId=001] 2018-10-12 10:50:42,854 INFO [MYSQL01] [RouterJob] [symmetric-engine-startup-1] Starting Routing on periodic schedule: every 10000ms with the first run at Fri Oct 12 10:50:50 UTC 2018 2018-10-12 10:50:42,857 INFO [MYSQL01] [PushJob] [symmetric-engine-startup-1] Starting Push on periodic schedule: every 60000ms with the first run at Fri Oct 12 10:50:50 UTC 2018 2018-10-12 10:50:42,858 INFO [MYSQL01] [PullJob] [symmetric-engine-startup-1] Starting Pull on periodic schedule: every 60000ms with the first run at Fri Oct 12 10:50:50 UTC 2018 2018-10-12 10:50:42,858 INFO [MYSQL01] [JobManager] [symmetric-engine-startup-1] Job Offline Push not configured for auto start 2018-10-12 10:50:42,858 INFO [MYSQL01] [JobManager] [symmetric-engine-startup-1] Job Offline Pull not configured for auto start 2018-10-12 10:50:42,861 INFO [MYSQL01] [OutgoingPurgeJob] [symmetric-engine-startup-1] Starting job 'Purge Outgoing' with cron expression: '0 0 0 * * *' 2018-10-12 10:50:42,863 INFO [MYSQL01] [IncomingPurgeJob] [symmetric-engine-startup-1] Starting job 'Purge Incoming' with cron expression: '0 0 0 * * *' 2018-10-12 10:50:42,863 INFO [MYSQL01] [StatisticFlushJob] [symmetric-engine-startup-1] Starting job 'Stat Flush' with cron expression: '0 0/5 * * * *' 2018-10-12 10:50:42,864 INFO [MYSQL01] [SyncTriggersJob] [symmetric-engine-startup-1] Starting job 'SyncTriggers' with cron expression: '0 0 0 * * *' 2018-10-12 10:50:42,865 INFO [MYSQL01] [HeartbeatJob] [symmetric-engine-startup-1] Starting Heartbeat on periodic schedule: every 900000ms with the first run at Fri Oct 12 10:50:50 UTC 2018 2018-10-12 10:50:42,865 INFO [MYSQL01] [WatchdogJob] [symmetric-engine-startup-1] Starting Watchdog on periodic schedule: every 3600000ms with the first run at Fri Oct 12 10:50:50 UTC 2018 2018-10-12 10:50:42,866 INFO [MYSQL01] [StageManagementJob] [symmetric-engine-startup-1] Starting job 'Stage Management' with cron expression: '0 0 * * * *' 2018-10-12 10:50:42,866 INFO [MYSQL01] [JobManager] [symmetric-engine-startup-1] Job Refresh Cache not configured for auto start 2018-10-12 10:50:42,866 INFO [MYSQL01] [JobManager] [symmetric-engine-startup-1] Job File Sync Tracker not configured for auto start 2018-10-12 10:50:42,866 INFO [MYSQL01] [JobManager] [symmetric-engine-startup-1] Job File Sync Pull not configured for auto start 2018-10-12 10:50:42,866 INFO [MYSQL01] [JobManager] [symmetric-engine-startup-1] Job File Sync Push not configured for auto start 2018-10-12 10:50:42,866 INFO [MYSQL01] [InitialLoadExtractorJob] [symmetric-engine-startup-1] Starting Initial Load Extract on periodic schedule: every 10000ms with the first run at Fri Oct 12 10:50:50 UTC 2018 2018-10-12 10:50:42,867 INFO [MYSQL01] [MonitorJob] [symmetric-engine-startup-1] Starting Monitor on periodic schedule: every 60000ms with the first run at Fri Oct 12 10:50:50 UTC 2018 2018-10-12 10:50:42,867 INFO [MYSQL01] [JobManager] [symmetric-engine-startup-1] Job Report Status not configured for auto start 2018-10-12 10:50:42,871 INFO [MYSQL01] [ClusterService] [symmetric-engine-startup-1] This node picked a server id of SDS01 2018-10-12 10:50:42,873 INFO [MYSQL01] [AbstractSymmetricEngine] [symmetric-engine-startup-1] SymmetricDS Node STARTED: nodeId=001 groupId=dest type=server subType=null name=MYSQL01 softwareVersion=3.9.14 databaseName=MySQL databaseVersion=8.0 driverName=MySQL Connector Java driverVersion=mysql-connector-java-5.1.45 ( Revision: 9131eefa398531c7dc98776e8a3fe839e544c5b2 ) uptime=0 sec. 2018-10-12 10:50:43,006 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] There are SymmetricDS tables that needed altered 2018-10-12 10:50:43,007 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on 2018-10-12 10:50:43,011 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: DROP INDEX "sym_idx_ib_time_status" ON "SyncTest"."dbo"."sym_incoming_batch" 2018-10-12 10:50:43,014 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: DROP INDEX "sym_idx_nd_hst_chnl_sts" ON "SyncTest"."dbo"."sym_node_host_channel_stats" 2018-10-12 10:50:43,016 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: DROP INDEX "sym_idx_nd_hst_job" ON "SyncTest"."dbo"."sym_node_host_job_stats" 2018-10-12 10:50:43,018 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: DROP INDEX "sym_idx_nd_hst_sts" ON "SyncTest"."dbo"."sym_node_host_stats" 2018-10-12 10:50:43,020 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: DROP INDEX "sym_idx_trigg_hist_1" ON "SyncTest"."dbo"."sym_trigger_hist" 2018-10-12 10:50:43,029 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'F' AND name = 'sym_fk_cf_2_grp_lnk') ALTER TABLE "sym_conflict" DROP CONSTRAINT "sym_fk_cf_2_grp_lnk" 2018-10-12 10:50:43,036 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'F' AND name = 'sym_fk_ftr_2_ftrg') ALTER TABLE "sym_file_trigger_router" DROP CONSTRAINT "sym_fk_ftr_2_ftrg" 2018-10-12 10:50:43,043 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'F' AND name = 'sym_fk_ftr_2_rtr') ALTER TABLE "sym_file_trigger_router" DROP CONSTRAINT "sym_fk_ftr_2_rtr" 2018-10-12 10:50:43,049 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'F' AND name = 'sym_fk_gpltlnk_2_gplt') ALTER TABLE "sym_grouplet_link" DROP CONSTRAINT "sym_fk_gpltlnk_2_gplt" 2018-10-12 10:50:43,056 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'F' AND name = 'sym_fk_lnk_2_grp_src') ALTER TABLE "sym_node_group_link" DROP CONSTRAINT "sym_fk_lnk_2_grp_src" 2018-10-12 10:50:43,062 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'F' AND name = 'sym_fk_lnk_2_grp_tgt') ALTER TABLE "sym_node_group_link" DROP CONSTRAINT "sym_fk_lnk_2_grp_tgt" 2018-10-12 10:50:43,069 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'F' AND name = 'sym_fk_sec_2_node') ALTER TABLE "sym_node_security" DROP CONSTRAINT "sym_fk_sec_2_node" 2018-10-12 10:50:43,076 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'F' AND name = 'sym_fk_rt_2_grp_lnk') ALTER TABLE "sym_router" DROP CONSTRAINT "sym_fk_rt_2_grp_lnk" 2018-10-12 10:50:43,082 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'F' AND name = 'sym_fk_tt_2_grp_lnk') ALTER TABLE "sym_transform_table" DROP CONSTRAINT "sym_fk_tt_2_grp_lnk" 2018-10-12 10:50:43,089 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'F' AND name = 'sym_fk_trg_2_chnl') ALTER TABLE "sym_trigger" DROP CONSTRAINT "sym_fk_trg_2_chnl" 2018-10-12 10:50:43,097 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'F' AND name = 'sym_fk_trg_2_rld_chnl') ALTER TABLE "sym_trigger" DROP CONSTRAINT "sym_fk_trg_2_rld_chnl" 2018-10-12 10:50:43,103 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'F' AND name = 'sym_fk_tr_2_trg') ALTER TABLE "sym_trigger_router" DROP CONSTRAINT "sym_fk_tr_2_trg" 2018-10-12 10:50:43,110 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'F' AND name = 'sym_fk_tr_2_rtr') ALTER TABLE "sym_trigger_router" DROP CONSTRAINT "sym_fk_tr_2_rtr" 2018-10-12 10:50:43,117 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'F' AND name = 'sym_fk_trgplt_2_gplt') ALTER TABLE "sym_trigger_router_grouplet" DROP CONSTRAINT "sym_fk_trgplt_2_gplt" 2018-10-12 10:50:43,124 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'F' AND name = 'sym_fk_trgplt_2_tr') ALTER TABLE "sym_trigger_router_grouplet" DROP CONSTRAINT "sym_fk_trgplt_2_tr" 2018-10-12 10:50:43,127 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "SyncTest"."dbo"."sym_channel" ALTER COLUMN "create_time" DATETIME2 2018-10-12 10:50:43,129 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "SyncTest"."dbo"."sym_channel" ALTER COLUMN "last_update_time" DATETIME2 2018-10-12 10:50:43,131 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "SyncTest"."dbo"."sym_conflict" ALTER COLUMN "create_time" DATETIME2 NOT NULL 2018-10-12 10:50:43,133 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "SyncTest"."dbo"."sym_conflict" ALTER COLUMN "last_update_time" DATETIME2 NOT NULL 2018-10-12 10:50:43,136 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "SyncTest"."dbo"."sym_context" ALTER COLUMN "create_time" DATETIME2 2018-10-12 10:50:43,138 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "SyncTest"."dbo"."sym_context" ALTER COLUMN "last_update_time" DATETIME2 2018-10-12 10:50:43,140 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "SyncTest"."dbo"."sym_data" ALTER COLUMN "create_time" DATETIME2 2018-10-12 10:50:43,142 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "SyncTest"."dbo"."sym_data_event" ALTER COLUMN "create_time" DATETIME2 2018-10-12 10:50:43,145 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "SyncTest"."dbo"."sym_data_gap" ALTER COLUMN "create_time" DATETIME2 NOT NULL 2018-10-12 10:50:43,147 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "SyncTest"."dbo"."sym_data_gap" ALTER COLUMN "last_update_time" DATETIME2 NOT NULL 2018-10-12 10:50:43,149 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "SyncTest"."dbo"."sym_extension" ALTER COLUMN "create_time" DATETIME2 2018-10-12 10:50:43,151 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "SyncTest"."dbo"."sym_extension" ALTER COLUMN "last_update_time" DATETIME2 2018-10-12 10:50:43,153 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "SyncTest"."dbo"."sym_extract_request" ALTER COLUMN "last_update_time" DATETIME2 2018-10-12 10:50:43,156 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "SyncTest"."dbo"."sym_extract_request" ALTER COLUMN "create_time" DATETIME2 2018-10-12 10:50:43,158 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "SyncTest"."dbo"."sym_file_snapshot" ALTER COLUMN "last_update_time" DATETIME2 NOT NULL 2018-10-12 10:50:43,160 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "SyncTest"."dbo"."sym_file_snapshot" ALTER COLUMN "create_time" DATETIME2 NOT NULL 2018-10-12 10:50:43,162 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "SyncTest"."dbo"."sym_file_trigger" ALTER COLUMN "create_time" DATETIME2 NOT NULL 2018-10-12 10:50:43,165 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "SyncTest"."dbo"."sym_file_trigger" ALTER COLUMN "last_update_time" DATETIME2 NOT NULL 2018-10-12 10:50:43,167 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "SyncTest"."dbo"."sym_file_trigger_router" ALTER COLUMN "create_time" DATETIME2 NOT NULL 2018-10-12 10:50:43,169 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "SyncTest"."dbo"."sym_file_trigger_router" ALTER COLUMN "last_update_time" DATETIME2 NOT NULL 2018-10-12 10:50:43,171 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "SyncTest"."dbo"."sym_grouplet" ALTER COLUMN "create_time" DATETIME2 NOT NULL 2018-10-12 10:50:43,173 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "SyncTest"."dbo"."sym_grouplet" ALTER COLUMN "last_update_time" DATETIME2 NOT NULL 2018-10-12 10:50:43,176 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "SyncTest"."dbo"."sym_grouplet_link" ALTER COLUMN "create_time" DATETIME2 NOT NULL 2018-10-12 10:50:43,178 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "SyncTest"."dbo"."sym_grouplet_link" ALTER COLUMN "last_update_time" DATETIME2 NOT NULL 2018-10-12 10:50:43,180 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "SyncTest"."dbo"."sym_incoming_batch" ALTER COLUMN "last_update_time" DATETIME2 2018-10-12 10:50:43,182 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "SyncTest"."dbo"."sym_incoming_batch" ALTER COLUMN "create_time" DATETIME2 2018-10-12 10:50:43,185 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "SyncTest"."dbo"."sym_incoming_error" ALTER COLUMN "create_time" DATETIME2 2018-10-12 10:50:43,187 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "SyncTest"."dbo"."sym_incoming_error" ALTER COLUMN "last_update_time" DATETIME2 NOT NULL 2018-10-12 10:50:43,189 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "SyncTest"."dbo"."sym_job" ALTER COLUMN "create_time" DATETIME2 2018-10-12 10:50:43,191 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "SyncTest"."dbo"."sym_job" ALTER COLUMN "last_update_time" DATETIME2 2018-10-12 10:50:43,194 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "SyncTest"."dbo"."sym_load_filter" ALTER COLUMN "create_time" DATETIME2 NOT NULL 2018-10-12 10:50:43,196 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "SyncTest"."dbo"."sym_load_filter" ALTER COLUMN "last_update_time" DATETIME2 NOT NULL 2018-10-12 10:50:43,199 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "SyncTest"."dbo"."sym_lock" ALTER COLUMN "lock_time" DATETIME2 2018-10-12 10:50:43,201 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "SyncTest"."dbo"."sym_lock" ALTER COLUMN "last_lock_time" DATETIME2 2018-10-12 10:50:43,205 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "SyncTest"."dbo"."sym_node" ALTER COLUMN "heartbeat_time" DATETIME2 2018-10-12 10:50:43,207 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "SyncTest"."dbo"."sym_node_communication" ALTER COLUMN "lock_time" DATETIME2 2018-10-12 10:50:43,209 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "SyncTest"."dbo"."sym_node_communication" ALTER COLUMN "last_lock_time" DATETIME2 2018-10-12 10:50:43,211 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "SyncTest"."dbo"."sym_node_channel_ctl" ALTER COLUMN "last_extract_time" DATETIME2 2018-10-12 10:50:43,213 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "SyncTest"."dbo"."sym_node_group" ALTER COLUMN "create_time" DATETIME2 2018-10-12 10:50:43,216 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "SyncTest"."dbo"."sym_node_group" ALTER COLUMN "last_update_time" DATETIME2 2018-10-12 10:50:43,216 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on 2018-10-12 10:50:43,226 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name = 'sym_node_group_channel_wnd_') BEGIN DECLARE @tn501e0ee8_16667e651bd__7ffb nvarchar(256), @cn501e0ee8_16667e651bd__7ffa nvarchar(256) DECLARE refcursor CURSOR FOR SELECT object_name(objs.parent_obj) tablename, objs.name constraintname FROM sysobjects objs WHERE objs.xtype in ('C','D','F','UQ') AND object_name(objs.parent_obj) = 'sym_node_group_channel_wnd_' OPEN refcursor FETCH NEXT FROM refcursor INTO @tn501e0ee8_16667e651bd__7ffb, @cn501e0ee8_16667e651bd__7ffa WHILE @@FETCH_STATUS = 0 BEGIN EXEC ('ALTER TABLE '+@tn501e0ee8_16667e651bd__7ffb+' DROP CONSTRAINT '+@cn501e0ee8_16667e651bd__7ffa) FETCH NEXT FROM refcursor INTO @tn501e0ee8_16667e651bd__7ffb, @cn501e0ee8_16667e651bd__7ffa END CLOSE refcursor DEALLOCATE refcursor DROP TABLE "sym_node_group_channel_wnd_" END 2018-10-12 10:50:43,226 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on 2018-10-12 10:50:43,229 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: CREATE TABLE "SyncTest"."dbo"."sym_node_group_channel_wnd_"( "node_group_id" VARCHAR(50) NOT NULL, "channel_id" VARCHAR(128) NOT NULL, "start_time" VARCHAR(27) NOT NULL, "end_time" VARCHAR(27) NOT NULL, "enabled" SMALLINT DEFAULT 0 NOT NULL, PRIMARY KEY ("node_group_id", "channel_id", "start_time", "end_time") ) 2018-10-12 10:50:43,231 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: INSERT INTO "SyncTest"."dbo"."sym_node_group_channel_wnd_" ("node_group_id","channel_id","start_time","end_time","enabled") SELECT "node_group_id","channel_id","start_time","end_time","enabled" FROM "SyncTest"."dbo"."sym_node_group_channel_wnd" 2018-10-12 10:50:43,231 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on 2018-10-12 10:50:43,248 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name = 'sym_node_group_channel_wnd') BEGIN DECLARE @tn501e0ee8_16667e651bd__7ff9 nvarchar(256), @cn501e0ee8_16667e651bd__7ff8 nvarchar(256) DECLARE refcursor CURSOR FOR SELECT object_name(objs.parent_obj) tablename, objs.name constraintname FROM sysobjects objs WHERE objs.xtype in ('C','D','F','UQ') AND object_name(objs.parent_obj) = 'sym_node_group_channel_wnd' OPEN refcursor FETCH NEXT FROM refcursor INTO @tn501e0ee8_16667e651bd__7ff9, @cn501e0ee8_16667e651bd__7ff8 WHILE @@FETCH_STATUS = 0 BEGIN EXEC ('ALTER TABLE '+@tn501e0ee8_16667e651bd__7ff9+' DROP CONSTRAINT '+@cn501e0ee8_16667e651bd__7ff8) FETCH NEXT FROM refcursor INTO @tn501e0ee8_16667e651bd__7ff9, @cn501e0ee8_16667e651bd__7ff8 END CLOSE refcursor DEALLOCATE refcursor DROP TABLE "sym_node_group_channel_wnd" END 2018-10-12 10:50:43,249 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on 2018-10-12 10:50:43,252 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: CREATE TABLE "sym_node_group_channel_wnd"( "node_group_id" VARCHAR(50) NOT NULL, "channel_id" VARCHAR(128) NOT NULL, "start_time" DATETIME2 NOT NULL, "end_time" DATETIME2 NOT NULL, "enabled" SMALLINT DEFAULT 0 NOT NULL, PRIMARY KEY ("node_group_id", "channel_id", "start_time", "end_time") ) 2018-10-12 10:50:43,253 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: INSERT INTO "sym_node_group_channel_wnd" ("node_group_id","channel_id","start_time","end_time","enabled") SELECT "node_group_id","channel_id","start_time","end_time","enabled" FROM "SyncTest"."dbo"."sym_node_group_channel_wnd_" 2018-10-12 10:50:43,253 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on 2018-10-12 10:50:43,270 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name = 'sym_node_group_channel_wnd_') BEGIN DECLARE @tn501e0ee8_16667e651bd__7ff7 nvarchar(256), @cn501e0ee8_16667e651bd__7ff6 nvarchar(256) DECLARE refcursor CURSOR FOR SELECT object_name(objs.parent_obj) tablename, objs.name constraintname FROM sysobjects objs WHERE objs.xtype in ('C','D','F','UQ') AND object_name(objs.parent_obj) = 'sym_node_group_channel_wnd_' OPEN refcursor FETCH NEXT FROM refcursor INTO @tn501e0ee8_16667e651bd__7ff7, @cn501e0ee8_16667e651bd__7ff6 WHILE @@FETCH_STATUS = 0 BEGIN EXEC ('ALTER TABLE '+@tn501e0ee8_16667e651bd__7ff7+' DROP CONSTRAINT '+@cn501e0ee8_16667e651bd__7ff6) FETCH NEXT FROM refcursor INTO @tn501e0ee8_16667e651bd__7ff7, @cn501e0ee8_16667e651bd__7ff6 END CLOSE refcursor DEALLOCATE refcursor DROP TABLE "sym_node_group_channel_wnd_" END 2018-10-12 10:50:43,273 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "SyncTest"."dbo"."sym_node_group_link" ALTER COLUMN "create_time" DATETIME2 2018-10-12 10:50:43,276 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "SyncTest"."dbo"."sym_node_group_link" ALTER COLUMN "last_update_time" DATETIME2 2018-10-12 10:50:43,278 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "SyncTest"."dbo"."sym_node_host" ALTER COLUMN "heartbeat_time" DATETIME2 2018-10-12 10:50:43,280 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "SyncTest"."dbo"."sym_node_host" ALTER COLUMN "last_restart_time" DATETIME2 NOT NULL 2018-10-12 10:50:43,283 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "SyncTest"."dbo"."sym_node_host" ALTER COLUMN "create_time" DATETIME2 NOT NULL 2018-10-12 10:50:43,283 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on 2018-10-12 10:50:43,293 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name = 'sym_node_host_channel_stats_') BEGIN DECLARE @tn501e0ee8_16667e651bd__7ff3 nvarchar(256), @cn501e0ee8_16667e651bd__7ff2 nvarchar(256) DECLARE refcursor CURSOR FOR SELECT object_name(objs.parent_obj) tablename, objs.name constraintname FROM sysobjects objs WHERE objs.xtype in ('C','D','F','UQ') AND object_name(objs.parent_obj) = 'sym_node_host_channel_stats_' OPEN refcursor FETCH NEXT FROM refcursor INTO @tn501e0ee8_16667e651bd__7ff3, @cn501e0ee8_16667e651bd__7ff2 WHILE @@FETCH_STATUS = 0 BEGIN EXEC ('ALTER TABLE '+@tn501e0ee8_16667e651bd__7ff3+' DROP CONSTRAINT '+@cn501e0ee8_16667e651bd__7ff2) FETCH NEXT FROM refcursor INTO @tn501e0ee8_16667e651bd__7ff3, @cn501e0ee8_16667e651bd__7ff2 END CLOSE refcursor DEALLOCATE refcursor DROP TABLE "sym_node_host_channel_stats_" END 2018-10-12 10:50:43,293 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on 2018-10-12 10:50:43,301 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: CREATE TABLE "SyncTest"."dbo"."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" VARCHAR(27) NOT NULL, "end_time" VARCHAR(27) 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-10-12 10:50:43,302 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: INSERT INTO "SyncTest"."dbo"."sym_node_host_channel_stats_" ("node_id","host_name","channel_id","start_time","end_time","data_routed","data_unrouted","data_event_inserted","data_extracted","data_bytes_extracted","data_extracted_errors","data_bytes_sent","data_sent","data_sent_errors","data_loaded","data_bytes_loaded","data_loaded_errors") SELECT "node_id","host_name","channel_id","start_time","end_time","data_routed","data_unrouted","data_event_inserted","data_extracted","data_bytes_extracted","data_extracted_errors","data_bytes_sent","data_sent","data_sent_errors","data_loaded","data_bytes_loaded","data_loaded_errors" FROM "SyncTest"."dbo"."sym_node_host_channel_stats" 2018-10-12 10:50:43,303 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on 2018-10-12 10:50:43,344 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name = 'sym_node_host_channel_stats') BEGIN DECLARE @tn501e0ee8_16667e651bd__7ff1 nvarchar(256), @cn501e0ee8_16667e651bd__7ff0 nvarchar(256) DECLARE refcursor CURSOR FOR SELECT object_name(objs.parent_obj) tablename, objs.name constraintname FROM sysobjects objs WHERE objs.xtype in ('C','D','F','UQ') AND object_name(objs.parent_obj) = 'sym_node_host_channel_stats' OPEN refcursor FETCH NEXT FROM refcursor INTO @tn501e0ee8_16667e651bd__7ff1, @cn501e0ee8_16667e651bd__7ff0 WHILE @@FETCH_STATUS = 0 BEGIN EXEC ('ALTER TABLE '+@tn501e0ee8_16667e651bd__7ff1+' DROP CONSTRAINT '+@cn501e0ee8_16667e651bd__7ff0) FETCH NEXT FROM refcursor INTO @tn501e0ee8_16667e651bd__7ff1, @cn501e0ee8_16667e651bd__7ff0 END CLOSE refcursor DEALLOCATE refcursor DROP TABLE "sym_node_host_channel_stats" END 2018-10-12 10:50:43,345 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on 2018-10-12 10:50:43,352 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] 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" DATETIME2 NOT NULL, "end_time" DATETIME2 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-10-12 10:50:43,354 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: INSERT INTO "sym_node_host_channel_stats" ("node_id","host_name","channel_id","start_time","end_time","data_routed","data_unrouted","data_event_inserted","data_extracted","data_bytes_extracted","data_extracted_errors","data_bytes_sent","data_sent","data_sent_errors","data_loaded","data_bytes_loaded","data_loaded_errors") SELECT "node_id","host_name","channel_id","start_time","end_time","data_routed","data_unrouted","data_event_inserted","data_extracted","data_bytes_extracted","data_extracted_errors","data_bytes_sent","data_sent","data_sent_errors","data_loaded","data_bytes_loaded","data_loaded_errors" FROM "SyncTest"."dbo"."sym_node_host_channel_stats_" 2018-10-12 10:50:43,354 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on 2018-10-12 10:50:43,395 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name = 'sym_node_host_channel_stats_') BEGIN DECLARE @tn501e0ee8_16667e651bd__7fef nvarchar(256), @cn501e0ee8_16667e651bd__7fee nvarchar(256) DECLARE refcursor CURSOR FOR SELECT object_name(objs.parent_obj) tablename, objs.name constraintname FROM sysobjects objs WHERE objs.xtype in ('C','D','F','UQ') AND object_name(objs.parent_obj) = 'sym_node_host_channel_stats_' OPEN refcursor FETCH NEXT FROM refcursor INTO @tn501e0ee8_16667e651bd__7fef, @cn501e0ee8_16667e651bd__7fee WHILE @@FETCH_STATUS = 0 BEGIN EXEC ('ALTER TABLE '+@tn501e0ee8_16667e651bd__7fef+' DROP CONSTRAINT '+@cn501e0ee8_16667e651bd__7fee) FETCH NEXT FROM refcursor INTO @tn501e0ee8_16667e651bd__7fef, @cn501e0ee8_16667e651bd__7fee END CLOSE refcursor DEALLOCATE refcursor DROP TABLE "sym_node_host_channel_stats_" END 2018-10-12 10:50:43,396 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on 2018-10-12 10:50:43,405 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name = 'sym_node_host_job_stats_') BEGIN DECLARE @tn501e0ee8_16667e651bd__7feb nvarchar(256), @cn501e0ee8_16667e651bd__7fea nvarchar(256) DECLARE refcursor CURSOR FOR SELECT object_name(objs.parent_obj) tablename, objs.name constraintname FROM sysobjects objs WHERE objs.xtype in ('C','D','F','UQ') AND object_name(objs.parent_obj) = 'sym_node_host_job_stats_' OPEN refcursor FETCH NEXT FROM refcursor INTO @tn501e0ee8_16667e651bd__7feb, @cn501e0ee8_16667e651bd__7fea WHILE @@FETCH_STATUS = 0 BEGIN EXEC ('ALTER TABLE '+@tn501e0ee8_16667e651bd__7feb+' DROP CONSTRAINT '+@cn501e0ee8_16667e651bd__7fea) FETCH NEXT FROM refcursor INTO @tn501e0ee8_16667e651bd__7feb, @cn501e0ee8_16667e651bd__7fea END CLOSE refcursor DEALLOCATE refcursor DROP TABLE "sym_node_host_job_stats_" END 2018-10-12 10:50:43,406 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on 2018-10-12 10:50:43,410 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: CREATE TABLE "SyncTest"."dbo"."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" VARCHAR(27) NOT NULL, "end_time" VARCHAR(27) NOT NULL, "processed_count" BIGINT DEFAULT 0, "target_node_id" VARCHAR(50), "target_node_count" INT DEFAULT 0, PRIMARY KEY ("node_id", "host_name", "job_name", "start_time", "end_time") ) 2018-10-12 10:50:43,411 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: INSERT INTO "SyncTest"."dbo"."sym_node_host_job_stats_" ("node_id","host_name","job_name","start_time","end_time","processed_count","target_node_id","target_node_count") SELECT "node_id","host_name","job_name","start_time","end_time","processed_count","target_node_id","target_node_count" FROM "SyncTest"."dbo"."sym_node_host_job_stats" 2018-10-12 10:50:43,411 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on 2018-10-12 10:50:43,430 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name = 'sym_node_host_job_stats') BEGIN DECLARE @tn501e0ee8_16667e651bd__7fe9 nvarchar(256), @cn501e0ee8_16667e651bd__7fe8 nvarchar(256) DECLARE refcursor CURSOR FOR SELECT object_name(objs.parent_obj) tablename, objs.name constraintname FROM sysobjects objs WHERE objs.xtype in ('C','D','F','UQ') AND object_name(objs.parent_obj) = 'sym_node_host_job_stats' OPEN refcursor FETCH NEXT FROM refcursor INTO @tn501e0ee8_16667e651bd__7fe9, @cn501e0ee8_16667e651bd__7fe8 WHILE @@FETCH_STATUS = 0 BEGIN EXEC ('ALTER TABLE '+@tn501e0ee8_16667e651bd__7fe9+' DROP CONSTRAINT '+@cn501e0ee8_16667e651bd__7fe8) FETCH NEXT FROM refcursor INTO @tn501e0ee8_16667e651bd__7fe9, @cn501e0ee8_16667e651bd__7fe8 END CLOSE refcursor DEALLOCATE refcursor DROP TABLE "sym_node_host_job_stats" END 2018-10-12 10:50:43,431 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on 2018-10-12 10:50:43,434 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] 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" DATETIME2 NOT NULL, "end_time" DATETIME2 NOT NULL, "processed_count" BIGINT DEFAULT 0, "target_node_id" VARCHAR(50), "target_node_count" INT DEFAULT 0, PRIMARY KEY ("node_id", "host_name", "job_name", "start_time", "end_time") ) 2018-10-12 10:50:43,435 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: INSERT INTO "sym_node_host_job_stats" ("node_id","host_name","job_name","start_time","end_time","processed_count","target_node_id","target_node_count") SELECT "node_id","host_name","job_name","start_time","end_time","processed_count","target_node_id","target_node_count" FROM "SyncTest"."dbo"."sym_node_host_job_stats_" 2018-10-12 10:50:43,436 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on 2018-10-12 10:50:43,455 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name = 'sym_node_host_job_stats_') BEGIN DECLARE @tn501e0ee8_16667e651bd__7fe7 nvarchar(256), @cn501e0ee8_16667e651bd__7fe6 nvarchar(256) DECLARE refcursor CURSOR FOR SELECT object_name(objs.parent_obj) tablename, objs.name constraintname FROM sysobjects objs WHERE objs.xtype in ('C','D','F','UQ') AND object_name(objs.parent_obj) = 'sym_node_host_job_stats_' OPEN refcursor FETCH NEXT FROM refcursor INTO @tn501e0ee8_16667e651bd__7fe7, @cn501e0ee8_16667e651bd__7fe6 WHILE @@FETCH_STATUS = 0 BEGIN EXEC ('ALTER TABLE '+@tn501e0ee8_16667e651bd__7fe7+' DROP CONSTRAINT '+@cn501e0ee8_16667e651bd__7fe6) FETCH NEXT FROM refcursor INTO @tn501e0ee8_16667e651bd__7fe7, @cn501e0ee8_16667e651bd__7fe6 END CLOSE refcursor DEALLOCATE refcursor DROP TABLE "sym_node_host_job_stats_" END 2018-10-12 10:50:43,455 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on 2018-10-12 10:50:43,465 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name = 'sym_node_host_stats_') BEGIN DECLARE @tn501e0ee8_16667e651bd__7fe3 nvarchar(256), @cn501e0ee8_16667e651bd__7fe2 nvarchar(256) DECLARE refcursor CURSOR FOR SELECT object_name(objs.parent_obj) tablename, objs.name constraintname FROM sysobjects objs WHERE objs.xtype in ('C','D','F','UQ') AND object_name(objs.parent_obj) = 'sym_node_host_stats_' OPEN refcursor FETCH NEXT FROM refcursor INTO @tn501e0ee8_16667e651bd__7fe3, @cn501e0ee8_16667e651bd__7fe2 WHILE @@FETCH_STATUS = 0 BEGIN EXEC ('ALTER TABLE '+@tn501e0ee8_16667e651bd__7fe3+' DROP CONSTRAINT '+@cn501e0ee8_16667e651bd__7fe2) FETCH NEXT FROM refcursor INTO @tn501e0ee8_16667e651bd__7fe3, @cn501e0ee8_16667e651bd__7fe2 END CLOSE refcursor DEALLOCATE refcursor DROP TABLE "sym_node_host_stats_" END 2018-10-12 10:50:43,465 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on 2018-10-12 10:50:43,474 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: CREATE TABLE "SyncTest"."dbo"."sym_node_host_stats_"( "node_id" VARCHAR(50) NOT NULL, "host_name" VARCHAR(60) NOT NULL, "start_time" VARCHAR(27) NOT NULL, "end_time" VARCHAR(27) 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-10-12 10:50:43,475 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: INSERT INTO "SyncTest"."dbo"."sym_node_host_stats_" ("node_id","host_name","start_time","end_time","restarted","nodes_pulled","total_nodes_pull_time","nodes_pushed","total_nodes_push_time","nodes_rejected","nodes_registered","nodes_loaded","nodes_disabled","purged_data_rows","purged_data_event_rows","purged_batch_outgoing_rows","purged_batch_incoming_rows","triggers_created_count","triggers_rebuilt_count","triggers_removed_count") SELECT "node_id","host_name","start_time","end_time","restarted","nodes_pulled","total_nodes_pull_time","nodes_pushed","total_nodes_push_time","nodes_rejected","nodes_registered","nodes_loaded","nodes_disabled","purged_data_rows","purged_data_event_rows","purged_batch_outgoing_rows","purged_batch_incoming_rows","triggers_created_count","triggers_rebuilt_count","triggers_removed_count" FROM "SyncTest"."dbo"."sym_node_host_stats" 2018-10-12 10:50:43,476 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on 2018-10-12 10:50:43,522 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name = 'sym_node_host_stats') BEGIN DECLARE @tn501e0ee8_16667e651bd__7fe1 nvarchar(256), @cn501e0ee8_16667e651bd__7fe0 nvarchar(256) DECLARE refcursor CURSOR FOR SELECT object_name(objs.parent_obj) tablename, objs.name constraintname FROM sysobjects objs WHERE objs.xtype in ('C','D','F','UQ') AND object_name(objs.parent_obj) = 'sym_node_host_stats' OPEN refcursor FETCH NEXT FROM refcursor INTO @tn501e0ee8_16667e651bd__7fe1, @cn501e0ee8_16667e651bd__7fe0 WHILE @@FETCH_STATUS = 0 BEGIN EXEC ('ALTER TABLE '+@tn501e0ee8_16667e651bd__7fe1+' DROP CONSTRAINT '+@cn501e0ee8_16667e651bd__7fe0) FETCH NEXT FROM refcursor INTO @tn501e0ee8_16667e651bd__7fe1, @cn501e0ee8_16667e651bd__7fe0 END CLOSE refcursor DEALLOCATE refcursor DROP TABLE "sym_node_host_stats" END 2018-10-12 10:50:43,523 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on 2018-10-12 10:50:43,530 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: CREATE TABLE "sym_node_host_stats"( "node_id" VARCHAR(50) NOT NULL, "host_name" VARCHAR(60) NOT NULL, "start_time" DATETIME2 NOT NULL, "end_time" DATETIME2 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-10-12 10:50:43,532 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: INSERT INTO "sym_node_host_stats" ("node_id","host_name","start_time","end_time","restarted","nodes_pulled","total_nodes_pull_time","nodes_pushed","total_nodes_push_time","nodes_rejected","nodes_registered","nodes_loaded","nodes_disabled","purged_data_rows","purged_data_event_rows","purged_batch_outgoing_rows","purged_batch_incoming_rows","triggers_created_count","triggers_rebuilt_count","triggers_removed_count") SELECT "node_id","host_name","start_time","end_time","restarted","nodes_pulled","total_nodes_pull_time","nodes_pushed","total_nodes_push_time","nodes_rejected","nodes_registered","nodes_loaded","nodes_disabled","purged_data_rows","purged_data_event_rows","purged_batch_outgoing_rows","purged_batch_incoming_rows","triggers_created_count","triggers_rebuilt_count","triggers_removed_count" FROM "SyncTest"."dbo"."sym_node_host_stats_" 2018-10-12 10:50:43,532 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on 2018-10-12 10:50:43,588 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name = 'sym_node_host_stats_') BEGIN DECLARE @tn501e0ee8_16667e651bd__7fdf nvarchar(256), @cn501e0ee8_16667e651bd__7fde nvarchar(256) DECLARE refcursor CURSOR FOR SELECT object_name(objs.parent_obj) tablename, objs.name constraintname FROM sysobjects objs WHERE objs.xtype in ('C','D','F','UQ') AND object_name(objs.parent_obj) = 'sym_node_host_stats_' OPEN refcursor FETCH NEXT FROM refcursor INTO @tn501e0ee8_16667e651bd__7fdf, @cn501e0ee8_16667e651bd__7fde WHILE @@FETCH_STATUS = 0 BEGIN EXEC ('ALTER TABLE '+@tn501e0ee8_16667e651bd__7fdf+' DROP CONSTRAINT '+@cn501e0ee8_16667e651bd__7fde) FETCH NEXT FROM refcursor INTO @tn501e0ee8_16667e651bd__7fdf, @cn501e0ee8_16667e651bd__7fde END CLOSE refcursor DEALLOCATE refcursor DROP TABLE "sym_node_host_stats_" END 2018-10-12 10:50:43,591 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "SyncTest"."dbo"."sym_node_security" ALTER COLUMN "registration_time" DATETIME2 2018-10-12 10:50:43,594 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "SyncTest"."dbo"."sym_node_security" ALTER COLUMN "initial_load_time" DATETIME2 2018-10-12 10:50:43,596 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "SyncTest"."dbo"."sym_node_security" ALTER COLUMN "rev_initial_load_time" DATETIME2 2018-10-12 10:50:43,599 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "SyncTest"."dbo"."sym_monitor" ALTER COLUMN "create_time" DATETIME2 2018-10-12 10:50:43,601 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "SyncTest"."dbo"."sym_monitor" ALTER COLUMN "last_update_time" DATETIME2 2018-10-12 10:50:43,601 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on 2018-10-12 10:50:43,612 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name = 'sym_monitor_event_') BEGIN DECLARE @tn501e0ee8_16667e651bd__7fdb nvarchar(256), @cn501e0ee8_16667e651bd__7fda nvarchar(256) DECLARE refcursor CURSOR FOR SELECT object_name(objs.parent_obj) tablename, objs.name constraintname FROM sysobjects objs WHERE objs.xtype in ('C','D','F','UQ') AND object_name(objs.parent_obj) = 'sym_monitor_event_' OPEN refcursor FETCH NEXT FROM refcursor INTO @tn501e0ee8_16667e651bd__7fdb, @cn501e0ee8_16667e651bd__7fda WHILE @@FETCH_STATUS = 0 BEGIN EXEC ('ALTER TABLE '+@tn501e0ee8_16667e651bd__7fdb+' DROP CONSTRAINT '+@cn501e0ee8_16667e651bd__7fda) FETCH NEXT FROM refcursor INTO @tn501e0ee8_16667e651bd__7fdb, @cn501e0ee8_16667e651bd__7fda END CLOSE refcursor DEALLOCATE refcursor DROP TABLE "sym_monitor_event_" END 2018-10-12 10:50:43,612 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on 2018-10-12 10:50:43,617 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: CREATE TABLE "SyncTest"."dbo"."sym_monitor_event_"( "monitor_id" VARCHAR(128) NOT NULL, "node_id" VARCHAR(50) NOT NULL, "event_time" VARCHAR(27) NOT NULL, "host_name" VARCHAR(60), "type" VARCHAR(50) NOT NULL, "threshold" BIGINT DEFAULT 0 NOT NULL, "event_value" BIGINT DEFAULT 0 NOT NULL, "event_count" INT DEFAULT 0 NOT NULL, "severity_level" INT DEFAULT 0 NOT NULL, "is_resolved" SMALLINT DEFAULT 0 NOT NULL, "is_notified" SMALLINT DEFAULT 0 NOT NULL, "details" TEXT, "last_update_time" VARCHAR(27), PRIMARY KEY ("monitor_id", "node_id", "event_time") ) 2018-10-12 10:50:43,619 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: INSERT INTO "SyncTest"."dbo"."sym_monitor_event_" ("monitor_id","node_id","event_time","host_name","type","threshold","event_value","event_count","severity_level","is_resolved","is_notified","details","last_update_time") SELECT "monitor_id","node_id","event_time","host_name","type","threshold","event_value","event_count","severity_level","is_resolved","is_notified","details","last_update_time" FROM "SyncTest"."dbo"."sym_monitor_event" 2018-10-12 10:50:43,619 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on 2018-10-12 10:50:43,648 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name = 'sym_monitor_event') BEGIN DECLARE @tn501e0ee8_16667e651bd__7fd9 nvarchar(256), @cn501e0ee8_16667e651bd__7fd8 nvarchar(256) DECLARE refcursor CURSOR FOR SELECT object_name(objs.parent_obj) tablename, objs.name constraintname FROM sysobjects objs WHERE objs.xtype in ('C','D','F','UQ') AND object_name(objs.parent_obj) = 'sym_monitor_event' OPEN refcursor FETCH NEXT FROM refcursor INTO @tn501e0ee8_16667e651bd__7fd9, @cn501e0ee8_16667e651bd__7fd8 WHILE @@FETCH_STATUS = 0 BEGIN EXEC ('ALTER TABLE '+@tn501e0ee8_16667e651bd__7fd9+' DROP CONSTRAINT '+@cn501e0ee8_16667e651bd__7fd8) FETCH NEXT FROM refcursor INTO @tn501e0ee8_16667e651bd__7fd9, @cn501e0ee8_16667e651bd__7fd8 END CLOSE refcursor DEALLOCATE refcursor DROP TABLE "sym_monitor_event" END 2018-10-12 10:50:43,649 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on 2018-10-12 10:50:43,653 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: CREATE TABLE "sym_monitor_event"( "monitor_id" VARCHAR(128) NOT NULL, "node_id" VARCHAR(50) NOT NULL, "event_time" DATETIME2 NOT NULL, "host_name" VARCHAR(60), "type" VARCHAR(50) NOT NULL, "threshold" BIGINT DEFAULT 0 NOT NULL, "event_value" BIGINT DEFAULT 0 NOT NULL, "event_count" INT DEFAULT 0 NOT NULL, "severity_level" INT DEFAULT 0 NOT NULL, "is_resolved" SMALLINT DEFAULT 0 NOT NULL, "is_notified" SMALLINT DEFAULT 0 NOT NULL, "details" TEXT, "last_update_time" DATETIME2, PRIMARY KEY ("monitor_id", "node_id", "event_time") ) 2018-10-12 10:50:43,654 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: INSERT INTO "sym_monitor_event" ("monitor_id","node_id","event_time","host_name","type","threshold","event_value","event_count","severity_level","is_resolved","is_notified","details","last_update_time") SELECT "monitor_id","node_id","event_time","host_name","type","threshold","event_value","event_count","severity_level","is_resolved","is_notified","details","last_update_time" FROM "SyncTest"."dbo"."sym_monitor_event_" 2018-10-12 10:50:43,655 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on 2018-10-12 10:50:43,683 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name = 'sym_monitor_event_') BEGIN DECLARE @tn501e0ee8_16667e651bd__7fd7 nvarchar(256), @cn501e0ee8_16667e651bd__7fd6 nvarchar(256) DECLARE refcursor CURSOR FOR SELECT object_name(objs.parent_obj) tablename, objs.name constraintname FROM sysobjects objs WHERE objs.xtype in ('C','D','F','UQ') AND object_name(objs.parent_obj) = 'sym_monitor_event_' OPEN refcursor FETCH NEXT FROM refcursor INTO @tn501e0ee8_16667e651bd__7fd7, @cn501e0ee8_16667e651bd__7fd6 WHILE @@FETCH_STATUS = 0 BEGIN EXEC ('ALTER TABLE '+@tn501e0ee8_16667e651bd__7fd7+' DROP CONSTRAINT '+@cn501e0ee8_16667e651bd__7fd6) FETCH NEXT FROM refcursor INTO @tn501e0ee8_16667e651bd__7fd7, @cn501e0ee8_16667e651bd__7fd6 END CLOSE refcursor DEALLOCATE refcursor DROP TABLE "sym_monitor_event_" END 2018-10-12 10:50:43,685 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "SyncTest"."dbo"."sym_notification" ALTER COLUMN "create_time" DATETIME2 2018-10-12 10:50:43,687 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "SyncTest"."dbo"."sym_notification" ALTER COLUMN "last_update_time" DATETIME2 2018-10-12 10:50:43,689 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "SyncTest"."dbo"."sym_outgoing_batch" ALTER COLUMN "last_update_time" DATETIME2 2018-10-12 10:50:43,691 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "SyncTest"."dbo"."sym_outgoing_batch" ALTER COLUMN "create_time" DATETIME2 2018-10-12 10:50:43,694 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "SyncTest"."dbo"."sym_outgoing_batch" ALTER COLUMN "extract_start_time" DATETIME2 2018-10-12 10:50:43,696 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "SyncTest"."dbo"."sym_outgoing_batch" ALTER COLUMN "transfer_start_time" DATETIME2 2018-10-12 10:50:43,698 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "SyncTest"."dbo"."sym_outgoing_batch" ALTER COLUMN "load_start_time" DATETIME2 2018-10-12 10:50:43,700 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "SyncTest"."dbo"."sym_parameter" ALTER COLUMN "create_time" DATETIME2 2018-10-12 10:50:43,703 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "SyncTest"."dbo"."sym_parameter" ALTER COLUMN "last_update_time" DATETIME2 2018-10-12 10:50:43,703 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on 2018-10-12 10:50:43,712 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name = 'sym_registration_request_') BEGIN DECLARE @tn501e0ee8_16667e651bd__7fd3 nvarchar(256), @cn501e0ee8_16667e651bd__7fd2 nvarchar(256) DECLARE refcursor CURSOR FOR SELECT object_name(objs.parent_obj) tablename, objs.name constraintname FROM sysobjects objs WHERE objs.xtype in ('C','D','F','UQ') AND object_name(objs.parent_obj) = 'sym_registration_request_' OPEN refcursor FETCH NEXT FROM refcursor INTO @tn501e0ee8_16667e651bd__7fd3, @cn501e0ee8_16667e651bd__7fd2 WHILE @@FETCH_STATUS = 0 BEGIN EXEC ('ALTER TABLE '+@tn501e0ee8_16667e651bd__7fd3+' DROP CONSTRAINT '+@cn501e0ee8_16667e651bd__7fd2) FETCH NEXT FROM refcursor INTO @tn501e0ee8_16667e651bd__7fd3, @cn501e0ee8_16667e651bd__7fd2 END CLOSE refcursor DEALLOCATE refcursor DROP TABLE "sym_registration_request_" END 2018-10-12 10:50:43,712 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on 2018-10-12 10:50:43,716 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: CREATE TABLE "SyncTest"."dbo"."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" INT DEFAULT 0, "registered_node_id" VARCHAR(50), "error_message" TEXT, "create_time" VARCHAR(27) NOT NULL, "last_update_by" VARCHAR(50), "last_update_time" VARCHAR(27) NOT NULL, PRIMARY KEY ("node_group_id", "external_id", "create_time") ) 2018-10-12 10:50:43,717 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: INSERT INTO "SyncTest"."dbo"."sym_registration_request_" ("node_group_id","external_id","status","host_name","ip_address","attempt_count","registered_node_id","error_message","create_time","last_update_by","last_update_time") SELECT "node_group_id","external_id","status","host_name","ip_address","attempt_count","registered_node_id","error_message","create_time","last_update_by","last_update_time" FROM "SyncTest"."dbo"."sym_registration_request" 2018-10-12 10:50:43,718 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on 2018-10-12 10:50:43,734 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name = 'sym_registration_request') BEGIN DECLARE @tn501e0ee8_16667e651bd__7fd1 nvarchar(256), @cn501e0ee8_16667e651bd__7fd0 nvarchar(256) DECLARE refcursor CURSOR FOR SELECT object_name(objs.parent_obj) tablename, objs.name constraintname FROM sysobjects objs WHERE objs.xtype in ('C','D','F','UQ') AND object_name(objs.parent_obj) = 'sym_registration_request' OPEN refcursor FETCH NEXT FROM refcursor INTO @tn501e0ee8_16667e651bd__7fd1, @cn501e0ee8_16667e651bd__7fd0 WHILE @@FETCH_STATUS = 0 BEGIN EXEC ('ALTER TABLE '+@tn501e0ee8_16667e651bd__7fd1+' DROP CONSTRAINT '+@cn501e0ee8_16667e651bd__7fd0) FETCH NEXT FROM refcursor INTO @tn501e0ee8_16667e651bd__7fd1, @cn501e0ee8_16667e651bd__7fd0 END CLOSE refcursor DEALLOCATE refcursor DROP TABLE "sym_registration_request" END 2018-10-12 10:50:43,734 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on 2018-10-12 10:50:43,738 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] 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" INT DEFAULT 0, "registered_node_id" VARCHAR(50), "error_message" TEXT, "create_time" DATETIME2 NOT NULL, "last_update_by" VARCHAR(50), "last_update_time" DATETIME2 NOT NULL, PRIMARY KEY ("node_group_id", "external_id", "create_time") ) 2018-10-12 10:50:43,740 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: CREATE INDEX "sym_idx_reg_req_1" ON "sym_registration_request" ("node_group_id", "external_id", "status", "host_name", "ip_address") 2018-10-12 10:50:43,743 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: CREATE INDEX "sym_idx_reg_req_2" ON "sym_registration_request" ("status") 2018-10-12 10:50:43,744 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: INSERT INTO "sym_registration_request" ("node_group_id","external_id","status","host_name","ip_address","attempt_count","registered_node_id","error_message","create_time","last_update_by","last_update_time") SELECT "node_group_id","external_id","status","host_name","ip_address","attempt_count","registered_node_id","error_message","create_time","last_update_by","last_update_time" FROM "SyncTest"."dbo"."sym_registration_request_" 2018-10-12 10:50:43,744 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on 2018-10-12 10:50:43,761 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name = 'sym_registration_request_') BEGIN DECLARE @tn501e0ee8_16667e651bd__7fcf nvarchar(256), @cn501e0ee8_16667e651bd__7fce nvarchar(256) DECLARE refcursor CURSOR FOR SELECT object_name(objs.parent_obj) tablename, objs.name constraintname FROM sysobjects objs WHERE objs.xtype in ('C','D','F','UQ') AND object_name(objs.parent_obj) = 'sym_registration_request_' OPEN refcursor FETCH NEXT FROM refcursor INTO @tn501e0ee8_16667e651bd__7fcf, @cn501e0ee8_16667e651bd__7fce WHILE @@FETCH_STATUS = 0 BEGIN EXEC ('ALTER TABLE '+@tn501e0ee8_16667e651bd__7fcf+' DROP CONSTRAINT '+@cn501e0ee8_16667e651bd__7fce) FETCH NEXT FROM refcursor INTO @tn501e0ee8_16667e651bd__7fcf, @cn501e0ee8_16667e651bd__7fce END CLOSE refcursor DEALLOCATE refcursor DROP TABLE "sym_registration_request_" END 2018-10-12 10:50:43,763 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "SyncTest"."dbo"."sym_router" ALTER COLUMN "create_time" DATETIME2 NOT NULL 2018-10-12 10:50:43,766 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "SyncTest"."dbo"."sym_router" ALTER COLUMN "last_update_time" DATETIME2 NOT NULL 2018-10-12 10:50:43,768 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "SyncTest"."dbo"."sym_sequence" ALTER COLUMN "create_time" DATETIME2 2018-10-12 10:50:43,770 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "SyncTest"."dbo"."sym_sequence" ALTER COLUMN "last_update_time" DATETIME2 NOT NULL 2018-10-12 10:50:43,770 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on 2018-10-12 10:50:43,780 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name = 'sym_table_reload_request_') BEGIN DECLARE @tn501e0ee8_16667e651bd__7fcb nvarchar(256), @cn501e0ee8_16667e651bd__7fca nvarchar(256) DECLARE refcursor CURSOR FOR SELECT object_name(objs.parent_obj) tablename, objs.name constraintname FROM sysobjects objs WHERE objs.xtype in ('C','D','F','UQ') AND object_name(objs.parent_obj) = 'sym_table_reload_request_' OPEN refcursor FETCH NEXT FROM refcursor INTO @tn501e0ee8_16667e651bd__7fcb, @cn501e0ee8_16667e651bd__7fca WHILE @@FETCH_STATUS = 0 BEGIN EXEC ('ALTER TABLE '+@tn501e0ee8_16667e651bd__7fcb+' DROP CONSTRAINT '+@cn501e0ee8_16667e651bd__7fca) FETCH NEXT FROM refcursor INTO @tn501e0ee8_16667e651bd__7fcb, @cn501e0ee8_16667e651bd__7fca END CLOSE refcursor DEALLOCATE refcursor DROP TABLE "sym_table_reload_request_" END 2018-10-12 10:50:43,780 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on 2018-10-12 10:50:43,784 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: CREATE TABLE "SyncTest"."dbo"."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" VARCHAR(27) NOT NULL, "create_table" SMALLINT DEFAULT 0 NOT NULL, "delete_first" SMALLINT DEFAULT 0 NOT NULL, "reload_select" TEXT, "before_custom_sql" TEXT, "reload_time" VARCHAR(27), "load_id" BIGINT, "processed" SMALLINT DEFAULT 0 NOT NULL, "channel_id" VARCHAR(128), "last_update_by" VARCHAR(50), "last_update_time" VARCHAR(27) NOT NULL, PRIMARY KEY ("target_node_id", "source_node_id", "trigger_id", "router_id", "create_time") ) 2018-10-12 10:50:43,786 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: INSERT INTO "SyncTest"."dbo"."sym_table_reload_request_" ("target_node_id","source_node_id","trigger_id","router_id","create_time","create_table","delete_first","reload_select","before_custom_sql","reload_time","load_id","processed","channel_id","last_update_by","last_update_time") SELECT "target_node_id","source_node_id","trigger_id","router_id","create_time","create_table","delete_first","reload_select","before_custom_sql","reload_time","load_id","processed","channel_id","last_update_by","last_update_time" FROM "SyncTest"."dbo"."sym_table_reload_request" 2018-10-12 10:50:43,786 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on 2018-10-12 10:50:43,808 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name = 'sym_table_reload_request') BEGIN DECLARE @tn501e0ee8_16667e651bd__7fc9 nvarchar(256), @cn501e0ee8_16667e651bd__7fc8 nvarchar(256) DECLARE refcursor CURSOR FOR SELECT object_name(objs.parent_obj) tablename, objs.name constraintname FROM sysobjects objs WHERE objs.xtype in ('C','D','F','UQ') AND object_name(objs.parent_obj) = 'sym_table_reload_request' OPEN refcursor FETCH NEXT FROM refcursor INTO @tn501e0ee8_16667e651bd__7fc9, @cn501e0ee8_16667e651bd__7fc8 WHILE @@FETCH_STATUS = 0 BEGIN EXEC ('ALTER TABLE '+@tn501e0ee8_16667e651bd__7fc9+' DROP CONSTRAINT '+@cn501e0ee8_16667e651bd__7fc8) FETCH NEXT FROM refcursor INTO @tn501e0ee8_16667e651bd__7fc9, @cn501e0ee8_16667e651bd__7fc8 END CLOSE refcursor DEALLOCATE refcursor DROP TABLE "sym_table_reload_request" END 2018-10-12 10:50:43,808 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on 2018-10-12 10:50:43,812 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] 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" DATETIME2 NOT NULL, "create_table" SMALLINT DEFAULT 0 NOT NULL, "delete_first" SMALLINT DEFAULT 0 NOT NULL, "reload_select" TEXT, "before_custom_sql" TEXT, "reload_time" DATETIME2, "load_id" BIGINT, "processed" SMALLINT DEFAULT 0 NOT NULL, "channel_id" VARCHAR(128), "last_update_by" VARCHAR(50), "last_update_time" DATETIME2 NOT NULL, PRIMARY KEY ("target_node_id", "source_node_id", "trigger_id", "router_id", "create_time") ) 2018-10-12 10:50:43,813 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: INSERT INTO "sym_table_reload_request" ("target_node_id","source_node_id","trigger_id","router_id","create_time","create_table","delete_first","reload_select","before_custom_sql","reload_time","load_id","processed","channel_id","last_update_by","last_update_time") SELECT "target_node_id","source_node_id","trigger_id","router_id","create_time","create_table","delete_first","reload_select","before_custom_sql","reload_time","load_id","processed","channel_id","last_update_by","last_update_time" FROM "SyncTest"."dbo"."sym_table_reload_request_" 2018-10-12 10:50:43,814 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on 2018-10-12 10:50:43,834 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name = 'sym_table_reload_request_') BEGIN DECLARE @tn501e0ee8_16667e651bd__7fc7 nvarchar(256), @cn501e0ee8_16667e651bd__7fc6 nvarchar(256) DECLARE refcursor CURSOR FOR SELECT object_name(objs.parent_obj) tablename, objs.name constraintname FROM sysobjects objs WHERE objs.xtype in ('C','D','F','UQ') AND object_name(objs.parent_obj) = 'sym_table_reload_request_' OPEN refcursor FETCH NEXT FROM refcursor INTO @tn501e0ee8_16667e651bd__7fc7, @cn501e0ee8_16667e651bd__7fc6 WHILE @@FETCH_STATUS = 0 BEGIN EXEC ('ALTER TABLE '+@tn501e0ee8_16667e651bd__7fc7+' DROP CONSTRAINT '+@cn501e0ee8_16667e651bd__7fc6) FETCH NEXT FROM refcursor INTO @tn501e0ee8_16667e651bd__7fc7, @cn501e0ee8_16667e651bd__7fc6 END CLOSE refcursor DEALLOCATE refcursor DROP TABLE "sym_table_reload_request_" END 2018-10-12 10:50:43,836 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "SyncTest"."dbo"."sym_transform_table" ALTER COLUMN "create_time" DATETIME2 2018-10-12 10:50:43,838 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "SyncTest"."dbo"."sym_transform_table" ALTER COLUMN "last_update_time" DATETIME2 2018-10-12 10:50:43,841 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "SyncTest"."dbo"."sym_transform_column" ALTER COLUMN "create_time" DATETIME2 2018-10-12 10:50:43,843 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "SyncTest"."dbo"."sym_transform_column" ALTER COLUMN "last_update_time" DATETIME2 2018-10-12 10:50:43,845 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "SyncTest"."dbo"."sym_trigger" ALTER COLUMN "create_time" DATETIME2 NOT NULL 2018-10-12 10:50:43,847 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "SyncTest"."dbo"."sym_trigger" ALTER COLUMN "last_update_time" DATETIME2 NOT NULL 2018-10-12 10:50:43,850 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "SyncTest"."dbo"."sym_trigger_hist" ALTER COLUMN "create_time" DATETIME2 NOT NULL 2018-10-12 10:50:43,852 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "SyncTest"."dbo"."sym_trigger_hist" ALTER COLUMN "inactive_time" DATETIME2 2018-10-12 10:50:43,854 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "SyncTest"."dbo"."sym_trigger_router" ALTER COLUMN "create_time" DATETIME2 NOT NULL 2018-10-12 10:50:43,857 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "SyncTest"."dbo"."sym_trigger_router" ALTER COLUMN "last_update_time" DATETIME2 NOT NULL 2018-10-12 10:50:43,859 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "SyncTest"."dbo"."sym_trigger_router_grouplet" ALTER COLUMN "create_time" DATETIME2 NOT NULL 2018-10-12 10:50:43,862 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "SyncTest"."dbo"."sym_trigger_router_grouplet" ALTER COLUMN "last_update_time" DATETIME2 NOT NULL 2018-10-12 10:50:43,864 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] 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-10-12 10:50:43,866 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] 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-10-12 10:50:43,868 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] 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-10-12 10:50:43,871 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "sym_grouplet_link" ADD CONSTRAINT "sym_fk_gpltlnk_2_gplt" FOREIGN KEY ("grouplet_id") REFERENCES "sym_grouplet" ("grouplet_id") 2018-10-12 10:50:43,876 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] 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-10-12 10:50:43,881 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] 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-10-12 10:50:43,885 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "sym_node_security" ADD CONSTRAINT "sym_fk_sec_2_node" FOREIGN KEY ("node_id") REFERENCES "sym_node" ("node_id") 2018-10-12 10:50:43,891 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] 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-10-12 10:50:43,895 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] 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-10-12 10:50:43,900 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "sym_trigger" ADD CONSTRAINT "sym_fk_trg_2_chnl" FOREIGN KEY ("channel_id") REFERENCES "sym_channel" ("channel_id") 2018-10-12 10:50:43,905 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] 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-10-12 10:50:43,910 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "sym_trigger_router" ADD CONSTRAINT "sym_fk_tr_2_trg" FOREIGN KEY ("trigger_id") REFERENCES "sym_trigger" ("trigger_id") 2018-10-12 10:50:43,916 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "sym_trigger_router" ADD CONSTRAINT "sym_fk_tr_2_rtr" FOREIGN KEY ("router_id") REFERENCES "sym_router" ("router_id") 2018-10-12 10:50:43,919 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] 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-10-12 10:50:43,921 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] 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-10-12 10:50:43,924 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: CREATE INDEX "sym_idx_ib_time_status" ON "SyncTest"."dbo"."sym_incoming_batch" ("create_time", "status") 2018-10-12 10:50:43,926 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: CREATE INDEX "sym_idx_nd_hst_chnl_sts" ON "SyncTest"."dbo"."sym_node_host_channel_stats" ("node_id", "start_time", "end_time") 2018-10-12 10:50:43,928 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: CREATE INDEX "sym_idx_nd_hst_job" ON "SyncTest"."dbo"."sym_node_host_job_stats" ("node_id", "start_time", "end_time") 2018-10-12 10:50:43,930 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: CREATE INDEX "sym_idx_nd_hst_sts" ON "SyncTest"."dbo"."sym_node_host_stats" ("node_id", "start_time", "end_time") 2018-10-12 10:50:43,933 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: CREATE INDEX "sym_idx_trigg_hist_1" ON "SyncTest"."dbo"."sym_trigger_hist" ("trigger_id", "inactive_time") 2018-10-12 10:50:43,939 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] Done with auto update of SymmetricDS tables 2018-10-12 10:50:43,940 INFO [MSSQL01] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] Updating indexes to prevent lock escalation 2018-10-12 10:50:43,998 INFO [MSSQL01] [AbstractSymmetricEngine] [symmetric-engine-startup-2] Done initializing SymmetricDS database 2018-10-12 10:50:43,998 INFO [MSSQL01] [AbstractSymmetricEngine] [symmetric-engine-startup-2] SymmetricDS database version : 3.9.14 2018-10-12 10:50:43,998 INFO [MSSQL01] [AbstractSymmetricEngine] [symmetric-engine-startup-2] SymmetricDS software version : 3.9.14 2018-10-12 10:50:44,173 INFO [MSSQL01] [AbstractSymmetricEngine] [symmetric-engine-startup-2] Starting registered node [group=src, id=000, nodeId=000] 2018-10-12 10:50:44,176 INFO [MSSQL01] [ClusterService] [symmetric-engine-startup-2] This node picked a server id of SDS01 2018-10-12 10:50:44,177 INFO [MSSQL01] [TriggerRouterService] [symmetric-engine-startup-2] Synchronizing triggers 2018-10-12 10:50:44,324 INFO [MSSQL01] [MsSqlSymmetricDialect] [mssql01-sync-triggers-1] Creating SYM_ON_I_FOR_SYM_RTR_SRC trigger for SyncTest.dbo.sym_router 2018-10-12 10:50:44,341 INFO [MSSQL01] [MsSqlSymmetricDialect] [mssql01-sync-triggers-1] Creating SYM_ON_U_FOR_SYM_RTR_SRC trigger for SyncTest.dbo.sym_router 2018-10-12 10:50:44,354 INFO [MSSQL01] [MsSqlSymmetricDialect] [mssql01-sync-triggers-1] Creating SYM_ON_D_FOR_SYM_RTR_SRC trigger for SyncTest.dbo.sym_router 2018-10-12 10:50:44,430 INFO [MSSQL01] [MsSqlSymmetricDialect] [mssql01-sync-triggers-1] Creating SYM_ON_I_FOR_SYM_TRNSFRM_TBL_SRC trigger for SyncTest.dbo.sym_transform_table 2018-10-12 10:50:44,442 INFO [MSSQL01] [MsSqlSymmetricDialect] [mssql01-sync-triggers-1] Creating SYM_ON_U_FOR_SYM_TRNSFRM_TBL_SRC trigger for SyncTest.dbo.sym_transform_table 2018-10-12 10:50:44,454 INFO [MSSQL01] [MsSqlSymmetricDialect] [mssql01-sync-triggers-1] Creating SYM_ON_D_FOR_SYM_TRNSFRM_TBL_SRC trigger for SyncTest.dbo.sym_transform_table 2018-10-12 10:50:44,492 INFO [MSSQL01] [MsSqlSymmetricDialect] [mssql01-sync-triggers-1] Creating SYM_ON_I_FOR_SYM_PRMTR_SRC trigger for SyncTest.dbo.sym_parameter 2018-10-12 10:50:44,501 INFO [MSSQL01] [MsSqlSymmetricDialect] [mssql01-sync-triggers-1] Creating SYM_ON_U_FOR_SYM_PRMTR_SRC trigger for SyncTest.dbo.sym_parameter 2018-10-12 10:50:44,511 INFO [MSSQL01] [MsSqlSymmetricDialect] [mssql01-sync-triggers-1] Creating SYM_ON_D_FOR_SYM_PRMTR_SRC trigger for SyncTest.dbo.sym_parameter 2018-10-12 10:50:44,546 INFO [MSSQL01] [MsSqlSymmetricDialect] [mssql01-sync-triggers-1] Creating SYM_ON_I_FOR_SYM_FL_TRGGR_RTR_SRC trigger for SyncTest.dbo.sym_file_trigger_router 2018-10-12 10:50:44,556 INFO [MSSQL01] [MsSqlSymmetricDialect] [mssql01-sync-triggers-1] Creating SYM_ON_U_FOR_SYM_FL_TRGGR_RTR_SRC trigger for SyncTest.dbo.sym_file_trigger_router 2018-10-12 10:50:44,566 INFO [MSSQL01] [MsSqlSymmetricDialect] [mssql01-sync-triggers-1] Creating SYM_ON_D_FOR_SYM_FL_TRGGR_RTR_SRC trigger for SyncTest.dbo.sym_file_trigger_router 2018-10-12 10:50:44,603 INFO [MSSQL01] [MsSqlSymmetricDialect] [mssql01-sync-triggers-1] Creating SYM_ON_I_FOR_SYM_TBL_RLD_RQST_SRC trigger for SyncTest.dbo.sym_table_reload_request 2018-10-12 10:50:44,613 INFO [MSSQL01] [MsSqlSymmetricDialect] [mssql01-sync-triggers-1] Creating SYM_ON_U_FOR_SYM_TBL_RLD_RQST_SRC trigger for SyncTest.dbo.sym_table_reload_request 2018-10-12 10:50:44,627 INFO [MSSQL01] [MsSqlSymmetricDialect] [mssql01-sync-triggers-1] Creating SYM_ON_D_FOR_SYM_TBL_RLD_RQST_SRC trigger for SyncTest.dbo.sym_table_reload_request 2018-10-12 10:50:44,687 INFO [MSSQL01] [MsSqlSymmetricDialect] [mssql01-sync-triggers-1] Creating SYM_ON_I_FOR_SYM_GRPLT_LNK_SRC trigger for SyncTest.dbo.sym_grouplet_link 2018-10-12 10:50:44,695 INFO [MSSQL01] [MsSqlSymmetricDialect] [mssql01-sync-triggers-1] Creating SYM_ON_U_FOR_SYM_GRPLT_LNK_SRC trigger for SyncTest.dbo.sym_grouplet_link 2018-10-12 10:50:44,704 INFO [MSSQL01] [MsSqlSymmetricDialect] [mssql01-sync-triggers-1] Creating SYM_ON_D_FOR_SYM_GRPLT_LNK_SRC trigger for SyncTest.dbo.sym_grouplet_link 2018-10-12 10:50:44,736 INFO [MSSQL01] [MsSqlSymmetricDialect] [mssql01-sync-triggers-1] Creating SYM_ON_I_FOR_SYM_GRPLT_SRC trigger for SyncTest.dbo.sym_grouplet 2018-10-12 10:50:44,744 INFO [MSSQL01] [MsSqlSymmetricDialect] [mssql01-sync-triggers-1] Creating SYM_ON_U_FOR_SYM_GRPLT_SRC trigger for SyncTest.dbo.sym_grouplet 2018-10-12 10:50:44,753 INFO [MSSQL01] [MsSqlSymmetricDialect] [mssql01-sync-triggers-1] Creating SYM_ON_D_FOR_SYM_GRPLT_SRC trigger for SyncTest.dbo.sym_grouplet 2018-10-12 10:50:44,816 INFO [MSSQL01] [MsSqlSymmetricDialect] [mssql01-sync-triggers-1] Creating SYM_ON_I_FOR_SYM_FL_TRGGR_SRC trigger for SyncTest.dbo.sym_file_trigger 2018-10-12 10:50:44,827 INFO [MSSQL01] [MsSqlSymmetricDialect] [mssql01-sync-triggers-1] Creating SYM_ON_U_FOR_SYM_FL_TRGGR_SRC trigger for SyncTest.dbo.sym_file_trigger 2018-10-12 10:50:44,839 INFO [MSSQL01] [MsSqlSymmetricDialect] [mssql01-sync-triggers-1] Creating SYM_ON_D_FOR_SYM_FL_TRGGR_SRC trigger for SyncTest.dbo.sym_file_trigger 2018-10-12 10:50:44,873 INFO [MSSQL01] [MsSqlSymmetricDialect] [mssql01-sync-triggers-1] Creating SYM_ON_I_FOR_SYM_TRNSFRM_CLMN_SRC trigger for SyncTest.dbo.sym_transform_column 2018-10-12 10:50:44,883 INFO [MSSQL01] [MsSqlSymmetricDialect] [mssql01-sync-triggers-1] Creating SYM_ON_U_FOR_SYM_TRNSFRM_CLMN_SRC trigger for SyncTest.dbo.sym_transform_column 2018-10-12 10:50:44,917 INFO [MSSQL01] [MsSqlSymmetricDialect] [mssql01-sync-triggers-1] Creating SYM_ON_D_FOR_SYM_TRNSFRM_CLMN_SRC trigger for SyncTest.dbo.sym_transform_column 2018-10-12 10:50:45,008 INFO [MSSQL01] [MsSqlSymmetricDialect] [mssql01-sync-triggers-1] Creating SYM_ON_I_FOR_TST_SRC trigger for SyncTest.dbo.Test 2018-10-12 10:50:45,016 INFO [MSSQL01] [MsSqlSymmetricDialect] [mssql01-sync-triggers-1] Creating SYM_ON_U_FOR_TST_SRC trigger for SyncTest.dbo.Test 2018-10-12 10:50:45,024 INFO [MSSQL01] [MsSqlSymmetricDialect] [mssql01-sync-triggers-1] Creating SYM_ON_D_FOR_TST_SRC trigger for SyncTest.dbo.Test 2018-10-12 10:50:45,073 INFO [MSSQL01] [MsSqlSymmetricDialect] [mssql01-sync-triggers-1] Creating SYM_ON_I_FOR_SYM_JB_SRC trigger for SyncTest.dbo.sym_job 2018-10-12 10:50:45,084 INFO [MSSQL01] [MsSqlSymmetricDialect] [mssql01-sync-triggers-1] Creating SYM_ON_U_FOR_SYM_JB_SRC trigger for SyncTest.dbo.sym_job 2018-10-12 10:50:45,093 INFO [MSSQL01] [MsSqlSymmetricDialect] [mssql01-sync-triggers-1] Creating SYM_ON_D_FOR_SYM_JB_SRC trigger for SyncTest.dbo.sym_job 2018-10-12 10:50:45,128 INFO [MSSQL01] [MsSqlSymmetricDialect] [mssql01-sync-triggers-1] Creating SYM_ON_I_FOR_SYM_TRGGR_RTR_SRC trigger for SyncTest.dbo.sym_trigger_router 2018-10-12 10:50:45,156 INFO [MSSQL01] [MsSqlSymmetricDialect] [mssql01-sync-triggers-1] Creating SYM_ON_U_FOR_SYM_TRGGR_RTR_SRC trigger for SyncTest.dbo.sym_trigger_router 2018-10-12 10:50:45,166 INFO [MSSQL01] [MsSqlSymmetricDialect] [mssql01-sync-triggers-1] Creating SYM_ON_D_FOR_SYM_TRGGR_RTR_SRC trigger for SyncTest.dbo.sym_trigger_router 2018-10-12 10:50:45,205 INFO [MSSQL01] [MsSqlSymmetricDialect] [mssql01-sync-triggers-1] Creating SYM_ON_I_FOR_SYM_ND_SRC trigger for SyncTest.dbo.sym_node 2018-10-12 10:50:45,214 INFO [MSSQL01] [MsSqlSymmetricDialect] [mssql01-sync-triggers-1] Creating SYM_ON_U_FOR_SYM_ND_SRC trigger for SyncTest.dbo.sym_node 2018-10-12 10:50:45,225 INFO [MSSQL01] [MsSqlSymmetricDialect] [mssql01-sync-triggers-1] Creating SYM_ON_D_FOR_SYM_ND_SRC trigger for SyncTest.dbo.sym_node 2018-10-12 10:50:45,268 INFO [MSSQL01] [MsSqlSymmetricDialect] [mssql01-sync-triggers-1] Creating SYM_ON_I_FOR_SYM_ND_GRP_CHNNL_WND_SRC trigger for SyncTest.dbo.sym_node_group_channel_wnd 2018-10-12 10:50:45,275 INFO [MSSQL01] [MsSqlSymmetricDialect] [mssql01-sync-triggers-1] Creating SYM_ON_U_FOR_SYM_ND_GRP_CHNNL_WND_SRC trigger for SyncTest.dbo.sym_node_group_channel_wnd 2018-10-12 10:50:45,284 INFO [MSSQL01] [MsSqlSymmetricDialect] [mssql01-sync-triggers-1] Creating SYM_ON_D_FOR_SYM_ND_GRP_CHNNL_WND_SRC trigger for SyncTest.dbo.sym_node_group_channel_wnd 2018-10-12 10:50:45,317 INFO [MSSQL01] [MsSqlSymmetricDialect] [mssql01-sync-triggers-1] Creating SYM_ON_I_FOR_SYM_NTFCTN_SRC trigger for SyncTest.dbo.sym_notification 2018-10-12 10:50:45,327 INFO [MSSQL01] [MsSqlSymmetricDialect] [mssql01-sync-triggers-1] Creating SYM_ON_U_FOR_SYM_NTFCTN_SRC trigger for SyncTest.dbo.sym_notification 2018-10-12 10:50:45,336 INFO [MSSQL01] [MsSqlSymmetricDialect] [mssql01-sync-triggers-1] Creating SYM_ON_D_FOR_SYM_NTFCTN_SRC trigger for SyncTest.dbo.sym_notification 2018-10-12 10:50:45,377 INFO [MSSQL01] [MsSqlSymmetricDialect] [mssql01-sync-triggers-1] Creating SYM_ON_I_FOR_SYM_ND_GRP_LNK_SRC trigger for SyncTest.dbo.sym_node_group_link 2018-10-12 10:50:45,386 INFO [MSSQL01] [MsSqlSymmetricDialect] [mssql01-sync-triggers-1] Creating SYM_ON_U_FOR_SYM_ND_GRP_LNK_SRC trigger for SyncTest.dbo.sym_node_group_link 2018-10-12 10:50:45,395 INFO [MSSQL01] [MsSqlSymmetricDialect] [mssql01-sync-triggers-1] Creating SYM_ON_D_FOR_SYM_ND_GRP_LNK_SRC trigger for SyncTest.dbo.sym_node_group_link 2018-10-12 10:50:45,435 INFO [MSSQL01] [MsSqlSymmetricDialect] [mssql01-sync-triggers-1] Creating SYM_ON_I_FOR_SYM_ND_GRP_SRC trigger for SyncTest.dbo.sym_node_group 2018-10-12 10:50:45,443 INFO [MSSQL01] [MsSqlSymmetricDialect] [mssql01-sync-triggers-1] Creating SYM_ON_U_FOR_SYM_ND_GRP_SRC trigger for SyncTest.dbo.sym_node_group 2018-10-12 10:50:45,452 INFO [MSSQL01] [MsSqlSymmetricDialect] [mssql01-sync-triggers-1] Creating SYM_ON_D_FOR_SYM_ND_GRP_SRC trigger for SyncTest.dbo.sym_node_group 2018-10-12 10:50:45,484 INFO [MSSQL01] [MsSqlSymmetricDialect] [mssql01-sync-triggers-1] Creating SYM_ON_I_FOR_SYM_ND_SCRTY_SRC trigger for SyncTest.dbo.sym_node_security 2018-10-12 10:50:45,493 INFO [MSSQL01] [MsSqlSymmetricDialect] [mssql01-sync-triggers-1] Creating SYM_ON_U_FOR_SYM_ND_SCRTY_SRC trigger for SyncTest.dbo.sym_node_security 2018-10-12 10:50:45,502 INFO [MSSQL01] [MsSqlSymmetricDialect] [mssql01-sync-triggers-1] Creating SYM_ON_D_FOR_SYM_ND_SCRTY_SRC trigger for SyncTest.dbo.sym_node_security 2018-10-12 10:50:45,568 INFO [MSSQL01] [MsSqlSymmetricDialect] [mssql01-sync-triggers-1] Creating SYM_ON_I_FOR_SYM_LD_FLTR_SRC trigger for SyncTest.dbo.sym_load_filter 2018-10-12 10:50:45,584 INFO [MSSQL01] [MsSqlSymmetricDialect] [mssql01-sync-triggers-1] Creating SYM_ON_U_FOR_SYM_LD_FLTR_SRC trigger for SyncTest.dbo.sym_load_filter 2018-10-12 10:50:45,595 INFO [MSSQL01] [MsSqlSymmetricDialect] [mssql01-sync-triggers-1] Creating SYM_ON_D_FOR_SYM_LD_FLTR_SRC trigger for SyncTest.dbo.sym_load_filter 2018-10-12 10:50:45,630 INFO [MSSQL01] [MsSqlSymmetricDialect] [mssql01-sync-triggers-1] Creating SYM_ON_I_FOR_SYM_MNTR_SRC trigger for SyncTest.dbo.sym_monitor 2018-10-12 10:50:45,639 INFO [MSSQL01] [MsSqlSymmetricDialect] [mssql01-sync-triggers-1] Creating SYM_ON_U_FOR_SYM_MNTR_SRC trigger for SyncTest.dbo.sym_monitor 2018-10-12 10:50:45,663 INFO [MSSQL01] [MsSqlSymmetricDialect] [mssql01-sync-triggers-1] Creating SYM_ON_D_FOR_SYM_MNTR_SRC trigger for SyncTest.dbo.sym_monitor 2018-10-12 10:50:45,697 INFO [MSSQL01] [MsSqlSymmetricDialect] [mssql01-sync-triggers-1] Creating SYM_ON_I_FOR_SYM_XTNSN_SRC trigger for SyncTest.dbo.sym_extension 2018-10-12 10:50:45,706 INFO [MSSQL01] [MsSqlSymmetricDialect] [mssql01-sync-triggers-1] Creating SYM_ON_U_FOR_SYM_XTNSN_SRC trigger for SyncTest.dbo.sym_extension 2018-10-12 10:50:45,714 INFO [MSSQL01] [MsSqlSymmetricDialect] [mssql01-sync-triggers-1] Creating SYM_ON_D_FOR_SYM_XTNSN_SRC trigger for SyncTest.dbo.sym_extension 2018-10-12 10:50:45,746 INFO [MSSQL01] [MsSqlSymmetricDialect] [mssql01-sync-triggers-1] Creating SYM_ON_I_FOR_SYM_CNFLCT_SRC trigger for SyncTest.dbo.sym_conflict 2018-10-12 10:50:45,757 INFO [MSSQL01] [MsSqlSymmetricDialect] [mssql01-sync-triggers-1] Creating SYM_ON_U_FOR_SYM_CNFLCT_SRC trigger for SyncTest.dbo.sym_conflict 2018-10-12 10:50:45,767 INFO [MSSQL01] [MsSqlSymmetricDialect] [mssql01-sync-triggers-1] Creating SYM_ON_D_FOR_SYM_CNFLCT_SRC trigger for SyncTest.dbo.sym_conflict 2018-10-12 10:50:45,804 INFO [MSSQL01] [MsSqlSymmetricDialect] [mssql01-sync-triggers-1] Creating SYM_ON_I_FOR_SYM_TRGGR_SRC trigger for SyncTest.dbo.sym_trigger 2018-10-12 10:50:45,817 INFO [MSSQL01] [MsSqlSymmetricDialect] [mssql01-sync-triggers-1] Creating SYM_ON_U_FOR_SYM_TRGGR_SRC trigger for SyncTest.dbo.sym_trigger 2018-10-12 10:50:45,830 INFO [MSSQL01] [MsSqlSymmetricDialect] [mssql01-sync-triggers-1] Creating SYM_ON_D_FOR_SYM_TRGGR_SRC trigger for SyncTest.dbo.sym_trigger 2018-10-12 10:50:45,864 INFO [MSSQL01] [MsSqlSymmetricDialect] [mssql01-sync-triggers-1] Creating SYM_ON_I_FOR_SYM_CHNNL_SRC trigger for SyncTest.dbo.sym_channel 2018-10-12 10:50:45,874 INFO [MSSQL01] [MsSqlSymmetricDialect] [mssql01-sync-triggers-1] Creating SYM_ON_U_FOR_SYM_CHNNL_SRC trigger for SyncTest.dbo.sym_channel 2018-10-12 10:50:45,884 INFO [MSSQL01] [MsSqlSymmetricDialect] [mssql01-sync-triggers-1] Creating SYM_ON_D_FOR_SYM_CHNNL_SRC trigger for SyncTest.dbo.sym_channel 2018-10-12 10:50:45,920 INFO [MSSQL01] [MsSqlSymmetricDialect] [mssql01-sync-triggers-1] Creating SYM_ON_I_FOR_SYM_TRGGR_RTR_GRPLT_SRC trigger for SyncTest.dbo.sym_trigger_router_grouplet 2018-10-12 10:50:45,927 INFO [MSSQL01] [MsSqlSymmetricDialect] [mssql01-sync-triggers-1] Creating SYM_ON_U_FOR_SYM_TRGGR_RTR_GRPLT_SRC trigger for SyncTest.dbo.sym_trigger_router_grouplet 2018-10-12 10:50:45,953 INFO [MSSQL01] [MsSqlSymmetricDialect] [mssql01-sync-triggers-1] Creating SYM_ON_D_FOR_SYM_TRGGR_RTR_GRPLT_SRC trigger for SyncTest.dbo.sym_trigger_router_grouplet 2018-10-12 10:50:45,987 INFO [MSSQL01] [MsSqlSymmetricDialect] [mssql01-sync-triggers-1] Creating SYM_ON_I_FOR_SYM_ND_HST_SRC trigger for SyncTest.dbo.sym_node_host 2018-10-12 10:50:45,997 INFO [MSSQL01] [MsSqlSymmetricDialect] [mssql01-sync-triggers-1] Creating SYM_ON_U_FOR_SYM_ND_HST_SRC trigger for SyncTest.dbo.sym_node_host 2018-10-12 10:50:46,008 INFO [MSSQL01] [MsSqlSymmetricDialect] [mssql01-sync-triggers-1] Creating SYM_ON_D_FOR_SYM_ND_HST_SRC trigger for SyncTest.dbo.sym_node_host 2018-10-12 10:50:46,018 INFO [MSSQL01] [TriggerRouterService] [symmetric-engine-startup-2] Done synchronizing triggers 2018-10-12 10:50:46,025 INFO [MSSQL01] [RouterJob] [symmetric-engine-startup-2] Starting Routing on periodic schedule: every 10000ms with the first run at Fri Oct 12 10:50:55 UTC 2018 2018-10-12 10:50:46,025 INFO [MSSQL01] [PushJob] [symmetric-engine-startup-2] Starting Push on periodic schedule: every 60000ms with the first run at Fri Oct 12 10:50:55 UTC 2018 2018-10-12 10:50:46,025 INFO [MSSQL01] [PullJob] [symmetric-engine-startup-2] Starting Pull on periodic schedule: every 60000ms with the first run at Fri Oct 12 10:50:55 UTC 2018 2018-10-12 10:50:46,025 INFO [MSSQL01] [JobManager] [symmetric-engine-startup-2] Job Offline Push not configured for auto start 2018-10-12 10:50:46,025 INFO [MSSQL01] [JobManager] [symmetric-engine-startup-2] Job Offline Pull not configured for auto start 2018-10-12 10:50:46,026 INFO [MSSQL01] [OutgoingPurgeJob] [symmetric-engine-startup-2] Starting job 'Purge Outgoing' with cron expression: '0 0 0 * * *' 2018-10-12 10:50:46,026 INFO [MSSQL01] [IncomingPurgeJob] [symmetric-engine-startup-2] Starting job 'Purge Incoming' with cron expression: '0 0 0 * * *' 2018-10-12 10:50:46,027 INFO [MSSQL01] [StatisticFlushJob] [symmetric-engine-startup-2] Starting job 'Stat Flush' with cron expression: '0 0/5 * * * *' 2018-10-12 10:50:46,027 INFO [MSSQL01] [SyncTriggersJob] [symmetric-engine-startup-2] Starting job 'SyncTriggers' with cron expression: '0 0 0 * * *' 2018-10-12 10:50:46,027 INFO [MSSQL01] [HeartbeatJob] [symmetric-engine-startup-2] Starting Heartbeat on periodic schedule: every 900000ms with the first run at Fri Oct 12 10:50:55 UTC 2018 2018-10-12 10:50:46,028 INFO [MSSQL01] [WatchdogJob] [symmetric-engine-startup-2] Starting Watchdog on periodic schedule: every 3600000ms with the first run at Fri Oct 12 10:50:55 UTC 2018 2018-10-12 10:50:46,028 INFO [MSSQL01] [StageManagementJob] [symmetric-engine-startup-2] Starting job 'Stage Management' with cron expression: '0 0 * * * *' 2018-10-12 10:50:46,028 INFO [MSSQL01] [JobManager] [symmetric-engine-startup-2] Job Refresh Cache not configured for auto start 2018-10-12 10:50:46,028 INFO [MSSQL01] [JobManager] [symmetric-engine-startup-2] Job File Sync Tracker not configured for auto start 2018-10-12 10:50:46,029 INFO [MSSQL01] [JobManager] [symmetric-engine-startup-2] Job File Sync Pull not configured for auto start 2018-10-12 10:50:46,029 INFO [MSSQL01] [JobManager] [symmetric-engine-startup-2] Job File Sync Push not configured for auto start 2018-10-12 10:50:46,029 INFO [MSSQL01] [InitialLoadExtractorJob] [symmetric-engine-startup-2] Starting Initial Load Extract on periodic schedule: every 10000ms with the first run at Fri Oct 12 10:50:55 UTC 2018 2018-10-12 10:50:46,029 INFO [MSSQL01] [MonitorJob] [symmetric-engine-startup-2] Starting Monitor on periodic schedule: every 60000ms with the first run at Fri Oct 12 10:50:55 UTC 2018 2018-10-12 10:50:46,029 INFO [MSSQL01] [JobManager] [symmetric-engine-startup-2] Job Report Status not configured for auto start 2018-10-12 10:50:46,030 INFO [MSSQL01] [AbstractSymmetricEngine] [symmetric-engine-startup-2] SymmetricDS Node STARTED: nodeId=000 groupId=src type=server subType=null name=MSSQL01 softwareVersion=3.9.14 databaseName=Microsoft SQL Server databaseVersion=12.0 driverName=jTDS Type 4 JDBC Driver for MS SQL Server and Sybase driverVersion=1.2.8 uptime=0 sec. 2018-10-12 10:50:50,223 INFO [MYSQL01] [RouterJob] [MYSQL01-job-1] Did not run the 'Routing' job because the engine is not registered. 2018-10-12 10:50:50,227 INFO [MYSQL01] [PushJob] [MYSQL01-job-2] Did not run the 'Push' job because the engine is not registered. 2018-10-12 10:50:50,239 INFO [MYSQL01] [MonitorJob] [MYSQL01-job-7] Did not run the 'Monitor' job because the engine is not registered. 2018-10-12 10:50:50,239 INFO [MYSQL01] [InitialLoadExtractorJob] [MYSQL01-job-6] Did not run the 'Initial Load Extract' job because the engine is not registered. 2018-10-12 10:50:50,243 INFO [MYSQL01] [RegistrationService] [MYSQL01-job-3] This node is unregistered. It will attempt to register using the registration.url 2018-10-12 10:50:50,261 INFO [MYSQL01] [DataLoaderService] [MYSQL01-job-3] Using registration URL of http://localhost:31415/sync/MSSQL01/registration?nodeGroupId=dest&externalId=001&syncURL=http%3A%2F%2Flocalhost%3A31415%2Fsync%2FMYSQL01&schemaVersion=%3F&databaseType=MySQL&databaseVersion=8.0&symmetricVersion=3.9.14&deploymentType=server&hostName=SDS01&ipAddress=192.168.0.3 2018-10-12 10:50:50,388 INFO [MSSQL01] [RegistrationService] [qtp1708570683-31] Completed registration of node dest:001:001 2018-10-12 10:50:50,389 INFO [MSSQL01] [MsSqlSymmetricDialect] [qtp1708570683-31] This database DOES support disabling triggers during a symmetricds data load 2018-10-12 10:50:51,673 INFO [MYSQL01] [ConfigurationChangedDatabaseWriterFilter] [mysql01-dataloader-1] Grouplets flushed because new grouplet config came through the data loader 2018-10-12 10:50:51,673 INFO [MYSQL01] [ConfigurationChangedDatabaseWriterFilter] [mysql01-dataloader-1] Load filters flushed because new filter config came through the data loader 2018-10-12 10:50:51,673 INFO [MYSQL01] [ConfigurationChangedDatabaseWriterFilter] [mysql01-dataloader-1] Channels flushed because new channels came through the data loader 2018-10-12 10:50:51,673 INFO [MYSQL01] [ConfigurationChangedDatabaseWriterFilter] [mysql01-dataloader-1] About to refresh the cache of conflict settings because new configuration came through the data loader 2018-10-12 10:50:51,674 INFO [MYSQL01] [ConfigurationChangedDatabaseWriterFilter] [mysql01-dataloader-1] About to refresh the cache of parameters because new configuration came through the data loader 2018-10-12 10:50:51,683 INFO [MYSQL01] [ConfigurationChangedDatabaseWriterFilter] [mysql01-dataloader-1] About to refresh the cache of node security because new configuration came through the data loader 2018-10-12 10:50:51,686 INFO [MYSQL01] [ConfigurationChangedDatabaseWriterFilter] [MYSQL01-job-3] About to refresh the cache of transformation because new configuration came through the data loader 2018-10-12 10:50:51,686 INFO [MYSQL01] [ConfigurationChangedDatabaseWriterFilter] [MYSQL01-job-3] About to clear the staging area because new transform configuration came through the data loader 2018-10-12 10:50:51,687 INFO [MYSQL01] [StagingManager] [MYSQL01-job-3] Purged 1 from stage, freeing 10 kbytes of space 2018-10-12 10:50:51,688 INFO [MYSQL01] [ConfigurationChangedDatabaseWriterFilter] [MYSQL01-job-3] About to syncTriggers because new configuration came through the data loader 2018-10-12 10:50:51,688 INFO [MYSQL01] [TriggerRouterService] [MYSQL01-job-3] Synchronizing triggers 2018-10-12 10:50:51,697 INFO [MYSQL01] [TriggerRouterService] [MYSQL01-job-3] Done synchronizing triggers 2018-10-12 10:50:51,721 INFO [MYSQL01] [RegistrationService] [MYSQL01-job-3] Successfully registered node [id=001] 2018-10-12 10:50:51,732 INFO [MYSQL01] [ExtensionService] [MYSQL01-job-3] Found 0 extension points from the database that will be registered 2018-10-12 10:50:51,732 INFO [MYSQL01] [ClientExtensionService] [MYSQL01-job-3] Found 7 extension points from spring that will be registered 2018-10-12 10:50:51,732 INFO [MYSQL01] [PushHeartbeatListener] [MYSQL01-job-3] Some attribute(s) of node changed. Recording changes 2018-10-12 10:50:51,732 INFO [MYSQL01] [PushHeartbeatListener] [MYSQL01-job-3] Updating my node configuration info according to the symmetric properties 2018-10-12 10:50:51,751 INFO [MYSQL01] [NodeCommunicationService] [MYSQL01-job-3] pull will use 10 threads 2018-10-12 10:50:55,768 INFO [MSSQL01] [PushHeartbeatListener] [MSSQL01-job-4] Some attribute(s) of node changed. Recording changes 2018-10-12 10:50:55,768 INFO [MSSQL01] [PushHeartbeatListener] [MSSQL01-job-4] Updating my node configuration info according to the symmetric properties 2018-10-12 10:50:55,783 INFO [MSSQL01] [NodeCommunicationService] [MSSQL01-job-3] pull will use 10 threads 2018-10-12 10:50:55,789 INFO [MSSQL01] [NodeCommunicationService] [MSSQL01-job-2] push will use 10 threads 2018-10-12 10:50:55,808 INFO [MSSQL01] [DataService] [MSSQL01-job-1] Inserting missing last data gap: { startId: 1, endId: 50000001, createTime: "Fri Oct 12 10:50:55 UTC 2018" } 2018-10-12 10:50:55,855 INFO [MSSQL01] [DataService] [MSSQL01-job-1] Queueing up an initial load to node 001 2018-10-12 10:50:56,004 INFO [MSSQL01] [PurgeService] [MSSQL01-job-1] Purged all 0 incoming batch for node 001 2018-10-12 10:50:56,004 INFO [MSSQL01] [RouterService] [MSSQL01-job-1] Inserted reload events for node 001 in 168 ms 2018-10-12 10:50:56,010 INFO [MSSQL01] [DataGapFastDetector] [MSSQL01-job-1] Full gap analysis is running 2018-10-12 10:50:56,021 INFO [MSSQL01] [DataGapFastDetector] [MSSQL01-job-1] Querying data in gaps from database took 11 ms 2018-10-12 10:50:56,032 INFO [MSSQL01] [DataGapFastDetector] [MSSQL01-job-1] Full gap analysis is done after 22 ms 2018-10-12 10:50:56,052 INFO [MSSQL01] [RouterService] [MSSQL01-job-1] The 'config' channel is NOT in common batch mode 2018-10-12 10:50:56,101 INFO [MSSQL01] [ConfigurationChangedDataRouter] [MSSQL01-job-1] About to refresh the cache of nodes because new configuration came through the data router 2018-10-12 10:50:56,101 INFO [MSSQL01] [ConfigurationChangedDataRouter] [MSSQL01-job-1] About to refresh the cache of node security because new configuration came through the data router 2018-10-12 10:50:56,102 INFO [MSSQL01] [RouterService] [MSSQL01-job-1] The 'heartbeat' channel is NOT in common batch mode 2018-10-12 10:50:56,114 INFO [MSSQL01] [RouterService] [MSSQL01-job-1] Routed 6 data events in 104 ms 2018-10-12 10:51:00,232 INFO [MYSQL01] [DataService] [MYSQL01-job-8] Inserting missing last data gap: { startId: 1, endId: 50000001, createTime: "Fri Oct 12 10:51:00 UTC 2018" } 2018-10-12 10:51:00,320 INFO [MYSQL01] [DataGapFastDetector] [MYSQL01-job-8] Full gap analysis is running 2018-10-12 10:51:00,324 INFO [MYSQL01] [DataGapFastDetector] [MYSQL01-job-8] Querying data in gaps from database took 4 ms 2018-10-12 10:51:00,324 INFO [MYSQL01] [DataGapFastDetector] [MYSQL01-job-8] Full gap analysis is done after 4 ms 2018-10-12 10:51:05,815 INFO [MSSQL01] [NodeCommunicationService] [MSSQL01-job-10] extract will use 20 threads 2018-10-12 10:51:05,834 INFO [MSSQL01] [DataExtractorService] [mssql01-extract-default-1] Extracting batches for request 2. Starting at batch 5. Ending at batch 5 2018-10-12 10:51:05,880 INFO [MSSQL01] [DataExtractorService] [mssql01-extract-default-1] Done extracting 1 batches for request 2 2018-10-12 10:51:55,900 INFO [MSSQL01] [PushService] [mssql01-push-default-2] Push data sent to dest:001:001 2018-10-12 10:51:55,988 INFO [MYSQL01] [ConfigurationChangedDatabaseWriterFilter] [mysql01-dataloader-2] About to refresh the cache of node security because new configuration came through the data loader 2018-10-12 10:51:55,995 INFO [MYSQL01] [ConfigurationChangedDatabaseWriterFilter] [mysql01-dataloader-2] About to refresh the cache of nodes because new configuration came through the data loader 2018-10-12 10:51:56,011 INFO [MYSQL01] [DefaultDatabaseWriter] [mysql01-dataloader-2] About to create table using the following definition:
2018-10-12 10:51:56,014 INFO [MYSQL01] [MySqlDatabasePlatform] [mysql01-dataloader-2] Running alter sql: CREATE TABLE `Test`( `id` CHAR(10) NOT NULL, `Value` CHAR(10) NULL, PRIMARY KEY (`id`) ); 2018-10-12 10:51:56,046 INFO [MYSQL01] [ConfigurationChangedDatabaseWriterFilter] [mysql01-dataloader-2] About to refresh the cache of node security because new configuration came through the data loader 2018-10-12 10:51:56,060 INFO [MYSQL01] [DataLoaderService] [qtp1708570683-27] 7 data and 6 batches loaded during push request from src:000:000. 2018-10-12 10:51:56,093 INFO [MSSQL01] [PushService] [mssql01-push-default-2] Pushed data to node dest:001:001. 7 data and 6 batches were processed. (sym_node, sym_node_security, test) 2018-10-12 10:51:56,094 INFO [MSSQL01] [PushService] [mssql01-push-default-2] Pushing to dest:001:001 again because the last push contained reload batches 2018-10-12 10:51:56,108 INFO [MSSQL01] [PushService] [mssql01-push-default-2] Push data sent to dest:001:001 2018-10-12 10:51:56,125 INFO [MYSQL01] [DataLoaderService] [qtp1708570683-27] 1 data and 1 batches loaded during push request from src:000:000. 2018-10-12 10:51:56,132 INFO [MSSQL01] [PushService] [mssql01-push-default-2] Pushed data to node dest:001:001. 1 data and 1 batches were processed. (sym_node, sym_node_security, test, sym_node_host) 2018-10-12 10:52:16,248 INFO [MSSQL01] [RouterService] [MSSQL01-job-19] The 'default' channel is NOT in common batch mode 2018-10-12 10:52:16,265 INFO [MSSQL01] [RouterService] [MSSQL01-job-19] Routed 1 data events in 19 ms 2018-10-12 10:52:55,809 INFO [MSSQL01] [PushService] [mssql01-push-default-3] Push data sent to dest:001:001 2018-10-12 10:52:55,832 INFO [MYSQL01] [DefaultDatabaseWriter] [mysql01-dataloader-4] Failed to process update event in batch 000-10 on channel 'default'. Failed pk data was: "1 " Failed row data was: "1 ","Test2 " Failed old data was: "1 ","Test " StackTraceKey.init [ConflictException:2315013580] org.jumpmind.symmetric.io.data.writer.ConflictException: Detected conflict while executing UPDATE on SyncTest.Test. The primary key data was: {id=1 }. Failed to fallback. The original error message was: Duplicate entry '1' for key 'PRIMARY' at org.jumpmind.symmetric.io.data.writer.AbstractDatabaseWriterConflictResolver.performFallbackToUpdate(AbstractDatabaseWriterConflictResolver.java:256) at org.jumpmind.symmetric.io.data.writer.DefaultTransformWriterConflictResolver.performFallbackToUpdate(DefaultTransformWriterConflictResolver.java:110) at org.jumpmind.symmetric.io.data.writer.AbstractDatabaseWriterConflictResolver.needsResolved(AbstractDatabaseWriterConflictResolver.java:90) at org.jumpmind.symmetric.io.data.writer.AbstractDatabaseWriter.write(AbstractDatabaseWriter.java:211) at org.jumpmind.symmetric.io.data.writer.NestedDataWriter.write(NestedDataWriter.java:64) at org.jumpmind.symmetric.model.ProcessInfoDataWriter.write(ProcessInfoDataWriter.java:84) at org.jumpmind.symmetric.io.data.writer.NestedDataWriter.write(NestedDataWriter.java:64) at org.jumpmind.symmetric.io.data.writer.TransformWriter.write(TransformWriter.java:201) at org.jumpmind.symmetric.io.data.DataProcessor.forEachDataInTable(DataProcessor.java:210) at org.jumpmind.symmetric.io.data.DataProcessor.forEachTableInBatch(DataProcessor.java:177) at org.jumpmind.symmetric.io.data.DataProcessor.process(DataProcessor.java:123) at org.jumpmind.symmetric.service.impl.DataLoaderService$LoadIntoDatabaseOnArrivalListener$2.call(DataLoaderService.java:1039) at org.jumpmind.symmetric.service.impl.DataLoaderService$LoadIntoDatabaseOnArrivalListener$2.call(DataLoaderService.java:1016) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) 2018-10-12 10:52:55,841 ERROR [MYSQL01] [ManageIncomingBatchListener] [mysql01-dataloader-4] Failed to load batch 000-10 StackTraceKey [ConflictException:2315013580] 2018-10-12 10:52:55,857 ERROR [MSSQL01] [AcknowledgeService] [mssql01-push-default-3] The outgoing batch 001-10 failed: [CONFLICT,-999] Detected conflict while executing UPDATE on SyncTest.Test. The primary key data was: {id=1 }. Failed to fallback. The original error message was: Duplicate entry '1' for key 'PRIMARY'