View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0005196 | SymmetricDS | Bug | public | 2022-01-17 18:07 | 2022-04-11 19:50 |
| Reporter | richard@squarepeg.co.za | Assigned To | emiller | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.12.14 | ||||
| Target Version | 3.12.16 | Fixed in Version | 3.12.16 | ||
| Summary | 0005196: "There are SymmetricDS tables that needed altered" on every start-up on Derby | ||||
| Description | The test "Checking if SymmetricDS tables need created or altered" is always positive, resulting in the database migration process running on each startup. Only happens on a new database initialised with 3.12.14, older versions updated work fine. Database is Derby. | ||||
| Steps To Reproduce | Launch Sym on an empty Derby database. Tables are initialised. Restart Sym. | ||||
| Tags | No tags attached. | ||||
|
|
sync.log (176,114 bytes)
2022-01-17 18:56:45,109 INFO (sync.starter) [za.drt.dbservice.sync.ClientSync] [KRKHBNM3] prep sync start;
2022-01-17 18:56:45,111 INFO (sync.starter) [za.drt.dbservice.sync.ClientSync] [KRKHBNM3] clear staging;
2022-01-17 18:56:45,113 INFO (sync.starter) [za.drt.dbservice.sync.ClientSync] [KRKHBNM3] prep sync init;
2022-01-17 18:56:45,141 INFO (sync.starter) [org.jumpmind.symmetric.util.SymmetricUtils]
_____ __ _ ____ _____
/ ___/ __ _____ __ ___ __ ___ _/ /_ ____(_)___ / __ | / ___/
\__ \ / / / / _ `_ \/ _ `_ \/ _ \/_ __// __/ / __/ / / / / \__ \
___/ // /_/ / // // / // // / __// / / / / / /_ / /_/ / ___/ /
/____/ \__ /_//_//_/_//_//_/\___/ \_/ /_/ /_/\__/ /_____/ /____/
/____/
+-----------------------------------------------------------------+
| Copyright (C) 2007-2021 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 |
+-----------------------------------------------------------------+
2022-01-17 18:56:45,187 INFO (sync.starter) [org.jumpmind.symmetric.AbstractSymmetricEngine] Initializing connection to database
2022-01-17 18:56:45,249 INFO (sync.starter) [org.jumpmind.db.platform.JdbcDatabasePlatformFactory] Detected database 'Apache Derby', version '10', protocol 'derby'
2022-01-17 18:56:45,258 INFO (sync.starter) [org.jumpmind.db.platform.JdbcDatabasePlatformFactory] The IDatabasePlatform being used is org.jumpmind.db.platform.derby.DerbyDatabasePlatform
2022-01-17 18:56:45,394 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] The DbDialect being used is org.jumpmind.symmetric.db.derby.DerbySymmetricDialect
2022-01-17 18:56:45,422 INFO (sync.starter) [org.jumpmind.symmetric.io.stage.StagingManager] The staging directory was initialized at the following location: C:\Users\richa\AppData\Local\Temp\\KRKHBNM3
2022-01-17 18:56:45,814 INFO (sync.starter) [org.jumpmind.symmetric.service.impl.ClientExtensionService] Found 7 extension points from spring that will be registered
2022-01-17 18:56:45,814 INFO (sync.starter) [org.jumpmind.symmetric.AbstractSymmetricEngine] Initializing SymmetricDS database
2022-01-17 18:56:45,834 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] Installing SymmetricDS database object:
CREATE FUNCTION sym_escape(STR VARCHAR(10000)) RETURNS VARCHAR(10000) PARAMETER STYLE JAVA NO SQL LANGUAGE JAVA EXTERNAL NAME 'org.jumpmind.symmetric.db.derby.DerbyFunctions.escape'
2022-01-17 18:56:45,840 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] Just installed sym_escape
2022-01-17 18:56:45,844 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] Installing SymmetricDS database object:
CREATE FUNCTION sym_clob_to_string(columnName varchar(50), tableName varchar(50), whereClause varchar(8000)) RETURNS varchar(32672) PARAMETER STYLE JAVA READS SQL DATA LANGUAGE JAVA EXTERNAL NAME 'org.jumpmind.symmetric.db.derby.DerbyFunctions.clobToString'
2022-01-17 18:56:45,846 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] Just installed sym_clob_to_string
2022-01-17 18:56:45,849 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] Installing SymmetricDS database object:
CREATE FUNCTION sym_blob_to_string(columnName varchar(50), tableName varchar(50), whereClause varchar(8000)) RETURNS varchar(32672) PARAMETER STYLE JAVA READS SQL DATA LANGUAGE JAVA EXTERNAL NAME 'org.jumpmind.symmetric.db.derby.DerbyFunctions.blobToString'
2022-01-17 18:56:45,850 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] Just installed sym_blob_to_string
2022-01-17 18:56:45,854 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] Installing SymmetricDS database object:
CREATE FUNCTION sym_transaction_id() RETURNS varchar(100) PARAMETER STYLE JAVA NO SQL LANGUAGE JAVA EXTERNAL NAME 'org.jumpmind.symmetric.db.derby.DerbyFunctions.getTransactionId'
2022-01-17 18:56:45,855 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] Just installed sym_transaction_id
2022-01-17 18:56:45,858 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] Installing SymmetricDS database object:
CREATE FUNCTION sym_sync_triggers_disabled() RETURNS integer PARAMETER STYLE JAVA NO SQL LANGUAGE JAVA EXTERNAL NAME 'org.jumpmind.symmetric.db.derby.DerbyFunctions.isSyncDisabled'
2022-01-17 18:56:45,860 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] Just installed sym_sync_triggers_disabled
2022-01-17 18:56:45,863 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] Installing SymmetricDS database object:
CREATE FUNCTION sym_sync_triggers_set_disabled(state integer) RETURNS integer PARAMETER STYLE JAVA NO SQL LANGUAGE JAVA EXTERNAL NAME 'org.jumpmind.symmetric.db.derby.DerbyFunctions.setSyncDisabled'
2022-01-17 18:56:45,865 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] Just installed sym_sync_triggers_set_disabled
2022-01-17 18:56:45,868 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] Installing SymmetricDS database object:
CREATE FUNCTION sym_sync_node_set_disabled(nodeId varchar(50)) RETURNS varchar(50) PARAMETER STYLE JAVA NO SQL LANGUAGE JAVA EXTERNAL NAME 'org.jumpmind.symmetric.db.derby.DerbyFunctions.setSyncNodeDisabled'
2022-01-17 18:56:45,869 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] Just installed sym_sync_node_set_disabled
2022-01-17 18:56:45,872 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] Installing SymmetricDS database object:
CREATE PROCEDURE sym_save_data(enabled integer, schemaName varchar(50), prefixName varchar(50), tableName varchar(50), channelName varchar(50), dmlType varchar(1), triggerHistId int, transactionId varchar(1000), externalData varchar(50), columnNames varchar(32672), pkColumnNames varchar(32672)) PARAMETER STYLE JAVA LANGUAGE JAVA MODIFIES SQL DATA EXTERNAL NAME 'org.jumpmind.symmetric.db.derby.DerbyFunctions.insertData'
2022-01-17 18:56:45,873 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] Just installed sym_save_data
2022-01-17 18:56:45,873 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] Checking if SymmetricDS tables need created or altered
2022-01-17 18:56:46,133 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] There are SymmetricDS tables that needed altered
2022-01-17 18:56:46,183 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] 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" DECIMAL(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")
)
2022-01-17 18:56:46,194 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] 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" CLOB,
"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")
)
2022-01-17 18:56:46,200 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: CREATE TABLE "SYM_CONTEXT"(
"NAME" VARCHAR(80) NOT NULL,
"CONTEXT_VALUE" CLOB,
"CREATE_TIME" TIMESTAMP,
"LAST_UPDATE_TIME" TIMESTAMP,
PRIMARY KEY ("NAME")
)
2022-01-17 18:56:46,210 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: CREATE TABLE "SYM_DATA"(
"DATA_ID" BIGINT NOT NULL GENERATED BY DEFAULT AS IDENTITY,
"TABLE_NAME" VARCHAR(255) NOT NULL,
"EVENT_TYPE" CHAR(1) NOT NULL,
"ROW_DATA" CLOB,
"PK_DATA" CLOB,
"OLD_DATA" CLOB,
"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),
"IS_PREROUTED" SMALLINT DEFAULT 0 NOT NULL,
"CREATE_TIME" TIMESTAMP,
PRIMARY KEY ("DATA_ID")
)
2022-01-17 18:56:46,214 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: CREATE UNIQUE INDEX "SYM_IDX_D_CHANNEL_ID" ON "SYM_DATA" ("DATA_ID", "CHANNEL_ID")
2022-01-17 18:56:46,220 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: CREATE TABLE "SYM_DATA_EVENT"(
"DATA_ID" BIGINT NOT NULL,
"BATCH_ID" BIGINT NOT NULL,
"CREATE_TIME" TIMESTAMP,
PRIMARY KEY ("DATA_ID", "BATCH_ID")
)
2022-01-17 18:56:46,222 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: CREATE INDEX "SYM_IDX_DE_BATCHID" ON "SYM_DATA_EVENT" ("BATCH_ID")
2022-01-17 18:56:46,229 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: CREATE TABLE "SYM_DATA_GAP"(
"START_ID" BIGINT NOT NULL,
"END_ID" BIGINT NOT NULL,
"CREATE_TIME" TIMESTAMP NOT NULL,
"LAST_UPDATE_HOSTNAME" VARCHAR(255),
PRIMARY KEY ("START_ID", "END_ID")
)
2022-01-17 18:56:46,236 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] 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" CLOB,
"CREATE_TIME" TIMESTAMP,
"LAST_UPDATE_BY" VARCHAR(50),
"LAST_UPDATE_TIME" TIMESTAMP,
PRIMARY KEY ("EXTENSION_ID")
)
2022-01-17 18:56:46,246 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] 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,
"LOAD_ID" BIGINT,
"TABLE_NAME" VARCHAR(255),
"EXTRACTED_ROWS" BIGINT DEFAULT 0 NOT NULL,
"EXTRACTED_MILLIS" BIGINT DEFAULT 0 NOT NULL,
"TRANSFERRED_ROWS" BIGINT DEFAULT 0 NOT NULL,
"TRANSFERRED_MILLIS" BIGINT DEFAULT 0 NOT NULL,
"LAST_TRANSFERRED_BATCH_ID" BIGINT,
"LOADED_ROWS" BIGINT DEFAULT 0 NOT NULL,
"LOADED_MILLIS" BIGINT DEFAULT 0 NOT NULL,
"LAST_LOADED_BATCH_ID" BIGINT,
"TOTAL_ROWS" BIGINT,
"LOADED_TIME" TIMESTAMP,
"PARENT_REQUEST_ID" BIGINT DEFAULT 0 NOT NULL,
"LAST_UPDATE_TIME" TIMESTAMP,
"CREATE_TIME" TIMESTAMP,
PRIMARY KEY ("REQUEST_ID")
)
2022-01-17 18:56:46,251 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] 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")
)
2022-01-17 18:56:46,259 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] 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")
)
2022-01-17 18:56:46,262 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: CREATE INDEX "SYM_IDX_F_SNPSHT_CHID" ON "SYM_FILE_SNAPSHOT" ("RELOAD_CHANNEL_ID")
2022-01-17 18:56:46,272 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] 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" CLOB,
"AFTER_COPY_SCRIPT" CLOB,
"CREATE_TIME" TIMESTAMP NOT NULL,
"LAST_UPDATE_BY" VARCHAR(50),
"LAST_UPDATE_TIME" TIMESTAMP NOT NULL,
"DESCRIPTION" CLOB,
PRIMARY KEY ("TRIGGER_ID")
)
2022-01-17 18:56:46,278 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] 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" CLOB,
PRIMARY KEY ("TRIGGER_ID", "ROUTER_ID")
)
2022-01-17 18:56:46,285 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] 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")
)
2022-01-17 18:56:46,290 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] 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")
)
2022-01-17 18:56:46,301 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] 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" CLOB,
"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")
)
2022-01-17 18:56:46,306 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: CREATE INDEX "SYM_IDX_IB_TIME_STATUS" ON "SYM_INCOMING_BATCH" ("CREATE_TIME", "STATUS")
2022-01-17 18:56:46,313 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: CREATE INDEX "SYM_IDX_IB_IN_ERROR" ON "SYM_INCOMING_BATCH" ("ERROR_FLAG")
2022-01-17 18:56:46,320 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] 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" CLOB NOT NULL,
"PK_COLUMN_NAMES" CLOB NOT NULL,
"ROW_DATA" CLOB,
"OLD_DATA" CLOB,
"CUR_DATA" CLOB,
"RESOLVE_DATA" CLOB,
"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")
)
2022-01-17 18:56:46,326 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] 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" CLOB,
"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")
)
2022-01-17 18:56:46,333 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] 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" CLOB,
"AFTER_WRITE_SCRIPT" CLOB,
"BATCH_COMPLETE_SCRIPT" CLOB,
"BATCH_COMMIT_SCRIPT" CLOB,
"BATCH_ROLLBACK_SCRIPT" CLOB,
"HANDLE_ERROR_SCRIPT" CLOB,
"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")
)
2022-01-17 18:56:46,339 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] 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")
)
2022-01-17 18:56:46,345 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] 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,
"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),
"DATABASE_NAME" 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")
)
2022-01-17 18:56:46,352 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] 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")
)
2022-01-17 18:56:46,357 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] 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")
)
2022-01-17 18:56:46,362 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] 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")
)
2022-01-17 18:56:46,371 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] 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")
)
2022-01-17 18:56:46,377 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] 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")
)
2022-01-17 18:56:46,383 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] 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")
)
2022-01-17 18:56:46,389 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] 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,
"DATA_LOADED_OUTGOING" BIGINT DEFAULT 0,
"DATA_BYTES_LOADED_OUTGOING" BIGINT DEFAULT 0,
"DATA_LOADED_OUTGOING_ERRORS" BIGINT DEFAULT 0,
PRIMARY KEY ("NODE_ID", "HOST_NAME", "CHANNEL_ID", "START_TIME", "END_TIME")
)
2022-01-17 18:56:46,392 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: CREATE INDEX "SYM_IDX_ND_HST_CHNL_STS" ON "SYM_NODE_HOST_CHANNEL_STATS" ("NODE_ID", "START_TIME", "END_TIME")
2022-01-17 18:56:46,399 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] 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")
)
2022-01-17 18:56:46,402 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: CREATE INDEX "SYM_IDX_ND_HST_JOB" ON "SYM_NODE_HOST_JOB_STATS" ("NODE_ID", "START_TIME", "END_TIME")
2022-01-17 18:56:46,408 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] 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")
)
2022-01-17 18:56:46,412 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: CREATE INDEX "SYM_IDX_ND_HST_STS" ON "SYM_NODE_HOST_STATS" ("NODE_ID", "START_TIME", "END_TIME")
2022-01-17 18:56:46,418 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: CREATE TABLE "SYM_NODE_IDENTITY"(
"NODE_ID" VARCHAR(50) NOT NULL,
PRIMARY KEY ("NODE_ID")
)
2022-01-17 18:56:46,426 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] 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_END_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),
"FAILED_LOGINS" SMALLINT DEFAULT 0,
"CREATED_AT_NODE_ID" VARCHAR(50),
PRIMARY KEY ("NODE_ID")
)
2022-01-17 18:56:46,433 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] 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" CLOB,
"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")
)
2022-01-17 18:56:46,441 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] 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" CLOB,
"LAST_UPDATE_TIME" TIMESTAMP,
PRIMARY KEY ("MONITOR_ID", "NODE_ID", "EVENT_TIME")
)
2022-01-17 18:56:46,449 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] 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" CLOB,
"ENABLED" SMALLINT DEFAULT 0 NOT NULL,
"CREATE_TIME" TIMESTAMP,
"LAST_UPDATE_BY" VARCHAR(50),
"LAST_UPDATE_TIME" TIMESTAMP,
PRIMARY KEY ("NOTIFICATION_ID")
)
2022-01-17 18:56:46,459 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] 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" CLOB,
"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")
)
2022-01-17 18:56:46,464 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: CREATE INDEX "SYM_IDX_OB_NODE_STATUS" ON "SYM_OUTGOING_BATCH" ("NODE_ID", "STATUS")
2022-01-17 18:56:46,469 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: CREATE INDEX "SYM_IDX_OB_STATUS" ON "SYM_OUTGOING_BATCH" ("STATUS")
2022-01-17 18:56:46,474 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: CREATE INDEX "SYM_IDX_OB_IN_ERROR" ON "SYM_OUTGOING_BATCH" ("ERROR_FLAG")
2022-01-17 18:56:46,481 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] 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" CLOB,
"CREATE_TIME" TIMESTAMP,
"LAST_UPDATE_BY" VARCHAR(50),
"LAST_UPDATE_TIME" TIMESTAMP,
PRIMARY KEY ("EXTERNAL_ID", "NODE_GROUP_ID", "PARAM_KEY")
)
2022-01-17 18:56:46,486 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] 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")
)
2022-01-17 18:56:46,493 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] 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" CLOB,
"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")
)
2022-01-17 18:56:46,497 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: CREATE INDEX "SYM_IDX_REG_REQ_1" ON "SYM_REGISTRATION_REQUEST" ("NODE_GROUP_ID", "EXTERNAL_ID", "STATUS", "HOST_NAME", "IP_ADDRESS")
2022-01-17 18:56:46,501 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: CREATE INDEX "SYM_IDX_REG_REQ_2" ON "SYM_REGISTRATION_REQUEST" ("STATUS")
2022-01-17 18:56:46,507 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] 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) DEFAULT 'default' NOT NULL,
"ROUTER_EXPRESSION" CLOB,
"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" CLOB,
PRIMARY KEY ("ROUTER_ID")
)
2022-01-17 18:56:46,513 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] 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")
)
2022-01-17 18:56:46,519 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] 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" CLOB,
"BEFORE_CUSTOM_SQL" CLOB,
"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")
)
2022-01-17 18:56:46,527 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: CREATE TABLE "SYM_TABLE_RELOAD_STATUS"(
"LOAD_ID" BIGINT NOT NULL,
"SOURCE_NODE_ID" VARCHAR(50) NOT NULL,
"TARGET_NODE_ID" VARCHAR(50) NOT NULL,
"START_TIME" TIMESTAMP,
"END_TIME" TIMESTAMP,
"COMPLETED" SMALLINT DEFAULT 0 NOT NULL,
"CANCELLED" SMALLINT DEFAULT 0 NOT NULL,
"FULL_LOAD" SMALLINT DEFAULT 0 NOT NULL,
"START_DATA_BATCH_ID" BIGINT,
"END_DATA_BATCH_ID" BIGINT,
"SETUP_BATCH_COUNT" BIGINT DEFAULT 0 NOT NULL,
"DATA_BATCH_COUNT" BIGINT DEFAULT 0 NOT NULL,
"FINALIZE_BATCH_COUNT" BIGINT DEFAULT 0 NOT NULL,
"SETUP_BATCH_LOADED" BIGINT DEFAULT 0 NOT NULL,
"DATA_BATCH_LOADED" BIGINT DEFAULT 0 NOT NULL,
"FINALIZE_BATCH_LOADED" BIGINT DEFAULT 0 NOT NULL,
"TABLE_COUNT" BIGINT DEFAULT 0 NOT NULL,
"ROWS_LOADED" BIGINT DEFAULT 0 NOT NULL,
"ROWS_COUNT" BIGINT DEFAULT 0 NOT NULL,
"ERROR_FLAG" SMALLINT DEFAULT 0 NOT NULL,
"SQL_STATE" VARCHAR(10),
"SQL_CODE" INTEGER DEFAULT 0 NOT NULL,
"SQL_MESSAGE" CLOB,
"LAST_UPDATE_BY" VARCHAR(50),
"LAST_UPDATE_TIME" TIMESTAMP NOT NULL,
PRIMARY KEY ("LOAD_ID", "SOURCE_NODE_ID")
)
2022-01-17 18:56:46,533 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] 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" CLOB,
PRIMARY KEY ("TRANSFORM_ID", "SOURCE_NODE_GROUP_ID", "TARGET_NODE_GROUP_ID")
)
2022-01-17 18:56:46,544 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] 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" CLOB,
"TRANSFORM_ORDER" INTEGER DEFAULT 1 NOT NULL,
"CREATE_TIME" TIMESTAMP,
"LAST_UPDATE_BY" VARCHAR(50),
"LAST_UPDATE_TIME" TIMESTAMP,
"DESCRIPTION" CLOB,
PRIMARY KEY ("TRANSFORM_ID", "INCLUDE_ON", "TARGET_COLUMN_NAME")
)
2022-01-17 18:56:46,554 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] 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" CLOB,
"SYNC_ON_INSERT_CONDITION" CLOB,
"SYNC_ON_DELETE_CONDITION" CLOB,
"CUSTOM_BEFORE_UPDATE_TEXT" CLOB,
"CUSTOM_BEFORE_INSERT_TEXT" CLOB,
"CUSTOM_BEFORE_DELETE_TEXT" CLOB,
"CUSTOM_ON_UPDATE_TEXT" CLOB,
"CUSTOM_ON_INSERT_TEXT" CLOB,
"CUSTOM_ON_DELETE_TEXT" CLOB,
"EXTERNAL_SELECT" CLOB,
"TX_ID_EXPRESSION" CLOB,
"CHANNEL_EXPRESSION" CLOB,
"EXCLUDED_COLUMN_NAMES" CLOB,
"INCLUDED_COLUMN_NAMES" CLOB,
"SYNC_KEY_NAMES" CLOB,
"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" CLOB,
PRIMARY KEY ("TRIGGER_ID")
)
2022-01-17 18:56:46,560 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] 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" CLOB NOT NULL,
"PK_COLUMN_NAMES" CLOB NOT NULL,
"LAST_TRIGGER_BUILD_REASON" CHAR(1) NOT NULL,
"ERROR_MESSAGE" CLOB,
"CREATE_TIME" TIMESTAMP NOT NULL,
"INACTIVE_TIME" TIMESTAMP,
PRIMARY KEY ("TRIGGER_HIST_ID")
)
2022-01-17 18:56:46,564 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: CREATE INDEX "SYM_IDX_TRIGG_HIST_1" ON "SYM_TRIGGER_HIST" ("TRIGGER_ID", "INACTIVE_TIME")
2022-01-17 18:56:46,569 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] 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" CLOB,
"INITIAL_LOAD_DELETE_STMT" CLOB,
"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" CLOB,
PRIMARY KEY ("TRIGGER_ID", "ROUTER_ID")
)
2022-01-17 18:56:46,575 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] 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")
)
2022-01-17 18:56:46,601 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] 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")
2022-01-17 18:56:46,610 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] 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")
2022-01-17 18:56:46,616 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: ALTER TABLE "SYM_FILE_TRIGGER_ROUTER"
ADD CONSTRAINT "SYM_FK_FTR_2_RTR" FOREIGN KEY ("ROUTER_ID") REFERENCES "SYM_ROUTER" ("ROUTER_ID")
2022-01-17 18:56:46,624 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: ALTER TABLE "SYM_GROUPLET_LINK"
ADD CONSTRAINT "SYM_FK_GPLTLNK_2_GPLT" FOREIGN KEY ("GROUPLET_ID") REFERENCES "SYM_GROUPLET" ("GROUPLET_ID")
2022-01-17 18:56:46,630 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] 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")
2022-01-17 18:56:46,635 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] 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")
2022-01-17 18:56:46,637 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: ALTER TABLE "SYM_NODE_IDENTITY"
ADD CONSTRAINT "SYM_FK_IDENT_2_NODE" FOREIGN KEY ("NODE_ID") REFERENCES "SYM_NODE" ("NODE_ID")
2022-01-17 18:56:46,639 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: ALTER TABLE "SYM_NODE_SECURITY"
ADD CONSTRAINT "SYM_FK_SEC_2_NODE" FOREIGN KEY ("NODE_ID") REFERENCES "SYM_NODE" ("NODE_ID")
2022-01-17 18:56:46,643 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] 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")
2022-01-17 18:56:46,649 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] 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")
2022-01-17 18:56:46,654 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: ALTER TABLE "SYM_TRIGGER"
ADD CONSTRAINT "SYM_FK_TRG_2_CHNL" FOREIGN KEY ("CHANNEL_ID") REFERENCES "SYM_CHANNEL" ("CHANNEL_ID")
2022-01-17 18:56:46,660 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: ALTER TABLE "SYM_TRIGGER"
ADD CONSTRAINT "SYM_FK_TRG_2_RLD_CHNL" FOREIGN KEY ("RELOAD_CHANNEL_ID") REFERENCES "SYM_CHANNEL" ("CHANNEL_ID")
2022-01-17 18:56:46,666 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: ALTER TABLE "SYM_TRIGGER_ROUTER"
ADD CONSTRAINT "SYM_FK_TR_2_TRG" FOREIGN KEY ("TRIGGER_ID") REFERENCES "SYM_TRIGGER" ("TRIGGER_ID")
2022-01-17 18:56:46,670 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: ALTER TABLE "SYM_TRIGGER_ROUTER"
ADD CONSTRAINT "SYM_FK_TR_2_RTR" FOREIGN KEY ("ROUTER_ID") REFERENCES "SYM_ROUTER" ("ROUTER_ID")
2022-01-17 18:56:46,675 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: ALTER TABLE "SYM_TRIGGER_ROUTER_GROUPLET"
ADD CONSTRAINT "SYM_FK_TRGPLT_2_GPLT" FOREIGN KEY ("GROUPLET_ID") REFERENCES "SYM_GROUPLET" ("GROUPLET_ID")
2022-01-17 18:56:46,681 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] 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")
2022-01-17 18:56:46,682 INFO (sync.starter) [org.jumpmind.symmetric.service.impl.ClusterService] This node picked a server id of MALACHOR
2022-01-17 18:56:46,682 INFO (sync.starter) [org.jumpmind.symmetric.service.impl.TriggerRouterService] Synchronizing triggers
2022-01-17 18:56:46,797 INFO (sync.starter) [org.jumpmind.symmetric.service.impl.TriggerRouterService] Done synchronizing triggers
2022-01-17 18:56:46,798 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] Done with auto update of SymmetricDS tables
2022-01-17 18:56:46,798 INFO (sync.starter) [org.jumpmind.symmetric.service.impl.ConfigurationService] Auto-configuring config channel
2022-01-17 18:56:46,831 INFO (sync.starter) [org.jumpmind.symmetric.service.impl.ConfigurationService] Auto-configuring reload channel
2022-01-17 18:56:46,833 INFO (sync.starter) [org.jumpmind.symmetric.service.impl.ConfigurationService] Auto-configuring monitor channel
2022-01-17 18:56:46,835 INFO (sync.starter) [org.jumpmind.symmetric.service.impl.ConfigurationService] Auto-configuring heartbeat channel
2022-01-17 18:56:46,837 INFO (sync.starter) [org.jumpmind.symmetric.service.impl.ConfigurationService] Auto-configuring default channel
2022-01-17 18:56:46,838 INFO (sync.starter) [org.jumpmind.symmetric.service.impl.ConfigurationService] Auto-configuring dynamic channel
2022-01-17 18:56:47,038 INFO (sync.starter) [org.jumpmind.symmetric.service.impl.ExtensionService] Found 0 extension points from the database that will be registered
2022-01-17 18:56:47,038 INFO (sync.starter) [org.jumpmind.symmetric.service.impl.ClientExtensionService] Found 7 extension points from spring that will be registered
2022-01-17 18:56:47,039 INFO (sync.starter) [org.jumpmind.symmetric.AbstractSymmetricEngine] Done initializing SymmetricDS database
2022-01-17 18:56:47,039 INFO (sync.starter) [org.jumpmind.symmetric.AbstractSymmetricEngine] SymmetricDS database version : null
2022-01-17 18:56:47,039 INFO (sync.starter) [org.jumpmind.symmetric.AbstractSymmetricEngine] SymmetricDS software version : 3.12.14
2022-01-17 18:56:47,039 INFO (sync.starter) [za.drt.dbservice.sync.ClientSync] [KRKHBNM3] done sync init;
2022-01-17 18:56:47,063 INFO (sync.starter) [org.jumpmind.symmetric.AbstractSymmetricEngine] Starting unregistered node [group=KRKHBNM3, externalId=KRKHBNM3.00-23-18-B3-95-FB.04]
2022-01-17 18:56:47,080 INFO (sync.starter) [org.jumpmind.symmetric.job.RouterJob] Starting Routing on periodic schedule: every 30000ms with the first run at 2022-01-17T18:56:48.157+0200
2022-01-17 18:56:47,081 INFO (sync.starter) [org.jumpmind.symmetric.job.PushJob] Starting Push on periodic schedule: every 60000ms with the first run at 2022-01-17T18:56:48.159+0200
2022-01-17 18:56:47,081 INFO (sync.starter) [org.jumpmind.symmetric.job.PullJob] Starting Pull on periodic schedule: every 60000ms with the first run at 2022-01-17T18:56:48.159+0200
2022-01-17 18:56:47,081 INFO (sync.starter) [org.jumpmind.symmetric.job.JobManager] Job Offline Push not configured for auto start
2022-01-17 18:56:47,081 INFO (sync.starter) [org.jumpmind.symmetric.job.JobManager] Job Offline Pull not configured for auto start
2022-01-17 18:56:47,084 INFO (sync.starter) [org.jumpmind.symmetric.job.OutgoingPurgeJob] Starting job 'Purge Outgoing' with cron expression: '0 0 */4 * * *'
2022-01-17 18:56:47,085 INFO (sync.starter) [org.jumpmind.symmetric.job.IncomingPurgeJob] Starting job 'Purge Incoming' with cron expression: '0 0 */4 * * *'
2022-01-17 18:56:47,085 INFO (sync.starter) [org.jumpmind.symmetric.job.StatisticFlushJob] Starting job 'Stat Flush' with cron expression: '0 0/5 * * * *'
2022-01-17 18:56:47,085 INFO (sync.starter) [org.jumpmind.symmetric.job.SyncTriggersJob] Starting job 'SyncTriggers' with cron expression: '0 0 0 * * *'
2022-01-17 18:56:47,085 INFO (sync.starter) [org.jumpmind.symmetric.job.HeartbeatJob] Starting Heartbeat on periodic schedule: every 900000ms with the first run at 2022-01-17T18:56:48.163+0200
2022-01-17 18:56:47,086 INFO (sync.starter) [org.jumpmind.symmetric.job.WatchdogJob] Starting Watchdog on periodic schedule: every 3600000ms with the first run at 2022-01-17T18:56:48.164+0200
2022-01-17 18:56:47,087 INFO (sync.starter) [org.jumpmind.symmetric.job.StageManagementJob] Starting job 'Stage Management' with cron expression: '0 0 * * * *'
2022-01-17 18:56:47,087 INFO (sync.starter) [org.jumpmind.symmetric.job.JobManager] Job Refresh Cache not configured for auto start
2022-01-17 18:56:47,087 INFO (sync.starter) [org.jumpmind.symmetric.job.JobManager] Job File Sync Tracker not configured for auto start
2022-01-17 18:56:47,087 INFO (sync.starter) [org.jumpmind.symmetric.job.JobManager] Job File Sync Pull not configured for auto start
2022-01-17 18:56:47,087 INFO (sync.starter) [org.jumpmind.symmetric.job.JobManager] Job File Sync Push not configured for auto start
2022-01-17 18:56:47,087 INFO (sync.starter) [org.jumpmind.symmetric.job.InitialLoadExtractorJob] Starting Initial Load Extract on periodic schedule: every 10000ms with the first run at 2022-01-17T18:56:48.165+0200
2022-01-17 18:56:47,087 INFO (sync.starter) [org.jumpmind.symmetric.job.MonitorJob] Starting Monitor on periodic schedule: every 60000ms with the first run at 2022-01-17T18:56:48.165+0200
2022-01-17 18:56:47,087 INFO (sync.starter) [org.jumpmind.symmetric.job.JobManager] Job Report Status not configured for auto start
2022-01-17 18:56:47,087 INFO (sync.starter) [org.jumpmind.symmetric.job.JobManager] Job Log Miner not configured for auto start
2022-01-17 18:56:47,087 INFO (sync.starter) [org.jumpmind.symmetric.job.InitialLoadJob] Starting Initial Load Queue on periodic schedule: every 10000ms with the first run at 2022-01-17T18:56:48.165+0200
2022-01-17 18:56:47,089 INFO (sync.starter) [org.jumpmind.symmetric.AbstractSymmetricEngine] SymmetricDS Node STARTED:
nodeId=KRKHBNM3.00-23-18-B3-95-FB.04
groupId=KRKHBNM3
type=client
subType=null
name=KRKHBNM3
softwareVersion=3.12.14
databaseName=Apache Derby
databaseVersion=10.14
driverName=Apache Derby Network Client JDBC Driver
driverVersion=10.14.2.0 - (1828579)
uptime=0 sec.
2022-01-17 18:56:47,089 INFO (sync.starter) [za.drt.dbservice.sync.ClientSync] [KRKHBNM3] done sync start;
2022-01-17 18:56:47,089 INFO (sync.starter) [za.drt.dbservice.sync.ClientSync] [KRKHBNM3] prep sync load;
2022-01-17 18:56:48,159 INFO (KRKHBNM3-job-1) [org.jumpmind.symmetric.job.RouterJob] Did not run the 'Routing' job because the engine is not registered.
2022-01-17 18:56:48,161 INFO (KRKHBNM3-job-2) [org.jumpmind.symmetric.job.PushJob] Did not run the 'Push' job because the engine is not registered.
2022-01-17 18:56:48,165 INFO (KRKHBNM3-job-5) [org.jumpmind.symmetric.job.InitialLoadExtractorJob] Did not run the 'Initial Load Extract' job because the engine is not registered.
2022-01-17 18:56:48,165 INFO (KRKHBNM3-job-6) [org.jumpmind.symmetric.job.MonitorJob] Did not run the 'Monitor' job because the engine is not registered.
2022-01-17 18:56:48,167 INFO (KRKHBNM3-job-6) [org.jumpmind.symmetric.job.InitialLoadJob] Did not run the 'Initial Load Queue' job because the engine is not registered.
2022-01-17 18:56:48,168 INFO (KRKHBNM3-job-3) [org.jumpmind.symmetric.service.impl.RegistrationService] This node is unregistered. It will attempt to register using the registration.url
2022-01-17 18:56:48,334 INFO (KRKHBNM3-job-3) [org.jumpmind.symmetric.service.impl.DataLoaderService] Using registration URL of https://sym.za.ambium.net/sync/home/registration
2022-01-17 18:56:48,685 WARN (KRKHBNM3-job-3) [org.jumpmind.symmetric.service.impl.RegistrationService] Waiting for registration to be accepted by the server. Registration is not open.
2022-01-17 18:56:48,686 INFO (KRKHBNM3-job-3) [org.jumpmind.symmetric.service.impl.RegistrationService] Could not register. Sleeping for 18000ms before attempting again.
2022-01-17 18:57:07,538 INFO (sync.starter) [za.drt.dbservice.sync.ClientSync] [KRKHBNM3] prep sync start;
2022-01-17 18:57:07,540 INFO (sync.starter) [za.drt.dbservice.sync.ClientSync] [KRKHBNM3] clear staging;
2022-01-17 18:57:07,542 INFO (sync.starter) [za.drt.dbservice.sync.ClientSync] [KRKHBNM3] prep sync init;
2022-01-17 18:57:07,567 INFO (sync.starter) [org.jumpmind.symmetric.util.SymmetricUtils]
_____ __ _ ____ _____
/ ___/ __ _____ __ ___ __ ___ _/ /_ ____(_)___ / __ | / ___/
\__ \ / / / / _ `_ \/ _ `_ \/ _ \/_ __// __/ / __/ / / / / \__ \
___/ // /_/ / // // / // // / __// / / / / / /_ / /_/ / ___/ /
/____/ \__ /_//_//_/_//_//_/\___/ \_/ /_/ /_/\__/ /_____/ /____/
/____/
+-----------------------------------------------------------------+
| Copyright (C) 2007-2021 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 |
+-----------------------------------------------------------------+
2022-01-17 18:57:07,628 INFO (sync.starter) [org.jumpmind.symmetric.AbstractSymmetricEngine] Initializing connection to database
2022-01-17 18:57:07,690 INFO (sync.starter) [org.jumpmind.db.platform.JdbcDatabasePlatformFactory] Detected database 'Apache Derby', version '10', protocol 'derby'
2022-01-17 18:57:07,700 INFO (sync.starter) [org.jumpmind.db.platform.JdbcDatabasePlatformFactory] The IDatabasePlatform being used is org.jumpmind.db.platform.derby.DerbyDatabasePlatform
2022-01-17 18:57:07,852 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] The DbDialect being used is org.jumpmind.symmetric.db.derby.DerbySymmetricDialect
2022-01-17 18:57:07,897 INFO (sync.starter) [org.jumpmind.symmetric.service.impl.ExtensionService] Found 0 extension points from the database that will be registered
2022-01-17 18:57:07,902 INFO (sync.starter) [org.jumpmind.symmetric.io.stage.StagingManager] The staging directory was initialized at the following location: C:\Users\richa\AppData\Local\Temp\\KRKHBNM3
2022-01-17 18:57:08,282 INFO (sync.starter) [org.jumpmind.symmetric.service.impl.ExtensionService] Found 0 extension points from the database that will be registered
2022-01-17 18:57:08,283 INFO (sync.starter) [org.jumpmind.symmetric.service.impl.ClientExtensionService] Found 7 extension points from spring that will be registered
2022-01-17 18:57:08,283 INFO (sync.starter) [org.jumpmind.symmetric.AbstractSymmetricEngine] Initializing SymmetricDS database
2022-01-17 18:57:08,324 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] Checking if SymmetricDS tables need created or altered
2022-01-17 18:57:08,768 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] There are SymmetricDS tables that needed altered
2022-01-17 18:57:08,794 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: ALTER TABLE "SYM_CONFLICT"
DROP CONSTRAINT "SYM_FK_CF_2_GRP_LNK"
2022-01-17 18:57:08,799 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: ALTER TABLE "SYM_FILE_TRIGGER_ROUTER"
DROP CONSTRAINT "SYM_FK_FTR_2_FTRG"
2022-01-17 18:57:08,804 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: ALTER TABLE "SYM_FILE_TRIGGER_ROUTER"
DROP CONSTRAINT "SYM_FK_FTR_2_RTR"
2022-01-17 18:57:08,812 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: ALTER TABLE "SYM_ROUTER"
DROP CONSTRAINT "SYM_FK_RT_2_GRP_LNK"
2022-01-17 18:57:08,816 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: ALTER TABLE "SYM_TRANSFORM_TABLE"
DROP CONSTRAINT "SYM_FK_TT_2_GRP_LNK"
2022-01-17 18:57:08,821 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: ALTER TABLE "SYM_TRIGGER"
DROP CONSTRAINT "SYM_FK_TRG_2_CHNL"
2022-01-17 18:57:08,826 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: ALTER TABLE "SYM_TRIGGER"
DROP CONSTRAINT "SYM_FK_TRG_2_RLD_CHNL"
2022-01-17 18:57:08,831 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: ALTER TABLE "SYM_TRIGGER_ROUTER"
DROP CONSTRAINT "SYM_FK_TR_2_TRG"
2022-01-17 18:57:08,836 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: ALTER TABLE "SYM_TRIGGER_ROUTER"
DROP CONSTRAINT "SYM_FK_TR_2_RTR"
2022-01-17 18:57:08,845 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: ALTER TABLE "SYM_TRIGGER_ROUTER_GROUPLET"
DROP CONSTRAINT "SYM_FK_TRGPLT_2_TR"
2022-01-17 18:57:08,850 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL failed: DROP TABLE "KRKHBNM3"."SYM_CONFLICT_"
2022-01-17 18:57:08,874 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: CREATE TABLE "KRKHBNM3"."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" CLOB,
"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")
)
2022-01-17 18:57:08,884 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: INSERT INTO "KRKHBNM3"."SYM_CONFLICT_" ("CONFLICT_ID","SOURCE_NODE_GROUP_ID","TARGET_NODE_GROUP_ID","TARGET_CHANNEL_ID","TARGET_CATALOG_NAME","TARGET_SCHEMA_NAME","TARGET_TABLE_NAME","DETECT_TYPE","DETECT_EXPRESSION","RESOLVE_TYPE","PING_BACK","RESOLVE_CHANGES_ONLY","RESOLVE_ROW_ONLY","CREATE_TIME","LAST_UPDATE_BY","LAST_UPDATE_TIME") SELECT "CONFLICT_ID","SOURCE_NODE_GROUP_ID","TARGET_NODE_GROUP_ID","TARGET_CHANNEL_ID","TARGET_CATALOG_NAME","TARGET_SCHEMA_NAME","TARGET_TABLE_NAME","DETECT_TYPE","DETECT_EXPRESSION","RESOLVE_TYPE","PING_BACK","RESOLVE_CHANGES_ONLY","RESOLVE_ROW_ONLY","CREATE_TIME","LAST_UPDATE_BY","LAST_UPDATE_TIME" FROM "KRKHBNM3"."SYM_CONFLICT"
2022-01-17 18:57:08,891 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: DROP TABLE "KRKHBNM3"."SYM_CONFLICT"
2022-01-17 18:57:08,913 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] 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" CLOB,
"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")
)
2022-01-17 18:57:08,916 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: INSERT INTO "SYM_CONFLICT" ("CONFLICT_ID","SOURCE_NODE_GROUP_ID","TARGET_NODE_GROUP_ID","TARGET_CHANNEL_ID","TARGET_CATALOG_NAME","TARGET_SCHEMA_NAME","TARGET_TABLE_NAME","DETECT_TYPE","DETECT_EXPRESSION","RESOLVE_TYPE","PING_BACK","RESOLVE_CHANGES_ONLY","RESOLVE_ROW_ONLY","CREATE_TIME","LAST_UPDATE_BY","LAST_UPDATE_TIME") SELECT "CONFLICT_ID","SOURCE_NODE_GROUP_ID","TARGET_NODE_GROUP_ID","TARGET_CHANNEL_ID","TARGET_CATALOG_NAME","TARGET_SCHEMA_NAME","TARGET_TABLE_NAME","DETECT_TYPE","DETECT_EXPRESSION","RESOLVE_TYPE","PING_BACK","RESOLVE_CHANGES_ONLY","RESOLVE_ROW_ONLY","CREATE_TIME","LAST_UPDATE_BY","LAST_UPDATE_TIME" FROM "KRKHBNM3"."SYM_CONFLICT_"
2022-01-17 18:57:08,920 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: DROP TABLE "KRKHBNM3"."SYM_CONFLICT_"
2022-01-17 18:57:08,921 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL failed: DROP TABLE "KRKHBNM3"."SYM_CONTEXT_"
2022-01-17 18:57:08,928 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: CREATE TABLE "KRKHBNM3"."SYM_CONTEXT_"(
"NAME" VARCHAR(80) NOT NULL,
"CONTEXT_VALUE" CLOB,
"CREATE_TIME" TIMESTAMP,
"LAST_UPDATE_TIME" TIMESTAMP,
PRIMARY KEY ("NAME")
)
2022-01-17 18:57:08,930 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: INSERT INTO "KRKHBNM3"."SYM_CONTEXT_" ("NAME","CONTEXT_VALUE","CREATE_TIME","LAST_UPDATE_TIME") SELECT "NAME","CONTEXT_VALUE","CREATE_TIME","LAST_UPDATE_TIME" FROM "KRKHBNM3"."SYM_CONTEXT"
2022-01-17 18:57:08,935 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: DROP TABLE "KRKHBNM3"."SYM_CONTEXT"
2022-01-17 18:57:08,942 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: CREATE TABLE "SYM_CONTEXT"(
"NAME" VARCHAR(80) NOT NULL,
"CONTEXT_VALUE" CLOB,
"CREATE_TIME" TIMESTAMP,
"LAST_UPDATE_TIME" TIMESTAMP,
PRIMARY KEY ("NAME")
)
2022-01-17 18:57:08,943 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: INSERT INTO "SYM_CONTEXT" ("NAME","CONTEXT_VALUE","CREATE_TIME","LAST_UPDATE_TIME") SELECT "NAME","CONTEXT_VALUE","CREATE_TIME","LAST_UPDATE_TIME" FROM "KRKHBNM3"."SYM_CONTEXT_"
2022-01-17 18:57:08,949 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: DROP TABLE "KRKHBNM3"."SYM_CONTEXT_"
2022-01-17 18:57:08,949 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL failed: DROP TABLE "KRKHBNM3"."SYM_DATA_"
2022-01-17 18:57:08,959 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: CREATE TABLE "KRKHBNM3"."SYM_DATA_"(
"DATA_ID" BIGINT NOT NULL GENERATED BY DEFAULT AS IDENTITY,
"TABLE_NAME" VARCHAR(255) NOT NULL,
"EVENT_TYPE" CHAR(1) NOT NULL,
"ROW_DATA" CLOB,
"PK_DATA" CLOB,
"OLD_DATA" CLOB,
"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),
"IS_PREROUTED" SMALLINT DEFAULT 0 NOT NULL,
"CREATE_TIME" TIMESTAMP,
PRIMARY KEY ("DATA_ID")
)
2022-01-17 18:57:08,962 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: INSERT INTO "KRKHBNM3"."SYM_DATA_" ("DATA_ID","TABLE_NAME","EVENT_TYPE","ROW_DATA","PK_DATA","OLD_DATA","TRIGGER_HIST_ID","CHANNEL_ID","TRANSACTION_ID","SOURCE_NODE_ID","EXTERNAL_DATA","NODE_LIST","IS_PREROUTED","CREATE_TIME") SELECT "DATA_ID","TABLE_NAME","EVENT_TYPE","ROW_DATA","PK_DATA","OLD_DATA","TRIGGER_HIST_ID","CHANNEL_ID","TRANSACTION_ID","SOURCE_NODE_ID","EXTERNAL_DATA","NODE_LIST","IS_PREROUTED","CREATE_TIME" FROM "KRKHBNM3"."SYM_DATA"
2022-01-17 18:57:08,970 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: DROP TABLE "KRKHBNM3"."SYM_DATA"
2022-01-17 18:57:08,977 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: CREATE TABLE "SYM_DATA"(
"DATA_ID" BIGINT NOT NULL GENERATED BY DEFAULT AS IDENTITY,
"TABLE_NAME" VARCHAR(255) NOT NULL,
"EVENT_TYPE" CHAR(1) NOT NULL,
"ROW_DATA" CLOB,
"PK_DATA" CLOB,
"OLD_DATA" CLOB,
"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),
"IS_PREROUTED" SMALLINT DEFAULT 0 NOT NULL,
"CREATE_TIME" TIMESTAMP,
PRIMARY KEY ("DATA_ID")
)
2022-01-17 18:57:08,982 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: CREATE UNIQUE INDEX "SYM_IDX_D_CHANNEL_ID" ON "SYM_DATA" ("DATA_ID", "CHANNEL_ID")
2022-01-17 18:57:08,984 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: INSERT INTO "SYM_DATA" ("DATA_ID","TABLE_NAME","EVENT_TYPE","ROW_DATA","PK_DATA","OLD_DATA","TRIGGER_HIST_ID","CHANNEL_ID","TRANSACTION_ID","SOURCE_NODE_ID","EXTERNAL_DATA","NODE_LIST","IS_PREROUTED","CREATE_TIME") SELECT "DATA_ID","TABLE_NAME","EVENT_TYPE","ROW_DATA","PK_DATA","OLD_DATA","TRIGGER_HIST_ID","CHANNEL_ID","TRANSACTION_ID","SOURCE_NODE_ID","EXTERNAL_DATA","NODE_LIST","IS_PREROUTED","CREATE_TIME" FROM "KRKHBNM3"."SYM_DATA_"
2022-01-17 18:57:08,989 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: DROP TABLE "KRKHBNM3"."SYM_DATA_"
2022-01-17 18:57:08,991 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL failed: DROP TABLE "KRKHBNM3"."SYM_EXTENSION_"
2022-01-17 18:57:09,002 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: CREATE TABLE "KRKHBNM3"."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" CLOB,
"CREATE_TIME" TIMESTAMP,
"LAST_UPDATE_BY" VARCHAR(50),
"LAST_UPDATE_TIME" TIMESTAMP,
PRIMARY KEY ("EXTENSION_ID")
)
2022-01-17 18:57:09,004 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: INSERT INTO "KRKHBNM3"."SYM_EXTENSION_" ("EXTENSION_ID","EXTENSION_TYPE","INTERFACE_NAME","NODE_GROUP_ID","ENABLED","EXTENSION_ORDER","EXTENSION_TEXT","CREATE_TIME","LAST_UPDATE_BY","LAST_UPDATE_TIME") SELECT "EXTENSION_ID","EXTENSION_TYPE","INTERFACE_NAME","NODE_GROUP_ID","ENABLED","EXTENSION_ORDER","EXTENSION_TEXT","CREATE_TIME","LAST_UPDATE_BY","LAST_UPDATE_TIME" FROM "KRKHBNM3"."SYM_EXTENSION"
2022-01-17 18:57:09,009 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: DROP TABLE "KRKHBNM3"."SYM_EXTENSION"
2022-01-17 18:57:09,017 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] 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" CLOB,
"CREATE_TIME" TIMESTAMP,
"LAST_UPDATE_BY" VARCHAR(50),
"LAST_UPDATE_TIME" TIMESTAMP,
PRIMARY KEY ("EXTENSION_ID")
)
2022-01-17 18:57:09,019 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: INSERT INTO "SYM_EXTENSION" ("EXTENSION_ID","EXTENSION_TYPE","INTERFACE_NAME","NODE_GROUP_ID","ENABLED","EXTENSION_ORDER","EXTENSION_TEXT","CREATE_TIME","LAST_UPDATE_BY","LAST_UPDATE_TIME") SELECT "EXTENSION_ID","EXTENSION_TYPE","INTERFACE_NAME","NODE_GROUP_ID","ENABLED","EXTENSION_ORDER","EXTENSION_TEXT","CREATE_TIME","LAST_UPDATE_BY","LAST_UPDATE_TIME" FROM "KRKHBNM3"."SYM_EXTENSION_"
2022-01-17 18:57:09,023 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: DROP TABLE "KRKHBNM3"."SYM_EXTENSION_"
2022-01-17 18:57:09,025 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL failed: DROP TABLE "KRKHBNM3"."SYM_FILE_TRIGGER_"
2022-01-17 18:57:09,034 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: CREATE TABLE "KRKHBNM3"."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" CLOB,
"AFTER_COPY_SCRIPT" CLOB,
"CREATE_TIME" TIMESTAMP NOT NULL,
"LAST_UPDATE_BY" VARCHAR(50),
"LAST_UPDATE_TIME" TIMESTAMP NOT NULL,
"DESCRIPTION" CLOB,
PRIMARY KEY ("TRIGGER_ID")
)
2022-01-17 18:57:09,042 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: INSERT INTO "KRKHBNM3"."SYM_FILE_TRIGGER_" ("TRIGGER_ID","CHANNEL_ID","RELOAD_CHANNEL_ID","BASE_DIR","RECURSE","INCLUDES_FILES","EXCLUDES_FILES","SYNC_ON_CREATE","SYNC_ON_MODIFIED","SYNC_ON_DELETE","SYNC_ON_CTL_FILE","DELETE_AFTER_SYNC","BEFORE_COPY_SCRIPT","AFTER_COPY_SCRIPT","CREATE_TIME","LAST_UPDATE_BY","LAST_UPDATE_TIME","DESCRIPTION") SELECT "TRIGGER_ID","CHANNEL_ID","RELOAD_CHANNEL_ID","BASE_DIR","RECURSE","INCLUDES_FILES","EXCLUDES_FILES","SYNC_ON_CREATE","SYNC_ON_MODIFIED","SYNC_ON_DELETE","SYNC_ON_CTL_FILE","DELETE_AFTER_SYNC","BEFORE_COPY_SCRIPT","AFTER_COPY_SCRIPT","CREATE_TIME","LAST_UPDATE_BY","LAST_UPDATE_TIME","DESCRIPTION" FROM "KRKHBNM3"."SYM_FILE_TRIGGER"
2022-01-17 18:57:09,047 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: DROP TABLE "KRKHBNM3"."SYM_FILE_TRIGGER"
2022-01-17 18:57:09,055 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] 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" CLOB,
"AFTER_COPY_SCRIPT" CLOB,
"CREATE_TIME" TIMESTAMP NOT NULL,
"LAST_UPDATE_BY" VARCHAR(50),
"LAST_UPDATE_TIME" TIMESTAMP NOT NULL,
"DESCRIPTION" CLOB,
PRIMARY KEY ("TRIGGER_ID")
)
2022-01-17 18:57:09,057 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: INSERT INTO "SYM_FILE_TRIGGER" ("TRIGGER_ID","CHANNEL_ID","RELOAD_CHANNEL_ID","BASE_DIR","RECURSE","INCLUDES_FILES","EXCLUDES_FILES","SYNC_ON_CREATE","SYNC_ON_MODIFIED","SYNC_ON_DELETE","SYNC_ON_CTL_FILE","DELETE_AFTER_SYNC","BEFORE_COPY_SCRIPT","AFTER_COPY_SCRIPT","CREATE_TIME","LAST_UPDATE_BY","LAST_UPDATE_TIME","DESCRIPTION") SELECT "TRIGGER_ID","CHANNEL_ID","RELOAD_CHANNEL_ID","BASE_DIR","RECURSE","INCLUDES_FILES","EXCLUDES_FILES","SYNC_ON_CREATE","SYNC_ON_MODIFIED","SYNC_ON_DELETE","SYNC_ON_CTL_FILE","DELETE_AFTER_SYNC","BEFORE_COPY_SCRIPT","AFTER_COPY_SCRIPT","CREATE_TIME","LAST_UPDATE_BY","LAST_UPDATE_TIME","DESCRIPTION" FROM "KRKHBNM3"."SYM_FILE_TRIGGER_"
2022-01-17 18:57:09,063 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: DROP TABLE "KRKHBNM3"."SYM_FILE_TRIGGER_"
2022-01-17 18:57:09,063 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL failed: DROP TABLE "KRKHBNM3"."SYM_FILE_TRIGGER_ROUTER_"
2022-01-17 18:57:09,071 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: CREATE TABLE "KRKHBNM3"."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" CLOB,
PRIMARY KEY ("TRIGGER_ID", "ROUTER_ID")
)
2022-01-17 18:57:09,073 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: INSERT INTO "KRKHBNM3"."SYM_FILE_TRIGGER_ROUTER_" ("TRIGGER_ID","ROUTER_ID","ENABLED","INITIAL_LOAD_ENABLED","TARGET_BASE_DIR","CONFLICT_STRATEGY","CREATE_TIME","LAST_UPDATE_BY","LAST_UPDATE_TIME","DESCRIPTION") SELECT "TRIGGER_ID","ROUTER_ID","ENABLED","INITIAL_LOAD_ENABLED","TARGET_BASE_DIR","CONFLICT_STRATEGY","CREATE_TIME","LAST_UPDATE_BY","LAST_UPDATE_TIME","DESCRIPTION" FROM "KRKHBNM3"."SYM_FILE_TRIGGER_ROUTER"
2022-01-17 18:57:09,078 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: DROP TABLE "KRKHBNM3"."SYM_FILE_TRIGGER_ROUTER"
2022-01-17 18:57:09,085 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] 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" CLOB,
PRIMARY KEY ("TRIGGER_ID", "ROUTER_ID")
)
2022-01-17 18:57:09,087 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: INSERT INTO "SYM_FILE_TRIGGER_ROUTER" ("TRIGGER_ID","ROUTER_ID","ENABLED","INITIAL_LOAD_ENABLED","TARGET_BASE_DIR","CONFLICT_STRATEGY","CREATE_TIME","LAST_UPDATE_BY","LAST_UPDATE_TIME","DESCRIPTION") SELECT "TRIGGER_ID","ROUTER_ID","ENABLED","INITIAL_LOAD_ENABLED","TARGET_BASE_DIR","CONFLICT_STRATEGY","CREATE_TIME","LAST_UPDATE_BY","LAST_UPDATE_TIME","DESCRIPTION" FROM "KRKHBNM3"."SYM_FILE_TRIGGER_ROUTER_"
2022-01-17 18:57:09,091 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: DROP TABLE "KRKHBNM3"."SYM_FILE_TRIGGER_ROUTER_"
2022-01-17 18:57:09,092 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL failed: DROP TABLE "KRKHBNM3"."SYM_INCOMING_BATCH_"
2022-01-17 18:57:09,102 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: CREATE TABLE "KRKHBNM3"."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" CLOB,
"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")
)
2022-01-17 18:57:09,112 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: INSERT INTO "KRKHBNM3"."SYM_INCOMING_BATCH_" ("BATCH_ID","NODE_ID","CHANNEL_ID","STATUS","ERROR_FLAG","SQL_STATE","SQL_CODE","SQL_MESSAGE","LAST_UPDATE_HOSTNAME","LAST_UPDATE_TIME","CREATE_TIME","SUMMARY","IGNORE_COUNT","BYTE_COUNT","LOAD_FLAG","EXTRACT_COUNT","SENT_COUNT","LOAD_COUNT","RELOAD_ROW_COUNT","OTHER_ROW_COUNT","DATA_ROW_COUNT","EXTRACT_ROW_COUNT","LOAD_ROW_COUNT","DATA_INSERT_ROW_COUNT","DATA_UPDATE_ROW_COUNT","DATA_DELETE_ROW_COUNT","EXTRACT_INSERT_ROW_COUNT","EXTRACT_UPDATE_ROW_COUNT","EXTRACT_DELETE_ROW_COUNT","LOAD_INSERT_ROW_COUNT","LOAD_UPDATE_ROW_COUNT","LOAD_DELETE_ROW_COUNT","NETWORK_MILLIS","FILTER_MILLIS","LOAD_MILLIS","ROUTER_MILLIS","EXTRACT_MILLIS","TRANSFORM_EXTRACT_MILLIS","TRANSFORM_LOAD_MILLIS","LOAD_ID","COMMON_FLAG","FALLBACK_INSERT_COUNT","FALLBACK_UPDATE_COUNT","IGNORE_ROW_COUNT","MISSING_DELETE_COUNT","SKIP_COUNT","FAILED_ROW_NUMBER","FAILED_LINE_NUMBER","FAILED_DATA_ID") SELECT "BATCH_ID","NODE_ID","CHANNEL_ID","STATUS","ERROR_FLAG","SQL_STATE","SQL_CODE","SQL_MESSAGE","LAST_UPDATE_HOSTNAME","LAST_UPDATE_TIME","CREATE_TIME","SUMMARY","IGNORE_COUNT","BYTE_COUNT","LOAD_FLAG","EXTRACT_COUNT","SENT_COUNT","LOAD_COUNT","RELOAD_ROW_COUNT","OTHER_ROW_COUNT","DATA_ROW_COUNT","EXTRACT_ROW_COUNT","LOAD_ROW_COUNT","DATA_INSERT_ROW_COUNT","DATA_UPDATE_ROW_COUNT","DATA_DELETE_ROW_COUNT","EXTRACT_INSERT_ROW_COUNT","EXTRACT_UPDATE_ROW_COUNT","EXTRACT_DELETE_ROW_COUNT","LOAD_INSERT_ROW_COUNT","LOAD_UPDATE_ROW_COUNT","LOAD_DELETE_ROW_COUNT","NETWORK_MILLIS","FILTER_MILLIS","LOAD_MILLIS","ROUTER_MILLIS","EXTRACT_MILLIS","TRANSFORM_EXTRACT_MILLIS","TRANSFORM_LOAD_MILLIS","LOAD_ID","COMMON_FLAG","FALLBACK_INSERT_COUNT","FALLBACK_UPDATE_COUNT","IGNORE_ROW_COUNT","MISSING_DELETE_COUNT","SKIP_COUNT","FAILED_ROW_NUMBER","FAILED_LINE_NUMBER","FAILED_DATA_ID" FROM "KRKHBNM3"."SYM_INCOMING_BATCH"
2022-01-17 18:57:09,123 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: DROP TABLE "KRKHBNM3"."SYM_INCOMING_BATCH"
2022-01-17 18:57:09,135 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] 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" CLOB,
"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")
)
2022-01-17 18:57:09,140 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: CREATE INDEX "SYM_IDX_IB_TIME_STATUS" ON "SYM_INCOMING_BATCH" ("CREATE_TIME", "STATUS")
2022-01-17 18:57:09,144 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: CREATE INDEX "SYM_IDX_IB_IN_ERROR" ON "SYM_INCOMING_BATCH" ("ERROR_FLAG")
2022-01-17 18:57:09,147 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: INSERT INTO "SYM_INCOMING_BATCH" ("BATCH_ID","NODE_ID","CHANNEL_ID","STATUS","ERROR_FLAG","SQL_STATE","SQL_CODE","SQL_MESSAGE","LAST_UPDATE_HOSTNAME","LAST_UPDATE_TIME","CREATE_TIME","SUMMARY","IGNORE_COUNT","BYTE_COUNT","LOAD_FLAG","EXTRACT_COUNT","SENT_COUNT","LOAD_COUNT","RELOAD_ROW_COUNT","OTHER_ROW_COUNT","DATA_ROW_COUNT","EXTRACT_ROW_COUNT","LOAD_ROW_COUNT","DATA_INSERT_ROW_COUNT","DATA_UPDATE_ROW_COUNT","DATA_DELETE_ROW_COUNT","EXTRACT_INSERT_ROW_COUNT","EXTRACT_UPDATE_ROW_COUNT","EXTRACT_DELETE_ROW_COUNT","LOAD_INSERT_ROW_COUNT","LOAD_UPDATE_ROW_COUNT","LOAD_DELETE_ROW_COUNT","NETWORK_MILLIS","FILTER_MILLIS","LOAD_MILLIS","ROUTER_MILLIS","EXTRACT_MILLIS","TRANSFORM_EXTRACT_MILLIS","TRANSFORM_LOAD_MILLIS","LOAD_ID","COMMON_FLAG","FALLBACK_INSERT_COUNT","FALLBACK_UPDATE_COUNT","IGNORE_ROW_COUNT","MISSING_DELETE_COUNT","SKIP_COUNT","FAILED_ROW_NUMBER","FAILED_LINE_NUMBER","FAILED_DATA_ID") SELECT "BATCH_ID","NODE_ID","CHANNEL_ID","STATUS","ERROR_FLAG","SQL_STATE","SQL_CODE","SQL_MESSAGE","LAST_UPDATE_HOSTNAME","LAST_UPDATE_TIME","CREATE_TIME","SUMMARY","IGNORE_COUNT","BYTE_COUNT","LOAD_FLAG","EXTRACT_COUNT","SENT_COUNT","LOAD_COUNT","RELOAD_ROW_COUNT","OTHER_ROW_COUNT","DATA_ROW_COUNT","EXTRACT_ROW_COUNT","LOAD_ROW_COUNT","DATA_INSERT_ROW_COUNT","DATA_UPDATE_ROW_COUNT","DATA_DELETE_ROW_COUNT","EXTRACT_INSERT_ROW_COUNT","EXTRACT_UPDATE_ROW_COUNT","EXTRACT_DELETE_ROW_COUNT","LOAD_INSERT_ROW_COUNT","LOAD_UPDATE_ROW_COUNT","LOAD_DELETE_ROW_COUNT","NETWORK_MILLIS","FILTER_MILLIS","LOAD_MILLIS","ROUTER_MILLIS","EXTRACT_MILLIS","TRANSFORM_EXTRACT_MILLIS","TRANSFORM_LOAD_MILLIS","LOAD_ID","COMMON_FLAG","FALLBACK_INSERT_COUNT","FALLBACK_UPDATE_COUNT","IGNORE_ROW_COUNT","MISSING_DELETE_COUNT","SKIP_COUNT","FAILED_ROW_NUMBER","FAILED_LINE_NUMBER","FAILED_DATA_ID" FROM "KRKHBNM3"."SYM_INCOMING_BATCH_"
2022-01-17 18:57:09,155 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: DROP TABLE "KRKHBNM3"."SYM_INCOMING_BATCH_"
2022-01-17 18:57:09,155 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL failed: DROP TABLE "KRKHBNM3"."SYM_INCOMING_ERROR_"
2022-01-17 18:57:09,163 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: CREATE TABLE "KRKHBNM3"."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" CLOB NOT NULL,
"PK_COLUMN_NAMES" CLOB NOT NULL,
"ROW_DATA" CLOB,
"OLD_DATA" CLOB,
"CUR_DATA" CLOB,
"RESOLVE_DATA" CLOB,
"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")
)
2022-01-17 18:57:09,169 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: INSERT INTO "KRKHBNM3"."SYM_INCOMING_ERROR_" ("BATCH_ID","NODE_ID","FAILED_ROW_NUMBER","FAILED_LINE_NUMBER","TARGET_CATALOG_NAME","TARGET_SCHEMA_NAME","TARGET_TABLE_NAME","EVENT_TYPE","BINARY_ENCODING","COLUMN_NAMES","PK_COLUMN_NAMES","ROW_DATA","OLD_DATA","CUR_DATA","RESOLVE_DATA","RESOLVE_IGNORE","CONFLICT_ID","CREATE_TIME","LAST_UPDATE_BY","LAST_UPDATE_TIME") SELECT "BATCH_ID","NODE_ID","FAILED_ROW_NUMBER","FAILED_LINE_NUMBER","TARGET_CATALOG_NAME","TARGET_SCHEMA_NAME","TARGET_TABLE_NAME","EVENT_TYPE","BINARY_ENCODING","COLUMN_NAMES","PK_COLUMN_NAMES","ROW_DATA","OLD_DATA","CUR_DATA","RESOLVE_DATA","RESOLVE_IGNORE","CONFLICT_ID","CREATE_TIME","LAST_UPDATE_BY","LAST_UPDATE_TIME" FROM "KRKHBNM3"."SYM_INCOMING_ERROR"
2022-01-17 18:57:09,173 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: DROP TABLE "KRKHBNM3"."SYM_INCOMING_ERROR"
2022-01-17 18:57:09,182 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] 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" CLOB NOT NULL,
"PK_COLUMN_NAMES" CLOB NOT NULL,
"ROW_DATA" CLOB,
"OLD_DATA" CLOB,
"CUR_DATA" CLOB,
"RESOLVE_DATA" CLOB,
"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")
)
2022-01-17 18:57:09,185 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: INSERT INTO "SYM_INCOMING_ERROR" ("BATCH_ID","NODE_ID","FAILED_ROW_NUMBER","FAILED_LINE_NUMBER","TARGET_CATALOG_NAME","TARGET_SCHEMA_NAME","TARGET_TABLE_NAME","EVENT_TYPE","BINARY_ENCODING","COLUMN_NAMES","PK_COLUMN_NAMES","ROW_DATA","OLD_DATA","CUR_DATA","RESOLVE_DATA","RESOLVE_IGNORE","CONFLICT_ID","CREATE_TIME","LAST_UPDATE_BY","LAST_UPDATE_TIME") SELECT "BATCH_ID","NODE_ID","FAILED_ROW_NUMBER","FAILED_LINE_NUMBER","TARGET_CATALOG_NAME","TARGET_SCHEMA_NAME","TARGET_TABLE_NAME","EVENT_TYPE","BINARY_ENCODING","COLUMN_NAMES","PK_COLUMN_NAMES","ROW_DATA","OLD_DATA","CUR_DATA","RESOLVE_DATA","RESOLVE_IGNORE","CONFLICT_ID","CREATE_TIME","LAST_UPDATE_BY","LAST_UPDATE_TIME" FROM "KRKHBNM3"."SYM_INCOMING_ERROR_"
2022-01-17 18:57:09,191 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: DROP TABLE "KRKHBNM3"."SYM_INCOMING_ERROR_"
2022-01-17 18:57:09,191 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL failed: DROP TABLE "KRKHBNM3"."SYM_JOB_"
2022-01-17 18:57:09,198 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: CREATE TABLE "KRKHBNM3"."SYM_JOB_"(
"JOB_NAME" VARCHAR(50) NOT NULL,
"JOB_TYPE" VARCHAR(10) NOT NULL,
"REQUIRES_REGISTRATION" SMALLINT DEFAULT 1 NOT NULL,
"JOB_EXPRESSION" CLOB,
"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")
)
2022-01-17 18:57:09,207 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: INSERT INTO "KRKHBNM3"."SYM_JOB_" ("JOB_NAME","JOB_TYPE","REQUIRES_REGISTRATION","JOB_EXPRESSION","DESCRIPTION","DEFAULT_SCHEDULE","DEFAULT_AUTO_START","NODE_GROUP_ID","CREATE_BY","CREATE_TIME","LAST_UPDATE_BY","LAST_UPDATE_TIME") SELECT "JOB_NAME","JOB_TYPE","REQUIRES_REGISTRATION","JOB_EXPRESSION","DESCRIPTION","DEFAULT_SCHEDULE","DEFAULT_AUTO_START","NODE_GROUP_ID","CREATE_BY","CREATE_TIME","LAST_UPDATE_BY","LAST_UPDATE_TIME" FROM "KRKHBNM3"."SYM_JOB"
2022-01-17 18:57:09,211 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: DROP TABLE "KRKHBNM3"."SYM_JOB"
2022-01-17 18:57:09,219 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] 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" CLOB,
"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")
)
2022-01-17 18:57:09,220 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: INSERT INTO "SYM_JOB" ("JOB_NAME","JOB_TYPE","REQUIRES_REGISTRATION","JOB_EXPRESSION","DESCRIPTION","DEFAULT_SCHEDULE","DEFAULT_AUTO_START","NODE_GROUP_ID","CREATE_BY","CREATE_TIME","LAST_UPDATE_BY","LAST_UPDATE_TIME") SELECT "JOB_NAME","JOB_TYPE","REQUIRES_REGISTRATION","JOB_EXPRESSION","DESCRIPTION","DEFAULT_SCHEDULE","DEFAULT_AUTO_START","NODE_GROUP_ID","CREATE_BY","CREATE_TIME","LAST_UPDATE_BY","LAST_UPDATE_TIME" FROM "KRKHBNM3"."SYM_JOB_"
2022-01-17 18:57:09,225 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: DROP TABLE "KRKHBNM3"."SYM_JOB_"
2022-01-17 18:57:09,226 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL failed: DROP TABLE "KRKHBNM3"."SYM_LOAD_FILTER_"
2022-01-17 18:57:09,234 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: CREATE TABLE "KRKHBNM3"."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" CLOB,
"AFTER_WRITE_SCRIPT" CLOB,
"BATCH_COMPLETE_SCRIPT" CLOB,
"BATCH_COMMIT_SCRIPT" CLOB,
"BATCH_ROLLBACK_SCRIPT" CLOB,
"HANDLE_ERROR_SCRIPT" CLOB,
"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")
)
2022-01-17 18:57:09,240 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: INSERT INTO "KRKHBNM3"."SYM_LOAD_FILTER_" ("LOAD_FILTER_ID","LOAD_FILTER_TYPE","SOURCE_NODE_GROUP_ID","TARGET_NODE_GROUP_ID","TARGET_CATALOG_NAME","TARGET_SCHEMA_NAME","TARGET_TABLE_NAME","FILTER_ON_UPDATE","FILTER_ON_INSERT","FILTER_ON_DELETE","BEFORE_WRITE_SCRIPT","AFTER_WRITE_SCRIPT","BATCH_COMPLETE_SCRIPT","BATCH_COMMIT_SCRIPT","BATCH_ROLLBACK_SCRIPT","HANDLE_ERROR_SCRIPT","CREATE_TIME","LAST_UPDATE_BY","LAST_UPDATE_TIME","LOAD_FILTER_ORDER","FAIL_ON_ERROR") SELECT "LOAD_FILTER_ID","LOAD_FILTER_TYPE","SOURCE_NODE_GROUP_ID","TARGET_NODE_GROUP_ID","TARGET_CATALOG_NAME","TARGET_SCHEMA_NAME","TARGET_TABLE_NAME","FILTER_ON_UPDATE","FILTER_ON_INSERT","FILTER_ON_DELETE","BEFORE_WRITE_SCRIPT","AFTER_WRITE_SCRIPT","BATCH_COMPLETE_SCRIPT","BATCH_COMMIT_SCRIPT","BATCH_ROLLBACK_SCRIPT","HANDLE_ERROR_SCRIPT","CREATE_TIME","LAST_UPDATE_BY","LAST_UPDATE_TIME","LOAD_FILTER_ORDER","FAIL_ON_ERROR" FROM "KRKHBNM3"."SYM_LOAD_FILTER"
2022-01-17 18:57:09,245 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: DROP TABLE "KRKHBNM3"."SYM_LOAD_FILTER"
2022-01-17 18:57:09,252 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] 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" CLOB,
"AFTER_WRITE_SCRIPT" CLOB,
"BATCH_COMPLETE_SCRIPT" CLOB,
"BATCH_COMMIT_SCRIPT" CLOB,
"BATCH_ROLLBACK_SCRIPT" CLOB,
"HANDLE_ERROR_SCRIPT" CLOB,
"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")
)
2022-01-17 18:57:09,254 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: INSERT INTO "SYM_LOAD_FILTER" ("LOAD_FILTER_ID","LOAD_FILTER_TYPE","SOURCE_NODE_GROUP_ID","TARGET_NODE_GROUP_ID","TARGET_CATALOG_NAME","TARGET_SCHEMA_NAME","TARGET_TABLE_NAME","FILTER_ON_UPDATE","FILTER_ON_INSERT","FILTER_ON_DELETE","BEFORE_WRITE_SCRIPT","AFTER_WRITE_SCRIPT","BATCH_COMPLETE_SCRIPT","BATCH_COMMIT_SCRIPT","BATCH_ROLLBACK_SCRIPT","HANDLE_ERROR_SCRIPT","CREATE_TIME","LAST_UPDATE_BY","LAST_UPDATE_TIME","LOAD_FILTER_ORDER","FAIL_ON_ERROR") SELECT "LOAD_FILTER_ID","LOAD_FILTER_TYPE","SOURCE_NODE_GROUP_ID","TARGET_NODE_GROUP_ID","TARGET_CATALOG_NAME","TARGET_SCHEMA_NAME","TARGET_TABLE_NAME","FILTER_ON_UPDATE","FILTER_ON_INSERT","FILTER_ON_DELETE","BEFORE_WRITE_SCRIPT","AFTER_WRITE_SCRIPT","BATCH_COMPLETE_SCRIPT","BATCH_COMMIT_SCRIPT","BATCH_ROLLBACK_SCRIPT","HANDLE_ERROR_SCRIPT","CREATE_TIME","LAST_UPDATE_BY","LAST_UPDATE_TIME","LOAD_FILTER_ORDER","FAIL_ON_ERROR" FROM "KRKHBNM3"."SYM_LOAD_FILTER_"
2022-01-17 18:57:09,259 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: DROP TABLE "KRKHBNM3"."SYM_LOAD_FILTER_"
2022-01-17 18:57:09,260 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL failed: DROP TABLE "KRKHBNM3"."SYM_MONITOR_"
2022-01-17 18:57:09,267 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: CREATE TABLE "KRKHBNM3"."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" CLOB,
"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")
)
2022-01-17 18:57:09,274 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: INSERT INTO "KRKHBNM3"."SYM_MONITOR_" ("MONITOR_ID","NODE_GROUP_ID","EXTERNAL_ID","TYPE","EXPRESSION","THRESHOLD","RUN_PERIOD","RUN_COUNT","SEVERITY_LEVEL","ENABLED","CREATE_TIME","LAST_UPDATE_BY","LAST_UPDATE_TIME") SELECT "MONITOR_ID","NODE_GROUP_ID","EXTERNAL_ID","TYPE","EXPRESSION","THRESHOLD","RUN_PERIOD","RUN_COUNT","SEVERITY_LEVEL","ENABLED","CREATE_TIME","LAST_UPDATE_BY","LAST_UPDATE_TIME" FROM "KRKHBNM3"."SYM_MONITOR"
2022-01-17 18:57:09,280 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: DROP TABLE "KRKHBNM3"."SYM_MONITOR"
2022-01-17 18:57:09,289 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] 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" CLOB,
"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")
)
2022-01-17 18:57:09,291 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: INSERT INTO "SYM_MONITOR" ("MONITOR_ID","NODE_GROUP_ID","EXTERNAL_ID","TYPE","EXPRESSION","THRESHOLD","RUN_PERIOD","RUN_COUNT","SEVERITY_LEVEL","ENABLED","CREATE_TIME","LAST_UPDATE_BY","LAST_UPDATE_TIME") SELECT "MONITOR_ID","NODE_GROUP_ID","EXTERNAL_ID","TYPE","EXPRESSION","THRESHOLD","RUN_PERIOD","RUN_COUNT","SEVERITY_LEVEL","ENABLED","CREATE_TIME","LAST_UPDATE_BY","LAST_UPDATE_TIME" FROM "KRKHBNM3"."SYM_MONITOR_"
2022-01-17 18:57:09,296 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: DROP TABLE "KRKHBNM3"."SYM_MONITOR_"
2022-01-17 18:57:09,296 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL failed: DROP TABLE "KRKHBNM3"."SYM_MONITOR_EVENT_"
2022-01-17 18:57:09,304 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: CREATE TABLE "KRKHBNM3"."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" CLOB,
"LAST_UPDATE_TIME" TIMESTAMP,
PRIMARY KEY ("MONITOR_ID", "NODE_ID", "EVENT_TIME")
)
2022-01-17 18:57:09,309 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: INSERT INTO "KRKHBNM3"."SYM_MONITOR_EVENT_" ("MONITOR_ID","NODE_ID","EVENT_TIME","HOST_NAME","TYPE","THRESHOLD","EVENT_VALUE","EVENT_COUNT","SEVERITY_LEVEL","IS_RESOLVED","IS_NOTIFIED","DETAILS","LAST_UPDATE_TIME") SELECT "MONITOR_ID","NODE_ID","EVENT_TIME","HOST_NAME","TYPE","THRESHOLD","EVENT_VALUE","EVENT_COUNT","SEVERITY_LEVEL","IS_RESOLVED","IS_NOTIFIED","DETAILS","LAST_UPDATE_TIME" FROM "KRKHBNM3"."SYM_MONITOR_EVENT"
2022-01-17 18:57:09,314 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: DROP TABLE "KRKHBNM3"."SYM_MONITOR_EVENT"
2022-01-17 18:57:09,322 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] 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" CLOB,
"LAST_UPDATE_TIME" TIMESTAMP,
PRIMARY KEY ("MONITOR_ID", "NODE_ID", "EVENT_TIME")
)
2022-01-17 18:57:09,323 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: INSERT INTO "SYM_MONITOR_EVENT" ("MONITOR_ID","NODE_ID","EVENT_TIME","HOST_NAME","TYPE","THRESHOLD","EVENT_VALUE","EVENT_COUNT","SEVERITY_LEVEL","IS_RESOLVED","IS_NOTIFIED","DETAILS","LAST_UPDATE_TIME") SELECT "MONITOR_ID","NODE_ID","EVENT_TIME","HOST_NAME","TYPE","THRESHOLD","EVENT_VALUE","EVENT_COUNT","SEVERITY_LEVEL","IS_RESOLVED","IS_NOTIFIED","DETAILS","LAST_UPDATE_TIME" FROM "KRKHBNM3"."SYM_MONITOR_EVENT_"
2022-01-17 18:57:09,329 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: DROP TABLE "KRKHBNM3"."SYM_MONITOR_EVENT_"
2022-01-17 18:57:09,330 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL failed: DROP TABLE "KRKHBNM3"."SYM_NOTIFICATION_"
2022-01-17 18:57:09,337 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: CREATE TABLE "KRKHBNM3"."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" CLOB,
"ENABLED" SMALLINT DEFAULT 0 NOT NULL,
"CREATE_TIME" TIMESTAMP,
"LAST_UPDATE_BY" VARCHAR(50),
"LAST_UPDATE_TIME" TIMESTAMP,
PRIMARY KEY ("NOTIFICATION_ID")
)
2022-01-17 18:57:09,342 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: INSERT INTO "KRKHBNM3"."SYM_NOTIFICATION_" ("NOTIFICATION_ID","NODE_GROUP_ID","EXTERNAL_ID","SEVERITY_LEVEL","TYPE","EXPRESSION","ENABLED","CREATE_TIME","LAST_UPDATE_BY","LAST_UPDATE_TIME") SELECT "NOTIFICATION_ID","NODE_GROUP_ID","EXTERNAL_ID","SEVERITY_LEVEL","TYPE","EXPRESSION","ENABLED","CREATE_TIME","LAST_UPDATE_BY","LAST_UPDATE_TIME" FROM "KRKHBNM3"."SYM_NOTIFICATION"
2022-01-17 18:57:09,347 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: DROP TABLE "KRKHBNM3"."SYM_NOTIFICATION"
2022-01-17 18:57:09,354 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] 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" CLOB,
"ENABLED" SMALLINT DEFAULT 0 NOT NULL,
"CREATE_TIME" TIMESTAMP,
"LAST_UPDATE_BY" VARCHAR(50),
"LAST_UPDATE_TIME" TIMESTAMP,
PRIMARY KEY ("NOTIFICATION_ID")
)
2022-01-17 18:57:09,355 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: INSERT INTO "SYM_NOTIFICATION" ("NOTIFICATION_ID","NODE_GROUP_ID","EXTERNAL_ID","SEVERITY_LEVEL","TYPE","EXPRESSION","ENABLED","CREATE_TIME","LAST_UPDATE_BY","LAST_UPDATE_TIME") SELECT "NOTIFICATION_ID","NODE_GROUP_ID","EXTERNAL_ID","SEVERITY_LEVEL","TYPE","EXPRESSION","ENABLED","CREATE_TIME","LAST_UPDATE_BY","LAST_UPDATE_TIME" FROM "KRKHBNM3"."SYM_NOTIFICATION_"
2022-01-17 18:57:09,360 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: DROP TABLE "KRKHBNM3"."SYM_NOTIFICATION_"
2022-01-17 18:57:09,361 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL failed: DROP TABLE "KRKHBNM3"."SYM_OUTGOING_BATCH_"
2022-01-17 18:57:09,371 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: CREATE TABLE "KRKHBNM3"."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" CLOB,
"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")
)
2022-01-17 18:57:09,379 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: INSERT INTO "KRKHBNM3"."SYM_OUTGOING_BATCH_" ("BATCH_ID","NODE_ID","CHANNEL_ID","STATUS","ERROR_FLAG","SQL_STATE","SQL_CODE","SQL_MESSAGE","LAST_UPDATE_HOSTNAME","LAST_UPDATE_TIME","CREATE_TIME","SUMMARY","IGNORE_COUNT","BYTE_COUNT","LOAD_FLAG","EXTRACT_COUNT","SENT_COUNT","LOAD_COUNT","RELOAD_ROW_COUNT","OTHER_ROW_COUNT","DATA_ROW_COUNT","EXTRACT_ROW_COUNT","LOAD_ROW_COUNT","DATA_INSERT_ROW_COUNT","DATA_UPDATE_ROW_COUNT","DATA_DELETE_ROW_COUNT","EXTRACT_INSERT_ROW_COUNT","EXTRACT_UPDATE_ROW_COUNT","EXTRACT_DELETE_ROW_COUNT","LOAD_INSERT_ROW_COUNT","LOAD_UPDATE_ROW_COUNT","LOAD_DELETE_ROW_COUNT","NETWORK_MILLIS","FILTER_MILLIS","LOAD_MILLIS","ROUTER_MILLIS","EXTRACT_MILLIS","TRANSFORM_EXTRACT_MILLIS","TRANSFORM_LOAD_MILLIS","LOAD_ID","COMMON_FLAG","FALLBACK_INSERT_COUNT","FALLBACK_UPDATE_COUNT","IGNORE_ROW_COUNT","MISSING_DELETE_COUNT","SKIP_COUNT","TOTAL_EXTRACT_MILLIS","TOTAL_LOAD_MILLIS","EXTRACT_JOB_FLAG","EXTRACT_START_TIME","TRANSFER_START_TIME","LOAD_START_TIME","FAILED_DATA_ID","FAILED_LINE_NUMBER","CREATE_BY") SELECT "BATCH_ID","NODE_ID","CHANNEL_ID","STATUS","ERROR_FLAG","SQL_STATE","SQL_CODE","SQL_MESSAGE","LAST_UPDATE_HOSTNAME","LAST_UPDATE_TIME","CREATE_TIME","SUMMARY","IGNORE_COUNT","BYTE_COUNT","LOAD_FLAG","EXTRACT_COUNT","SENT_COUNT","LOAD_COUNT","RELOAD_ROW_COUNT","OTHER_ROW_COUNT","DATA_ROW_COUNT","EXTRACT_ROW_COUNT","LOAD_ROW_COUNT","DATA_INSERT_ROW_COUNT","DATA_UPDATE_ROW_COUNT","DATA_DELETE_ROW_COUNT","EXTRACT_INSERT_ROW_COUNT","EXTRACT_UPDATE_ROW_COUNT","EXTRACT_DELETE_ROW_COUNT","LOAD_INSERT_ROW_COUNT","LOAD_UPDATE_ROW_COUNT","LOAD_DELETE_ROW_COUNT","NETWORK_MILLIS","FILTER_MILLIS","LOAD_MILLIS","ROUTER_MILLIS","EXTRACT_MILLIS","TRANSFORM_EXTRACT_MILLIS","TRANSFORM_LOAD_MILLIS","LOAD_ID","COMMON_FLAG","FALLBACK_INSERT_COUNT","FALLBACK_UPDATE_COUNT","IGNORE_ROW_COUNT","MISSING_DELETE_COUNT","SKIP_COUNT","TOTAL_EXTRACT_MILLIS","TOTAL_LOAD_MILLIS","EXTRACT_JOB_FLAG","EXTRACT_START_TIME","TRANSFER_START_TIME","LOAD_START_TIME","FAILED_DATA_ID","FAILED_LINE_NUMBER","CREATE_BY" FROM "KRKHBNM3"."SYM_OUTGOING_BATCH"
2022-01-17 18:57:09,390 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: DROP TABLE "KRKHBNM3"."SYM_OUTGOING_BATCH"
2022-01-17 18:57:09,400 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] 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" CLOB,
"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")
)
2022-01-17 18:57:09,405 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: CREATE INDEX "SYM_IDX_OB_NODE_STATUS" ON "SYM_OUTGOING_BATCH" ("NODE_ID", "STATUS")
2022-01-17 18:57:09,409 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: CREATE INDEX "SYM_IDX_OB_STATUS" ON "SYM_OUTGOING_BATCH" ("STATUS")
2022-01-17 18:57:09,415 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: CREATE INDEX "SYM_IDX_OB_IN_ERROR" ON "SYM_OUTGOING_BATCH" ("ERROR_FLAG")
2022-01-17 18:57:09,419 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: INSERT INTO "SYM_OUTGOING_BATCH" ("BATCH_ID","NODE_ID","CHANNEL_ID","STATUS","ERROR_FLAG","SQL_STATE","SQL_CODE","SQL_MESSAGE","LAST_UPDATE_HOSTNAME","LAST_UPDATE_TIME","CREATE_TIME","SUMMARY","IGNORE_COUNT","BYTE_COUNT","LOAD_FLAG","EXTRACT_COUNT","SENT_COUNT","LOAD_COUNT","RELOAD_ROW_COUNT","OTHER_ROW_COUNT","DATA_ROW_COUNT","EXTRACT_ROW_COUNT","LOAD_ROW_COUNT","DATA_INSERT_ROW_COUNT","DATA_UPDATE_ROW_COUNT","DATA_DELETE_ROW_COUNT","EXTRACT_INSERT_ROW_COUNT","EXTRACT_UPDATE_ROW_COUNT","EXTRACT_DELETE_ROW_COUNT","LOAD_INSERT_ROW_COUNT","LOAD_UPDATE_ROW_COUNT","LOAD_DELETE_ROW_COUNT","NETWORK_MILLIS","FILTER_MILLIS","LOAD_MILLIS","ROUTER_MILLIS","EXTRACT_MILLIS","TRANSFORM_EXTRACT_MILLIS","TRANSFORM_LOAD_MILLIS","LOAD_ID","COMMON_FLAG","FALLBACK_INSERT_COUNT","FALLBACK_UPDATE_COUNT","IGNORE_ROW_COUNT","MISSING_DELETE_COUNT","SKIP_COUNT","TOTAL_EXTRACT_MILLIS","TOTAL_LOAD_MILLIS","EXTRACT_JOB_FLAG","EXTRACT_START_TIME","TRANSFER_START_TIME","LOAD_START_TIME","FAILED_DATA_ID","FAILED_LINE_NUMBER","CREATE_BY") SELECT "BATCH_ID","NODE_ID","CHANNEL_ID","STATUS","ERROR_FLAG","SQL_STATE","SQL_CODE","SQL_MESSAGE","LAST_UPDATE_HOSTNAME","LAST_UPDATE_TIME","CREATE_TIME","SUMMARY","IGNORE_COUNT","BYTE_COUNT","LOAD_FLAG","EXTRACT_COUNT","SENT_COUNT","LOAD_COUNT","RELOAD_ROW_COUNT","OTHER_ROW_COUNT","DATA_ROW_COUNT","EXTRACT_ROW_COUNT","LOAD_ROW_COUNT","DATA_INSERT_ROW_COUNT","DATA_UPDATE_ROW_COUNT","DATA_DELETE_ROW_COUNT","EXTRACT_INSERT_ROW_COUNT","EXTRACT_UPDATE_ROW_COUNT","EXTRACT_DELETE_ROW_COUNT","LOAD_INSERT_ROW_COUNT","LOAD_UPDATE_ROW_COUNT","LOAD_DELETE_ROW_COUNT","NETWORK_MILLIS","FILTER_MILLIS","LOAD_MILLIS","ROUTER_MILLIS","EXTRACT_MILLIS","TRANSFORM_EXTRACT_MILLIS","TRANSFORM_LOAD_MILLIS","LOAD_ID","COMMON_FLAG","FALLBACK_INSERT_COUNT","FALLBACK_UPDATE_COUNT","IGNORE_ROW_COUNT","MISSING_DELETE_COUNT","SKIP_COUNT","TOTAL_EXTRACT_MILLIS","TOTAL_LOAD_MILLIS","EXTRACT_JOB_FLAG","EXTRACT_START_TIME","TRANSFER_START_TIME","LOAD_START_TIME","FAILED_DATA_ID","FAILED_LINE_NUMBER","CREATE_BY" FROM "KRKHBNM3"."SYM_OUTGOING_BATCH_"
2022-01-17 18:57:09,425 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: DROP TABLE "KRKHBNM3"."SYM_OUTGOING_BATCH_"
2022-01-17 18:57:09,426 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL failed: DROP TABLE "KRKHBNM3"."SYM_PARAMETER_"
2022-01-17 18:57:09,431 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: CREATE TABLE "KRKHBNM3"."SYM_PARAMETER_"(
"EXTERNAL_ID" VARCHAR(255) NOT NULL,
"NODE_GROUP_ID" VARCHAR(50) NOT NULL,
"PARAM_KEY" VARCHAR(80) NOT NULL,
"PARAM_VALUE" CLOB,
"CREATE_TIME" TIMESTAMP,
"LAST_UPDATE_BY" VARCHAR(50),
"LAST_UPDATE_TIME" TIMESTAMP,
PRIMARY KEY ("EXTERNAL_ID", "NODE_GROUP_ID", "PARAM_KEY")
)
2022-01-17 18:57:09,440 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: INSERT INTO "KRKHBNM3"."SYM_PARAMETER_" ("EXTERNAL_ID","NODE_GROUP_ID","PARAM_KEY","PARAM_VALUE","CREATE_TIME","LAST_UPDATE_BY","LAST_UPDATE_TIME") SELECT "EXTERNAL_ID","NODE_GROUP_ID","PARAM_KEY","PARAM_VALUE","CREATE_TIME","LAST_UPDATE_BY","LAST_UPDATE_TIME" FROM "KRKHBNM3"."SYM_PARAMETER"
2022-01-17 18:57:09,444 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: DROP TABLE "KRKHBNM3"."SYM_PARAMETER"
2022-01-17 18:57:09,450 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] 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" CLOB,
"CREATE_TIME" TIMESTAMP,
"LAST_UPDATE_BY" VARCHAR(50),
"LAST_UPDATE_TIME" TIMESTAMP,
PRIMARY KEY ("EXTERNAL_ID", "NODE_GROUP_ID", "PARAM_KEY")
)
2022-01-17 18:57:09,452 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: INSERT INTO "SYM_PARAMETER" ("EXTERNAL_ID","NODE_GROUP_ID","PARAM_KEY","PARAM_VALUE","CREATE_TIME","LAST_UPDATE_BY","LAST_UPDATE_TIME") SELECT "EXTERNAL_ID","NODE_GROUP_ID","PARAM_KEY","PARAM_VALUE","CREATE_TIME","LAST_UPDATE_BY","LAST_UPDATE_TIME" FROM "KRKHBNM3"."SYM_PARAMETER_"
2022-01-17 18:57:09,456 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: DROP TABLE "KRKHBNM3"."SYM_PARAMETER_"
2022-01-17 18:57:09,457 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL failed: DROP TABLE "KRKHBNM3"."SYM_REGISTRATION_REQUEST_"
2022-01-17 18:57:09,463 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: CREATE TABLE "KRKHBNM3"."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" CLOB,
"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")
)
2022-01-17 18:57:09,469 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: INSERT INTO "KRKHBNM3"."SYM_REGISTRATION_REQUEST_" ("NODE_GROUP_ID","EXTERNAL_ID","STATUS","HOST_NAME","IP_ADDRESS","ATTEMPT_COUNT","REGISTERED_NODE_ID","ERROR_MESSAGE","CREATE_TIME","LAST_UPDATE_BY","LAST_UPDATE_TIME") SELECT "NODE_GROUP_ID","EXTERNAL_ID","STATUS","HOST_NAME","IP_ADDRESS","ATTEMPT_COUNT","REGISTERED_NODE_ID","ERROR_MESSAGE","CREATE_TIME","LAST_UPDATE_BY","LAST_UPDATE_TIME" FROM "KRKHBNM3"."SYM_REGISTRATION_REQUEST"
2022-01-17 18:57:09,478 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: DROP TABLE "KRKHBNM3"."SYM_REGISTRATION_REQUEST"
2022-01-17 18:57:09,485 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] 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" CLOB,
"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")
)
2022-01-17 18:57:09,489 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: CREATE INDEX "SYM_IDX_REG_REQ_1" ON "SYM_REGISTRATION_REQUEST" ("NODE_GROUP_ID", "EXTERNAL_ID", "STATUS", "HOST_NAME", "IP_ADDRESS")
2022-01-17 18:57:09,492 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: CREATE INDEX "SYM_IDX_REG_REQ_2" ON "SYM_REGISTRATION_REQUEST" ("STATUS")
2022-01-17 18:57:09,493 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: INSERT INTO "SYM_REGISTRATION_REQUEST" ("NODE_GROUP_ID","EXTERNAL_ID","STATUS","HOST_NAME","IP_ADDRESS","ATTEMPT_COUNT","REGISTERED_NODE_ID","ERROR_MESSAGE","CREATE_TIME","LAST_UPDATE_BY","LAST_UPDATE_TIME") SELECT "NODE_GROUP_ID","EXTERNAL_ID","STATUS","HOST_NAME","IP_ADDRESS","ATTEMPT_COUNT","REGISTERED_NODE_ID","ERROR_MESSAGE","CREATE_TIME","LAST_UPDATE_BY","LAST_UPDATE_TIME" FROM "KRKHBNM3"."SYM_REGISTRATION_REQUEST_"
2022-01-17 18:57:09,498 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: DROP TABLE "KRKHBNM3"."SYM_REGISTRATION_REQUEST_"
2022-01-17 18:57:09,498 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL failed: DROP TABLE "KRKHBNM3"."SYM_ROUTER_"
2022-01-17 18:57:09,505 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: CREATE TABLE "KRKHBNM3"."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) DEFAULT 'default' NOT NULL,
"ROUTER_EXPRESSION" CLOB,
"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" CLOB,
PRIMARY KEY ("ROUTER_ID")
)
2022-01-17 18:57:09,507 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: INSERT INTO "KRKHBNM3"."SYM_ROUTER_" ("ROUTER_ID","TARGET_CATALOG_NAME","TARGET_SCHEMA_NAME","TARGET_TABLE_NAME","SOURCE_NODE_GROUP_ID","TARGET_NODE_GROUP_ID","ROUTER_TYPE","ROUTER_EXPRESSION","SYNC_ON_UPDATE","SYNC_ON_INSERT","SYNC_ON_DELETE","USE_SOURCE_CATALOG_SCHEMA","CREATE_TIME","LAST_UPDATE_BY","LAST_UPDATE_TIME","DESCRIPTION") SELECT "ROUTER_ID","TARGET_CATALOG_NAME","TARGET_SCHEMA_NAME","TARGET_TABLE_NAME","SOURCE_NODE_GROUP_ID","TARGET_NODE_GROUP_ID","ROUTER_TYPE","ROUTER_EXPRESSION","SYNC_ON_UPDATE","SYNC_ON_INSERT","SYNC_ON_DELETE","USE_SOURCE_CATALOG_SCHEMA","CREATE_TIME","LAST_UPDATE_BY","LAST_UPDATE_TIME","DESCRIPTION" FROM "KRKHBNM3"."SYM_ROUTER"
2022-01-17 18:57:09,512 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: DROP TABLE "KRKHBNM3"."SYM_ROUTER"
2022-01-17 18:57:09,520 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] 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) DEFAULT 'default' NOT NULL,
"ROUTER_EXPRESSION" CLOB,
"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" CLOB,
PRIMARY KEY ("ROUTER_ID")
)
2022-01-17 18:57:09,522 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: INSERT INTO "SYM_ROUTER" ("ROUTER_ID","TARGET_CATALOG_NAME","TARGET_SCHEMA_NAME","TARGET_TABLE_NAME","SOURCE_NODE_GROUP_ID","TARGET_NODE_GROUP_ID","ROUTER_TYPE","ROUTER_EXPRESSION","SYNC_ON_UPDATE","SYNC_ON_INSERT","SYNC_ON_DELETE","USE_SOURCE_CATALOG_SCHEMA","CREATE_TIME","LAST_UPDATE_BY","LAST_UPDATE_TIME","DESCRIPTION") SELECT "ROUTER_ID","TARGET_CATALOG_NAME","TARGET_SCHEMA_NAME","TARGET_TABLE_NAME","SOURCE_NODE_GROUP_ID","TARGET_NODE_GROUP_ID","ROUTER_TYPE","ROUTER_EXPRESSION","SYNC_ON_UPDATE","SYNC_ON_INSERT","SYNC_ON_DELETE","USE_SOURCE_CATALOG_SCHEMA","CREATE_TIME","LAST_UPDATE_BY","LAST_UPDATE_TIME","DESCRIPTION" FROM "KRKHBNM3"."SYM_ROUTER_"
2022-01-17 18:57:09,527 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: DROP TABLE "KRKHBNM3"."SYM_ROUTER_"
2022-01-17 18:57:09,528 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL failed: DROP TABLE "KRKHBNM3"."SYM_TABLE_RELOAD_REQUEST_"
2022-01-17 18:57:09,537 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: CREATE TABLE "KRKHBNM3"."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" CLOB,
"BEFORE_CUSTOM_SQL" CLOB,
"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")
)
2022-01-17 18:57:09,544 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: INSERT INTO "KRKHBNM3"."SYM_TABLE_RELOAD_REQUEST_" ("TARGET_NODE_ID","SOURCE_NODE_ID","TRIGGER_ID","ROUTER_ID","CREATE_TIME","CREATE_TABLE","DELETE_FIRST","RELOAD_SELECT","BEFORE_CUSTOM_SQL","RELOAD_TIME","LOAD_ID","PROCESSED","CHANNEL_ID","LAST_UPDATE_BY","LAST_UPDATE_TIME") SELECT "TARGET_NODE_ID","SOURCE_NODE_ID","TRIGGER_ID","ROUTER_ID","CREATE_TIME","CREATE_TABLE","DELETE_FIRST","RELOAD_SELECT","BEFORE_CUSTOM_SQL","RELOAD_TIME","LOAD_ID","PROCESSED","CHANNEL_ID","LAST_UPDATE_BY","LAST_UPDATE_TIME" FROM "KRKHBNM3"."SYM_TABLE_RELOAD_REQUEST"
2022-01-17 18:57:09,548 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: DROP TABLE "KRKHBNM3"."SYM_TABLE_RELOAD_REQUEST"
2022-01-17 18:57:09,555 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] 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" CLOB,
"BEFORE_CUSTOM_SQL" CLOB,
"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")
)
2022-01-17 18:57:09,557 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: INSERT INTO "SYM_TABLE_RELOAD_REQUEST" ("TARGET_NODE_ID","SOURCE_NODE_ID","TRIGGER_ID","ROUTER_ID","CREATE_TIME","CREATE_TABLE","DELETE_FIRST","RELOAD_SELECT","BEFORE_CUSTOM_SQL","RELOAD_TIME","LOAD_ID","PROCESSED","CHANNEL_ID","LAST_UPDATE_BY","LAST_UPDATE_TIME") SELECT "TARGET_NODE_ID","SOURCE_NODE_ID","TRIGGER_ID","ROUTER_ID","CREATE_TIME","CREATE_TABLE","DELETE_FIRST","RELOAD_SELECT","BEFORE_CUSTOM_SQL","RELOAD_TIME","LOAD_ID","PROCESSED","CHANNEL_ID","LAST_UPDATE_BY","LAST_UPDATE_TIME" FROM "KRKHBNM3"."SYM_TABLE_RELOAD_REQUEST_"
2022-01-17 18:57:09,562 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: DROP TABLE "KRKHBNM3"."SYM_TABLE_RELOAD_REQUEST_"
2022-01-17 18:57:09,563 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL failed: DROP TABLE "KRKHBNM3"."SYM_TABLE_RELOAD_STATUS_"
2022-01-17 18:57:09,572 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: CREATE TABLE "KRKHBNM3"."SYM_TABLE_RELOAD_STATUS_"(
"LOAD_ID" BIGINT NOT NULL,
"SOURCE_NODE_ID" VARCHAR(50) NOT NULL,
"TARGET_NODE_ID" VARCHAR(50) NOT NULL,
"START_TIME" TIMESTAMP,
"END_TIME" TIMESTAMP,
"COMPLETED" SMALLINT DEFAULT 0 NOT NULL,
"CANCELLED" SMALLINT DEFAULT 0 NOT NULL,
"FULL_LOAD" SMALLINT DEFAULT 0 NOT NULL,
"START_DATA_BATCH_ID" BIGINT,
"END_DATA_BATCH_ID" BIGINT,
"SETUP_BATCH_COUNT" BIGINT DEFAULT 0 NOT NULL,
"DATA_BATCH_COUNT" BIGINT DEFAULT 0 NOT NULL,
"FINALIZE_BATCH_COUNT" BIGINT DEFAULT 0 NOT NULL,
"SETUP_BATCH_LOADED" BIGINT DEFAULT 0 NOT NULL,
"DATA_BATCH_LOADED" BIGINT DEFAULT 0 NOT NULL,
"FINALIZE_BATCH_LOADED" BIGINT DEFAULT 0 NOT NULL,
"TABLE_COUNT" BIGINT DEFAULT 0 NOT NULL,
"ROWS_LOADED" BIGINT DEFAULT 0 NOT NULL,
"ROWS_COUNT" BIGINT DEFAULT 0 NOT NULL,
"ERROR_FLAG" SMALLINT DEFAULT 0 NOT NULL,
"SQL_STATE" VARCHAR(10),
"SQL_CODE" INTEGER DEFAULT 0 NOT NULL,
"SQL_MESSAGE" CLOB,
"LAST_UPDATE_BY" VARCHAR(50),
"LAST_UPDATE_TIME" TIMESTAMP NOT NULL,
PRIMARY KEY ("LOAD_ID", "SOURCE_NODE_ID")
)
2022-01-17 18:57:09,583 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: INSERT INTO "KRKHBNM3"."SYM_TABLE_RELOAD_STATUS_" ("LOAD_ID","SOURCE_NODE_ID","TARGET_NODE_ID","START_TIME","END_TIME","COMPLETED","CANCELLED","FULL_LOAD","START_DATA_BATCH_ID","END_DATA_BATCH_ID","SETUP_BATCH_COUNT","DATA_BATCH_COUNT","FINALIZE_BATCH_COUNT","SETUP_BATCH_LOADED","DATA_BATCH_LOADED","FINALIZE_BATCH_LOADED","TABLE_COUNT","ROWS_LOADED","ROWS_COUNT","ERROR_FLAG","SQL_STATE","SQL_CODE","SQL_MESSAGE","LAST_UPDATE_BY","LAST_UPDATE_TIME") SELECT "LOAD_ID","SOURCE_NODE_ID","TARGET_NODE_ID","START_TIME","END_TIME","COMPLETED","CANCELLED","FULL_LOAD","START_DATA_BATCH_ID","END_DATA_BATCH_ID","SETUP_BATCH_COUNT","DATA_BATCH_COUNT","FINALIZE_BATCH_COUNT","SETUP_BATCH_LOADED","DATA_BATCH_LOADED","FINALIZE_BATCH_LOADED","TABLE_COUNT","ROWS_LOADED","ROWS_COUNT","ERROR_FLAG","SQL_STATE","SQL_CODE","SQL_MESSAGE","LAST_UPDATE_BY","LAST_UPDATE_TIME" FROM "KRKHBNM3"."SYM_TABLE_RELOAD_STATUS"
2022-01-17 18:57:09,589 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: DROP TABLE "KRKHBNM3"."SYM_TABLE_RELOAD_STATUS"
2022-01-17 18:57:09,597 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: CREATE TABLE "SYM_TABLE_RELOAD_STATUS"(
"LOAD_ID" BIGINT NOT NULL,
"SOURCE_NODE_ID" VARCHAR(50) NOT NULL,
"TARGET_NODE_ID" VARCHAR(50) NOT NULL,
"START_TIME" TIMESTAMP,
"END_TIME" TIMESTAMP,
"COMPLETED" SMALLINT DEFAULT 0 NOT NULL,
"CANCELLED" SMALLINT DEFAULT 0 NOT NULL,
"FULL_LOAD" SMALLINT DEFAULT 0 NOT NULL,
"START_DATA_BATCH_ID" BIGINT,
"END_DATA_BATCH_ID" BIGINT,
"SETUP_BATCH_COUNT" BIGINT DEFAULT 0 NOT NULL,
"DATA_BATCH_COUNT" BIGINT DEFAULT 0 NOT NULL,
"FINALIZE_BATCH_COUNT" BIGINT DEFAULT 0 NOT NULL,
"SETUP_BATCH_LOADED" BIGINT DEFAULT 0 NOT NULL,
"DATA_BATCH_LOADED" BIGINT DEFAULT 0 NOT NULL,
"FINALIZE_BATCH_LOADED" BIGINT DEFAULT 0 NOT NULL,
"TABLE_COUNT" BIGINT DEFAULT 0 NOT NULL,
"ROWS_LOADED" BIGINT DEFAULT 0 NOT NULL,
"ROWS_COUNT" BIGINT DEFAULT 0 NOT NULL,
"ERROR_FLAG" SMALLINT DEFAULT 0 NOT NULL,
"SQL_STATE" VARCHAR(10),
"SQL_CODE" INTEGER DEFAULT 0 NOT NULL,
"SQL_MESSAGE" CLOB,
"LAST_UPDATE_BY" VARCHAR(50),
"LAST_UPDATE_TIME" TIMESTAMP NOT NULL,
PRIMARY KEY ("LOAD_ID", "SOURCE_NODE_ID")
)
2022-01-17 18:57:09,600 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: INSERT INTO "SYM_TABLE_RELOAD_STATUS" ("LOAD_ID","SOURCE_NODE_ID","TARGET_NODE_ID","START_TIME","END_TIME","COMPLETED","CANCELLED","FULL_LOAD","START_DATA_BATCH_ID","END_DATA_BATCH_ID","SETUP_BATCH_COUNT","DATA_BATCH_COUNT","FINALIZE_BATCH_COUNT","SETUP_BATCH_LOADED","DATA_BATCH_LOADED","FINALIZE_BATCH_LOADED","TABLE_COUNT","ROWS_LOADED","ROWS_COUNT","ERROR_FLAG","SQL_STATE","SQL_CODE","SQL_MESSAGE","LAST_UPDATE_BY","LAST_UPDATE_TIME") SELECT "LOAD_ID","SOURCE_NODE_ID","TARGET_NODE_ID","START_TIME","END_TIME","COMPLETED","CANCELLED","FULL_LOAD","START_DATA_BATCH_ID","END_DATA_BATCH_ID","SETUP_BATCH_COUNT","DATA_BATCH_COUNT","FINALIZE_BATCH_COUNT","SETUP_BATCH_LOADED","DATA_BATCH_LOADED","FINALIZE_BATCH_LOADED","TABLE_COUNT","ROWS_LOADED","ROWS_COUNT","ERROR_FLAG","SQL_STATE","SQL_CODE","SQL_MESSAGE","LAST_UPDATE_BY","LAST_UPDATE_TIME" FROM "KRKHBNM3"."SYM_TABLE_RELOAD_STATUS_"
2022-01-17 18:57:09,605 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: DROP TABLE "KRKHBNM3"."SYM_TABLE_RELOAD_STATUS_"
2022-01-17 18:57:09,606 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL failed: DROP TABLE "KRKHBNM3"."SYM_TRANSFORM_TABLE_"
2022-01-17 18:57:09,612 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: CREATE TABLE "KRKHBNM3"."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" CLOB,
PRIMARY KEY ("TRANSFORM_ID", "SOURCE_NODE_GROUP_ID", "TARGET_NODE_GROUP_ID")
)
2022-01-17 18:57:09,619 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: INSERT INTO "KRKHBNM3"."SYM_TRANSFORM_TABLE_" ("TRANSFORM_ID","SOURCE_NODE_GROUP_ID","TARGET_NODE_GROUP_ID","TRANSFORM_POINT","SOURCE_CATALOG_NAME","SOURCE_SCHEMA_NAME","SOURCE_TABLE_NAME","TARGET_CATALOG_NAME","TARGET_SCHEMA_NAME","TARGET_TABLE_NAME","UPDATE_FIRST","UPDATE_ACTION","DELETE_ACTION","TRANSFORM_ORDER","COLUMN_POLICY","CREATE_TIME","LAST_UPDATE_BY","LAST_UPDATE_TIME","DESCRIPTION") SELECT "TRANSFORM_ID","SOURCE_NODE_GROUP_ID","TARGET_NODE_GROUP_ID","TRANSFORM_POINT","SOURCE_CATALOG_NAME","SOURCE_SCHEMA_NAME","SOURCE_TABLE_NAME","TARGET_CATALOG_NAME","TARGET_SCHEMA_NAME","TARGET_TABLE_NAME","UPDATE_FIRST","UPDATE_ACTION","DELETE_ACTION","TRANSFORM_ORDER","COLUMN_POLICY","CREATE_TIME","LAST_UPDATE_BY","LAST_UPDATE_TIME","DESCRIPTION" FROM "KRKHBNM3"."SYM_TRANSFORM_TABLE"
2022-01-17 18:57:09,624 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: DROP TABLE "KRKHBNM3"."SYM_TRANSFORM_TABLE"
2022-01-17 18:57:09,631 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] 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" CLOB,
PRIMARY KEY ("TRANSFORM_ID", "SOURCE_NODE_GROUP_ID", "TARGET_NODE_GROUP_ID")
)
2022-01-17 18:57:09,637 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: INSERT INTO "SYM_TRANSFORM_TABLE" ("TRANSFORM_ID","SOURCE_NODE_GROUP_ID","TARGET_NODE_GROUP_ID","TRANSFORM_POINT","SOURCE_CATALOG_NAME","SOURCE_SCHEMA_NAME","SOURCE_TABLE_NAME","TARGET_CATALOG_NAME","TARGET_SCHEMA_NAME","TARGET_TABLE_NAME","UPDATE_FIRST","UPDATE_ACTION","DELETE_ACTION","TRANSFORM_ORDER","COLUMN_POLICY","CREATE_TIME","LAST_UPDATE_BY","LAST_UPDATE_TIME","DESCRIPTION") SELECT "TRANSFORM_ID","SOURCE_NODE_GROUP_ID","TARGET_NODE_GROUP_ID","TRANSFORM_POINT","SOURCE_CATALOG_NAME","SOURCE_SCHEMA_NAME","SOURCE_TABLE_NAME","TARGET_CATALOG_NAME","TARGET_SCHEMA_NAME","TARGET_TABLE_NAME","UPDATE_FIRST","UPDATE_ACTION","DELETE_ACTION","TRANSFORM_ORDER","COLUMN_POLICY","CREATE_TIME","LAST_UPDATE_BY","LAST_UPDATE_TIME","DESCRIPTION" FROM "KRKHBNM3"."SYM_TRANSFORM_TABLE_"
2022-01-17 18:57:09,642 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: DROP TABLE "KRKHBNM3"."SYM_TRANSFORM_TABLE_"
2022-01-17 18:57:09,643 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL failed: DROP TABLE "KRKHBNM3"."SYM_TRANSFORM_COLUMN_"
2022-01-17 18:57:09,651 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: CREATE TABLE "KRKHBNM3"."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" CLOB,
"TRANSFORM_ORDER" INTEGER DEFAULT 1 NOT NULL,
"CREATE_TIME" TIMESTAMP,
"LAST_UPDATE_BY" VARCHAR(50),
"LAST_UPDATE_TIME" TIMESTAMP,
"DESCRIPTION" CLOB,
PRIMARY KEY ("TRANSFORM_ID", "INCLUDE_ON", "TARGET_COLUMN_NAME")
)
2022-01-17 18:57:09,657 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: INSERT INTO "KRKHBNM3"."SYM_TRANSFORM_COLUMN_" ("TRANSFORM_ID","INCLUDE_ON","TARGET_COLUMN_NAME","SOURCE_COLUMN_NAME","PK","TRANSFORM_TYPE","TRANSFORM_EXPRESSION","TRANSFORM_ORDER","CREATE_TIME","LAST_UPDATE_BY","LAST_UPDATE_TIME","DESCRIPTION") SELECT "TRANSFORM_ID","INCLUDE_ON","TARGET_COLUMN_NAME","SOURCE_COLUMN_NAME","PK","TRANSFORM_TYPE","TRANSFORM_EXPRESSION","TRANSFORM_ORDER","CREATE_TIME","LAST_UPDATE_BY","LAST_UPDATE_TIME","DESCRIPTION" FROM "KRKHBNM3"."SYM_TRANSFORM_COLUMN"
2022-01-17 18:57:09,662 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: DROP TABLE "KRKHBNM3"."SYM_TRANSFORM_COLUMN"
2022-01-17 18:57:09,669 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] 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" CLOB,
"TRANSFORM_ORDER" INTEGER DEFAULT 1 NOT NULL,
"CREATE_TIME" TIMESTAMP,
"LAST_UPDATE_BY" VARCHAR(50),
"LAST_UPDATE_TIME" TIMESTAMP,
"DESCRIPTION" CLOB,
PRIMARY KEY ("TRANSFORM_ID", "INCLUDE_ON", "TARGET_COLUMN_NAME")
)
2022-01-17 18:57:09,670 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: INSERT INTO "SYM_TRANSFORM_COLUMN" ("TRANSFORM_ID","INCLUDE_ON","TARGET_COLUMN_NAME","SOURCE_COLUMN_NAME","PK","TRANSFORM_TYPE","TRANSFORM_EXPRESSION","TRANSFORM_ORDER","CREATE_TIME","LAST_UPDATE_BY","LAST_UPDATE_TIME","DESCRIPTION") SELECT "TRANSFORM_ID","INCLUDE_ON","TARGET_COLUMN_NAME","SOURCE_COLUMN_NAME","PK","TRANSFORM_TYPE","TRANSFORM_EXPRESSION","TRANSFORM_ORDER","CREATE_TIME","LAST_UPDATE_BY","LAST_UPDATE_TIME","DESCRIPTION" FROM "KRKHBNM3"."SYM_TRANSFORM_COLUMN_"
2022-01-17 18:57:09,675 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: DROP TABLE "KRKHBNM3"."SYM_TRANSFORM_COLUMN_"
2022-01-17 18:57:09,676 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL failed: DROP TABLE "KRKHBNM3"."SYM_TRIGGER_"
2022-01-17 18:57:09,684 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: CREATE TABLE "KRKHBNM3"."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" CLOB,
"SYNC_ON_INSERT_CONDITION" CLOB,
"SYNC_ON_DELETE_CONDITION" CLOB,
"CUSTOM_BEFORE_UPDATE_TEXT" CLOB,
"CUSTOM_BEFORE_INSERT_TEXT" CLOB,
"CUSTOM_BEFORE_DELETE_TEXT" CLOB,
"CUSTOM_ON_UPDATE_TEXT" CLOB,
"CUSTOM_ON_INSERT_TEXT" CLOB,
"CUSTOM_ON_DELETE_TEXT" CLOB,
"EXTERNAL_SELECT" CLOB,
"TX_ID_EXPRESSION" CLOB,
"CHANNEL_EXPRESSION" CLOB,
"EXCLUDED_COLUMN_NAMES" CLOB,
"INCLUDED_COLUMN_NAMES" CLOB,
"SYNC_KEY_NAMES" CLOB,
"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" CLOB,
PRIMARY KEY ("TRIGGER_ID")
)
2022-01-17 18:57:09,691 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: INSERT INTO "KRKHBNM3"."SYM_TRIGGER_" ("TRIGGER_ID","SOURCE_CATALOG_NAME","SOURCE_SCHEMA_NAME","SOURCE_TABLE_NAME","CHANNEL_ID","RELOAD_CHANNEL_ID","SYNC_ON_UPDATE","SYNC_ON_INSERT","SYNC_ON_DELETE","SYNC_ON_INCOMING_BATCH","NAME_FOR_UPDATE_TRIGGER","NAME_FOR_INSERT_TRIGGER","NAME_FOR_DELETE_TRIGGER","SYNC_ON_UPDATE_CONDITION","SYNC_ON_INSERT_CONDITION","SYNC_ON_DELETE_CONDITION","CUSTOM_BEFORE_UPDATE_TEXT","CUSTOM_BEFORE_INSERT_TEXT","CUSTOM_BEFORE_DELETE_TEXT","CUSTOM_ON_UPDATE_TEXT","CUSTOM_ON_INSERT_TEXT","CUSTOM_ON_DELETE_TEXT","EXTERNAL_SELECT","TX_ID_EXPRESSION","CHANNEL_EXPRESSION","EXCLUDED_COLUMN_NAMES","INCLUDED_COLUMN_NAMES","SYNC_KEY_NAMES","USE_STREAM_LOBS","USE_CAPTURE_LOBS","USE_CAPTURE_OLD_DATA","USE_HANDLE_KEY_UPDATES","STREAM_ROW","CREATE_TIME","LAST_UPDATE_BY","LAST_UPDATE_TIME","DESCRIPTION") SELECT "TRIGGER_ID","SOURCE_CATALOG_NAME","SOURCE_SCHEMA_NAME","SOURCE_TABLE_NAME","CHANNEL_ID","RELOAD_CHANNEL_ID","SYNC_ON_UPDATE","SYNC_ON_INSERT","SYNC_ON_DELETE","SYNC_ON_INCOMING_BATCH","NAME_FOR_UPDATE_TRIGGER","NAME_FOR_INSERT_TRIGGER","NAME_FOR_DELETE_TRIGGER","SYNC_ON_UPDATE_CONDITION","SYNC_ON_INSERT_CONDITION","SYNC_ON_DELETE_CONDITION","CUSTOM_BEFORE_UPDATE_TEXT","CUSTOM_BEFORE_INSERT_TEXT","CUSTOM_BEFORE_DELETE_TEXT","CUSTOM_ON_UPDATE_TEXT","CUSTOM_ON_INSERT_TEXT","CUSTOM_ON_DELETE_TEXT","EXTERNAL_SELECT","TX_ID_EXPRESSION","CHANNEL_EXPRESSION","EXCLUDED_COLUMN_NAMES","INCLUDED_COLUMN_NAMES","SYNC_KEY_NAMES","USE_STREAM_LOBS","USE_CAPTURE_LOBS","USE_CAPTURE_OLD_DATA","USE_HANDLE_KEY_UPDATES","STREAM_ROW","CREATE_TIME","LAST_UPDATE_BY","LAST_UPDATE_TIME","DESCRIPTION" FROM "KRKHBNM3"."SYM_TRIGGER"
2022-01-17 18:57:09,698 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: DROP TABLE "KRKHBNM3"."SYM_TRIGGER"
2022-01-17 18:57:09,707 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] 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" CLOB,
"SYNC_ON_INSERT_CONDITION" CLOB,
"SYNC_ON_DELETE_CONDITION" CLOB,
"CUSTOM_BEFORE_UPDATE_TEXT" CLOB,
"CUSTOM_BEFORE_INSERT_TEXT" CLOB,
"CUSTOM_BEFORE_DELETE_TEXT" CLOB,
"CUSTOM_ON_UPDATE_TEXT" CLOB,
"CUSTOM_ON_INSERT_TEXT" CLOB,
"CUSTOM_ON_DELETE_TEXT" CLOB,
"EXTERNAL_SELECT" CLOB,
"TX_ID_EXPRESSION" CLOB,
"CHANNEL_EXPRESSION" CLOB,
"EXCLUDED_COLUMN_NAMES" CLOB,
"INCLUDED_COLUMN_NAMES" CLOB,
"SYNC_KEY_NAMES" CLOB,
"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" CLOB,
PRIMARY KEY ("TRIGGER_ID")
)
2022-01-17 18:57:09,710 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: INSERT INTO "SYM_TRIGGER" ("TRIGGER_ID","SOURCE_CATALOG_NAME","SOURCE_SCHEMA_NAME","SOURCE_TABLE_NAME","CHANNEL_ID","RELOAD_CHANNEL_ID","SYNC_ON_UPDATE","SYNC_ON_INSERT","SYNC_ON_DELETE","SYNC_ON_INCOMING_BATCH","NAME_FOR_UPDATE_TRIGGER","NAME_FOR_INSERT_TRIGGER","NAME_FOR_DELETE_TRIGGER","SYNC_ON_UPDATE_CONDITION","SYNC_ON_INSERT_CONDITION","SYNC_ON_DELETE_CONDITION","CUSTOM_BEFORE_UPDATE_TEXT","CUSTOM_BEFORE_INSERT_TEXT","CUSTOM_BEFORE_DELETE_TEXT","CUSTOM_ON_UPDATE_TEXT","CUSTOM_ON_INSERT_TEXT","CUSTOM_ON_DELETE_TEXT","EXTERNAL_SELECT","TX_ID_EXPRESSION","CHANNEL_EXPRESSION","EXCLUDED_COLUMN_NAMES","INCLUDED_COLUMN_NAMES","SYNC_KEY_NAMES","USE_STREAM_LOBS","USE_CAPTURE_LOBS","USE_CAPTURE_OLD_DATA","USE_HANDLE_KEY_UPDATES","STREAM_ROW","CREATE_TIME","LAST_UPDATE_BY","LAST_UPDATE_TIME","DESCRIPTION") SELECT "TRIGGER_ID","SOURCE_CATALOG_NAME","SOURCE_SCHEMA_NAME","SOURCE_TABLE_NAME","CHANNEL_ID","RELOAD_CHANNEL_ID","SYNC_ON_UPDATE","SYNC_ON_INSERT","SYNC_ON_DELETE","SYNC_ON_INCOMING_BATCH","NAME_FOR_UPDATE_TRIGGER","NAME_FOR_INSERT_TRIGGER","NAME_FOR_DELETE_TRIGGER","SYNC_ON_UPDATE_CONDITION","SYNC_ON_INSERT_CONDITION","SYNC_ON_DELETE_CONDITION","CUSTOM_BEFORE_UPDATE_TEXT","CUSTOM_BEFORE_INSERT_TEXT","CUSTOM_BEFORE_DELETE_TEXT","CUSTOM_ON_UPDATE_TEXT","CUSTOM_ON_INSERT_TEXT","CUSTOM_ON_DELETE_TEXT","EXTERNAL_SELECT","TX_ID_EXPRESSION","CHANNEL_EXPRESSION","EXCLUDED_COLUMN_NAMES","INCLUDED_COLUMN_NAMES","SYNC_KEY_NAMES","USE_STREAM_LOBS","USE_CAPTURE_LOBS","USE_CAPTURE_OLD_DATA","USE_HANDLE_KEY_UPDATES","STREAM_ROW","CREATE_TIME","LAST_UPDATE_BY","LAST_UPDATE_TIME","DESCRIPTION" FROM "KRKHBNM3"."SYM_TRIGGER_"
2022-01-17 18:57:09,716 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: DROP TABLE "KRKHBNM3"."SYM_TRIGGER_"
2022-01-17 18:57:09,717 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL failed: DROP TABLE "KRKHBNM3"."SYM_TRIGGER_HIST_"
2022-01-17 18:57:09,723 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: CREATE TABLE "KRKHBNM3"."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" CLOB NOT NULL,
"PK_COLUMN_NAMES" CLOB NOT NULL,
"LAST_TRIGGER_BUILD_REASON" CHAR(1) NOT NULL,
"ERROR_MESSAGE" CLOB,
"CREATE_TIME" TIMESTAMP NOT NULL,
"INACTIVE_TIME" TIMESTAMP,
PRIMARY KEY ("TRIGGER_HIST_ID")
)
2022-01-17 18:57:09,732 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: INSERT INTO "KRKHBNM3"."SYM_TRIGGER_HIST_" ("TRIGGER_HIST_ID","TRIGGER_ID","SOURCE_TABLE_NAME","SOURCE_CATALOG_NAME","SOURCE_SCHEMA_NAME","NAME_FOR_UPDATE_TRIGGER","NAME_FOR_INSERT_TRIGGER","NAME_FOR_DELETE_TRIGGER","TABLE_HASH","TRIGGER_ROW_HASH","TRIGGER_TEMPLATE_HASH","COLUMN_NAMES","PK_COLUMN_NAMES","LAST_TRIGGER_BUILD_REASON","ERROR_MESSAGE","CREATE_TIME","INACTIVE_TIME") SELECT "TRIGGER_HIST_ID","TRIGGER_ID","SOURCE_TABLE_NAME","SOURCE_CATALOG_NAME","SOURCE_SCHEMA_NAME","NAME_FOR_UPDATE_TRIGGER","NAME_FOR_INSERT_TRIGGER","NAME_FOR_DELETE_TRIGGER","TABLE_HASH","TRIGGER_ROW_HASH","TRIGGER_TEMPLATE_HASH","COLUMN_NAMES","PK_COLUMN_NAMES","LAST_TRIGGER_BUILD_REASON","ERROR_MESSAGE","CREATE_TIME","INACTIVE_TIME" FROM "KRKHBNM3"."SYM_TRIGGER_HIST"
2022-01-17 18:57:09,738 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: DROP TABLE "KRKHBNM3"."SYM_TRIGGER_HIST"
2022-01-17 18:57:09,746 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] 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" CLOB NOT NULL,
"PK_COLUMN_NAMES" CLOB NOT NULL,
"LAST_TRIGGER_BUILD_REASON" CHAR(1) NOT NULL,
"ERROR_MESSAGE" CLOB,
"CREATE_TIME" TIMESTAMP NOT NULL,
"INACTIVE_TIME" TIMESTAMP,
PRIMARY KEY ("TRIGGER_HIST_ID")
)
2022-01-17 18:57:09,751 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: CREATE INDEX "SYM_IDX_TRIGG_HIST_1" ON "SYM_TRIGGER_HIST" ("TRIGGER_ID", "INACTIVE_TIME")
2022-01-17 18:57:09,753 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: INSERT INTO "SYM_TRIGGER_HIST" ("TRIGGER_HIST_ID","TRIGGER_ID","SOURCE_TABLE_NAME","SOURCE_CATALOG_NAME","SOURCE_SCHEMA_NAME","NAME_FOR_UPDATE_TRIGGER","NAME_FOR_INSERT_TRIGGER","NAME_FOR_DELETE_TRIGGER","TABLE_HASH","TRIGGER_ROW_HASH","TRIGGER_TEMPLATE_HASH","COLUMN_NAMES","PK_COLUMN_NAMES","LAST_TRIGGER_BUILD_REASON","ERROR_MESSAGE","CREATE_TIME","INACTIVE_TIME") SELECT "TRIGGER_HIST_ID","TRIGGER_ID","SOURCE_TABLE_NAME","SOURCE_CATALOG_NAME","SOURCE_SCHEMA_NAME","NAME_FOR_UPDATE_TRIGGER","NAME_FOR_INSERT_TRIGGER","NAME_FOR_DELETE_TRIGGER","TABLE_HASH","TRIGGER_ROW_HASH","TRIGGER_TEMPLATE_HASH","COLUMN_NAMES","PK_COLUMN_NAMES","LAST_TRIGGER_BUILD_REASON","ERROR_MESSAGE","CREATE_TIME","INACTIVE_TIME" FROM "KRKHBNM3"."SYM_TRIGGER_HIST_"
2022-01-17 18:57:09,757 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: DROP TABLE "KRKHBNM3"."SYM_TRIGGER_HIST_"
2022-01-17 18:57:09,758 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL failed: DROP TABLE "KRKHBNM3"."SYM_TRIGGER_ROUTER_"
2022-01-17 18:57:09,765 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: CREATE TABLE "KRKHBNM3"."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" CLOB,
"INITIAL_LOAD_DELETE_STMT" CLOB,
"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" CLOB,
PRIMARY KEY ("TRIGGER_ID", "ROUTER_ID")
)
2022-01-17 18:57:09,770 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: INSERT INTO "KRKHBNM3"."SYM_TRIGGER_ROUTER_" ("TRIGGER_ID","ROUTER_ID","ENABLED","INITIAL_LOAD_ORDER","INITIAL_LOAD_SELECT","INITIAL_LOAD_DELETE_STMT","PING_BACK_ENABLED","CREATE_TIME","LAST_UPDATE_BY","LAST_UPDATE_TIME","DESCRIPTION") SELECT "TRIGGER_ID","ROUTER_ID","ENABLED","INITIAL_LOAD_ORDER","INITIAL_LOAD_SELECT","INITIAL_LOAD_DELETE_STMT","PING_BACK_ENABLED","CREATE_TIME","LAST_UPDATE_BY","LAST_UPDATE_TIME","DESCRIPTION" FROM "KRKHBNM3"."SYM_TRIGGER_ROUTER"
2022-01-17 18:57:09,774 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: DROP TABLE "KRKHBNM3"."SYM_TRIGGER_ROUTER"
2022-01-17 18:57:09,782 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] 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" CLOB,
"INITIAL_LOAD_DELETE_STMT" CLOB,
"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" CLOB,
PRIMARY KEY ("TRIGGER_ID", "ROUTER_ID")
)
2022-01-17 18:57:09,784 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: INSERT INTO "SYM_TRIGGER_ROUTER" ("TRIGGER_ID","ROUTER_ID","ENABLED","INITIAL_LOAD_ORDER","INITIAL_LOAD_SELECT","INITIAL_LOAD_DELETE_STMT","PING_BACK_ENABLED","CREATE_TIME","LAST_UPDATE_BY","LAST_UPDATE_TIME","DESCRIPTION") SELECT "TRIGGER_ID","ROUTER_ID","ENABLED","INITIAL_LOAD_ORDER","INITIAL_LOAD_SELECT","INITIAL_LOAD_DELETE_STMT","PING_BACK_ENABLED","CREATE_TIME","LAST_UPDATE_BY","LAST_UPDATE_TIME","DESCRIPTION" FROM "KRKHBNM3"."SYM_TRIGGER_ROUTER_"
2022-01-17 18:57:09,788 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: DROP TABLE "KRKHBNM3"."SYM_TRIGGER_ROUTER_"
2022-01-17 18:57:09,806 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] 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")
2022-01-17 18:57:09,813 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] 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")
2022-01-17 18:57:09,829 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: ALTER TABLE "SYM_FILE_TRIGGER_ROUTER"
ADD CONSTRAINT "SYM_FK_FTR_2_RTR" FOREIGN KEY ("ROUTER_ID") REFERENCES "SYM_ROUTER" ("ROUTER_ID")
2022-01-17 18:57:09,833 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] 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")
2022-01-17 18:57:09,838 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] 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")
2022-01-17 18:57:09,842 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: ALTER TABLE "SYM_TRIGGER"
ADD CONSTRAINT "SYM_FK_TRG_2_CHNL" FOREIGN KEY ("CHANNEL_ID") REFERENCES "SYM_CHANNEL" ("CHANNEL_ID")
2022-01-17 18:57:09,846 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: ALTER TABLE "SYM_TRIGGER"
ADD CONSTRAINT "SYM_FK_TRG_2_RLD_CHNL" FOREIGN KEY ("RELOAD_CHANNEL_ID") REFERENCES "SYM_CHANNEL" ("CHANNEL_ID")
2022-01-17 18:57:09,855 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: ALTER TABLE "SYM_TRIGGER_ROUTER"
ADD CONSTRAINT "SYM_FK_TR_2_TRG" FOREIGN KEY ("TRIGGER_ID") REFERENCES "SYM_TRIGGER" ("TRIGGER_ID")
2022-01-17 18:57:09,859 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] DDL applied: ALTER TABLE "SYM_TRIGGER_ROUTER"
ADD CONSTRAINT "SYM_FK_TR_2_RTR" FOREIGN KEY ("ROUTER_ID") REFERENCES "SYM_ROUTER" ("ROUTER_ID")
2022-01-17 18:57:09,866 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] 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")
2022-01-17 18:57:09,867 INFO (sync.starter) [org.jumpmind.symmetric.service.impl.ClusterService] This node picked a server id of MALACHOR
2022-01-17 18:57:09,867 INFO (sync.starter) [org.jumpmind.symmetric.service.impl.TriggerRouterService] Synchronizing triggers
2022-01-17 18:57:09,911 INFO (sync.starter) [org.jumpmind.symmetric.service.impl.TriggerRouterService] Done synchronizing triggers
2022-01-17 18:57:09,911 INFO (sync.starter) [org.jumpmind.symmetric.db.derby.DerbySymmetricDialect] Done with auto update of SymmetricDS tables
2022-01-17 18:57:09,912 INFO (sync.starter) [org.jumpmind.symmetric.service.impl.ConfigurationService] Auto-configuring config channel
2022-01-17 18:57:09,936 INFO (sync.starter) [org.jumpmind.symmetric.service.impl.ConfigurationService] Auto-configuring reload channel
2022-01-17 18:57:09,937 INFO (sync.starter) [org.jumpmind.symmetric.service.impl.ConfigurationService] Auto-configuring monitor channel
2022-01-17 18:57:09,938 INFO (sync.starter) [org.jumpmind.symmetric.service.impl.ConfigurationService] Auto-configuring heartbeat channel
2022-01-17 18:57:09,939 INFO (sync.starter) [org.jumpmind.symmetric.service.impl.ConfigurationService] Auto-configuring default channel
2022-01-17 18:57:09,939 INFO (sync.starter) [org.jumpmind.symmetric.service.impl.ConfigurationService] Auto-configuring dynamic channel
2022-01-17 18:57:10,202 INFO (sync.starter) [org.jumpmind.symmetric.service.impl.ExtensionService] Found 0 extension points from the database that will be registered
2022-01-17 18:57:10,203 INFO (sync.starter) [org.jumpmind.symmetric.service.impl.ClientExtensionService] Found 7 extension points from spring that will be registered
2022-01-17 18:57:10,203 INFO (sync.starter) [org.jumpmind.symmetric.AbstractSymmetricEngine] Done initializing SymmetricDS database
2022-01-17 18:57:10,204 INFO (sync.starter) [org.jumpmind.symmetric.AbstractSymmetricEngine] SymmetricDS database version : null
2022-01-17 18:57:10,204 INFO (sync.starter) [org.jumpmind.symmetric.AbstractSymmetricEngine] SymmetricDS software version : 3.12.14
2022-01-17 18:57:10,204 INFO (sync.starter) [za.drt.dbservice.sync.ClientSync] [KRKHBNM3] done sync init;
2022-01-17 18:57:10,214 INFO (sync.starter) [org.jumpmind.symmetric.AbstractSymmetricEngine] Starting unregistered node [group=KRKHBNM3, externalId=KRKHBNM3.00-23-18-B3-95-FB.04]
2022-01-17 18:57:10,230 INFO (sync.starter) [org.jumpmind.symmetric.job.RouterJob] Starting Routing on periodic schedule: every 30000ms with the first run at 2022-01-17T18:57:11.308+0200
2022-01-17 18:57:10,235 INFO (sync.starter) [org.jumpmind.symmetric.job.PushJob] Starting Push on periodic schedule: every 60000ms with the first run at 2022-01-17T18:57:11.313+0200
2022-01-17 18:57:10,236 INFO (sync.starter) [org.jumpmind.symmetric.job.PullJob] Starting Pull on periodic schedule: every 60000ms with the first run at 2022-01-17T18:57:11.314+0200
2022-01-17 18:57:10,236 INFO (sync.starter) [org.jumpmind.symmetric.job.JobManager] Job Offline Push not configured for auto start
2022-01-17 18:57:10,236 INFO (sync.starter) [org.jumpmind.symmetric.job.JobManager] Job Offline Pull not configured for auto start
2022-01-17 18:57:10,239 INFO (sync.starter) [org.jumpmind.symmetric.job.OutgoingPurgeJob] Starting job 'Purge Outgoing' with cron expression: '0 0 */4 * * *'
2022-01-17 18:57:10,240 INFO (sync.starter) [org.jumpmind.symmetric.job.IncomingPurgeJob] Starting job 'Purge Incoming' with cron expression: '0 0 */4 * * *'
2022-01-17 18:57:10,240 INFO (sync.starter) [org.jumpmind.symmetric.job.StatisticFlushJob] Starting job 'Stat Flush' with cron expression: '0 0/5 * * * *'
2022-01-17 18:57:10,240 INFO (sync.starter) [org.jumpmind.symmetric.job.SyncTriggersJob] Starting job 'SyncTriggers' with cron expression: '0 0 0 * * *'
2022-01-17 18:57:10,240 INFO (sync.starter) [org.jumpmind.symmetric.job.HeartbeatJob] Starting Heartbeat on periodic schedule: every 900000ms with the first run at 2022-01-17T18:57:11.318+0200
2022-01-17 18:57:10,240 INFO (sync.starter) [org.jumpmind.symmetric.job.WatchdogJob] Starting Watchdog on periodic schedule: every 3600000ms with the first run at 2022-01-17T18:57:11.318+0200
2022-01-17 18:57:10,241 INFO (sync.starter) [org.jumpmind.symmetric.job.StageManagementJob] Starting job 'Stage Management' with cron expression: '0 0 * * * *'
2022-01-17 18:57:10,241 INFO (sync.starter) [org.jumpmind.symmetric.job.JobManager] Job Refresh Cache not configured for auto start
2022-01-17 18:57:10,241 INFO (sync.starter) [org.jumpmind.symmetric.job.JobManager] Job File Sync Tracker not configured for auto start
2022-01-17 18:57:10,241 INFO (sync.starter) [org.jumpmind.symmetric.job.JobManager] Job File Sync Pull not configured for auto start
2022-01-17 18:57:10,241 INFO (sync.starter) [org.jumpmind.symmetric.job.JobManager] Job File Sync Push not configured for auto start
2022-01-17 18:57:10,241 INFO (sync.starter) [org.jumpmind.symmetric.job.InitialLoadExtractorJob] Starting Initial Load Extract on periodic schedule: every 10000ms with the first run at 2022-01-17T18:57:11.319+0200
2022-01-17 18:57:10,241 INFO (sync.starter) [org.jumpmind.symmetric.job.MonitorJob] Starting Monitor on periodic schedule: every 60000ms with the first run at 2022-01-17T18:57:11.319+0200
2022-01-17 18:57:10,241 INFO (sync.starter) [org.jumpmind.symmetric.job.JobManager] Job Report Status not configured for auto start
2022-01-17 18:57:10,241 INFO (sync.starter) [org.jumpmind.symmetric.job.JobManager] Job Log Miner not configured for auto start
2022-01-17 18:57:10,241 INFO (sync.starter) [org.jumpmind.symmetric.job.InitialLoadJob] Starting Initial Load Queue on periodic schedule: every 10000ms with the first run at 2022-01-17T18:57:11.319+0200
2022-01-17 18:57:10,243 INFO (sync.starter) [org.jumpmind.symmetric.AbstractSymmetricEngine] SymmetricDS Node STARTED:
nodeId=KRKHBNM3.00-23-18-B3-95-FB.04
groupId=KRKHBNM3
type=client
subType=null
name=KRKHBNM3
softwareVersion=3.12.14
databaseName=Apache Derby
databaseVersion=10.14
driverName=Apache Derby Network Client JDBC Driver
driverVersion=10.14.2.0 - (1828579)
uptime=0 sec.
2022-01-17 18:57:10,243 INFO (sync.starter) [za.drt.dbservice.sync.ClientSync] [KRKHBNM3] done sync start;
2022-01-17 18:57:10,243 INFO (sync.starter) [za.drt.dbservice.sync.ClientSync] [KRKHBNM3] prep sync load;
2022-01-17 18:57:11,313 INFO (KRKHBNM3-job-2) [org.jumpmind.symmetric.job.PushJob] Did not run the 'Push' job because the engine is not registered.
2022-01-17 18:57:11,315 INFO (KRKHBNM3-job-1) [org.jumpmind.symmetric.job.RouterJob] Did not run the 'Routing' job because the engine is not registered.
2022-01-17 18:57:11,320 INFO (KRKHBNM3-job-2) [org.jumpmind.symmetric.job.InitialLoadExtractorJob] Did not run the 'Initial Load Extract' job because the engine is not registered.
2022-01-17 18:57:11,320 INFO (KRKHBNM3-job-3) [org.jumpmind.symmetric.service.impl.RegistrationService] This node is unregistered. It will attempt to register using the registration.url
2022-01-17 18:57:11,321 INFO (KRKHBNM3-job-4) [org.jumpmind.symmetric.job.MonitorJob] Did not run the 'Monitor' job because the engine is not registered.
2022-01-17 18:57:11,321 INFO (KRKHBNM3-job-5) [org.jumpmind.symmetric.job.InitialLoadJob] Did not run the 'Initial Load Queue' job because the engine is not registered.
2022-01-17 18:57:11,480 INFO (KRKHBNM3-job-3) [org.jumpmind.symmetric.service.impl.DataLoaderService] Using registration URL of https://sym.za.ambium.net/sync/home/registration
2022-01-17 18:57:11,642 WARN (KRKHBNM3-job-3) [org.jumpmind.symmetric.service.impl.RegistrationService] Waiting for registration to be accepted by the server. Registration is not open.
2022-01-17 18:57:11,643 INFO (KRKHBNM3-job-3) [org.jumpmind.symmetric.service.impl.RegistrationService] Could not register. Sleeping for 18000ms before attempting again.
|
|
SymmetricDS: 3.12 1a3173ec 2022-02-18 18:55:03 evan-miller-jumpmind Details Diff |
0005196: Fixed Derby tables needing altered on every startup |
Affected Issues 0005196 |
|
| mod - symmetric-db/src/main/java/org/jumpmind/db/platform/derby/DerbyDdlBuilder.java | Diff File | ||
|
SymmetricDS: 3.13 455c26cf 2022-02-18 20:01:06 evan-miller-jumpmind Details Diff |
0005196: Fixed Derby tables needing altered on every startup |
Affected Issues 0005196 |
|
| mod - symmetric-db/src/main/java/org/jumpmind/db/platform/derby/DerbyDdlBuilder.java | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2022-01-17 18:07 | richard@squarepeg.co.za | New Issue | |
| 2022-01-17 18:07 | richard@squarepeg.co.za | File Added: sync.log | |
| 2022-01-19 18:55 | pmarzullo | Relationship added | related to 0005072 |
| 2022-02-18 18:56 | emiller | Assigned To | => emiller |
| 2022-02-18 18:56 | emiller | Status | new => resolved |
| 2022-02-18 18:56 | emiller | Resolution | open => fixed |
| 2022-02-18 18:56 | emiller | Fixed in Version | => 3.12.16 |
| 2022-02-18 19:00 | Changeset attached | => SymmetricDS 3.12 1a3173ec | |
| 2022-02-18 21:00 | Changeset attached | => SymmetricDS 3.13 455c26cf | |
| 2022-02-23 15:27 | elong | Summary | "There are SymmetricDS tables that needed altered" on every start-up => "There are SymmetricDS tables that needed altered" on every start-up on Derby |
| 2022-04-11 19:50 | elong | Status | resolved => closed |
| 2022-04-11 19:50 | elong | Target Version | => 3.12.16 |