View Issue Details

Related ChangesetsJump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0003362SymmetricDSBugpublic2018-01-11 12:352019-11-15 13:23
Reportergilles.riand Assigned Topmarzullo  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.9.2 
Target Version3.10.6Fixed in Version3.10.6 
Summary0003362: SYM tables (sym_trigger, etc) won't create on Interbase bec they exceed 64KB max row size
DescriptionImpossible to Install SymmetricDS
Steps To ReproduceJust try to install SymmetricDS with InterbaseXE (x32) edition with Last Patch 5
Additional Informationin the Log File
(...)
2018-01-11 13:24:49,699 WARN [server] [InterbaseSymmetricDialect] [background-refresher-1] DDL failed: 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" VARCHAR(4096),
    "SYNC_ON_INSERT_CONDITION" VARCHAR(4096),
    "SYNC_ON_DELETE_CONDITION" VARCHAR(4096),
    "CUSTOM_BEFORE_UPDATE_TEXT" VARCHAR(4096),
    "CUSTOM_BEFORE_INSERT_TEXT" VARCHAR(4096),
    "CUSTOM_BEFORE_DELETE_TEXT" VARCHAR(4096),
    "CUSTOM_ON_UPDATE_TEXT" VARCHAR(4096),
    "CUSTOM_ON_INSERT_TEXT" VARCHAR(4096),
    "CUSTOM_ON_DELETE_TEXT" VARCHAR(4096),
    "EXTERNAL_SELECT" VARCHAR(4096),
    "TX_ID_EXPRESSION" VARCHAR(4096),
    "CHANNEL_EXPRESSION" VARCHAR(4096),
    "EXCLUDED_COLUMN_NAMES" VARCHAR(4096),
    "INCLUDED_COLUMN_NAMES" VARCHAR(4096),
    "SYNC_KEY_NAMES" VARCHAR(4096),
    "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" VARCHAR(4096),
    PRIMARY KEY ("TRIGGER_ID")
)
2018-01-11 13:24:49,700 WARN [server] [JdbcSqlTemplate] [background-refresher-1] interbase.interclient.IBException: [interclient][interbase]unsuccessful metadata update
[interclient][interbase]new record size of 67602 bytes is too big
[interclient][interbase]TABLE SYM_TRIGGER. Failed to execute: 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" VARCHAR(4096),
    "SYNC_ON_INSERT_CONDITION" VARCHAR(4096),
    "SYNC_ON_DELETE_CONDITION" VARCHAR(4096),
    "CUSTOM_BEFORE_UPDATE_TEXT" VARCHAR(4096),
    "CUSTOM_BEFORE_INSERT_TEXT" VARCHAR(4096),
    "CUSTOM_BEFORE_DELETE_TEXT" VARCHAR(4096),
    "CUSTOM_ON_UPDATE_TEXT" VARCHAR(4096),
    "CUSTOM_ON_INSERT_TEXT" VARCHAR(4096),
    "CUSTOM_ON_DELETE_TEXT" VARCHAR(4096),
    "EXTERNAL_SELECT" VARCHAR(4096),
    "TX_ID_EXPRESSION" VARCHAR(4096),
    "CHANNEL_EXPRESSION" VARCHAR(4096),
    "EXCLUDED_COLUMN_NAMES" VARCHAR(4096),
    "INCLUDED_COLUMN_NAMES" VARCHAR(4096),
    "SYNC_KEY_NAMES" VARCHAR(4096),
    "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" VARCHAR(4096),
    PRIMARY KEY ("TRIGGER_ID")
)
2018-01-11 13:24:49,701 ERROR [server] [AbstractSymmetricEngine] [background-refresher-1] An error occurred while starting SymmetricDS StackTraceKey.init [SqlException:4262246999]
org.jumpmind.db.sql.SqlException: interbase.interclient.IBException: [interclient][interbase]unsuccessful metadata update
[interclient][interbase]new record size of 67602 bytes is too big
[interclient][interbase]TABLE SYM_TRIGGER
    at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:300)
    at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:291)
    at org.jumpmind.db.sql.JdbcSqlTemplate.execute(JdbcSqlTemplate.java:493)
    at org.jumpmind.db.sql.JdbcSqlTemplate.update(JdbcSqlTemplate.java:401)
Tagsdialect: interbase, install

Relationships

has duplicate 0003832 new SYM tables (sym_trigger, etc) won't create on Interbase bec they exceed 64KB max row size 

Activities

gilles.riand

2018-01-11 12:36

reporter   ~0001103

2018-01-11 13:24:09,793 INFO [gui] [JdbcDatabasePlatformFactory] [qtp323326911-17] Detected database 'InterBase', version '10', protocol 'interbase'
2018-01-11 13:24:09,810 INFO [gui] [JdbcDatabasePlatformFactory] [qtp323326911-17] The IDatabasePlatform being used is org.jumpmind.db.platform.interbase.InterbaseDatabasePlatform
2018-01-11 13:24:09,833 INFO [gui] [InterbaseSymmetricDialect] [qtp323326911-17] The DbDialect being used is org.jumpmind.symmetric.db.interbase.InterbaseSymmetricDialect
2018-01-11 13:24:15,853 INFO [SymmetricDS] [AbstractSymmetricEngine] [qtp323326911-18] Initializing connection to database
2018-01-11 13:24:15,871 INFO [SymmetricDS] [JdbcDatabasePlatformFactory] [qtp323326911-18] Detected database 'InterBase', version '10', protocol 'interbase'
2018-01-11 13:24:15,872 INFO [SymmetricDS] [JdbcDatabasePlatformFactory] [qtp323326911-18] The IDatabasePlatform being used is org.jumpmind.db.platform.interbase.InterbaseDatabasePlatform
2018-01-11 13:24:15,887 INFO [SymmetricDS] [InterbaseSymmetricDialect] [qtp323326911-18] The DbDialect being used is org.jumpmind.symmetric.db.interbase.InterbaseSymmetricDialect
2018-01-11 13:24:15,914 INFO [SymmetricDS] [StagingManager] [qtp323326911-18] The staging directory was initialized at the following location: tmp\SymmetricDS
2018-01-11 13:24:15,944 INFO [SymmetricDS] [ClusterService] [qtp323326911-18] This node picked a server id of RIAND
2018-01-11 13:24:15,981 INFO [SymmetricDS] [NodeService] [qtp323326911-18] Failed to load the node identity because: org.jumpmind.db.sql.SqlException Failed to execute sql: select c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.config_version from sym_node c inner join sym_node_identity i on c.node_id = i.node_id . Returning null
2018-01-11 13:24:16,318 INFO [SymmetricDS] [ClientExtensionService] [qtp323326911-18] Found 12 extension points from spring that will be registered
2018-01-11 13:24:48,317 INFO [server] [AbstractSymmetricEngine] [background-refresher-1] Initializing connection to database
2018-01-11 13:24:48,444 INFO [server] [JdbcDatabasePlatformFactory] [background-refresher-1] Detected database 'InterBase', version '10', protocol 'interbase'
2018-01-11 13:24:48,444 INFO [server] [JdbcDatabasePlatformFactory] [background-refresher-1] The IDatabasePlatform being used is org.jumpmind.db.platform.interbase.InterbaseDatabasePlatform
2018-01-11 13:24:48,457 INFO [server] [InterbaseSymmetricDialect] [background-refresher-1] The DbDialect being used is org.jumpmind.symmetric.db.interbase.InterbaseSymmetricDialect
2018-01-11 13:24:48,472 INFO [server] [StagingManager] [background-refresher-1] The staging directory was initialized at the following location: tmp\server
2018-01-11 13:24:48,475 INFO [server] [ClusterService] [background-refresher-1] This node picked a server id of RIAND
2018-01-11 13:24:48,477 INFO [server] [NodeService] [background-refresher-1] Failed to load the node identity because: org.jumpmind.db.sql.SqlException Failed to execute sql: select c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.config_version from sym_node c inner join sym_node_identity i on c.node_id = i.node_id . Returning null
2018-01-11 13:24:48,663 INFO [server] [ClientExtensionService] [background-refresher-1] Found 14 extension points from spring that will be registered
2018-01-11 13:24:48,675 INFO [server] [AbstractSymmetricEngine] [background-refresher-1] Initializing SymmetricDS database
2018-01-11 13:24:48,676 INFO [server] [InterbaseSymmetricDialect] [background-refresher-1] Checking if SymmetricDS tables need created or altered
2018-01-11 13:24:49,143 INFO [server] [InterbaseSymmetricDialect] [background-refresher-1] There are SymmetricDS tables that needed altered
2018-01-11 13:24:49,268 INFO [server] [InterbaseSymmetricDialect] [background-refresher-1] DDL applied: CREATE TABLE "SYM_CHANNEL"(
    "CHANNEL_ID" VARCHAR(128) NOT NULL,
    "PROCESSING_ORDER" INTEGER DEFAULT 1 NOT NULL,
    "MAX_BATCH_SIZE" INTEGER DEFAULT 1000 NOT NULL,
    "MAX_BATCH_TO_SEND" INTEGER DEFAULT 60 NOT NULL,
    "MAX_DATA_TO_ROUTE" INTEGER DEFAULT 100000 NOT NULL,
    "EXTRACT_PERIOD_MILLIS" INTEGER DEFAULT 0 NOT NULL,
    "ENABLED" 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")
)
2018-01-11 13:24:49,283 INFO [server] [InterbaseSymmetricDialect] [background-refresher-1] DDL applied: CREATE TABLE "SYM_CONFLICT"(
    "CONFLICT_ID" VARCHAR(50) NOT NULL,
    "SOURCE_NODE_GROUP_ID" VARCHAR(50) NOT NULL,
    "TARGET_NODE_GROUP_ID" VARCHAR(50) NOT NULL,
    "TARGET_CHANNEL_ID" VARCHAR(128),
    "TARGET_CATALOG_NAME" VARCHAR(255),
    "TARGET_SCHEMA_NAME" VARCHAR(255),
    "TARGET_TABLE_NAME" VARCHAR(255),
    "DETECT_TYPE" VARCHAR(128) NOT NULL,
    "DETECT_EXPRESSION" VARCHAR(4096),
    "RESOLVE_TYPE" VARCHAR(128) NOT NULL,
    "PING_BACK" VARCHAR(128) NOT NULL,
    "RESOLVE_CHANGES_ONLY" SMALLINT DEFAULT 0,
    "RESOLVE_ROW_ONLY" SMALLINT DEFAULT 0,
    "CREATE_TIME" TIMESTAMP NOT NULL,
    "LAST_UPDATE_BY" VARCHAR(50),
    "LAST_UPDATE_TIME" TIMESTAMP NOT NULL,
    PRIMARY KEY ("CONFLICT_ID")
)
2018-01-11 13:24:49,288 INFO [server] [InterbaseSymmetricDialect] [background-refresher-1] DDL applied: CREATE TABLE "SYM_CONTEXT"(
    "NAME" VARCHAR(80) NOT NULL,
    "CONTEXT_VALUE" VARCHAR(4096),
    "CREATE_TIME" TIMESTAMP,
    "LAST_UPDATE_TIME" TIMESTAMP,
    PRIMARY KEY ("NAME")
)
2018-01-11 13:24:49,300 INFO [server] [InterbaseSymmetricDialect] [background-refresher-1] DDL applied: CREATE TABLE "SYM_DATA"(
    "DATA_ID" NUMERIC(18,0) NOT NULL ,
    "TABLE_NAME" VARCHAR(255) NOT NULL,
    "EVENT_TYPE" CHAR(1) NOT NULL,
    "ROW_DATA" VARCHAR(4096),
    "PK_DATA" VARCHAR(4096),
    "OLD_DATA" VARCHAR(4096),
    "TRIGGER_HIST_ID" INTEGER NOT NULL,
    "CHANNEL_ID" VARCHAR(128),
    "TRANSACTION_ID" VARCHAR(255),
    "SOURCE_NODE_ID" VARCHAR(50),
    "EXTERNAL_DATA" VARCHAR(50),
    "NODE_LIST" VARCHAR(255),
    "CREATE_TIME" TIMESTAMP,
    PRIMARY KEY ("DATA_ID")
)
2018-01-11 13:24:49,310 INFO [server] [InterbaseSymmetricDialect] [background-refresher-1] DDL applied: CREATE INDEX "SYM_IDX_D_CHANNEL_ID" ON "SYM_DATA" ("DATA_ID", "CHANNEL_ID")
2018-01-11 13:24:49,310 INFO [server] [InterbaseSymmetricDialect] [background-refresher-1] DDL applied: CREATE GENERATOR "GEN_SYM_DATA_DATA_ID"
2018-01-11 13:24:49,319 INFO [server] [InterbaseSymmetricDialect] [background-refresher-1] DDL applied: CREATE TRIGGER "TRG_SYM_DATA_DATA_ID" FOR "SYM_DATA" ACTIVE BEFORE INSERT POSITION 0 AS
BEGIN IF (NEW."DATA_ID" IS NULL) THEN NEW."DATA_ID" = GEN_ID("GEN_SYM_DATA_DATA_ID", 1); END
2018-01-11 13:24:49,324 INFO [server] [InterbaseSymmetricDialect] [background-refresher-1] DDL applied: CREATE TABLE "SYM_DATA_EVENT"(
    "DATA_ID" NUMERIC(18,0) NOT NULL,
    "BATCH_ID" NUMERIC(18,0) NOT NULL,
    "ROUTER_ID" VARCHAR(50) NOT NULL,
    "CREATE_TIME" TIMESTAMP,
    PRIMARY KEY ("DATA_ID", "BATCH_ID", "ROUTER_ID")
)
2018-01-11 13:24:49,326 INFO [server] [InterbaseSymmetricDialect] [background-refresher-1] DDL applied: CREATE INDEX "SYM_IDX_DE_BATCHID" ON "SYM_DATA_EVENT" ("BATCH_ID")
2018-01-11 13:24:49,341 INFO [server] [InterbaseSymmetricDialect] [background-refresher-1] DDL applied: CREATE TABLE "SYM_DATA_GAP"(
    "START_ID" NUMERIC(18,0) NOT NULL,
    "END_ID" NUMERIC(18,0) NOT NULL,
    "STATUS" CHAR(2),
    "CREATE_TIME" TIMESTAMP NOT NULL,
    "LAST_UPDATE_HOSTNAME" VARCHAR(255),
    "LAST_UPDATE_TIME" TIMESTAMP NOT NULL,
    PRIMARY KEY ("START_ID", "END_ID")
)
2018-01-11 13:24:49,342 INFO [server] [InterbaseSymmetricDialect] [background-refresher-1] DDL applied: CREATE INDEX "SYM_IDX_DG_STATUS" ON "SYM_DATA_GAP" ("STATUS")
2018-01-11 13:24:49,357 INFO [server] [InterbaseSymmetricDialect] [background-refresher-1] DDL applied: CREATE TABLE "SYM_EXTENSION"(
    "EXTENSION_ID" VARCHAR(50) NOT NULL,
    "EXTENSION_TYPE" VARCHAR(10) NOT NULL,
    "INTERFACE_NAME" VARCHAR(255),
    "NODE_GROUP_ID" VARCHAR(50) NOT NULL,
    "ENABLED" SMALLINT DEFAULT 1 NOT NULL,
    "EXTENSION_ORDER" INTEGER DEFAULT 1 NOT NULL,
    "EXTENSION_TEXT" VARCHAR(4096),
    "CREATE_TIME" TIMESTAMP,
    "LAST_UPDATE_BY" VARCHAR(50),
    "LAST_UPDATE_TIME" TIMESTAMP,
    PRIMARY KEY ("EXTENSION_ID")
)
2018-01-11 13:24:49,364 INFO [server] [InterbaseSymmetricDialect] [background-refresher-1] DDL applied: CREATE TABLE "SYM_EXTRACT_REQUEST"(
    "REQUEST_ID" NUMERIC(18,0) NOT NULL,
    "NODE_ID" VARCHAR(50) NOT NULL,
    "QUEUE" VARCHAR(128),
    "STATUS" CHAR(2),
    "START_BATCH_ID" NUMERIC(18,0) NOT NULL,
    "END_BATCH_ID" NUMERIC(18,0) NOT NULL,
    "TRIGGER_ID" VARCHAR(128) NOT NULL,
    "ROUTER_ID" VARCHAR(50) NOT NULL,
    "LAST_UPDATE_TIME" TIMESTAMP,
    "CREATE_TIME" TIMESTAMP,
    PRIMARY KEY ("REQUEST_ID")
)
2018-01-11 13:24:49,370 INFO [server] [InterbaseSymmetricDialect] [background-refresher-1] DDL applied: CREATE TABLE "SYM_FILE_INCOMING"(
    "RELATIVE_DIR" VARCHAR(255) NOT NULL,
    "FILE_NAME" VARCHAR(128) NOT NULL,
    "LAST_EVENT_TYPE" CHAR(1) NOT NULL,
    "NODE_ID" VARCHAR(50) NOT NULL,
    "FILE_MODIFIED_TIME" NUMERIC(18,0),
    PRIMARY KEY ("RELATIVE_DIR", "FILE_NAME")
)
2018-01-11 13:24:49,378 INFO [server] [InterbaseSymmetricDialect] [background-refresher-1] DDL applied: CREATE TABLE "SYM_FILE_SNAPSHOT"(
    "TRIGGER_ID" VARCHAR(128) NOT NULL,
    "ROUTER_ID" VARCHAR(50) NOT NULL,
    "RELATIVE_DIR" VARCHAR(255) NOT NULL,
    "FILE_NAME" VARCHAR(128) NOT NULL,
    "CHANNEL_ID" VARCHAR(128) DEFAULT 'filesync' NOT NULL,
    "RELOAD_CHANNEL_ID" VARCHAR(128) DEFAULT 'filesync_reload' NOT NULL,
    "LAST_EVENT_TYPE" CHAR(1) NOT NULL,
    "CRC32_CHECKSUM" NUMERIC(18,0),
    "FILE_SIZE" NUMERIC(18,0),
    "FILE_MODIFIED_TIME" NUMERIC(18,0),
    "LAST_UPDATE_TIME" TIMESTAMP NOT NULL,
    "LAST_UPDATE_BY" VARCHAR(50),
    "CREATE_TIME" TIMESTAMP NOT NULL,
    PRIMARY KEY ("TRIGGER_ID", "ROUTER_ID", "RELATIVE_DIR", "FILE_NAME")
)
2018-01-11 13:24:49,380 INFO [server] [InterbaseSymmetricDialect] [background-refresher-1] DDL applied: CREATE INDEX "SYM_IDX_F_SNPSHT_CHID" ON "SYM_FILE_SNAPSHOT" ("RELOAD_CHANNEL_ID")
2018-01-11 13:24:49,395 INFO [server] [InterbaseSymmetricDialect] [background-refresher-1] DDL applied: CREATE TABLE "SYM_FILE_TRIGGER"(
    "TRIGGER_ID" VARCHAR(128) NOT NULL,
    "CHANNEL_ID" VARCHAR(128) DEFAULT 'filesync' NOT NULL,
    "RELOAD_CHANNEL_ID" VARCHAR(128) DEFAULT 'filesync_reload' NOT NULL,
    "BASE_DIR" VARCHAR(255) NOT NULL,
    "RECURSE" 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" VARCHAR(4096),
    "AFTER_COPY_SCRIPT" VARCHAR(4096),
    "CREATE_TIME" TIMESTAMP NOT NULL,
    "LAST_UPDATE_BY" VARCHAR(50),
    "LAST_UPDATE_TIME" TIMESTAMP NOT NULL,
    "DESCRIPTION" VARCHAR(4096),
    PRIMARY KEY ("TRIGGER_ID")
)
2018-01-11 13:24:49,402 INFO [server] [InterbaseSymmetricDialect] [background-refresher-1] DDL applied: CREATE TABLE "SYM_FILE_TRIGGER_ROUTER"(
    "TRIGGER_ID" VARCHAR(128) NOT NULL,
    "ROUTER_ID" VARCHAR(50) NOT NULL,
    "ENABLED" SMALLINT DEFAULT 1 NOT NULL,
    "INITIAL_LOAD_ENABLED" SMALLINT DEFAULT 1 NOT NULL,
    "TARGET_BASE_DIR" VARCHAR(255),
    "CONFLICT_STRATEGY" VARCHAR(128) DEFAULT 'source_wins' NOT NULL,
    "CREATE_TIME" TIMESTAMP NOT NULL,
    "LAST_UPDATE_BY" VARCHAR(50),
    "LAST_UPDATE_TIME" TIMESTAMP NOT NULL,
    "DESCRIPTION" VARCHAR(4096),
    PRIMARY KEY ("TRIGGER_ID", "ROUTER_ID")
)
2018-01-11 13:24:49,408 INFO [server] [InterbaseSymmetricDialect] [background-refresher-1] DDL applied: CREATE TABLE "SYM_GROUPLET"(
    "GROUPLET_ID" VARCHAR(50) NOT NULL,
    "GROUPLET_LINK_POLICY" CHAR(1) DEFAULT 'I' NOT NULL,
    "DESCRIPTION" VARCHAR(255),
    "CREATE_TIME" TIMESTAMP NOT NULL,
    "LAST_UPDATE_BY" VARCHAR(50),
    "LAST_UPDATE_TIME" TIMESTAMP NOT NULL,
    PRIMARY KEY ("GROUPLET_ID")
)
2018-01-11 13:24:49,413 INFO [server] [InterbaseSymmetricDialect] [background-refresher-1] DDL applied: CREATE TABLE "SYM_GROUPLET_LINK"(
    "GROUPLET_ID" VARCHAR(50) NOT NULL,
    "EXTERNAL_ID" VARCHAR(255) NOT NULL,
    "CREATE_TIME" TIMESTAMP NOT NULL,
    "LAST_UPDATE_BY" VARCHAR(50),
    "LAST_UPDATE_TIME" TIMESTAMP NOT NULL,
    PRIMARY KEY ("GROUPLET_ID", "EXTERNAL_ID")
)
2018-01-11 13:24:49,436 INFO [server] [InterbaseSymmetricDialect] [background-refresher-1] DDL applied: CREATE TABLE "SYM_INCOMING_BATCH"(
    "BATCH_ID" NUMERIC(18,0) 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" VARCHAR(4096),
    "LAST_UPDATE_HOSTNAME" VARCHAR(255),
    "LAST_UPDATE_TIME" TIMESTAMP,
    "CREATE_TIME" TIMESTAMP,
    "SUMMARY" VARCHAR(255),
    "IGNORE_COUNT" INTEGER DEFAULT 0 NOT NULL,
    "BYTE_COUNT" NUMERIC(18,0) 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" NUMERIC(18,0),
    "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" NUMERIC(18,0) DEFAULT 0 NOT NULL,
    PRIMARY KEY ("BATCH_ID", "NODE_ID")
)
2018-01-11 13:24:49,439 INFO [server] [InterbaseSymmetricDialect] [background-refresher-1] DDL applied: CREATE INDEX "SYM_IDX_IB_TIME_STATUS" ON "SYM_INCOMING_BATCH" ("CREATE_TIME", "STATUS")
2018-01-11 13:24:49,442 INFO [server] [InterbaseSymmetricDialect] [background-refresher-1] DDL applied: CREATE INDEX "SYM_IDX_IB_IN_ERROR" ON "SYM_INCOMING_BATCH" ("ERROR_FLAG")
2018-01-11 13:24:49,452 INFO [server] [InterbaseSymmetricDialect] [background-refresher-1] DDL applied: CREATE TABLE "SYM_INCOMING_ERROR"(
    "BATCH_ID" NUMERIC(18,0) NOT NULL,
    "NODE_ID" VARCHAR(50) NOT NULL,
    "FAILED_ROW_NUMBER" NUMERIC(18,0) NOT NULL,
    "FAILED_LINE_NUMBER" NUMERIC(18,0) 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" VARCHAR(4096) NOT NULL,
    "PK_COLUMN_NAMES" VARCHAR(4096) NOT NULL,
    "ROW_DATA" VARCHAR(4096),
    "OLD_DATA" VARCHAR(4096),
    "CUR_DATA" VARCHAR(4096),
    "RESOLVE_DATA" VARCHAR(4096),
    "RESOLVE_IGNORE" SMALLINT DEFAULT 0,
    "CONFLICT_ID" VARCHAR(50),
    "CREATE_TIME" TIMESTAMP,
    "LAST_UPDATE_BY" VARCHAR(50),
    "LAST_UPDATE_TIME" TIMESTAMP NOT NULL,
    PRIMARY KEY ("BATCH_ID", "NODE_ID", "FAILED_ROW_NUMBER")
)
2018-01-11 13:24:49,463 INFO [server] [InterbaseSymmetricDialect] [background-refresher-1] DDL applied: CREATE TABLE "SYM_LOAD_FILTER"(
    "LOAD_FILTER_ID" VARCHAR(50) NOT NULL,
    "LOAD_FILTER_TYPE" VARCHAR(10) NOT NULL,
    "SOURCE_NODE_GROUP_ID" VARCHAR(50) NOT NULL,
    "TARGET_NODE_GROUP_ID" VARCHAR(50) NOT NULL,
    "TARGET_CATALOG_NAME" VARCHAR(255),
    "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" VARCHAR(4096),
    "AFTER_WRITE_SCRIPT" VARCHAR(4096),
    "BATCH_COMPLETE_SCRIPT" VARCHAR(4096),
    "BATCH_COMMIT_SCRIPT" VARCHAR(4096),
    "BATCH_ROLLBACK_SCRIPT" VARCHAR(4096),
    "HANDLE_ERROR_SCRIPT" VARCHAR(4096),
    "CREATE_TIME" TIMESTAMP NOT NULL,
    "LAST_UPDATE_BY" VARCHAR(50),
    "LAST_UPDATE_TIME" TIMESTAMP NOT NULL,
    "LOAD_FILTER_ORDER" INTEGER DEFAULT 1 NOT NULL,
    "FAIL_ON_ERROR" SMALLINT DEFAULT 0 NOT NULL,
    PRIMARY KEY ("LOAD_FILTER_ID")
)
2018-01-11 13:24:49,473 INFO [server] [InterbaseSymmetricDialect] [background-refresher-1] DDL applied: CREATE TABLE "SYM_LOCK"(
    "LOCK_ACTION" VARCHAR(50) NOT NULL,
    "LOCK_TYPE" VARCHAR(50) NOT NULL,
    "LOCKING_SERVER_ID" VARCHAR(255),
    "LOCK_TIME" TIMESTAMP,
    "SHARED_COUNT" INTEGER DEFAULT 0 NOT NULL,
    "SHARED_ENABLE" INTEGER DEFAULT 0 NOT NULL,
    "LAST_LOCK_TIME" TIMESTAMP,
    "LAST_LOCKING_SERVER_ID" VARCHAR(255),
    PRIMARY KEY ("LOCK_ACTION")
)
2018-01-11 13:24:49,481 INFO [server] [InterbaseSymmetricDialect] [background-refresher-1] DDL applied: CREATE TABLE "SYM_NODE"(
    "NODE_ID" VARCHAR(50) NOT NULL,
    "NODE_GROUP_ID" VARCHAR(50) NOT NULL,
    "EXTERNAL_ID" VARCHAR(255) NOT NULL,
    "HEARTBEAT_TIME" TIMESTAMP,
    "TIMEZONE_OFFSET" VARCHAR(6),
    "SYNC_ENABLED" SMALLINT DEFAULT 0,
    "SYNC_URL" VARCHAR(255),
    "SCHEMA_VERSION" VARCHAR(50),
    "SYMMETRIC_VERSION" VARCHAR(50),
    "CONFIG_VERSION" VARCHAR(50),
    "DATABASE_TYPE" VARCHAR(50),
    "DATABASE_VERSION" VARCHAR(50),
    "BATCH_TO_SEND_COUNT" INTEGER DEFAULT 0,
    "BATCH_IN_ERROR_COUNT" INTEGER DEFAULT 0,
    "CREATED_AT_NODE_ID" VARCHAR(50),
    "DEPLOYMENT_TYPE" VARCHAR(50),
    "DEPLOYMENT_SUB_TYPE" VARCHAR(50),
    PRIMARY KEY ("NODE_ID")
)
2018-01-11 13:24:49,490 INFO [server] [InterbaseSymmetricDialect] [background-refresher-1] DDL applied: CREATE TABLE "SYM_NODE_COMMUNICATION"(
    "NODE_ID" VARCHAR(50) NOT NULL,
    "QUEUE" VARCHAR(25) DEFAULT 'default' NOT NULL,
    "COMMUNICATION_TYPE" VARCHAR(10) NOT NULL,
    "LOCK_TIME" TIMESTAMP,
    "LOCKING_SERVER_ID" VARCHAR(255),
    "LAST_LOCK_TIME" TIMESTAMP,
    "LAST_LOCK_MILLIS" NUMERIC(18,0) DEFAULT 0,
    "SUCCESS_COUNT" NUMERIC(18,0) DEFAULT 0,
    "FAIL_COUNT" NUMERIC(18,0) DEFAULT 0,
    "SKIP_COUNT" NUMERIC(18,0) DEFAULT 0,
    "TOTAL_SUCCESS_COUNT" NUMERIC(18,0) DEFAULT 0,
    "TOTAL_FAIL_COUNT" NUMERIC(18,0) DEFAULT 0,
    "TOTAL_SUCCESS_MILLIS" NUMERIC(18,0) DEFAULT 0,
    "TOTAL_FAIL_MILLIS" NUMERIC(18,0) DEFAULT 0,
    "BATCH_TO_SEND_COUNT" NUMERIC(18,0) DEFAULT 0,
    "NODE_PRIORITY" INTEGER DEFAULT 0,
    PRIMARY KEY ("NODE_ID", "QUEUE", "COMMUNICATION_TYPE")
)
2018-01-11 13:24:49,496 INFO [server] [InterbaseSymmetricDialect] [background-refresher-1] DDL applied: CREATE TABLE "SYM_NODE_CHANNEL_CTL"(
    "NODE_ID" VARCHAR(50) NOT NULL,
    "CHANNEL_ID" VARCHAR(128) NOT NULL,
    "SUSPEND_ENABLED" SMALLINT DEFAULT 0,
    "IGNORE_ENABLED" SMALLINT DEFAULT 0,
    "LAST_EXTRACT_TIME" TIMESTAMP,
    PRIMARY KEY ("NODE_ID", "CHANNEL_ID")
)
2018-01-11 13:24:49,501 INFO [server] [InterbaseSymmetricDialect] [background-refresher-1] DDL applied: CREATE TABLE "SYM_NODE_GROUP"(
    "NODE_GROUP_ID" VARCHAR(50) NOT NULL,
    "DESCRIPTION" VARCHAR(255),
    "CREATE_TIME" TIMESTAMP,
    "LAST_UPDATE_BY" VARCHAR(50),
    "LAST_UPDATE_TIME" TIMESTAMP,
    PRIMARY KEY ("NODE_GROUP_ID")
)
2018-01-11 13:24:49,507 INFO [server] [InterbaseSymmetricDialect] [background-refresher-1] DDL applied: CREATE TABLE "SYM_NODE_GROUP_CHANNEL_WND"(
    "NODE_GROUP_ID" VARCHAR(50) NOT NULL,
    "CHANNEL_ID" VARCHAR(128) NOT NULL,
    "START_TIME" TIMESTAMP NOT NULL,
    "END_TIME" TIMESTAMP NOT NULL,
    "ENABLED" SMALLINT DEFAULT 0 NOT NULL,
    PRIMARY KEY ("NODE_GROUP_ID", "CHANNEL_ID", "START_TIME", "END_TIME")
)
2018-01-11 13:24:49,514 INFO [server] [InterbaseSymmetricDialect] [background-refresher-1] DDL applied: CREATE TABLE "SYM_NODE_GROUP_LINK"(
    "SOURCE_NODE_GROUP_ID" VARCHAR(50) NOT NULL,
    "TARGET_NODE_GROUP_ID" VARCHAR(50) NOT NULL,
    "DATA_EVENT_ACTION" CHAR(1) DEFAULT 'W' NOT NULL,
    "SYNC_CONFIG_ENABLED" SMALLINT DEFAULT 1 NOT NULL,
    "IS_REVERSIBLE" SMALLINT DEFAULT 0 NOT NULL,
    "CREATE_TIME" TIMESTAMP,
    "LAST_UPDATE_BY" VARCHAR(50),
    "LAST_UPDATE_TIME" TIMESTAMP,
    PRIMARY KEY ("SOURCE_NODE_GROUP_ID", "TARGET_NODE_GROUP_ID")
)
2018-01-11 13:24:49,524 INFO [server] [InterbaseSymmetricDialect] [background-refresher-1] DDL applied: CREATE TABLE "SYM_NODE_HOST"(
    "NODE_ID" VARCHAR(50) NOT NULL,
    "HOST_NAME" VARCHAR(60) NOT NULL,
    "INSTANCE_ID" VARCHAR(60),
    "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" NUMERIC(18,0) DEFAULT 0,
    "TOTAL_MEMORY_BYTES" NUMERIC(18,0) DEFAULT 0,
    "MAX_MEMORY_BYTES" NUMERIC(18,0) DEFAULT 0,
    "JAVA_VERSION" VARCHAR(50),
    "JAVA_VENDOR" VARCHAR(255),
    "JDBC_VERSION" VARCHAR(255),
    "SYMMETRIC_VERSION" VARCHAR(50),
    "TIMEZONE_OFFSET" VARCHAR(6),
    "HEARTBEAT_TIME" TIMESTAMP,
    "LAST_RESTART_TIME" TIMESTAMP NOT NULL,
    "CREATE_TIME" TIMESTAMP NOT NULL,
    PRIMARY KEY ("NODE_ID", "HOST_NAME")
)
2018-01-11 13:24:49,534 INFO [server] [InterbaseSymmetricDialect] [background-refresher-1] DDL applied: CREATE TABLE "SYM_NODE_HOST_CHANNEL_STATS"(
    "NODE_ID" VARCHAR(50) NOT NULL,
    "HOST_NAME" VARCHAR(60) NOT NULL,
    "CHANNEL_ID" VARCHAR(128) NOT NULL,
    "START_TIME" TIMESTAMP NOT NULL,
    "END_TIME" TIMESTAMP NOT NULL,
    "DATA_ROUTED" NUMERIC(18,0) DEFAULT 0,
    "DATA_UNROUTED" NUMERIC(18,0) DEFAULT 0,
    "DATA_EVENT_INSERTED" NUMERIC(18,0) DEFAULT 0,
    "DATA_EXTRACTED" NUMERIC(18,0) DEFAULT 0,
    "DATA_BYTES_EXTRACTED" NUMERIC(18,0) DEFAULT 0,
    "DATA_EXTRACTED_ERRORS" NUMERIC(18,0) DEFAULT 0,
    "DATA_BYTES_SENT" NUMERIC(18,0) DEFAULT 0,
    "DATA_SENT" NUMERIC(18,0) DEFAULT 0,
    "DATA_SENT_ERRORS" NUMERIC(18,0) DEFAULT 0,
    "DATA_LOADED" NUMERIC(18,0) DEFAULT 0,
    "DATA_BYTES_LOADED" NUMERIC(18,0) DEFAULT 0,
    "DATA_LOADED_ERRORS" NUMERIC(18,0) DEFAULT 0,
    PRIMARY KEY ("NODE_ID", "HOST_NAME", "CHANNEL_ID", "START_TIME", "END_TIME")
)
2018-01-11 13:24:49,536 INFO [server] [InterbaseSymmetricDialect] [background-refresher-1] DDL applied: CREATE INDEX "SYM_IDX_ND_HST_CHNL_STS" ON "SYM_NODE_HOST_CHANNEL_STATS" ("NODE_ID", "START_TIME", "END_TIME")
2018-01-11 13:24:49,543 INFO [server] [InterbaseSymmetricDialect] [background-refresher-1] DDL applied: CREATE TABLE "SYM_NODE_HOST_JOB_STATS"(
    "NODE_ID" VARCHAR(50) NOT NULL,
    "HOST_NAME" VARCHAR(60) NOT NULL,
    "JOB_NAME" VARCHAR(50) NOT NULL,
    "START_TIME" TIMESTAMP NOT NULL,
    "END_TIME" TIMESTAMP NOT NULL,
    "PROCESSED_COUNT" NUMERIC(18,0) DEFAULT 0,
    "TARGET_NODE_ID" VARCHAR(50),
    "TARGET_NODE_COUNT" INTEGER DEFAULT 0,
    PRIMARY KEY ("NODE_ID", "HOST_NAME", "JOB_NAME", "START_TIME", "END_TIME")
)
2018-01-11 13:24:49,545 INFO [server] [InterbaseSymmetricDialect] [background-refresher-1] DDL applied: CREATE INDEX "SYM_IDX_ND_HST_JOB" ON "SYM_NODE_HOST_JOB_STATS" ("NODE_ID", "START_TIME", "END_TIME")
2018-01-11 13:24:49,557 INFO [server] [InterbaseSymmetricDialect] [background-refresher-1] DDL applied: CREATE TABLE "SYM_NODE_HOST_STATS"(
    "NODE_ID" VARCHAR(50) NOT NULL,
    "HOST_NAME" VARCHAR(60) NOT NULL,
    "START_TIME" TIMESTAMP NOT NULL,
    "END_TIME" TIMESTAMP NOT NULL,
    "RESTARTED" NUMERIC(18,0) DEFAULT 0 NOT NULL,
    "NODES_PULLED" NUMERIC(18,0) DEFAULT 0,
    "TOTAL_NODES_PULL_TIME" NUMERIC(18,0) DEFAULT 0,
    "NODES_PUSHED" NUMERIC(18,0) DEFAULT 0,
    "TOTAL_NODES_PUSH_TIME" NUMERIC(18,0) DEFAULT 0,
    "NODES_REJECTED" NUMERIC(18,0) DEFAULT 0,
    "NODES_REGISTERED" NUMERIC(18,0) DEFAULT 0,
    "NODES_LOADED" NUMERIC(18,0) DEFAULT 0,
    "NODES_DISABLED" NUMERIC(18,0) DEFAULT 0,
    "PURGED_DATA_ROWS" NUMERIC(18,0) DEFAULT 0,
    "PURGED_DATA_EVENT_ROWS" NUMERIC(18,0) DEFAULT 0,
    "PURGED_BATCH_OUTGOING_ROWS" NUMERIC(18,0) DEFAULT 0,
    "PURGED_BATCH_INCOMING_ROWS" NUMERIC(18,0) DEFAULT 0,
    "TRIGGERS_CREATED_COUNT" NUMERIC(18,0),
    "TRIGGERS_REBUILT_COUNT" NUMERIC(18,0),
    "TRIGGERS_REMOVED_COUNT" NUMERIC(18,0),
    PRIMARY KEY ("NODE_ID", "HOST_NAME", "START_TIME", "END_TIME")
)
2018-01-11 13:24:49,560 INFO [server] [InterbaseSymmetricDialect] [background-refresher-1] DDL applied: CREATE INDEX "SYM_IDX_ND_HST_STS" ON "SYM_NODE_HOST_STATS" ("NODE_ID", "START_TIME", "END_TIME")
2018-01-11 13:24:49,563 INFO [server] [InterbaseSymmetricDialect] [background-refresher-1] DDL applied: CREATE TABLE "SYM_NODE_IDENTITY"(
    "NODE_ID" VARCHAR(50) NOT NULL,
    PRIMARY KEY ("NODE_ID")
)
2018-01-11 13:24:49,571 INFO [server] [InterbaseSymmetricDialect] [background-refresher-1] DDL applied: CREATE TABLE "SYM_NODE_SECURITY"(
    "NODE_ID" VARCHAR(50) NOT NULL,
    "NODE_PASSWORD" VARCHAR(50) NOT NULL,
    "REGISTRATION_ENABLED" SMALLINT DEFAULT 0,
    "REGISTRATION_TIME" TIMESTAMP,
    "INITIAL_LOAD_ENABLED" SMALLINT DEFAULT 0,
    "INITIAL_LOAD_TIME" TIMESTAMP,
    "INITIAL_LOAD_ID" NUMERIC(18,0),
    "INITIAL_LOAD_CREATE_BY" VARCHAR(255),
    "REV_INITIAL_LOAD_ENABLED" SMALLINT DEFAULT 0,
    "REV_INITIAL_LOAD_TIME" TIMESTAMP,
    "REV_INITIAL_LOAD_ID" NUMERIC(18,0),
    "REV_INITIAL_LOAD_CREATE_BY" VARCHAR(255),
    "CREATED_AT_NODE_ID" VARCHAR(50),
    PRIMARY KEY ("NODE_ID")
)
2018-01-11 13:24:49,579 INFO [server] [InterbaseSymmetricDialect] [background-refresher-1] DDL applied: CREATE TABLE "SYM_MONITOR"(
    "MONITOR_ID" VARCHAR(128) NOT NULL,
    "NODE_GROUP_ID" VARCHAR(50) DEFAULT 'ALL' NOT NULL,
    "EXTERNAL_ID" VARCHAR(255) DEFAULT 'ALL' NOT NULL,
    "TYPE" VARCHAR(50) NOT NULL,
    "EXPRESSION" VARCHAR(4096),
    "THRESHOLD" NUMERIC(18,0) DEFAULT 0 NOT NULL,
    "RUN_PERIOD" INTEGER DEFAULT 0 NOT NULL,
    "RUN_COUNT" INTEGER DEFAULT 0 NOT NULL,
    "SEVERITY_LEVEL" INTEGER DEFAULT 0 NOT NULL,
    "ENABLED" SMALLINT DEFAULT 0 NOT NULL,
    "CREATE_TIME" TIMESTAMP,
    "LAST_UPDATE_BY" VARCHAR(50),
    "LAST_UPDATE_TIME" TIMESTAMP,
    PRIMARY KEY ("MONITOR_ID")
)
2018-01-11 13:24:49,588 INFO [server] [InterbaseSymmetricDialect] [background-refresher-1] DDL applied: CREATE TABLE "SYM_MONITOR_EVENT"(
    "MONITOR_ID" VARCHAR(128) NOT NULL,
    "NODE_ID" VARCHAR(50) NOT NULL,
    "EVENT_TIME" TIMESTAMP NOT NULL,
    "HOST_NAME" VARCHAR(60),
    "TYPE" VARCHAR(50) NOT NULL,
    "THRESHOLD" NUMERIC(18,0) DEFAULT 0 NOT NULL,
    "EVENT_VALUE" NUMERIC(18,0) 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" VARCHAR(4096),
    "LAST_UPDATE_TIME" TIMESTAMP,
    PRIMARY KEY ("MONITOR_ID", "NODE_ID", "EVENT_TIME")
)
2018-01-11 13:24:49,594 INFO [server] [InterbaseSymmetricDialect] [background-refresher-1] DDL applied: CREATE TABLE "SYM_NOTIFICATION"(
    "NOTIFICATION_ID" VARCHAR(128) NOT NULL,
    "NODE_GROUP_ID" VARCHAR(50) DEFAULT 'ALL' NOT NULL,
    "EXTERNAL_ID" VARCHAR(255) DEFAULT 'ALL' NOT NULL,
    "SEVERITY_LEVEL" INTEGER DEFAULT 0 NOT NULL,
    "TYPE" VARCHAR(50) NOT NULL,
    "EXPRESSION" VARCHAR(4096),
    "ENABLED" SMALLINT DEFAULT 0 NOT NULL,
    "CREATE_TIME" TIMESTAMP,
    "LAST_UPDATE_BY" VARCHAR(50),
    "LAST_UPDATE_TIME" TIMESTAMP,
    PRIMARY KEY ("NOTIFICATION_ID")
)
2018-01-11 13:24:49,617 INFO [server] [InterbaseSymmetricDialect] [background-refresher-1] DDL applied: CREATE TABLE "SYM_OUTGOING_BATCH"(
    "BATCH_ID" NUMERIC(18,0) 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" VARCHAR(4096),
    "LAST_UPDATE_HOSTNAME" VARCHAR(255),
    "LAST_UPDATE_TIME" TIMESTAMP,
    "CREATE_TIME" TIMESTAMP,
    "SUMMARY" VARCHAR(255),
    "IGNORE_COUNT" INTEGER DEFAULT 0 NOT NULL,
    "BYTE_COUNT" NUMERIC(18,0) 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" NUMERIC(18,0),
    "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" NUMERIC(18,0) DEFAULT 0 NOT NULL,
    "FAILED_LINE_NUMBER" NUMERIC(18,0) DEFAULT 0 NOT NULL,
    "CREATE_BY" VARCHAR(255),
    PRIMARY KEY ("BATCH_ID", "NODE_ID")
)
2018-01-11 13:24:49,621 INFO [server] [InterbaseSymmetricDialect] [background-refresher-1] DDL applied: CREATE INDEX "SYM_IDX_OB_NODE_STATUS" ON "SYM_OUTGOING_BATCH" ("NODE_ID", "STATUS")
2018-01-11 13:24:49,623 INFO [server] [InterbaseSymmetricDialect] [background-refresher-1] DDL applied: CREATE INDEX "SYM_IDX_OB_STATUS" ON "SYM_OUTGOING_BATCH" ("STATUS")
2018-01-11 13:24:49,626 INFO [server] [InterbaseSymmetricDialect] [background-refresher-1] DDL applied: CREATE INDEX "SYM_IDX_OB_IN_ERROR" ON "SYM_OUTGOING_BATCH" ("ERROR_FLAG")
2018-01-11 13:24:49,631 INFO [server] [InterbaseSymmetricDialect] [background-refresher-1] DDL applied: CREATE TABLE "SYM_PARAMETER"(
    "EXTERNAL_ID" VARCHAR(255) NOT NULL,
    "NODE_GROUP_ID" VARCHAR(50) NOT NULL,
    "PARAM_KEY" VARCHAR(80) NOT NULL,
    "PARAM_VALUE" VARCHAR(4096),
    "CREATE_TIME" TIMESTAMP,
    "LAST_UPDATE_BY" VARCHAR(50),
    "LAST_UPDATE_TIME" TIMESTAMP,
    PRIMARY KEY ("EXTERNAL_ID", "NODE_GROUP_ID", "PARAM_KEY")
)
2018-01-11 13:24:49,635 INFO [server] [InterbaseSymmetricDialect] [background-refresher-1] DDL applied: CREATE TABLE "SYM_REGISTRATION_REDIRECT"(
    "REGISTRANT_EXTERNAL_ID" VARCHAR(255) NOT NULL,
    "REGISTRATION_NODE_ID" VARCHAR(50) NOT NULL,
    PRIMARY KEY ("REGISTRANT_EXTERNAL_ID")
)
2018-01-11 13:24:49,642 INFO [server] [InterbaseSymmetricDialect] [background-refresher-1] DDL applied: CREATE TABLE "SYM_REGISTRATION_REQUEST"(
    "NODE_GROUP_ID" VARCHAR(50) NOT NULL,
    "EXTERNAL_ID" VARCHAR(255) NOT NULL,
    "STATUS" CHAR(2) NOT NULL,
    "HOST_NAME" VARCHAR(60) NOT NULL,
    "IP_ADDRESS" VARCHAR(50) NOT NULL,
    "ATTEMPT_COUNT" INTEGER DEFAULT 0,
    "REGISTERED_NODE_ID" VARCHAR(50),
    "ERROR_MESSAGE" VARCHAR(4096),
    "CREATE_TIME" TIMESTAMP NOT NULL,
    "LAST_UPDATE_BY" VARCHAR(50),
    "LAST_UPDATE_TIME" TIMESTAMP NOT NULL,
    PRIMARY KEY ("NODE_GROUP_ID", "EXTERNAL_ID", "CREATE_TIME")
)
2018-01-11 13:24:49,644 INFO [server] [InterbaseSymmetricDialect] [background-refresher-1] DDL applied: CREATE INDEX "SYM_IDX_REG_REQ_1" ON "SYM_REGISTRATION_REQUEST" ("NODE_GROUP_ID", "EXTERNAL_ID", "STATUS", "HOST_NAME", "IP_ADDRESS")
2018-01-11 13:24:49,646 INFO [server] [InterbaseSymmetricDialect] [background-refresher-1] DDL applied: CREATE INDEX "SYM_IDX_REG_REQ_2" ON "SYM_REGISTRATION_REQUEST" ("STATUS")
2018-01-11 13:24:49,654 INFO [server] [InterbaseSymmetricDialect] [background-refresher-1] DDL applied: CREATE TABLE "SYM_ROUTER"(
    "ROUTER_ID" VARCHAR(50) NOT NULL,
    "TARGET_CATALOG_NAME" VARCHAR(255),
    "TARGET_SCHEMA_NAME" VARCHAR(255),
    "TARGET_TABLE_NAME" VARCHAR(255),
    "SOURCE_NODE_GROUP_ID" VARCHAR(50) NOT NULL,
    "TARGET_NODE_GROUP_ID" VARCHAR(50) NOT NULL,
    "ROUTER_TYPE" VARCHAR(50),
    "ROUTER_EXPRESSION" VARCHAR(4096),
    "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" VARCHAR(4096),
    PRIMARY KEY ("ROUTER_ID")
)
2018-01-11 13:24:49,661 INFO [server] [InterbaseSymmetricDialect] [background-refresher-1] DDL applied: CREATE TABLE "SYM_SEQUENCE"(
    "SEQUENCE_NAME" VARCHAR(50) NOT NULL,
    "CURRENT_VALUE" NUMERIC(18,0) DEFAULT 0 NOT NULL,
    "INCREMENT_BY" INTEGER DEFAULT 1 NOT NULL,
    "MIN_VALUE" NUMERIC(18,0) DEFAULT 1 NOT NULL,
    "MAX_VALUE" NUMERIC(18,0) DEFAULT 9999999999 NOT NULL,
    "CYCLE_FLAG" SMALLINT DEFAULT 0,
    "CACHE_SIZE" INTEGER DEFAULT 0 NOT NULL,
    "CREATE_TIME" TIMESTAMP,
    "LAST_UPDATE_BY" VARCHAR(50),
    "LAST_UPDATE_TIME" TIMESTAMP NOT NULL,
    PRIMARY KEY ("SEQUENCE_NAME")
)
2018-01-11 13:24:49,670 INFO [server] [InterbaseSymmetricDialect] [background-refresher-1] DDL applied: CREATE TABLE "SYM_TABLE_RELOAD_REQUEST"(
    "TARGET_NODE_ID" VARCHAR(50) NOT NULL,
    "SOURCE_NODE_ID" VARCHAR(50) NOT NULL,
    "TRIGGER_ID" VARCHAR(128) NOT NULL,
    "ROUTER_ID" VARCHAR(50) NOT NULL,
    "CREATE_TIME" TIMESTAMP NOT NULL,
    "CREATE_TABLE" SMALLINT DEFAULT 0 NOT NULL,
    "DELETE_FIRST" SMALLINT DEFAULT 0 NOT NULL,
    "RELOAD_SELECT" VARCHAR(4096),
    "BEFORE_CUSTOM_SQL" VARCHAR(4096),
    "RELOAD_TIME" TIMESTAMP,
    "LOAD_ID" NUMERIC(18,0),
    "PROCESSED" SMALLINT DEFAULT 0 NOT NULL,
    "CHANNEL_ID" VARCHAR(128),
    "LAST_UPDATE_BY" VARCHAR(50),
    "LAST_UPDATE_TIME" TIMESTAMP NOT NULL,
    PRIMARY KEY ("TARGET_NODE_ID", "SOURCE_NODE_ID", "TRIGGER_ID", "ROUTER_ID", "CREATE_TIME")
)
2018-01-11 13:24:49,679 INFO [server] [InterbaseSymmetricDialect] [background-refresher-1] DDL applied: CREATE TABLE "SYM_TRANSFORM_TABLE"(
    "TRANSFORM_ID" VARCHAR(50) NOT NULL,
    "SOURCE_NODE_GROUP_ID" VARCHAR(50) NOT NULL,
    "TARGET_NODE_GROUP_ID" VARCHAR(50) NOT NULL,
    "TRANSFORM_POINT" VARCHAR(10) NOT NULL,
    "SOURCE_CATALOG_NAME" VARCHAR(255),
    "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" VARCHAR(4096),
    PRIMARY KEY ("TRANSFORM_ID", "SOURCE_NODE_GROUP_ID", "TARGET_NODE_GROUP_ID")
)
2018-01-11 13:24:49,687 INFO [server] [InterbaseSymmetricDialect] [background-refresher-1] DDL applied: CREATE TABLE "SYM_TRANSFORM_COLUMN"(
    "TRANSFORM_ID" VARCHAR(50) NOT NULL,
    "INCLUDE_ON" CHAR(1) DEFAULT '*' NOT NULL,
    "TARGET_COLUMN_NAME" VARCHAR(128) NOT NULL,
    "SOURCE_COLUMN_NAME" VARCHAR(128),
    "PK" SMALLINT DEFAULT 0,
    "TRANSFORM_TYPE" VARCHAR(50) DEFAULT 'copy',
    "TRANSFORM_EXPRESSION" VARCHAR(4096),
    "TRANSFORM_ORDER" INTEGER DEFAULT 1 NOT NULL,
    "CREATE_TIME" TIMESTAMP,
    "LAST_UPDATE_BY" VARCHAR(50),
    "LAST_UPDATE_TIME" TIMESTAMP,
    "DESCRIPTION" VARCHAR(4096),
    PRIMARY KEY ("TRANSFORM_ID", "INCLUDE_ON", "TARGET_COLUMN_NAME")
)
2018-01-11 13:24:49,699 WARN [server] [InterbaseSymmetricDialect] [background-refresher-1] DDL failed: 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" VARCHAR(4096),
    "SYNC_ON_INSERT_CONDITION" VARCHAR(4096),
    "SYNC_ON_DELETE_CONDITION" VARCHAR(4096),
    "CUSTOM_BEFORE_UPDATE_TEXT" VARCHAR(4096),
    "CUSTOM_BEFORE_INSERT_TEXT" VARCHAR(4096),
    "CUSTOM_BEFORE_DELETE_TEXT" VARCHAR(4096),
    "CUSTOM_ON_UPDATE_TEXT" VARCHAR(4096),
    "CUSTOM_ON_INSERT_TEXT" VARCHAR(4096),
    "CUSTOM_ON_DELETE_TEXT" VARCHAR(4096),
    "EXTERNAL_SELECT" VARCHAR(4096),
    "TX_ID_EXPRESSION" VARCHAR(4096),
    "CHANNEL_EXPRESSION" VARCHAR(4096),
    "EXCLUDED_COLUMN_NAMES" VARCHAR(4096),
    "INCLUDED_COLUMN_NAMES" VARCHAR(4096),
    "SYNC_KEY_NAMES" VARCHAR(4096),
    "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" VARCHAR(4096),
    PRIMARY KEY ("TRIGGER_ID")
)
2018-01-11 13:24:49,700 WARN [server] [JdbcSqlTemplate] [background-refresher-1] interbase.interclient.IBException: [interclient][interbase]unsuccessful metadata update
[interclient][interbase]new record size of 67602 bytes is too big
[interclient][interbase]TABLE SYM_TRIGGER. Failed to execute: 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" VARCHAR(4096),
    "SYNC_ON_INSERT_CONDITION" VARCHAR(4096),
    "SYNC_ON_DELETE_CONDITION" VARCHAR(4096),
    "CUSTOM_BEFORE_UPDATE_TEXT" VARCHAR(4096),
    "CUSTOM_BEFORE_INSERT_TEXT" VARCHAR(4096),
    "CUSTOM_BEFORE_DELETE_TEXT" VARCHAR(4096),
    "CUSTOM_ON_UPDATE_TEXT" VARCHAR(4096),
    "CUSTOM_ON_INSERT_TEXT" VARCHAR(4096),
    "CUSTOM_ON_DELETE_TEXT" VARCHAR(4096),
    "EXTERNAL_SELECT" VARCHAR(4096),
    "TX_ID_EXPRESSION" VARCHAR(4096),
    "CHANNEL_EXPRESSION" VARCHAR(4096),
    "EXCLUDED_COLUMN_NAMES" VARCHAR(4096),
    "INCLUDED_COLUMN_NAMES" VARCHAR(4096),
    "SYNC_KEY_NAMES" VARCHAR(4096),
    "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" VARCHAR(4096),
    PRIMARY KEY ("TRIGGER_ID")
)
2018-01-11 13:24:49,701 ERROR [server] [AbstractSymmetricEngine] [background-refresher-1] An error occurred while starting SymmetricDS StackTraceKey.init [SqlException:4262246999]
org.jumpmind.db.sql.SqlException: interbase.interclient.IBException: [interclient][interbase]unsuccessful metadata update
[interclient][interbase]new record size of 67602 bytes is too big
[interclient][interbase]TABLE SYM_TRIGGER
    at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:300)
    at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:291)
    at org.jumpmind.db.sql.JdbcSqlTemplate.execute(JdbcSqlTemplate.java:493)
    at org.jumpmind.db.sql.JdbcSqlTemplate.update(JdbcSqlTemplate.java:401)
    at org.jumpmind.db.sql.SqlScript.execute(SqlScript.java:107)
    at org.jumpmind.symmetric.db.AbstractSymmetricDialect.createOrAlterTablesIfNecessary(AbstractSymmetricDialect.java:528)
    at org.jumpmind.symmetric.db.AbstractSymmetricDialect.initTablesAndDatabaseObjects(AbstractSymmetricDialect.java:159)
    at org.jumpmind.symmetric.AbstractSymmetricEngine.setupDatabase(AbstractSymmetricEngine.java:495)
    at org.jumpmind.symmetric.AbstractSymmetricEngine.setup(AbstractSymmetricEngine.java:469)
    at org.jumpmind.symmetric.AbstractSymmetricEngine.start(AbstractSymmetricEngine.java:637)
    at org.jumpmind.symmetric.AbstractSymmetricEngine.start(AbstractSymmetricEngine.java:628)
    at org.jumpmind.symmetric.ClientSymmetricEngine.start(ClientSymmetricEngine.java:258)
    at org.jumpmind.symmetric.web.SymmetricEngineHolder.install(SymmetricEngineHolder.java:412)
    at com.jumpmind.symmetric.console.ui.a.c.a.t(AbstractWizardScreen.java:149)
    at com.jumpmind.symmetric.console.ui.a.c.p$a.doWork(SummaryScreen.java:68)
    at com.jumpmind.symmetric.console.ui.common.InProgressDialog$2.onBackgroundDataRefresh(InProgressDialog.java:99)
    at com.jumpmind.symmetric.console.ui.a.a(BackgroundRefresherService.java:97)
    at com.jumpmind.symmetric.console.ui.a$3.run(BackgroundRefresherService.java:140)
    at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
    at java.util.concurrent.FutureTask.run(Unknown Source)
    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(Unknown Source)
    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
    at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLException: interbase.interclient.IBException: [interclient][interbase]unsuccessful metadata update
[interclient][interbase]new record size of 67602 bytes is too big
[interclient][interbase]TABLE SYM_TRIGGER
    at interbase.interclient.Connection.remote_COMMIT(Unknown Source)
    at interbase.interclient.Connection.setAutoCommit(Unknown Source)
    at org.apache.commons.dbcp.DelegatingConnection.setAutoCommit(DelegatingConnection.java:371)
    at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.setAutoCommit(PoolingDataSource.java:328)
    at org.jumpmind.db.sql.JdbcSqlTemplate$6.execute(JdbcSqlTemplate.java:472)
    at org.jumpmind.db.sql.JdbcSqlTemplate$6.execute(JdbcSqlTemplate.java:401)
    at org.jumpmind.db.sql.JdbcSqlTemplate.execute(JdbcSqlTemplate.java:491)
    ... 22 more
2018-01-11 13:24:49,702 INFO [server] [AbstractSymmetricEngine] [background-refresher-1] Stopping SymmetricDS externalId=server version=3.9.2 database=InterBase
2018-01-11 13:24:49,702 INFO [server] [AbstractSymmetricEngine] [background-refresher-1]
2018-01-11 13:24:49,716 ERROR [server] [a] [background-refresher-1] Exception while refreshing class com.jumpmind.symmetric.console.ui.common.InProgressDialog$2 StackTraceKey.init [SqlException:29683552]
org.jumpmind.db.sql.SqlException: [interclient][interbase]Dynamic SQL Error
[interclient][interbase]SQL error code = -204
[interclient][interbase]Table unknown
[interclient][interbase]SYM_CONSOLE_USER
    at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:300)
    at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:291)
    at org.jumpmind.db.sql.JdbcSqlTemplate.execute(JdbcSqlTemplate.java:493)
    at org.jumpmind.db.sql.JdbcSqlTemplate.update(JdbcSqlTemplate.java:342)
    at org.jumpmind.db.sql.AbstractSqlTemplate.update(AbstractSqlTemplate.java:224)
    at com.jumpmind.symmetric.console.service.impl.ConsoleUserService.save(ConsoleUserService.java:112)
    at com.jumpmind.symmetric.console.ui.a.c.p.u(SummaryScreen.java:60)
    at com.jumpmind.symmetric.console.ui.a.c.a.t(AbstractWizardScreen.java:160)
    at com.jumpmind.symmetric.console.ui.a.c.p$a.doWork(SummaryScreen.java:68)
    at com.jumpmind.symmetric.console.ui.common.InProgressDialog$2.onBackgroundDataRefresh(InProgressDialog.java:99)
    at com.jumpmind.symmetric.console.ui.a.a(BackgroundRefresherService.java:97)
    at com.jumpmind.symmetric.console.ui.a$3.run(BackgroundRefresherService.java:140)
    at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
    at java.util.concurrent.FutureTask.run(Unknown Source)
    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(Unknown Source)
    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
    at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLException: [interclient][interbase]Dynamic SQL Error
[interclient][interbase]SQL error code = -204
[interclient][interbase]Table unknown
[interclient][interbase]SYM_CONSOLE_USER
    at interbase.interclient.PreparedStatement.remote_PREPARE_STATEMENT(Unknown Source)
    at interbase.interclient.PreparedStatement.<init>(Unknown Source)
    at interbase.interclient.Connection.prepareStatement(Unknown Source)
    at interbase.interclient.Connection.prepareStatement(Unknown Source)
    at org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:281)
    at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:313)
    at org.jumpmind.db.sql.JdbcSqlTemplate$5.execute(JdbcSqlTemplate.java:364)
    at org.jumpmind.db.sql.JdbcSqlTemplate$5.execute(JdbcSqlTemplate.java:342)
    at org.jumpmind.db.sql.JdbcSqlTemplate.execute(JdbcSqlTemplate.java:491)
    ... 16 more
2018-01-11 13:24:59,711 ERROR [server] [a] [background-refresher-2] Exception while refreshing class com.jumpmind.symmetric.console.ui.b$a StackTraceKey.init [SqlException:639049808]
org.jumpmind.db.sql.SqlException: Failed to execute sql: select monitor_id, node_id, event_time, "TYPE", event_value, event_count, threshold, severity_level, host_name, is_resolved, is_notified, details, last_update_time from sym_monitor_event where severity_level >= ? and is_resolved = ? order by event_time desc
    at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:300)
    at org.jumpmind.db.sql.JdbcSqlReadCursor.<init>(JdbcSqlReadCursor.java:120)
    at org.jumpmind.db.sql.JdbcSqlTemplate.queryForCursor(JdbcSqlTemplate.java:140)
    at org.jumpmind.db.sql.AbstractSqlTemplate.query(AbstractSqlTemplate.java:199)
    at org.jumpmind.db.sql.AbstractSqlTemplate.query(AbstractSqlTemplate.java:195)
    at org.jumpmind.db.sql.AbstractSqlTemplate.query(AbstractSqlTemplate.java:150)
    at org.jumpmind.symmetric.service.impl.MonitorService.getMonitorEventsFiltered(MonitorService.java:327)
    at com.jumpmind.symmetric.console.ui.b.a(MainWindow.java:1001)
    at com.jumpmind.symmetric.console.ui.b$a.a(MainWindow.java:1452)
    at com.jumpmind.symmetric.console.ui.b$a.onBackgroundDataRefresh(MainWindow.java:1448)
    at com.jumpmind.symmetric.console.ui.a.a(BackgroundRefresherService.java:97)
    at com.jumpmind.symmetric.console.ui.a$1.run(BackgroundRefresherService.java:81)
    at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)
    at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
    at java.util.concurrent.FutureTask.runAndReset(Unknown Source)
    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(Unknown Source)
    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
    at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLException: interbase.interclient.IBException: [interclient][interbase]unsuccessful metadata update
[interclient][interbase]new record size of 67602 bytes is too big
[interclient][interbase]TABLE SYM_TRIGGER
    at interbase.interclient.Connection.remote_COMMIT(Unknown Source)
    at interbase.interclient.Connection$TransactionProperties.setIsolation(Unknown Source)
    at interbase.interclient.Connection$TransactionProperties.access$400(Unknown Source)
    at interbase.interclient.Connection.setTransactionIsolation(Unknown Source)
    at org.apache.commons.dbcp.DelegatingConnection.setTransactionIsolation(DelegatingConnection.java:380)
    at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.setTransactionIsolation(PoolingDataSource.java:343)
    at org.jumpmind.db.sql.JdbcSqlReadCursor.<init>(JdbcSqlReadCursor.java:81)
    ... 18 more
2018-01-11 13:25:09,716 ERROR [server] [a] [background-refresher-2] Exception while refreshing class com.jumpmind.symmetric.console.ui.b$a StackTraceKey [SqlException:639049808]
2018-01-11 13:25:19,722 ERROR [server] [a] [background-refresher-2] Exception while refreshing class com.jumpmind.symmetric.console.ui.b$a StackTraceKey [SqlException:639049808]
2018-01-11 13:25:29,726 ERROR [server] [a] [background-refresher-2] Exception while refreshing class com.jumpmind.symmetric.console.ui.b$a StackTraceKey [SqlException:639049808]
2018-01-11 13:25:39,731 ERROR [server] [a] [background-refresher-2] Exception while refreshing class com.jumpmind.symmetric.console.ui.b$a StackTraceKey [SqlException:639049808]
2018-01-11 13:25:49,736 ERROR [server] [a] [background-refresher-2] Exception while refreshing class com.jumpmind.symmetric.console.ui.b$a StackTraceKey [SqlException:639049808]
2018-01-11 13:25:59,741 ERROR [server] [a] [background-refresher-2] Exception while refreshing class com.jumpmind.symmetric.console.ui.b$a StackTraceKey [SqlException:639049808]
2018-01-11 13:26:09,746 ERROR [server] [a] [background-refresher-2] Exception while refreshing class com.jumpmind.symmetric.console.ui.b$a StackTraceKey [SqlException:639049808]
2018-01-11 13:26:19,751 ERROR [server] [a] [background-refresher-2] Exception while refreshing class com.jumpmind.symmetric.console.ui.b$a StackTraceKey [SqlException:639049808]
2018-01-11 13:26:29,757 ERROR [server] [a] [background-refresher-2] Exception while refreshing class com.jumpmind.symmetric.console.ui.b$a StackTraceKey [SqlException:639049808]
2018-01-11 13:26:39,762 ERROR [server] [a] [background-refresher-2] Exception while refreshing class com.jumpmind.symmetric.console.ui.b$a StackTraceKey [SqlException:639049808]
2018-01-11 13:26:49,768 ERROR [server] [a] [background-refresher-2] Exception while refreshing class com.jumpmind.symmetric.console.ui.b$a StackTraceKey [SqlException:639049808]
2018-01-11 13:26:59,774 ERROR [server] [a] [background-refresher-2] Exception while refreshing class com.jumpmind.symmetric.console.ui.b$a StackTraceKey [SqlException:639049808]
2018-01-11 13:27:09,780 ERROR [server] [a] [background-refresher-2] Exception while refreshing class com.jumpmind.symmetric.console.ui.b$a StackTraceKey [SqlException:639049808]
2018-01-11 13:27:19,785 ERROR [server] [a] [background-refresher-2] Exception while refreshing class com.jumpmind.symmetric.console.ui.b$a StackTraceKey [SqlException:639049808]
2018-01-11 13:27:29,791 ERROR [server] [a] [background-refresher-2] Exception while refreshing class com.jumpmind.symmetric.console.ui.b$a StackTraceKey [SqlException:639049808]
2018-01-11 13:27:39,795 ERROR [server] [a] [background-refresher-2] Exception while refreshing class com.jumpmind.symmetric.console.ui.b$a StackTraceKey [SqlException:639049808]
2018-01-11 13:27:49,801 ERROR [server] [a] [background-refresher-2] Exception while refreshing class com.jumpmind.symmetric.console.ui.b$a StackTraceKey [SqlException:639049808]
2018-01-11 13:27:59,806 ERROR [server] [a] [background-refresher-2] Exception while refreshing class com.jumpmind.symmetric.console.ui.b$a StackTraceKey [SqlException:639049808]
2018-01-11 13:28:09,810 ERROR [server] [a] [background-refresher-2] Exception while refreshing class com.jumpmind.symmetric.console.ui.b$a StackTraceKey [SqlException:639049808]
2018-01-11 13:28:19,815 ERROR [server] [a] [background-refresher-2] Exception while refreshing class com.jumpmind.symmetric.console.ui.b$a StackTraceKey [SqlException:639049808]
2018-01-11 13:28:29,821 ERROR [server] [a] [background-refresher-2] Exception while refreshing class com.jumpmind.symmetric.console.ui.b$a StackTraceKey [SqlException:639049808]

gilles.riand

2018-04-24 12:26

reporter   ~0001166

>>> new record size of 67602 bytes is too big

http://docwiki.embarcadero.com/InterBase/2017/en/Various_InterBase_Limits

For Interbase

Maximum row size
64KB. Each Blob and array contributes eight bytes to this limit in the form of their Blob handle.
Systems tables (tables maintained by the InterBase engine for system data) have a row size limit of 128KB.

gilles.riand

2019-11-06 07:30

reporter   ~0001628

It's the same bug with th e last version 3.10.5 !

[interclient][interbase]unsuccessful metadata update
[interclient][interbase]new record size of 67602 bytes is too big
[interclient][interbase]TABLE SYM_TRIGGER
    at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:305)

elong

2019-11-06 13:38

developer   ~0001629

Let's target 3.10.6. Testing potential fix this week.

pmarzullo

2019-11-06 15:24

developer   ~0001630

Interbase also pads char column types.

Related Changesets

SymmetricDS: 3.10 b93b7227

2019-11-06 10:22:53

Philip Marzullo

Details Diff 		0003362: SYM tables (sym_trigger, etc) won't create on Interbase bec
they exceed 64KB max row size		 Affected Issues
0003362
mod - symmetric-db/src/main/java/org/jumpmind/db/platform/interbase/InterbaseDdlBuilder.java Diff File

Issue History

Date Modified Username Field Change
2018-01-11 12:35 gilles.riand New Issue
2018-01-11 12:36 gilles.riand Note Added: 0001103
2018-04-24 12:26 gilles.riand Note Added: 0001166
2018-10-10 17:13 hanes Summary Impossible to Install SymmetricDS => Impossible to Install SymmetricDS on Interbase due to table size issue on sym_trigger (and possibly others)
2018-10-17 16:26 hanes Project SymmetricDS Pro => SymmetricDS
2018-10-17 16:26 hanes Category Installation => General
2019-04-12 16:48 admin Tag Attached: interbase
2019-04-12 16:48 admin Tag Attached: install
2019-04-23 20:49 admin Tag Renamed interbase => dialect: interbase
2019-04-26 22:03 elong Category General => Bug
2019-04-26 22:03 elong Summary Impossible to Install SymmetricDS on Interbase due to table size issue on sym_trigger (and possibly others) => SYM tables (sym_trigger, etc) won't create on Interbase bec they exceed 64KB max row size
2019-04-26 22:10 elong Relationship added has duplicate 0003832
2019-09-13 12:59 pmarzullo Assigned To => pmarzullo
2019-09-13 12:59 pmarzullo Status new => assigned
2019-11-06 07:30 gilles.riand Note Added: 0001628
2019-11-06 13:38 elong Target Version => 3.10.6
2019-11-06 13:38 elong Note Added: 0001629
2019-11-06 15:24 pmarzullo Status assigned => resolved
2019-11-06 15:24 pmarzullo Resolution open => fixed
2019-11-06 15:24 pmarzullo Fixed in Version => 3.10.6
2019-11-06 15:24 pmarzullo Note Added: 0001630
2019-11-06 16:00 Changeset attached => SymmetricDS 3.10 b93b7227
2019-11-15 13:23 admin Status resolved => closed