2018-10-23 07:06:21,555 INFO [] [AbstractCommandLauncher] [main] Option: name=engine, value={sunserver-000}
2018-10-23 07:06:21,926 INFO [] [SymmetricUtils] [main]
_____ __ _ ____ _____
/ ___/ __ _____ __ ___ __ ___ _/ /_ ____(_)___ / __ | / ___/
\__ \ / / / / _ `_ \/ _ `_ \/ _ \/_ __// __/ / __/ / / / / \__ \
___/ // /_/ / // // / // // / __// / / / / / /_ / /_/ / ___/ /
/____/ \__ /_//_//_/_//_//_/\___/ \_/ /_/ /_/\__/ /_____/ /____/
/____/
+-----------------------------------------------------------------+
| Copyright (C) 2007-2018 JumpMind, Inc. |
| |
| Licensed under the GNU General Public License version 3. |
| This software comes with ABSOLUTELY NO WARRANTY. |
| See http://www.gnu.org/licenses/gpl.html |
+-----------------------------------------------------------------+
2018-10-23 07:06:21,933 INFO [sunserver-000] [AbstractSymmetricEngine] [main] Initializing connection to database
2018-10-23 07:06:22,018 INFO [sunserver-000] [JdbcDatabasePlatformFactory] [main] Detected database 'greenplum', version '5', protocol 'postgresql'
2018-10-23 07:06:22,028 INFO [sunserver-000] [JdbcDatabasePlatformFactory] [main] The IDatabasePlatform being used is org.jumpmind.db.platform.greenplum.GreenplumPlatform
2018-10-23 07:06:22,079 INFO [sunserver-000] [GreenplumSymmetricDialect] [main] The DbDialect being used is org.jumpmind.symmetric.db.postgresql.GreenplumSymmetricDialect
2018-10-23 07:06:22,102 INFO [sunserver-000] [StagingManager] [main] The staging directory was initialized at the following location: /opt/websuite/symmetric-server-3.9.14/tmp/sunserver-000
2018-10-23 07:06:22,570 INFO [sunserver-000] [ClientExtensionService] [main] Found 6 extension points from spring that will be registered
2018-10-23 07:06:22,571 INFO [sunserver-000] [AbstractSymmetricEngine] [main] Initializing SymmetricDS database
2018-10-23 07:06:22,571 INFO [sunserver-000] [GreenplumSymmetricDialect] [main] Checking if SymmetricDS tables need created or altered
2018-10-23 07:06:23,111 INFO [sunserver-000] [GreenplumSymmetricDialect] [main] There are SymmetricDS tables that needed altered
2018-10-23 07:06:23,343 INFO [sunserver-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_channel"(
"channel_id" VARCHAR(128) NOT NULL,
"processing_order" INTEGER DEFAULT 1 NOT NULL,
"max_batch_size" INTEGER DEFAULT 1000 NOT NULL,
"max_batch_to_send" INTEGER DEFAULT 60 NOT NULL,
"max_data_to_route" INTEGER DEFAULT 100000 NOT NULL,
"extract_period_millis" INTEGER DEFAULT 0 NOT NULL,
"enabled" SMALLINT DEFAULT 1 NOT NULL,
"use_old_data_to_route" SMALLINT DEFAULT 1 NOT NULL,
"use_row_data_to_route" SMALLINT DEFAULT 1 NOT NULL,
"use_pk_data_to_route" SMALLINT DEFAULT 1 NOT NULL,
"reload_flag" SMALLINT DEFAULT 0 NOT NULL,
"file_sync_flag" SMALLINT DEFAULT 0 NOT NULL,
"contains_big_lob" SMALLINT DEFAULT 0 NOT NULL,
"batch_algorithm" VARCHAR(50) DEFAULT 'default' NOT NULL,
"data_loader_type" VARCHAR(50) DEFAULT 'default' NOT NULL,
"description" VARCHAR(255),
"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")
)
2018-10-23 07:06:23,513 INFO [sunserver-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_conflict"(
"conflict_id" VARCHAR(50) NOT NULL,
"source_node_group_id" VARCHAR(50) NOT NULL,
"target_node_group_id" VARCHAR(50) NOT NULL,
"target_channel_id" VARCHAR(128),
"target_catalog_name" VARCHAR(255),
"target_schema_name" VARCHAR(255),
"target_table_name" VARCHAR(255),
"detect_type" VARCHAR(128) NOT NULL,
"detect_expression" 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")
)
2018-10-23 07:06:23,674 INFO [sunserver-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_context"(
"name" VARCHAR(80) NOT NULL,
"context_value" TEXT,
"create_time" TIMESTAMP,
"last_update_time" TIMESTAMP,
PRIMARY KEY ("name")
)
2018-10-23 07:06:23,745 INFO [sunserver-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE SEQUENCE "sym_data_data_id_seq"
2018-10-23 07:06:23,898 INFO [sunserver-000] [GreenplumSymmetricDialect] [main] 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")
)
2018-10-23 07:06:23,983 INFO [sunserver-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE INDEX "sym_idx_d_channel_id" ON "sym_data" ("data_id", "channel_id")
2018-10-23 07:06:24,096 INFO [sunserver-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_data_event"(
"data_id" BIGINT NOT NULL,
"batch_id" BIGINT NOT NULL,
"router_id" VARCHAR(50) NOT NULL,
"create_time" TIMESTAMP,
PRIMARY KEY ("data_id", "batch_id", "router_id")
)
2018-10-23 07:06:24,186 INFO [sunserver-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE INDEX "sym_idx_de_batchid" ON "sym_data_event" ("batch_id")
2018-10-23 07:06:24,295 INFO [sunserver-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_data_gap"(
"start_id" BIGINT NOT NULL,
"end_id" BIGINT NOT NULL,
"status" CHAR(2),
"create_time" TIMESTAMP NOT NULL,
"last_update_hostname" VARCHAR(255),
"last_update_time" TIMESTAMP NOT NULL,
PRIMARY KEY ("start_id", "end_id")
)
2018-10-23 07:06:24,374 INFO [sunserver-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE INDEX "sym_idx_dg_status" ON "sym_data_gap" ("status")
2018-10-23 07:06:24,548 INFO [sunserver-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_extension"(
"extension_id" VARCHAR(50) NOT NULL,
"extension_type" VARCHAR(10) NOT NULL,
"interface_name" VARCHAR(255),
"node_group_id" VARCHAR(50) NOT NULL,
"enabled" SMALLINT DEFAULT 1 NOT NULL,
"extension_order" INTEGER DEFAULT 1 NOT NULL,
"extension_text" TEXT,
"create_time" TIMESTAMP,
"last_update_by" VARCHAR(50),
"last_update_time" TIMESTAMP,
PRIMARY KEY ("extension_id")
)
2018-10-23 07:06:24,656 INFO [sunserver-000] [GreenplumSymmetricDialect] [main] 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")
)
2018-10-23 07:06:24,769 INFO [sunserver-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_file_incoming"(
"relative_dir" VARCHAR(255) NOT NULL,
"file_name" VARCHAR(128) NOT NULL,
"last_event_type" CHAR(1) NOT NULL,
"node_id" VARCHAR(50) NOT NULL,
"file_modified_time" BIGINT,
PRIMARY KEY ("relative_dir", "file_name")
)
2018-10-23 07:06:24,886 INFO [sunserver-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_file_snapshot"(
"trigger_id" VARCHAR(128) NOT NULL,
"router_id" VARCHAR(50) NOT NULL,
"relative_dir" VARCHAR(255) NOT NULL,
"file_name" VARCHAR(128) NOT NULL,
"channel_id" VARCHAR(128) DEFAULT 'filesync' NOT NULL,
"reload_channel_id" VARCHAR(128) DEFAULT 'filesync_reload' NOT NULL,
"last_event_type" CHAR(1) NOT NULL,
"crc32_checksum" BIGINT,
"file_size" BIGINT,
"file_modified_time" BIGINT,
"last_update_time" TIMESTAMP NOT NULL,
"last_update_by" VARCHAR(50),
"create_time" TIMESTAMP NOT NULL,
PRIMARY KEY ("trigger_id", "router_id", "relative_dir", "file_name")
)
2018-10-23 07:06:24,979 INFO [sunserver-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE INDEX "sym_idx_f_snpsht_chid" ON "sym_file_snapshot" ("reload_channel_id")
2018-10-23 07:06:25,163 INFO [sunserver-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_file_trigger"(
"trigger_id" VARCHAR(128) NOT NULL,
"channel_id" VARCHAR(128) DEFAULT 'filesync' NOT NULL,
"reload_channel_id" VARCHAR(128) DEFAULT 'filesync_reload' NOT NULL,
"base_dir" VARCHAR(255) NOT NULL,
"recurse" SMALLINT DEFAULT 1 NOT NULL,
"includes_files" VARCHAR(255),
"excludes_files" VARCHAR(255),
"sync_on_create" SMALLINT DEFAULT 1 NOT NULL,
"sync_on_modified" SMALLINT DEFAULT 1 NOT NULL,
"sync_on_delete" SMALLINT DEFAULT 1 NOT NULL,
"sync_on_ctl_file" SMALLINT DEFAULT 0 NOT NULL,
"delete_after_sync" SMALLINT DEFAULT 0 NOT NULL,
"before_copy_script" 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")
)
2018-10-23 07:06:25,354 INFO [sunserver-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_file_trigger_router"(
"trigger_id" VARCHAR(128) NOT NULL,
"router_id" VARCHAR(50) NOT NULL,
"enabled" SMALLINT DEFAULT 1 NOT NULL,
"initial_load_enabled" SMALLINT DEFAULT 1 NOT NULL,
"target_base_dir" VARCHAR(255),
"conflict_strategy" VARCHAR(128) DEFAULT 'source_wins' NOT NULL,
"create_time" TIMESTAMP NOT NULL,
"last_update_by" VARCHAR(50),
"last_update_time" TIMESTAMP NOT NULL,
"description" TEXT,
PRIMARY KEY ("trigger_id", "router_id")
)
2018-10-23 07:06:25,474 INFO [sunserver-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_grouplet"(
"grouplet_id" VARCHAR(50) NOT NULL,
"grouplet_link_policy" CHAR(1) DEFAULT 'I' NOT NULL,
"description" VARCHAR(255),
"create_time" TIMESTAMP NOT NULL,
"last_update_by" VARCHAR(50),
"last_update_time" TIMESTAMP NOT NULL,
PRIMARY KEY ("grouplet_id")
)
2018-10-23 07:06:25,583 INFO [sunserver-000] [GreenplumSymmetricDialect] [main] 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")
)
2018-10-23 07:06:25,766 INFO [sunserver-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_incoming_batch"(
"batch_id" BIGINT NOT NULL,
"node_id" VARCHAR(50) NOT NULL,
"channel_id" VARCHAR(128),
"status" CHAR(2),
"error_flag" SMALLINT DEFAULT 0,
"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")
)
2018-10-23 07:06:25,863 INFO [sunserver-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE INDEX "sym_idx_ib_time_status" ON "sym_incoming_batch" ("create_time", "status")
2018-10-23 07:06:25,946 INFO [sunserver-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE INDEX "sym_idx_ib_in_error" ON "sym_incoming_batch" ("error_flag")
2018-10-23 07:06:26,120 INFO [sunserver-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_incoming_error"(
"batch_id" BIGINT NOT NULL,
"node_id" VARCHAR(50) NOT NULL,
"failed_row_number" BIGINT NOT NULL,
"failed_line_number" BIGINT DEFAULT 0 NOT NULL,
"target_catalog_name" VARCHAR(255),
"target_schema_name" VARCHAR(255),
"target_table_name" VARCHAR(255) NOT NULL,
"event_type" CHAR(1) NOT NULL,
"binary_encoding" VARCHAR(10) DEFAULT 'HEX' NOT NULL,
"column_names" 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")
)
2018-10-23 07:06:26,285 INFO [sunserver-000] [GreenplumSymmetricDialect] [main] 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")
)
2018-10-23 07:06:26,452 INFO [sunserver-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_load_filter"(
"load_filter_id" VARCHAR(50) NOT NULL,
"load_filter_type" VARCHAR(10) NOT NULL,
"source_node_group_id" VARCHAR(50) NOT NULL,
"target_node_group_id" VARCHAR(50) NOT NULL,
"target_catalog_name" VARCHAR(255),
"target_schema_name" VARCHAR(255),
"target_table_name" VARCHAR(255),
"filter_on_update" SMALLINT DEFAULT 1 NOT NULL,
"filter_on_insert" SMALLINT DEFAULT 1 NOT NULL,
"filter_on_delete" SMALLINT DEFAULT 1 NOT NULL,
"before_write_script" 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")
)
2018-10-23 07:06:26,561 INFO [sunserver-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_lock"(
"lock_action" VARCHAR(50) NOT NULL,
"lock_type" VARCHAR(50) NOT NULL,
"locking_server_id" VARCHAR(255),
"lock_time" TIMESTAMP,
"shared_count" INTEGER DEFAULT 0 NOT NULL,
"shared_enable" INTEGER DEFAULT 0 NOT NULL,
"last_lock_time" TIMESTAMP,
"last_locking_server_id" VARCHAR(255),
PRIMARY KEY ("lock_action")
)
2018-10-23 07:06:26,666 INFO [sunserver-000] [GreenplumSymmetricDialect] [main] 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")
)
2018-10-23 07:06:26,783 INFO [sunserver-000] [GreenplumSymmetricDialect] [main] 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")
)
2018-10-23 07:06:26,890 INFO [sunserver-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_node_channel_ctl"(
"node_id" VARCHAR(50) NOT NULL,
"channel_id" VARCHAR(128) NOT NULL,
"suspend_enabled" SMALLINT DEFAULT 0,
"ignore_enabled" SMALLINT DEFAULT 0,
"last_extract_time" TIMESTAMP,
PRIMARY KEY ("node_id", "channel_id")
)
2018-10-23 07:06:27,031 INFO [sunserver-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_node_group"(
"node_group_id" VARCHAR(50) NOT NULL,
"description" VARCHAR(255),
"create_time" TIMESTAMP,
"last_update_by" VARCHAR(50),
"last_update_time" TIMESTAMP,
PRIMARY KEY ("node_group_id")
)
2018-10-23 07:06:27,139 INFO [sunserver-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_node_group_channel_wnd"(
"node_group_id" VARCHAR(50) NOT NULL,
"channel_id" VARCHAR(128) NOT NULL,
"start_time" TIMESTAMP NOT NULL,
"end_time" TIMESTAMP NOT NULL,
"enabled" SMALLINT DEFAULT 0 NOT NULL,
PRIMARY KEY ("node_group_id", "channel_id", "start_time", "end_time")
)
2018-10-23 07:06:27,251 INFO [sunserver-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_node_group_link"(
"source_node_group_id" VARCHAR(50) NOT NULL,
"target_node_group_id" VARCHAR(50) NOT NULL,
"data_event_action" CHAR(1) DEFAULT 'W' NOT NULL,
"sync_config_enabled" SMALLINT DEFAULT 1 NOT NULL,
"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")
)
2018-10-23 07:06:27,375 INFO [sunserver-000] [GreenplumSymmetricDialect] [main] 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")
)
2018-10-23 07:06:27,491 INFO [sunserver-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_node_host_channel_stats"(
"node_id" VARCHAR(50) NOT NULL,
"host_name" VARCHAR(60) NOT NULL,
"channel_id" VARCHAR(128) NOT NULL,
"start_time" TIMESTAMP NOT NULL,
"end_time" TIMESTAMP NOT NULL,
"data_routed" BIGINT DEFAULT 0,
"data_unrouted" BIGINT DEFAULT 0,
"data_event_inserted" BIGINT DEFAULT 0,
"data_extracted" BIGINT DEFAULT 0,
"data_bytes_extracted" BIGINT DEFAULT 0,
"data_extracted_errors" BIGINT DEFAULT 0,
"data_bytes_sent" BIGINT DEFAULT 0,
"data_sent" BIGINT DEFAULT 0,
"data_sent_errors" BIGINT DEFAULT 0,
"data_loaded" BIGINT DEFAULT 0,
"data_bytes_loaded" BIGINT DEFAULT 0,
"data_loaded_errors" BIGINT DEFAULT 0,
PRIMARY KEY ("node_id", "host_name", "channel_id", "start_time", "end_time")
)
2018-10-23 07:06:27,584 INFO [sunserver-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE INDEX "sym_idx_nd_hst_chnl_sts" ON "sym_node_host_channel_stats" ("node_id", "start_time", "end_time")
2018-10-23 07:06:27,691 INFO [sunserver-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_node_host_job_stats"(
"node_id" VARCHAR(50) NOT NULL,
"host_name" VARCHAR(60) NOT NULL,
"job_name" VARCHAR(50) NOT NULL,
"start_time" TIMESTAMP NOT NULL,
"end_time" TIMESTAMP NOT NULL,
"processed_count" BIGINT DEFAULT 0,
"target_node_id" VARCHAR(50),
"target_node_count" INTEGER DEFAULT 0,
PRIMARY KEY ("node_id", "host_name", "job_name", "start_time", "end_time")
)
2018-10-23 07:06:27,777 INFO [sunserver-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE INDEX "sym_idx_nd_hst_job" ON "sym_node_host_job_stats" ("node_id", "start_time", "end_time")
2018-10-23 07:06:27,893 INFO [sunserver-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_node_host_stats"(
"node_id" VARCHAR(50) NOT NULL,
"host_name" VARCHAR(60) NOT NULL,
"start_time" TIMESTAMP NOT NULL,
"end_time" TIMESTAMP NOT NULL,
"restarted" BIGINT DEFAULT 0 NOT NULL,
"nodes_pulled" BIGINT DEFAULT 0,
"total_nodes_pull_time" BIGINT DEFAULT 0,
"nodes_pushed" BIGINT DEFAULT 0,
"total_nodes_push_time" BIGINT DEFAULT 0,
"nodes_rejected" BIGINT DEFAULT 0,
"nodes_registered" BIGINT DEFAULT 0,
"nodes_loaded" BIGINT DEFAULT 0,
"nodes_disabled" BIGINT DEFAULT 0,
"purged_data_rows" BIGINT DEFAULT 0,
"purged_data_event_rows" BIGINT DEFAULT 0,
"purged_batch_outgoing_rows" BIGINT DEFAULT 0,
"purged_batch_incoming_rows" BIGINT DEFAULT 0,
"triggers_created_count" BIGINT,
"triggers_rebuilt_count" BIGINT,
"triggers_removed_count" BIGINT,
PRIMARY KEY ("node_id", "host_name", "start_time", "end_time")
)
2018-10-23 07:06:27,979 INFO [sunserver-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE INDEX "sym_idx_nd_hst_sts" ON "sym_node_host_stats" ("node_id", "start_time", "end_time")
2018-10-23 07:06:28,089 INFO [sunserver-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_node_identity"(
"node_id" VARCHAR(50) NOT NULL,
PRIMARY KEY ("node_id")
)
2018-10-23 07:06:28,200 INFO [sunserver-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_node_security"(
"node_id" VARCHAR(50) NOT NULL,
"node_password" VARCHAR(50) NOT NULL,
"registration_enabled" SMALLINT DEFAULT 0,
"registration_time" TIMESTAMP,
"initial_load_enabled" SMALLINT DEFAULT 0,
"initial_load_time" TIMESTAMP,
"initial_load_id" BIGINT,
"initial_load_create_by" VARCHAR(255),
"rev_initial_load_enabled" SMALLINT DEFAULT 0,
"rev_initial_load_time" TIMESTAMP,
"rev_initial_load_id" BIGINT,
"rev_initial_load_create_by" VARCHAR(255),
"created_at_node_id" VARCHAR(50),
PRIMARY KEY ("node_id")
)
2018-10-23 07:06:28,382 INFO [sunserver-000] [GreenplumSymmetricDialect] [main] 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")
)
2018-10-23 07:06:28,560 INFO [sunserver-000] [GreenplumSymmetricDialect] [main] 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")
)
2018-10-23 07:06:28,726 INFO [sunserver-000] [GreenplumSymmetricDialect] [main] 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")
)
2018-10-23 07:06:28,905 INFO [sunserver-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_outgoing_batch"(
"batch_id" BIGINT NOT NULL,
"node_id" VARCHAR(50) NOT NULL,
"channel_id" VARCHAR(128),
"status" CHAR(2),
"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")
)
2018-10-23 07:06:28,996 INFO [sunserver-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE INDEX "sym_idx_ob_node_status" ON "sym_outgoing_batch" ("node_id", "status")
2018-10-23 07:06:29,084 INFO [sunserver-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE INDEX "sym_idx_ob_status" ON "sym_outgoing_batch" ("status")
2018-10-23 07:06:29,167 INFO [sunserver-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE INDEX "sym_idx_ob_in_error" ON "sym_outgoing_batch" ("error_flag")
2018-10-23 07:06:29,341 INFO [sunserver-000] [GreenplumSymmetricDialect] [main] 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")
)
2018-10-23 07:06:29,456 INFO [sunserver-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_registration_redirect"(
"registrant_external_id" VARCHAR(255) NOT NULL,
"registration_node_id" VARCHAR(50) NOT NULL,
PRIMARY KEY ("registrant_external_id")
)
2018-10-23 07:06:29,631 INFO [sunserver-000] [GreenplumSymmetricDialect] [main] 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")
)
2018-10-23 07:06:29,717 INFO [sunserver-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE INDEX "sym_idx_reg_req_1" ON "sym_registration_request" ("node_group_id", "external_id", "status", "host_name", "ip_address")
2018-10-23 07:06:29,812 INFO [sunserver-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE INDEX "sym_idx_reg_req_2" ON "sym_registration_request" ("status")
2018-10-23 07:06:29,995 INFO [sunserver-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_router"(
"router_id" VARCHAR(50) NOT NULL,
"target_catalog_name" VARCHAR(255),
"target_schema_name" VARCHAR(255),
"target_table_name" VARCHAR(255),
"source_node_group_id" VARCHAR(50) NOT NULL,
"target_node_group_id" VARCHAR(50) NOT NULL,
"router_type" VARCHAR(50),
"router_expression" 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")
)
2018-10-23 07:06:30,088 INFO [sunserver-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_sequence"(
"sequence_name" VARCHAR(50) NOT NULL,
"current_value" BIGINT DEFAULT 0 NOT NULL,
"increment_by" INTEGER DEFAULT 1 NOT NULL,
"min_value" BIGINT DEFAULT 1 NOT NULL,
"max_value" BIGINT DEFAULT 9999999999 NOT NULL,
"cycle_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")
)
2018-10-23 07:06:30,238 INFO [sunserver-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_table_reload_request"(
"target_node_id" VARCHAR(50) NOT NULL,
"source_node_id" VARCHAR(50) NOT NULL,
"trigger_id" VARCHAR(128) NOT NULL,
"router_id" VARCHAR(50) NOT NULL,
"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")
)
2018-10-23 07:06:30,418 INFO [sunserver-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_transform_table"(
"transform_id" VARCHAR(50) NOT NULL,
"source_node_group_id" VARCHAR(50) NOT NULL,
"target_node_group_id" VARCHAR(50) NOT NULL,
"transform_point" VARCHAR(10) NOT NULL,
"source_catalog_name" VARCHAR(255),
"source_schema_name" VARCHAR(255),
"source_table_name" VARCHAR(255) NOT NULL,
"target_catalog_name" VARCHAR(255),
"target_schema_name" VARCHAR(255),
"target_table_name" VARCHAR(255),
"update_first" SMALLINT DEFAULT 0,
"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")
)
2018-10-23 07:06:30,594 INFO [sunserver-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_transform_column"(
"transform_id" VARCHAR(50) NOT NULL,
"include_on" CHAR(1) DEFAULT '*' NOT NULL,
"target_column_name" VARCHAR(128) NOT NULL,
"source_column_name" VARCHAR(128),
"pk" SMALLINT DEFAULT 0,
"transform_type" VARCHAR(50) DEFAULT 'copy',
"transform_expression" 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")
)
2018-10-23 07:06:30,759 INFO [sunserver-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_trigger"(
"trigger_id" VARCHAR(128) NOT NULL,
"source_catalog_name" VARCHAR(255),
"source_schema_name" VARCHAR(255),
"source_table_name" VARCHAR(255) NOT NULL,
"channel_id" VARCHAR(128) NOT NULL,
"reload_channel_id" VARCHAR(128) DEFAULT 'reload' NOT NULL,
"sync_on_update" SMALLINT DEFAULT 1 NOT NULL,
"sync_on_insert" SMALLINT DEFAULT 1 NOT NULL,
"sync_on_delete" SMALLINT DEFAULT 1 NOT NULL,
"sync_on_incoming_batch" SMALLINT DEFAULT 0 NOT NULL,
"name_for_update_trigger" VARCHAR(255),
"name_for_insert_trigger" VARCHAR(255),
"name_for_delete_trigger" VARCHAR(255),
"sync_on_update_condition" 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")
)
2018-10-23 07:06:30,922 INFO [sunserver-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_trigger_hist"(
"trigger_hist_id" INTEGER NOT NULL,
"trigger_id" VARCHAR(128) NOT NULL,
"source_table_name" VARCHAR(255) NOT NULL,
"source_catalog_name" VARCHAR(255),
"source_schema_name" VARCHAR(255),
"name_for_update_trigger" VARCHAR(255),
"name_for_insert_trigger" VARCHAR(255),
"name_for_delete_trigger" VARCHAR(255),
"table_hash" BIGINT DEFAULT 0 NOT NULL,
"trigger_row_hash" BIGINT DEFAULT 0 NOT NULL,
"trigger_template_hash" BIGINT DEFAULT 0 NOT NULL,
"column_names" 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")
)
2018-10-23 07:06:31,012 INFO [sunserver-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE INDEX "sym_idx_trigg_hist_1" ON "sym_trigger_hist" ("trigger_id", "inactive_time")
2018-10-23 07:06:31,178 INFO [sunserver-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_trigger_router"(
"trigger_id" VARCHAR(128) NOT NULL,
"router_id" VARCHAR(50) NOT NULL,
"enabled" SMALLINT DEFAULT 1 NOT NULL,
"initial_load_order" INTEGER DEFAULT 1 NOT NULL,
"initial_load_select" 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")
)
2018-10-23 07:06:31,281 INFO [sunserver-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_trigger_router_grouplet"(
"grouplet_id" VARCHAR(50) NOT NULL,
"trigger_id" VARCHAR(128) NOT NULL,
"router_id" VARCHAR(50) NOT NULL,
"applies_when" CHAR(1) NOT NULL,
"create_time" TIMESTAMP NOT NULL,
"last_update_by" VARCHAR(50),
"last_update_time" TIMESTAMP NOT NULL,
PRIMARY KEY ("grouplet_id", "trigger_id", "router_id", "applies_when")
)
2018-10-23 07:06:31,326 INFO [sunserver-000] [GreenplumSymmetricDialect] [main] DDL applied: ALTER TABLE "sym_conflict"
ADD CONSTRAINT "sym_fk_cf_2_grp_lnk" FOREIGN KEY ("source_node_group_id", "target_node_group_id") REFERENCES "sym_node_group_link" ("source_node_group_id", "target_node_group_id")
2018-10-23 07:06:31,362 INFO [sunserver-000] [GreenplumSymmetricDialect] [main] DDL applied: ALTER TABLE "sym_file_trigger_router"
ADD CONSTRAINT "sym_fk_ftr_2_ftrg" FOREIGN KEY ("trigger_id") REFERENCES "sym_file_trigger" ("trigger_id")
2018-10-23 07:06:31,396 INFO [sunserver-000] [GreenplumSymmetricDialect] [main] DDL applied: ALTER TABLE "sym_file_trigger_router"
ADD CONSTRAINT "sym_fk_ftr_2_rtr" FOREIGN KEY ("router_id") REFERENCES "sym_router" ("router_id")
2018-10-23 07:06:31,434 INFO [sunserver-000] [GreenplumSymmetricDialect] [main] DDL applied: ALTER TABLE "sym_grouplet_link"
ADD CONSTRAINT "sym_fk_gpltlnk_2_gplt" FOREIGN KEY ("grouplet_id") REFERENCES "sym_grouplet" ("grouplet_id")
2018-10-23 07:06:31,462 INFO [sunserver-000] [GreenplumSymmetricDialect] [main] DDL applied: ALTER TABLE "sym_node_group_link"
ADD CONSTRAINT "sym_fk_lnk_2_grp_src" FOREIGN KEY ("source_node_group_id") REFERENCES "sym_node_group" ("node_group_id")
2018-10-23 07:06:31,500 INFO [sunserver-000] [GreenplumSymmetricDialect] [main] DDL applied: ALTER TABLE "sym_node_group_link"
ADD CONSTRAINT "sym_fk_lnk_2_grp_tgt" FOREIGN KEY ("target_node_group_id") REFERENCES "sym_node_group" ("node_group_id")
2018-10-23 07:06:31,534 INFO [sunserver-000] [GreenplumSymmetricDialect] [main] DDL applied: ALTER TABLE "sym_node_identity"
ADD CONSTRAINT "sym_fk_ident_2_node" FOREIGN KEY ("node_id") REFERENCES "sym_node" ("node_id")
2018-10-23 07:06:31,568 INFO [sunserver-000] [GreenplumSymmetricDialect] [main] DDL applied: ALTER TABLE "sym_node_security"
ADD CONSTRAINT "sym_fk_sec_2_node" FOREIGN KEY ("node_id") REFERENCES "sym_node" ("node_id")
2018-10-23 07:06:31,603 INFO [sunserver-000] [GreenplumSymmetricDialect] [main] DDL applied: ALTER TABLE "sym_router"
ADD CONSTRAINT "sym_fk_rt_2_grp_lnk" FOREIGN KEY ("source_node_group_id", "target_node_group_id") REFERENCES "sym_node_group_link" ("source_node_group_id", "target_node_group_id")
2018-10-23 07:06:31,636 INFO [sunserver-000] [GreenplumSymmetricDialect] [main] DDL applied: ALTER TABLE "sym_transform_table"
ADD CONSTRAINT "sym_fk_tt_2_grp_lnk" FOREIGN KEY ("source_node_group_id", "target_node_group_id") REFERENCES "sym_node_group_link" ("source_node_group_id", "target_node_group_id")
2018-10-23 07:06:31,674 INFO [sunserver-000] [GreenplumSymmetricDialect] [main] DDL applied: ALTER TABLE "sym_trigger"
ADD CONSTRAINT "sym_fk_trg_2_chnl" FOREIGN KEY ("channel_id") REFERENCES "sym_channel" ("channel_id")
2018-10-23 07:06:31,707 INFO [sunserver-000] [GreenplumSymmetricDialect] [main] DDL applied: ALTER TABLE "sym_trigger"
ADD CONSTRAINT "sym_fk_trg_2_rld_chnl" FOREIGN KEY ("reload_channel_id") REFERENCES "sym_channel" ("channel_id")
2018-10-23 07:06:31,742 INFO [sunserver-000] [GreenplumSymmetricDialect] [main] DDL applied: ALTER TABLE "sym_trigger_router"
ADD CONSTRAINT "sym_fk_tr_2_trg" FOREIGN KEY ("trigger_id") REFERENCES "sym_trigger" ("trigger_id")
2018-10-23 07:06:31,776 INFO [sunserver-000] [GreenplumSymmetricDialect] [main] DDL applied: ALTER TABLE "sym_trigger_router"
ADD CONSTRAINT "sym_fk_tr_2_rtr" FOREIGN KEY ("router_id") REFERENCES "sym_router" ("router_id")
2018-10-23 07:06:31,810 INFO [sunserver-000] [GreenplumSymmetricDialect] [main] DDL applied: ALTER TABLE "sym_trigger_router_grouplet"
ADD CONSTRAINT "sym_fk_trgplt_2_gplt" FOREIGN KEY ("grouplet_id") REFERENCES "sym_grouplet" ("grouplet_id")
2018-10-23 07:06:31,844 INFO [sunserver-000] [GreenplumSymmetricDialect] [main] DDL applied: ALTER TABLE "sym_trigger_router_grouplet"
ADD CONSTRAINT "sym_fk_trgplt_2_tr" FOREIGN KEY ("trigger_id", "router_id") REFERENCES "sym_trigger_router" ("trigger_id", "router_id")
2018-10-23 07:06:31,978 INFO [sunserver-000] [GreenplumSymmetricDialect] [main] Done with auto update of SymmetricDS tables
2018-10-23 07:06:32,040 INFO [sunserver-000] [ConfigurationService] [main] Auto-configuring config channel
2018-10-23 07:06:32,161 INFO [sunserver-000] [ConfigurationService] [main] Auto-configuring reload channel
2018-10-23 07:06:32,249 INFO [sunserver-000] [ConfigurationService] [main] Auto-configuring monitor channel
2018-10-23 07:06:32,360 INFO [sunserver-000] [ConfigurationService] [main] Auto-configuring heartbeat channel
2018-10-23 07:06:32,449 INFO [sunserver-000] [ConfigurationService] [main] Auto-configuring default channel
2018-10-23 07:06:32,535 INFO [sunserver-000] [ConfigurationService] [main] Auto-configuring dynamic channel
2018-10-23 07:06:33,384 INFO [sunserver-000] [AbstractSymmetricEngine] [main] Inserting rows for node, security, identity and group for registration server
2018-10-23 07:06:34,000 INFO [sunserver-000] [AbstractSymmetricEngine] [main] Done initializing SymmetricDS database
2018-10-23 07:33:34,385 INFO [] [AbstractCommandLauncher] [main] Option: name=engine, value={sunserver-000}
2018-10-23 07:33:34,696 INFO [] [SymmetricUtils] [main]
_____ __ _ ____ _____
/ ___/ __ _____ __ ___ __ ___ _/ /_ ____(_)___ / __ | / ___/
\__ \ / / / / _ `_ \/ _ `_ \/ _ \/_ __// __/ / __/ / / / / \__ \
___/ // /_/ / // // / // // / __// / / / / / /_ / /_/ / ___/ /
/____/ \__ /_//_//_/_//_//_/\___/ \_/ /_/ /_/\__/ /_____/ /____/
/____/
+-----------------------------------------------------------------+
| Copyright (C) 2007-2018 JumpMind, Inc. |
| |
| Licensed under the GNU General Public License version 3. |
| This software comes with ABSOLUTELY NO WARRANTY. |
| See http://www.gnu.org/licenses/gpl.html |
+-----------------------------------------------------------------+
2018-10-23 07:33:34,703 INFO [sunserver-000] [AbstractSymmetricEngine] [main] Initializing connection to database
2018-10-23 07:33:34,783 INFO [sunserver-000] [JdbcDatabasePlatformFactory] [main] Detected database 'greenplum', version '5', protocol 'postgresql'
2018-10-23 07:33:34,793 INFO [sunserver-000] [JdbcDatabasePlatformFactory] [main] The IDatabasePlatform being used is org.jumpmind.db.platform.greenplum.GreenplumPlatform
2018-10-23 07:33:35,171 INFO [sunserver-000] [GreenplumSymmetricDialect] [main] The DbDialect being used is org.jumpmind.symmetric.db.postgresql.GreenplumSymmetricDialect
2018-10-23 07:33:35,287 INFO [sunserver-000] [ExtensionService] [main] Found 0 extension points from the database that will be registered
2018-10-23 07:33:35,290 INFO [sunserver-000] [StagingManager] [main] The staging directory was initialized at the following location: /opt/websuite/symmetric-server-3.9.14/tmp/sunserver-000
2018-10-23 07:33:35,741 INFO [sunserver-000] [ExtensionService] [main] Found 0 extension points from the database that will be registered
2018-10-23 07:33:35,742 INFO [sunserver-000] [ClientExtensionService] [main] Found 6 extension points from spring that will be registered
2018-10-23 07:33:36,142 INFO [sunserver-000] [RegistrationService] [main] Just opened registration for external id of 001 and a node group of sunclinet and a node id of 001
2018-10-23 07:34:16,992 INFO [] [AbstractCommandLauncher] [main] Option: name=engine, value={sunserver-000}
2018-10-23 07:34:17,299 INFO [] [SymmetricUtils] [main]
_____ __ _ ____ _____
/ ___/ __ _____ __ ___ __ ___ _/ /_ ____(_)___ / __ | / ___/
\__ \ / / / / _ `_ \/ _ `_ \/ _ \/_ __// __/ / __/ / / / / \__ \
___/ // /_/ / // // / // // / __// / / / / / /_ / /_/ / ___/ /
/____/ \__ /_//_//_/_//_//_/\___/ \_/ /_/ /_/\__/ /_____/ /____/
/____/
+-----------------------------------------------------------------+
| Copyright (C) 2007-2018 JumpMind, Inc. |
| |
| Licensed under the GNU General Public License version 3. |
| This software comes with ABSOLUTELY NO WARRANTY. |
| See http://www.gnu.org/licenses/gpl.html |
+-----------------------------------------------------------------+
2018-10-23 07:34:17,306 INFO [sunserver-000] [AbstractSymmetricEngine] [main] Initializing connection to database
2018-10-23 07:34:17,387 INFO [sunserver-000] [JdbcDatabasePlatformFactory] [main] Detected database 'greenplum', version '5', protocol 'postgresql'
2018-10-23 07:34:17,397 INFO [sunserver-000] [JdbcDatabasePlatformFactory] [main] The IDatabasePlatform being used is org.jumpmind.db.platform.greenplum.GreenplumPlatform
2018-10-23 07:34:17,759 INFO [sunserver-000] [GreenplumSymmetricDialect] [main] The DbDialect being used is org.jumpmind.symmetric.db.postgresql.GreenplumSymmetricDialect
2018-10-23 07:34:17,870 INFO [sunserver-000] [ExtensionService] [main] Found 0 extension points from the database that will be registered
2018-10-23 07:34:17,877 INFO [sunserver-000] [StagingManager] [main] The staging directory was initialized at the following location: /opt/websuite/symmetric-server-3.9.14/tmp/sunserver-000
2018-10-23 07:34:18,332 INFO [sunserver-000] [ExtensionService] [main] Found 0 extension points from the database that will be registered
2018-10-23 07:34:18,333 INFO [sunserver-000] [ClientExtensionService] [main] Found 6 extension points from spring that will be registered
2018-10-23 08:00:12,905 INFO [] [AbstractCommandLauncher] [main] Option: name=engine, value={sunserver-000}
2018-10-23 08:00:13,211 INFO [] [SymmetricUtils] [main]
_____ __ _ ____ _____
/ ___/ __ _____ __ ___ __ ___ _/ /_ ____(_)___ / __ | / ___/
\__ \ / / / / _ `_ \/ _ `_ \/ _ \/_ __// __/ / __/ / / / / \__ \
___/ // /_/ / // // / // // / __// / / / / / /_ / /_/ / ___/ /
/____/ \__ /_//_//_/_//_//_/\___/ \_/ /_/ /_/\__/ /_____/ /____/
/____/
+-----------------------------------------------------------------+
| Copyright (C) 2007-2018 JumpMind, Inc. |
| |
| Licensed under the GNU General Public License version 3. |
| This software comes with ABSOLUTELY NO WARRANTY. |
| See http://www.gnu.org/licenses/gpl.html |
+-----------------------------------------------------------------+
2018-10-23 08:00:13,218 INFO [sunserver-000] [AbstractSymmetricEngine] [main] Initializing connection to database
2018-10-23 08:00:13,298 INFO [sunserver-000] [JdbcDatabasePlatformFactory] [main] Detected database 'greenplum', version '5', protocol 'postgresql'
2018-10-23 08:00:13,308 INFO [sunserver-000] [JdbcDatabasePlatformFactory] [main] The IDatabasePlatform being used is org.jumpmind.db.platform.greenplum.GreenplumPlatform
2018-10-23 08:00:13,692 INFO [sunserver-000] [GreenplumSymmetricDialect] [main] The DbDialect being used is org.jumpmind.symmetric.db.postgresql.GreenplumSymmetricDialect
2018-10-23 08:00:13,811 INFO [sunserver-000] [ExtensionService] [main] Found 0 extension points from the database that will be registered
2018-10-23 08:00:13,815 INFO [sunserver-000] [StagingManager] [main] The staging directory was initialized at the following location: /opt/websuite/symmetric-server-3.9.14/tmp/sunserver-000
2018-10-23 08:00:14,277 INFO [sunserver-000] [ExtensionService] [main] Found 0 extension points from the database that will be registered
2018-10-23 08:00:14,278 INFO [sunserver-000] [ClientExtensionService] [main] Found 6 extension points from spring that will be registered
2018-10-23 08:00:14,691 WARN [sunserver-000] [RegistrationService] [main] Registration was already enabled for 001. No need to reenable it
2018-10-23 08:13:26,137 INFO [] [AbstractCommandLauncher] [main] Option: name=engine, value={sunserver-000}
2018-10-23 08:13:26,446 INFO [] [SymmetricUtils] [main]
_____ __ _ ____ _____
/ ___/ __ _____ __ ___ __ ___ _/ /_ ____(_)___ / __ | / ___/
\__ \ / / / / _ `_ \/ _ `_ \/ _ \/_ __// __/ / __/ / / / / \__ \
___/ // /_/ / // // / // // / __// / / / / / /_ / /_/ / ___/ /
/____/ \__ /_//_//_/_//_//_/\___/ \_/ /_/ /_/\__/ /_____/ /____/
/____/
+-----------------------------------------------------------------+
| Copyright (C) 2007-2018 JumpMind, Inc. |
| |
| Licensed under the GNU General Public License version 3. |
| This software comes with ABSOLUTELY NO WARRANTY. |
| See http://www.gnu.org/licenses/gpl.html |
+-----------------------------------------------------------------+
2018-10-23 08:13:26,453 INFO [sunserver-000] [AbstractSymmetricEngine] [main] Initializing connection to database
2018-10-23 08:13:26,533 INFO [sunserver-000] [JdbcDatabasePlatformFactory] [main] Detected database 'greenplum', version '5', protocol 'postgresql'
2018-10-23 08:13:26,543 INFO [sunserver-000] [JdbcDatabasePlatformFactory] [main] The IDatabasePlatform being used is org.jumpmind.db.platform.greenplum.GreenplumPlatform
2018-10-23 08:13:26,952 INFO [sunserver-000] [GreenplumSymmetricDialect] [main] The DbDialect being used is org.jumpmind.symmetric.db.postgresql.GreenplumSymmetricDialect
2018-10-23 08:13:27,065 INFO [sunserver-000] [ExtensionService] [main] Found 0 extension points from the database that will be registered
2018-10-23 08:13:27,072 INFO [sunserver-000] [StagingManager] [main] The staging directory was initialized at the following location: /opt/websuite/symmetric-server-3.9.14/tmp/sunserver-000
2018-10-23 08:13:27,533 INFO [sunserver-000] [ExtensionService] [main] Found 0 extension points from the database that will be registered
2018-10-23 08:13:27,534 INFO [sunserver-000] [ClientExtensionService] [main] Found 6 extension points from spring that will be registered
2018-10-23 08:30:55,809 INFO [] [AbstractCommandLauncher] [main] Option: name=engine, value={sunserver-000}
2018-10-23 08:30:56,120 INFO [] [SymmetricUtils] [main]
_____ __ _ ____ _____
/ ___/ __ _____ __ ___ __ ___ _/ /_ ____(_)___ / __ | / ___/
\__ \ / / / / _ `_ \/ _ `_ \/ _ \/_ __// __/ / __/ / / / / \__ \
___/ // /_/ / // // / // // / __// / / / / / /_ / /_/ / ___/ /
/____/ \__ /_//_//_/_//_//_/\___/ \_/ /_/ /_/\__/ /_____/ /____/
/____/
+-----------------------------------------------------------------+
| Copyright (C) 2007-2018 JumpMind, Inc. |
| |
| Licensed under the GNU General Public License version 3. |
| This software comes with ABSOLUTELY NO WARRANTY. |
| See http://www.gnu.org/licenses/gpl.html |
+-----------------------------------------------------------------+
2018-10-23 08:30:56,127 INFO [sunserver-000] [AbstractSymmetricEngine] [main] Initializing connection to database
2018-10-23 08:30:56,207 INFO [sunserver-000] [JdbcDatabasePlatformFactory] [main] Detected database 'greenplum', version '5', protocol 'postgresql'
2018-10-23 08:30:56,216 INFO [sunserver-000] [JdbcDatabasePlatformFactory] [main] The IDatabasePlatform being used is org.jumpmind.db.platform.greenplum.GreenplumPlatform
2018-10-23 08:30:56,591 INFO [sunserver-000] [GreenplumSymmetricDialect] [main] The DbDialect being used is org.jumpmind.symmetric.db.postgresql.GreenplumSymmetricDialect
2018-10-23 08:30:56,708 INFO [sunserver-000] [ExtensionService] [main] Found 0 extension points from the database that will be registered
2018-10-23 08:30:56,712 INFO [sunserver-000] [StagingManager] [main] The staging directory was initialized at the following location: /opt/websuite/symmetric-server-3.9.14/tmp/sunserver-000
2018-10-23 08:30:57,171 INFO [sunserver-000] [ExtensionService] [main] Found 0 extension points from the database that will be registered
2018-10-23 08:30:57,171 INFO [sunserver-000] [ClientExtensionService] [main] Found 6 extension points from spring that will be registered
2018-10-23 08:30:57,562 WARN [sunserver-000] [RegistrationService] [main] Registration was already enabled for 001. No need to reenable it
2018-10-23 08:31:20,625 INFO [] [AbstractCommandLauncher] [main] Option: name=engine, value={sunserver-000}
2018-10-23 08:31:20,936 INFO [] [SymmetricUtils] [main]
_____ __ _ ____ _____
/ ___/ __ _____ __ ___ __ ___ _/ /_ ____(_)___ / __ | / ___/
\__ \ / / / / _ `_ \/ _ `_ \/ _ \/_ __// __/ / __/ / / / / \__ \
___/ // /_/ / // // / // // / __// / / / / / /_ / /_/ / ___/ /
/____/ \__ /_//_//_/_//_//_/\___/ \_/ /_/ /_/\__/ /_____/ /____/
/____/
+-----------------------------------------------------------------+
| Copyright (C) 2007-2018 JumpMind, Inc. |
| |
| Licensed under the GNU General Public License version 3. |
| This software comes with ABSOLUTELY NO WARRANTY. |
| See http://www.gnu.org/licenses/gpl.html |
+-----------------------------------------------------------------+
2018-10-23 08:31:20,943 INFO [sunserver-000] [AbstractSymmetricEngine] [main] Initializing connection to database
2018-10-23 08:31:21,024 INFO [sunserver-000] [JdbcDatabasePlatformFactory] [main] Detected database 'greenplum', version '5', protocol 'postgresql'
2018-10-23 08:31:21,034 INFO [sunserver-000] [JdbcDatabasePlatformFactory] [main] The IDatabasePlatform being used is org.jumpmind.db.platform.greenplum.GreenplumPlatform
2018-10-23 08:31:21,525 INFO [sunserver-000] [GreenplumSymmetricDialect] [main] The DbDialect being used is org.jumpmind.symmetric.db.postgresql.GreenplumSymmetricDialect
2018-10-23 08:31:21,635 INFO [sunserver-000] [ExtensionService] [main] Found 0 extension points from the database that will be registered
2018-10-23 08:31:21,639 INFO [sunserver-000] [StagingManager] [main] The staging directory was initialized at the following location: /opt/websuite/symmetric-server-3.9.14/tmp/sunserver-000
2018-10-23 08:31:22,093 INFO [sunserver-000] [ExtensionService] [main] Found 0 extension points from the database that will be registered
2018-10-23 08:31:22,094 INFO [sunserver-000] [ClientExtensionService] [main] Found 6 extension points from spring that will be registered
2018-10-23 08:41:06,637 INFO [] [AbstractCommandLauncher] [main] Option: name=engine, value={sunserver-000}
2018-10-23 08:41:06,945 INFO [] [SymmetricUtils] [main]
_____ __ _ ____ _____
/ ___/ __ _____ __ ___ __ ___ _/ /_ ____(_)___ / __ | / ___/
\__ \ / / / / _ `_ \/ _ `_ \/ _ \/_ __// __/ / __/ / / / / \__ \
___/ // /_/ / // // / // // / __// / / / / / /_ / /_/ / ___/ /
/____/ \__ /_//_//_/_//_//_/\___/ \_/ /_/ /_/\__/ /_____/ /____/
/____/
+-----------------------------------------------------------------+
| Copyright (C) 2007-2018 JumpMind, Inc. |
| |
| Licensed under the GNU General Public License version 3. |
| This software comes with ABSOLUTELY NO WARRANTY. |
| See http://www.gnu.org/licenses/gpl.html |
+-----------------------------------------------------------------+
2018-10-23 08:41:06,952 INFO [sunserver-000] [AbstractSymmetricEngine] [main] Initializing connection to database
2018-10-23 08:41:07,033 INFO [sunserver-000] [JdbcDatabasePlatformFactory] [main] Detected database 'greenplum', version '5', protocol 'postgresql'
2018-10-23 08:41:07,043 INFO [sunserver-000] [JdbcDatabasePlatformFactory] [main] The IDatabasePlatform being used is org.jumpmind.db.platform.greenplum.GreenplumPlatform
2018-10-23 08:41:07,425 INFO [sunserver-000] [GreenplumSymmetricDialect] [main] The DbDialect being used is org.jumpmind.symmetric.db.postgresql.GreenplumSymmetricDialect
2018-10-23 08:41:07,543 INFO [sunserver-000] [ExtensionService] [main] Found 0 extension points from the database that will be registered
2018-10-23 08:41:07,554 INFO [sunserver-000] [StagingManager] [main] The staging directory was initialized at the following location: /opt/websuite/symmetric-server-3.9.14/tmp/sunserver-000
2018-10-23 08:41:08,008 INFO [sunserver-000] [ExtensionService] [main] Found 0 extension points from the database that will be registered
2018-10-23 08:41:08,009 INFO [sunserver-000] [ClientExtensionService] [main] Found 6 extension points from spring that will be registered
2018-10-23 08:41:08,398 WARN [sunserver-000] [RegistrationService] [main] Registration was already enabled for 001. No need to reenable it
2018-10-23 08:41:21,332 INFO [] [AbstractCommandLauncher] [main] Option: name=engine, value={sunserver-000}
2018-10-23 08:41:21,646 INFO [] [SymmetricUtils] [main]
_____ __ _ ____ _____
/ ___/ __ _____ __ ___ __ ___ _/ /_ ____(_)___ / __ | / ___/
\__ \ / / / / _ `_ \/ _ `_ \/ _ \/_ __// __/ / __/ / / / / \__ \
___/ // /_/ / // // / // // / __// / / / / / /_ / /_/ / ___/ /
/____/ \__ /_//_//_/_//_//_/\___/ \_/ /_/ /_/\__/ /_____/ /____/
/____/
+-----------------------------------------------------------------+
| Copyright (C) 2007-2018 JumpMind, Inc. |
| |
| Licensed under the GNU General Public License version 3. |
| This software comes with ABSOLUTELY NO WARRANTY. |
| See http://www.gnu.org/licenses/gpl.html |
+-----------------------------------------------------------------+
2018-10-23 08:41:21,653 INFO [sunserver-000] [AbstractSymmetricEngine] [main] Initializing connection to database
2018-10-23 08:41:21,733 INFO [sunserver-000] [JdbcDatabasePlatformFactory] [main] Detected database 'greenplum', version '5', protocol 'postgresql'
2018-10-23 08:41:21,743 INFO [sunserver-000] [JdbcDatabasePlatformFactory] [main] The IDatabasePlatform being used is org.jumpmind.db.platform.greenplum.GreenplumPlatform
2018-10-23 08:41:22,104 INFO [sunserver-000] [GreenplumSymmetricDialect] [main] The DbDialect being used is org.jumpmind.symmetric.db.postgresql.GreenplumSymmetricDialect
2018-10-23 08:41:22,224 INFO [sunserver-000] [ExtensionService] [main] Found 0 extension points from the database that will be registered
2018-10-23 08:41:22,231 INFO [sunserver-000] [StagingManager] [main] The staging directory was initialized at the following location: /opt/websuite/symmetric-server-3.9.14/tmp/sunserver-000
2018-10-23 08:41:22,687 INFO [sunserver-000] [ExtensionService] [main] Found 0 extension points from the database that will be registered
2018-10-23 08:41:22,687 INFO [sunserver-000] [ClientExtensionService] [main] Found 6 extension points from spring that will be registered
2018-10-23 09:55:01,406 INFO [startup] [AbstractCommandLauncher] [main] Option: name=port, value={8888}
2018-10-23 09:55:01,521 INFO [startup] [SymmetricUtils] [main]
_____ __ _ ____ _____
/ ___/ __ _____ __ ___ __ ___ _/ /_ ____(_)___ / __ | / ___/
\__ \ / / / / _ `_ \/ _ `_ \/ _ \/_ __// __/ / __/ / / / / \__ \
___/ // /_/ / // // / // // / __// / / / / / /_ / /_/ / ___/ /
/____/ \__ /_//_//_/_//_//_/\___/ \_/ /_/ /_/\__/ /_____/ /____/
/____/
+-----------------------------------------------------------------+
| Copyright (C) 2007-2018 JumpMind, Inc. |
| |
| Licensed under the GNU General Public License version 3. |
| This software comes with ABSOLUTELY NO WARRANTY. |
| See http://www.gnu.org/licenses/gpl.html |
+-----------------------------------------------------------------+
2018-10-23 09:55:01,552 INFO [startup] [SymmetricWebServer] [main] About to start SymmetricDS web server on host:port 0.0.0.0:8888
2018-10-23 09:55:01,896 INFO [sunserver-000] [AbstractSymmetricEngine] [symmetric-engine-startup-1] Initializing connection to database
2018-10-23 09:55:02,087 INFO [sunserver-000] [JdbcDatabasePlatformFactory] [symmetric-engine-startup-1] Detected database 'greenplum', version '5', protocol 'postgresql'
2018-10-23 09:55:02,099 INFO [sunserver-000] [JdbcDatabasePlatformFactory] [symmetric-engine-startup-1] The IDatabasePlatform being used is org.jumpmind.db.platform.greenplum.GreenplumPlatform
2018-10-23 09:55:02,419 INFO [sunserver-000] [GreenplumSymmetricDialect] [symmetric-engine-startup-1] The DbDialect being used is org.jumpmind.symmetric.db.postgresql.GreenplumSymmetricDialect
2018-10-23 09:55:02,540 INFO [sunserver-000] [ExtensionService] [symmetric-engine-startup-1] Found 0 extension points from the database that will be registered
2018-10-23 09:55:02,544 INFO [sunserver-000] [StagingManager] [symmetric-engine-startup-1] The staging directory was initialized at the following location: /opt/websuite/symmetric-server-3.9.14/tmp/sunserver-000
2018-10-23 09:55:02,890 INFO [startup] [SymmetricWebServer] [main] Starting JMX HTTP console on port 8889
2018-10-23 09:55:02,971 INFO [startup] [SymmetricWebServer] [main] Joining the web server main thread
2018-10-23 09:55:03,027 INFO [sunserver-000] [ExtensionService] [symmetric-engine-startup-1] Found 0 extension points from the database that will be registered
2018-10-23 09:55:03,028 INFO [sunserver-000] [ClientExtensionService] [symmetric-engine-startup-1] Found 7 extension points from spring that will be registered
2018-10-23 09:55:03,033 INFO [sunserver-000] [AbstractSymmetricEngine] [symmetric-engine-startup-1] Initializing SymmetricDS database
2018-10-23 09:55:03,033 INFO [sunserver-000] [GreenplumSymmetricDialect] [symmetric-engine-startup-1] Checking if SymmetricDS tables need created or altered
2018-10-23 09:55:03,375 ERROR [sunserver-000] [GreenplumDdlReader] [symmetric-engine-startup-1] Failed to read table: sym_context. Error: PANIC: ERRORDATA_STACK_SIZE exceeded (elog.c:1416)
2018-10-23 09:55:03,378 ERROR [sunserver-000] [GreenplumDdlReader] [symmetric-engine-startup-1] Failed to get metadata for public.sym_context
2018-10-23 09:55:03,379 ERROR [sunserver-000] [AbstractSymmetricEngine] [symmetric-engine-startup-1] An error occurred while starting SymmetricDS StackTraceKey.init [SqlException:3075436943]
org.jumpmind.db.sql.SqlException: PANIC: ERRORDATA_STACK_SIZE exceeded (elog.c:1416)
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.platform.AbstractJdbcDdlReader.readTable(AbstractJdbcDdlReader.java:562)
at org.jumpmind.db.platform.AbstractDatabasePlatform.readTableFromDatabase(AbstractDatabasePlatform.java:259)
at org.jumpmind.db.platform.AbstractDatabasePlatform.getTableFromCache(AbstractDatabasePlatform.java:328)
at org.jumpmind.db.platform.AbstractDatabasePlatform.readFromDatabase(AbstractDatabasePlatform.java:245)
at org.jumpmind.symmetric.db.AbstractSymmetricDialect.readSymmetricSchemaFromDatabase(AbstractSymmetricDialect.java:593)
at org.jumpmind.symmetric.db.AbstractSymmetricDialect.createOrAlterTablesIfNecessary(AbstractSymmetricDialect.java:502)
at org.jumpmind.symmetric.db.AbstractSymmetricDialect.initTablesAndDatabaseObjects(AbstractSymmetricDialect.java:159)
at org.jumpmind.symmetric.AbstractSymmetricEngine.setupDatabase(AbstractSymmetricEngine.java:501)
at org.jumpmind.symmetric.AbstractSymmetricEngine.setup(AbstractSymmetricEngine.java:475)
at org.jumpmind.symmetric.AbstractSymmetricEngine.start(AbstractSymmetricEngine.java:645)
at org.jumpmind.symmetric.AbstractSymmetricEngine.start(AbstractSymmetricEngine.java:634)
at org.jumpmind.symmetric.ClientSymmetricEngine.start(ClientSymmetricEngine.java:276)
at org.jumpmind.symmetric.web.SymmetricEngineHolder$EngineStarter.run(SymmetricEngineHolder.java:600)
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: PANIC: ERRORDATA_STACK_SIZE exceeded (elog.c:1416)
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.executeQuery(PgStatement.java:224)
at org.postgresql.jdbc.PgDatabaseMetaData.getPrimaryKeys(PgDatabaseMetaData.java:2020)
at org.apache.commons.dbcp.DelegatingDatabaseMetaData.getPrimaryKeys(DelegatingDatabaseMetaData.java:456)
at org.jumpmind.db.platform.DatabaseMetaDataWrapper.getPrimaryKeys(DatabaseMetaDataWrapper.java:167)
at org.jumpmind.db.platform.AbstractJdbcDdlReader.readPrimaryKeyNames(AbstractJdbcDdlReader.java:1002)
at org.jumpmind.db.platform.AbstractJdbcDdlReader.readTable(AbstractJdbcDdlReader.java:692)
at org.jumpmind.db.platform.postgresql.PostgreSqlDdlReader.readTable(PostgreSqlDdlReader.java:65)
at org.jumpmind.db.platform.greenplum.GreenplumDdlReader.readTable(GreenplumDdlReader.java:99)
at org.jumpmind.db.platform.AbstractJdbcDdlReader$3.execute(AbstractJdbcDdlReader.java:577)
at org.jumpmind.db.platform.AbstractJdbcDdlReader$3.execute(AbstractJdbcDdlReader.java:562)
at org.jumpmind.db.sql.JdbcSqlTemplate.execute(JdbcSqlTemplate.java:501)
... 16 more
2018-10-23 09:55:03,397 INFO [sunserver-000] [AbstractSymmetricEngine] [symmetric-engine-startup-1] Stopping SymmetricDS externalId=000 version=3.9.14 database=PostgreSQL
2018-10-23 09:55:03,397 INFO [sunserver-000] [AbstractSymmetricEngine] [symmetric-engine-startup-1]
2018-10-25 15:16:09,581 INFO [] [AbstractCommandLauncher] [main] Option: name=engine, value={corp-000}
2018-10-25 15:16:09,583 INFO [] [AbstractCommandLauncher] [main] Option: name=format, value={XML}
2018-10-25 15:16:09,890 INFO [] [AbstractSymmetricEngine] [main] Initializing connection to database
2018-10-25 15:16:09,957 INFO [] [JdbcDatabasePlatformFactory] [main] Detected database 'greenplum', version '5', protocol 'postgresql'
2018-10-25 15:16:09,973 INFO [] [JdbcDatabasePlatformFactory] [main] The IDatabasePlatform being used is org.jumpmind.db.platform.greenplum.GreenplumPlatform
2018-10-25 15:16:10,057 INFO [] [DefaultDatabaseWriter] [main] About to create table using the following definition:
2018-10-25 15:16:10,262 INFO [] [DefaultDatabaseWriter] [main] About to create table using the following definition:
2018-10-25 15:16:10,460 INFO [] [DefaultDatabaseWriter] [main] About to create table using the following definition:
2018-10-25 15:16:10,614 INFO [] [DefaultDatabaseWriter] [main] About to create table using the following definition:
2018-10-25 15:18:09,461 INFO [] [AbstractCommandLauncher] [main] Option: name=engine, value={corp-000}
2018-10-25 15:18:09,770 INFO [] [SymmetricUtils] [main]
_____ __ _ ____ _____
/ ___/ __ _____ __ ___ __ ___ _/ /_ ____(_)___ / __ | / ___/
\__ \ / / / / _ `_ \/ _ `_ \/ _ \/_ __// __/ / __/ / / / / \__ \
___/ // /_/ / // // / // // / __// / / / / / /_ / /_/ / ___/ /
/____/ \__ /_//_//_/_//_//_/\___/ \_/ /_/ /_/\__/ /_____/ /____/
/____/
+-----------------------------------------------------------------+
| Copyright (C) 2007-2018 JumpMind, Inc. |
| |
| Licensed under the GNU General Public License version 3. |
| This software comes with ABSOLUTELY NO WARRANTY. |
| See http://www.gnu.org/licenses/gpl.html |
+-----------------------------------------------------------------+
2018-10-25 15:18:09,777 INFO [corp-000] [AbstractSymmetricEngine] [main] Initializing connection to database
2018-10-25 15:18:09,857 INFO [corp-000] [JdbcDatabasePlatformFactory] [main] Detected database 'greenplum', version '5', protocol 'postgresql'
2018-10-25 15:18:09,867 INFO [corp-000] [JdbcDatabasePlatformFactory] [main] The IDatabasePlatform being used is org.jumpmind.db.platform.greenplum.GreenplumPlatform
2018-10-25 15:18:09,919 INFO [corp-000] [GreenplumSymmetricDialect] [main] The DbDialect being used is org.jumpmind.symmetric.db.postgresql.GreenplumSymmetricDialect
2018-10-25 15:18:09,942 INFO [corp-000] [StagingManager] [main] The staging directory was initialized at the following location: /opt/websuite/symmetric-server-3.9.14/tmp/corp-000
2018-10-25 15:18:10,477 INFO [corp-000] [ClientExtensionService] [main] Found 6 extension points from spring that will be registered
2018-10-25 15:18:10,478 INFO [corp-000] [AbstractSymmetricEngine] [main] Initializing SymmetricDS database
2018-10-25 15:18:10,478 INFO [corp-000] [GreenplumSymmetricDialect] [main] Checking if SymmetricDS tables need created or altered
2018-10-25 15:18:10,941 INFO [corp-000] [GreenplumSymmetricDialect] [main] There are SymmetricDS tables that needed altered
2018-10-25 15:18:11,098 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_channel"(
"channel_id" VARCHAR(128) NOT NULL,
"processing_order" INTEGER DEFAULT 1 NOT NULL,
"max_batch_size" INTEGER DEFAULT 1000 NOT NULL,
"max_batch_to_send" INTEGER DEFAULT 60 NOT NULL,
"max_data_to_route" INTEGER DEFAULT 100000 NOT NULL,
"extract_period_millis" INTEGER DEFAULT 0 NOT NULL,
"enabled" SMALLINT DEFAULT 1 NOT NULL,
"use_old_data_to_route" SMALLINT DEFAULT 1 NOT NULL,
"use_row_data_to_route" SMALLINT DEFAULT 1 NOT NULL,
"use_pk_data_to_route" SMALLINT DEFAULT 1 NOT NULL,
"reload_flag" SMALLINT DEFAULT 0 NOT NULL,
"file_sync_flag" SMALLINT DEFAULT 0 NOT NULL,
"contains_big_lob" SMALLINT DEFAULT 0 NOT NULL,
"batch_algorithm" VARCHAR(50) DEFAULT 'default' NOT NULL,
"data_loader_type" VARCHAR(50) DEFAULT 'default' NOT NULL,
"description" VARCHAR(255),
"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")
)
2018-10-25 15:18:11,270 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_conflict"(
"conflict_id" VARCHAR(50) NOT NULL,
"source_node_group_id" VARCHAR(50) NOT NULL,
"target_node_group_id" VARCHAR(50) NOT NULL,
"target_channel_id" VARCHAR(128),
"target_catalog_name" VARCHAR(255),
"target_schema_name" VARCHAR(255),
"target_table_name" VARCHAR(255),
"detect_type" VARCHAR(128) NOT NULL,
"detect_expression" 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")
)
2018-10-25 15:18:11,431 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_context"(
"name" VARCHAR(80) NOT NULL,
"context_value" TEXT,
"create_time" TIMESTAMP,
"last_update_time" TIMESTAMP,
PRIMARY KEY ("name")
)
2018-10-25 15:18:11,493 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE SEQUENCE "sym_data_data_id_seq"
2018-10-25 15:18:11,664 INFO [corp-000] [GreenplumSymmetricDialect] [main] 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")
)
2018-10-25 15:18:11,749 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE INDEX "sym_idx_d_channel_id" ON "sym_data" ("data_id", "channel_id")
2018-10-25 15:18:11,857 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_data_event"(
"data_id" BIGINT NOT NULL,
"batch_id" BIGINT NOT NULL,
"router_id" VARCHAR(50) NOT NULL,
"create_time" TIMESTAMP,
PRIMARY KEY ("data_id", "batch_id", "router_id")
)
2018-10-25 15:18:11,942 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE INDEX "sym_idx_de_batchid" ON "sym_data_event" ("batch_id")
2018-10-25 15:18:12,053 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_data_gap"(
"start_id" BIGINT NOT NULL,
"end_id" BIGINT NOT NULL,
"status" CHAR(2),
"create_time" TIMESTAMP NOT NULL,
"last_update_hostname" VARCHAR(255),
"last_update_time" TIMESTAMP NOT NULL,
PRIMARY KEY ("start_id", "end_id")
)
2018-10-25 15:18:12,144 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE INDEX "sym_idx_dg_status" ON "sym_data_gap" ("status")
2018-10-25 15:18:12,315 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_extension"(
"extension_id" VARCHAR(50) NOT NULL,
"extension_type" VARCHAR(10) NOT NULL,
"interface_name" VARCHAR(255),
"node_group_id" VARCHAR(50) NOT NULL,
"enabled" SMALLINT DEFAULT 1 NOT NULL,
"extension_order" INTEGER DEFAULT 1 NOT NULL,
"extension_text" TEXT,
"create_time" TIMESTAMP,
"last_update_by" VARCHAR(50),
"last_update_time" TIMESTAMP,
PRIMARY KEY ("extension_id")
)
2018-10-25 15:18:12,424 INFO [corp-000] [GreenplumSymmetricDialect] [main] 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")
)
2018-10-25 15:18:12,533 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_file_incoming"(
"relative_dir" VARCHAR(255) NOT NULL,
"file_name" VARCHAR(128) NOT NULL,
"last_event_type" CHAR(1) NOT NULL,
"node_id" VARCHAR(50) NOT NULL,
"file_modified_time" BIGINT,
PRIMARY KEY ("relative_dir", "file_name")
)
2018-10-25 15:18:12,646 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_file_snapshot"(
"trigger_id" VARCHAR(128) NOT NULL,
"router_id" VARCHAR(50) NOT NULL,
"relative_dir" VARCHAR(255) NOT NULL,
"file_name" VARCHAR(128) NOT NULL,
"channel_id" VARCHAR(128) DEFAULT 'filesync' NOT NULL,
"reload_channel_id" VARCHAR(128) DEFAULT 'filesync_reload' NOT NULL,
"last_event_type" CHAR(1) NOT NULL,
"crc32_checksum" BIGINT,
"file_size" BIGINT,
"file_modified_time" BIGINT,
"last_update_time" TIMESTAMP NOT NULL,
"last_update_by" VARCHAR(50),
"create_time" TIMESTAMP NOT NULL,
PRIMARY KEY ("trigger_id", "router_id", "relative_dir", "file_name")
)
2018-10-25 15:18:12,732 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE INDEX "sym_idx_f_snpsht_chid" ON "sym_file_snapshot" ("reload_channel_id")
2018-10-25 15:18:12,920 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_file_trigger"(
"trigger_id" VARCHAR(128) NOT NULL,
"channel_id" VARCHAR(128) DEFAULT 'filesync' NOT NULL,
"reload_channel_id" VARCHAR(128) DEFAULT 'filesync_reload' NOT NULL,
"base_dir" VARCHAR(255) NOT NULL,
"recurse" SMALLINT DEFAULT 1 NOT NULL,
"includes_files" VARCHAR(255),
"excludes_files" VARCHAR(255),
"sync_on_create" SMALLINT DEFAULT 1 NOT NULL,
"sync_on_modified" SMALLINT DEFAULT 1 NOT NULL,
"sync_on_delete" SMALLINT DEFAULT 1 NOT NULL,
"sync_on_ctl_file" SMALLINT DEFAULT 0 NOT NULL,
"delete_after_sync" SMALLINT DEFAULT 0 NOT NULL,
"before_copy_script" 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")
)
2018-10-25 15:18:13,082 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_file_trigger_router"(
"trigger_id" VARCHAR(128) NOT NULL,
"router_id" VARCHAR(50) NOT NULL,
"enabled" SMALLINT DEFAULT 1 NOT NULL,
"initial_load_enabled" SMALLINT DEFAULT 1 NOT NULL,
"target_base_dir" VARCHAR(255),
"conflict_strategy" VARCHAR(128) DEFAULT 'source_wins' NOT NULL,
"create_time" TIMESTAMP NOT NULL,
"last_update_by" VARCHAR(50),
"last_update_time" TIMESTAMP NOT NULL,
"description" TEXT,
PRIMARY KEY ("trigger_id", "router_id")
)
2018-10-25 15:18:13,186 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_grouplet"(
"grouplet_id" VARCHAR(50) NOT NULL,
"grouplet_link_policy" CHAR(1) DEFAULT 'I' NOT NULL,
"description" VARCHAR(255),
"create_time" TIMESTAMP NOT NULL,
"last_update_by" VARCHAR(50),
"last_update_time" TIMESTAMP NOT NULL,
PRIMARY KEY ("grouplet_id")
)
2018-10-25 15:18:13,288 INFO [corp-000] [GreenplumSymmetricDialect] [main] 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")
)
2018-10-25 15:18:13,483 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_incoming_batch"(
"batch_id" BIGINT NOT NULL,
"node_id" VARCHAR(50) NOT NULL,
"channel_id" VARCHAR(128),
"status" CHAR(2),
"error_flag" SMALLINT DEFAULT 0,
"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")
)
2018-10-25 15:18:13,579 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE INDEX "sym_idx_ib_time_status" ON "sym_incoming_batch" ("create_time", "status")
2018-10-25 15:18:13,668 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE INDEX "sym_idx_ib_in_error" ON "sym_incoming_batch" ("error_flag")
2018-10-25 15:18:13,840 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_incoming_error"(
"batch_id" BIGINT NOT NULL,
"node_id" VARCHAR(50) NOT NULL,
"failed_row_number" BIGINT NOT NULL,
"failed_line_number" BIGINT DEFAULT 0 NOT NULL,
"target_catalog_name" VARCHAR(255),
"target_schema_name" VARCHAR(255),
"target_table_name" VARCHAR(255) NOT NULL,
"event_type" CHAR(1) NOT NULL,
"binary_encoding" VARCHAR(10) DEFAULT 'HEX' NOT NULL,
"column_names" 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")
)
2018-10-25 15:18:14,012 INFO [corp-000] [GreenplumSymmetricDialect] [main] 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")
)
2018-10-25 15:18:14,196 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_load_filter"(
"load_filter_id" VARCHAR(50) NOT NULL,
"load_filter_type" VARCHAR(10) NOT NULL,
"source_node_group_id" VARCHAR(50) NOT NULL,
"target_node_group_id" VARCHAR(50) NOT NULL,
"target_catalog_name" VARCHAR(255),
"target_schema_name" VARCHAR(255),
"target_table_name" VARCHAR(255),
"filter_on_update" SMALLINT DEFAULT 1 NOT NULL,
"filter_on_insert" SMALLINT DEFAULT 1 NOT NULL,
"filter_on_delete" SMALLINT DEFAULT 1 NOT NULL,
"before_write_script" 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")
)
2018-10-25 15:18:14,312 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_lock"(
"lock_action" VARCHAR(50) NOT NULL,
"lock_type" VARCHAR(50) NOT NULL,
"locking_server_id" VARCHAR(255),
"lock_time" TIMESTAMP,
"shared_count" INTEGER DEFAULT 0 NOT NULL,
"shared_enable" INTEGER DEFAULT 0 NOT NULL,
"last_lock_time" TIMESTAMP,
"last_locking_server_id" VARCHAR(255),
PRIMARY KEY ("lock_action")
)
2018-10-25 15:18:14,432 INFO [corp-000] [GreenplumSymmetricDialect] [main] 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")
)
2018-10-25 15:18:14,552 INFO [corp-000] [GreenplumSymmetricDialect] [main] 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")
)
2018-10-25 15:18:14,663 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_node_channel_ctl"(
"node_id" VARCHAR(50) NOT NULL,
"channel_id" VARCHAR(128) NOT NULL,
"suspend_enabled" SMALLINT DEFAULT 0,
"ignore_enabled" SMALLINT DEFAULT 0,
"last_extract_time" TIMESTAMP,
PRIMARY KEY ("node_id", "channel_id")
)
2018-10-25 15:18:14,771 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_node_group"(
"node_group_id" VARCHAR(50) NOT NULL,
"description" VARCHAR(255),
"create_time" TIMESTAMP,
"last_update_by" VARCHAR(50),
"last_update_time" TIMESTAMP,
PRIMARY KEY ("node_group_id")
)
2018-10-25 15:18:14,876 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_node_group_channel_wnd"(
"node_group_id" VARCHAR(50) NOT NULL,
"channel_id" VARCHAR(128) NOT NULL,
"start_time" TIMESTAMP NOT NULL,
"end_time" TIMESTAMP NOT NULL,
"enabled" SMALLINT DEFAULT 0 NOT NULL,
PRIMARY KEY ("node_group_id", "channel_id", "start_time", "end_time")
)
2018-10-25 15:18:14,983 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_node_group_link"(
"source_node_group_id" VARCHAR(50) NOT NULL,
"target_node_group_id" VARCHAR(50) NOT NULL,
"data_event_action" CHAR(1) DEFAULT 'W' NOT NULL,
"sync_config_enabled" SMALLINT DEFAULT 1 NOT NULL,
"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")
)
2018-10-25 15:18:15,089 INFO [corp-000] [GreenplumSymmetricDialect] [main] 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")
)
2018-10-25 15:18:15,207 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_node_host_channel_stats"(
"node_id" VARCHAR(50) NOT NULL,
"host_name" VARCHAR(60) NOT NULL,
"channel_id" VARCHAR(128) NOT NULL,
"start_time" TIMESTAMP NOT NULL,
"end_time" TIMESTAMP NOT NULL,
"data_routed" BIGINT DEFAULT 0,
"data_unrouted" BIGINT DEFAULT 0,
"data_event_inserted" BIGINT DEFAULT 0,
"data_extracted" BIGINT DEFAULT 0,
"data_bytes_extracted" BIGINT DEFAULT 0,
"data_extracted_errors" BIGINT DEFAULT 0,
"data_bytes_sent" BIGINT DEFAULT 0,
"data_sent" BIGINT DEFAULT 0,
"data_sent_errors" BIGINT DEFAULT 0,
"data_loaded" BIGINT DEFAULT 0,
"data_bytes_loaded" BIGINT DEFAULT 0,
"data_loaded_errors" BIGINT DEFAULT 0,
PRIMARY KEY ("node_id", "host_name", "channel_id", "start_time", "end_time")
)
2018-10-25 15:18:15,299 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE INDEX "sym_idx_nd_hst_chnl_sts" ON "sym_node_host_channel_stats" ("node_id", "start_time", "end_time")
2018-10-25 15:18:15,408 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_node_host_job_stats"(
"node_id" VARCHAR(50) NOT NULL,
"host_name" VARCHAR(60) NOT NULL,
"job_name" VARCHAR(50) NOT NULL,
"start_time" TIMESTAMP NOT NULL,
"end_time" TIMESTAMP NOT NULL,
"processed_count" BIGINT DEFAULT 0,
"target_node_id" VARCHAR(50),
"target_node_count" INTEGER DEFAULT 0,
PRIMARY KEY ("node_id", "host_name", "job_name", "start_time", "end_time")
)
2018-10-25 15:18:15,489 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE INDEX "sym_idx_nd_hst_job" ON "sym_node_host_job_stats" ("node_id", "start_time", "end_time")
2018-10-25 15:18:15,605 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_node_host_stats"(
"node_id" VARCHAR(50) NOT NULL,
"host_name" VARCHAR(60) NOT NULL,
"start_time" TIMESTAMP NOT NULL,
"end_time" TIMESTAMP NOT NULL,
"restarted" BIGINT DEFAULT 0 NOT NULL,
"nodes_pulled" BIGINT DEFAULT 0,
"total_nodes_pull_time" BIGINT DEFAULT 0,
"nodes_pushed" BIGINT DEFAULT 0,
"total_nodes_push_time" BIGINT DEFAULT 0,
"nodes_rejected" BIGINT DEFAULT 0,
"nodes_registered" BIGINT DEFAULT 0,
"nodes_loaded" BIGINT DEFAULT 0,
"nodes_disabled" BIGINT DEFAULT 0,
"purged_data_rows" BIGINT DEFAULT 0,
"purged_data_event_rows" BIGINT DEFAULT 0,
"purged_batch_outgoing_rows" BIGINT DEFAULT 0,
"purged_batch_incoming_rows" BIGINT DEFAULT 0,
"triggers_created_count" BIGINT,
"triggers_rebuilt_count" BIGINT,
"triggers_removed_count" BIGINT,
PRIMARY KEY ("node_id", "host_name", "start_time", "end_time")
)
2018-10-25 15:18:15,695 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE INDEX "sym_idx_nd_hst_sts" ON "sym_node_host_stats" ("node_id", "start_time", "end_time")
2018-10-25 15:18:15,804 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_node_identity"(
"node_id" VARCHAR(50) NOT NULL,
PRIMARY KEY ("node_id")
)
2018-10-25 15:18:15,913 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_node_security"(
"node_id" VARCHAR(50) NOT NULL,
"node_password" VARCHAR(50) NOT NULL,
"registration_enabled" SMALLINT DEFAULT 0,
"registration_time" TIMESTAMP,
"initial_load_enabled" SMALLINT DEFAULT 0,
"initial_load_time" TIMESTAMP,
"initial_load_id" BIGINT,
"initial_load_create_by" VARCHAR(255),
"rev_initial_load_enabled" SMALLINT DEFAULT 0,
"rev_initial_load_time" TIMESTAMP,
"rev_initial_load_id" BIGINT,
"rev_initial_load_create_by" VARCHAR(255),
"created_at_node_id" VARCHAR(50),
PRIMARY KEY ("node_id")
)
2018-10-25 15:18:16,090 INFO [corp-000] [GreenplumSymmetricDialect] [main] 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")
)
2018-10-25 15:18:16,258 INFO [corp-000] [GreenplumSymmetricDialect] [main] 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")
)
2018-10-25 15:18:16,426 INFO [corp-000] [GreenplumSymmetricDialect] [main] 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")
)
2018-10-25 15:18:16,607 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_outgoing_batch"(
"batch_id" BIGINT NOT NULL,
"node_id" VARCHAR(50) NOT NULL,
"channel_id" VARCHAR(128),
"status" CHAR(2),
"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")
)
2018-10-25 15:18:16,690 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE INDEX "sym_idx_ob_node_status" ON "sym_outgoing_batch" ("node_id", "status")
2018-10-25 15:18:16,781 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE INDEX "sym_idx_ob_status" ON "sym_outgoing_batch" ("status")
2018-10-25 15:18:16,875 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE INDEX "sym_idx_ob_in_error" ON "sym_outgoing_batch" ("error_flag")
2018-10-25 15:18:17,051 INFO [corp-000] [GreenplumSymmetricDialect] [main] 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")
)
2018-10-25 15:18:17,171 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_registration_redirect"(
"registrant_external_id" VARCHAR(255) NOT NULL,
"registration_node_id" VARCHAR(50) NOT NULL,
PRIMARY KEY ("registrant_external_id")
)
2018-10-25 15:18:17,338 INFO [corp-000] [GreenplumSymmetricDialect] [main] 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")
)
2018-10-25 15:18:17,451 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE INDEX "sym_idx_reg_req_1" ON "sym_registration_request" ("node_group_id", "external_id", "status", "host_name", "ip_address")
2018-10-25 15:18:17,529 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE INDEX "sym_idx_reg_req_2" ON "sym_registration_request" ("status")
2018-10-25 15:18:17,689 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_router"(
"router_id" VARCHAR(50) NOT NULL,
"target_catalog_name" VARCHAR(255),
"target_schema_name" VARCHAR(255),
"target_table_name" VARCHAR(255),
"source_node_group_id" VARCHAR(50) NOT NULL,
"target_node_group_id" VARCHAR(50) NOT NULL,
"router_type" VARCHAR(50),
"router_expression" 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")
)
2018-10-25 15:18:17,790 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_sequence"(
"sequence_name" VARCHAR(50) NOT NULL,
"current_value" BIGINT DEFAULT 0 NOT NULL,
"increment_by" INTEGER DEFAULT 1 NOT NULL,
"min_value" BIGINT DEFAULT 1 NOT NULL,
"max_value" BIGINT DEFAULT 9999999999 NOT NULL,
"cycle_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")
)
2018-10-25 15:18:17,946 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_table_reload_request"(
"target_node_id" VARCHAR(50) NOT NULL,
"source_node_id" VARCHAR(50) NOT NULL,
"trigger_id" VARCHAR(128) NOT NULL,
"router_id" VARCHAR(50) NOT NULL,
"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")
)
2018-10-25 15:18:18,105 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_transform_table"(
"transform_id" VARCHAR(50) NOT NULL,
"source_node_group_id" VARCHAR(50) NOT NULL,
"target_node_group_id" VARCHAR(50) NOT NULL,
"transform_point" VARCHAR(10) NOT NULL,
"source_catalog_name" VARCHAR(255),
"source_schema_name" VARCHAR(255),
"source_table_name" VARCHAR(255) NOT NULL,
"target_catalog_name" VARCHAR(255),
"target_schema_name" VARCHAR(255),
"target_table_name" VARCHAR(255),
"update_first" SMALLINT DEFAULT 0,
"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")
)
2018-10-25 15:18:18,269 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_transform_column"(
"transform_id" VARCHAR(50) NOT NULL,
"include_on" CHAR(1) DEFAULT '*' NOT NULL,
"target_column_name" VARCHAR(128) NOT NULL,
"source_column_name" VARCHAR(128),
"pk" SMALLINT DEFAULT 0,
"transform_type" VARCHAR(50) DEFAULT 'copy',
"transform_expression" 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")
)
2018-10-25 15:18:18,459 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_trigger"(
"trigger_id" VARCHAR(128) NOT NULL,
"source_catalog_name" VARCHAR(255),
"source_schema_name" VARCHAR(255),
"source_table_name" VARCHAR(255) NOT NULL,
"channel_id" VARCHAR(128) NOT NULL,
"reload_channel_id" VARCHAR(128) DEFAULT 'reload' NOT NULL,
"sync_on_update" SMALLINT DEFAULT 1 NOT NULL,
"sync_on_insert" SMALLINT DEFAULT 1 NOT NULL,
"sync_on_delete" SMALLINT DEFAULT 1 NOT NULL,
"sync_on_incoming_batch" SMALLINT DEFAULT 0 NOT NULL,
"name_for_update_trigger" VARCHAR(255),
"name_for_insert_trigger" VARCHAR(255),
"name_for_delete_trigger" VARCHAR(255),
"sync_on_update_condition" 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")
)
2018-10-25 15:18:18,627 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_trigger_hist"(
"trigger_hist_id" INTEGER NOT NULL,
"trigger_id" VARCHAR(128) NOT NULL,
"source_table_name" VARCHAR(255) NOT NULL,
"source_catalog_name" VARCHAR(255),
"source_schema_name" VARCHAR(255),
"name_for_update_trigger" VARCHAR(255),
"name_for_insert_trigger" VARCHAR(255),
"name_for_delete_trigger" VARCHAR(255),
"table_hash" BIGINT DEFAULT 0 NOT NULL,
"trigger_row_hash" BIGINT DEFAULT 0 NOT NULL,
"trigger_template_hash" BIGINT DEFAULT 0 NOT NULL,
"column_names" 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")
)
2018-10-25 15:18:18,724 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE INDEX "sym_idx_trigg_hist_1" ON "sym_trigger_hist" ("trigger_id", "inactive_time")
2018-10-25 15:18:18,901 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_trigger_router"(
"trigger_id" VARCHAR(128) NOT NULL,
"router_id" VARCHAR(50) NOT NULL,
"enabled" SMALLINT DEFAULT 1 NOT NULL,
"initial_load_order" INTEGER DEFAULT 1 NOT NULL,
"initial_load_select" 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")
)
2018-10-25 15:18:19,011 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_trigger_router_grouplet"(
"grouplet_id" VARCHAR(50) NOT NULL,
"trigger_id" VARCHAR(128) NOT NULL,
"router_id" VARCHAR(50) NOT NULL,
"applies_when" CHAR(1) NOT NULL,
"create_time" TIMESTAMP NOT NULL,
"last_update_by" VARCHAR(50),
"last_update_time" TIMESTAMP NOT NULL,
PRIMARY KEY ("grouplet_id", "trigger_id", "router_id", "applies_when")
)
2018-10-25 15:18:19,042 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: ALTER TABLE "sym_conflict"
ADD CONSTRAINT "sym_fk_cf_2_grp_lnk" FOREIGN KEY ("source_node_group_id", "target_node_group_id") REFERENCES "sym_node_group_link" ("source_node_group_id", "target_node_group_id")
2018-10-25 15:18:19,070 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: ALTER TABLE "sym_file_trigger_router"
ADD CONSTRAINT "sym_fk_ftr_2_ftrg" FOREIGN KEY ("trigger_id") REFERENCES "sym_file_trigger" ("trigger_id")
2018-10-25 15:18:19,098 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: ALTER TABLE "sym_file_trigger_router"
ADD CONSTRAINT "sym_fk_ftr_2_rtr" FOREIGN KEY ("router_id") REFERENCES "sym_router" ("router_id")
2018-10-25 15:18:19,134 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: ALTER TABLE "sym_grouplet_link"
ADD CONSTRAINT "sym_fk_gpltlnk_2_gplt" FOREIGN KEY ("grouplet_id") REFERENCES "sym_grouplet" ("grouplet_id")
2018-10-25 15:18:19,166 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: ALTER TABLE "sym_node_group_link"
ADD CONSTRAINT "sym_fk_lnk_2_grp_src" FOREIGN KEY ("source_node_group_id") REFERENCES "sym_node_group" ("node_group_id")
2018-10-25 15:18:19,201 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: ALTER TABLE "sym_node_group_link"
ADD CONSTRAINT "sym_fk_lnk_2_grp_tgt" FOREIGN KEY ("target_node_group_id") REFERENCES "sym_node_group" ("node_group_id")
2018-10-25 15:18:19,238 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: ALTER TABLE "sym_node_identity"
ADD CONSTRAINT "sym_fk_ident_2_node" FOREIGN KEY ("node_id") REFERENCES "sym_node" ("node_id")
2018-10-25 15:18:19,270 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: ALTER TABLE "sym_node_security"
ADD CONSTRAINT "sym_fk_sec_2_node" FOREIGN KEY ("node_id") REFERENCES "sym_node" ("node_id")
2018-10-25 15:18:19,301 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: ALTER TABLE "sym_router"
ADD CONSTRAINT "sym_fk_rt_2_grp_lnk" FOREIGN KEY ("source_node_group_id", "target_node_group_id") REFERENCES "sym_node_group_link" ("source_node_group_id", "target_node_group_id")
2018-10-25 15:18:19,340 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: ALTER TABLE "sym_transform_table"
ADD CONSTRAINT "sym_fk_tt_2_grp_lnk" FOREIGN KEY ("source_node_group_id", "target_node_group_id") REFERENCES "sym_node_group_link" ("source_node_group_id", "target_node_group_id")
2018-10-25 15:18:19,371 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: ALTER TABLE "sym_trigger"
ADD CONSTRAINT "sym_fk_trg_2_chnl" FOREIGN KEY ("channel_id") REFERENCES "sym_channel" ("channel_id")
2018-10-25 15:18:19,403 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: ALTER TABLE "sym_trigger"
ADD CONSTRAINT "sym_fk_trg_2_rld_chnl" FOREIGN KEY ("reload_channel_id") REFERENCES "sym_channel" ("channel_id")
2018-10-25 15:18:19,439 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: ALTER TABLE "sym_trigger_router"
ADD CONSTRAINT "sym_fk_tr_2_trg" FOREIGN KEY ("trigger_id") REFERENCES "sym_trigger" ("trigger_id")
2018-10-25 15:18:19,473 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: ALTER TABLE "sym_trigger_router"
ADD CONSTRAINT "sym_fk_tr_2_rtr" FOREIGN KEY ("router_id") REFERENCES "sym_router" ("router_id")
2018-10-25 15:18:19,523 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: ALTER TABLE "sym_trigger_router_grouplet"
ADD CONSTRAINT "sym_fk_trgplt_2_gplt" FOREIGN KEY ("grouplet_id") REFERENCES "sym_grouplet" ("grouplet_id")
2018-10-25 15:18:19,562 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: ALTER TABLE "sym_trigger_router_grouplet"
ADD CONSTRAINT "sym_fk_trgplt_2_tr" FOREIGN KEY ("trigger_id", "router_id") REFERENCES "sym_trigger_router" ("trigger_id", "router_id")
2018-10-25 15:18:19,668 INFO [corp-000] [GreenplumSymmetricDialect] [main] Done with auto update of SymmetricDS tables
2018-10-25 15:18:19,747 INFO [corp-000] [ConfigurationService] [main] Auto-configuring config channel
2018-10-25 15:18:19,858 INFO [corp-000] [ConfigurationService] [main] Auto-configuring reload channel
2018-10-25 15:18:19,939 INFO [corp-000] [ConfigurationService] [main] Auto-configuring monitor channel
2018-10-25 15:18:20,041 INFO [corp-000] [ConfigurationService] [main] Auto-configuring heartbeat channel
2018-10-25 15:18:20,120 INFO [corp-000] [ConfigurationService] [main] Auto-configuring default channel
2018-10-25 15:18:20,214 INFO [corp-000] [ConfigurationService] [main] Auto-configuring dynamic channel
2018-10-25 15:18:20,942 INFO [corp-000] [AbstractSymmetricEngine] [main] Inserting rows for node, security, identity and group for registration server
2018-10-25 15:18:21,547 INFO [corp-000] [AbstractSymmetricEngine] [main] Done initializing SymmetricDS database
2018-10-25 15:20:53,645 INFO [] [AbstractCommandLauncher] [main] Option: name=engine, value={corp-000}
2018-10-25 15:20:53,835 INFO [] [AbstractSymmetricEngine] [main] Initializing connection to database
2018-10-25 15:20:53,893 INFO [] [JdbcDatabasePlatformFactory] [main] Detected database 'greenplum', version '5', protocol 'postgresql'
2018-10-25 15:20:53,906 INFO [] [JdbcDatabasePlatformFactory] [main] The IDatabasePlatform being used is org.jumpmind.db.platform.greenplum.GreenplumPlatform
2018-10-25 15:28:09,358 INFO [startup] [AbstractCommandLauncher] [main] Option: name=engine, value={corp-000}
2018-10-25 15:28:09,359 INFO [startup] [AbstractCommandLauncher] [main] Option: name=port, value={8888}
2018-10-25 15:28:09,479 INFO [startup] [SymmetricUtils] [main]
_____ __ _ ____ _____
/ ___/ __ _____ __ ___ __ ___ _/ /_ ____(_)___ / __ | / ___/
\__ \ / / / / _ `_ \/ _ `_ \/ _ \/_ __// __/ / __/ / / / / \__ \
___/ // /_/ / // // / // // / __// / / / / / /_ / /_/ / ___/ /
/____/ \__ /_//_//_/_//_//_/\___/ \_/ /_/ /_/\__/ /_____/ /____/
/____/
+-----------------------------------------------------------------+
| Copyright (C) 2007-2018 JumpMind, Inc. |
| |
| Licensed under the GNU General Public License version 3. |
| This software comes with ABSOLUTELY NO WARRANTY. |
| See http://www.gnu.org/licenses/gpl.html |
+-----------------------------------------------------------------+
2018-10-25 15:28:09,515 INFO [startup] [SymmetricWebServer] [main] About to start SymmetricDS web server on host:port 0.0.0.0:8888
2018-10-25 15:28:09,884 INFO [corp-000] [AbstractSymmetricEngine] [symmetric-engine-startup-1] Initializing connection to database
2018-10-25 15:28:10,067 INFO [corp-000] [JdbcDatabasePlatformFactory] [symmetric-engine-startup-1] Detected database 'greenplum', version '5', protocol 'postgresql'
2018-10-25 15:28:10,079 INFO [corp-000] [JdbcDatabasePlatformFactory] [symmetric-engine-startup-1] The IDatabasePlatform being used is org.jumpmind.db.platform.greenplum.GreenplumPlatform
2018-10-25 15:28:10,381 INFO [corp-000] [GreenplumSymmetricDialect] [symmetric-engine-startup-1] The DbDialect being used is org.jumpmind.symmetric.db.postgresql.GreenplumSymmetricDialect
2018-10-25 15:28:10,485 INFO [corp-000] [ExtensionService] [symmetric-engine-startup-1] Found 0 extension points from the database that will be registered
2018-10-25 15:28:10,496 INFO [corp-000] [StagingManager] [symmetric-engine-startup-1] The staging directory was initialized at the following location: /opt/websuite/symmetric-server-3.9.14/tmp/corp-000
2018-10-25 15:28:10,980 INFO [startup] [SymmetricWebServer] [main] Starting JMX HTTP console on port 8889
2018-10-25 15:28:10,999 INFO [startup] [SymmetricWebServer] [main] Joining the web server main thread
2018-10-25 15:28:11,005 INFO [corp-000] [ExtensionService] [symmetric-engine-startup-1] Found 0 extension points from the database that will be registered
2018-10-25 15:28:11,005 INFO [corp-000] [ClientExtensionService] [symmetric-engine-startup-1] Found 7 extension points from spring that will be registered
2018-10-25 15:28:11,011 INFO [corp-000] [AbstractSymmetricEngine] [symmetric-engine-startup-1] Initializing SymmetricDS database
2018-10-25 15:28:11,011 INFO [corp-000] [GreenplumSymmetricDialect] [symmetric-engine-startup-1] Checking if SymmetricDS tables need created or altered
2018-10-25 15:28:11,294 ERROR [corp-000] [GreenplumDdlReader] [symmetric-engine-startup-1] Failed to read table: sym_context. Error: PANIC: ERRORDATA_STACK_SIZE exceeded (elog.c:1416)
2018-10-25 15:28:11,297 ERROR [corp-000] [GreenplumDdlReader] [symmetric-engine-startup-1] Failed to get metadata for public.sym_context
2018-10-25 15:28:11,297 ERROR [corp-000] [AbstractSymmetricEngine] [symmetric-engine-startup-1] An error occurred while starting SymmetricDS StackTraceKey.init [SqlException:3075436943]
org.jumpmind.db.sql.SqlException: PANIC: ERRORDATA_STACK_SIZE exceeded (elog.c:1416)
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.platform.AbstractJdbcDdlReader.readTable(AbstractJdbcDdlReader.java:562)
at org.jumpmind.db.platform.AbstractDatabasePlatform.readTableFromDatabase(AbstractDatabasePlatform.java:259)
at org.jumpmind.db.platform.AbstractDatabasePlatform.getTableFromCache(AbstractDatabasePlatform.java:328)
at org.jumpmind.db.platform.AbstractDatabasePlatform.readFromDatabase(AbstractDatabasePlatform.java:245)
at org.jumpmind.symmetric.db.AbstractSymmetricDialect.readSymmetricSchemaFromDatabase(AbstractSymmetricDialect.java:593)
at org.jumpmind.symmetric.db.AbstractSymmetricDialect.createOrAlterTablesIfNecessary(AbstractSymmetricDialect.java:502)
at org.jumpmind.symmetric.db.AbstractSymmetricDialect.initTablesAndDatabaseObjects(AbstractSymmetricDialect.java:159)
at org.jumpmind.symmetric.AbstractSymmetricEngine.setupDatabase(AbstractSymmetricEngine.java:501)
at org.jumpmind.symmetric.AbstractSymmetricEngine.setup(AbstractSymmetricEngine.java:475)
at org.jumpmind.symmetric.AbstractSymmetricEngine.start(AbstractSymmetricEngine.java:645)
at org.jumpmind.symmetric.AbstractSymmetricEngine.start(AbstractSymmetricEngine.java:634)
at org.jumpmind.symmetric.ClientSymmetricEngine.start(ClientSymmetricEngine.java:276)
at org.jumpmind.symmetric.web.SymmetricEngineHolder$EngineStarter.run(SymmetricEngineHolder.java:600)
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: PANIC: ERRORDATA_STACK_SIZE exceeded (elog.c:1416)
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.executeQuery(PgStatement.java:224)
at org.postgresql.jdbc.PgDatabaseMetaData.getPrimaryKeys(PgDatabaseMetaData.java:2020)
at org.apache.commons.dbcp.DelegatingDatabaseMetaData.getPrimaryKeys(DelegatingDatabaseMetaData.java:456)
at org.jumpmind.db.platform.DatabaseMetaDataWrapper.getPrimaryKeys(DatabaseMetaDataWrapper.java:167)
at org.jumpmind.db.platform.AbstractJdbcDdlReader.readPrimaryKeyNames(AbstractJdbcDdlReader.java:1002)
at org.jumpmind.db.platform.AbstractJdbcDdlReader.readTable(AbstractJdbcDdlReader.java:692)
at org.jumpmind.db.platform.postgresql.PostgreSqlDdlReader.readTable(PostgreSqlDdlReader.java:65)
at org.jumpmind.db.platform.greenplum.GreenplumDdlReader.readTable(GreenplumDdlReader.java:99)
at org.jumpmind.db.platform.AbstractJdbcDdlReader$3.execute(AbstractJdbcDdlReader.java:577)
at org.jumpmind.db.platform.AbstractJdbcDdlReader$3.execute(AbstractJdbcDdlReader.java:562)
at org.jumpmind.db.sql.JdbcSqlTemplate.execute(JdbcSqlTemplate.java:501)
... 16 more
2018-10-25 15:28:11,316 INFO [corp-000] [AbstractSymmetricEngine] [symmetric-engine-startup-1] Stopping SymmetricDS externalId=000 version=3.9.14 database=PostgreSQL
2018-10-25 15:28:11,317 INFO [corp-000] [AbstractSymmetricEngine] [symmetric-engine-startup-1]
2018-10-25 15:44:10,345 INFO [startup] [AbstractCommandLauncher] [main] Option: name=engine, value={corp-000}
2018-10-25 15:44:10,346 INFO [startup] [AbstractCommandLauncher] [main] Option: name=port, value={8888}
2018-10-25 15:44:10,467 INFO [startup] [SymmetricUtils] [main]
_____ __ _ ____ _____
/ ___/ __ _____ __ ___ __ ___ _/ /_ ____(_)___ / __ | / ___/
\__ \ / / / / _ `_ \/ _ `_ \/ _ \/_ __// __/ / __/ / / / / \__ \
___/ // /_/ / // // / // // / __// / / / / / /_ / /_/ / ___/ /
/____/ \__ /_//_//_/_//_//_/\___/ \_/ /_/ /_/\__/ /_____/ /____/
/____/
+-----------------------------------------------------------------+
| Copyright (C) 2007-2018 JumpMind, Inc. |
| |
| Licensed under the GNU General Public License version 3. |
| This software comes with ABSOLUTELY NO WARRANTY. |
| See http://www.gnu.org/licenses/gpl.html |
+-----------------------------------------------------------------+
2018-10-25 15:44:10,497 INFO [startup] [SymmetricWebServer] [main] About to start SymmetricDS web server on host:port 0.0.0.0:8888
2018-10-25 15:44:10,829 INFO [corp-000] [AbstractSymmetricEngine] [symmetric-engine-startup-1] Initializing connection to database
2018-10-25 15:44:11,062 INFO [corp-000] [JdbcDatabasePlatformFactory] [symmetric-engine-startup-1] Detected database 'greenplum', version '5', protocol 'postgresql'
2018-10-25 15:44:11,074 INFO [corp-000] [JdbcDatabasePlatformFactory] [symmetric-engine-startup-1] The IDatabasePlatform being used is org.jumpmind.db.platform.greenplum.GreenplumPlatform
2018-10-25 15:44:11,414 INFO [corp-000] [GreenplumSymmetricDialect] [symmetric-engine-startup-1] The DbDialect being used is org.jumpmind.symmetric.db.postgresql.GreenplumSymmetricDialect
2018-10-25 15:44:11,516 INFO [corp-000] [ExtensionService] [symmetric-engine-startup-1] Found 0 extension points from the database that will be registered
2018-10-25 15:44:11,519 INFO [corp-000] [StagingManager] [symmetric-engine-startup-1] The staging directory was initialized at the following location: /opt/websuite/symmetric-server-3.9.14/tmp/corp-000
2018-10-25 15:44:11,679 INFO [startup] [SymmetricWebServer] [main] Starting JMX HTTP console on port 8889
2018-10-25 15:44:11,691 INFO [startup] [SymmetricWebServer] [main] Joining the web server main thread
2018-10-25 15:44:11,951 INFO [corp-000] [ExtensionService] [symmetric-engine-startup-1] Found 0 extension points from the database that will be registered
2018-10-25 15:44:11,951 INFO [corp-000] [ClientExtensionService] [symmetric-engine-startup-1] Found 7 extension points from spring that will be registered
2018-10-25 15:44:11,957 INFO [corp-000] [AbstractSymmetricEngine] [symmetric-engine-startup-1] Initializing SymmetricDS database
2018-10-25 15:44:11,957 INFO [corp-000] [GreenplumSymmetricDialect] [symmetric-engine-startup-1] Checking if SymmetricDS tables need created or altered
2018-10-25 15:44:12,124 ERROR [corp-000] [GreenplumDdlReader] [symmetric-engine-startup-1] Failed to read table: sym_context. Error: PANIC: ERRORDATA_STACK_SIZE exceeded (elog.c:1416)
2018-10-25 15:44:12,126 ERROR [corp-000] [GreenplumDdlReader] [symmetric-engine-startup-1] Failed to get metadata for public.sym_context
2018-10-25 15:44:12,126 ERROR [corp-000] [AbstractSymmetricEngine] [symmetric-engine-startup-1] An error occurred while starting SymmetricDS StackTraceKey.init [SqlException:3075436943]
org.jumpmind.db.sql.SqlException: PANIC: ERRORDATA_STACK_SIZE exceeded (elog.c:1416)
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.platform.AbstractJdbcDdlReader.readTable(AbstractJdbcDdlReader.java:562)
at org.jumpmind.db.platform.AbstractDatabasePlatform.readTableFromDatabase(AbstractDatabasePlatform.java:259)
at org.jumpmind.db.platform.AbstractDatabasePlatform.getTableFromCache(AbstractDatabasePlatform.java:328)
at org.jumpmind.db.platform.AbstractDatabasePlatform.readFromDatabase(AbstractDatabasePlatform.java:245)
at org.jumpmind.symmetric.db.AbstractSymmetricDialect.readSymmetricSchemaFromDatabase(AbstractSymmetricDialect.java:593)
at org.jumpmind.symmetric.db.AbstractSymmetricDialect.createOrAlterTablesIfNecessary(AbstractSymmetricDialect.java:502)
at org.jumpmind.symmetric.db.AbstractSymmetricDialect.initTablesAndDatabaseObjects(AbstractSymmetricDialect.java:159)
at org.jumpmind.symmetric.AbstractSymmetricEngine.setupDatabase(AbstractSymmetricEngine.java:501)
at org.jumpmind.symmetric.AbstractSymmetricEngine.setup(AbstractSymmetricEngine.java:475)
at org.jumpmind.symmetric.AbstractSymmetricEngine.start(AbstractSymmetricEngine.java:645)
at org.jumpmind.symmetric.AbstractSymmetricEngine.start(AbstractSymmetricEngine.java:634)
at org.jumpmind.symmetric.ClientSymmetricEngine.start(ClientSymmetricEngine.java:276)
at org.jumpmind.symmetric.web.SymmetricEngineHolder$EngineStarter.run(SymmetricEngineHolder.java:600)
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: PANIC: ERRORDATA_STACK_SIZE exceeded (elog.c:1416)
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.executeQuery(PgStatement.java:224)
at org.postgresql.jdbc.PgDatabaseMetaData.getPrimaryKeys(PgDatabaseMetaData.java:2020)
at org.apache.commons.dbcp.DelegatingDatabaseMetaData.getPrimaryKeys(DelegatingDatabaseMetaData.java:456)
at org.jumpmind.db.platform.DatabaseMetaDataWrapper.getPrimaryKeys(DatabaseMetaDataWrapper.java:167)
at org.jumpmind.db.platform.AbstractJdbcDdlReader.readPrimaryKeyNames(AbstractJdbcDdlReader.java:1002)
at org.jumpmind.db.platform.AbstractJdbcDdlReader.readTable(AbstractJdbcDdlReader.java:692)
at org.jumpmind.db.platform.postgresql.PostgreSqlDdlReader.readTable(PostgreSqlDdlReader.java:65)
at org.jumpmind.db.platform.greenplum.GreenplumDdlReader.readTable(GreenplumDdlReader.java:99)
at org.jumpmind.db.platform.AbstractJdbcDdlReader$3.execute(AbstractJdbcDdlReader.java:577)
at org.jumpmind.db.platform.AbstractJdbcDdlReader$3.execute(AbstractJdbcDdlReader.java:562)
at org.jumpmind.db.sql.JdbcSqlTemplate.execute(JdbcSqlTemplate.java:501)
... 16 more
2018-10-25 15:44:12,146 INFO [corp-000] [AbstractSymmetricEngine] [symmetric-engine-startup-1] Stopping SymmetricDS externalId=000 version=3.9.14 database=PostgreSQL
2018-10-25 15:44:12,146 INFO [corp-000] [AbstractSymmetricEngine] [symmetric-engine-startup-1]
2018-10-25 15:46:02,074 ERROR [corp-000] [GreenplumDdlReader] [qtp1783047508-17] Failed to get metadata for public.sym_node
2018-10-25 15:46:02,074 WARN [corp-000] [HttpChannel] [qtp1783047508-17] /sync/corp-000/registration StackTraceKey.init [SqlException:3427406688]
org.jumpmind.db.sql.SqlException: An I/O error occurred while sending to the backend.
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.platform.AbstractJdbcDdlReader.readTable(AbstractJdbcDdlReader.java:562)
at org.jumpmind.db.platform.AbstractDatabasePlatform.readTableFromDatabase(AbstractDatabasePlatform.java:259)
at org.jumpmind.symmetric.AbstractSymmetricEngine.isConfigured(AbstractSymmetricEngine.java:954)
at org.jumpmind.symmetric.web.SymmetricServlet.service(SymmetricServlet.java:144)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:833)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1650)
at org.jumpmind.symmetric.web.HttpMethodFilter.doFilter(HttpMethodFilter.java:62)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1637)
at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:533)
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143)
at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:548)
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)
at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:190)
at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1595)
at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:188)
at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1253)
at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:168)
at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:473)
at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1564)
at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:166)
at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1155)
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)
at org.eclipse.jetty.server.Server.handle(Server.java:561)
at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:334)
at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:251)
at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:279)
at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:104)
at org.eclipse.jetty.io.ChannelEndPoint$2.run(ChannelEndPoint.java:124)
at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:679)
at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:597)
at java.lang.Thread.run(Thread.java:748)
Caused by: org.postgresql.util.PSQLException: An I/O error occurred while sending to the backend.
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:333)
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.executeQuery(PgStatement.java:224)
at org.postgresql.jdbc.PgDatabaseMetaData.getTables(PgDatabaseMetaData.java:1249)
at org.apache.commons.dbcp.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:604)
at org.jumpmind.db.platform.DatabaseMetaDataWrapper.getTables(DatabaseMetaDataWrapper.java:130)
at org.jumpmind.db.platform.AbstractJdbcDdlReader$3.execute(AbstractJdbcDdlReader.java:573)
at org.jumpmind.db.platform.AbstractJdbcDdlReader$3.execute(AbstractJdbcDdlReader.java:562)
at org.jumpmind.db.sql.JdbcSqlTemplate.execute(JdbcSqlTemplate.java:501)
... 33 more
Caused by: java.io.EOFException
at org.postgresql.core.PGStream.receiveChar(PGStream.java:295)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1936)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:306)
... 45 more
2018-10-25 15:46:08,403 ERROR [corp-000] [GreenplumDdlReader] [qtp1783047508-12] Failed to get metadata for public.sym_node
2018-10-25 15:46:08,404 WARN [corp-000] [HttpChannel] [qtp1783047508-12] /sync/corp-000/registration StackTraceKey.init [SqlException:3132669190]
org.jumpmind.db.sql.SqlException: An I/O error occurred while sending to the backend.
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.platform.AbstractJdbcDdlReader.readTable(AbstractJdbcDdlReader.java:562)
at org.jumpmind.db.platform.AbstractDatabasePlatform.readTableFromDatabase(AbstractDatabasePlatform.java:259)
at org.jumpmind.symmetric.AbstractSymmetricEngine.isConfigured(AbstractSymmetricEngine.java:954)
at org.jumpmind.symmetric.web.SymmetricServlet.service(SymmetricServlet.java:144)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:833)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1650)
at org.jumpmind.symmetric.web.HttpMethodFilter.doFilter(HttpMethodFilter.java:62)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1637)
at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:533)
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143)
at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:548)
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)
at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:190)
at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1595)
at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:188)
at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1253)
at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:168)
at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:473)
at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1564)
at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:166)
at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1155)
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)
at org.eclipse.jetty.server.Server.handle(Server.java:561)
at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:334)
at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:251)
at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:279)
at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:104)
at org.eclipse.jetty.io.ChannelEndPoint$2.run(ChannelEndPoint.java:124)
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:247)
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.produce(EatWhatYouKill.java:140)
at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:679)
at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:597)
at java.lang.Thread.run(Thread.java:748)
Caused by: org.postgresql.util.PSQLException: An I/O error occurred while sending to the backend.
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:333)
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.executeQuery(PgStatement.java:224)
at org.postgresql.jdbc.PgDatabaseMetaData.getTables(PgDatabaseMetaData.java:1249)
at org.apache.commons.dbcp.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:604)
at org.jumpmind.db.platform.DatabaseMetaDataWrapper.getTables(DatabaseMetaDataWrapper.java:130)
at org.jumpmind.db.platform.AbstractJdbcDdlReader$3.execute(AbstractJdbcDdlReader.java:573)
at org.jumpmind.db.platform.AbstractJdbcDdlReader$3.execute(AbstractJdbcDdlReader.java:562)
at org.jumpmind.db.sql.JdbcSqlTemplate.execute(JdbcSqlTemplate.java:501)
... 35 more
Caused by: java.io.EOFException
at org.postgresql.core.PGStream.receiveChar(PGStream.java:295)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1936)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:306)
... 47 more
2018-10-25 15:46:25,868 INFO [corp-000] [SymmetricServlet] [qtp1783047508-11] Requests for engine corp-000 are being rejected because it is not started
2018-10-25 15:47:13,290 ERROR [corp-000] [GreenplumDdlReader] [qtp1783047508-13] Failed to read table: sym_node. Error: PANIC: ERRORDATA_STACK_SIZE exceeded (elog.c:1416)
2018-10-25 15:47:13,290 ERROR [corp-000] [GreenplumDdlReader] [qtp1783047508-13] Failed to get metadata for public.sym_node
2018-10-25 15:47:13,290 WARN [corp-000] [HttpChannel] [qtp1783047508-13] /sync/corp-000/registration StackTraceKey.init [SqlException:4052076445]
org.jumpmind.db.sql.SqlException: PANIC: ERRORDATA_STACK_SIZE exceeded (elog.c:1416)
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.platform.AbstractJdbcDdlReader.readTable(AbstractJdbcDdlReader.java:562)
at org.jumpmind.db.platform.AbstractDatabasePlatform.readTableFromDatabase(AbstractDatabasePlatform.java:259)
at org.jumpmind.symmetric.AbstractSymmetricEngine.isConfigured(AbstractSymmetricEngine.java:954)
at org.jumpmind.symmetric.web.SymmetricServlet.service(SymmetricServlet.java:144)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:833)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1650)
at org.jumpmind.symmetric.web.HttpMethodFilter.doFilter(HttpMethodFilter.java:62)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1637)
at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:533)
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143)
at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:548)
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)
at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:190)
at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1595)
at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:188)
at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1253)
at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:168)
at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:473)
at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1564)
at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:166)
at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1155)
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)
at org.eclipse.jetty.server.Server.handle(Server.java:561)
at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:334)
at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:251)
at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:279)
at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:104)
at org.eclipse.jetty.io.ChannelEndPoint$2.run(ChannelEndPoint.java:124)
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:247)
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.produce(EatWhatYouKill.java:140)
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:131)
at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:243)
at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:679)
at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:597)
at java.lang.Thread.run(Thread.java:748)
Caused by: org.postgresql.util.PSQLException: PANIC: ERRORDATA_STACK_SIZE exceeded (elog.c:1416)
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.executeQuery(PgStatement.java:224)
at org.postgresql.jdbc.PgDatabaseMetaData.getPrimaryKeys(PgDatabaseMetaData.java:2020)
at org.apache.commons.dbcp.DelegatingDatabaseMetaData.getPrimaryKeys(DelegatingDatabaseMetaData.java:456)
at org.jumpmind.db.platform.DatabaseMetaDataWrapper.getPrimaryKeys(DatabaseMetaDataWrapper.java:167)
at org.jumpmind.db.platform.AbstractJdbcDdlReader.readPrimaryKeyNames(AbstractJdbcDdlReader.java:1002)
at org.jumpmind.db.platform.AbstractJdbcDdlReader.readTable(AbstractJdbcDdlReader.java:692)
at org.jumpmind.db.platform.postgresql.PostgreSqlDdlReader.readTable(PostgreSqlDdlReader.java:65)
at org.jumpmind.db.platform.greenplum.GreenplumDdlReader.readTable(GreenplumDdlReader.java:99)
at org.jumpmind.db.platform.AbstractJdbcDdlReader$3.execute(AbstractJdbcDdlReader.java:577)
at org.jumpmind.db.platform.AbstractJdbcDdlReader$3.execute(AbstractJdbcDdlReader.java:562)
at org.jumpmind.db.sql.JdbcSqlTemplate.execute(JdbcSqlTemplate.java:501)
... 37 more
2018-10-25 15:47:15,537 ERROR [corp-000] [GreenplumDdlReader] [qtp1783047508-17] Failed to get metadata for public.sym_node
2018-10-25 15:47:15,537 WARN [corp-000] [HttpChannel] [qtp1783047508-17] /sync/corp-000/registration StackTraceKey.init [SqlException:3223263259]
org.jumpmind.db.sql.SqlException: An I/O error occurred while sending to the backend.
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.platform.AbstractJdbcDdlReader.readTable(AbstractJdbcDdlReader.java:562)
at org.jumpmind.db.platform.AbstractDatabasePlatform.readTableFromDatabase(AbstractDatabasePlatform.java:259)
at org.jumpmind.symmetric.AbstractSymmetricEngine.isConfigured(AbstractSymmetricEngine.java:954)
at org.jumpmind.symmetric.web.SymmetricServlet.service(SymmetricServlet.java:144)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:833)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1650)
at org.jumpmind.symmetric.web.HttpMethodFilter.doFilter(HttpMethodFilter.java:62)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1637)
at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:533)
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143)
at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:548)
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)
at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:190)
at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1595)
at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:188)
at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1253)
at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:168)
at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:473)
at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1564)
at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:166)
at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1155)
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)
at org.eclipse.jetty.server.Server.handle(Server.java:561)
at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:334)
at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:251)
at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:279)
at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:104)
at org.eclipse.jetty.io.ChannelEndPoint$2.run(ChannelEndPoint.java:124)
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:247)
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.produce(EatWhatYouKill.java:140)
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:131)
at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:243)
at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:679)
at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:597)
at java.lang.Thread.run(Thread.java:748)
Caused by: org.postgresql.util.PSQLException: An I/O error occurred while sending to the backend.
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:333)
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.executeQuery(PgStatement.java:224)
at org.postgresql.jdbc.PgDatabaseMetaData.getTables(PgDatabaseMetaData.java:1249)
at org.apache.commons.dbcp.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:604)
at org.jumpmind.db.platform.DatabaseMetaDataWrapper.getTables(DatabaseMetaDataWrapper.java:130)
at org.jumpmind.db.platform.AbstractJdbcDdlReader$3.execute(AbstractJdbcDdlReader.java:573)
at org.jumpmind.db.platform.AbstractJdbcDdlReader$3.execute(AbstractJdbcDdlReader.java:562)
at org.jumpmind.db.sql.JdbcSqlTemplate.execute(JdbcSqlTemplate.java:501)
... 37 more
Caused by: java.io.EOFException
at org.postgresql.core.PGStream.receiveChar(PGStream.java:295)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1936)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:306)
... 49 more
2018-10-25 15:47:32,782 ERROR [corp-000] [GreenplumDdlReader] [qtp1783047508-11] Failed to get metadata for public.sym_node
2018-10-25 15:47:32,783 WARN [corp-000] [HttpChannel] [qtp1783047508-11] /sync/corp-000/registration StackTraceKey [SqlException:3223263259]
2018-10-25 15:47:38,150 ERROR [corp-000] [GreenplumDdlReader] [qtp1783047508-13] Failed to get metadata for public.sym_node
2018-10-25 15:47:38,150 WARN [corp-000] [HttpChannel] [qtp1783047508-13] /sync/corp-000/registration StackTraceKey [SqlException:3223263259]
2018-10-25 15:48:06,514 ERROR [corp-000] [GreenplumDdlReader] [qtp1783047508-17] Failed to get metadata for public.sym_node
2018-10-25 15:48:06,514 WARN [corp-000] [HttpChannel] [qtp1783047508-17] /sync/corp-000/registration StackTraceKey [SqlException:3223263259]
2018-10-25 15:59:16,313 INFO [startup] [AbstractCommandLauncher] [main] Option: name=port, value={8888}
2018-10-25 15:59:16,435 INFO [startup] [SymmetricUtils] [main]
_____ __ _ ____ _____
/ ___/ __ _____ __ ___ __ ___ _/ /_ ____(_)___ / __ | / ___/
\__ \ / / / / _ `_ \/ _ `_ \/ _ \/_ __// __/ / __/ / / / / \__ \
___/ // /_/ / // // / // // / __// / / / / / /_ / /_/ / ___/ /
/____/ \__ /_//_//_/_//_//_/\___/ \_/ /_/ /_/\__/ /_____/ /____/
/____/
+-----------------------------------------------------------------+
| Copyright (C) 2007-2018 JumpMind, Inc. |
| |
| Licensed under the GNU General Public License version 3. |
| This software comes with ABSOLUTELY NO WARRANTY. |
| See http://www.gnu.org/licenses/gpl.html |
+-----------------------------------------------------------------+
2018-10-25 15:59:16,467 INFO [startup] [SymmetricWebServer] [main] About to start SymmetricDS web server on host:port 0.0.0.0:8888
2018-10-25 15:59:16,794 INFO [corp-000] [AbstractSymmetricEngine] [symmetric-engine-startup-1] Initializing connection to database
2018-10-25 15:59:16,998 INFO [corp-000] [JdbcDatabasePlatformFactory] [symmetric-engine-startup-1] Detected database 'greenplum', version '5', protocol 'postgresql'
2018-10-25 15:59:17,009 INFO [corp-000] [JdbcDatabasePlatformFactory] [symmetric-engine-startup-1] The IDatabasePlatform being used is org.jumpmind.db.platform.greenplum.GreenplumPlatform
2018-10-25 15:59:17,316 INFO [corp-000] [GreenplumSymmetricDialect] [symmetric-engine-startup-1] The DbDialect being used is org.jumpmind.symmetric.db.postgresql.GreenplumSymmetricDialect
2018-10-25 15:59:17,410 INFO [corp-000] [ExtensionService] [symmetric-engine-startup-1] Found 0 extension points from the database that will be registered
2018-10-25 15:59:17,414 INFO [corp-000] [StagingManager] [symmetric-engine-startup-1] The staging directory was initialized at the following location: /opt/websuite/symmetric-server-3.9.14/tmp/corp-000
2018-10-25 15:59:17,660 INFO [startup] [SymmetricWebServer] [main] Starting JMX HTTP console on port 8889
2018-10-25 15:59:17,686 INFO [startup] [SymmetricWebServer] [main] Joining the web server main thread
2018-10-25 15:59:17,837 INFO [corp-000] [ExtensionService] [symmetric-engine-startup-1] Found 0 extension points from the database that will be registered
2018-10-25 15:59:17,838 INFO [corp-000] [ClientExtensionService] [symmetric-engine-startup-1] Found 7 extension points from spring that will be registered
2018-10-25 15:59:17,844 INFO [corp-000] [AbstractSymmetricEngine] [symmetric-engine-startup-1] Initializing SymmetricDS database
2018-10-25 15:59:17,845 INFO [corp-000] [GreenplumSymmetricDialect] [symmetric-engine-startup-1] Checking if SymmetricDS tables need created or altered
2018-10-25 15:59:18,060 ERROR [corp-000] [GreenplumDdlReader] [symmetric-engine-startup-1] Failed to read table: sym_context. Error: PANIC: ERRORDATA_STACK_SIZE exceeded (elog.c:1416)
2018-10-25 15:59:18,060 ERROR [corp-000] [GreenplumDdlReader] [symmetric-engine-startup-1] Failed to get metadata for public.sym_context
2018-10-25 15:59:18,061 ERROR [corp-000] [AbstractSymmetricEngine] [symmetric-engine-startup-1] An error occurred while starting SymmetricDS StackTraceKey.init [SqlException:3075436943]
org.jumpmind.db.sql.SqlException: PANIC: ERRORDATA_STACK_SIZE exceeded (elog.c:1416)
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.platform.AbstractJdbcDdlReader.readTable(AbstractJdbcDdlReader.java:562)
at org.jumpmind.db.platform.AbstractDatabasePlatform.readTableFromDatabase(AbstractDatabasePlatform.java:259)
at org.jumpmind.db.platform.AbstractDatabasePlatform.getTableFromCache(AbstractDatabasePlatform.java:328)
at org.jumpmind.db.platform.AbstractDatabasePlatform.readFromDatabase(AbstractDatabasePlatform.java:245)
at org.jumpmind.symmetric.db.AbstractSymmetricDialect.readSymmetricSchemaFromDatabase(AbstractSymmetricDialect.java:593)
at org.jumpmind.symmetric.db.AbstractSymmetricDialect.createOrAlterTablesIfNecessary(AbstractSymmetricDialect.java:502)
at org.jumpmind.symmetric.db.AbstractSymmetricDialect.initTablesAndDatabaseObjects(AbstractSymmetricDialect.java:159)
at org.jumpmind.symmetric.AbstractSymmetricEngine.setupDatabase(AbstractSymmetricEngine.java:501)
at org.jumpmind.symmetric.AbstractSymmetricEngine.setup(AbstractSymmetricEngine.java:475)
at org.jumpmind.symmetric.AbstractSymmetricEngine.start(AbstractSymmetricEngine.java:645)
at org.jumpmind.symmetric.AbstractSymmetricEngine.start(AbstractSymmetricEngine.java:634)
at org.jumpmind.symmetric.ClientSymmetricEngine.start(ClientSymmetricEngine.java:276)
at org.jumpmind.symmetric.web.SymmetricEngineHolder$EngineStarter.run(SymmetricEngineHolder.java:600)
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: PANIC: ERRORDATA_STACK_SIZE exceeded (elog.c:1416)
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.executeQuery(PgStatement.java:224)
at org.postgresql.jdbc.PgDatabaseMetaData.getPrimaryKeys(PgDatabaseMetaData.java:2020)
at org.apache.commons.dbcp.DelegatingDatabaseMetaData.getPrimaryKeys(DelegatingDatabaseMetaData.java:456)
at org.jumpmind.db.platform.DatabaseMetaDataWrapper.getPrimaryKeys(DatabaseMetaDataWrapper.java:167)
at org.jumpmind.db.platform.AbstractJdbcDdlReader.readPrimaryKeyNames(AbstractJdbcDdlReader.java:1002)
at org.jumpmind.db.platform.AbstractJdbcDdlReader.readTable(AbstractJdbcDdlReader.java:692)
at org.jumpmind.db.platform.postgresql.PostgreSqlDdlReader.readTable(PostgreSqlDdlReader.java:65)
at org.jumpmind.db.platform.greenplum.GreenplumDdlReader.readTable(GreenplumDdlReader.java:99)
at org.jumpmind.db.platform.AbstractJdbcDdlReader$3.execute(AbstractJdbcDdlReader.java:577)
at org.jumpmind.db.platform.AbstractJdbcDdlReader$3.execute(AbstractJdbcDdlReader.java:562)
at org.jumpmind.db.sql.JdbcSqlTemplate.execute(JdbcSqlTemplate.java:501)
... 16 more
2018-10-25 15:59:18,079 INFO [corp-000] [AbstractSymmetricEngine] [symmetric-engine-startup-1] Stopping SymmetricDS externalId=000 version=3.9.14 database=PostgreSQL
2018-10-25 15:59:18,079 INFO [corp-000] [AbstractSymmetricEngine] [symmetric-engine-startup-1]
2018-10-25 16:27:21,753 INFO [] [AbstractCommandLauncher] [main] Option: name=engine, value={corp-000}
2018-10-25 16:27:21,754 INFO [] [AbstractCommandLauncher] [main] Option: name=format, value={XML}
2018-10-25 16:27:21,948 INFO [] [AbstractSymmetricEngine] [main] Initializing connection to database
2018-10-25 16:27:22,005 INFO [] [JdbcDatabasePlatformFactory] [main] Detected database 'greenplum', version '5', protocol 'postgresql'
2018-10-25 16:27:22,019 INFO [] [JdbcDatabasePlatformFactory] [main] The IDatabasePlatform being used is org.jumpmind.db.platform.greenplum.GreenplumPlatform
2018-10-25 16:27:22,107 INFO [] [DefaultDatabaseWriter] [main] About to create table using the following definition:
2018-10-25 16:27:22,368 INFO [] [DefaultDatabaseWriter] [main] About to create table using the following definition:
2018-10-25 16:27:22,566 INFO [] [DefaultDatabaseWriter] [main] About to create table using the following definition:
2018-10-25 16:27:22,696 INFO [] [DefaultDatabaseWriter] [main] About to create table using the following definition:
2018-10-25 16:28:05,841 INFO [] [AbstractCommandLauncher] [main] Option: name=engine, value={corp-000}
2018-10-25 16:28:06,148 INFO [] [SymmetricUtils] [main]
_____ __ _ ____ _____
/ ___/ __ _____ __ ___ __ ___ _/ /_ ____(_)___ / __ | / ___/
\__ \ / / / / _ `_ \/ _ `_ \/ _ \/_ __// __/ / __/ / / / / \__ \
___/ // /_/ / // // / // // / __// / / / / / /_ / /_/ / ___/ /
/____/ \__ /_//_//_/_//_//_/\___/ \_/ /_/ /_/\__/ /_____/ /____/
/____/
+-----------------------------------------------------------------+
| Copyright (C) 2007-2018 JumpMind, Inc. |
| |
| Licensed under the GNU General Public License version 3. |
| This software comes with ABSOLUTELY NO WARRANTY. |
| See http://www.gnu.org/licenses/gpl.html |
+-----------------------------------------------------------------+
2018-10-25 16:28:06,155 INFO [corp-000] [AbstractSymmetricEngine] [main] Initializing connection to database
2018-10-25 16:28:06,234 INFO [corp-000] [JdbcDatabasePlatformFactory] [main] Detected database 'greenplum', version '5', protocol 'postgresql'
2018-10-25 16:28:06,244 INFO [corp-000] [JdbcDatabasePlatformFactory] [main] The IDatabasePlatform being used is org.jumpmind.db.platform.greenplum.GreenplumPlatform
2018-10-25 16:28:06,294 INFO [corp-000] [GreenplumSymmetricDialect] [main] The DbDialect being used is org.jumpmind.symmetric.db.postgresql.GreenplumSymmetricDialect
2018-10-25 16:28:06,316 INFO [corp-000] [StagingManager] [main] The staging directory was initialized at the following location: /opt/websuite/symmetric-server-3.9.14/tmp/corp-000
2018-10-25 16:28:06,743 INFO [corp-000] [ClientExtensionService] [main] Found 6 extension points from spring that will be registered
2018-10-25 16:28:06,743 INFO [corp-000] [AbstractSymmetricEngine] [main] Initializing SymmetricDS database
2018-10-25 16:28:06,743 INFO [corp-000] [GreenplumSymmetricDialect] [main] Checking if SymmetricDS tables need created or altered
2018-10-25 16:28:07,287 INFO [corp-000] [GreenplumSymmetricDialect] [main] There are SymmetricDS tables that needed altered
2018-10-25 16:28:07,429 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_channel"(
"channel_id" VARCHAR(128) NOT NULL,
"processing_order" INTEGER DEFAULT 1 NOT NULL,
"max_batch_size" INTEGER DEFAULT 1000 NOT NULL,
"max_batch_to_send" INTEGER DEFAULT 60 NOT NULL,
"max_data_to_route" INTEGER DEFAULT 100000 NOT NULL,
"extract_period_millis" INTEGER DEFAULT 0 NOT NULL,
"enabled" SMALLINT DEFAULT 1 NOT NULL,
"use_old_data_to_route" SMALLINT DEFAULT 1 NOT NULL,
"use_row_data_to_route" SMALLINT DEFAULT 1 NOT NULL,
"use_pk_data_to_route" SMALLINT DEFAULT 1 NOT NULL,
"reload_flag" SMALLINT DEFAULT 0 NOT NULL,
"file_sync_flag" SMALLINT DEFAULT 0 NOT NULL,
"contains_big_lob" SMALLINT DEFAULT 0 NOT NULL,
"batch_algorithm" VARCHAR(50) DEFAULT 'default' NOT NULL,
"data_loader_type" VARCHAR(50) DEFAULT 'default' NOT NULL,
"description" VARCHAR(255),
"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")
)
2018-10-25 16:28:07,561 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_conflict"(
"conflict_id" VARCHAR(50) NOT NULL,
"source_node_group_id" VARCHAR(50) NOT NULL,
"target_node_group_id" VARCHAR(50) NOT NULL,
"target_channel_id" VARCHAR(128),
"target_catalog_name" VARCHAR(255),
"target_schema_name" VARCHAR(255),
"target_table_name" VARCHAR(255),
"detect_type" VARCHAR(128) NOT NULL,
"detect_expression" 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")
)
2018-10-25 16:28:07,690 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_context"(
"name" VARCHAR(80) NOT NULL,
"context_value" TEXT,
"create_time" TIMESTAMP,
"last_update_time" TIMESTAMP,
PRIMARY KEY ("name")
)
2018-10-25 16:28:07,694 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL failed: CREATE SEQUENCE "sym_data_data_id_seq"
2018-10-25 16:28:07,827 INFO [corp-000] [GreenplumSymmetricDialect] [main] 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")
)
2018-10-25 16:28:07,897 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE INDEX "sym_idx_d_channel_id" ON "sym_data" ("data_id", "channel_id")
2018-10-25 16:28:07,974 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_data_event"(
"data_id" BIGINT NOT NULL,
"batch_id" BIGINT NOT NULL,
"router_id" VARCHAR(50) NOT NULL,
"create_time" TIMESTAMP,
PRIMARY KEY ("data_id", "batch_id", "router_id")
)
2018-10-25 16:28:08,039 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE INDEX "sym_idx_de_batchid" ON "sym_data_event" ("batch_id")
2018-10-25 16:28:08,119 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_data_gap"(
"start_id" BIGINT NOT NULL,
"end_id" BIGINT NOT NULL,
"status" CHAR(2),
"create_time" TIMESTAMP NOT NULL,
"last_update_hostname" VARCHAR(255),
"last_update_time" TIMESTAMP NOT NULL,
PRIMARY KEY ("start_id", "end_id")
)
2018-10-25 16:28:08,183 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE INDEX "sym_idx_dg_status" ON "sym_data_gap" ("status")
2018-10-25 16:28:08,319 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_extension"(
"extension_id" VARCHAR(50) NOT NULL,
"extension_type" VARCHAR(10) NOT NULL,
"interface_name" VARCHAR(255),
"node_group_id" VARCHAR(50) NOT NULL,
"enabled" SMALLINT DEFAULT 1 NOT NULL,
"extension_order" INTEGER DEFAULT 1 NOT NULL,
"extension_text" TEXT,
"create_time" TIMESTAMP,
"last_update_by" VARCHAR(50),
"last_update_time" TIMESTAMP,
PRIMARY KEY ("extension_id")
)
2018-10-25 16:28:08,406 INFO [corp-000] [GreenplumSymmetricDialect] [main] 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")
)
2018-10-25 16:28:08,492 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_file_incoming"(
"relative_dir" VARCHAR(255) NOT NULL,
"file_name" VARCHAR(128) NOT NULL,
"last_event_type" CHAR(1) NOT NULL,
"node_id" VARCHAR(50) NOT NULL,
"file_modified_time" BIGINT,
PRIMARY KEY ("relative_dir", "file_name")
)
2018-10-25 16:28:08,581 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_file_snapshot"(
"trigger_id" VARCHAR(128) NOT NULL,
"router_id" VARCHAR(50) NOT NULL,
"relative_dir" VARCHAR(255) NOT NULL,
"file_name" VARCHAR(128) NOT NULL,
"channel_id" VARCHAR(128) DEFAULT 'filesync' NOT NULL,
"reload_channel_id" VARCHAR(128) DEFAULT 'filesync_reload' NOT NULL,
"last_event_type" CHAR(1) NOT NULL,
"crc32_checksum" BIGINT,
"file_size" BIGINT,
"file_modified_time" BIGINT,
"last_update_time" TIMESTAMP NOT NULL,
"last_update_by" VARCHAR(50),
"create_time" TIMESTAMP NOT NULL,
PRIMARY KEY ("trigger_id", "router_id", "relative_dir", "file_name")
)
2018-10-25 16:28:08,650 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE INDEX "sym_idx_f_snpsht_chid" ON "sym_file_snapshot" ("reload_channel_id")
2018-10-25 16:28:08,789 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_file_trigger"(
"trigger_id" VARCHAR(128) NOT NULL,
"channel_id" VARCHAR(128) DEFAULT 'filesync' NOT NULL,
"reload_channel_id" VARCHAR(128) DEFAULT 'filesync_reload' NOT NULL,
"base_dir" VARCHAR(255) NOT NULL,
"recurse" SMALLINT DEFAULT 1 NOT NULL,
"includes_files" VARCHAR(255),
"excludes_files" VARCHAR(255),
"sync_on_create" SMALLINT DEFAULT 1 NOT NULL,
"sync_on_modified" SMALLINT DEFAULT 1 NOT NULL,
"sync_on_delete" SMALLINT DEFAULT 1 NOT NULL,
"sync_on_ctl_file" SMALLINT DEFAULT 0 NOT NULL,
"delete_after_sync" SMALLINT DEFAULT 0 NOT NULL,
"before_copy_script" 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")
)
2018-10-25 16:28:08,920 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_file_trigger_router"(
"trigger_id" VARCHAR(128) NOT NULL,
"router_id" VARCHAR(50) NOT NULL,
"enabled" SMALLINT DEFAULT 1 NOT NULL,
"initial_load_enabled" SMALLINT DEFAULT 1 NOT NULL,
"target_base_dir" VARCHAR(255),
"conflict_strategy" VARCHAR(128) DEFAULT 'source_wins' NOT NULL,
"create_time" TIMESTAMP NOT NULL,
"last_update_by" VARCHAR(50),
"last_update_time" TIMESTAMP NOT NULL,
"description" TEXT,
PRIMARY KEY ("trigger_id", "router_id")
)
2018-10-25 16:28:09,007 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_grouplet"(
"grouplet_id" VARCHAR(50) NOT NULL,
"grouplet_link_policy" CHAR(1) DEFAULT 'I' NOT NULL,
"description" VARCHAR(255),
"create_time" TIMESTAMP NOT NULL,
"last_update_by" VARCHAR(50),
"last_update_time" TIMESTAMP NOT NULL,
PRIMARY KEY ("grouplet_id")
)
2018-10-25 16:28:09,090 INFO [corp-000] [GreenplumSymmetricDialect] [main] 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")
)
2018-10-25 16:28:09,241 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_incoming_batch"(
"batch_id" BIGINT NOT NULL,
"node_id" VARCHAR(50) NOT NULL,
"channel_id" VARCHAR(128),
"status" CHAR(2),
"error_flag" SMALLINT DEFAULT 0,
"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")
)
2018-10-25 16:28:09,310 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE INDEX "sym_idx_ib_time_status" ON "sym_incoming_batch" ("create_time", "status")
2018-10-25 16:28:09,376 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE INDEX "sym_idx_ib_in_error" ON "sym_incoming_batch" ("error_flag")
2018-10-25 16:28:09,518 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_incoming_error"(
"batch_id" BIGINT NOT NULL,
"node_id" VARCHAR(50) NOT NULL,
"failed_row_number" BIGINT NOT NULL,
"failed_line_number" BIGINT DEFAULT 0 NOT NULL,
"target_catalog_name" VARCHAR(255),
"target_schema_name" VARCHAR(255),
"target_table_name" VARCHAR(255) NOT NULL,
"event_type" CHAR(1) NOT NULL,
"binary_encoding" VARCHAR(10) DEFAULT 'HEX' NOT NULL,
"column_names" 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")
)
2018-10-25 16:28:09,655 INFO [corp-000] [GreenplumSymmetricDialect] [main] 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")
)
2018-10-25 16:28:09,794 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_load_filter"(
"load_filter_id" VARCHAR(50) NOT NULL,
"load_filter_type" VARCHAR(10) NOT NULL,
"source_node_group_id" VARCHAR(50) NOT NULL,
"target_node_group_id" VARCHAR(50) NOT NULL,
"target_catalog_name" VARCHAR(255),
"target_schema_name" VARCHAR(255),
"target_table_name" VARCHAR(255),
"filter_on_update" SMALLINT DEFAULT 1 NOT NULL,
"filter_on_insert" SMALLINT DEFAULT 1 NOT NULL,
"filter_on_delete" SMALLINT DEFAULT 1 NOT NULL,
"before_write_script" 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")
)
2018-10-25 16:28:09,881 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_lock"(
"lock_action" VARCHAR(50) NOT NULL,
"lock_type" VARCHAR(50) NOT NULL,
"locking_server_id" VARCHAR(255),
"lock_time" TIMESTAMP,
"shared_count" INTEGER DEFAULT 0 NOT NULL,
"shared_enable" INTEGER DEFAULT 0 NOT NULL,
"last_lock_time" TIMESTAMP,
"last_locking_server_id" VARCHAR(255),
PRIMARY KEY ("lock_action")
)
2018-10-25 16:28:09,972 INFO [corp-000] [GreenplumSymmetricDialect] [main] 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")
)
2018-10-25 16:28:10,064 INFO [corp-000] [GreenplumSymmetricDialect] [main] 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")
)
2018-10-25 16:28:10,148 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_node_channel_ctl"(
"node_id" VARCHAR(50) NOT NULL,
"channel_id" VARCHAR(128) NOT NULL,
"suspend_enabled" SMALLINT DEFAULT 0,
"ignore_enabled" SMALLINT DEFAULT 0,
"last_extract_time" TIMESTAMP,
PRIMARY KEY ("node_id", "channel_id")
)
2018-10-25 16:28:10,235 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_node_group"(
"node_group_id" VARCHAR(50) NOT NULL,
"description" VARCHAR(255),
"create_time" TIMESTAMP,
"last_update_by" VARCHAR(50),
"last_update_time" TIMESTAMP,
PRIMARY KEY ("node_group_id")
)
2018-10-25 16:28:10,322 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_node_group_channel_wnd"(
"node_group_id" VARCHAR(50) NOT NULL,
"channel_id" VARCHAR(128) NOT NULL,
"start_time" TIMESTAMP NOT NULL,
"end_time" TIMESTAMP NOT NULL,
"enabled" SMALLINT DEFAULT 0 NOT NULL,
PRIMARY KEY ("node_group_id", "channel_id", "start_time", "end_time")
)
2018-10-25 16:28:10,413 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_node_group_link"(
"source_node_group_id" VARCHAR(50) NOT NULL,
"target_node_group_id" VARCHAR(50) NOT NULL,
"data_event_action" CHAR(1) DEFAULT 'W' NOT NULL,
"sync_config_enabled" SMALLINT DEFAULT 1 NOT NULL,
"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")
)
2018-10-25 16:28:10,506 INFO [corp-000] [GreenplumSymmetricDialect] [main] 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")
)
2018-10-25 16:28:10,597 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_node_host_channel_stats"(
"node_id" VARCHAR(50) NOT NULL,
"host_name" VARCHAR(60) NOT NULL,
"channel_id" VARCHAR(128) NOT NULL,
"start_time" TIMESTAMP NOT NULL,
"end_time" TIMESTAMP NOT NULL,
"data_routed" BIGINT DEFAULT 0,
"data_unrouted" BIGINT DEFAULT 0,
"data_event_inserted" BIGINT DEFAULT 0,
"data_extracted" BIGINT DEFAULT 0,
"data_bytes_extracted" BIGINT DEFAULT 0,
"data_extracted_errors" BIGINT DEFAULT 0,
"data_bytes_sent" BIGINT DEFAULT 0,
"data_sent" BIGINT DEFAULT 0,
"data_sent_errors" BIGINT DEFAULT 0,
"data_loaded" BIGINT DEFAULT 0,
"data_bytes_loaded" BIGINT DEFAULT 0,
"data_loaded_errors" BIGINT DEFAULT 0,
PRIMARY KEY ("node_id", "host_name", "channel_id", "start_time", "end_time")
)
2018-10-25 16:28:10,666 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE INDEX "sym_idx_nd_hst_chnl_sts" ON "sym_node_host_channel_stats" ("node_id", "start_time", "end_time")
2018-10-25 16:28:10,754 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_node_host_job_stats"(
"node_id" VARCHAR(50) NOT NULL,
"host_name" VARCHAR(60) NOT NULL,
"job_name" VARCHAR(50) NOT NULL,
"start_time" TIMESTAMP NOT NULL,
"end_time" TIMESTAMP NOT NULL,
"processed_count" BIGINT DEFAULT 0,
"target_node_id" VARCHAR(50),
"target_node_count" INTEGER DEFAULT 0,
PRIMARY KEY ("node_id", "host_name", "job_name", "start_time", "end_time")
)
2018-10-25 16:28:10,889 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE INDEX "sym_idx_nd_hst_job" ON "sym_node_host_job_stats" ("node_id", "start_time", "end_time")
2018-10-25 16:28:10,985 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_node_host_stats"(
"node_id" VARCHAR(50) NOT NULL,
"host_name" VARCHAR(60) NOT NULL,
"start_time" TIMESTAMP NOT NULL,
"end_time" TIMESTAMP NOT NULL,
"restarted" BIGINT DEFAULT 0 NOT NULL,
"nodes_pulled" BIGINT DEFAULT 0,
"total_nodes_pull_time" BIGINT DEFAULT 0,
"nodes_pushed" BIGINT DEFAULT 0,
"total_nodes_push_time" BIGINT DEFAULT 0,
"nodes_rejected" BIGINT DEFAULT 0,
"nodes_registered" BIGINT DEFAULT 0,
"nodes_loaded" BIGINT DEFAULT 0,
"nodes_disabled" BIGINT DEFAULT 0,
"purged_data_rows" BIGINT DEFAULT 0,
"purged_data_event_rows" BIGINT DEFAULT 0,
"purged_batch_outgoing_rows" BIGINT DEFAULT 0,
"purged_batch_incoming_rows" BIGINT DEFAULT 0,
"triggers_created_count" BIGINT,
"triggers_rebuilt_count" BIGINT,
"triggers_removed_count" BIGINT,
PRIMARY KEY ("node_id", "host_name", "start_time", "end_time")
)
2018-10-25 16:28:11,049 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE INDEX "sym_idx_nd_hst_sts" ON "sym_node_host_stats" ("node_id", "start_time", "end_time")
2018-10-25 16:28:11,156 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_node_identity"(
"node_id" VARCHAR(50) NOT NULL,
PRIMARY KEY ("node_id")
)
2018-10-25 16:28:11,245 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_node_security"(
"node_id" VARCHAR(50) NOT NULL,
"node_password" VARCHAR(50) NOT NULL,
"registration_enabled" SMALLINT DEFAULT 0,
"registration_time" TIMESTAMP,
"initial_load_enabled" SMALLINT DEFAULT 0,
"initial_load_time" TIMESTAMP,
"initial_load_id" BIGINT,
"initial_load_create_by" VARCHAR(255),
"rev_initial_load_enabled" SMALLINT DEFAULT 0,
"rev_initial_load_time" TIMESTAMP,
"rev_initial_load_id" BIGINT,
"rev_initial_load_create_by" VARCHAR(255),
"created_at_node_id" VARCHAR(50),
PRIMARY KEY ("node_id")
)
2018-10-25 16:28:11,375 INFO [corp-000] [GreenplumSymmetricDialect] [main] 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")
)
2018-10-25 16:28:11,507 INFO [corp-000] [GreenplumSymmetricDialect] [main] 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")
)
2018-10-25 16:28:11,659 INFO [corp-000] [GreenplumSymmetricDialect] [main] 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")
)
2018-10-25 16:28:11,802 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_outgoing_batch"(
"batch_id" BIGINT NOT NULL,
"node_id" VARCHAR(50) NOT NULL,
"channel_id" VARCHAR(128),
"status" CHAR(2),
"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")
)
2018-10-25 16:28:11,869 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE INDEX "sym_idx_ob_node_status" ON "sym_outgoing_batch" ("node_id", "status")
2018-10-25 16:28:11,932 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE INDEX "sym_idx_ob_status" ON "sym_outgoing_batch" ("status")
2018-10-25 16:28:12,001 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE INDEX "sym_idx_ob_in_error" ON "sym_outgoing_batch" ("error_flag")
2018-10-25 16:28:12,128 INFO [corp-000] [GreenplumSymmetricDialect] [main] 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")
)
2018-10-25 16:28:12,214 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_registration_redirect"(
"registrant_external_id" VARCHAR(255) NOT NULL,
"registration_node_id" VARCHAR(50) NOT NULL,
PRIMARY KEY ("registrant_external_id")
)
2018-10-25 16:28:12,346 INFO [corp-000] [GreenplumSymmetricDialect] [main] 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")
)
2018-10-25 16:28:12,416 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE INDEX "sym_idx_reg_req_1" ON "sym_registration_request" ("node_group_id", "external_id", "status", "host_name", "ip_address")
2018-10-25 16:28:12,488 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE INDEX "sym_idx_reg_req_2" ON "sym_registration_request" ("status")
2018-10-25 16:28:12,625 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_router"(
"router_id" VARCHAR(50) NOT NULL,
"target_catalog_name" VARCHAR(255),
"target_schema_name" VARCHAR(255),
"target_table_name" VARCHAR(255),
"source_node_group_id" VARCHAR(50) NOT NULL,
"target_node_group_id" VARCHAR(50) NOT NULL,
"router_type" VARCHAR(50),
"router_expression" 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")
)
2018-10-25 16:28:12,717 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_sequence"(
"sequence_name" VARCHAR(50) NOT NULL,
"current_value" BIGINT DEFAULT 0 NOT NULL,
"increment_by" INTEGER DEFAULT 1 NOT NULL,
"min_value" BIGINT DEFAULT 1 NOT NULL,
"max_value" BIGINT DEFAULT 9999999999 NOT NULL,
"cycle_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")
)
2018-10-25 16:28:12,865 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_table_reload_request"(
"target_node_id" VARCHAR(50) NOT NULL,
"source_node_id" VARCHAR(50) NOT NULL,
"trigger_id" VARCHAR(128) NOT NULL,
"router_id" VARCHAR(50) NOT NULL,
"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")
)
2018-10-25 16:28:13,001 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_transform_table"(
"transform_id" VARCHAR(50) NOT NULL,
"source_node_group_id" VARCHAR(50) NOT NULL,
"target_node_group_id" VARCHAR(50) NOT NULL,
"transform_point" VARCHAR(10) NOT NULL,
"source_catalog_name" VARCHAR(255),
"source_schema_name" VARCHAR(255),
"source_table_name" VARCHAR(255) NOT NULL,
"target_catalog_name" VARCHAR(255),
"target_schema_name" VARCHAR(255),
"target_table_name" VARCHAR(255),
"update_first" SMALLINT DEFAULT 0,
"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")
)
2018-10-25 16:28:13,135 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_transform_column"(
"transform_id" VARCHAR(50) NOT NULL,
"include_on" CHAR(1) DEFAULT '*' NOT NULL,
"target_column_name" VARCHAR(128) NOT NULL,
"source_column_name" VARCHAR(128),
"pk" SMALLINT DEFAULT 0,
"transform_type" VARCHAR(50) DEFAULT 'copy',
"transform_expression" 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")
)
2018-10-25 16:28:13,270 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_trigger"(
"trigger_id" VARCHAR(128) NOT NULL,
"source_catalog_name" VARCHAR(255),
"source_schema_name" VARCHAR(255),
"source_table_name" VARCHAR(255) NOT NULL,
"channel_id" VARCHAR(128) NOT NULL,
"reload_channel_id" VARCHAR(128) DEFAULT 'reload' NOT NULL,
"sync_on_update" SMALLINT DEFAULT 1 NOT NULL,
"sync_on_insert" SMALLINT DEFAULT 1 NOT NULL,
"sync_on_delete" SMALLINT DEFAULT 1 NOT NULL,
"sync_on_incoming_batch" SMALLINT DEFAULT 0 NOT NULL,
"name_for_update_trigger" VARCHAR(255),
"name_for_insert_trigger" VARCHAR(255),
"name_for_delete_trigger" VARCHAR(255),
"sync_on_update_condition" 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")
)
2018-10-25 16:28:13,396 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_trigger_hist"(
"trigger_hist_id" INTEGER NOT NULL,
"trigger_id" VARCHAR(128) NOT NULL,
"source_table_name" VARCHAR(255) NOT NULL,
"source_catalog_name" VARCHAR(255),
"source_schema_name" VARCHAR(255),
"name_for_update_trigger" VARCHAR(255),
"name_for_insert_trigger" VARCHAR(255),
"name_for_delete_trigger" VARCHAR(255),
"table_hash" BIGINT DEFAULT 0 NOT NULL,
"trigger_row_hash" BIGINT DEFAULT 0 NOT NULL,
"trigger_template_hash" BIGINT DEFAULT 0 NOT NULL,
"column_names" 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")
)
2018-10-25 16:28:13,463 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE INDEX "sym_idx_trigg_hist_1" ON "sym_trigger_hist" ("trigger_id", "inactive_time")
2018-10-25 16:28:13,590 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_trigger_router"(
"trigger_id" VARCHAR(128) NOT NULL,
"router_id" VARCHAR(50) NOT NULL,
"enabled" SMALLINT DEFAULT 1 NOT NULL,
"initial_load_order" INTEGER DEFAULT 1 NOT NULL,
"initial_load_select" 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")
)
2018-10-25 16:28:13,676 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_trigger_router_grouplet"(
"grouplet_id" VARCHAR(50) NOT NULL,
"trigger_id" VARCHAR(128) NOT NULL,
"router_id" VARCHAR(50) NOT NULL,
"applies_when" CHAR(1) NOT NULL,
"create_time" TIMESTAMP NOT NULL,
"last_update_by" VARCHAR(50),
"last_update_time" TIMESTAMP NOT NULL,
PRIMARY KEY ("grouplet_id", "trigger_id", "router_id", "applies_when")
)
2018-10-25 16:28:13,707 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: ALTER TABLE "sym_conflict"
ADD CONSTRAINT "sym_fk_cf_2_grp_lnk" FOREIGN KEY ("source_node_group_id", "target_node_group_id") REFERENCES "sym_node_group_link" ("source_node_group_id", "target_node_group_id")
2018-10-25 16:28:13,733 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: ALTER TABLE "sym_file_trigger_router"
ADD CONSTRAINT "sym_fk_ftr_2_ftrg" FOREIGN KEY ("trigger_id") REFERENCES "sym_file_trigger" ("trigger_id")
2018-10-25 16:28:13,760 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: ALTER TABLE "sym_file_trigger_router"
ADD CONSTRAINT "sym_fk_ftr_2_rtr" FOREIGN KEY ("router_id") REFERENCES "sym_router" ("router_id")
2018-10-25 16:28:13,785 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: ALTER TABLE "sym_grouplet_link"
ADD CONSTRAINT "sym_fk_gpltlnk_2_gplt" FOREIGN KEY ("grouplet_id") REFERENCES "sym_grouplet" ("grouplet_id")
2018-10-25 16:28:13,813 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: ALTER TABLE "sym_node_group_link"
ADD CONSTRAINT "sym_fk_lnk_2_grp_src" FOREIGN KEY ("source_node_group_id") REFERENCES "sym_node_group" ("node_group_id")
2018-10-25 16:28:13,842 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: ALTER TABLE "sym_node_group_link"
ADD CONSTRAINT "sym_fk_lnk_2_grp_tgt" FOREIGN KEY ("target_node_group_id") REFERENCES "sym_node_group" ("node_group_id")
2018-10-25 16:28:13,867 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: ALTER TABLE "sym_node_identity"
ADD CONSTRAINT "sym_fk_ident_2_node" FOREIGN KEY ("node_id") REFERENCES "sym_node" ("node_id")
2018-10-25 16:28:13,897 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: ALTER TABLE "sym_node_security"
ADD CONSTRAINT "sym_fk_sec_2_node" FOREIGN KEY ("node_id") REFERENCES "sym_node" ("node_id")
2018-10-25 16:28:13,922 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: ALTER TABLE "sym_router"
ADD CONSTRAINT "sym_fk_rt_2_grp_lnk" FOREIGN KEY ("source_node_group_id", "target_node_group_id") REFERENCES "sym_node_group_link" ("source_node_group_id", "target_node_group_id")
2018-10-25 16:28:13,952 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: ALTER TABLE "sym_transform_table"
ADD CONSTRAINT "sym_fk_tt_2_grp_lnk" FOREIGN KEY ("source_node_group_id", "target_node_group_id") REFERENCES "sym_node_group_link" ("source_node_group_id", "target_node_group_id")
2018-10-25 16:28:13,979 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: ALTER TABLE "sym_trigger"
ADD CONSTRAINT "sym_fk_trg_2_chnl" FOREIGN KEY ("channel_id") REFERENCES "sym_channel" ("channel_id")
2018-10-25 16:28:14,009 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: ALTER TABLE "sym_trigger"
ADD CONSTRAINT "sym_fk_trg_2_rld_chnl" FOREIGN KEY ("reload_channel_id") REFERENCES "sym_channel" ("channel_id")
2018-10-25 16:28:14,034 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: ALTER TABLE "sym_trigger_router"
ADD CONSTRAINT "sym_fk_tr_2_trg" FOREIGN KEY ("trigger_id") REFERENCES "sym_trigger" ("trigger_id")
2018-10-25 16:28:14,061 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: ALTER TABLE "sym_trigger_router"
ADD CONSTRAINT "sym_fk_tr_2_rtr" FOREIGN KEY ("router_id") REFERENCES "sym_router" ("router_id")
2018-10-25 16:28:14,089 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: ALTER TABLE "sym_trigger_router_grouplet"
ADD CONSTRAINT "sym_fk_trgplt_2_gplt" FOREIGN KEY ("grouplet_id") REFERENCES "sym_grouplet" ("grouplet_id")
2018-10-25 16:28:14,113 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: ALTER TABLE "sym_trigger_router_grouplet"
ADD CONSTRAINT "sym_fk_trgplt_2_tr" FOREIGN KEY ("trigger_id", "router_id") REFERENCES "sym_trigger_router" ("trigger_id", "router_id")
2018-10-25 16:28:14,232 INFO [corp-000] [GreenplumSymmetricDialect] [main] Done with auto update of SymmetricDS tables
2018-10-25 16:28:14,277 INFO [corp-000] [ConfigurationService] [main] Auto-configuring config channel
2018-10-25 16:28:14,371 INFO [corp-000] [ConfigurationService] [main] Auto-configuring reload channel
2018-10-25 16:28:14,443 INFO [corp-000] [ConfigurationService] [main] Auto-configuring monitor channel
2018-10-25 16:28:14,536 INFO [corp-000] [ConfigurationService] [main] Auto-configuring heartbeat channel
2018-10-25 16:28:14,626 INFO [corp-000] [ConfigurationService] [main] Auto-configuring default channel
2018-10-25 16:28:14,689 INFO [corp-000] [ConfigurationService] [main] Auto-configuring dynamic channel
2018-10-25 16:28:15,272 INFO [corp-000] [AbstractSymmetricEngine] [main] Inserting rows for node, security, identity and group for registration server
2018-10-25 16:28:15,954 INFO [corp-000] [AbstractSymmetricEngine] [main] Done initializing SymmetricDS database
2018-10-25 16:29:04,690 INFO [] [AbstractCommandLauncher] [main] Option: name=engine, value={corp-000}
2018-10-25 16:29:04,882 INFO [] [AbstractSymmetricEngine] [main] Initializing connection to database
2018-10-25 16:29:04,940 INFO [] [JdbcDatabasePlatformFactory] [main] Detected database 'greenplum', version '5', protocol 'postgresql'
2018-10-25 16:29:04,953 INFO [] [JdbcDatabasePlatformFactory] [main] The IDatabasePlatform being used is org.jumpmind.db.platform.greenplum.GreenplumPlatform
2018-10-25 16:31:13,304 INFO [startup] [AbstractCommandLauncher] [main] Option: name=engine, value={corp-000}
2018-10-25 16:31:13,304 INFO [startup] [AbstractCommandLauncher] [main] Option: name=port, value={8888}
2018-10-25 16:31:13,421 INFO [startup] [SymmetricUtils] [main]
_____ __ _ ____ _____
/ ___/ __ _____ __ ___ __ ___ _/ /_ ____(_)___ / __ | / ___/
\__ \ / / / / _ `_ \/ _ `_ \/ _ \/_ __// __/ / __/ / / / / \__ \
___/ // /_/ / // // / // // / __// / / / / / /_ / /_/ / ___/ /
/____/ \__ /_//_//_/_//_//_/\___/ \_/ /_/ /_/\__/ /_____/ /____/
/____/
+-----------------------------------------------------------------+
| Copyright (C) 2007-2018 JumpMind, Inc. |
| |
| Licensed under the GNU General Public License version 3. |
| This software comes with ABSOLUTELY NO WARRANTY. |
| See http://www.gnu.org/licenses/gpl.html |
+-----------------------------------------------------------------+
2018-10-25 16:31:13,451 INFO [startup] [SymmetricWebServer] [main] About to start SymmetricDS web server on host:port 0.0.0.0:8888
2018-10-25 16:31:13,782 INFO [corp-000] [AbstractSymmetricEngine] [symmetric-engine-startup-1] Initializing connection to database
2018-10-25 16:31:13,950 INFO [corp-000] [JdbcDatabasePlatformFactory] [symmetric-engine-startup-1] Detected database 'greenplum', version '5', protocol 'postgresql'
2018-10-25 16:31:13,961 INFO [corp-000] [JdbcDatabasePlatformFactory] [symmetric-engine-startup-1] The IDatabasePlatform being used is org.jumpmind.db.platform.greenplum.GreenplumPlatform
2018-10-25 16:31:14,403 INFO [corp-000] [GreenplumSymmetricDialect] [symmetric-engine-startup-1] The DbDialect being used is org.jumpmind.symmetric.db.postgresql.GreenplumSymmetricDialect
2018-10-25 16:31:14,516 INFO [corp-000] [ExtensionService] [symmetric-engine-startup-1] Found 0 extension points from the database that will be registered
2018-10-25 16:31:14,520 INFO [corp-000] [StagingManager] [symmetric-engine-startup-1] The staging directory was initialized at the following location: /opt/websuite/symmetric-server-3.9.14/tmp/corp-000
2018-10-25 16:31:14,624 INFO [startup] [SymmetricWebServer] [main] Starting JMX HTTP console on port 8889
2018-10-25 16:31:14,637 INFO [startup] [SymmetricWebServer] [main] Joining the web server main thread
2018-10-25 16:31:14,958 INFO [corp-000] [ExtensionService] [symmetric-engine-startup-1] Found 0 extension points from the database that will be registered
2018-10-25 16:31:14,959 INFO [corp-000] [ClientExtensionService] [symmetric-engine-startup-1] Found 7 extension points from spring that will be registered
2018-10-25 16:31:14,965 INFO [corp-000] [AbstractSymmetricEngine] [symmetric-engine-startup-1] Initializing SymmetricDS database
2018-10-25 16:31:14,965 INFO [corp-000] [GreenplumSymmetricDialect] [symmetric-engine-startup-1] Checking if SymmetricDS tables need created or altered
2018-10-25 16:31:15,162 ERROR [corp-000] [GreenplumDdlReader] [symmetric-engine-startup-1] Failed to read table: sym_context. Error: PANIC: ERRORDATA_STACK_SIZE exceeded (elog.c:1416)
2018-10-25 16:31:15,163 ERROR [corp-000] [GreenplumDdlReader] [symmetric-engine-startup-1] Failed to get metadata for public.sym_context
2018-10-25 16:31:15,163 ERROR [corp-000] [AbstractSymmetricEngine] [symmetric-engine-startup-1] An error occurred while starting SymmetricDS StackTraceKey.init [SqlException:3075436943]
org.jumpmind.db.sql.SqlException: PANIC: ERRORDATA_STACK_SIZE exceeded (elog.c:1416)
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.platform.AbstractJdbcDdlReader.readTable(AbstractJdbcDdlReader.java:562)
at org.jumpmind.db.platform.AbstractDatabasePlatform.readTableFromDatabase(AbstractDatabasePlatform.java:259)
at org.jumpmind.db.platform.AbstractDatabasePlatform.getTableFromCache(AbstractDatabasePlatform.java:328)
at org.jumpmind.db.platform.AbstractDatabasePlatform.readFromDatabase(AbstractDatabasePlatform.java:245)
at org.jumpmind.symmetric.db.AbstractSymmetricDialect.readSymmetricSchemaFromDatabase(AbstractSymmetricDialect.java:593)
at org.jumpmind.symmetric.db.AbstractSymmetricDialect.createOrAlterTablesIfNecessary(AbstractSymmetricDialect.java:502)
at org.jumpmind.symmetric.db.AbstractSymmetricDialect.initTablesAndDatabaseObjects(AbstractSymmetricDialect.java:159)
at org.jumpmind.symmetric.AbstractSymmetricEngine.setupDatabase(AbstractSymmetricEngine.java:501)
at org.jumpmind.symmetric.AbstractSymmetricEngine.setup(AbstractSymmetricEngine.java:475)
at org.jumpmind.symmetric.AbstractSymmetricEngine.start(AbstractSymmetricEngine.java:645)
at org.jumpmind.symmetric.AbstractSymmetricEngine.start(AbstractSymmetricEngine.java:634)
at org.jumpmind.symmetric.ClientSymmetricEngine.start(ClientSymmetricEngine.java:276)
at org.jumpmind.symmetric.web.SymmetricEngineHolder$EngineStarter.run(SymmetricEngineHolder.java:600)
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: PANIC: ERRORDATA_STACK_SIZE exceeded (elog.c:1416)
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.executeQuery(PgStatement.java:224)
at org.postgresql.jdbc.PgDatabaseMetaData.getPrimaryKeys(PgDatabaseMetaData.java:2020)
at org.apache.commons.dbcp.DelegatingDatabaseMetaData.getPrimaryKeys(DelegatingDatabaseMetaData.java:456)
at org.jumpmind.db.platform.DatabaseMetaDataWrapper.getPrimaryKeys(DatabaseMetaDataWrapper.java:167)
at org.jumpmind.db.platform.AbstractJdbcDdlReader.readPrimaryKeyNames(AbstractJdbcDdlReader.java:1002)
at org.jumpmind.db.platform.AbstractJdbcDdlReader.readTable(AbstractJdbcDdlReader.java:692)
at org.jumpmind.db.platform.postgresql.PostgreSqlDdlReader.readTable(PostgreSqlDdlReader.java:65)
at org.jumpmind.db.platform.greenplum.GreenplumDdlReader.readTable(GreenplumDdlReader.java:99)
at org.jumpmind.db.platform.AbstractJdbcDdlReader$3.execute(AbstractJdbcDdlReader.java:577)
at org.jumpmind.db.platform.AbstractJdbcDdlReader$3.execute(AbstractJdbcDdlReader.java:562)
at org.jumpmind.db.sql.JdbcSqlTemplate.execute(JdbcSqlTemplate.java:501)
... 16 more
2018-10-25 16:31:15,181 INFO [corp-000] [AbstractSymmetricEngine] [symmetric-engine-startup-1] Stopping SymmetricDS externalId=000 version=3.9.14 database=PostgreSQL
2018-10-25 16:31:15,181 INFO [corp-000] [AbstractSymmetricEngine] [symmetric-engine-startup-1]
2018-10-26 09:24:29,133 INFO [corp-000] [SymmetricServlet] [qtp1783047508-16] Requests for engine corp-000 are being rejected because it is not started
2018-10-26 09:25:06,741 ERROR [corp-000] [GreenplumDdlReader] [qtp1783047508-12] Failed to read table: sym_node. Error: PANIC: ERRORDATA_STACK_SIZE exceeded (elog.c:1416)
2018-10-26 09:25:06,741 ERROR [corp-000] [GreenplumDdlReader] [qtp1783047508-12] Failed to get metadata for public.sym_node
2018-10-26 09:25:06,741 WARN [corp-000] [HttpChannel] [qtp1783047508-12] /sync/corp-000/registration StackTraceKey.init [SqlException:4052076445]
org.jumpmind.db.sql.SqlException: PANIC: ERRORDATA_STACK_SIZE exceeded (elog.c:1416)
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.platform.AbstractJdbcDdlReader.readTable(AbstractJdbcDdlReader.java:562)
at org.jumpmind.db.platform.AbstractDatabasePlatform.readTableFromDatabase(AbstractDatabasePlatform.java:259)
at org.jumpmind.symmetric.AbstractSymmetricEngine.isConfigured(AbstractSymmetricEngine.java:954)
at org.jumpmind.symmetric.web.SymmetricServlet.service(SymmetricServlet.java:144)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:833)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1650)
at org.jumpmind.symmetric.web.HttpMethodFilter.doFilter(HttpMethodFilter.java:62)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1637)
at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:533)
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143)
at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:548)
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)
at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:190)
at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1595)
at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:188)
at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1253)
at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:168)
at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:473)
at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1564)
at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:166)
at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1155)
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)
at org.eclipse.jetty.server.Server.handle(Server.java:561)
at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:334)
at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:251)
at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:279)
at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:104)
at org.eclipse.jetty.io.ChannelEndPoint$2.run(ChannelEndPoint.java:124)
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:247)
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.produce(EatWhatYouKill.java:140)
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:131)
at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:243)
at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:679)
at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:597)
at java.lang.Thread.run(Thread.java:748)
Caused by: org.postgresql.util.PSQLException: PANIC: ERRORDATA_STACK_SIZE exceeded (elog.c:1416)
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.executeQuery(PgStatement.java:224)
at org.postgresql.jdbc.PgDatabaseMetaData.getPrimaryKeys(PgDatabaseMetaData.java:2020)
at org.apache.commons.dbcp.DelegatingDatabaseMetaData.getPrimaryKeys(DelegatingDatabaseMetaData.java:456)
at org.jumpmind.db.platform.DatabaseMetaDataWrapper.getPrimaryKeys(DatabaseMetaDataWrapper.java:167)
at org.jumpmind.db.platform.AbstractJdbcDdlReader.readPrimaryKeyNames(AbstractJdbcDdlReader.java:1002)
at org.jumpmind.db.platform.AbstractJdbcDdlReader.readTable(AbstractJdbcDdlReader.java:692)
at org.jumpmind.db.platform.postgresql.PostgreSqlDdlReader.readTable(PostgreSqlDdlReader.java:65)
at org.jumpmind.db.platform.greenplum.GreenplumDdlReader.readTable(GreenplumDdlReader.java:99)
at org.jumpmind.db.platform.AbstractJdbcDdlReader$3.execute(AbstractJdbcDdlReader.java:577)
at org.jumpmind.db.platform.AbstractJdbcDdlReader$3.execute(AbstractJdbcDdlReader.java:562)
at org.jumpmind.db.sql.JdbcSqlTemplate.execute(JdbcSqlTemplate.java:501)
... 37 more
2018-10-26 14:52:59,073 INFO [] [AbstractCommandLauncher] [main] Option: name=engine, value={corp-000}
2018-10-26 14:52:59,074 INFO [] [AbstractCommandLauncher] [main] Option: name=format, value={XML}
2018-10-26 14:52:59,266 INFO [] [AbstractSymmetricEngine] [main] Initializing connection to database
2018-10-26 14:52:59,325 INFO [] [JdbcDatabasePlatformFactory] [main] Detected database 'greenplum', version '5', protocol 'postgresql'
2018-10-26 14:52:59,338 INFO [] [JdbcDatabasePlatformFactory] [main] The IDatabasePlatform being used is org.jumpmind.db.platform.greenplum.GreenplumPlatform
2018-10-26 14:52:59,418 INFO [] [DefaultDatabaseWriter] [main] About to create table using the following definition:
2018-10-26 14:52:59,608 INFO [] [DefaultDatabaseWriter] [main] About to create table using the following definition:
2018-10-26 14:52:59,791 INFO [] [DefaultDatabaseWriter] [main] About to create table using the following definition:
2018-10-26 14:52:59,897 INFO [] [DefaultDatabaseWriter] [main] About to create table using the following definition:
2018-10-26 14:54:21,798 INFO [] [AbstractCommandLauncher] [main] Option: name=engine, value={corp-000}
2018-10-26 14:54:22,108 INFO [] [SymmetricUtils] [main]
_____ __ _ ____ _____
/ ___/ __ _____ __ ___ __ ___ _/ /_ ____(_)___ / __ | / ___/
\__ \ / / / / _ `_ \/ _ `_ \/ _ \/_ __// __/ / __/ / / / / \__ \
___/ // /_/ / // // / // // / __// / / / / / /_ / /_/ / ___/ /
/____/ \__ /_//_//_/_//_//_/\___/ \_/ /_/ /_/\__/ /_____/ /____/
/____/
+-----------------------------------------------------------------+
| Copyright (C) 2007-2018 JumpMind, Inc. |
| |
| Licensed under the GNU General Public License version 3. |
| This software comes with ABSOLUTELY NO WARRANTY. |
| See http://www.gnu.org/licenses/gpl.html |
+-----------------------------------------------------------------+
2018-10-26 14:54:22,115 INFO [corp-000] [AbstractSymmetricEngine] [main] Initializing connection to database
2018-10-26 14:54:22,194 INFO [corp-000] [JdbcDatabasePlatformFactory] [main] Detected database 'greenplum', version '5', protocol 'postgresql'
2018-10-26 14:54:22,204 INFO [corp-000] [JdbcDatabasePlatformFactory] [main] The IDatabasePlatform being used is org.jumpmind.db.platform.greenplum.GreenplumPlatform
2018-10-26 14:54:22,249 INFO [corp-000] [GreenplumSymmetricDialect] [main] The DbDialect being used is org.jumpmind.symmetric.db.postgresql.GreenplumSymmetricDialect
2018-10-26 14:54:22,270 INFO [corp-000] [StagingManager] [main] The staging directory was initialized at the following location: /opt/websuite/symmetric-server-3.9.14/tmp/corp-000
2018-10-26 14:54:22,696 INFO [corp-000] [ClientExtensionService] [main] Found 6 extension points from spring that will be registered
2018-10-26 14:54:22,697 INFO [corp-000] [AbstractSymmetricEngine] [main] Initializing SymmetricDS database
2018-10-26 14:54:22,697 INFO [corp-000] [GreenplumSymmetricDialect] [main] Checking if SymmetricDS tables need created or altered
2018-10-26 14:54:23,159 INFO [corp-000] [GreenplumSymmetricDialect] [main] There are SymmetricDS tables that needed altered
2018-10-26 14:54:23,280 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_channel"(
"channel_id" VARCHAR(128) NOT NULL,
"processing_order" INTEGER DEFAULT 1 NOT NULL,
"max_batch_size" INTEGER DEFAULT 1000 NOT NULL,
"max_batch_to_send" INTEGER DEFAULT 60 NOT NULL,
"max_data_to_route" INTEGER DEFAULT 100000 NOT NULL,
"extract_period_millis" INTEGER DEFAULT 0 NOT NULL,
"enabled" SMALLINT DEFAULT 1 NOT NULL,
"use_old_data_to_route" SMALLINT DEFAULT 1 NOT NULL,
"use_row_data_to_route" SMALLINT DEFAULT 1 NOT NULL,
"use_pk_data_to_route" SMALLINT DEFAULT 1 NOT NULL,
"reload_flag" SMALLINT DEFAULT 0 NOT NULL,
"file_sync_flag" SMALLINT DEFAULT 0 NOT NULL,
"contains_big_lob" SMALLINT DEFAULT 0 NOT NULL,
"batch_algorithm" VARCHAR(50) DEFAULT 'default' NOT NULL,
"data_loader_type" VARCHAR(50) DEFAULT 'default' NOT NULL,
"description" VARCHAR(255),
"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")
)
2018-10-26 14:54:23,413 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_conflict"(
"conflict_id" VARCHAR(50) NOT NULL,
"source_node_group_id" VARCHAR(50) NOT NULL,
"target_node_group_id" VARCHAR(50) NOT NULL,
"target_channel_id" VARCHAR(128),
"target_catalog_name" VARCHAR(255),
"target_schema_name" VARCHAR(255),
"target_table_name" VARCHAR(255),
"detect_type" VARCHAR(128) NOT NULL,
"detect_expression" 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")
)
2018-10-26 14:54:23,546 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_context"(
"name" VARCHAR(80) NOT NULL,
"context_value" TEXT,
"create_time" TIMESTAMP,
"last_update_time" TIMESTAMP,
PRIMARY KEY ("name")
)
2018-10-26 14:54:23,597 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE SEQUENCE "sym_data_data_id_seq"
2018-10-26 14:54:23,729 INFO [corp-000] [GreenplumSymmetricDialect] [main] 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")
)
2018-10-26 14:54:23,796 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE INDEX "sym_idx_d_channel_id" ON "sym_data" ("data_id", "channel_id")
2018-10-26 14:54:23,880 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_data_event"(
"data_id" BIGINT NOT NULL,
"batch_id" BIGINT NOT NULL,
"router_id" VARCHAR(50) NOT NULL,
"create_time" TIMESTAMP,
PRIMARY KEY ("data_id", "batch_id", "router_id")
)
2018-10-26 14:54:23,945 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE INDEX "sym_idx_de_batchid" ON "sym_data_event" ("batch_id")
2018-10-26 14:54:24,032 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_data_gap"(
"start_id" BIGINT NOT NULL,
"end_id" BIGINT NOT NULL,
"status" CHAR(2),
"create_time" TIMESTAMP NOT NULL,
"last_update_hostname" VARCHAR(255),
"last_update_time" TIMESTAMP NOT NULL,
PRIMARY KEY ("start_id", "end_id")
)
2018-10-26 14:54:24,098 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE INDEX "sym_idx_dg_status" ON "sym_data_gap" ("status")
2018-10-26 14:54:24,228 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_extension"(
"extension_id" VARCHAR(50) NOT NULL,
"extension_type" VARCHAR(10) NOT NULL,
"interface_name" VARCHAR(255),
"node_group_id" VARCHAR(50) NOT NULL,
"enabled" SMALLINT DEFAULT 1 NOT NULL,
"extension_order" INTEGER DEFAULT 1 NOT NULL,
"extension_text" TEXT,
"create_time" TIMESTAMP,
"last_update_by" VARCHAR(50),
"last_update_time" TIMESTAMP,
PRIMARY KEY ("extension_id")
)
2018-10-26 14:54:24,310 INFO [corp-000] [GreenplumSymmetricDialect] [main] 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")
)
2018-10-26 14:54:24,395 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_file_incoming"(
"relative_dir" VARCHAR(255) NOT NULL,
"file_name" VARCHAR(128) NOT NULL,
"last_event_type" CHAR(1) NOT NULL,
"node_id" VARCHAR(50) NOT NULL,
"file_modified_time" BIGINT,
PRIMARY KEY ("relative_dir", "file_name")
)
2018-10-26 14:54:24,504 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_file_snapshot"(
"trigger_id" VARCHAR(128) NOT NULL,
"router_id" VARCHAR(50) NOT NULL,
"relative_dir" VARCHAR(255) NOT NULL,
"file_name" VARCHAR(128) NOT NULL,
"channel_id" VARCHAR(128) DEFAULT 'filesync' NOT NULL,
"reload_channel_id" VARCHAR(128) DEFAULT 'filesync_reload' NOT NULL,
"last_event_type" CHAR(1) NOT NULL,
"crc32_checksum" BIGINT,
"file_size" BIGINT,
"file_modified_time" BIGINT,
"last_update_time" TIMESTAMP NOT NULL,
"last_update_by" VARCHAR(50),
"create_time" TIMESTAMP NOT NULL,
PRIMARY KEY ("trigger_id", "router_id", "relative_dir", "file_name")
)
2018-10-26 14:54:24,572 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE INDEX "sym_idx_f_snpsht_chid" ON "sym_file_snapshot" ("reload_channel_id")
2018-10-26 14:54:24,722 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_file_trigger"(
"trigger_id" VARCHAR(128) NOT NULL,
"channel_id" VARCHAR(128) DEFAULT 'filesync' NOT NULL,
"reload_channel_id" VARCHAR(128) DEFAULT 'filesync_reload' NOT NULL,
"base_dir" VARCHAR(255) NOT NULL,
"recurse" SMALLINT DEFAULT 1 NOT NULL,
"includes_files" VARCHAR(255),
"excludes_files" VARCHAR(255),
"sync_on_create" SMALLINT DEFAULT 1 NOT NULL,
"sync_on_modified" SMALLINT DEFAULT 1 NOT NULL,
"sync_on_delete" SMALLINT DEFAULT 1 NOT NULL,
"sync_on_ctl_file" SMALLINT DEFAULT 0 NOT NULL,
"delete_after_sync" SMALLINT DEFAULT 0 NOT NULL,
"before_copy_script" 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")
)
2018-10-26 14:54:24,850 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_file_trigger_router"(
"trigger_id" VARCHAR(128) NOT NULL,
"router_id" VARCHAR(50) NOT NULL,
"enabled" SMALLINT DEFAULT 1 NOT NULL,
"initial_load_enabled" SMALLINT DEFAULT 1 NOT NULL,
"target_base_dir" VARCHAR(255),
"conflict_strategy" VARCHAR(128) DEFAULT 'source_wins' NOT NULL,
"create_time" TIMESTAMP NOT NULL,
"last_update_by" VARCHAR(50),
"last_update_time" TIMESTAMP NOT NULL,
"description" TEXT,
PRIMARY KEY ("trigger_id", "router_id")
)
2018-10-26 14:54:24,936 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_grouplet"(
"grouplet_id" VARCHAR(50) NOT NULL,
"grouplet_link_policy" CHAR(1) DEFAULT 'I' NOT NULL,
"description" VARCHAR(255),
"create_time" TIMESTAMP NOT NULL,
"last_update_by" VARCHAR(50),
"last_update_time" TIMESTAMP NOT NULL,
PRIMARY KEY ("grouplet_id")
)
2018-10-26 14:54:25,017 INFO [corp-000] [GreenplumSymmetricDialect] [main] 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")
)
2018-10-26 14:54:25,166 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_incoming_batch"(
"batch_id" BIGINT NOT NULL,
"node_id" VARCHAR(50) NOT NULL,
"channel_id" VARCHAR(128),
"status" CHAR(2),
"error_flag" SMALLINT DEFAULT 0,
"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")
)
2018-10-26 14:54:25,234 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE INDEX "sym_idx_ib_time_status" ON "sym_incoming_batch" ("create_time", "status")
2018-10-26 14:54:25,303 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE INDEX "sym_idx_ib_in_error" ON "sym_incoming_batch" ("error_flag")
2018-10-26 14:54:25,436 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_incoming_error"(
"batch_id" BIGINT NOT NULL,
"node_id" VARCHAR(50) NOT NULL,
"failed_row_number" BIGINT NOT NULL,
"failed_line_number" BIGINT DEFAULT 0 NOT NULL,
"target_catalog_name" VARCHAR(255),
"target_schema_name" VARCHAR(255),
"target_table_name" VARCHAR(255) NOT NULL,
"event_type" CHAR(1) NOT NULL,
"binary_encoding" VARCHAR(10) DEFAULT 'HEX' NOT NULL,
"column_names" 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")
)
2018-10-26 14:54:25,569 INFO [corp-000] [GreenplumSymmetricDialect] [main] 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")
)
2018-10-26 14:54:25,701 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_load_filter"(
"load_filter_id" VARCHAR(50) NOT NULL,
"load_filter_type" VARCHAR(10) NOT NULL,
"source_node_group_id" VARCHAR(50) NOT NULL,
"target_node_group_id" VARCHAR(50) NOT NULL,
"target_catalog_name" VARCHAR(255),
"target_schema_name" VARCHAR(255),
"target_table_name" VARCHAR(255),
"filter_on_update" SMALLINT DEFAULT 1 NOT NULL,
"filter_on_insert" SMALLINT DEFAULT 1 NOT NULL,
"filter_on_delete" SMALLINT DEFAULT 1 NOT NULL,
"before_write_script" 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")
)
2018-10-26 14:54:25,789 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_lock"(
"lock_action" VARCHAR(50) NOT NULL,
"lock_type" VARCHAR(50) NOT NULL,
"locking_server_id" VARCHAR(255),
"lock_time" TIMESTAMP,
"shared_count" INTEGER DEFAULT 0 NOT NULL,
"shared_enable" INTEGER DEFAULT 0 NOT NULL,
"last_lock_time" TIMESTAMP,
"last_locking_server_id" VARCHAR(255),
PRIMARY KEY ("lock_action")
)
2018-10-26 14:54:25,877 INFO [corp-000] [GreenplumSymmetricDialect] [main] 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")
)
2018-10-26 14:54:25,970 INFO [corp-000] [GreenplumSymmetricDialect] [main] 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")
)
2018-10-26 14:54:26,062 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_node_channel_ctl"(
"node_id" VARCHAR(50) NOT NULL,
"channel_id" VARCHAR(128) NOT NULL,
"suspend_enabled" SMALLINT DEFAULT 0,
"ignore_enabled" SMALLINT DEFAULT 0,
"last_extract_time" TIMESTAMP,
PRIMARY KEY ("node_id", "channel_id")
)
2018-10-26 14:54:26,147 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_node_group"(
"node_group_id" VARCHAR(50) NOT NULL,
"description" VARCHAR(255),
"create_time" TIMESTAMP,
"last_update_by" VARCHAR(50),
"last_update_time" TIMESTAMP,
PRIMARY KEY ("node_group_id")
)
2018-10-26 14:54:26,230 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_node_group_channel_wnd"(
"node_group_id" VARCHAR(50) NOT NULL,
"channel_id" VARCHAR(128) NOT NULL,
"start_time" TIMESTAMP NOT NULL,
"end_time" TIMESTAMP NOT NULL,
"enabled" SMALLINT DEFAULT 0 NOT NULL,
PRIMARY KEY ("node_group_id", "channel_id", "start_time", "end_time")
)
2018-10-26 14:54:26,312 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_node_group_link"(
"source_node_group_id" VARCHAR(50) NOT NULL,
"target_node_group_id" VARCHAR(50) NOT NULL,
"data_event_action" CHAR(1) DEFAULT 'W' NOT NULL,
"sync_config_enabled" SMALLINT DEFAULT 1 NOT NULL,
"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")
)
2018-10-26 14:54:26,401 INFO [corp-000] [GreenplumSymmetricDialect] [main] 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")
)
2018-10-26 14:54:26,494 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_node_host_channel_stats"(
"node_id" VARCHAR(50) NOT NULL,
"host_name" VARCHAR(60) NOT NULL,
"channel_id" VARCHAR(128) NOT NULL,
"start_time" TIMESTAMP NOT NULL,
"end_time" TIMESTAMP NOT NULL,
"data_routed" BIGINT DEFAULT 0,
"data_unrouted" BIGINT DEFAULT 0,
"data_event_inserted" BIGINT DEFAULT 0,
"data_extracted" BIGINT DEFAULT 0,
"data_bytes_extracted" BIGINT DEFAULT 0,
"data_extracted_errors" BIGINT DEFAULT 0,
"data_bytes_sent" BIGINT DEFAULT 0,
"data_sent" BIGINT DEFAULT 0,
"data_sent_errors" BIGINT DEFAULT 0,
"data_loaded" BIGINT DEFAULT 0,
"data_bytes_loaded" BIGINT DEFAULT 0,
"data_loaded_errors" BIGINT DEFAULT 0,
PRIMARY KEY ("node_id", "host_name", "channel_id", "start_time", "end_time")
)
2018-10-26 14:54:26,563 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE INDEX "sym_idx_nd_hst_chnl_sts" ON "sym_node_host_channel_stats" ("node_id", "start_time", "end_time")
2018-10-26 14:54:26,654 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_node_host_job_stats"(
"node_id" VARCHAR(50) NOT NULL,
"host_name" VARCHAR(60) NOT NULL,
"job_name" VARCHAR(50) NOT NULL,
"start_time" TIMESTAMP NOT NULL,
"end_time" TIMESTAMP NOT NULL,
"processed_count" BIGINT DEFAULT 0,
"target_node_id" VARCHAR(50),
"target_node_count" INTEGER DEFAULT 0,
PRIMARY KEY ("node_id", "host_name", "job_name", "start_time", "end_time")
)
2018-10-26 14:54:26,723 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE INDEX "sym_idx_nd_hst_job" ON "sym_node_host_job_stats" ("node_id", "start_time", "end_time")
2018-10-26 14:54:26,821 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_node_host_stats"(
"node_id" VARCHAR(50) NOT NULL,
"host_name" VARCHAR(60) NOT NULL,
"start_time" TIMESTAMP NOT NULL,
"end_time" TIMESTAMP NOT NULL,
"restarted" BIGINT DEFAULT 0 NOT NULL,
"nodes_pulled" BIGINT DEFAULT 0,
"total_nodes_pull_time" BIGINT DEFAULT 0,
"nodes_pushed" BIGINT DEFAULT 0,
"total_nodes_push_time" BIGINT DEFAULT 0,
"nodes_rejected" BIGINT DEFAULT 0,
"nodes_registered" BIGINT DEFAULT 0,
"nodes_loaded" BIGINT DEFAULT 0,
"nodes_disabled" BIGINT DEFAULT 0,
"purged_data_rows" BIGINT DEFAULT 0,
"purged_data_event_rows" BIGINT DEFAULT 0,
"purged_batch_outgoing_rows" BIGINT DEFAULT 0,
"purged_batch_incoming_rows" BIGINT DEFAULT 0,
"triggers_created_count" BIGINT,
"triggers_rebuilt_count" BIGINT,
"triggers_removed_count" BIGINT,
PRIMARY KEY ("node_id", "host_name", "start_time", "end_time")
)
2018-10-26 14:54:26,888 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE INDEX "sym_idx_nd_hst_sts" ON "sym_node_host_stats" ("node_id", "start_time", "end_time")
2018-10-26 14:54:26,973 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_node_identity"(
"node_id" VARCHAR(50) NOT NULL,
PRIMARY KEY ("node_id")
)
2018-10-26 14:54:27,060 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_node_security"(
"node_id" VARCHAR(50) NOT NULL,
"node_password" VARCHAR(50) NOT NULL,
"registration_enabled" SMALLINT DEFAULT 0,
"registration_time" TIMESTAMP,
"initial_load_enabled" SMALLINT DEFAULT 0,
"initial_load_time" TIMESTAMP,
"initial_load_id" BIGINT,
"initial_load_create_by" VARCHAR(255),
"rev_initial_load_enabled" SMALLINT DEFAULT 0,
"rev_initial_load_time" TIMESTAMP,
"rev_initial_load_id" BIGINT,
"rev_initial_load_create_by" VARCHAR(255),
"created_at_node_id" VARCHAR(50),
PRIMARY KEY ("node_id")
)
2018-10-26 14:54:27,191 INFO [corp-000] [GreenplumSymmetricDialect] [main] 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")
)
2018-10-26 14:54:27,323 INFO [corp-000] [GreenplumSymmetricDialect] [main] 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")
)
2018-10-26 14:54:27,458 INFO [corp-000] [GreenplumSymmetricDialect] [main] 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")
)
2018-10-26 14:54:27,603 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_outgoing_batch"(
"batch_id" BIGINT NOT NULL,
"node_id" VARCHAR(50) NOT NULL,
"channel_id" VARCHAR(128),
"status" CHAR(2),
"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")
)
2018-10-26 14:54:27,670 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE INDEX "sym_idx_ob_node_status" ON "sym_outgoing_batch" ("node_id", "status")
2018-10-26 14:54:27,734 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE INDEX "sym_idx_ob_status" ON "sym_outgoing_batch" ("status")
2018-10-26 14:54:27,803 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE INDEX "sym_idx_ob_in_error" ON "sym_outgoing_batch" ("error_flag")
2018-10-26 14:54:27,935 INFO [corp-000] [GreenplumSymmetricDialect] [main] 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")
)
2018-10-26 14:54:28,019 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_registration_redirect"(
"registrant_external_id" VARCHAR(255) NOT NULL,
"registration_node_id" VARCHAR(50) NOT NULL,
PRIMARY KEY ("registrant_external_id")
)
2018-10-26 14:54:28,154 INFO [corp-000] [GreenplumSymmetricDialect] [main] 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")
)
2018-10-26 14:54:28,222 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE INDEX "sym_idx_reg_req_1" ON "sym_registration_request" ("node_group_id", "external_id", "status", "host_name", "ip_address")
2018-10-26 14:54:28,310 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE INDEX "sym_idx_reg_req_2" ON "sym_registration_request" ("status")
2018-10-26 14:54:28,442 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_router"(
"router_id" VARCHAR(50) NOT NULL,
"target_catalog_name" VARCHAR(255),
"target_schema_name" VARCHAR(255),
"target_table_name" VARCHAR(255),
"source_node_group_id" VARCHAR(50) NOT NULL,
"target_node_group_id" VARCHAR(50) NOT NULL,
"router_type" VARCHAR(50),
"router_expression" 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")
)
2018-10-26 14:54:28,529 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_sequence"(
"sequence_name" VARCHAR(50) NOT NULL,
"current_value" BIGINT DEFAULT 0 NOT NULL,
"increment_by" INTEGER DEFAULT 1 NOT NULL,
"min_value" BIGINT DEFAULT 1 NOT NULL,
"max_value" BIGINT DEFAULT 9999999999 NOT NULL,
"cycle_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")
)
2018-10-26 14:54:28,662 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_table_reload_request"(
"target_node_id" VARCHAR(50) NOT NULL,
"source_node_id" VARCHAR(50) NOT NULL,
"trigger_id" VARCHAR(128) NOT NULL,
"router_id" VARCHAR(50) NOT NULL,
"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")
)
2018-10-26 14:54:28,797 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_transform_table"(
"transform_id" VARCHAR(50) NOT NULL,
"source_node_group_id" VARCHAR(50) NOT NULL,
"target_node_group_id" VARCHAR(50) NOT NULL,
"transform_point" VARCHAR(10) NOT NULL,
"source_catalog_name" VARCHAR(255),
"source_schema_name" VARCHAR(255),
"source_table_name" VARCHAR(255) NOT NULL,
"target_catalog_name" VARCHAR(255),
"target_schema_name" VARCHAR(255),
"target_table_name" VARCHAR(255),
"update_first" SMALLINT DEFAULT 0,
"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")
)
2018-10-26 14:54:28,929 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_transform_column"(
"transform_id" VARCHAR(50) NOT NULL,
"include_on" CHAR(1) DEFAULT '*' NOT NULL,
"target_column_name" VARCHAR(128) NOT NULL,
"source_column_name" VARCHAR(128),
"pk" SMALLINT DEFAULT 0,
"transform_type" VARCHAR(50) DEFAULT 'copy',
"transform_expression" 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")
)
2018-10-26 14:54:29,059 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_trigger"(
"trigger_id" VARCHAR(128) NOT NULL,
"source_catalog_name" VARCHAR(255),
"source_schema_name" VARCHAR(255),
"source_table_name" VARCHAR(255) NOT NULL,
"channel_id" VARCHAR(128) NOT NULL,
"reload_channel_id" VARCHAR(128) DEFAULT 'reload' NOT NULL,
"sync_on_update" SMALLINT DEFAULT 1 NOT NULL,
"sync_on_insert" SMALLINT DEFAULT 1 NOT NULL,
"sync_on_delete" SMALLINT DEFAULT 1 NOT NULL,
"sync_on_incoming_batch" SMALLINT DEFAULT 0 NOT NULL,
"name_for_update_trigger" VARCHAR(255),
"name_for_insert_trigger" VARCHAR(255),
"name_for_delete_trigger" VARCHAR(255),
"sync_on_update_condition" 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")
)
2018-10-26 14:54:29,188 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_trigger_hist"(
"trigger_hist_id" INTEGER NOT NULL,
"trigger_id" VARCHAR(128) NOT NULL,
"source_table_name" VARCHAR(255) NOT NULL,
"source_catalog_name" VARCHAR(255),
"source_schema_name" VARCHAR(255),
"name_for_update_trigger" VARCHAR(255),
"name_for_insert_trigger" VARCHAR(255),
"name_for_delete_trigger" VARCHAR(255),
"table_hash" BIGINT DEFAULT 0 NOT NULL,
"trigger_row_hash" BIGINT DEFAULT 0 NOT NULL,
"trigger_template_hash" BIGINT DEFAULT 0 NOT NULL,
"column_names" 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")
)
2018-10-26 14:54:29,253 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE INDEX "sym_idx_trigg_hist_1" ON "sym_trigger_hist" ("trigger_id", "inactive_time")
2018-10-26 14:54:29,389 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_trigger_router"(
"trigger_id" VARCHAR(128) NOT NULL,
"router_id" VARCHAR(50) NOT NULL,
"enabled" SMALLINT DEFAULT 1 NOT NULL,
"initial_load_order" INTEGER DEFAULT 1 NOT NULL,
"initial_load_select" 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")
)
2018-10-26 14:54:29,476 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_trigger_router_grouplet"(
"grouplet_id" VARCHAR(50) NOT NULL,
"trigger_id" VARCHAR(128) NOT NULL,
"router_id" VARCHAR(50) NOT NULL,
"applies_when" CHAR(1) NOT NULL,
"create_time" TIMESTAMP NOT NULL,
"last_update_by" VARCHAR(50),
"last_update_time" TIMESTAMP NOT NULL,
PRIMARY KEY ("grouplet_id", "trigger_id", "router_id", "applies_when")
)
2018-10-26 14:54:29,505 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: ALTER TABLE "sym_conflict"
ADD CONSTRAINT "sym_fk_cf_2_grp_lnk" FOREIGN KEY ("source_node_group_id", "target_node_group_id") REFERENCES "sym_node_group_link" ("source_node_group_id", "target_node_group_id")
2018-10-26 14:54:29,534 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: ALTER TABLE "sym_file_trigger_router"
ADD CONSTRAINT "sym_fk_ftr_2_ftrg" FOREIGN KEY ("trigger_id") REFERENCES "sym_file_trigger" ("trigger_id")
2018-10-26 14:54:29,560 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: ALTER TABLE "sym_file_trigger_router"
ADD CONSTRAINT "sym_fk_ftr_2_rtr" FOREIGN KEY ("router_id") REFERENCES "sym_router" ("router_id")
2018-10-26 14:54:29,587 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: ALTER TABLE "sym_grouplet_link"
ADD CONSTRAINT "sym_fk_gpltlnk_2_gplt" FOREIGN KEY ("grouplet_id") REFERENCES "sym_grouplet" ("grouplet_id")
2018-10-26 14:54:29,610 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: ALTER TABLE "sym_node_group_link"
ADD CONSTRAINT "sym_fk_lnk_2_grp_src" FOREIGN KEY ("source_node_group_id") REFERENCES "sym_node_group" ("node_group_id")
2018-10-26 14:54:29,638 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: ALTER TABLE "sym_node_group_link"
ADD CONSTRAINT "sym_fk_lnk_2_grp_tgt" FOREIGN KEY ("target_node_group_id") REFERENCES "sym_node_group" ("node_group_id")
2018-10-26 14:54:29,663 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: ALTER TABLE "sym_node_identity"
ADD CONSTRAINT "sym_fk_ident_2_node" FOREIGN KEY ("node_id") REFERENCES "sym_node" ("node_id")
2018-10-26 14:54:29,693 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: ALTER TABLE "sym_node_security"
ADD CONSTRAINT "sym_fk_sec_2_node" FOREIGN KEY ("node_id") REFERENCES "sym_node" ("node_id")
2018-10-26 14:54:29,739 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: ALTER TABLE "sym_router"
ADD CONSTRAINT "sym_fk_rt_2_grp_lnk" FOREIGN KEY ("source_node_group_id", "target_node_group_id") REFERENCES "sym_node_group_link" ("source_node_group_id", "target_node_group_id")
2018-10-26 14:54:29,767 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: ALTER TABLE "sym_transform_table"
ADD CONSTRAINT "sym_fk_tt_2_grp_lnk" FOREIGN KEY ("source_node_group_id", "target_node_group_id") REFERENCES "sym_node_group_link" ("source_node_group_id", "target_node_group_id")
2018-10-26 14:54:29,793 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: ALTER TABLE "sym_trigger"
ADD CONSTRAINT "sym_fk_trg_2_chnl" FOREIGN KEY ("channel_id") REFERENCES "sym_channel" ("channel_id")
2018-10-26 14:54:29,824 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: ALTER TABLE "sym_trigger"
ADD CONSTRAINT "sym_fk_trg_2_rld_chnl" FOREIGN KEY ("reload_channel_id") REFERENCES "sym_channel" ("channel_id")
2018-10-26 14:54:29,851 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: ALTER TABLE "sym_trigger_router"
ADD CONSTRAINT "sym_fk_tr_2_trg" FOREIGN KEY ("trigger_id") REFERENCES "sym_trigger" ("trigger_id")
2018-10-26 14:54:29,879 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: ALTER TABLE "sym_trigger_router"
ADD CONSTRAINT "sym_fk_tr_2_rtr" FOREIGN KEY ("router_id") REFERENCES "sym_router" ("router_id")
2018-10-26 14:54:29,903 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: ALTER TABLE "sym_trigger_router_grouplet"
ADD CONSTRAINT "sym_fk_trgplt_2_gplt" FOREIGN KEY ("grouplet_id") REFERENCES "sym_grouplet" ("grouplet_id")
2018-10-26 14:54:29,948 INFO [corp-000] [GreenplumSymmetricDialect] [main] DDL applied: ALTER TABLE "sym_trigger_router_grouplet"
ADD CONSTRAINT "sym_fk_trgplt_2_tr" FOREIGN KEY ("trigger_id", "router_id") REFERENCES "sym_trigger_router" ("trigger_id", "router_id")
2018-10-26 14:54:30,065 INFO [corp-000] [GreenplumSymmetricDialect] [main] Done with auto update of SymmetricDS tables
2018-10-26 14:54:30,111 INFO [corp-000] [ConfigurationService] [main] Auto-configuring config channel
2018-10-26 14:54:30,209 INFO [corp-000] [ConfigurationService] [main] Auto-configuring reload channel
2018-10-26 14:54:30,282 INFO [corp-000] [ConfigurationService] [main] Auto-configuring monitor channel
2018-10-26 14:54:30,357 INFO [corp-000] [ConfigurationService] [main] Auto-configuring heartbeat channel
2018-10-26 14:54:30,419 INFO [corp-000] [ConfigurationService] [main] Auto-configuring default channel
2018-10-26 14:54:30,481 INFO [corp-000] [ConfigurationService] [main] Auto-configuring dynamic channel
2018-10-26 14:54:31,098 INFO [corp-000] [AbstractSymmetricEngine] [main] Inserting rows for node, security, identity and group for registration server
2018-10-26 14:54:31,586 INFO [corp-000] [AbstractSymmetricEngine] [main] Done initializing SymmetricDS database
2018-10-26 14:55:34,721 INFO [] [AbstractCommandLauncher] [main] Option: name=engine, value={corp-000}
2018-10-26 14:55:34,911 INFO [] [AbstractSymmetricEngine] [main] Initializing connection to database
2018-10-26 14:55:34,968 INFO [] [JdbcDatabasePlatformFactory] [main] Detected database 'greenplum', version '5', protocol 'postgresql'
2018-10-26 14:55:34,982 INFO [] [JdbcDatabasePlatformFactory] [main] The IDatabasePlatform being used is org.jumpmind.db.platform.greenplum.GreenplumPlatform
2018-10-29 10:20:54,332 INFO [startup] [AbstractCommandLauncher] [main] Option: name=engine, value={corp-000}
2018-10-29 10:20:54,333 INFO [startup] [AbstractCommandLauncher] [main] Option: name=port, value={8888}
2018-10-29 10:20:54,457 INFO [startup] [SymmetricUtils] [main]
_____ __ _ ____ _____
/ ___/ __ _____ __ ___ __ ___ _/ /_ ____(_)___ / __ | / ___/
\__ \ / / / / _ `_ \/ _ `_ \/ _ \/_ __// __/ / __/ / / / / \__ \
___/ // /_/ / // // / // // / __// / / / / / /_ / /_/ / ___/ /
/____/ \__ /_//_//_/_//_//_/\___/ \_/ /_/ /_/\__/ /_____/ /____/
/____/
+-----------------------------------------------------------------+
| Copyright (C) 2007-2018 JumpMind, Inc. |
| |
| Licensed under the GNU General Public License version 3. |
| This software comes with ABSOLUTELY NO WARRANTY. |
| See http://www.gnu.org/licenses/gpl.html |
+-----------------------------------------------------------------+
2018-10-29 10:20:54,487 INFO [startup] [SymmetricWebServer] [main] About to start SymmetricDS web server on host:port 0.0.0.0:8888
2018-10-29 10:20:54,797 INFO [corp-000] [AbstractSymmetricEngine] [symmetric-engine-startup-1] Initializing connection to database
2018-10-29 10:20:54,988 INFO [corp-000] [JdbcDatabasePlatformFactory] [symmetric-engine-startup-1] Detected database 'greenplum', version '5', protocol 'postgresql'
2018-10-29 10:20:54,999 INFO [corp-000] [JdbcDatabasePlatformFactory] [symmetric-engine-startup-1] The IDatabasePlatform being used is org.jumpmind.db.platform.greenplum.GreenplumPlatform
2018-10-29 10:20:55,342 INFO [corp-000] [GreenplumSymmetricDialect] [symmetric-engine-startup-1] The DbDialect being used is org.jumpmind.symmetric.db.postgresql.GreenplumSymmetricDialect
2018-10-29 10:20:55,452 INFO [corp-000] [ExtensionService] [symmetric-engine-startup-1] Found 0 extension points from the database that will be registered
2018-10-29 10:20:55,457 INFO [corp-000] [StagingManager] [symmetric-engine-startup-1] The staging directory was initialized at the following location: /opt/websuite/symmetric-server-3.9.14/tmp/corp-000
2018-10-29 10:20:55,709 INFO [startup] [SymmetricWebServer] [main] Starting JMX HTTP console on port 8889
2018-10-29 10:20:55,746 INFO [startup] [SymmetricWebServer] [main] Joining the web server main thread
2018-10-29 10:20:55,930 INFO [corp-000] [ExtensionService] [symmetric-engine-startup-1] Found 0 extension points from the database that will be registered
2018-10-29 10:20:55,930 INFO [corp-000] [ClientExtensionService] [symmetric-engine-startup-1] Found 7 extension points from spring that will be registered
2018-10-29 10:20:55,936 INFO [corp-000] [AbstractSymmetricEngine] [symmetric-engine-startup-1] Initializing SymmetricDS database
2018-10-29 10:20:55,936 INFO [corp-000] [GreenplumSymmetricDialect] [symmetric-engine-startup-1] Checking if SymmetricDS tables need created or altered
2018-10-29 10:20:56,105 ERROR [corp-000] [GreenplumDdlReader] [symmetric-engine-startup-1] Failed to read table: sym_context. Error: PANIC: ERRORDATA_STACK_SIZE exceeded (elog.c:1416)
2018-10-29 10:20:56,108 ERROR [corp-000] [GreenplumDdlReader] [symmetric-engine-startup-1] Failed to get metadata for public.sym_context
2018-10-29 10:20:56,109 ERROR [corp-000] [AbstractSymmetricEngine] [symmetric-engine-startup-1] An error occurred while starting SymmetricDS StackTraceKey.init [SqlException:3075436943]
org.jumpmind.db.sql.SqlException: PANIC: ERRORDATA_STACK_SIZE exceeded (elog.c:1416)
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.platform.AbstractJdbcDdlReader.readTable(AbstractJdbcDdlReader.java:562)
at org.jumpmind.db.platform.AbstractDatabasePlatform.readTableFromDatabase(AbstractDatabasePlatform.java:259)
at org.jumpmind.db.platform.AbstractDatabasePlatform.getTableFromCache(AbstractDatabasePlatform.java:328)
at org.jumpmind.db.platform.AbstractDatabasePlatform.readFromDatabase(AbstractDatabasePlatform.java:245)
at org.jumpmind.symmetric.db.AbstractSymmetricDialect.readSymmetricSchemaFromDatabase(AbstractSymmetricDialect.java:593)
at org.jumpmind.symmetric.db.AbstractSymmetricDialect.createOrAlterTablesIfNecessary(AbstractSymmetricDialect.java:502)
at org.jumpmind.symmetric.db.AbstractSymmetricDialect.initTablesAndDatabaseObjects(AbstractSymmetricDialect.java:159)
at org.jumpmind.symmetric.AbstractSymmetricEngine.setupDatabase(AbstractSymmetricEngine.java:501)
at org.jumpmind.symmetric.AbstractSymmetricEngine.setup(AbstractSymmetricEngine.java:475)
at org.jumpmind.symmetric.AbstractSymmetricEngine.start(AbstractSymmetricEngine.java:645)
at org.jumpmind.symmetric.AbstractSymmetricEngine.start(AbstractSymmetricEngine.java:634)
at org.jumpmind.symmetric.ClientSymmetricEngine.start(ClientSymmetricEngine.java:276)
at org.jumpmind.symmetric.web.SymmetricEngineHolder$EngineStarter.run(SymmetricEngineHolder.java:600)
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: PANIC: ERRORDATA_STACK_SIZE exceeded (elog.c:1416)
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.executeQuery(PgStatement.java:224)
at org.postgresql.jdbc.PgDatabaseMetaData.getPrimaryKeys(PgDatabaseMetaData.java:2020)
at org.apache.commons.dbcp.DelegatingDatabaseMetaData.getPrimaryKeys(DelegatingDatabaseMetaData.java:456)
at org.jumpmind.db.platform.DatabaseMetaDataWrapper.getPrimaryKeys(DatabaseMetaDataWrapper.java:167)
at org.jumpmind.db.platform.AbstractJdbcDdlReader.readPrimaryKeyNames(AbstractJdbcDdlReader.java:1002)
at org.jumpmind.db.platform.AbstractJdbcDdlReader.readTable(AbstractJdbcDdlReader.java:692)
at org.jumpmind.db.platform.postgresql.PostgreSqlDdlReader.readTable(PostgreSqlDdlReader.java:65)
at org.jumpmind.db.platform.greenplum.GreenplumDdlReader.readTable(GreenplumDdlReader.java:99)
at org.jumpmind.db.platform.AbstractJdbcDdlReader$3.execute(AbstractJdbcDdlReader.java:577)
at org.jumpmind.db.platform.AbstractJdbcDdlReader$3.execute(AbstractJdbcDdlReader.java:562)
at org.jumpmind.db.sql.JdbcSqlTemplate.execute(JdbcSqlTemplate.java:501)
... 16 more
2018-10-29 10:20:56,127 INFO [corp-000] [AbstractSymmetricEngine] [symmetric-engine-startup-1] Stopping SymmetricDS externalId=000 version=3.9.14 database=PostgreSQL
2018-10-29 10:20:56,127 INFO [corp-000] [AbstractSymmetricEngine] [symmetric-engine-startup-1]
2018-10-29 13:50:02,133 INFO [startup] [AbstractCommandLauncher] [main] Option: name=engine, value={corp-000}
2018-10-29 13:50:02,133 INFO [startup] [AbstractCommandLauncher] [main] Option: name=port, value={8888}
2018-10-29 13:50:02,254 INFO [startup] [SymmetricUtils] [main]
_____ __ _ ____ _____
/ ___/ __ _____ __ ___ __ ___ _/ /_ ____(_)___ / __ | / ___/
\__ \ / / / / _ `_ \/ _ `_ \/ _ \/_ __// __/ / __/ / / / / \__ \
___/ // /_/ / // // / // // / __// / / / / / /_ / /_/ / ___/ /
/____/ \__ /_//_//_/_//_//_/\___/ \_/ /_/ /_/\__/ /_____/ /____/
/____/
+-----------------------------------------------------------------+
| Copyright (C) 2007-2018 JumpMind, Inc. |
| |
| Licensed under the GNU General Public License version 3. |
| This software comes with ABSOLUTELY NO WARRANTY. |
| See http://www.gnu.org/licenses/gpl.html |
+-----------------------------------------------------------------+
2018-10-29 13:50:02,287 INFO [startup] [SymmetricWebServer] [main] About to start SymmetricDS web server on host:port 0.0.0.0:8888
2018-10-29 13:50:02,611 INFO [corp-000] [AbstractSymmetricEngine] [symmetric-engine-startup-1] Initializing connection to database
2018-10-29 13:50:02,794 INFO [corp-000] [JdbcDatabasePlatformFactory] [symmetric-engine-startup-1] Detected database 'greenplum', version '5', protocol 'postgresql'
2018-10-29 13:50:02,805 INFO [corp-000] [JdbcDatabasePlatformFactory] [symmetric-engine-startup-1] The IDatabasePlatform being used is org.jumpmind.db.platform.greenplum.GreenplumPlatform
2018-10-29 13:50:03,129 INFO [corp-000] [GreenplumSymmetricDialect] [symmetric-engine-startup-1] The DbDialect being used is org.jumpmind.symmetric.db.postgresql.GreenplumSymmetricDialect
2018-10-29 13:50:03,231 INFO [corp-000] [ExtensionService] [symmetric-engine-startup-1] Found 0 extension points from the database that will be registered
2018-10-29 13:50:03,234 INFO [corp-000] [StagingManager] [symmetric-engine-startup-1] The staging directory was initialized at the following location: /opt/websuite/symmetric-server-3.9.14/tmp/corp-000
2018-10-29 13:50:03,643 INFO [startup] [SymmetricWebServer] [main] Starting JMX HTTP console on port 8889
2018-10-29 13:50:03,657 INFO [startup] [SymmetricWebServer] [main] Joining the web server main thread
2018-10-29 13:50:03,684 INFO [corp-000] [ExtensionService] [symmetric-engine-startup-1] Found 0 extension points from the database that will be registered
2018-10-29 13:50:03,684 INFO [corp-000] [ClientExtensionService] [symmetric-engine-startup-1] Found 7 extension points from spring that will be registered
2018-10-29 13:50:03,691 INFO [corp-000] [AbstractSymmetricEngine] [symmetric-engine-startup-1] Initializing SymmetricDS database
2018-10-29 13:50:03,691 INFO [corp-000] [GreenplumSymmetricDialect] [symmetric-engine-startup-1] Checking if SymmetricDS tables need created or altered
2018-10-29 13:50:03,868 ERROR [corp-000] [GreenplumDdlReader] [symmetric-engine-startup-1] Failed to read table: sym_context. Error: PANIC: ERRORDATA_STACK_SIZE exceeded (elog.c:1416)
2018-10-29 13:50:03,875 ERROR [corp-000] [GreenplumDdlReader] [symmetric-engine-startup-1] Failed to get metadata for public.sym_context
2018-10-29 13:50:03,875 ERROR [corp-000] [AbstractSymmetricEngine] [symmetric-engine-startup-1] An error occurred while starting SymmetricDS StackTraceKey.init [SqlException:3075436943]
org.jumpmind.db.sql.SqlException: PANIC: ERRORDATA_STACK_SIZE exceeded (elog.c:1416)
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.platform.AbstractJdbcDdlReader.readTable(AbstractJdbcDdlReader.java:562)
at org.jumpmind.db.platform.AbstractDatabasePlatform.readTableFromDatabase(AbstractDatabasePlatform.java:259)
at org.jumpmind.db.platform.AbstractDatabasePlatform.getTableFromCache(AbstractDatabasePlatform.java:328)
at org.jumpmind.db.platform.AbstractDatabasePlatform.readFromDatabase(AbstractDatabasePlatform.java:245)
at org.jumpmind.symmetric.db.AbstractSymmetricDialect.readSymmetricSchemaFromDatabase(AbstractSymmetricDialect.java:593)
at org.jumpmind.symmetric.db.AbstractSymmetricDialect.createOrAlterTablesIfNecessary(AbstractSymmetricDialect.java:502)
at org.jumpmind.symmetric.db.AbstractSymmetricDialect.initTablesAndDatabaseObjects(AbstractSymmetricDialect.java:159)
at org.jumpmind.symmetric.AbstractSymmetricEngine.setupDatabase(AbstractSymmetricEngine.java:501)
at org.jumpmind.symmetric.AbstractSymmetricEngine.setup(AbstractSymmetricEngine.java:475)
at org.jumpmind.symmetric.AbstractSymmetricEngine.start(AbstractSymmetricEngine.java:645)
at org.jumpmind.symmetric.AbstractSymmetricEngine.start(AbstractSymmetricEngine.java:634)
at org.jumpmind.symmetric.ClientSymmetricEngine.start(ClientSymmetricEngine.java:276)
at org.jumpmind.symmetric.web.SymmetricEngineHolder$EngineStarter.run(SymmetricEngineHolder.java:600)
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: PANIC: ERRORDATA_STACK_SIZE exceeded (elog.c:1416)
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.executeQuery(PgStatement.java:224)
at org.postgresql.jdbc.PgDatabaseMetaData.getPrimaryKeys(PgDatabaseMetaData.java:2020)
at org.apache.commons.dbcp.DelegatingDatabaseMetaData.getPrimaryKeys(DelegatingDatabaseMetaData.java:456)
at org.jumpmind.db.platform.DatabaseMetaDataWrapper.getPrimaryKeys(DatabaseMetaDataWrapper.java:167)
at org.jumpmind.db.platform.AbstractJdbcDdlReader.readPrimaryKeyNames(AbstractJdbcDdlReader.java:1002)
at org.jumpmind.db.platform.AbstractJdbcDdlReader.readTable(AbstractJdbcDdlReader.java:692)
at org.jumpmind.db.platform.postgresql.PostgreSqlDdlReader.readTable(PostgreSqlDdlReader.java:65)
at org.jumpmind.db.platform.greenplum.GreenplumDdlReader.readTable(GreenplumDdlReader.java:99)
at org.jumpmind.db.platform.AbstractJdbcDdlReader$3.execute(AbstractJdbcDdlReader.java:577)
at org.jumpmind.db.platform.AbstractJdbcDdlReader$3.execute(AbstractJdbcDdlReader.java:562)
at org.jumpmind.db.sql.JdbcSqlTemplate.execute(JdbcSqlTemplate.java:501)
... 16 more
2018-10-29 13:50:03,893 INFO [corp-000] [AbstractSymmetricEngine] [symmetric-engine-startup-1] Stopping SymmetricDS externalId=000 version=3.9.14 database=PostgreSQL
2018-10-29 13:50:03,893 INFO [corp-000] [AbstractSymmetricEngine] [symmetric-engine-startup-1]