2019-01-03 17:14:23,666 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 |
+-----------------------------------------------------------------+
2019-01-03 17:14:23,789 INFO [startup] [SymmetricWebServer] [main] About to start SymmetricDS web server on host:port 0.0.0.0:31415
2019-01-03 17:14:25,576 INFO [zol-000] [AbstractSymmetricEngine] [symmetric-engine-startup-2] Initializing connection to database
2019-01-03 17:14:25,576 INFO [zapaonline-001] [AbstractSymmetricEngine] [symmetric-engine-startup-1] Initializing connection to database
2019-01-03 17:14:26,841 INFO [zapaonline-001] [JdbcDatabasePlatformFactory] [symmetric-engine-startup-1] Detected database 'PostgreSQL', version '9', protocol 'postgresql'
2019-01-03 17:14:26,870 INFO [zapaonline-001] [JdbcDatabasePlatformFactory] [symmetric-engine-startup-1] The IDatabasePlatform being used is org.jumpmind.db.platform.postgresql.PostgreSqlDatabasePlatform
2019-01-03 17:14:27,000 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] The DbDialect being used is org.jumpmind.symmetric.db.postgresql.PostgreSqlSymmetricDialect
2019-01-03 17:14:27,057 INFO [zapaonline-001] [StagingManager] [symmetric-engine-startup-1] The staging directory was initialized at the following location: C:\Downloads\symmetric-server-3.9.16\tmp\zapaonline-001
2019-01-03 17:14:27,966 INFO [zol-000] [JdbcDatabasePlatformFactory] [symmetric-engine-startup-2] Detected database 'Microsoft SQL Server', version '14', protocol 'jtds'
2019-01-03 17:14:27,978 INFO [zol-000] [JdbcDatabasePlatformFactory] [symmetric-engine-startup-2] The IDatabasePlatform being used is org.jumpmind.db.platform.mssql.MsSql2008DatabasePlatform
2019-01-03 17:14:28,788 INFO [zapaonline-001] [ClientExtensionService] [symmetric-engine-startup-1] Found 7 extension points from spring that will be registered
2019-01-03 17:14:28,816 INFO [zapaonline-001] [AbstractSymmetricEngine] [symmetric-engine-startup-1] Initializing SymmetricDS database
2019-01-03 17:14:28,817 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] Checking if SymmetricDS tables need created or altered
2019-01-03 17:14:29,658 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] There are SymmetricDS tables that needed altered
2019-01-03 17:14:29,823 INFO [startup] [SymmetricWebServer] [main] Starting JMX HTTP console on port 31416
2019-01-03 17:14:29,873 INFO [startup] [SymmetricWebServer] [main] Joining the web server main thread
2019-01-03 17:14:29,945 INFO [zol-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] The DbDialect being used is org.jumpmind.symmetric.db.mssql.MsSqlSymmetricDialect
2019-01-03 17:14:29,968 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "sym_channel"(
"channel_id" VARCHAR(128) NOT NULL,
"processing_order" INTEGER DEFAULT 1 NOT NULL,
"max_batch_size" INTEGER DEFAULT 1000 NOT NULL,
"max_batch_to_send" INTEGER DEFAULT 60 NOT NULL,
"max_data_to_route" INTEGER DEFAULT 100000 NOT NULL,
"extract_period_millis" INTEGER DEFAULT 0 NOT NULL,
"enabled" SMALLINT DEFAULT 1 NOT NULL,
"use_old_data_to_route" SMALLINT DEFAULT 1 NOT NULL,
"use_row_data_to_route" SMALLINT DEFAULT 1 NOT NULL,
"use_pk_data_to_route" SMALLINT DEFAULT 1 NOT NULL,
"reload_flag" SMALLINT DEFAULT 0 NOT NULL,
"file_sync_flag" SMALLINT DEFAULT 0 NOT NULL,
"contains_big_lob" SMALLINT DEFAULT 0 NOT NULL,
"batch_algorithm" VARCHAR(50) DEFAULT 'default' NOT NULL,
"data_loader_type" VARCHAR(50) DEFAULT 'default' NOT NULL,
"description" VARCHAR(255),
"queue" VARCHAR(25) DEFAULT 'default' NOT NULL,
"max_network_kbps" NUMERIC(10,3) DEFAULT 0.000 NOT NULL,
"data_event_action" CHAR(1),
"create_time" TIMESTAMP,
"last_update_by" VARCHAR(50),
"last_update_time" TIMESTAMP,
PRIMARY KEY ("channel_id")
)
2019-01-03 17:14:30,009 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "sym_conflict"(
"conflict_id" VARCHAR(50) NOT NULL,
"source_node_group_id" VARCHAR(50) NOT NULL,
"target_node_group_id" VARCHAR(50) NOT NULL,
"target_channel_id" VARCHAR(128),
"target_catalog_name" VARCHAR(255),
"target_schema_name" VARCHAR(255),
"target_table_name" VARCHAR(255),
"detect_type" VARCHAR(128) NOT NULL,
"detect_expression" TEXT,
"resolve_type" VARCHAR(128) NOT NULL,
"ping_back" VARCHAR(128) NOT NULL,
"resolve_changes_only" SMALLINT DEFAULT 0,
"resolve_row_only" SMALLINT DEFAULT 0,
"create_time" TIMESTAMP NOT NULL,
"last_update_by" VARCHAR(50),
"last_update_time" TIMESTAMP NOT NULL,
PRIMARY KEY ("conflict_id")
)
2019-01-03 17:14:30,025 INFO [zol-000] [StagingManager] [symmetric-engine-startup-2] The staging directory was initialized at the following location: C:\Downloads\symmetric-server-3.9.16\tmp\zol-000
2019-01-03 17:14:30,029 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "sym_context"(
"name" VARCHAR(80) NOT NULL,
"context_value" TEXT,
"create_time" TIMESTAMP,
"last_update_time" TIMESTAMP,
PRIMARY KEY ("name")
)
2019-01-03 17:14:30,034 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE SEQUENCE "sym_data_data_id_seq"
2019-01-03 17:14:30,086 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "sym_data"(
"data_id" BIGINT NOT NULL DEFAULT nextval('"sym_data_data_id_seq"'),
"table_name" VARCHAR(255) NOT NULL,
"event_type" CHAR(1) NOT NULL,
"row_data" TEXT,
"pk_data" TEXT,
"old_data" TEXT,
"trigger_hist_id" INTEGER NOT NULL,
"channel_id" VARCHAR(128),
"transaction_id" VARCHAR(255),
"source_node_id" VARCHAR(50),
"external_data" VARCHAR(50),
"node_list" VARCHAR(255),
"create_time" TIMESTAMP,
PRIMARY KEY ("data_id")
)
2019-01-03 17:14:30,100 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE INDEX "sym_idx_d_channel_id" ON "sym_data" ("data_id", "channel_id")
2019-01-03 17:14:30,118 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "sym_data_event"(
"data_id" BIGINT NOT NULL,
"batch_id" BIGINT NOT NULL,
"router_id" VARCHAR(50) NOT NULL,
"create_time" TIMESTAMP,
PRIMARY KEY ("data_id", "batch_id", "router_id")
)
2019-01-03 17:14:30,132 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE INDEX "sym_idx_de_batchid" ON "sym_data_event" ("batch_id")
2019-01-03 17:14:30,152 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "sym_data_gap"(
"start_id" BIGINT NOT NULL,
"end_id" BIGINT NOT NULL,
"status" CHAR(2),
"create_time" TIMESTAMP NOT NULL,
"last_update_hostname" VARCHAR(255),
"last_update_time" TIMESTAMP NOT NULL,
PRIMARY KEY ("start_id", "end_id")
)
2019-01-03 17:14:30,179 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE INDEX "sym_idx_dg_status" ON "sym_data_gap" ("status")
2019-01-03 17:14:30,229 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "sym_extension"(
"extension_id" VARCHAR(50) NOT NULL,
"extension_type" VARCHAR(10) NOT NULL,
"interface_name" VARCHAR(255),
"node_group_id" VARCHAR(50) NOT NULL,
"enabled" SMALLINT DEFAULT 1 NOT NULL,
"extension_order" INTEGER DEFAULT 1 NOT NULL,
"extension_text" TEXT,
"create_time" TIMESTAMP,
"last_update_by" VARCHAR(50),
"last_update_time" TIMESTAMP,
PRIMARY KEY ("extension_id")
)
2019-01-03 17:14:30,251 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "sym_extract_request"(
"request_id" BIGINT NOT NULL,
"node_id" VARCHAR(50) NOT NULL,
"queue" VARCHAR(128),
"status" CHAR(2),
"start_batch_id" BIGINT NOT NULL,
"end_batch_id" BIGINT NOT NULL,
"trigger_id" VARCHAR(128) NOT NULL,
"router_id" VARCHAR(50) NOT NULL,
"last_update_time" TIMESTAMP,
"create_time" TIMESTAMP,
PRIMARY KEY ("request_id")
)
2019-01-03 17:14:30,264 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "sym_file_incoming"(
"relative_dir" VARCHAR(255) NOT NULL,
"file_name" VARCHAR(128) NOT NULL,
"last_event_type" CHAR(1) NOT NULL,
"node_id" VARCHAR(50) NOT NULL,
"file_modified_time" BIGINT,
PRIMARY KEY ("relative_dir", "file_name")
)
2019-01-03 17:14:30,289 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "sym_file_snapshot"(
"trigger_id" VARCHAR(128) NOT NULL,
"router_id" VARCHAR(50) NOT NULL,
"relative_dir" VARCHAR(255) NOT NULL,
"file_name" VARCHAR(128) NOT NULL,
"channel_id" VARCHAR(128) DEFAULT 'filesync' NOT NULL,
"reload_channel_id" VARCHAR(128) DEFAULT 'filesync_reload' NOT NULL,
"last_event_type" CHAR(1) NOT NULL,
"crc32_checksum" BIGINT,
"file_size" BIGINT,
"file_modified_time" BIGINT,
"last_update_time" TIMESTAMP NOT NULL,
"last_update_by" VARCHAR(50),
"create_time" TIMESTAMP NOT NULL,
PRIMARY KEY ("trigger_id", "router_id", "relative_dir", "file_name")
)
2019-01-03 17:14:30,299 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE INDEX "sym_idx_f_snpsht_chid" ON "sym_file_snapshot" ("reload_channel_id")
2019-01-03 17:14:30,321 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "sym_file_trigger"(
"trigger_id" VARCHAR(128) NOT NULL,
"channel_id" VARCHAR(128) DEFAULT 'filesync' NOT NULL,
"reload_channel_id" VARCHAR(128) DEFAULT 'filesync_reload' NOT NULL,
"base_dir" VARCHAR(255) NOT NULL,
"recurse" SMALLINT DEFAULT 1 NOT NULL,
"includes_files" VARCHAR(255),
"excludes_files" VARCHAR(255),
"sync_on_create" SMALLINT DEFAULT 1 NOT NULL,
"sync_on_modified" SMALLINT DEFAULT 1 NOT NULL,
"sync_on_delete" SMALLINT DEFAULT 1 NOT NULL,
"sync_on_ctl_file" SMALLINT DEFAULT 0 NOT NULL,
"delete_after_sync" SMALLINT DEFAULT 0 NOT NULL,
"before_copy_script" TEXT,
"after_copy_script" TEXT,
"create_time" TIMESTAMP NOT NULL,
"last_update_by" VARCHAR(50),
"last_update_time" TIMESTAMP NOT NULL,
"description" TEXT,
PRIMARY KEY ("trigger_id")
)
2019-01-03 17:14:30,350 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "sym_file_trigger_router"(
"trigger_id" VARCHAR(128) NOT NULL,
"router_id" VARCHAR(50) NOT NULL,
"enabled" SMALLINT DEFAULT 1 NOT NULL,
"initial_load_enabled" SMALLINT DEFAULT 1 NOT NULL,
"target_base_dir" VARCHAR(255),
"conflict_strategy" VARCHAR(128) DEFAULT 'source_wins' NOT NULL,
"create_time" TIMESTAMP NOT NULL,
"last_update_by" VARCHAR(50),
"last_update_time" TIMESTAMP NOT NULL,
"description" TEXT,
PRIMARY KEY ("trigger_id", "router_id")
)
2019-01-03 17:14:30,388 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "sym_grouplet"(
"grouplet_id" VARCHAR(50) NOT NULL,
"grouplet_link_policy" CHAR(1) DEFAULT 'I' NOT NULL,
"description" VARCHAR(255),
"create_time" TIMESTAMP NOT NULL,
"last_update_by" VARCHAR(50),
"last_update_time" TIMESTAMP NOT NULL,
PRIMARY KEY ("grouplet_id")
)
2019-01-03 17:14:30,425 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "sym_grouplet_link"(
"grouplet_id" VARCHAR(50) NOT NULL,
"external_id" VARCHAR(255) NOT NULL,
"create_time" TIMESTAMP NOT NULL,
"last_update_by" VARCHAR(50),
"last_update_time" TIMESTAMP NOT NULL,
PRIMARY KEY ("grouplet_id", "external_id")
)
2019-01-03 17:14:30,458 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "sym_incoming_batch"(
"batch_id" BIGINT NOT NULL,
"node_id" VARCHAR(50) NOT NULL,
"channel_id" VARCHAR(128),
"status" CHAR(2),
"error_flag" SMALLINT DEFAULT 0,
"sql_state" VARCHAR(10),
"sql_code" INTEGER DEFAULT 0 NOT NULL,
"sql_message" TEXT,
"last_update_hostname" VARCHAR(255),
"last_update_time" TIMESTAMP,
"create_time" TIMESTAMP,
"summary" VARCHAR(255),
"ignore_count" INTEGER DEFAULT 0 NOT NULL,
"byte_count" BIGINT DEFAULT 0 NOT NULL,
"load_flag" SMALLINT DEFAULT 0,
"extract_count" INTEGER DEFAULT 0 NOT NULL,
"sent_count" INTEGER DEFAULT 0 NOT NULL,
"load_count" INTEGER DEFAULT 0 NOT NULL,
"reload_row_count" INTEGER DEFAULT 0 NOT NULL,
"other_row_count" INTEGER DEFAULT 0 NOT NULL,
"data_row_count" INTEGER DEFAULT 0 NOT NULL,
"extract_row_count" INTEGER DEFAULT 0 NOT NULL,
"load_row_count" INTEGER DEFAULT 0 NOT NULL,
"data_insert_row_count" INTEGER DEFAULT 0 NOT NULL,
"data_update_row_count" INTEGER DEFAULT 0 NOT NULL,
"data_delete_row_count" INTEGER DEFAULT 0 NOT NULL,
"extract_insert_row_count" INTEGER DEFAULT 0 NOT NULL,
"extract_update_row_count" INTEGER DEFAULT 0 NOT NULL,
"extract_delete_row_count" INTEGER DEFAULT 0 NOT NULL,
"load_insert_row_count" INTEGER DEFAULT 0 NOT NULL,
"load_update_row_count" INTEGER DEFAULT 0 NOT NULL,
"load_delete_row_count" INTEGER DEFAULT 0 NOT NULL,
"network_millis" INTEGER DEFAULT 0 NOT NULL,
"filter_millis" INTEGER DEFAULT 0 NOT NULL,
"load_millis" INTEGER DEFAULT 0 NOT NULL,
"router_millis" INTEGER DEFAULT 0 NOT NULL,
"extract_millis" INTEGER DEFAULT 0 NOT NULL,
"transform_extract_millis" INTEGER DEFAULT 0 NOT NULL,
"transform_load_millis" INTEGER DEFAULT 0 NOT NULL,
"load_id" BIGINT,
"common_flag" SMALLINT DEFAULT 0,
"fallback_insert_count" INTEGER DEFAULT 0 NOT NULL,
"fallback_update_count" INTEGER DEFAULT 0 NOT NULL,
"ignore_row_count" INTEGER DEFAULT 0 NOT NULL,
"missing_delete_count" INTEGER DEFAULT 0 NOT NULL,
"skip_count" INTEGER DEFAULT 0 NOT NULL,
"failed_row_number" INTEGER DEFAULT 0 NOT NULL,
"failed_line_number" INTEGER DEFAULT 0 NOT NULL,
"failed_data_id" BIGINT DEFAULT 0 NOT NULL,
PRIMARY KEY ("batch_id", "node_id")
)
2019-01-03 17:14:30,523 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE INDEX "sym_idx_ib_time_status" ON "sym_incoming_batch" ("create_time", "status")
2019-01-03 17:14:30,537 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE INDEX "sym_idx_ib_in_error" ON "sym_incoming_batch" ("error_flag")
2019-01-03 17:14:30,567 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "sym_incoming_error"(
"batch_id" BIGINT NOT NULL,
"node_id" VARCHAR(50) NOT NULL,
"failed_row_number" BIGINT NOT NULL,
"failed_line_number" BIGINT DEFAULT 0 NOT NULL,
"target_catalog_name" VARCHAR(255),
"target_schema_name" VARCHAR(255),
"target_table_name" VARCHAR(255) NOT NULL,
"event_type" CHAR(1) NOT NULL,
"binary_encoding" VARCHAR(10) DEFAULT 'HEX' NOT NULL,
"column_names" 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" TIMESTAMP,
"last_update_by" VARCHAR(50),
"last_update_time" TIMESTAMP NOT NULL,
PRIMARY KEY ("batch_id", "node_id", "failed_row_number")
)
2019-01-03 17:14:30,578 INFO [zol-000] [ClientExtensionService] [symmetric-engine-startup-2] Found 7 extension points from spring that will be registered
2019-01-03 17:14:30,591 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [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" TEXT,
"description" VARCHAR(255),
"default_schedule" VARCHAR(50),
"default_auto_start" SMALLINT DEFAULT 1 NOT NULL,
"node_group_id" VARCHAR(50) NOT NULL,
"create_by" VARCHAR(50),
"create_time" TIMESTAMP,
"last_update_by" VARCHAR(50),
"last_update_time" TIMESTAMP,
PRIMARY KEY ("job_name")
)
2019-01-03 17:14:30,613 INFO [zol-000] [AbstractSymmetricEngine] [symmetric-engine-startup-2] Initializing SymmetricDS database
2019-01-03 17:14:30,613 INFO [zol-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] Checking if SymmetricDS tables need created or altered
2019-01-03 17:14:30,655 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "sym_load_filter"(
"load_filter_id" VARCHAR(50) NOT NULL,
"load_filter_type" VARCHAR(10) NOT NULL,
"source_node_group_id" VARCHAR(50) NOT NULL,
"target_node_group_id" VARCHAR(50) NOT NULL,
"target_catalog_name" VARCHAR(255),
"target_schema_name" VARCHAR(255),
"target_table_name" VARCHAR(255),
"filter_on_update" SMALLINT DEFAULT 1 NOT NULL,
"filter_on_insert" SMALLINT DEFAULT 1 NOT NULL,
"filter_on_delete" SMALLINT DEFAULT 1 NOT NULL,
"before_write_script" TEXT,
"after_write_script" TEXT,
"batch_complete_script" TEXT,
"batch_commit_script" TEXT,
"batch_rollback_script" TEXT,
"handle_error_script" TEXT,
"create_time" TIMESTAMP NOT NULL,
"last_update_by" VARCHAR(50),
"last_update_time" TIMESTAMP NOT NULL,
"load_filter_order" INTEGER DEFAULT 1 NOT NULL,
"fail_on_error" SMALLINT DEFAULT 0 NOT NULL,
PRIMARY KEY ("load_filter_id")
)
2019-01-03 17:14:30,681 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "sym_lock"(
"lock_action" VARCHAR(50) NOT NULL,
"lock_type" VARCHAR(50) NOT NULL,
"locking_server_id" VARCHAR(255),
"lock_time" TIMESTAMP,
"shared_count" INTEGER DEFAULT 0 NOT NULL,
"shared_enable" INTEGER DEFAULT 0 NOT NULL,
"last_lock_time" TIMESTAMP,
"last_locking_server_id" VARCHAR(255),
PRIMARY KEY ("lock_action")
)
2019-01-03 17:14:30,733 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [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" TIMESTAMP,
"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" INTEGER DEFAULT 0,
"batch_in_error_count" INTEGER DEFAULT 0,
"created_at_node_id" VARCHAR(50),
"deployment_type" VARCHAR(50),
"deployment_sub_type" VARCHAR(50),
PRIMARY KEY ("node_id")
)
2019-01-03 17:14:30,753 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "sym_node_communication"(
"node_id" VARCHAR(50) NOT NULL,
"queue" VARCHAR(25) DEFAULT 'default' NOT NULL,
"communication_type" VARCHAR(10) NOT NULL,
"lock_time" TIMESTAMP,
"locking_server_id" VARCHAR(255),
"last_lock_time" TIMESTAMP,
"last_lock_millis" BIGINT DEFAULT 0,
"success_count" BIGINT DEFAULT 0,
"fail_count" BIGINT DEFAULT 0,
"skip_count" BIGINT DEFAULT 0,
"total_success_count" BIGINT DEFAULT 0,
"total_fail_count" BIGINT DEFAULT 0,
"total_success_millis" BIGINT DEFAULT 0,
"total_fail_millis" BIGINT DEFAULT 0,
"batch_to_send_count" BIGINT DEFAULT 0,
"node_priority" INTEGER DEFAULT 0,
PRIMARY KEY ("node_id", "queue", "communication_type")
)
2019-01-03 17:14:30,767 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "sym_node_channel_ctl"(
"node_id" VARCHAR(50) NOT NULL,
"channel_id" VARCHAR(128) NOT NULL,
"suspend_enabled" SMALLINT DEFAULT 0,
"ignore_enabled" SMALLINT DEFAULT 0,
"last_extract_time" TIMESTAMP,
PRIMARY KEY ("node_id", "channel_id")
)
2019-01-03 17:14:30,778 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "sym_node_group"(
"node_group_id" VARCHAR(50) NOT NULL,
"description" VARCHAR(255),
"create_time" TIMESTAMP,
"last_update_by" VARCHAR(50),
"last_update_time" TIMESTAMP,
PRIMARY KEY ("node_group_id")
)
2019-01-03 17:14:30,794 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "sym_node_group_channel_wnd"(
"node_group_id" VARCHAR(50) NOT NULL,
"channel_id" VARCHAR(128) NOT NULL,
"start_time" TIMESTAMP NOT NULL,
"end_time" TIMESTAMP NOT NULL,
"enabled" SMALLINT DEFAULT 0 NOT NULL,
PRIMARY KEY ("node_group_id", "channel_id", "start_time", "end_time")
)
2019-01-03 17:14:30,808 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "sym_node_group_link"(
"source_node_group_id" VARCHAR(50) NOT NULL,
"target_node_group_id" VARCHAR(50) NOT NULL,
"data_event_action" CHAR(1) DEFAULT 'W' NOT NULL,
"sync_config_enabled" SMALLINT DEFAULT 1 NOT NULL,
"is_reversible" SMALLINT DEFAULT 0 NOT NULL,
"create_time" TIMESTAMP,
"last_update_by" VARCHAR(50),
"last_update_time" TIMESTAMP,
PRIMARY KEY ("source_node_group_id", "target_node_group_id")
)
2019-01-03 17:14:30,837 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "sym_node_host"(
"node_id" VARCHAR(50) NOT NULL,
"host_name" VARCHAR(60) NOT NULL,
"instance_id" VARCHAR(60),
"ip_address" VARCHAR(50),
"os_user" VARCHAR(50),
"os_name" VARCHAR(50),
"os_arch" VARCHAR(50),
"os_version" VARCHAR(50),
"available_processors" INTEGER DEFAULT 0,
"free_memory_bytes" BIGINT DEFAULT 0,
"total_memory_bytes" BIGINT DEFAULT 0,
"max_memory_bytes" BIGINT DEFAULT 0,
"java_version" VARCHAR(50),
"java_vendor" VARCHAR(255),
"jdbc_version" VARCHAR(255),
"symmetric_version" VARCHAR(50),
"timezone_offset" VARCHAR(6),
"heartbeat_time" TIMESTAMP,
"last_restart_time" TIMESTAMP NOT NULL,
"create_time" TIMESTAMP NOT NULL,
PRIMARY KEY ("node_id", "host_name")
)
2019-01-03 17:14:30,850 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "sym_node_host_channel_stats"(
"node_id" VARCHAR(50) NOT NULL,
"host_name" VARCHAR(60) NOT NULL,
"channel_id" VARCHAR(128) NOT NULL,
"start_time" TIMESTAMP NOT NULL,
"end_time" TIMESTAMP NOT NULL,
"data_routed" BIGINT DEFAULT 0,
"data_unrouted" BIGINT DEFAULT 0,
"data_event_inserted" BIGINT DEFAULT 0,
"data_extracted" BIGINT DEFAULT 0,
"data_bytes_extracted" BIGINT DEFAULT 0,
"data_extracted_errors" BIGINT DEFAULT 0,
"data_bytes_sent" BIGINT DEFAULT 0,
"data_sent" BIGINT DEFAULT 0,
"data_sent_errors" BIGINT DEFAULT 0,
"data_loaded" BIGINT DEFAULT 0,
"data_bytes_loaded" BIGINT DEFAULT 0,
"data_loaded_errors" BIGINT DEFAULT 0,
PRIMARY KEY ("node_id", "host_name", "channel_id", "start_time", "end_time")
)
2019-01-03 17:14:30,859 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE INDEX "sym_idx_nd_hst_chnl_sts" ON "sym_node_host_channel_stats" ("node_id", "start_time", "end_time")
2019-01-03 17:14:30,869 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "sym_node_host_job_stats"(
"node_id" VARCHAR(50) NOT NULL,
"host_name" VARCHAR(60) NOT NULL,
"job_name" VARCHAR(50) NOT NULL,
"start_time" TIMESTAMP NOT NULL,
"end_time" TIMESTAMP NOT NULL,
"processed_count" BIGINT DEFAULT 0,
"target_node_id" VARCHAR(50),
"target_node_count" INTEGER DEFAULT 0,
PRIMARY KEY ("node_id", "host_name", "job_name", "start_time", "end_time")
)
2019-01-03 17:14:30,878 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE INDEX "sym_idx_nd_hst_job" ON "sym_node_host_job_stats" ("node_id", "start_time", "end_time")
2019-01-03 17:14:30,889 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "sym_node_host_stats"(
"node_id" VARCHAR(50) NOT NULL,
"host_name" VARCHAR(60) NOT NULL,
"start_time" TIMESTAMP NOT NULL,
"end_time" TIMESTAMP NOT NULL,
"restarted" BIGINT DEFAULT 0 NOT NULL,
"nodes_pulled" BIGINT DEFAULT 0,
"total_nodes_pull_time" BIGINT DEFAULT 0,
"nodes_pushed" BIGINT DEFAULT 0,
"total_nodes_push_time" BIGINT DEFAULT 0,
"nodes_rejected" BIGINT DEFAULT 0,
"nodes_registered" BIGINT DEFAULT 0,
"nodes_loaded" BIGINT DEFAULT 0,
"nodes_disabled" BIGINT DEFAULT 0,
"purged_data_rows" BIGINT DEFAULT 0,
"purged_data_event_rows" BIGINT DEFAULT 0,
"purged_batch_outgoing_rows" BIGINT DEFAULT 0,
"purged_batch_incoming_rows" BIGINT DEFAULT 0,
"triggers_created_count" BIGINT,
"triggers_rebuilt_count" BIGINT,
"triggers_removed_count" BIGINT,
PRIMARY KEY ("node_id", "host_name", "start_time", "end_time")
)
2019-01-03 17:14:30,904 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE INDEX "sym_idx_nd_hst_sts" ON "sym_node_host_stats" ("node_id", "start_time", "end_time")
2019-01-03 17:14:30,939 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "sym_node_identity"(
"node_id" VARCHAR(50) NOT NULL,
PRIMARY KEY ("node_id")
)
2019-01-03 17:14:30,961 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "sym_node_security"(
"node_id" VARCHAR(50) NOT NULL,
"node_password" VARCHAR(50) NOT NULL,
"registration_enabled" SMALLINT DEFAULT 0,
"registration_time" TIMESTAMP,
"initial_load_enabled" SMALLINT DEFAULT 0,
"initial_load_time" TIMESTAMP,
"initial_load_id" BIGINT,
"initial_load_create_by" VARCHAR(255),
"rev_initial_load_enabled" SMALLINT DEFAULT 0,
"rev_initial_load_time" TIMESTAMP,
"rev_initial_load_id" BIGINT,
"rev_initial_load_create_by" VARCHAR(255),
"created_at_node_id" VARCHAR(50),
PRIMARY KEY ("node_id")
)
2019-01-03 17:14:30,990 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [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" TEXT,
"threshold" BIGINT DEFAULT 0 NOT NULL,
"run_period" INTEGER DEFAULT 0 NOT NULL,
"run_count" INTEGER DEFAULT 0 NOT NULL,
"severity_level" INTEGER DEFAULT 0 NOT NULL,
"enabled" SMALLINT DEFAULT 0 NOT NULL,
"create_time" TIMESTAMP,
"last_update_by" VARCHAR(50),
"last_update_time" TIMESTAMP,
PRIMARY KEY ("monitor_id")
)
2019-01-03 17:14:31,051 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "sym_monitor_event"(
"monitor_id" VARCHAR(128) NOT NULL,
"node_id" VARCHAR(50) NOT NULL,
"event_time" TIMESTAMP NOT NULL,
"host_name" VARCHAR(60),
"type" VARCHAR(50) NOT NULL,
"threshold" BIGINT DEFAULT 0 NOT NULL,
"event_value" BIGINT DEFAULT 0 NOT NULL,
"event_count" INTEGER DEFAULT 0 NOT NULL,
"severity_level" INTEGER DEFAULT 0 NOT NULL,
"is_resolved" SMALLINT DEFAULT 0 NOT NULL,
"is_notified" SMALLINT DEFAULT 0 NOT NULL,
"details" TEXT,
"last_update_time" TIMESTAMP,
PRIMARY KEY ("monitor_id", "node_id", "event_time")
)
2019-01-03 17:14:31,093 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [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" TEXT,
"enabled" SMALLINT DEFAULT 0 NOT NULL,
"create_time" TIMESTAMP,
"last_update_by" VARCHAR(50),
"last_update_time" TIMESTAMP,
PRIMARY KEY ("notification_id")
)
2019-01-03 17:14:31,161 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "sym_outgoing_batch"(
"batch_id" BIGINT NOT NULL,
"node_id" VARCHAR(50) NOT NULL,
"channel_id" VARCHAR(128),
"status" CHAR(2),
"error_flag" SMALLINT DEFAULT 0,
"sql_state" VARCHAR(10),
"sql_code" INTEGER DEFAULT 0 NOT NULL,
"sql_message" TEXT,
"last_update_hostname" VARCHAR(255),
"last_update_time" TIMESTAMP,
"create_time" TIMESTAMP,
"summary" VARCHAR(255),
"ignore_count" INTEGER DEFAULT 0 NOT NULL,
"byte_count" BIGINT DEFAULT 0 NOT NULL,
"load_flag" SMALLINT DEFAULT 0,
"extract_count" INTEGER DEFAULT 0 NOT NULL,
"sent_count" INTEGER DEFAULT 0 NOT NULL,
"load_count" INTEGER DEFAULT 0 NOT NULL,
"reload_row_count" INTEGER DEFAULT 0 NOT NULL,
"other_row_count" INTEGER DEFAULT 0 NOT NULL,
"data_row_count" INTEGER DEFAULT 0 NOT NULL,
"extract_row_count" INTEGER DEFAULT 0 NOT NULL,
"load_row_count" INTEGER DEFAULT 0 NOT NULL,
"data_insert_row_count" INTEGER DEFAULT 0 NOT NULL,
"data_update_row_count" INTEGER DEFAULT 0 NOT NULL,
"data_delete_row_count" INTEGER DEFAULT 0 NOT NULL,
"extract_insert_row_count" INTEGER DEFAULT 0 NOT NULL,
"extract_update_row_count" INTEGER DEFAULT 0 NOT NULL,
"extract_delete_row_count" INTEGER DEFAULT 0 NOT NULL,
"load_insert_row_count" INTEGER DEFAULT 0 NOT NULL,
"load_update_row_count" INTEGER DEFAULT 0 NOT NULL,
"load_delete_row_count" INTEGER DEFAULT 0 NOT NULL,
"network_millis" INTEGER DEFAULT 0 NOT NULL,
"filter_millis" INTEGER DEFAULT 0 NOT NULL,
"load_millis" INTEGER DEFAULT 0 NOT NULL,
"router_millis" INTEGER DEFAULT 0 NOT NULL,
"extract_millis" INTEGER DEFAULT 0 NOT NULL,
"transform_extract_millis" INTEGER DEFAULT 0 NOT NULL,
"transform_load_millis" INTEGER DEFAULT 0 NOT NULL,
"load_id" BIGINT,
"common_flag" SMALLINT DEFAULT 0,
"fallback_insert_count" INTEGER DEFAULT 0 NOT NULL,
"fallback_update_count" INTEGER DEFAULT 0 NOT NULL,
"ignore_row_count" INTEGER DEFAULT 0 NOT NULL,
"missing_delete_count" INTEGER DEFAULT 0 NOT NULL,
"skip_count" INTEGER DEFAULT 0 NOT NULL,
"total_extract_millis" INTEGER DEFAULT 0 NOT NULL,
"total_load_millis" INTEGER DEFAULT 0 NOT NULL,
"extract_job_flag" SMALLINT DEFAULT 0,
"extract_start_time" TIMESTAMP,
"transfer_start_time" TIMESTAMP,
"load_start_time" TIMESTAMP,
"failed_data_id" BIGINT DEFAULT 0 NOT NULL,
"failed_line_number" BIGINT DEFAULT 0 NOT NULL,
"create_by" VARCHAR(255),
PRIMARY KEY ("batch_id", "node_id")
)
2019-01-03 17:14:31,191 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE INDEX "sym_idx_ob_node_status" ON "sym_outgoing_batch" ("node_id", "status")
2019-01-03 17:14:31,221 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE INDEX "sym_idx_ob_status" ON "sym_outgoing_batch" ("status")
2019-01-03 17:14:31,239 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE INDEX "sym_idx_ob_in_error" ON "sym_outgoing_batch" ("error_flag")
2019-01-03 17:14:31,259 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [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" TEXT,
"create_time" TIMESTAMP,
"last_update_by" VARCHAR(50),
"last_update_time" TIMESTAMP,
PRIMARY KEY ("external_id", "node_group_id", "param_key")
)
2019-01-03 17:14:31,270 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "sym_registration_redirect"(
"registrant_external_id" VARCHAR(255) NOT NULL,
"registration_node_id" VARCHAR(50) NOT NULL,
PRIMARY KEY ("registrant_external_id")
)
2019-01-03 17:14:31,294 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "sym_registration_request"(
"node_group_id" VARCHAR(50) NOT NULL,
"external_id" VARCHAR(255) NOT NULL,
"status" CHAR(2) NOT NULL,
"host_name" VARCHAR(60) NOT NULL,
"ip_address" VARCHAR(50) NOT NULL,
"attempt_count" INTEGER DEFAULT 0,
"registered_node_id" VARCHAR(50),
"error_message" TEXT,
"create_time" TIMESTAMP NOT NULL,
"last_update_by" VARCHAR(50),
"last_update_time" TIMESTAMP NOT NULL,
PRIMARY KEY ("node_group_id", "external_id", "create_time")
)
2019-01-03 17:14:31,303 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE INDEX "sym_idx_reg_req_1" ON "sym_registration_request" ("node_group_id", "external_id", "status", "host_name", "ip_address")
2019-01-03 17:14:31,311 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE INDEX "sym_idx_reg_req_2" ON "sym_registration_request" ("status")
2019-01-03 17:14:31,331 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "sym_router"(
"router_id" VARCHAR(50) NOT NULL,
"target_catalog_name" VARCHAR(255),
"target_schema_name" VARCHAR(255),
"target_table_name" VARCHAR(255),
"source_node_group_id" VARCHAR(50) NOT NULL,
"target_node_group_id" VARCHAR(50) NOT NULL,
"router_type" VARCHAR(50),
"router_expression" TEXT,
"sync_on_update" SMALLINT DEFAULT 1 NOT NULL,
"sync_on_insert" SMALLINT DEFAULT 1 NOT NULL,
"sync_on_delete" SMALLINT DEFAULT 1 NOT NULL,
"use_source_catalog_schema" SMALLINT DEFAULT 1 NOT NULL,
"create_time" TIMESTAMP NOT NULL,
"last_update_by" VARCHAR(50),
"last_update_time" TIMESTAMP NOT NULL,
"description" TEXT,
PRIMARY KEY ("router_id")
)
2019-01-03 17:14:31,347 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "sym_sequence"(
"sequence_name" VARCHAR(50) NOT NULL,
"current_value" BIGINT DEFAULT 0 NOT NULL,
"increment_by" INTEGER DEFAULT 1 NOT NULL,
"min_value" BIGINT DEFAULT 1 NOT NULL,
"max_value" BIGINT DEFAULT 9999999999 NOT NULL,
"cycle_flag" SMALLINT DEFAULT 0,
"cache_size" INTEGER DEFAULT 0 NOT NULL,
"create_time" TIMESTAMP,
"last_update_by" VARCHAR(50),
"last_update_time" TIMESTAMP NOT NULL,
PRIMARY KEY ("sequence_name")
)
2019-01-03 17:14:31,374 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "sym_table_reload_request"(
"target_node_id" VARCHAR(50) NOT NULL,
"source_node_id" VARCHAR(50) NOT NULL,
"trigger_id" VARCHAR(128) NOT NULL,
"router_id" VARCHAR(50) NOT NULL,
"create_time" TIMESTAMP NOT NULL,
"create_table" SMALLINT DEFAULT 0 NOT NULL,
"delete_first" SMALLINT DEFAULT 0 NOT NULL,
"reload_select" TEXT,
"before_custom_sql" TEXT,
"reload_time" TIMESTAMP,
"load_id" BIGINT,
"processed" SMALLINT DEFAULT 0 NOT NULL,
"channel_id" VARCHAR(128),
"last_update_by" VARCHAR(50),
"last_update_time" TIMESTAMP NOT NULL,
PRIMARY KEY ("target_node_id", "source_node_id", "trigger_id", "router_id", "create_time")
)
2019-01-03 17:14:31,408 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "sym_transform_table"(
"transform_id" VARCHAR(50) NOT NULL,
"source_node_group_id" VARCHAR(50) NOT NULL,
"target_node_group_id" VARCHAR(50) NOT NULL,
"transform_point" VARCHAR(10) NOT NULL,
"source_catalog_name" VARCHAR(255),
"source_schema_name" VARCHAR(255),
"source_table_name" VARCHAR(255) NOT NULL,
"target_catalog_name" VARCHAR(255),
"target_schema_name" VARCHAR(255),
"target_table_name" VARCHAR(255),
"update_first" SMALLINT DEFAULT 0,
"update_action" VARCHAR(255) DEFAULT 'UPDATE_COL' NOT NULL,
"delete_action" VARCHAR(10) NOT NULL,
"transform_order" INTEGER DEFAULT 1 NOT NULL,
"column_policy" VARCHAR(10) DEFAULT 'SPECIFIED' NOT NULL,
"create_time" TIMESTAMP,
"last_update_by" VARCHAR(50),
"last_update_time" TIMESTAMP,
"description" TEXT,
PRIMARY KEY ("transform_id", "source_node_group_id", "target_node_group_id")
)
2019-01-03 17:14:31,431 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "sym_transform_column"(
"transform_id" VARCHAR(50) NOT NULL,
"include_on" CHAR(1) DEFAULT '*' NOT NULL,
"target_column_name" VARCHAR(128) NOT NULL,
"source_column_name" VARCHAR(128),
"pk" SMALLINT DEFAULT 0,
"transform_type" VARCHAR(50) DEFAULT 'copy',
"transform_expression" TEXT,
"transform_order" INTEGER DEFAULT 1 NOT NULL,
"create_time" TIMESTAMP,
"last_update_by" VARCHAR(50),
"last_update_time" TIMESTAMP,
"description" TEXT,
PRIMARY KEY ("transform_id", "include_on", "target_column_name")
)
2019-01-03 17:14:31,459 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "sym_trigger"(
"trigger_id" VARCHAR(128) NOT NULL,
"source_catalog_name" VARCHAR(255),
"source_schema_name" VARCHAR(255),
"source_table_name" VARCHAR(255) NOT NULL,
"channel_id" VARCHAR(128) NOT NULL,
"reload_channel_id" VARCHAR(128) DEFAULT 'reload' NOT NULL,
"sync_on_update" SMALLINT DEFAULT 1 NOT NULL,
"sync_on_insert" SMALLINT DEFAULT 1 NOT NULL,
"sync_on_delete" SMALLINT DEFAULT 1 NOT NULL,
"sync_on_incoming_batch" SMALLINT DEFAULT 0 NOT NULL,
"name_for_update_trigger" VARCHAR(255),
"name_for_insert_trigger" VARCHAR(255),
"name_for_delete_trigger" VARCHAR(255),
"sync_on_update_condition" 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" TIMESTAMP NOT NULL,
"last_update_by" VARCHAR(50),
"last_update_time" TIMESTAMP NOT NULL,
"description" TEXT,
PRIMARY KEY ("trigger_id")
)
2019-01-03 17:14:31,482 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "sym_trigger_hist"(
"trigger_hist_id" INTEGER NOT NULL,
"trigger_id" VARCHAR(128) NOT NULL,
"source_table_name" VARCHAR(255) NOT NULL,
"source_catalog_name" VARCHAR(255),
"source_schema_name" VARCHAR(255),
"name_for_update_trigger" VARCHAR(255),
"name_for_insert_trigger" VARCHAR(255),
"name_for_delete_trigger" VARCHAR(255),
"table_hash" BIGINT DEFAULT 0 NOT NULL,
"trigger_row_hash" BIGINT DEFAULT 0 NOT NULL,
"trigger_template_hash" BIGINT DEFAULT 0 NOT NULL,
"column_names" TEXT NOT NULL,
"pk_column_names" TEXT NOT NULL,
"last_trigger_build_reason" CHAR(1) NOT NULL,
"error_message" TEXT,
"create_time" TIMESTAMP NOT NULL,
"inactive_time" TIMESTAMP,
PRIMARY KEY ("trigger_hist_id")
)
2019-01-03 17:14:31,492 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE INDEX "sym_idx_trigg_hist_1" ON "sym_trigger_hist" ("trigger_id", "inactive_time")
2019-01-03 17:14:31,514 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [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" TEXT,
"initial_load_delete_stmt" TEXT,
"ping_back_enabled" SMALLINT DEFAULT 0 NOT NULL,
"create_time" TIMESTAMP NOT NULL,
"last_update_by" VARCHAR(50),
"last_update_time" TIMESTAMP NOT NULL,
"description" TEXT,
PRIMARY KEY ("trigger_id", "router_id")
)
2019-01-03 17:14:31,530 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: CREATE TABLE "sym_trigger_router_grouplet"(
"grouplet_id" VARCHAR(50) NOT NULL,
"trigger_id" VARCHAR(128) NOT NULL,
"router_id" VARCHAR(50) NOT NULL,
"applies_when" CHAR(1) NOT NULL,
"create_time" TIMESTAMP NOT NULL,
"last_update_by" VARCHAR(50),
"last_update_time" TIMESTAMP NOT NULL,
PRIMARY KEY ("grouplet_id", "trigger_id", "router_id", "applies_when")
)
2019-01-03 17:14:31,547 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: ALTER TABLE "sym_conflict"
ADD CONSTRAINT "sym_fk_cf_2_grp_lnk" FOREIGN KEY ("source_node_group_id", "target_node_group_id") REFERENCES "sym_node_group_link" ("source_node_group_id", "target_node_group_id")
2019-01-03 17:14:31,552 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: ALTER TABLE "sym_file_trigger_router"
ADD CONSTRAINT "sym_fk_ftr_2_ftrg" FOREIGN KEY ("trigger_id") REFERENCES "sym_file_trigger" ("trigger_id")
2019-01-03 17:14:31,557 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: ALTER TABLE "sym_file_trigger_router"
ADD CONSTRAINT "sym_fk_ftr_2_rtr" FOREIGN KEY ("router_id") REFERENCES "sym_router" ("router_id")
2019-01-03 17:14:31,562 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: ALTER TABLE "sym_grouplet_link"
ADD CONSTRAINT "sym_fk_gpltlnk_2_gplt" FOREIGN KEY ("grouplet_id") REFERENCES "sym_grouplet" ("grouplet_id")
2019-01-03 17:14:31,566 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: ALTER TABLE "sym_node_group_link"
ADD CONSTRAINT "sym_fk_lnk_2_grp_src" FOREIGN KEY ("source_node_group_id") REFERENCES "sym_node_group" ("node_group_id")
2019-01-03 17:14:31,570 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: ALTER TABLE "sym_node_group_link"
ADD CONSTRAINT "sym_fk_lnk_2_grp_tgt" FOREIGN KEY ("target_node_group_id") REFERENCES "sym_node_group" ("node_group_id")
2019-01-03 17:14:31,574 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: ALTER TABLE "sym_node_identity"
ADD CONSTRAINT "sym_fk_ident_2_node" FOREIGN KEY ("node_id") REFERENCES "sym_node" ("node_id")
2019-01-03 17:14:31,578 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: ALTER TABLE "sym_node_security"
ADD CONSTRAINT "sym_fk_sec_2_node" FOREIGN KEY ("node_id") REFERENCES "sym_node" ("node_id")
2019-01-03 17:14:31,582 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: ALTER TABLE "sym_router"
ADD CONSTRAINT "sym_fk_rt_2_grp_lnk" FOREIGN KEY ("source_node_group_id", "target_node_group_id") REFERENCES "sym_node_group_link" ("source_node_group_id", "target_node_group_id")
2019-01-03 17:14:31,589 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: ALTER TABLE "sym_transform_table"
ADD CONSTRAINT "sym_fk_tt_2_grp_lnk" FOREIGN KEY ("source_node_group_id", "target_node_group_id") REFERENCES "sym_node_group_link" ("source_node_group_id", "target_node_group_id")
2019-01-03 17:14:31,594 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: ALTER TABLE "sym_trigger"
ADD CONSTRAINT "sym_fk_trg_2_chnl" FOREIGN KEY ("channel_id") REFERENCES "sym_channel" ("channel_id")
2019-01-03 17:14:31,598 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: ALTER TABLE "sym_trigger"
ADD CONSTRAINT "sym_fk_trg_2_rld_chnl" FOREIGN KEY ("reload_channel_id") REFERENCES "sym_channel" ("channel_id")
2019-01-03 17:14:31,602 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: ALTER TABLE "sym_trigger_router"
ADD CONSTRAINT "sym_fk_tr_2_trg" FOREIGN KEY ("trigger_id") REFERENCES "sym_trigger" ("trigger_id")
2019-01-03 17:14:31,607 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: ALTER TABLE "sym_trigger_router"
ADD CONSTRAINT "sym_fk_tr_2_rtr" FOREIGN KEY ("router_id") REFERENCES "sym_router" ("router_id")
2019-01-03 17:14:31,610 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: ALTER TABLE "sym_trigger_router_grouplet"
ADD CONSTRAINT "sym_fk_trgplt_2_gplt" FOREIGN KEY ("grouplet_id") REFERENCES "sym_grouplet" ("grouplet_id")
2019-01-03 17:14:31,613 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: ALTER TABLE "sym_trigger_router_grouplet"
ADD CONSTRAINT "sym_fk_trgplt_2_tr" FOREIGN KEY ("trigger_id", "router_id") REFERENCES "sym_trigger_router" ("trigger_id", "router_id")
2019-01-03 17:14:31,628 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] Done with auto update of SymmetricDS tables
2019-01-03 17:14:31,729 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] Installing SymmetricDS database object:
CREATE or REPLACE FUNCTION sym_triggers_disabled() RETURNS INTEGER AS $$ DECLARE triggerDisabled INTEGER; BEGIN select current_setting('symmetric.triggers_disabled') into triggerDisabled; return triggerDisabled; EXCEPTION WHEN OTHERS THEN return 0; END; $$ LANGUAGE plpgsql;
2019-01-03 17:14:31,858 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] Just installed sym_triggers_disabled
2019-01-03 17:14:31,863 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] Installing SymmetricDS database object:
CREATE or REPLACE FUNCTION sym_node_disabled() RETURNS VARCHAR AS $$ DECLARE nodeId VARCHAR(50); BEGIN select current_setting('symmetric.node_disabled') into nodeId; return nodeId; EXCEPTION WHEN OTHERS THEN return ''; END; $$ LANGUAGE plpgsql;
2019-01-03 17:14:31,869 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] Just installed sym_node_disabled
2019-01-03 17:14:31,876 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] Installing SymmetricDS database object:
CREATE OR REPLACE FUNCTION sym_largeobject(objectId oid) RETURNS text AS $$ DECLARE encodedBlob text; encodedBlobPage text; BEGIN encodedBlob := ''; FOR encodedBlobPage IN SELECT pg_catalog.encode(data, 'escape') FROM pg_largeobject WHERE loid = objectId ORDER BY pageno LOOP encodedBlob := encodedBlob || encodedBlobPage; END LOOP; RETURN pg_catalog.encode(pg_catalog.decode(encodedBlob, 'escape'), 'base64'); EXCEPTION WHEN OTHERS THEN RETURN ''; END $$ LANGUAGE plpgsql;
2019-01-03 17:14:31,879 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] Just installed sym_largeobject
2019-01-03 17:14:31,882 INFO [zapaonline-001] [ConfigurationService] [symmetric-engine-startup-1] Auto-configuring config channel
2019-01-03 17:14:31,897 INFO [zapaonline-001] [ConfigurationService] [symmetric-engine-startup-1] Auto-configuring reload channel
2019-01-03 17:14:31,901 INFO [zapaonline-001] [ConfigurationService] [symmetric-engine-startup-1] Auto-configuring monitor channel
2019-01-03 17:14:31,906 INFO [zapaonline-001] [ConfigurationService] [symmetric-engine-startup-1] Auto-configuring heartbeat channel
2019-01-03 17:14:31,911 INFO [zapaonline-001] [ConfigurationService] [symmetric-engine-startup-1] Auto-configuring default channel
2019-01-03 17:14:31,916 INFO [zapaonline-001] [ConfigurationService] [symmetric-engine-startup-1] Auto-configuring dynamic channel
2019-01-03 17:14:31,978 INFO [zapaonline-001] [AbstractSymmetricEngine] [symmetric-engine-startup-1] Done initializing SymmetricDS database
2019-01-03 17:14:31,981 INFO [zapaonline-001] [AbstractSymmetricEngine] [symmetric-engine-startup-1] SymmetricDS database version : null
2019-01-03 17:14:31,981 INFO [zapaonline-001] [AbstractSymmetricEngine] [symmetric-engine-startup-1] SymmetricDS software version : 3.9.16
2019-01-03 17:14:32,078 INFO [zapaonline-001] [AbstractSymmetricEngine] [symmetric-engine-startup-1] Starting unregistered node [group=zapaonline, externalId=001]
2019-01-03 17:14:32,115 INFO [zapaonline-001] [RouterJob] [symmetric-engine-startup-1] Starting Routing on periodic schedule: every 5000ms with the first run at Thu Jan 03 17:14:39 CET 2019
2019-01-03 17:14:32,119 INFO [zapaonline-001] [PushJob] [symmetric-engine-startup-1] Starting Push on periodic schedule: every 10000ms with the first run at Thu Jan 03 17:14:39 CET 2019
2019-01-03 17:14:32,121 INFO [zapaonline-001] [PullJob] [symmetric-engine-startup-1] Starting Pull on periodic schedule: every 10000ms with the first run at Thu Jan 03 17:14:39 CET 2019
2019-01-03 17:14:32,121 INFO [zapaonline-001] [JobManager] [symmetric-engine-startup-1] Job Offline Push not configured for auto start
2019-01-03 17:14:32,121 INFO [zapaonline-001] [JobManager] [symmetric-engine-startup-1] Job Offline Pull not configured for auto start
2019-01-03 17:14:32,125 INFO [zapaonline-001] [OutgoingPurgeJob] [symmetric-engine-startup-1] Starting job 'Purge Outgoing' with cron expression: '0 0 0 * * *'
2019-01-03 17:14:32,128 INFO [zapaonline-001] [IncomingPurgeJob] [symmetric-engine-startup-1] Starting job 'Purge Incoming' with cron expression: '0 0 0 * * *'
2019-01-03 17:14:32,129 INFO [zapaonline-001] [StatisticFlushJob] [symmetric-engine-startup-1] Starting job 'Stat Flush' with cron expression: '0 0/5 * * * *'
2019-01-03 17:14:32,130 INFO [zapaonline-001] [SyncTriggersJob] [symmetric-engine-startup-1] Starting job 'SyncTriggers' with cron expression: '0 0 0 * * *'
2019-01-03 17:14:32,133 INFO [zapaonline-001] [HeartbeatJob] [symmetric-engine-startup-1] Starting Heartbeat on periodic schedule: every 900000ms with the first run at Thu Jan 03 17:14:39 CET 2019
2019-01-03 17:14:32,134 INFO [zapaonline-001] [WatchdogJob] [symmetric-engine-startup-1] Starting Watchdog on periodic schedule: every 3600000ms with the first run at Thu Jan 03 17:14:39 CET 2019
2019-01-03 17:14:32,137 INFO [zapaonline-001] [StageManagementJob] [symmetric-engine-startup-1] Starting job 'Stage Management' with cron expression: '0 0 * * * *'
2019-01-03 17:14:32,139 INFO [zapaonline-001] [JobManager] [symmetric-engine-startup-1] Job Refresh Cache not configured for auto start
2019-01-03 17:14:32,140 INFO [zapaonline-001] [JobManager] [symmetric-engine-startup-1] Job File Sync Tracker not configured for auto start
2019-01-03 17:14:32,141 INFO [zapaonline-001] [JobManager] [symmetric-engine-startup-1] Job File Sync Pull not configured for auto start
2019-01-03 17:14:32,143 INFO [zapaonline-001] [JobManager] [symmetric-engine-startup-1] Job File Sync Push not configured for auto start
2019-01-03 17:14:32,143 INFO [zapaonline-001] [InitialLoadExtractorJob] [symmetric-engine-startup-1] Starting Initial Load Extract on periodic schedule: every 10000ms with the first run at Thu Jan 03 17:14:39 CET 2019
2019-01-03 17:14:32,144 INFO [zapaonline-001] [MonitorJob] [symmetric-engine-startup-1] Starting Monitor on periodic schedule: every 60000ms with the first run at Thu Jan 03 17:14:39 CET 2019
2019-01-03 17:14:32,146 INFO [zapaonline-001] [JobManager] [symmetric-engine-startup-1] Job Report Status not configured for auto start
2019-01-03 17:14:32,148 INFO [zapaonline-001] [ClusterService] [symmetric-engine-startup-1] This node picked a server id of LPZWPL000001098
2019-01-03 17:14:32,152 INFO [zapaonline-001] [AbstractSymmetricEngine] [symmetric-engine-startup-1] SymmetricDS Node STARTED:
nodeId=001
groupId=zapaonline
type=server
subType=null
name=zapaonline-001
softwareVersion=3.9.16
databaseName=PostgreSQL
databaseVersion=9.6
driverName=PostgreSQL JDBC Driver
driverVersion=42.2.1
uptime=0 sec.
2019-01-03 17:14:32,449 INFO [zol-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] There are SymmetricDS tables that needed altered
2019-01-03 17:14:32,451 INFO [zol-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2019-01-03 17:14:32,453 INFO [zol-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2019-01-03 17:14:32,479 INFO [zol-000] [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")
)
2019-01-03 17:14:32,481 INFO [zol-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2019-01-03 17:14:32,491 INFO [zol-000] [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")
)
2019-01-03 17:14:32,494 INFO [zol-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2019-01-03 17:14:32,499 INFO [zol-000] [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")
)
2019-01-03 17:14:32,501 INFO [zol-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2019-01-03 17:14:32,509 INFO [zol-000] [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")
)
2019-01-03 17:14:32,513 INFO [zol-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: CREATE INDEX "sym_idx_d_channel_id" ON "sym_data" ("data_id", "channel_id")
2019-01-03 17:14:32,514 INFO [zol-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2019-01-03 17:14:32,519 INFO [zol-000] [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")
)
2019-01-03 17:14:32,522 INFO [zol-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: CREATE INDEX "sym_idx_de_batchid" ON "sym_data_event" ("batch_id")
2019-01-03 17:14:32,523 INFO [zol-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2019-01-03 17:14:32,528 INFO [zol-000] [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")
)
2019-01-03 17:14:32,533 INFO [zol-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: CREATE INDEX "sym_idx_dg_status" ON "sym_data_gap" ("status")
2019-01-03 17:14:32,534 INFO [zol-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2019-01-03 17:14:32,540 INFO [zol-000] [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")
)
2019-01-03 17:14:32,541 INFO [zol-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2019-01-03 17:14:32,548 INFO [zol-000] [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")
)
2019-01-03 17:14:32,550 INFO [zol-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2019-01-03 17:14:32,554 INFO [zol-000] [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")
)
2019-01-03 17:14:32,555 INFO [zol-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2019-01-03 17:14:32,563 INFO [zol-000] [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")
)
2019-01-03 17:14:32,567 INFO [zol-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: CREATE INDEX "sym_idx_f_snpsht_chid" ON "sym_file_snapshot" ("reload_channel_id")
2019-01-03 17:14:32,568 INFO [zol-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2019-01-03 17:14:32,577 INFO [zol-000] [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")
)
2019-01-03 17:14:32,578 INFO [zol-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2019-01-03 17:14:32,584 INFO [zol-000] [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")
)
2019-01-03 17:14:32,585 INFO [zol-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2019-01-03 17:14:32,606 INFO [zol-000] [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")
)
2019-01-03 17:14:32,607 INFO [zol-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2019-01-03 17:14:32,612 INFO [zol-000] [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")
)
2019-01-03 17:14:32,613 INFO [zol-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2019-01-03 17:14:32,637 INFO [zol-000] [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")
)
2019-01-03 17:14:32,640 INFO [zol-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: CREATE INDEX "sym_idx_ib_time_status" ON "sym_incoming_batch" ("create_time", "status")
2019-01-03 17:14:32,643 INFO [zol-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: CREATE INDEX "sym_idx_ib_in_error" ON "sym_incoming_batch" ("error_flag")
2019-01-03 17:14:32,646 INFO [zol-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2019-01-03 17:14:32,652 INFO [zol-000] [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")
)
2019-01-03 17:14:32,654 INFO [zol-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2019-01-03 17:14:32,659 INFO [zol-000] [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")
)
2019-01-03 17:14:32,660 INFO [zol-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2019-01-03 17:14:32,667 INFO [zol-000] [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")
)
2019-01-03 17:14:32,668 INFO [zol-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2019-01-03 17:14:32,674 INFO [zol-000] [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")
)
2019-01-03 17:14:32,675 INFO [zol-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2019-01-03 17:14:32,682 INFO [zol-000] [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")
)
2019-01-03 17:14:32,683 INFO [zol-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2019-01-03 17:14:32,689 INFO [zol-000] [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")
)
2019-01-03 17:14:32,691 INFO [zol-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2019-01-03 17:14:32,698 INFO [zol-000] [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")
)
2019-01-03 17:14:32,699 INFO [zol-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2019-01-03 17:14:32,703 INFO [zol-000] [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")
)
2019-01-03 17:14:32,705 INFO [zol-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2019-01-03 17:14:32,710 INFO [zol-000] [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")
)
2019-01-03 17:14:32,711 INFO [zol-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2019-01-03 17:14:32,715 INFO [zol-000] [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")
)
2019-01-03 17:14:32,717 INFO [zol-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2019-01-03 17:14:32,721 INFO [zol-000] [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")
)
2019-01-03 17:14:32,722 INFO [zol-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2019-01-03 17:14:32,730 INFO [zol-000] [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")
)
2019-01-03 17:14:32,733 INFO [zol-000] [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")
2019-01-03 17:14:32,734 INFO [zol-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2019-01-03 17:14:32,743 INFO [zol-000] [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")
)
2019-01-03 17:14:32,746 INFO [zol-000] [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")
2019-01-03 17:14:32,747 INFO [zol-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2019-01-03 17:14:32,759 INFO [zol-000] [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")
)
2019-01-03 17:14:32,763 INFO [zol-000] [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")
2019-01-03 17:14:32,766 INFO [zol-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2019-01-03 17:14:32,769 INFO [zol-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: CREATE TABLE "sym_node_identity"(
"node_id" VARCHAR(50) NOT NULL,
PRIMARY KEY ("node_id")
)
2019-01-03 17:14:32,770 INFO [zol-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2019-01-03 17:14:32,776 INFO [zol-000] [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")
)
2019-01-03 17:14:32,777 INFO [zol-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2019-01-03 17:14:32,784 INFO [zol-000] [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")
)
2019-01-03 17:14:32,785 INFO [zol-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2019-01-03 17:14:32,791 INFO [zol-000] [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")
)
2019-01-03 17:14:32,793 INFO [zol-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2019-01-03 17:14:32,799 INFO [zol-000] [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")
)
2019-01-03 17:14:32,801 INFO [zol-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2019-01-03 17:14:32,833 INFO [zol-000] [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")
)
2019-01-03 17:14:32,837 INFO [zol-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: CREATE INDEX "sym_idx_ob_node_status" ON "sym_outgoing_batch" ("node_id", "status")
2019-01-03 17:14:32,841 INFO [zol-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: CREATE INDEX "sym_idx_ob_status" ON "sym_outgoing_batch" ("status")
2019-01-03 17:14:32,844 INFO [zol-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: CREATE INDEX "sym_idx_ob_in_error" ON "sym_outgoing_batch" ("error_flag")
2019-01-03 17:14:32,846 INFO [zol-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2019-01-03 17:14:32,852 INFO [zol-000] [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")
)
2019-01-03 17:14:32,854 INFO [zol-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2019-01-03 17:14:32,867 INFO [zol-000] [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")
)
2019-01-03 17:14:32,868 INFO [zol-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2019-01-03 17:14:32,872 INFO [zol-000] [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")
)
2019-01-03 17:14:32,876 INFO [zol-000] [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")
2019-01-03 17:14:32,880 INFO [zol-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: CREATE INDEX "sym_idx_reg_req_2" ON "sym_registration_request" ("status")
2019-01-03 17:14:32,881 INFO [zol-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2019-01-03 17:14:32,887 INFO [zol-000] [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")
)
2019-01-03 17:14:32,888 INFO [zol-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2019-01-03 17:14:32,897 INFO [zol-000] [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")
)
2019-01-03 17:14:32,898 INFO [zol-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2019-01-03 17:14:32,903 INFO [zol-000] [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")
)
2019-01-03 17:14:32,905 INFO [zol-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2019-01-03 17:14:32,912 INFO [zol-000] [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")
)
2019-01-03 17:14:32,913 INFO [zol-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2019-01-03 17:14:32,940 INFO [zol-000] [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")
)
2019-01-03 17:14:32,942 INFO [zol-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2019-01-03 17:14:32,954 INFO [zol-000] [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")
)
2019-01-03 17:14:32,958 INFO [zol-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2019-01-03 17:14:32,964 INFO [zol-000] [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")
)
2019-01-03 17:14:32,968 INFO [zol-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: CREATE INDEX "sym_idx_trigg_hist_1" ON "sym_trigger_hist" ("trigger_id", "inactive_time")
2019-01-03 17:14:32,969 INFO [zol-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2019-01-03 17:14:32,977 INFO [zol-000] [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")
)
2019-01-03 17:14:32,978 INFO [zol-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2019-01-03 17:14:32,983 INFO [zol-000] [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")
)
2019-01-03 17:14:32,987 INFO [zol-000] [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")
2019-01-03 17:14:32,991 INFO [zol-000] [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")
2019-01-03 17:14:32,996 INFO [zol-000] [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")
2019-01-03 17:14:33,000 INFO [zol-000] [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")
2019-01-03 17:14:33,005 INFO [zol-000] [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")
2019-01-03 17:14:33,008 INFO [zol-000] [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")
2019-01-03 17:14:33,012 INFO [zol-000] [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")
2019-01-03 17:14:33,016 INFO [zol-000] [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")
2019-01-03 17:14:33,019 INFO [zol-000] [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")
2019-01-03 17:14:33,024 INFO [zol-000] [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")
2019-01-03 17:14:33,028 INFO [zol-000] [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")
2019-01-03 17:14:33,032 INFO [zol-000] [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")
2019-01-03 17:14:33,036 INFO [zol-000] [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")
2019-01-03 17:14:33,041 INFO [zol-000] [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")
2019-01-03 17:14:33,044 INFO [zol-000] [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")
2019-01-03 17:14:33,048 INFO [zol-000] [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")
2019-01-03 17:14:33,061 INFO [zol-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] Done with auto update of SymmetricDS tables
2019-01-03 17:14:33,174 INFO [zol-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] Updating indexes to prevent lock escalation
2019-01-03 17:14:33,249 INFO [zol-000] [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
2019-01-03 17:14:33,255 INFO [zol-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] Just installed sym_base64_encode
2019-01-03 17:14:33,260 INFO [zol-000] [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
2019-01-03 17:14:33,266 INFO [zol-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] Just installed sym_triggers_disabled
2019-01-03 17:14:33,271 INFO [zol-000] [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
2019-01-03 17:14:33,307 INFO [zol-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] Just installed sym_node_disabled
2019-01-03 17:14:33,311 INFO [zol-000] [ConfigurationService] [symmetric-engine-startup-2] Auto-configuring config channel
2019-01-03 17:14:33,330 INFO [zol-000] [ConfigurationService] [symmetric-engine-startup-2] Auto-configuring reload channel
2019-01-03 17:14:33,334 INFO [zol-000] [ConfigurationService] [symmetric-engine-startup-2] Auto-configuring monitor channel
2019-01-03 17:14:33,338 INFO [zol-000] [ConfigurationService] [symmetric-engine-startup-2] Auto-configuring heartbeat channel
2019-01-03 17:14:33,343 INFO [zol-000] [ConfigurationService] [symmetric-engine-startup-2] Auto-configuring default channel
2019-01-03 17:14:33,347 INFO [zol-000] [ConfigurationService] [symmetric-engine-startup-2] Auto-configuring dynamic channel
2019-01-03 17:14:33,451 INFO [zol-000] [AbstractSymmetricEngine] [symmetric-engine-startup-2] Inserting rows for node, security, identity and group for registration server
2019-01-03 17:14:33,526 INFO [zol-000] [AbstractSymmetricEngine] [symmetric-engine-startup-2] Done initializing SymmetricDS database
2019-01-03 17:14:33,526 INFO [zol-000] [AbstractSymmetricEngine] [symmetric-engine-startup-2] SymmetricDS database version : 3.9.16
2019-01-03 17:14:33,526 INFO [zol-000] [AbstractSymmetricEngine] [symmetric-engine-startup-2] SymmetricDS software version : 3.9.16
2019-01-03 17:14:34,627 INFO [zol-000] [AbstractSymmetricEngine] [symmetric-engine-startup-2] Starting registered node [group=zol, id=000, nodeId=000]
2019-01-03 17:14:34,632 INFO [zol-000] [ClusterService] [symmetric-engine-startup-2] This node picked a server id of LPZWPL000001098
2019-01-03 17:14:34,634 INFO [zol-000] [TriggerRouterService] [symmetric-engine-startup-2] Synchronizing triggers
2019-01-03 17:14:34,779 INFO [zol-000] [TriggerRouterService] [symmetric-engine-startup-2] Done synchronizing triggers
2019-01-03 17:14:34,801 INFO [zol-000] [RouterJob] [symmetric-engine-startup-2] Starting Routing on periodic schedule: every 5000ms with the first run at Thu Jan 03 17:14:44 CET 2019
2019-01-03 17:14:34,802 INFO [zol-000] [PushJob] [symmetric-engine-startup-2] Starting Push on periodic schedule: every 10000ms with the first run at Thu Jan 03 17:14:44 CET 2019
2019-01-03 17:14:34,803 INFO [zol-000] [PullJob] [symmetric-engine-startup-2] Starting Pull on periodic schedule: every 10000ms with the first run at Thu Jan 03 17:14:44 CET 2019
2019-01-03 17:14:34,804 INFO [zol-000] [JobManager] [symmetric-engine-startup-2] Job Offline Push not configured for auto start
2019-01-03 17:14:34,804 INFO [zol-000] [JobManager] [symmetric-engine-startup-2] Job Offline Pull not configured for auto start
2019-01-03 17:14:34,805 INFO [zol-000] [OutgoingPurgeJob] [symmetric-engine-startup-2] Starting job 'Purge Outgoing' with cron expression: '0 0 0 * * *'
2019-01-03 17:14:34,806 INFO [zol-000] [IncomingPurgeJob] [symmetric-engine-startup-2] Starting job 'Purge Incoming' with cron expression: '0 0 0 * * *'
2019-01-03 17:14:34,807 INFO [zol-000] [StatisticFlushJob] [symmetric-engine-startup-2] Starting job 'Stat Flush' with cron expression: '0 0/5 * * * *'
2019-01-03 17:14:34,809 INFO [zol-000] [SyncTriggersJob] [symmetric-engine-startup-2] Starting job 'SyncTriggers' with cron expression: '0 0 0 * * *'
2019-01-03 17:14:34,810 INFO [zol-000] [HeartbeatJob] [symmetric-engine-startup-2] Starting Heartbeat on periodic schedule: every 900000ms with the first run at Thu Jan 03 17:14:44 CET 2019
2019-01-03 17:14:34,811 INFO [zol-000] [WatchdogJob] [symmetric-engine-startup-2] Starting Watchdog on periodic schedule: every 3600000ms with the first run at Thu Jan 03 17:14:44 CET 2019
2019-01-03 17:14:34,812 INFO [zol-000] [StageManagementJob] [symmetric-engine-startup-2] Starting job 'Stage Management' with cron expression: '0 0 * * * *'
2019-01-03 17:14:34,813 INFO [zol-000] [JobManager] [symmetric-engine-startup-2] Job Refresh Cache not configured for auto start
2019-01-03 17:14:34,813 INFO [zol-000] [JobManager] [symmetric-engine-startup-2] Job File Sync Tracker not configured for auto start
2019-01-03 17:14:34,813 INFO [zol-000] [JobManager] [symmetric-engine-startup-2] Job File Sync Pull not configured for auto start
2019-01-03 17:14:34,813 INFO [zol-000] [JobManager] [symmetric-engine-startup-2] Job File Sync Push not configured for auto start
2019-01-03 17:14:34,814 INFO [zol-000] [InitialLoadExtractorJob] [symmetric-engine-startup-2] Starting Initial Load Extract on periodic schedule: every 10000ms with the first run at Thu Jan 03 17:14:44 CET 2019
2019-01-03 17:14:34,814 INFO [zol-000] [MonitorJob] [symmetric-engine-startup-2] Starting Monitor on periodic schedule: every 60000ms with the first run at Thu Jan 03 17:14:44 CET 2019
2019-01-03 17:14:34,815 INFO [zol-000] [JobManager] [symmetric-engine-startup-2] Job Report Status not configured for auto start
2019-01-03 17:14:34,816 INFO [zol-000] [AbstractSymmetricEngine] [symmetric-engine-startup-2] SymmetricDS Node STARTED:
nodeId=000
groupId=zol
type=server
subType=null
name=zol-000
softwareVersion=3.9.16
databaseName=Microsoft SQL Server
databaseVersion=14.0
driverName=jTDS Type 4 JDBC Driver for MS SQL Server and Sybase
driverVersion=1.2.8
uptime=0 sec.
2019-01-03 17:14:39,482 INFO [zapaonline-001] [RouterJob] [zapaonline-001-job-1] Did not run the 'Routing' job because the engine is not registered.
2019-01-03 17:14:39,487 INFO [zapaonline-001] [PushJob] [zapaonline-001-job-2] Did not run the 'Push' job because the engine is not registered.
2019-01-03 17:14:39,511 INFO [zapaonline-001] [InitialLoadExtractorJob] [zapaonline-001-job-5] Did not run the 'Initial Load Extract' job because the engine is not registered.
2019-01-03 17:14:39,513 INFO [zapaonline-001] [MonitorJob] [zapaonline-001-job-6] Did not run the 'Monitor' job because the engine is not registered.
2019-01-03 17:14:39,519 INFO [zapaonline-001] [RegistrationService] [zapaonline-001-job-3] This node is unregistered. It will attempt to register using the registration.url
2019-01-03 17:14:39,981 INFO [zapaonline-001] [DataLoaderService] [zapaonline-001-job-3] Using registration URL of http://localhost:31415/sync/zol-000/registration?nodeGroupId=zapaonline&externalId=001&syncURL=http%3A%2F%2FLPZWPL000001098%3A31415%2Fsync%2Fzapaonline-001&schemaVersion=%3F&databaseType=PostgreSQL&databaseVersion=9.6&symmetricVersion=3.9.16&deploymentType=server&hostName=LPZWPL000001098&ipAddress=10.100.199.1
2019-01-03 17:14:40,144 WARN [zol-000] [RegistrationService] [qtp973576304-18] Cannot register a client node unless a node group link exists so the registering node can receive configuration updates. Please add a group link where the source group id is zol and the target group id is zapaonline
2019-01-03 17:14:40,146 WARN [zol-000] [RegistrationUriHandler] [qtp973576304-18] zapaonline:001:? was not allowed to register.
2019-01-03 17:14:40,160 WARN [zapaonline-001] [RegistrationService] [zapaonline-001-job-3] Waiting for registration to be accepted by the server. Registration is not open.
2019-01-03 17:14:40,162 INFO [zapaonline-001] [RegistrationService] [zapaonline-001-job-3] Could not register. Sleeping for 6000ms before attempting again.
2019-01-03 17:14:44,557 INFO [zol-000] [PushHeartbeatListener] [zol-000-job-4] Some attribute(s) of node changed. Recording changes
2019-01-03 17:14:44,569 INFO [zol-000] [PushHeartbeatListener] [zol-000-job-4] Updating my node configuration info according to the symmetric properties
2019-01-03 17:14:44,610 INFO [zol-000] [NodeCommunicationService] [zol-000-job-3] pull will use 10 threads
2019-01-03 17:14:44,651 INFO [zol-000] [DataService] [zol-000-job-1] Inserting missing last data gap: { startId: 1, endId: 50000001, createTime: "Thu Jan 03 17:14:44 CET 2019" }
2019-01-03 17:14:44,698 INFO [zol-000] [DataGapFastDetector] [zol-000-job-1] Full gap analysis is running
2019-01-03 17:14:44,713 INFO [zol-000] [DataGapFastDetector] [zol-000-job-1] Querying data in gaps from database took 15 ms
2019-01-03 17:14:44,713 INFO [zol-000] [DataGapFastDetector] [zol-000-job-1] Full gap analysis is done after 15 ms
2019-01-03 17:14:46,164 INFO [zapaonline-001] [RegistrationService] [zapaonline-001-job-3] This node is unregistered. It will attempt to register using the registration.url
2019-01-03 17:14:46,576 INFO [zapaonline-001] [DataLoaderService] [zapaonline-001-job-3] Using registration URL of http://localhost:31415/sync/zol-000/registration?nodeGroupId=zapaonline&externalId=001&syncURL=http%3A%2F%2FLPZWPL000001098%3A31415%2Fsync%2Fzapaonline-001&schemaVersion=%3F&databaseType=PostgreSQL&databaseVersion=9.6&symmetricVersion=3.9.16&deploymentType=server&hostName=LPZWPL000001098&ipAddress=10.100.199.1
2019-01-03 17:14:46,629 WARN [zol-000] [RegistrationService] [qtp973576304-11] Cannot register a client node unless a node group link exists so the registering node can receive configuration updates. Please add a group link where the source group id is zol and the target group id is zapaonline
2019-01-03 17:14:46,629 WARN [zol-000] [RegistrationUriHandler] [qtp973576304-11] zapaonline:001:? was not allowed to register.
2019-01-03 17:14:46,630 WARN [zapaonline-001] [RegistrationService] [zapaonline-001-job-3] Waiting for registration to be accepted by the server. Registration is not open.
2019-01-03 17:14:46,631 INFO [zapaonline-001] [RegistrationService] [zapaonline-001-job-3] Could not register. Sleeping for 17000ms before attempting again.
2019-01-03 17:15:00,003 INFO [zapaonline-001] [StatisticFlushJob] [zapaonline-001-job-15] Did not run the 'Stat Flush' job because the engine is not registered.
2019-01-03 17:15:03,632 INFO [zapaonline-001] [RegistrationService] [zapaonline-001-job-3] This node is unregistered. It will attempt to register using the registration.url
2019-01-03 17:15:04,030 INFO [zapaonline-001] [DataLoaderService] [zapaonline-001-job-3] Using registration URL of http://localhost:31415/sync/zol-000/registration?nodeGroupId=zapaonline&externalId=001&syncURL=http%3A%2F%2FLPZWPL000001098%3A31415%2Fsync%2Fzapaonline-001&schemaVersion=%3F&databaseType=PostgreSQL&databaseVersion=9.6&symmetricVersion=3.9.16&deploymentType=server&hostName=LPZWPL000001098&ipAddress=10.100.199.1
2019-01-03 17:15:04,045 WARN [zol-000] [RegistrationService] [qtp973576304-12] Cannot register a client node unless a node group link exists so the registering node can receive configuration updates. Please add a group link where the source group id is zol and the target group id is zapaonline
2019-01-03 17:15:04,045 WARN [zol-000] [RegistrationUriHandler] [qtp973576304-12] zapaonline:001:? was not allowed to register.
2019-01-03 17:15:04,047 WARN [zapaonline-001] [RegistrationService] [zapaonline-001-job-3] Waiting for registration to be accepted by the server. Registration is not open.
2019-01-03 17:15:04,048 INFO [zapaonline-001] [RegistrationService] [zapaonline-001-job-3] Could not register. Sleeping for 9000ms before attempting again.
2019-01-03 17:15:13,049 INFO [zapaonline-001] [RegistrationService] [zapaonline-001-job-3] This node is unregistered. It will attempt to register using the registration.url
2019-01-03 17:15:13,457 INFO [zapaonline-001] [DataLoaderService] [zapaonline-001-job-3] Using registration URL of http://localhost:31415/sync/zol-000/registration?nodeGroupId=zapaonline&externalId=001&syncURL=http%3A%2F%2FLPZWPL000001098%3A31415%2Fsync%2Fzapaonline-001&schemaVersion=%3F&databaseType=PostgreSQL&databaseVersion=9.6&symmetricVersion=3.9.16&deploymentType=server&hostName=LPZWPL000001098&ipAddress=10.100.199.1
2019-01-03 17:15:13,472 WARN [zol-000] [RegistrationService] [qtp973576304-17] Cannot register a client node unless a node group link exists so the registering node can receive configuration updates. Please add a group link where the source group id is zol and the target group id is zapaonline
2019-01-03 17:15:13,472 WARN [zol-000] [RegistrationUriHandler] [qtp973576304-17] zapaonline:001:? was not allowed to register.
2019-01-03 17:15:13,473 WARN [zapaonline-001] [RegistrationService] [zapaonline-001-job-3] Waiting for registration to be accepted by the server. Registration is not open.
2019-01-03 17:15:13,474 INFO [zapaonline-001] [RegistrationService] [zapaonline-001-job-3] Could not register. Sleeping for 4000ms before attempting again.
2019-01-03 17:15:17,475 INFO [zapaonline-001] [RegistrationService] [zapaonline-001-job-3] This node is unregistered. It will attempt to register using the registration.url
2019-01-03 17:15:17,904 INFO [zapaonline-001] [DataLoaderService] [zapaonline-001-job-3] Using registration URL of http://localhost:31415/sync/zol-000/registration?nodeGroupId=zapaonline&externalId=001&syncURL=http%3A%2F%2FLPZWPL000001098%3A31415%2Fsync%2Fzapaonline-001&schemaVersion=%3F&databaseType=PostgreSQL&databaseVersion=9.6&symmetricVersion=3.9.16&deploymentType=server&hostName=LPZWPL000001098&ipAddress=10.100.199.1
2019-01-03 17:15:17,914 WARN [zol-000] [RegistrationService] [qtp973576304-15] Cannot register a client node unless a node group link exists so the registering node can receive configuration updates. Please add a group link where the source group id is zol and the target group id is zapaonline
2019-01-03 17:15:17,914 WARN [zol-000] [RegistrationUriHandler] [qtp973576304-15] zapaonline:001:? was not allowed to register.
2019-01-03 17:15:17,915 WARN [zapaonline-001] [RegistrationService] [zapaonline-001-job-3] Waiting for registration to be accepted by the server. Registration is not open.
2019-01-03 17:15:17,916 INFO [zapaonline-001] [RegistrationService] [zapaonline-001-job-3] Could not register. Sleeping for 15000ms before attempting again.
2019-01-03 17:15:32,918 INFO [zapaonline-001] [RegistrationService] [zapaonline-001-job-3] This node is unregistered. It will attempt to register using the registration.url
2019-01-03 17:15:33,323 INFO [zapaonline-001] [DataLoaderService] [zapaonline-001-job-3] Using registration URL of http://localhost:31415/sync/zol-000/registration?nodeGroupId=zapaonline&externalId=001&syncURL=http%3A%2F%2FLPZWPL000001098%3A31415%2Fsync%2Fzapaonline-001&schemaVersion=%3F&databaseType=PostgreSQL&databaseVersion=9.6&symmetricVersion=3.9.16&deploymentType=server&hostName=LPZWPL000001098&ipAddress=10.100.199.1
2019-01-03 17:15:33,334 WARN [zol-000] [RegistrationService] [qtp973576304-12] Cannot register a client node unless a node group link exists so the registering node can receive configuration updates. Please add a group link where the source group id is zol and the target group id is zapaonline
2019-01-03 17:15:33,334 WARN [zol-000] [RegistrationUriHandler] [qtp973576304-12] zapaonline:001:? was not allowed to register.
2019-01-03 17:15:33,335 WARN [zapaonline-001] [RegistrationService] [zapaonline-001-job-3] Waiting for registration to be accepted by the server. Registration is not open.
2019-01-03 17:15:33,336 INFO [zapaonline-001] [RegistrationService] [zapaonline-001-job-3] Could not register. Sleeping for 18000ms before attempting again.
2019-01-03 17:15:51,337 INFO [zapaonline-001] [RegistrationService] [zapaonline-001-job-3] This node is unregistered. It will attempt to register using the registration.url
2019-01-03 17:15:51,784 INFO [zapaonline-001] [DataLoaderService] [zapaonline-001-job-3] Using registration URL of http://localhost:31415/sync/zol-000/registration?nodeGroupId=zapaonline&externalId=001&syncURL=http%3A%2F%2FLPZWPL000001098%3A31415%2Fsync%2Fzapaonline-001&schemaVersion=%3F&databaseType=PostgreSQL&databaseVersion=9.6&symmetricVersion=3.9.16&deploymentType=server&hostName=LPZWPL000001098&ipAddress=10.100.199.1
2019-01-03 17:15:51,797 WARN [zol-000] [RegistrationService] [qtp973576304-17] Cannot register a client node unless a node group link exists so the registering node can receive configuration updates. Please add a group link where the source group id is zol and the target group id is zapaonline
2019-01-03 17:15:51,797 WARN [zol-000] [RegistrationUriHandler] [qtp973576304-17] zapaonline:001:? was not allowed to register.
2019-01-03 17:15:51,798 WARN [zapaonline-001] [RegistrationService] [zapaonline-001-job-3] Waiting for registration to be accepted by the server. Registration is not open.
2019-01-03 17:15:51,799 INFO [zapaonline-001] [RegistrationService] [zapaonline-001-job-3] Could not register. Sleeping for 2000ms before attempting again.
2019-01-03 17:15:53,800 INFO [zapaonline-001] [RegistrationService] [zapaonline-001-job-3] This node is unregistered. It will attempt to register using the registration.url
2019-01-03 17:15:54,256 INFO [zapaonline-001] [DataLoaderService] [zapaonline-001-job-3] Using registration URL of http://localhost:31415/sync/zol-000/registration?nodeGroupId=zapaonline&externalId=001&syncURL=http%3A%2F%2FLPZWPL000001098%3A31415%2Fsync%2Fzapaonline-001&schemaVersion=%3F&databaseType=PostgreSQL&databaseVersion=9.6&symmetricVersion=3.9.16&deploymentType=server&hostName=LPZWPL000001098&ipAddress=10.100.199.1
2019-01-03 17:15:54,270 WARN [zol-000] [RegistrationService] [qtp973576304-15] Cannot register a client node unless a node group link exists so the registering node can receive configuration updates. Please add a group link where the source group id is zol and the target group id is zapaonline
2019-01-03 17:15:54,271 WARN [zol-000] [RegistrationUriHandler] [qtp973576304-15] zapaonline:001:? was not allowed to register.
2019-01-03 17:15:54,271 WARN [zapaonline-001] [RegistrationService] [zapaonline-001-job-3] Waiting for registration to be accepted by the server. Registration is not open.
2019-01-03 17:15:54,272 INFO [zapaonline-001] [RegistrationService] [zapaonline-001-job-3] Could not register. Sleeping for 17000ms before attempting again.
2019-01-03 17:16:02,039 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 |
+-----------------------------------------------------------------+
2019-01-03 17:16:02,122 INFO [startup] [SymmetricWebServer] [main] About to start SymmetricDS web server on host:port 0.0.0.0:31415
2019-01-03 17:16:03,018 INFO [zol-000] [AbstractSymmetricEngine] [symmetric-engine-startup-2] Initializing connection to database
2019-01-03 17:16:03,018 INFO [zapaonline-001] [AbstractSymmetricEngine] [symmetric-engine-startup-1] Initializing connection to database
2019-01-03 17:16:03,376 INFO [zol-000] [JdbcDatabasePlatformFactory] [symmetric-engine-startup-2] Detected database 'Microsoft SQL Server', version '14', protocol 'jtds'
2019-01-03 17:16:03,408 INFO [zol-000] [JdbcDatabasePlatformFactory] [symmetric-engine-startup-2] The IDatabasePlatform being used is org.jumpmind.db.platform.mssql.MsSql2008DatabasePlatform
2019-01-03 17:16:03,988 INFO [zapaonline-001] [JdbcDatabasePlatformFactory] [symmetric-engine-startup-1] Detected database 'PostgreSQL', version '9', protocol 'postgresql'
2019-01-03 17:16:03,992 INFO [zol-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] The DbDialect being used is org.jumpmind.symmetric.db.mssql.MsSqlSymmetricDialect
2019-01-03 17:16:03,995 INFO [zapaonline-001] [JdbcDatabasePlatformFactory] [symmetric-engine-startup-1] The IDatabasePlatform being used is org.jumpmind.db.platform.postgresql.PostgreSqlDatabasePlatform
2019-01-03 17:16:04,206 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] The DbDialect being used is org.jumpmind.symmetric.db.postgresql.PostgreSqlSymmetricDialect
2019-01-03 17:16:04,331 INFO [zapaonline-001] [ExtensionService] [symmetric-engine-startup-1] Found 0 extension points from the database that will be registered
2019-01-03 17:16:04,351 INFO [zapaonline-001] [StagingManager] [symmetric-engine-startup-1] The staging directory was initialized at the following location: C:\Downloads\symmetric-server-3.9.16\tmp\zapaonline-001
2019-01-03 17:16:04,512 INFO [zol-000] [ExtensionService] [symmetric-engine-startup-2] Found 0 extension points from the database that will be registered
2019-01-03 17:16:04,515 INFO [zol-000] [StagingManager] [symmetric-engine-startup-2] The staging directory was initialized at the following location: C:\Downloads\symmetric-server-3.9.16\tmp\zol-000
2019-01-03 17:16:05,365 INFO [zapaonline-001] [ExtensionService] [symmetric-engine-startup-1] Found 0 extension points from the database that will be registered
2019-01-03 17:16:05,367 INFO [zapaonline-001] [ClientExtensionService] [symmetric-engine-startup-1] Found 7 extension points from spring that will be registered
2019-01-03 17:16:05,385 INFO [zapaonline-001] [AbstractSymmetricEngine] [symmetric-engine-startup-1] Initializing SymmetricDS database
2019-01-03 17:16:05,386 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] Checking if SymmetricDS tables need created or altered
2019-01-03 17:16:06,266 INFO [zol-000] [ExtensionService] [symmetric-engine-startup-2] Found 0 extension points from the database that will be registered
2019-01-03 17:16:06,289 INFO [zol-000] [ClientExtensionService] [symmetric-engine-startup-2] Found 7 extension points from spring that will be registered
2019-01-03 17:16:06,314 INFO [zol-000] [AbstractSymmetricEngine] [symmetric-engine-startup-2] Initializing SymmetricDS database
2019-01-03 17:16:06,319 INFO [zol-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] Checking if SymmetricDS tables need created or altered
2019-01-03 17:16:06,910 INFO [startup] [SymmetricWebServer] [main] Starting JMX HTTP console on port 31416
2019-01-03 17:16:06,954 INFO [startup] [SymmetricWebServer] [main] Joining the web server main thread
2019-01-03 17:16:07,940 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] There are SymmetricDS tables that needed altered
2019-01-03 17:16:07,995 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] DDL applied: ALTER TABLE "public"."sym_sequence"
ALTER COLUMN "max_value" SET DEFAULT 9999999999
2019-01-03 17:16:08,024 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [symmetric-engine-startup-1] Done with auto update of SymmetricDS tables
2019-01-03 17:16:08,099 INFO [zapaonline-001] [ConfigurationService] [symmetric-engine-startup-1] Auto-configuring config channel
2019-01-03 17:16:08,122 INFO [zapaonline-001] [ConfigurationService] [symmetric-engine-startup-1] Auto-configuring reload channel
2019-01-03 17:16:08,125 INFO [zapaonline-001] [ConfigurationService] [symmetric-engine-startup-1] Auto-configuring monitor channel
2019-01-03 17:16:08,130 INFO [zapaonline-001] [ConfigurationService] [symmetric-engine-startup-1] Auto-configuring heartbeat channel
2019-01-03 17:16:08,135 INFO [zapaonline-001] [ConfigurationService] [symmetric-engine-startup-1] Auto-configuring default channel
2019-01-03 17:16:08,149 INFO [zapaonline-001] [ConfigurationService] [symmetric-engine-startup-1] Auto-configuring dynamic channel
2019-01-03 17:16:08,216 INFO [zapaonline-001] [AbstractSymmetricEngine] [symmetric-engine-startup-1] Done initializing SymmetricDS database
2019-01-03 17:16:08,222 INFO [zapaonline-001] [AbstractSymmetricEngine] [symmetric-engine-startup-1] SymmetricDS database version : null
2019-01-03 17:16:08,227 INFO [zapaonline-001] [AbstractSymmetricEngine] [symmetric-engine-startup-1] SymmetricDS software version : 3.9.16
2019-01-03 17:16:08,270 INFO [zapaonline-001] [AbstractSymmetricEngine] [symmetric-engine-startup-1] Starting unregistered node [group=zapaonline, externalId=001]
2019-01-03 17:16:08,312 INFO [zapaonline-001] [RouterJob] [symmetric-engine-startup-1] Starting Routing on periodic schedule: every 5000ms with the first run at Thu Jan 03 17:16:15 CET 2019
2019-01-03 17:16:08,322 INFO [zapaonline-001] [PushJob] [symmetric-engine-startup-1] Starting Push on periodic schedule: every 10000ms with the first run at Thu Jan 03 17:16:15 CET 2019
2019-01-03 17:16:08,327 INFO [zapaonline-001] [PullJob] [symmetric-engine-startup-1] Starting Pull on periodic schedule: every 10000ms with the first run at Thu Jan 03 17:16:15 CET 2019
2019-01-03 17:16:08,332 INFO [zapaonline-001] [JobManager] [symmetric-engine-startup-1] Job Offline Push not configured for auto start
2019-01-03 17:16:08,337 INFO [zapaonline-001] [JobManager] [symmetric-engine-startup-1] Job Offline Pull not configured for auto start
2019-01-03 17:16:08,343 INFO [zapaonline-001] [OutgoingPurgeJob] [symmetric-engine-startup-1] Starting job 'Purge Outgoing' with cron expression: '0 0 0 * * *'
2019-01-03 17:16:08,351 INFO [zapaonline-001] [IncomingPurgeJob] [symmetric-engine-startup-1] Starting job 'Purge Incoming' with cron expression: '0 0 0 * * *'
2019-01-03 17:16:08,361 INFO [zapaonline-001] [StatisticFlushJob] [symmetric-engine-startup-1] Starting job 'Stat Flush' with cron expression: '0 0/5 * * * *'
2019-01-03 17:16:08,365 INFO [zapaonline-001] [SyncTriggersJob] [symmetric-engine-startup-1] Starting job 'SyncTriggers' with cron expression: '0 0 0 * * *'
2019-01-03 17:16:08,368 INFO [zapaonline-001] [HeartbeatJob] [symmetric-engine-startup-1] Starting Heartbeat on periodic schedule: every 900000ms with the first run at Thu Jan 03 17:16:15 CET 2019
2019-01-03 17:16:08,373 INFO [zapaonline-001] [WatchdogJob] [symmetric-engine-startup-1] Starting Watchdog on periodic schedule: every 3600000ms with the first run at Thu Jan 03 17:16:15 CET 2019
2019-01-03 17:16:08,378 INFO [zapaonline-001] [StageManagementJob] [symmetric-engine-startup-1] Starting job 'Stage Management' with cron expression: '0 0 * * * *'
2019-01-03 17:16:08,382 INFO [zapaonline-001] [JobManager] [symmetric-engine-startup-1] Job Refresh Cache not configured for auto start
2019-01-03 17:16:08,384 INFO [zapaonline-001] [JobManager] [symmetric-engine-startup-1] Job File Sync Tracker not configured for auto start
2019-01-03 17:16:08,387 INFO [zapaonline-001] [JobManager] [symmetric-engine-startup-1] Job File Sync Pull not configured for auto start
2019-01-03 17:16:08,389 INFO [zapaonline-001] [JobManager] [symmetric-engine-startup-1] Job File Sync Push not configured for auto start
2019-01-03 17:16:08,391 INFO [zapaonline-001] [InitialLoadExtractorJob] [symmetric-engine-startup-1] Starting Initial Load Extract on periodic schedule: every 10000ms with the first run at Thu Jan 03 17:16:15 CET 2019
2019-01-03 17:16:08,399 INFO [zapaonline-001] [MonitorJob] [symmetric-engine-startup-1] Starting Monitor on periodic schedule: every 60000ms with the first run at Thu Jan 03 17:16:15 CET 2019
2019-01-03 17:16:08,403 INFO [zapaonline-001] [JobManager] [symmetric-engine-startup-1] Job Report Status not configured for auto start
2019-01-03 17:16:08,408 INFO [zapaonline-001] [ClusterService] [symmetric-engine-startup-1] This node picked a server id of LPZWPL000001098
2019-01-03 17:16:08,413 INFO [zapaonline-001] [AbstractSymmetricEngine] [symmetric-engine-startup-1] SymmetricDS Node STARTED:
nodeId=001
groupId=zapaonline
type=server
subType=null
name=zapaonline-001
softwareVersion=3.9.16
databaseName=PostgreSQL
databaseVersion=9.6
driverName=PostgreSQL JDBC Driver
driverVersion=42.2.1
uptime=0 sec.
2019-01-03 17:16:09,745 INFO [zol-000] [AbstractSymmetricEngine] [symmetric-engine-startup-2] Done initializing SymmetricDS database
2019-01-03 17:16:09,746 INFO [zol-000] [AbstractSymmetricEngine] [symmetric-engine-startup-2] SymmetricDS database version : null
2019-01-03 17:16:09,748 INFO [zol-000] [AbstractSymmetricEngine] [symmetric-engine-startup-2] SymmetricDS software version : 3.9.16
2019-01-03 17:16:09,777 INFO [zol-000] [AbstractSymmetricEngine] [symmetric-engine-startup-2] Starting registered node [group=zol, id=000, nodeId=000]
2019-01-03 17:16:09,780 INFO [zol-000] [ClusterService] [symmetric-engine-startup-2] This node picked a server id of LPZWPL000001098
2019-01-03 17:16:09,781 INFO [zol-000] [TriggerRouterService] [symmetric-engine-startup-2] Synchronizing triggers
2019-01-03 17:16:10,013 INFO [zol-000] [MsSqlSymmetricDialect] [zol-000-sync-triggers-1] Creating SYM_ON_I_FOR_SYM_RTR_ZL trigger for zol.dbo.sym_router
2019-01-03 17:16:10,053 INFO [zol-000] [MsSqlSymmetricDialect] [zol-000-sync-triggers-1] Creating SYM_ON_U_FOR_SYM_RTR_ZL trigger for zol.dbo.sym_router
2019-01-03 17:16:10,075 INFO [zol-000] [MsSqlSymmetricDialect] [zol-000-sync-triggers-1] Creating SYM_ON_D_FOR_SYM_RTR_ZL trigger for zol.dbo.sym_router
2019-01-03 17:16:10,225 INFO [zol-000] [MsSqlSymmetricDialect] [zol-000-sync-triggers-1] Creating SYM_ON_I_FOR_SYM_TRNSFRM_TBL_ZL trigger for zol.dbo.sym_transform_table
2019-01-03 17:16:10,241 INFO [zol-000] [MsSqlSymmetricDialect] [zol-000-sync-triggers-1] Creating SYM_ON_U_FOR_SYM_TRNSFRM_TBL_ZL trigger for zol.dbo.sym_transform_table
2019-01-03 17:16:10,259 INFO [zol-000] [MsSqlSymmetricDialect] [zol-000-sync-triggers-1] Creating SYM_ON_D_FOR_SYM_TRNSFRM_TBL_ZL trigger for zol.dbo.sym_transform_table
2019-01-03 17:16:10,317 INFO [zol-000] [MsSqlSymmetricDialect] [zol-000-sync-triggers-1] Creating SYM_ON_I_FOR_SYM_PRMTR_ZL trigger for zol.dbo.sym_parameter
2019-01-03 17:16:10,330 INFO [zol-000] [MsSqlSymmetricDialect] [zol-000-sync-triggers-1] Creating SYM_ON_U_FOR_SYM_PRMTR_ZL trigger for zol.dbo.sym_parameter
2019-01-03 17:16:10,345 INFO [zol-000] [MsSqlSymmetricDialect] [zol-000-sync-triggers-1] Creating SYM_ON_D_FOR_SYM_PRMTR_ZL trigger for zol.dbo.sym_parameter
2019-01-03 17:16:10,406 INFO [zol-000] [MsSqlSymmetricDialect] [zol-000-sync-triggers-1] Creating SYM_ON_I_FOR_SYM_FL_TRGGR_RTR_ZL trigger for zol.dbo.sym_file_trigger_router
2019-01-03 17:16:10,421 INFO [zol-000] [MsSqlSymmetricDialect] [zol-000-sync-triggers-1] Creating SYM_ON_U_FOR_SYM_FL_TRGGR_RTR_ZL trigger for zol.dbo.sym_file_trigger_router
2019-01-03 17:16:10,439 INFO [zol-000] [MsSqlSymmetricDialect] [zol-000-sync-triggers-1] Creating SYM_ON_D_FOR_SYM_FL_TRGGR_RTR_ZL trigger for zol.dbo.sym_file_trigger_router
2019-01-03 17:16:10,496 INFO [zol-000] [MsSqlSymmetricDialect] [zol-000-sync-triggers-1] Creating SYM_ON_I_FOR_SYM_TBL_RLD_RQST_ZL trigger for zol.dbo.sym_table_reload_request
2019-01-03 17:16:10,511 INFO [zol-000] [MsSqlSymmetricDialect] [zol-000-sync-triggers-1] Creating SYM_ON_U_FOR_SYM_TBL_RLD_RQST_ZL trigger for zol.dbo.sym_table_reload_request
2019-01-03 17:16:10,529 INFO [zol-000] [MsSqlSymmetricDialect] [zol-000-sync-triggers-1] Creating SYM_ON_D_FOR_SYM_TBL_RLD_RQST_ZL trigger for zol.dbo.sym_table_reload_request
2019-01-03 17:16:10,634 INFO [zol-000] [MsSqlSymmetricDialect] [zol-000-sync-triggers-1] Creating SYM_ON_I_FOR_SYM_GRPLT_LNK_ZL trigger for zol.dbo.sym_grouplet_link
2019-01-03 17:16:10,654 INFO [zol-000] [MsSqlSymmetricDialect] [zol-000-sync-triggers-1] Creating SYM_ON_U_FOR_SYM_GRPLT_LNK_ZL trigger for zol.dbo.sym_grouplet_link
2019-01-03 17:16:10,680 INFO [zol-000] [MsSqlSymmetricDialect] [zol-000-sync-triggers-1] Creating SYM_ON_D_FOR_SYM_GRPLT_LNK_ZL trigger for zol.dbo.sym_grouplet_link
2019-01-03 17:16:10,762 INFO [zol-000] [MsSqlSymmetricDialect] [zol-000-sync-triggers-1] Creating SYM_ON_I_FOR_SYM_GRPLT_ZL trigger for zol.dbo.sym_grouplet
2019-01-03 17:16:10,776 INFO [zol-000] [MsSqlSymmetricDialect] [zol-000-sync-triggers-1] Creating SYM_ON_U_FOR_SYM_GRPLT_ZL trigger for zol.dbo.sym_grouplet
2019-01-03 17:16:10,789 INFO [zol-000] [MsSqlSymmetricDialect] [zol-000-sync-triggers-1] Creating SYM_ON_D_FOR_SYM_GRPLT_ZL trigger for zol.dbo.sym_grouplet
2019-01-03 17:16:10,919 INFO [zol-000] [MsSqlSymmetricDialect] [zol-000-sync-triggers-1] Creating SYM_ON_I_FOR_SYM_FL_TRGGR_ZL trigger for zol.dbo.sym_file_trigger
2019-01-03 17:16:10,942 INFO [zol-000] [MsSqlSymmetricDialect] [zol-000-sync-triggers-1] Creating SYM_ON_U_FOR_SYM_FL_TRGGR_ZL trigger for zol.dbo.sym_file_trigger
2019-01-03 17:16:10,968 INFO [zol-000] [MsSqlSymmetricDialect] [zol-000-sync-triggers-1] Creating SYM_ON_D_FOR_SYM_FL_TRGGR_ZL trigger for zol.dbo.sym_file_trigger
2019-01-03 17:16:11,072 INFO [zol-000] [MsSqlSymmetricDialect] [zol-000-sync-triggers-1] Creating SYM_ON_I_FOR_SYM_TRNSFRM_CLMN_ZL trigger for zol.dbo.sym_transform_column
2019-01-03 17:16:11,088 INFO [zol-000] [MsSqlSymmetricDialect] [zol-000-sync-triggers-1] Creating SYM_ON_U_FOR_SYM_TRNSFRM_CLMN_ZL trigger for zol.dbo.sym_transform_column
2019-01-03 17:16:11,105 INFO [zol-000] [MsSqlSymmetricDialect] [zol-000-sync-triggers-1] Creating SYM_ON_D_FOR_SYM_TRNSFRM_CLMN_ZL trigger for zol.dbo.sym_transform_column
2019-01-03 17:16:11,159 INFO [zol-000] [MsSqlSymmetricDialect] [zol-000-sync-triggers-1] Creating SYM_ON_I_FOR_SYM_JB_ZL trigger for zol.dbo.sym_job
2019-01-03 17:16:11,171 INFO [zol-000] [MsSqlSymmetricDialect] [zol-000-sync-triggers-1] Creating SYM_ON_U_FOR_SYM_JB_ZL trigger for zol.dbo.sym_job
2019-01-03 17:16:11,184 INFO [zol-000] [MsSqlSymmetricDialect] [zol-000-sync-triggers-1] Creating SYM_ON_D_FOR_SYM_JB_ZL trigger for zol.dbo.sym_job
2019-01-03 17:16:11,246 INFO [zol-000] [MsSqlSymmetricDialect] [zol-000-sync-triggers-1] Creating SYM_ON_I_FOR_SYM_TRGGR_RTR_ZL trigger for zol.dbo.sym_trigger_router
2019-01-03 17:16:11,271 INFO [zol-000] [MsSqlSymmetricDialect] [zol-000-sync-triggers-1] Creating SYM_ON_U_FOR_SYM_TRGGR_RTR_ZL trigger for zol.dbo.sym_trigger_router
2019-01-03 17:16:11,293 INFO [zol-000] [MsSqlSymmetricDialect] [zol-000-sync-triggers-1] Creating SYM_ON_D_FOR_SYM_TRGGR_RTR_ZL trigger for zol.dbo.sym_trigger_router
2019-01-03 17:16:11,348 INFO [zol-000] [MsSqlSymmetricDialect] [zol-000-sync-triggers-1] Creating SYM_ON_I_FOR_SYM_ND_ZL trigger for zol.dbo.sym_node
2019-01-03 17:16:11,378 INFO [zol-000] [MsSqlSymmetricDialect] [zol-000-sync-triggers-1] Creating SYM_ON_U_FOR_SYM_ND_ZL trigger for zol.dbo.sym_node
2019-01-03 17:16:11,406 INFO [zol-000] [MsSqlSymmetricDialect] [zol-000-sync-triggers-1] Creating SYM_ON_D_FOR_SYM_ND_ZL trigger for zol.dbo.sym_node
2019-01-03 17:16:11,505 INFO [zol-000] [MsSqlSymmetricDialect] [zol-000-sync-triggers-1] Creating SYM_ON_I_FOR_VT_RT_ZL trigger for zol.dbo.vat_rate
2019-01-03 17:16:11,526 INFO [zol-000] [MsSqlSymmetricDialect] [zol-000-sync-triggers-1] Creating SYM_ON_U_FOR_VT_RT_ZL trigger for zol.dbo.vat_rate
2019-01-03 17:16:11,541 INFO [zol-000] [MsSqlSymmetricDialect] [zol-000-sync-triggers-1] Creating SYM_ON_D_FOR_VT_RT_ZL trigger for zol.dbo.vat_rate
2019-01-03 17:16:11,604 INFO [zol-000] [MsSqlSymmetricDialect] [zol-000-sync-triggers-1] Creating SYM_ON_I_FOR_SYM_ND_GRP_CHNNL_WND_ZL trigger for zol.dbo.sym_node_group_channel_wnd
2019-01-03 17:16:11,621 INFO [zol-000] [MsSqlSymmetricDialect] [zol-000-sync-triggers-1] Creating SYM_ON_U_FOR_SYM_ND_GRP_CHNNL_WND_ZL trigger for zol.dbo.sym_node_group_channel_wnd
2019-01-03 17:16:11,642 INFO [zol-000] [MsSqlSymmetricDialect] [zol-000-sync-triggers-1] Creating SYM_ON_D_FOR_SYM_ND_GRP_CHNNL_WND_ZL trigger for zol.dbo.sym_node_group_channel_wnd
2019-01-03 17:16:11,707 INFO [zol-000] [MsSqlSymmetricDialect] [zol-000-sync-triggers-1] Creating SYM_ON_I_FOR_SYM_NTFCTN_ZL trigger for zol.dbo.sym_notification
2019-01-03 17:16:11,720 INFO [zol-000] [MsSqlSymmetricDialect] [zol-000-sync-triggers-1] Creating SYM_ON_U_FOR_SYM_NTFCTN_ZL trigger for zol.dbo.sym_notification
2019-01-03 17:16:11,741 INFO [zol-000] [MsSqlSymmetricDialect] [zol-000-sync-triggers-1] Creating SYM_ON_D_FOR_SYM_NTFCTN_ZL trigger for zol.dbo.sym_notification
2019-01-03 17:16:11,801 INFO [zol-000] [MsSqlSymmetricDialect] [zol-000-sync-triggers-1] Creating SYM_ON_I_FOR_SYM_ND_GRP_LNK_ZL trigger for zol.dbo.sym_node_group_link
2019-01-03 17:16:11,813 INFO [zol-000] [MsSqlSymmetricDialect] [zol-000-sync-triggers-1] Creating SYM_ON_U_FOR_SYM_ND_GRP_LNK_ZL trigger for zol.dbo.sym_node_group_link
2019-01-03 17:16:11,825 INFO [zol-000] [MsSqlSymmetricDialect] [zol-000-sync-triggers-1] Creating SYM_ON_D_FOR_SYM_ND_GRP_LNK_ZL trigger for zol.dbo.sym_node_group_link
2019-01-03 17:16:11,926 INFO [zol-000] [MsSqlSymmetricDialect] [zol-000-sync-triggers-1] Creating SYM_ON_I_FOR_SYM_ND_GRP_ZL trigger for zol.dbo.sym_node_group
2019-01-03 17:16:11,941 INFO [zol-000] [MsSqlSymmetricDialect] [zol-000-sync-triggers-1] Creating SYM_ON_U_FOR_SYM_ND_GRP_ZL trigger for zol.dbo.sym_node_group
2019-01-03 17:16:11,956 INFO [zol-000] [MsSqlSymmetricDialect] [zol-000-sync-triggers-1] Creating SYM_ON_D_FOR_SYM_ND_GRP_ZL trigger for zol.dbo.sym_node_group
2019-01-03 17:16:12,038 INFO [zol-000] [MsSqlSymmetricDialect] [zol-000-sync-triggers-1] Creating SYM_ON_I_FOR_SYM_ND_SCRTY_ZL trigger for zol.dbo.sym_node_security
2019-01-03 17:16:12,051 INFO [zol-000] [MsSqlSymmetricDialect] [zol-000-sync-triggers-1] Creating SYM_ON_U_FOR_SYM_ND_SCRTY_ZL trigger for zol.dbo.sym_node_security
2019-01-03 17:16:12,066 INFO [zol-000] [MsSqlSymmetricDialect] [zol-000-sync-triggers-1] Creating SYM_ON_D_FOR_SYM_ND_SCRTY_ZL trigger for zol.dbo.sym_node_security
2019-01-03 17:16:12,129 INFO [zol-000] [MsSqlSymmetricDialect] [zol-000-sync-triggers-1] Creating SYM_ON_I_FOR_SYM_LD_FLTR_ZL trigger for zol.dbo.sym_load_filter
2019-01-03 17:16:12,151 INFO [zol-000] [MsSqlSymmetricDialect] [zol-000-sync-triggers-1] Creating SYM_ON_U_FOR_SYM_LD_FLTR_ZL trigger for zol.dbo.sym_load_filter
2019-01-03 17:16:12,172 INFO [zol-000] [MsSqlSymmetricDialect] [zol-000-sync-triggers-1] Creating SYM_ON_D_FOR_SYM_LD_FLTR_ZL trigger for zol.dbo.sym_load_filter
2019-01-03 17:16:12,227 INFO [zol-000] [MsSqlSymmetricDialect] [zol-000-sync-triggers-1] Creating SYM_ON_I_FOR_SYM_MNTR_ZL trigger for zol.dbo.sym_monitor
2019-01-03 17:16:12,242 INFO [zol-000] [MsSqlSymmetricDialect] [zol-000-sync-triggers-1] Creating SYM_ON_U_FOR_SYM_MNTR_ZL trigger for zol.dbo.sym_monitor
2019-01-03 17:16:12,256 INFO [zol-000] [MsSqlSymmetricDialect] [zol-000-sync-triggers-1] Creating SYM_ON_D_FOR_SYM_MNTR_ZL trigger for zol.dbo.sym_monitor
2019-01-03 17:16:12,507 INFO [zol-000] [MsSqlSymmetricDialect] [zol-000-sync-triggers-1] Creating SYM_ON_I_FOR_SYM_XTNSN_ZL trigger for zol.dbo.sym_extension
2019-01-03 17:16:12,522 INFO [zol-000] [MsSqlSymmetricDialect] [zol-000-sync-triggers-1] Creating SYM_ON_U_FOR_SYM_XTNSN_ZL trigger for zol.dbo.sym_extension
2019-01-03 17:16:12,561 INFO [zol-000] [MsSqlSymmetricDialect] [zol-000-sync-triggers-1] Creating SYM_ON_D_FOR_SYM_XTNSN_ZL trigger for zol.dbo.sym_extension
2019-01-03 17:16:12,626 INFO [zol-000] [MsSqlSymmetricDialect] [zol-000-sync-triggers-1] Creating SYM_ON_I_FOR_SYM_CNFLCT_ZL trigger for zol.dbo.sym_conflict
2019-01-03 17:16:12,640 INFO [zol-000] [MsSqlSymmetricDialect] [zol-000-sync-triggers-1] Creating SYM_ON_U_FOR_SYM_CNFLCT_ZL trigger for zol.dbo.sym_conflict
2019-01-03 17:16:12,655 INFO [zol-000] [MsSqlSymmetricDialect] [zol-000-sync-triggers-1] Creating SYM_ON_D_FOR_SYM_CNFLCT_ZL trigger for zol.dbo.sym_conflict
2019-01-03 17:16:12,750 INFO [zol-000] [MsSqlSymmetricDialect] [zol-000-sync-triggers-1] Creating SYM_ON_I_FOR_SYM_TRGGR_ZL trigger for zol.dbo.sym_trigger
2019-01-03 17:16:12,768 INFO [zol-000] [MsSqlSymmetricDialect] [zol-000-sync-triggers-1] Creating SYM_ON_U_FOR_SYM_TRGGR_ZL trigger for zol.dbo.sym_trigger
2019-01-03 17:16:12,794 INFO [zol-000] [MsSqlSymmetricDialect] [zol-000-sync-triggers-1] Creating SYM_ON_D_FOR_SYM_TRGGR_ZL trigger for zol.dbo.sym_trigger
2019-01-03 17:16:12,907 INFO [zol-000] [MsSqlSymmetricDialect] [zol-000-sync-triggers-1] Creating SYM_ON_I_FOR_SYM_CHNNL_ZL trigger for zol.dbo.sym_channel
2019-01-03 17:16:12,933 INFO [zol-000] [MsSqlSymmetricDialect] [zol-000-sync-triggers-1] Creating SYM_ON_U_FOR_SYM_CHNNL_ZL trigger for zol.dbo.sym_channel
2019-01-03 17:16:12,969 INFO [zol-000] [MsSqlSymmetricDialect] [zol-000-sync-triggers-1] Creating SYM_ON_D_FOR_SYM_CHNNL_ZL trigger for zol.dbo.sym_channel
2019-01-03 17:16:13,132 INFO [zol-000] [MsSqlSymmetricDialect] [zol-000-sync-triggers-1] Creating SYM_ON_I_FOR_SYM_TRGGR_RTR_GRPLT_ZL trigger for zol.dbo.sym_trigger_router_grouplet
2019-01-03 17:16:13,169 INFO [zol-000] [MsSqlSymmetricDialect] [zol-000-sync-triggers-1] Creating SYM_ON_U_FOR_SYM_TRGGR_RTR_GRPLT_ZL trigger for zol.dbo.sym_trigger_router_grouplet
2019-01-03 17:16:13,194 INFO [zol-000] [MsSqlSymmetricDialect] [zol-000-sync-triggers-1] Creating SYM_ON_D_FOR_SYM_TRGGR_RTR_GRPLT_ZL trigger for zol.dbo.sym_trigger_router_grouplet
2019-01-03 17:16:13,264 INFO [zol-000] [MsSqlSymmetricDialect] [zol-000-sync-triggers-1] Creating SYM_ON_I_FOR_SYM_ND_HST_ZL trigger for zol.dbo.sym_node_host
2019-01-03 17:16:13,283 INFO [zol-000] [MsSqlSymmetricDialect] [zol-000-sync-triggers-1] Creating SYM_ON_U_FOR_SYM_ND_HST_ZL trigger for zol.dbo.sym_node_host
2019-01-03 17:16:13,297 INFO [zol-000] [MsSqlSymmetricDialect] [zol-000-sync-triggers-1] Creating SYM_ON_D_FOR_SYM_ND_HST_ZL trigger for zol.dbo.sym_node_host
2019-01-03 17:16:13,310 INFO [zol-000] [TriggerRouterService] [symmetric-engine-startup-2] Done synchronizing triggers
2019-01-03 17:16:13,311 INFO [zol-000] [PushHeartbeatListener] [symmetric-engine-startup-2] Some attribute(s) of node changed. Recording changes
2019-01-03 17:16:13,312 INFO [zol-000] [PushHeartbeatListener] [symmetric-engine-startup-2] Updating my node configuration info according to the symmetric properties
2019-01-03 17:16:13,781 INFO [zol-000] [RouterJob] [symmetric-engine-startup-2] Starting Routing on periodic schedule: every 5000ms with the first run at Thu Jan 03 17:16:23 CET 2019
2019-01-03 17:16:13,784 INFO [zol-000] [PushJob] [symmetric-engine-startup-2] Starting Push on periodic schedule: every 10000ms with the first run at Thu Jan 03 17:16:23 CET 2019
2019-01-03 17:16:13,788 INFO [zol-000] [PullJob] [symmetric-engine-startup-2] Starting Pull on periodic schedule: every 10000ms with the first run at Thu Jan 03 17:16:23 CET 2019
2019-01-03 17:16:13,792 INFO [zol-000] [JobManager] [symmetric-engine-startup-2] Job Offline Push not configured for auto start
2019-01-03 17:16:13,792 INFO [zol-000] [JobManager] [symmetric-engine-startup-2] Job Offline Pull not configured for auto start
2019-01-03 17:16:13,795 INFO [zol-000] [OutgoingPurgeJob] [symmetric-engine-startup-2] Starting job 'Purge Outgoing' with cron expression: '0 0 0 * * *'
2019-01-03 17:16:13,798 INFO [zol-000] [IncomingPurgeJob] [symmetric-engine-startup-2] Starting job 'Purge Incoming' with cron expression: '0 0 0 * * *'
2019-01-03 17:16:13,800 INFO [zol-000] [StatisticFlushJob] [symmetric-engine-startup-2] Starting job 'Stat Flush' with cron expression: '0 0/5 * * * *'
2019-01-03 17:16:13,803 INFO [zol-000] [SyncTriggersJob] [symmetric-engine-startup-2] Starting job 'SyncTriggers' with cron expression: '0 0 0 * * *'
2019-01-03 17:16:13,806 INFO [zol-000] [HeartbeatJob] [symmetric-engine-startup-2] Starting Heartbeat on periodic schedule: every 900000ms with the first run at Thu Jan 03 17:16:23 CET 2019
2019-01-03 17:16:13,809 INFO [zol-000] [WatchdogJob] [symmetric-engine-startup-2] Starting Watchdog on periodic schedule: every 3600000ms with the first run at Thu Jan 03 17:16:23 CET 2019
2019-01-03 17:16:13,813 INFO [zol-000] [StageManagementJob] [symmetric-engine-startup-2] Starting job 'Stage Management' with cron expression: '0 0 * * * *'
2019-01-03 17:16:13,815 INFO [zol-000] [JobManager] [symmetric-engine-startup-2] Job Refresh Cache not configured for auto start
2019-01-03 17:16:13,817 INFO [zol-000] [JobManager] [symmetric-engine-startup-2] Job File Sync Tracker not configured for auto start
2019-01-03 17:16:13,818 INFO [zol-000] [JobManager] [symmetric-engine-startup-2] Job File Sync Pull not configured for auto start
2019-01-03 17:16:13,819 INFO [zol-000] [JobManager] [symmetric-engine-startup-2] Job File Sync Push not configured for auto start
2019-01-03 17:16:13,820 INFO [zol-000] [InitialLoadExtractorJob] [symmetric-engine-startup-2] Starting Initial Load Extract on periodic schedule: every 10000ms with the first run at Thu Jan 03 17:16:23 CET 2019
2019-01-03 17:16:13,823 INFO [zol-000] [MonitorJob] [symmetric-engine-startup-2] Starting Monitor on periodic schedule: every 60000ms with the first run at Thu Jan 03 17:16:23 CET 2019
2019-01-03 17:16:13,825 INFO [zol-000] [JobManager] [symmetric-engine-startup-2] Job Report Status not configured for auto start
2019-01-03 17:16:13,828 INFO [zol-000] [AbstractSymmetricEngine] [symmetric-engine-startup-2] SymmetricDS Node STARTED:
nodeId=000
groupId=zol
type=server
subType=null
name=zol-000
softwareVersion=3.9.16
databaseName=Microsoft SQL Server
databaseVersion=14.0
driverName=jTDS Type 4 JDBC Driver for MS SQL Server and Sybase
driverVersion=1.2.8
uptime=0 sec.
2019-01-03 17:16:15,680 INFO [zapaonline-001] [RouterJob] [zapaonline-001-job-1] Did not run the 'Routing' job because the engine is not registered.
2019-01-03 17:16:15,690 INFO [zapaonline-001] [PushJob] [zapaonline-001-job-2] Did not run the 'Push' job because the engine is not registered.
2019-01-03 17:16:15,708 INFO [zapaonline-001] [RegistrationService] [zapaonline-001-job-3] This node is unregistered. It will attempt to register using the registration.url
2019-01-03 17:16:15,759 INFO [zapaonline-001] [InitialLoadExtractorJob] [zapaonline-001-job-6] Did not run the 'Initial Load Extract' job because the engine is not registered.
2019-01-03 17:16:15,767 INFO [zapaonline-001] [MonitorJob] [zapaonline-001-job-17] Did not run the 'Monitor' job because the engine is not registered.
2019-01-03 17:16:16,103 INFO [zapaonline-001] [DataLoaderService] [zapaonline-001-job-3] Using registration URL of http://localhost:31415/sync/zol-000/registration?nodeGroupId=zapaonline&externalId=001&syncURL=http%3A%2F%2FLPZWPL000001098%3A31415%2Fsync%2Fzapaonline-001&schemaVersion=%3F&databaseType=PostgreSQL&databaseVersion=9.6&symmetricVersion=3.9.16&deploymentType=server&hostName=LPZWPL000001098&ipAddress=10.100.199.1
2019-01-03 17:16:16,235 INFO [zol-000] [RegistrationService] [qtp973576304-16] Completed registration of node zapaonline:001:001
2019-01-03 17:16:16,241 INFO [zol-000] [MsSqlSymmetricDialect] [qtp973576304-16] This database DOES support disabling triggers during a symmetricds data load
2019-01-03 17:16:18,887 INFO [zapaonline-001] [ConfigurationChangedDatabaseWriterFilter] [zapaonline-001-dataloader-1] Grouplets flushed because new grouplet config came through the data loader
2019-01-03 17:16:18,888 INFO [zapaonline-001] [ConfigurationChangedDatabaseWriterFilter] [zapaonline-001-dataloader-1] Load filters flushed because new filter config came through the data loader
2019-01-03 17:16:18,891 INFO [zapaonline-001] [ConfigurationChangedDatabaseWriterFilter] [zapaonline-001-dataloader-1] Channels flushed because new channels came through the data loader
2019-01-03 17:16:18,893 INFO [zapaonline-001] [ConfigurationChangedDatabaseWriterFilter] [zapaonline-001-dataloader-1] About to refresh the cache of conflict settings because new configuration came through the data loader
2019-01-03 17:16:18,896 INFO [zapaonline-001] [ConfigurationChangedDatabaseWriterFilter] [zapaonline-001-dataloader-1] About to refresh the cache of parameters because new configuration came through the data loader
2019-01-03 17:16:18,917 INFO [zapaonline-001] [ConfigurationChangedDatabaseWriterFilter] [zapaonline-001-dataloader-1] About to refresh the cache of node security because new configuration came through the data loader
2019-01-03 17:16:18,921 INFO [zapaonline-001] [ConfigurationChangedDatabaseWriterFilter] [zapaonline-001-job-3] About to refresh the cache of transformation because new configuration came through the data loader
2019-01-03 17:16:18,922 INFO [zapaonline-001] [ConfigurationChangedDatabaseWriterFilter] [zapaonline-001-job-3] About to clear the staging area because new transform configuration came through the data loader
2019-01-03 17:16:18,927 INFO [zapaonline-001] [StagingManager] [zapaonline-001-job-3] Cleaning staging...
2019-01-03 17:16:19,933 INFO [zapaonline-001] [StagingManager] [zapaonline-001-job-3] Purged 740 staging files, freed 11 GB of disk space.
2019-01-03 17:16:19,934 INFO [zapaonline-001] [StagingManager] [zapaonline-001-job-3] Finished cleaning staging in 1 second.
2019-01-03 17:16:19,936 INFO [zapaonline-001] [ConfigurationChangedDatabaseWriterFilter] [zapaonline-001-job-3] About to syncTriggers because new configuration came through the data loader
2019-01-03 17:16:19,938 INFO [zapaonline-001] [TriggerRouterService] [zapaonline-001-job-3] Synchronizing triggers
2019-01-03 17:16:20,022 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [zapaonline-001-sync-triggers-1] Creating SYM_ON_I_FOR_SYM_RTR_ZPNLN trigger for public.sym_router
2019-01-03 17:16:20,071 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [zapaonline-001-sync-triggers-1] Creating SYM_ON_U_FOR_SYM_RTR_ZPNLN trigger for public.sym_router
2019-01-03 17:16:20,079 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [zapaonline-001-sync-triggers-1] Creating SYM_ON_D_FOR_SYM_RTR_ZPNLN trigger for public.sym_router
2019-01-03 17:16:20,133 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [zapaonline-001-sync-triggers-1] Creating SYM_ON_I_FOR_SYM_TRNSFRM_TBL_ZPNLN trigger for public.sym_transform_table
2019-01-03 17:16:20,142 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [zapaonline-001-sync-triggers-1] Creating SYM_ON_U_FOR_SYM_TRNSFRM_TBL_ZPNLN trigger for public.sym_transform_table
2019-01-03 17:16:20,150 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [zapaonline-001-sync-triggers-1] Creating SYM_ON_D_FOR_SYM_TRNSFRM_TBL_ZPNLN trigger for public.sym_transform_table
2019-01-03 17:16:20,182 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [zapaonline-001-sync-triggers-1] Creating SYM_ON_I_FOR_SYM_PRMTR_ZPNLN trigger for public.sym_parameter
2019-01-03 17:16:20,193 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [zapaonline-001-sync-triggers-1] Creating SYM_ON_U_FOR_SYM_PRMTR_ZPNLN trigger for public.sym_parameter
2019-01-03 17:16:20,204 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [zapaonline-001-sync-triggers-1] Creating SYM_ON_D_FOR_SYM_PRMTR_ZPNLN trigger for public.sym_parameter
2019-01-03 17:16:20,249 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [zapaonline-001-sync-triggers-1] Creating SYM_ON_I_FOR_SYM_FL_TRGGR_RTR_ZPNLN trigger for public.sym_file_trigger_router
2019-01-03 17:16:20,259 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [zapaonline-001-sync-triggers-1] Creating SYM_ON_U_FOR_SYM_FL_TRGGR_RTR_ZPNLN trigger for public.sym_file_trigger_router
2019-01-03 17:16:20,267 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [zapaonline-001-sync-triggers-1] Creating SYM_ON_D_FOR_SYM_FL_TRGGR_RTR_ZPNLN trigger for public.sym_file_trigger_router
2019-01-03 17:16:20,318 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [zapaonline-001-sync-triggers-1] Creating SYM_ON_I_FOR_SYM_TBL_RLD_RQST_ZPNLN trigger for public.sym_table_reload_request
2019-01-03 17:16:20,331 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [zapaonline-001-sync-triggers-1] Creating SYM_ON_U_FOR_SYM_TBL_RLD_RQST_ZPNLN trigger for public.sym_table_reload_request
2019-01-03 17:16:20,342 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [zapaonline-001-sync-triggers-1] Creating SYM_ON_D_FOR_SYM_TBL_RLD_RQST_ZPNLN trigger for public.sym_table_reload_request
2019-01-03 17:16:20,426 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [zapaonline-001-sync-triggers-1] Creating SYM_ON_I_FOR_SYM_GRPLT_LNK_ZPNLN trigger for public.sym_grouplet_link
2019-01-03 17:16:20,433 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [zapaonline-001-sync-triggers-1] Creating SYM_ON_U_FOR_SYM_GRPLT_LNK_ZPNLN trigger for public.sym_grouplet_link
2019-01-03 17:16:20,441 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [zapaonline-001-sync-triggers-1] Creating SYM_ON_D_FOR_SYM_GRPLT_LNK_ZPNLN trigger for public.sym_grouplet_link
2019-01-03 17:16:20,484 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [zapaonline-001-sync-triggers-1] Creating SYM_ON_I_FOR_SYM_GRPLT_ZPNLN trigger for public.sym_grouplet
2019-01-03 17:16:20,494 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [zapaonline-001-sync-triggers-1] Creating SYM_ON_U_FOR_SYM_GRPLT_ZPNLN trigger for public.sym_grouplet
2019-01-03 17:16:20,502 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [zapaonline-001-sync-triggers-1] Creating SYM_ON_D_FOR_SYM_GRPLT_ZPNLN trigger for public.sym_grouplet
2019-01-03 17:16:20,557 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [zapaonline-001-sync-triggers-1] Creating SYM_ON_I_FOR_SYM_FL_TRGGR_ZPNLN trigger for public.sym_file_trigger
2019-01-03 17:16:20,566 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [zapaonline-001-sync-triggers-1] Creating SYM_ON_U_FOR_SYM_FL_TRGGR_ZPNLN trigger for public.sym_file_trigger
2019-01-03 17:16:20,574 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [zapaonline-001-sync-triggers-1] Creating SYM_ON_D_FOR_SYM_FL_TRGGR_ZPNLN trigger for public.sym_file_trigger
2019-01-03 17:16:20,604 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [zapaonline-001-sync-triggers-1] Creating SYM_ON_I_FOR_SYM_TRNSFRM_CLMN_ZPNLN trigger for public.sym_transform_column
2019-01-03 17:16:20,612 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [zapaonline-001-sync-triggers-1] Creating SYM_ON_U_FOR_SYM_TRNSFRM_CLMN_ZPNLN trigger for public.sym_transform_column
2019-01-03 17:16:20,619 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [zapaonline-001-sync-triggers-1] Creating SYM_ON_D_FOR_SYM_TRNSFRM_CLMN_ZPNLN trigger for public.sym_transform_column
2019-01-03 17:16:20,649 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [zapaonline-001-sync-triggers-1] Creating SYM_ON_I_FOR_SYM_JB_ZPNLN trigger for public.sym_job
2019-01-03 17:16:20,655 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [zapaonline-001-sync-triggers-1] Creating SYM_ON_U_FOR_SYM_JB_ZPNLN trigger for public.sym_job
2019-01-03 17:16:20,661 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [zapaonline-001-sync-triggers-1] Creating SYM_ON_D_FOR_SYM_JB_ZPNLN trigger for public.sym_job
2019-01-03 17:16:20,688 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [zapaonline-001-sync-triggers-1] Creating SYM_ON_I_FOR_SYM_TRGGR_RTR_ZPNLN trigger for public.sym_trigger_router
2019-01-03 17:16:20,699 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [zapaonline-001-sync-triggers-1] Creating SYM_ON_U_FOR_SYM_TRGGR_RTR_ZPNLN trigger for public.sym_trigger_router
2019-01-03 17:16:20,702 INFO [zapaonline-001] [DataService] [zapaonline-001-job-7] Inserting missing last data gap: { startId: 1, endId: 50000001, createTime: "Thu Jan 03 17:16:20 CET 2019" }
2019-01-03 17:16:20,711 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [zapaonline-001-sync-triggers-1] Creating SYM_ON_D_FOR_SYM_TRGGR_RTR_ZPNLN trigger for public.sym_trigger_router
2019-01-03 17:16:20,735 INFO [zapaonline-001] [DataGapFastDetector] [zapaonline-001-job-7] Full gap analysis is running
2019-01-03 17:16:20,740 INFO [zapaonline-001] [DataGapFastDetector] [zapaonline-001-job-7] Querying data in gaps from database took 4 ms
2019-01-03 17:16:20,742 INFO [zapaonline-001] [DataGapFastDetector] [zapaonline-001-job-7] Full gap analysis is done after 6 ms
2019-01-03 17:16:20,767 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [zapaonline-001-sync-triggers-1] Creating SYM_ON_I_FOR_SYM_ND_ZPNLN trigger for public.sym_node
2019-01-03 17:16:20,785 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [zapaonline-001-sync-triggers-1] Creating SYM_ON_U_FOR_SYM_ND_ZPNLN trigger for public.sym_node
2019-01-03 17:16:20,793 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [zapaonline-001-sync-triggers-1] Creating SYM_ON_D_FOR_SYM_ND_ZPNLN trigger for public.sym_node
2019-01-03 17:16:20,826 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [zapaonline-001-sync-triggers-1] Creating SYM_ON_I_FOR_SYM_ND_GRP_CHNNL_WND_ZPNLN trigger for public.sym_node_group_channel_wnd
2019-01-03 17:16:20,834 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [zapaonline-001-sync-triggers-1] Creating SYM_ON_U_FOR_SYM_ND_GRP_CHNNL_WND_ZPNLN trigger for public.sym_node_group_channel_wnd
2019-01-03 17:16:20,841 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [zapaonline-001-sync-triggers-1] Creating SYM_ON_D_FOR_SYM_ND_GRP_CHNNL_WND_ZPNLN trigger for public.sym_node_group_channel_wnd
2019-01-03 17:16:20,870 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [zapaonline-001-sync-triggers-1] Creating SYM_ON_I_FOR_SYM_NTFCTN_ZPNLN trigger for public.sym_notification
2019-01-03 17:16:20,877 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [zapaonline-001-sync-triggers-1] Creating SYM_ON_U_FOR_SYM_NTFCTN_ZPNLN trigger for public.sym_notification
2019-01-03 17:16:20,886 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [zapaonline-001-sync-triggers-1] Creating SYM_ON_D_FOR_SYM_NTFCTN_ZPNLN trigger for public.sym_notification
2019-01-03 17:16:20,921 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [zapaonline-001-sync-triggers-1] Creating SYM_ON_I_FOR_SYM_ND_GRP_LNK_ZPNLN trigger for public.sym_node_group_link
2019-01-03 17:16:20,927 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [zapaonline-001-sync-triggers-1] Creating SYM_ON_U_FOR_SYM_ND_GRP_LNK_ZPNLN trigger for public.sym_node_group_link
2019-01-03 17:16:20,935 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [zapaonline-001-sync-triggers-1] Creating SYM_ON_D_FOR_SYM_ND_GRP_LNK_ZPNLN trigger for public.sym_node_group_link
2019-01-03 17:16:20,975 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [zapaonline-001-sync-triggers-1] Creating SYM_ON_I_FOR_SYM_ND_GRP_ZPNLN trigger for public.sym_node_group
2019-01-03 17:16:20,981 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [zapaonline-001-sync-triggers-1] Creating SYM_ON_U_FOR_SYM_ND_GRP_ZPNLN trigger for public.sym_node_group
2019-01-03 17:16:20,988 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [zapaonline-001-sync-triggers-1] Creating SYM_ON_D_FOR_SYM_ND_GRP_ZPNLN trigger for public.sym_node_group
2019-01-03 17:16:21,025 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [zapaonline-001-sync-triggers-1] Creating SYM_ON_I_FOR_SYM_ND_SCRTY_ZPNLN trigger for public.sym_node_security
2019-01-03 17:16:21,032 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [zapaonline-001-sync-triggers-1] Creating SYM_ON_U_FOR_SYM_ND_SCRTY_ZPNLN trigger for public.sym_node_security
2019-01-03 17:16:21,040 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [zapaonline-001-sync-triggers-1] Creating SYM_ON_D_FOR_SYM_ND_SCRTY_ZPNLN trigger for public.sym_node_security
2019-01-03 17:16:21,072 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [zapaonline-001-sync-triggers-1] Creating SYM_ON_I_FOR_SYM_LD_FLTR_ZPNLN trigger for public.sym_load_filter
2019-01-03 17:16:21,082 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [zapaonline-001-sync-triggers-1] Creating SYM_ON_U_FOR_SYM_LD_FLTR_ZPNLN trigger for public.sym_load_filter
2019-01-03 17:16:21,090 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [zapaonline-001-sync-triggers-1] Creating SYM_ON_D_FOR_SYM_LD_FLTR_ZPNLN trigger for public.sym_load_filter
2019-01-03 17:16:21,120 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [zapaonline-001-sync-triggers-1] Creating SYM_ON_I_FOR_SYM_MNTR_ZPNLN trigger for public.sym_monitor
2019-01-03 17:16:21,125 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [zapaonline-001-sync-triggers-1] Creating SYM_ON_U_FOR_SYM_MNTR_ZPNLN trigger for public.sym_monitor
2019-01-03 17:16:21,132 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [zapaonline-001-sync-triggers-1] Creating SYM_ON_D_FOR_SYM_MNTR_ZPNLN trigger for public.sym_monitor
2019-01-03 17:16:21,160 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [zapaonline-001-sync-triggers-1] Creating SYM_ON_I_FOR_SYM_XTNSN_ZPNLN trigger for public.sym_extension
2019-01-03 17:16:21,170 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [zapaonline-001-sync-triggers-1] Creating SYM_ON_U_FOR_SYM_XTNSN_ZPNLN trigger for public.sym_extension
2019-01-03 17:16:21,183 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [zapaonline-001-sync-triggers-1] Creating SYM_ON_D_FOR_SYM_XTNSN_ZPNLN trigger for public.sym_extension
2019-01-03 17:16:21,220 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [zapaonline-001-sync-triggers-1] Creating SYM_ON_I_FOR_SYM_CNFLCT_ZPNLN trigger for public.sym_conflict
2019-01-03 17:16:21,227 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [zapaonline-001-sync-triggers-1] Creating SYM_ON_U_FOR_SYM_CNFLCT_ZPNLN trigger for public.sym_conflict
2019-01-03 17:16:21,235 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [zapaonline-001-sync-triggers-1] Creating SYM_ON_D_FOR_SYM_CNFLCT_ZPNLN trigger for public.sym_conflict
2019-01-03 17:16:21,264 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [zapaonline-001-sync-triggers-1] Creating SYM_ON_I_FOR_SYM_TRGGR_ZPNLN trigger for public.sym_trigger
2019-01-03 17:16:21,274 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [zapaonline-001-sync-triggers-1] Creating SYM_ON_U_FOR_SYM_TRGGR_ZPNLN trigger for public.sym_trigger
2019-01-03 17:16:21,285 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [zapaonline-001-sync-triggers-1] Creating SYM_ON_D_FOR_SYM_TRGGR_ZPNLN trigger for public.sym_trigger
2019-01-03 17:16:21,316 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [zapaonline-001-sync-triggers-1] Creating SYM_ON_I_FOR_SYM_CHNNL_ZPNLN trigger for public.sym_channel
2019-01-03 17:16:21,323 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [zapaonline-001-sync-triggers-1] Creating SYM_ON_U_FOR_SYM_CHNNL_ZPNLN trigger for public.sym_channel
2019-01-03 17:16:21,332 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [zapaonline-001-sync-triggers-1] Creating SYM_ON_D_FOR_SYM_CHNNL_ZPNLN trigger for public.sym_channel
2019-01-03 17:16:21,362 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [zapaonline-001-sync-triggers-1] Creating SYM_ON_I_FOR_SYM_TRGGR_RTR_GRPLT_ZPNLN trigger for public.sym_trigger_router_grouplet
2019-01-03 17:16:21,369 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [zapaonline-001-sync-triggers-1] Creating SYM_ON_U_FOR_SYM_TRGGR_RTR_GRPLT_ZPNLN trigger for public.sym_trigger_router_grouplet
2019-01-03 17:16:21,377 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [zapaonline-001-sync-triggers-1] Creating SYM_ON_D_FOR_SYM_TRGGR_RTR_GRPLT_ZPNLN trigger for public.sym_trigger_router_grouplet
2019-01-03 17:16:21,406 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [zapaonline-001-sync-triggers-1] Creating SYM_ON_I_FOR_SYM_ND_HST_ZPNLN trigger for public.sym_node_host
2019-01-03 17:16:21,413 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [zapaonline-001-sync-triggers-1] Creating SYM_ON_U_FOR_SYM_ND_HST_ZPNLN trigger for public.sym_node_host
2019-01-03 17:16:21,423 INFO [zapaonline-001] [PostgreSqlSymmetricDialect] [zapaonline-001-sync-triggers-1] Creating SYM_ON_D_FOR_SYM_ND_HST_ZPNLN trigger for public.sym_node_host
2019-01-03 17:16:21,430 INFO [zapaonline-001] [TriggerRouterService] [zapaonline-001-job-3] Done synchronizing triggers
2019-01-03 17:16:21,866 INFO [zapaonline-001] [RegistrationService] [zapaonline-001-job-3] Successfully registered node [id=001]
2019-01-03 17:16:21,870 INFO [zapaonline-001] [ExtensionService] [zapaonline-001-job-3] Found 0 extension points from the database that will be registered
2019-01-03 17:16:21,870 INFO [zapaonline-001] [ClientExtensionService] [zapaonline-001-job-3] Found 7 extension points from spring that will be registered
2019-01-03 17:16:21,872 INFO [zapaonline-001] [PushHeartbeatListener] [zapaonline-001-job-3] Some attribute(s) of node changed. Recording changes
2019-01-03 17:16:21,873 INFO [zapaonline-001] [PushHeartbeatListener] [zapaonline-001-job-3] Updating my node configuration info according to the symmetric properties
2019-01-03 17:16:22,328 INFO [zapaonline-001] [NodeCommunicationService] [zapaonline-001-job-3] pull will use 10 threads
2019-01-03 17:16:23,611 INFO [zol-000] [NodeCommunicationService] [zol-000-job-3] pull will use 10 threads
2019-01-03 17:16:23,732 INFO [zol-000] [DataService] [zol-000-job-1] Queueing up an initial load to node 001
2019-01-03 17:16:24,193 INFO [zol-000] [PurgeService] [zol-000-job-1] Purged all 0 incoming batch for node 001
2019-01-03 17:16:24,194 INFO [zol-000] [RouterService] [zol-000-job-1] Inserted reload events for node 001 in 533 ms
2019-01-03 17:16:24,209 INFO [zol-000] [DataGapFastDetector] [zol-000-job-1] Full gap analysis is running
2019-01-03 17:16:24,242 INFO [zol-000] [DataGapFastDetector] [zol-000-job-1] Querying data in gaps from database took 33 ms
2019-01-03 17:16:24,267 INFO [zol-000] [DataGapFastDetector] [zol-000-job-1] Full gap analysis is done after 58 ms
2019-01-03 17:16:24,297 INFO [zol-000] [RouterService] [zol-000-job-1] The 'config' channel is NOT in common batch mode
2019-01-03 17:16:24,372 INFO [zol-000] [ConfigurationChangedDataRouter] [zol-000-job-1] About to refresh the cache of nodes because new configuration came through the data router
2019-01-03 17:16:24,374 INFO [zol-000] [ConfigurationChangedDataRouter] [zol-000-job-1] About to refresh the cache of node security because new configuration came through the data router
2019-01-03 17:16:24,379 INFO [zol-000] [RouterService] [zol-000-job-1] The 'heartbeat' channel is NOT in common batch mode
2019-01-03 17:16:24,409 INFO [zol-000] [RouterService] [zol-000-job-1] Routed 7 data events in 200 ms
2019-01-03 17:16:25,707 INFO [zapaonline-001] [NodeCommunicationService] [zapaonline-001-job-8] push will use 10 threads
2019-01-03 17:16:25,782 INFO [zapaonline-001] [RouterService] [zapaonline-001-job-9] The 'config' channel is NOT in common batch mode
2019-01-03 17:16:25,833 INFO [zapaonline-001] [ConfigurationChangedDataRouter] [zapaonline-001-job-9] About to refresh the cache of nodes because new configuration came through the data router
2019-01-03 17:16:25,834 INFO [zapaonline-001] [RouterService] [zapaonline-001-job-9] The 'heartbeat' channel is NOT in common batch mode
2019-01-03 17:16:25,867 INFO [zapaonline-001] [RouterService] [zapaonline-001-job-9] Routed 2 data events in 117 ms
2019-01-03 17:16:32,531 INFO [zol-000] [DataExtractorService] [zol-000-dataextractor-1] Batch 001-5 is not ready for delivery. It is currently scheduled for extraction
2019-01-03 17:16:32,542 INFO [zol-000] [PullUriHandler] [qtp973576304-14] 5 data and 4 batches sent during pull request from zapaonline:001:001
2019-01-03 17:16:32,619 INFO [zapaonline-001] [ConfigurationChangedDatabaseWriterFilter] [zapaonline-001-dataloader-2] About to refresh the cache of node security because new configuration came through the data loader
2019-01-03 17:16:32,630 INFO [zapaonline-001] [ConfigurationChangedDatabaseWriterFilter] [zapaonline-001-dataloader-2] About to refresh the cache of nodes because new configuration came through the data loader
2019-01-03 17:16:32,656 INFO [zapaonline-001] [DefaultDatabaseWriter] [zapaonline-001-dataloader-2] About to create table using the following definition:
2019-01-03 17:16:32,686 INFO [zapaonline-001] [PostgreSqlDatabasePlatform] [zapaonline-001-dataloader-2] Running alter sql:
CREATE TABLE "vat_rate"(
"id" INTEGER NOT NULL,
"name" VARCHAR(64) NOT NULL,
"value" NUMERIC(5,4),
"vat" BOOLEAN DEFAULT 1 NOT NULL,
"guid" CHAR(36) DEFAULT 'newid()' NOT NULL,
"last_update_date_time" TIMESTAMP NOT NULL,
PRIMARY KEY ("id")
);
2019-01-03 17:16:32,705 WARN [zapaonline-001] [JdbcSqlTemplate] [zapaonline-001-dataloader-2] BŁĄD: kolumna "vat" jest typu boolean ale domyślne wyrażenie jest typu integer
Hint: Będziesz musiał przepisać lub rzutować wyrażenie.. Failed to execute: CREATE TABLE "vat_rate"(
"id" INTEGER NOT NULL,
"name" VARCHAR(64) NOT NULL,
"value" NUMERIC(5,4),
"vat" BOOLEAN DEFAULT 1 NOT NULL,
"guid" CHAR(36) DEFAULT 'newid()' NOT NULL,
"last_update_date_time" TIMESTAMP NOT NULL,
PRIMARY KEY ("id")
)
2019-01-03 17:16:32,723 ERROR [zapaonline-001] [DefaultDatabaseWriter] [zapaonline-001-dataloader-2] Failed to alter table using the following xml:
StackTraceKey.init [SqlException:4238718066]
org.jumpmind.db.sql.SqlException: BŁĄD: kolumna "vat" jest typu boolean ale domyślne wyrażenie jest typu integer
Hint: Będziesz musiał przepisać lub rzutować wyrażenie.
at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:302)
at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:291)
at org.jumpmind.db.sql.JdbcSqlTemplate.execute(JdbcSqlTemplate.java:503)
at org.jumpmind.db.sql.JdbcSqlTemplate.update(JdbcSqlTemplate.java:411)
at org.jumpmind.db.sql.SqlScript.execute(SqlScript.java:115)
at org.jumpmind.db.platform.AbstractDatabasePlatform.alterTables(AbstractDatabasePlatform.java:227)
at org.jumpmind.db.platform.AbstractDatabasePlatform.alterDatabase(AbstractDatabasePlatform.java:200)
at org.jumpmind.symmetric.io.data.writer.DefaultDatabaseWriter.create(DefaultDatabaseWriter.java:544)
at org.jumpmind.symmetric.io.data.writer.AbstractDatabaseWriter.write(AbstractDatabaseWriter.java:203)
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)
Caused by: org.postgresql.util.PSQLException: BŁĄD: kolumna "vat" jest typu boolean ale domyślne wyrażenie jest typu integer
Hint: Będziesz musiał przepisać lub rzutować wyrażenie.
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2422)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2167)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:306)
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:307)
at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:293)
at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:270)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:266)
at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
at org.jumpmind.db.sql.JdbcSqlTemplate$6.execute(JdbcSqlTemplate.java:426)
at org.jumpmind.db.sql.JdbcSqlTemplate$6.execute(JdbcSqlTemplate.java:411)
at org.jumpmind.db.sql.JdbcSqlTemplate.execute(JdbcSqlTemplate.java:501)
... 19 more
2019-01-03 17:16:32,853 ERROR [zapaonline-001] [ManageIncomingBatchListener] [zapaonline-001-dataloader-2] Failed to load batch 000-4 StackTraceKey [SqlException:4238718066]
2019-01-03 17:16:32,983 ERROR [zol-000] [AcknowledgeService] [qtp973576304-17] The outgoing batch 001-4 failed: BŁĄD: kolumna "vat" jest typu boolean ale domyślne wyrażenie jest typu integer
Hint: Będziesz musiał przepisać lub rzutować wyrażenie.
2019-01-03 17:16:33,657 INFO [zol-000] [NodeCommunicationService] [zol-000-job-11] extract will use 20 threads
2019-01-03 17:16:33,707 INFO [zol-000] [DataExtractorService] [zol-000-extract-default-1] Extracting batches for request 2. Starting at batch 5. Ending at batch 5
2019-01-03 17:16:33,818 INFO [zol-000] [DataExtractorService] [zol-000-extract-default-1] Done extracting 1 batches for request 2
2019-01-03 17:16:35,777 INFO [zapaonline-001] [PushService] [zapaonline-001-push-default-2] Push data sent to zol:000:000
2019-01-03 17:16:35,891 INFO [zol-000] [DataLoaderService] [qtp973576304-17] 2 data and 2 batches loaded during push request from zapaonline:001:001.
2019-01-03 17:16:35,904 INFO [zapaonline-001] [ConfigurationChangedDataRouter] [zapaonline-001-job-14] About to refresh the cache of nodes because new configuration came through the data router
2019-01-03 17:16:35,909 INFO [zapaonline-001] [ConfigurationChangedDataRouter] [zapaonline-001-job-14] About to refresh the cache of node security because new configuration came through the data router
2019-01-03 17:16:35,910 INFO [zapaonline-001] [PushService] [zapaonline-001-push-default-2] Pushed data to node zol:000:000. 2 data and 2 batches were processed. (sym_node, sym_node_host)
2019-01-03 17:16:35,912 INFO [zapaonline-001] [RouterService] [zapaonline-001-job-14] Routed 3 data events in 33 ms
2019-01-03 17:16:39,524 INFO [zol-000] [ConfigurationChangedDataRouter] [zol-000-job-5] About to refresh the cache of nodes because new configuration came through the data router
2019-01-03 17:16:39,558 INFO [zol-000] [RouterService] [zol-000-job-5] Routed 2 data events in 82 ms
2019-01-03 17:16:42,422 INFO [zol-000] [PullUriHandler] [qtp973576304-14] 6 data and 3 batches sent during pull request from zapaonline:001:001
2019-01-03 17:16:42,430 INFO [zapaonline-001] [IncomingBatchService] [zapaonline-001-dataloader-3] Retrying batch 000-4
2019-01-03 17:16:42,464 INFO [zapaonline-001] [DefaultDatabaseWriter] [zapaonline-001-dataloader-3] About to create table using the following definition:
2019-01-03 17:16:42,503 INFO [zapaonline-001] [PostgreSqlDatabasePlatform] [zapaonline-001-dataloader-3] Running alter sql:
CREATE TABLE "vat_rate"(
"id" INTEGER NOT NULL,
"name" VARCHAR(64) NOT NULL,
"value" NUMERIC(5,4),
"vat" BOOLEAN DEFAULT 1 NOT NULL,
"guid" CHAR(36) DEFAULT 'newid()' NOT NULL,
"last_update_date_time" TIMESTAMP NOT NULL,
PRIMARY KEY ("id")
);
2019-01-03 17:16:42,520 WARN [zapaonline-001] [JdbcSqlTemplate] [zapaonline-001-dataloader-3] BŁĄD: kolumna "vat" jest typu boolean ale domyślne wyrażenie jest typu integer
Hint: Będziesz musiał przepisać lub rzutować wyrażenie.. Failed to execute: CREATE TABLE "vat_rate"(
"id" INTEGER NOT NULL,
"name" VARCHAR(64) NOT NULL,
"value" NUMERIC(5,4),
"vat" BOOLEAN DEFAULT 1 NOT NULL,
"guid" CHAR(36) DEFAULT 'newid()' NOT NULL,
"last_update_date_time" TIMESTAMP NOT NULL,
PRIMARY KEY ("id")
)
2019-01-03 17:16:42,532 ERROR [zapaonline-001] [DefaultDatabaseWriter] [zapaonline-001-dataloader-3] Failed to alter table using the following xml:
StackTraceKey [SqlException:4238718066]
2019-01-03 17:16:42,658 ERROR [zapaonline-001] [ManageIncomingBatchListener] [zapaonline-001-dataloader-3] Failed to load batch 000-4 StackTraceKey [SqlException:4238718066]
2019-01-03 17:16:42,759 ERROR [zol-000] [AcknowledgeService] [qtp973576304-15] The outgoing batch 001-4 failed: BŁĄD: kolumna "vat" jest typu boolean ale domyślne wyrażenie jest typu integer
Hint: Będziesz musiał przepisać lub rzutować wyrażenie.