Hi I am using symmetric-server-3.9.13 to replication data for few tables from sybase to sql server. Was able to successfully create sym tables at source/target side and inserted table name in sym_trigger and sym_trigger_router. But when I execute sym command replication is not happening from sybase to sql server.
Sybase version is Adaptive Server Enterprise/15.5. And SQL server version is 2014.
Please suggest if you have encountered this or if I am missing something. Below are the logs which I am not able to interpret fully but looks like it is going in loop where it goes 'Full gap analysis is done under x ms'
Also there is one line in logs on which I am doubtful which says An error occurred while starting SymmetricDS StackTraceKey.init [IllegalArgumentException:322018706]..
2018-10-05 10:31:07,530 ERROR [store-001][AbstractSymmetricEngine][symmetric-engine-startup-2] An error occurred while starting SymmetricDS StackTraceKey.init [IllegalArgumentException:322018706]
java.lang.IllegalArgumentException: Cron expression must consist of 6 fields (found 1 in "10000 ")
Full logs are below:
2018-09-26 10:42:18,902 INFO [startup][SymmetricUtils][main] _ __ _ _____
/ / __ __ __ ___ __ ___ / /()___ / __ | / ___/
_ \ / / / / _ _ \/ _ \/ _ \/// / / / / / / / _ \ / // // / // // / // // / __// / / / / / / / // / ___/ /
/____/ _ ///////////_/ _/ // //_/ /__/ /_/
//
+-----------------------------------------------------------------+
| Copyright (C) 2007-2018 JumpMind, Inc. |
| |
| Licensed under the GNU General Public License version 3. |
| This software comes with ABSOLUTELY NO WARRANTY. |
| See http://www.gnu.org/licenses/gpl.html |
+-----------------------------------------------------------------+
2018-09-26 10:42:19,027 INFO [startup][SymmetricWebServer][main] About to start SymmetricDS web server on host:port 0.0.0.0:31415
2018-09-26 10:42:20,793 INFO [store-001][AbstractSymmetricEngine][symmetric-engine-startup-2] Initializing connection to database
2018-09-26 10:42:20,809 INFO [corp-000][AbstractSymmetricEngine][symmetric-engine-startup-1] Initializing connection to database
2018-09-26 10:42:21,715 INFO [store-001][JdbcDatabasePlatformFactory][symmetric-engine-startup-2] Detected database 'Microsoft SQL Server', version '12', protocol 'jtds'
2018-09-26 10:42:21,840 INFO [store-001][JdbcDatabasePlatformFactory][symmetric-engine-startup-2] The IDatabasePlatform being used is org.jumpmind.db.platform.mssql.MsSql2008DatabasePlatform
2018-09-26 10:42:22,246 INFO [corp-000][JdbcDatabasePlatformFactory][symmetric-engine-startup-1] Detected database 'Adaptive Server Enterprise', version '15', protocol 'sybase'
2018-09-26 10:42:22,293 INFO [corp-000][JdbcDatabasePlatformFactory][symmetric-engine-startup-1] The IDatabasePlatform being used is org.jumpmind.db.platform.ase.AseDatabasePlatform
2018-09-26 10:42:22,559 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] The DbDialect being used is org.jumpmind.symmetric.db.mssql.MsSqlSymmetricDialect
2018-09-26 10:42:22,574 INFO [corp-000][AseSymmetricDialect][symmetric-engine-startup-1] The DbDialect being used is org.jumpmind.symmetric.db.ase.AseSymmetricDialect
2018-09-26 10:42:22,746 INFO [store-001][ExtensionService][symmetric-engine-startup-2] Found 0 extension points from the database that will be registered
2018-09-26 10:42:22,762 INFO [store-001][StagingManager][symmetric-engine-startup-2] The staging directory was initialized at the following location: E:\symmetric-server-3.9.13\tmp\store-001
2018-09-26 10:42:22,777 INFO [corp-000][ExtensionService][symmetric-engine-startup-1] Found 0 extension points from the database that will be registered
2018-09-26 10:42:22,809 INFO [corp-000][StagingManager][symmetric-engine-startup-1] The staging directory was initialized at the following location: E:\symmetric-server-3.9.13\tmp\corp-000
2018-09-26 10:42:24,902 INFO [store-001][ExtensionService][symmetric-engine-startup-2] Found 0 extension points from the database that will be registered
2018-09-26 10:42:24,934 INFO [store-001][ClientExtensionService][symmetric-engine-startup-2] Found 7 extension points from spring that will be registered
2018-09-26 10:42:24,949 INFO [store-001][AbstractSymmetricEngine][symmetric-engine-startup-2] Initializing SymmetricDS database
2018-09-26 10:42:24,949 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] Checking if SymmetricDS tables need created or altered
2018-09-26 10:42:25,043 INFO [corp-000][ExtensionService][symmetric-engine-startup-1] Found 0 extension points from the database that will be registered
2018-09-26 10:42:25,043 INFO [corp-000][ClientExtensionService][symmetric-engine-startup-1] Found 7 extension points from spring that will be registered
2018-09-26 10:42:25,043 INFO [corp-000][AbstractSymmetricEngine][symmetric-engine-startup-1] Initializing SymmetricDS database
2018-09-26 10:42:25,043 INFO [corp-000][AseSymmetricDialect][symmetric-engine-startup-1] Checking if SymmetricDS tables need created or altered
2018-09-26 10:42:25,105 INFO [startup][SymmetricWebServer][main] Starting JMX HTTP console on port 31416
2018-09-26 10:42:25,152 INFO [startup][SymmetricWebServer][main] Joining the web server main thread
2018-09-26 10:42:26,027 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] There are SymmetricDS tables that needed altered
2018-09-26 10:42:26,027 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2018-09-26 10:42:26,074 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: DROP INDEX "sym_idx_ib_time_status" ON "facets540xts"."dbo"."sym_incoming_batch"
2018-09-26 10:42:26,090 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: DROP INDEX "sym_idx_nd_hst_chnl_sts" ON "facets540xts"."dbo"."sym_node_host_channel_stats"
2018-09-26 10:42:26,090 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: DROP INDEX "sym_idx_nd_hst_job" ON "facets540xts"."dbo"."sym_node_host_job_stats"
2018-09-26 10:42:26,090 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: DROP INDEX "sym_idx_nd_hst_sts" ON "facets540xts"."dbo"."sym_node_host_stats"
2018-09-26 10:42:26,090 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: DROP INDEX "sym_idx_trigg_hist_1" ON "facets540xts"."dbo"."sym_trigger_hist"
2018-09-26 10:42:26,121 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'F' AND name = 'sym_fk_cf_2_grp_lnk')
ALTER TABLE "sym_conflict" DROP CONSTRAINT "sym_fk_cf_2_grp_lnk"
2018-09-26 10:42:26,121 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'F' AND name = 'sym_fk_ftr_2_ftrg')
ALTER TABLE "sym_file_trigger_router" DROP CONSTRAINT "sym_fk_ftr_2_ftrg"
2018-09-26 10:42:26,121 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'F' AND name = 'sym_fk_ftr_2_rtr')
ALTER TABLE "sym_file_trigger_router" DROP CONSTRAINT "sym_fk_ftr_2_rtr"
2018-09-26 10:42:26,137 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'F' AND name = 'sym_fk_gpltlnk_2_gplt')
ALTER TABLE "sym_grouplet_link" DROP CONSTRAINT "sym_fk_gpltlnk_2_gplt"
2018-09-26 10:42:26,137 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'F' AND name = 'sym_fk_lnk_2_grp_src')
ALTER TABLE "sym_node_group_link" DROP CONSTRAINT "sym_fk_lnk_2_grp_src"
2018-09-26 10:42:26,152 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'F' AND name = 'sym_fk_lnk_2_grp_tgt')
ALTER TABLE "sym_node_group_link" DROP CONSTRAINT "sym_fk_lnk_2_grp_tgt"
2018-09-26 10:42:26,152 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'F' AND name = 'sym_fk_sec_2_node')
ALTER TABLE "sym_node_security" DROP CONSTRAINT "sym_fk_sec_2_node"
2018-09-26 10:42:26,152 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'F' AND name = 'sym_fk_rt_2_grp_lnk')
ALTER TABLE "sym_router" DROP CONSTRAINT "sym_fk_rt_2_grp_lnk"
2018-09-26 10:42:26,168 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'F' AND name = 'sym_fk_tt_2_grp_lnk')
ALTER TABLE "sym_transform_table" DROP CONSTRAINT "sym_fk_tt_2_grp_lnk"
2018-09-26 10:42:26,168 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'F' AND name = 'sym_fk_trg_2_chnl')
ALTER TABLE "sym_trigger" DROP CONSTRAINT "sym_fk_trg_2_chnl"
2018-09-26 10:42:26,184 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'F' AND name = 'sym_fk_trg_2_rld_chnl')
ALTER TABLE "sym_trigger" DROP CONSTRAINT "sym_fk_trg_2_rld_chnl"
2018-09-26 10:42:26,184 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'F' AND name = 'sym_fk_tr_2_trg')
ALTER TABLE "sym_trigger_router" DROP CONSTRAINT "sym_fk_tr_2_trg"
2018-09-26 10:42:26,184 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'F' AND name = 'sym_fk_tr_2_rtr')
ALTER TABLE "sym_trigger_router" DROP CONSTRAINT "sym_fk_tr_2_rtr"
2018-09-26 10:42:26,199 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'F' AND name = 'sym_fk_trgplt_2_gplt')
ALTER TABLE "sym_trigger_router_grouplet" DROP CONSTRAINT "sym_fk_trgplt_2_gplt"
2018-09-26 10:42:26,199 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'F' AND name = 'sym_fk_trgplt_2_tr')
ALTER TABLE "sym_trigger_router_grouplet" DROP CONSTRAINT "sym_fk_trgplt_2_tr"
2018-09-26 10:42:26,324 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_channel" ALTER COLUMN "create_time" DATETIME2
2018-09-26 10:42:26,324 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_channel" ALTER COLUMN "last_update_time" DATETIME2
2018-09-26 10:42:26,324 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_conflict" ALTER COLUMN "create_time" DATETIME2 NOT NULL
2018-09-26 10:42:26,324 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_conflict" ALTER COLUMN "last_update_time" DATETIME2 NOT NULL
2018-09-26 10:42:26,324 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_context" ALTER COLUMN "create_time" DATETIME2
2018-09-26 10:42:26,340 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_context" ALTER COLUMN "last_update_time" DATETIME2
2018-09-26 10:42:26,340 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_data" ALTER COLUMN "create_time" DATETIME2
2018-09-26 10:42:26,340 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_data_event" ALTER COLUMN "create_time" DATETIME2
2018-09-26 10:42:26,340 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_data_gap" ALTER COLUMN "create_time" DATETIME2 NOT NULL
2018-09-26 10:42:26,340 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_data_gap" ALTER COLUMN "last_update_time" DATETIME2 NOT NULL
2018-09-26 10:42:26,340 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_extension" ALTER COLUMN "create_time" DATETIME2
2018-09-26 10:42:26,340 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_extension" ALTER COLUMN "last_update_time" DATETIME2
2018-09-26 10:42:26,340 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_extract_request" ALTER COLUMN "last_update_time" DATETIME2
2018-09-26 10:42:26,355 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_extract_request" ALTER COLUMN "create_time" DATETIME2
2018-09-26 10:42:26,355 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_file_snapshot" ALTER COLUMN "last_update_time" DATETIME2 NOT NULL
2018-09-26 10:42:26,355 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_file_snapshot" ALTER COLUMN "create_time" DATETIME2 NOT NULL
2018-09-26 10:42:26,355 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_file_trigger" ALTER COLUMN "create_time" DATETIME2 NOT NULL
2018-09-26 10:42:26,355 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_file_trigger" ALTER COLUMN "last_update_time" DATETIME2 NOT NULL
2018-09-26 10:42:26,355 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_file_trigger_router" ALTER COLUMN "create_time" DATETIME2 NOT NULL
2018-09-26 10:42:26,371 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_file_trigger_router" ALTER COLUMN "last_update_time" DATETIME2 NOT NULL
2018-09-26 10:42:26,371 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_grouplet" ALTER COLUMN "create_time" DATETIME2 NOT NULL
2018-09-26 10:42:26,371 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_grouplet" ALTER COLUMN "last_update_time" DATETIME2 NOT NULL
2018-09-26 10:42:26,371 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_grouplet_link" ALTER COLUMN "create_time" DATETIME2 NOT NULL
2018-09-26 10:42:26,371 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_grouplet_link" ALTER COLUMN "last_update_time" DATETIME2 NOT NULL
2018-09-26 10:42:26,371 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_incoming_batch" ALTER COLUMN "last_update_time" DATETIME2
2018-09-26 10:42:26,387 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_incoming_batch" ALTER COLUMN "create_time" DATETIME2
2018-09-26 10:42:26,387 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_incoming_error" ALTER COLUMN "create_time" DATETIME2
2018-09-26 10:42:26,402 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_incoming_error" ALTER COLUMN "last_update_time" DATETIME2 NOT NULL
2018-09-26 10:42:26,402 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_job" ALTER COLUMN "create_time" DATETIME2
2018-09-26 10:42:26,402 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_job" ALTER COLUMN "last_update_time" DATETIME2
2018-09-26 10:42:26,402 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_load_filter" ALTER COLUMN "create_time" DATETIME2 NOT NULL
2018-09-26 10:42:26,402 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_load_filter" ALTER COLUMN "last_update_time" DATETIME2 NOT NULL
2018-09-26 10:42:26,418 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_lock" ALTER COLUMN "lock_time" DATETIME2
2018-09-26 10:42:26,418 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_lock" ALTER COLUMN "last_lock_time" DATETIME2
2018-09-26 10:42:26,418 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_node" ALTER COLUMN "heartbeat_time" DATETIME2
2018-09-26 10:42:26,434 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_node_communication" ALTER COLUMN "lock_time" DATETIME2
2018-09-26 10:42:26,434 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_node_communication" ALTER COLUMN "last_lock_time" DATETIME2
2018-09-26 10:42:26,434 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_node_channel_ctl" ALTER COLUMN "last_extract_time" DATETIME2
2018-09-26 10:42:26,434 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_node_group" ALTER COLUMN "create_time" DATETIME2
2018-09-26 10:42:26,434 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_node_group" ALTER COLUMN "last_update_time" DATETIME2
2018-09-26 10:42:26,434 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2018-09-26 10:42:26,449 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name = 'sym_node_group_channel_wnd')
BEGIN
DECLARE @tn33d71ac7_166168bb2cc__7ffe nvarchar(256), @cn33d71ac7_166168bb2cc__7ffd nvarchar(256)
DECLARE refcursor CURSOR FOR
SELECT object_name(objs.parent_obj) tablename, objs.name constraintname
FROM sysobjects objs
WHERE objs.xtype in ('C','D','F','UQ') AND object_name(objs.parent_obj) = 'sym_node_group_channel_wnd_' OPEN refcursor
FETCH NEXT FROM refcursor INTO @tn33d71ac7_166168bb2cc__7ffe, @cn33d71ac7_166168bb2cc__7ffd
WHILE @@FETCH_STATUS = 0
BEGIN
EXEC ('ALTER TABLE '+@tn33d71ac7_166168bb2cc__7ffe+' DROP CONSTRAINT '+@cn33d71ac7_166168bb2cc__7ffd)
FETCH NEXT FROM refcursor INTO @tn33d71ac7_166168bb2cc__7ffe, @cn33d71ac7_166168bb2cc__7ffd
END
CLOSE refcursor
DEALLOCATE refcursor
DROP TABLE "sym_node_group_channel_wnd_"
END
2018-09-26 10:42:26,449 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2018-09-26 10:42:26,449 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: CREATE TABLE "facets540xts"."dbo"."sym_node_group_channel_wnd_"(
"node_group_id" VARCHAR(50) NOT NULL,
"channel_id" VARCHAR(128) NOT NULL,
"start_time" VARCHAR(27) NOT NULL,
"end_time" VARCHAR(27) NOT NULL,
"enabled" SMALLINT DEFAULT 0 NOT NULL,
PRIMARY KEY ("node_group_id", "channel_id", "start_time", "end_time")
)
2018-09-26 10:42:26,465 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: INSERT INTO "facets540xts"."dbo"."sym_node_group_channel_wnd_" ("node_group_id","channel_id","start_time","end_time","enabled") SELECT "node_group_id","channel_id","start_time","end_time","enabled" FROM "facets540xts"."dbo"."sym_node_group_channel_wnd"
2018-09-26 10:42:26,465 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2018-09-26 10:42:26,480 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name = 'sym_node_group_channel_wnd')
BEGIN
DECLARE @tn33d71ac7_166168bb2cc__7ffc nvarchar(256), @cn33d71ac7_166168bb2cc__7ffb nvarchar(256)
DECLARE refcursor CURSOR FOR
SELECT object_name(objs.parent_obj) tablename, objs.name constraintname
FROM sysobjects objs
WHERE objs.xtype in ('C','D','F','UQ') AND object_name(objs.parent_obj) = 'sym_node_group_channel_wnd' OPEN refcursor
FETCH NEXT FROM refcursor INTO @tn33d71ac7_166168bb2cc__7ffc, @cn33d71ac7_166168bb2cc__7ffb
WHILE @@FETCH_STATUS = 0
BEGIN
EXEC ('ALTER TABLE '+@tn33d71ac7_166168bb2cc__7ffc+' DROP CONSTRAINT '+@cn33d71ac7_166168bb2cc__7ffb)
FETCH NEXT FROM refcursor INTO @tn33d71ac7_166168bb2cc__7ffc, @cn33d71ac7_166168bb2cc__7ffb
END
CLOSE refcursor
DEALLOCATE refcursor
DROP TABLE "sym_node_group_channel_wnd"
END
2018-09-26 10:42:26,480 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2018-09-26 10:42:26,480 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: CREATE TABLE "sym_node_group_channel_wnd"(
"node_group_id" VARCHAR(50) NOT NULL,
"channel_id" VARCHAR(128) NOT NULL,
"start_time" DATETIME2 NOT NULL,
"end_time" DATETIME2 NOT NULL,
"enabled" SMALLINT DEFAULT 0 NOT NULL,
PRIMARY KEY ("node_group_id", "channel_id", "start_time", "end_time")
)
2018-09-26 10:42:26,496 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: INSERT INTO "sym_node_group_channel_wnd" ("node_group_id","channel_id","start_time","end_time","enabled") SELECT "node_group_id","channel_id","start_time","end_time","enabled" FROM "facets540xts"."dbo"."sym_node_group_channel_wnd_"
2018-09-26 10:42:26,496 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2018-09-26 10:42:26,512 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name = 'sym_node_group_channel_wnd_')
BEGIN
DECLARE @tn33d71ac7_166168bb2cc__7ffa nvarchar(256), @cn33d71ac7_166168bb2cc__7ff9 nvarchar(256)
DECLARE refcursor CURSOR FOR
SELECT object_name(objs.parent_obj) tablename, objs.name constraintname
FROM sysobjects objs
WHERE objs.xtype in ('C','D','F','UQ') AND object_name(objs.parent_obj) = 'sym_node_group_channel_wnd_' OPEN refcursor
FETCH NEXT FROM refcursor INTO @tn33d71ac7_166168bb2cc__7ffa, @cn33d71ac7_166168bb2cc__7ff9
WHILE @@FETCH_STATUS = 0
BEGIN
EXEC ('ALTER TABLE '+@tn33d71ac7_166168bb2cc__7ffa+' DROP CONSTRAINT '+@cn33d71ac7_166168bb2cc__7ff9)
FETCH NEXT FROM refcursor INTO @tn33d71ac7_166168bb2cc__7ffa, @cn33d71ac7_166168bb2cc__7ff9
END
CLOSE refcursor
DEALLOCATE refcursor
DROP TABLE "sym_node_group_channel_wnd_"
END
2018-09-26 10:42:26,512 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_node_group_link" ALTER COLUMN "create_time" DATETIME2
2018-09-26 10:42:26,512 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_node_group_link" ALTER COLUMN "last_update_time" DATETIME2
2018-09-26 10:42:26,527 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_node_host" ALTER COLUMN "heartbeat_time" DATETIME2
2018-09-26 10:42:26,527 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_node_host" ALTER COLUMN "last_restart_time" DATETIME2 NOT NULL
2018-09-26 10:42:26,527 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_node_host" ALTER COLUMN "create_time" DATETIME2 NOT NULL
2018-09-26 10:42:26,527 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2018-09-26 10:42:26,543 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name = 'sym_node_host_channel_stats_')
BEGIN
DECLARE @tn33d71ac7_166168bb2cc__7ff6 nvarchar(256), @cn33d71ac7_166168bb2cc__7ff5 nvarchar(256)
DECLARE refcursor CURSOR FOR
SELECT object_name(objs.parent_obj) tablename, objs.name constraintname
FROM sysobjects objs
WHERE objs.xtype in ('C','D','F','UQ') AND object_name(objs.parent_obj) = 'sym_node_host_channel_stats_' OPEN refcursor
FETCH NEXT FROM refcursor INTO @tn33d71ac7_166168bb2cc__7ff6, @cn33d71ac7_166168bb2cc__7ff5
WHILE @@FETCH_STATUS = 0
BEGIN
EXEC ('ALTER TABLE '+@tn33d71ac7_166168bb2cc__7ff6+' DROP CONSTRAINT '+@cn33d71ac7_166168bb2cc__7ff5)
FETCH NEXT FROM refcursor INTO @tn33d71ac7_166168bb2cc__7ff6, @cn33d71ac7_166168bb2cc__7ff5
END
CLOSE refcursor
DEALLOCATE refcursor
DROP TABLE "sym_node_host_channel_stats_"
END
2018-09-26 10:42:26,543 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2018-09-26 10:42:26,543 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: CREATE TABLE "facets540xts"."dbo"."sym_node_host_channel_stats_"(
"node_id" VARCHAR(50) NOT NULL,
"host_name" VARCHAR(60) NOT NULL,
"channel_id" VARCHAR(128) NOT NULL,
"start_time" VARCHAR(27) NOT NULL,
"end_time" VARCHAR(27) NOT NULL,
"data_routed" BIGINT DEFAULT 0,
"data_unrouted" BIGINT DEFAULT 0,
"data_event_inserted" BIGINT DEFAULT 0,
"data_extracted" BIGINT DEFAULT 0,
"data_bytes_extracted" BIGINT DEFAULT 0,
"data_extracted_errors" BIGINT DEFAULT 0,
"data_bytes_sent" BIGINT DEFAULT 0,
"data_sent" BIGINT DEFAULT 0,
"data_sent_errors" BIGINT DEFAULT 0,
"data_loaded" BIGINT DEFAULT 0,
"data_bytes_loaded" BIGINT DEFAULT 0,
"data_loaded_errors" BIGINT DEFAULT 0,
PRIMARY KEY ("node_id", "host_name", "channel_id", "start_time", "end_time")
)
2018-09-26 10:42:26,543 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: INSERT INTO "facets540xts"."dbo"."sym_node_host_channel_stats_" ("node_id","host_name","channel_id","start_time","end_time","data_routed","data_unrouted","data_event_inserted","data_extracted","data_bytes_extracted","data_extracted_errors","data_bytes_sent","data_sent","data_sent_errors","data_loaded","data_bytes_loaded","data_loaded_errors") SELECT "node_id","host_name","channel_id","start_time","end_time","data_routed","data_unrouted","data_event_inserted","data_extracted","data_bytes_extracted","data_extracted_errors","data_bytes_sent","data_sent","data_sent_errors","data_loaded","data_bytes_loaded","data_loaded_errors" FROM "facets540xts"."dbo"."sym_node_host_channel_stats"
2018-09-26 10:42:26,559 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2018-09-26 10:42:26,605 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name = 'sym_node_host_channel_stats')
BEGIN
DECLARE @tn33d71ac7_166168bb2cc__7ff4 nvarchar(256), @cn33d71ac7_166168bb2cc__7ff3 nvarchar(256)
DECLARE refcursor CURSOR FOR
SELECT object_name(objs.parent_obj) tablename, objs.name constraintname
FROM sysobjects objs
WHERE objs.xtype in ('C','D','F','UQ') AND object_name(objs.parent_obj) = 'sym_node_host_channel_stats' OPEN refcursor
FETCH NEXT FROM refcursor INTO @tn33d71ac7_166168bb2cc__7ff4, @cn33d71ac7_166168bb2cc__7ff3
WHILE @@FETCH_STATUS = 0
BEGIN
EXEC ('ALTER TABLE '+@tn33d71ac7_166168bb2cc__7ff4+' DROP CONSTRAINT '+@cn33d71ac7_166168bb2cc__7ff3)
FETCH NEXT FROM refcursor INTO @tn33d71ac7_166168bb2cc__7ff4, @cn33d71ac7_166168bb2cc__7ff3
END
CLOSE refcursor
DEALLOCATE refcursor
DROP TABLE "sym_node_host_channel_stats"
END
2018-09-26 10:42:26,605 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2018-09-26 10:42:26,605 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: CREATE TABLE "sym_node_host_channel_stats"(
"node_id" VARCHAR(50) NOT NULL,
"host_name" VARCHAR(60) NOT NULL,
"channel_id" VARCHAR(128) NOT NULL,
"start_time" DATETIME2 NOT NULL,
"end_time" DATETIME2 NOT NULL,
"data_routed" BIGINT DEFAULT 0,
"data_unrouted" BIGINT DEFAULT 0,
"data_event_inserted" BIGINT DEFAULT 0,
"data_extracted" BIGINT DEFAULT 0,
"data_bytes_extracted" BIGINT DEFAULT 0,
"data_extracted_errors" BIGINT DEFAULT 0,
"data_bytes_sent" BIGINT DEFAULT 0,
"data_sent" BIGINT DEFAULT 0,
"data_sent_errors" BIGINT DEFAULT 0,
"data_loaded" BIGINT DEFAULT 0,
"data_bytes_loaded" BIGINT DEFAULT 0,
"data_loaded_errors" BIGINT DEFAULT 0,
PRIMARY KEY ("node_id", "host_name", "channel_id", "start_time", "end_time")
)
2018-09-26 10:42:26,621 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: INSERT INTO "sym_node_host_channel_stats" ("node_id","host_name","channel_id","start_time","end_time","data_routed","data_unrouted","data_event_inserted","data_extracted","data_bytes_extracted","data_extracted_errors","data_bytes_sent","data_sent","data_sent_errors","data_loaded","data_bytes_loaded","data_loaded_errors") SELECT "node_id","host_name","channel_id","start_time","end_time","data_routed","data_unrouted","data_event_inserted","data_extracted","data_bytes_extracted","data_extracted_errors","data_bytes_sent","data_sent","data_sent_errors","data_loaded","data_bytes_loaded","data_loaded_errors" FROM "facets540xts"."dbo"."sym_node_host_channel_stats_"
2018-09-26 10:42:26,621 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2018-09-26 10:42:26,715 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name = 'sym_node_host_channel_stats_')
BEGIN
DECLARE @tn33d71ac7_166168bb2cc__7ff2 nvarchar(256), @cn33d71ac7_166168bb2cc__7ff1 nvarchar(256)
DECLARE refcursor CURSOR FOR
SELECT object_name(objs.parent_obj) tablename, objs.name constraintname
FROM sysobjects objs
WHERE objs.xtype in ('C','D','F','UQ') AND object_name(objs.parent_obj) = 'sym_node_host_channel_stats_' OPEN refcursor
FETCH NEXT FROM refcursor INTO @tn33d71ac7_166168bb2cc__7ff2, @cn33d71ac7_166168bb2cc__7ff1
WHILE @@FETCH_STATUS = 0
BEGIN
EXEC ('ALTER TABLE '+@tn33d71ac7_166168bb2cc__7ff2+' DROP CONSTRAINT '+@cn33d71ac7_166168bb2cc__7ff1)
FETCH NEXT FROM refcursor INTO @tn33d71ac7_166168bb2cc__7ff2, @cn33d71ac7_166168bb2cc__7ff1
END
CLOSE refcursor
DEALLOCATE refcursor
DROP TABLE "sym_node_host_channel_stats_"
END
2018-09-26 10:42:26,715 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2018-09-26 10:42:26,730 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name = 'sym_node_host_job_stats_')
BEGIN
DECLARE @tn33d71ac7_166168bb2cc__7fee nvarchar(256), @cn33d71ac7_166168bb2cc__7fed nvarchar(256)
DECLARE refcursor CURSOR FOR
SELECT object_name(objs.parent_obj) tablename, objs.name constraintname
FROM sysobjects objs
WHERE objs.xtype in ('C','D','F','UQ') AND object_name(objs.parent_obj) = 'sym_node_host_job_stats_' OPEN refcursor
FETCH NEXT FROM refcursor INTO @tn33d71ac7_166168bb2cc__7fee, @cn33d71ac7_166168bb2cc__7fed
WHILE @@FETCH_STATUS = 0
BEGIN
EXEC ('ALTER TABLE '+@tn33d71ac7_166168bb2cc__7fee+' DROP CONSTRAINT '+@cn33d71ac7_166168bb2cc__7fed)
FETCH NEXT FROM refcursor INTO @tn33d71ac7_166168bb2cc__7fee, @cn33d71ac7_166168bb2cc__7fed
END
CLOSE refcursor
DEALLOCATE refcursor
DROP TABLE "sym_node_host_job_stats_"
END
2018-09-26 10:42:26,730 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2018-09-26 10:42:26,746 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: CREATE TABLE "facets540xts"."dbo"."sym_node_host_job_stats_"(
"node_id" VARCHAR(50) NOT NULL,
"host_name" VARCHAR(60) NOT NULL,
"job_name" VARCHAR(50) NOT NULL,
"start_time" VARCHAR(27) NOT NULL,
"end_time" VARCHAR(27) NOT NULL,
"processed_count" BIGINT DEFAULT 0,
"target_node_id" VARCHAR(50),
"target_node_count" INT DEFAULT 0,
PRIMARY KEY ("node_id", "host_name", "job_name", "start_time", "end_time")
)
2018-09-26 10:42:26,746 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: INSERT INTO "facets540xts"."dbo"."sym_node_host_job_stats_" ("node_id","host_name","job_name","start_time","end_time","processed_count","target_node_id","target_node_count") SELECT "node_id","host_name","job_name","start_time","end_time","processed_count","target_node_id","target_node_count" FROM "facets540xts"."dbo"."sym_node_host_job_stats"
2018-09-26 10:42:26,746 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2018-09-26 10:42:26,762 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name = 'sym_node_host_job_stats')
BEGIN
DECLARE @tn33d71ac7_166168bb2cc__7fec nvarchar(256), @cn33d71ac7_166168bb2cc__7feb nvarchar(256)
DECLARE refcursor CURSOR FOR
SELECT object_name(objs.parent_obj) tablename, objs.name constraintname
FROM sysobjects objs
WHERE objs.xtype in ('C','D','F','UQ') AND object_name(objs.parent_obj) = 'sym_node_host_job_stats' OPEN refcursor
FETCH NEXT FROM refcursor INTO @tn33d71ac7_166168bb2cc__7fec, @cn33d71ac7_166168bb2cc__7feb
WHILE @@FETCH_STATUS = 0
BEGIN
EXEC ('ALTER TABLE '+@tn33d71ac7_166168bb2cc__7fec+' DROP CONSTRAINT '+@cn33d71ac7_166168bb2cc__7feb)
FETCH NEXT FROM refcursor INTO @tn33d71ac7_166168bb2cc__7fec, @cn33d71ac7_166168bb2cc__7feb
END
CLOSE refcursor
DEALLOCATE refcursor
DROP TABLE "sym_node_host_job_stats"
END
2018-09-26 10:42:26,762 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2018-09-26 10:42:26,777 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: CREATE TABLE "sym_node_host_job_stats"(
"node_id" VARCHAR(50) NOT NULL,
"host_name" VARCHAR(60) NOT NULL,
"job_name" VARCHAR(50) NOT NULL,
"start_time" DATETIME2 NOT NULL,
"end_time" DATETIME2 NOT NULL,
"processed_count" BIGINT DEFAULT 0,
"target_node_id" VARCHAR(50),
"target_node_count" INT DEFAULT 0,
PRIMARY KEY ("node_id", "host_name", "job_name", "start_time", "end_time")
)
2018-09-26 10:42:26,777 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: INSERT INTO "sym_node_host_job_stats" ("node_id","host_name","job_name","start_time","end_time","processed_count","target_node_id","target_node_count") SELECT "node_id","host_name","job_name","start_time","end_time","processed_count","target_node_id","target_node_count" FROM "facets540xts"."dbo"."sym_node_host_job_stats_"
2018-09-26 10:42:26,777 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2018-09-26 10:42:26,793 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name = 'sym_node_host_job_stats_')
BEGIN
DECLARE @tn33d71ac7_166168bb2cc__7fea nvarchar(256), @cn33d71ac7_166168bb2cc__7fe9 nvarchar(256)
DECLARE refcursor CURSOR FOR
SELECT object_name(objs.parent_obj) tablename, objs.name constraintname
FROM sysobjects objs
WHERE objs.xtype in ('C','D','F','UQ') AND object_name(objs.parent_obj) = 'sym_node_host_job_stats_' OPEN refcursor
FETCH NEXT FROM refcursor INTO @tn33d71ac7_166168bb2cc__7fea, @cn33d71ac7_166168bb2cc__7fe9
WHILE @@FETCH_STATUS = 0
BEGIN
EXEC ('ALTER TABLE '+@tn33d71ac7_166168bb2cc__7fea+' DROP CONSTRAINT '+@cn33d71ac7_166168bb2cc__7fe9)
FETCH NEXT FROM refcursor INTO @tn33d71ac7_166168bb2cc__7fea, @cn33d71ac7_166168bb2cc__7fe9
END
CLOSE refcursor
DEALLOCATE refcursor
DROP TABLE "sym_node_host_job_stats_"
END
2018-09-26 10:42:26,793 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2018-09-26 10:42:26,809 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name = 'sym_node_host_stats_')
BEGIN
DECLARE @tn33d71ac7_166168bb2cc__7fe6 nvarchar(256), @cn33d71ac7_166168bb2cc__7fe5 nvarchar(256)
DECLARE refcursor CURSOR FOR
SELECT object_name(objs.parent_obj) tablename, objs.name constraintname
FROM sysobjects objs
WHERE objs.xtype in ('C','D','F','UQ') AND object_name(objs.parent_obj) = 'sym_node_host_stats_' OPEN refcursor
FETCH NEXT FROM refcursor INTO @tn33d71ac7_166168bb2cc__7fe6, @cn33d71ac7_166168bb2cc__7fe5
WHILE @@FETCH_STATUS = 0
BEGIN
EXEC ('ALTER TABLE '+@tn33d71ac7_166168bb2cc__7fe6+' DROP CONSTRAINT '+@cn33d71ac7_166168bb2cc__7fe5)
FETCH NEXT FROM refcursor INTO @tn33d71ac7_166168bb2cc__7fe6, @cn33d71ac7_166168bb2cc__7fe5
END
CLOSE refcursor
DEALLOCATE refcursor
DROP TABLE "sym_node_host_stats_"
END
2018-09-26 10:42:26,809 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2018-09-26 10:42:26,824 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: CREATE TABLE "facets540xts"."dbo"."sym_node_host_stats_"(
"node_id" VARCHAR(50) NOT NULL,
"host_name" VARCHAR(60) NOT NULL,
"start_time" VARCHAR(27) NOT NULL,
"end_time" VARCHAR(27) NOT NULL,
"restarted" BIGINT DEFAULT 0 NOT NULL,
"nodes_pulled" BIGINT DEFAULT 0,
"total_nodes_pull_time" BIGINT DEFAULT 0,
"nodes_pushed" BIGINT DEFAULT 0,
"total_nodes_push_time" BIGINT DEFAULT 0,
"nodes_rejected" BIGINT DEFAULT 0,
"nodes_registered" BIGINT DEFAULT 0,
"nodes_loaded" BIGINT DEFAULT 0,
"nodes_disabled" BIGINT DEFAULT 0,
"purged_data_rows" BIGINT DEFAULT 0,
"purged_data_event_rows" BIGINT DEFAULT 0,
"purged_batch_outgoing_rows" BIGINT DEFAULT 0,
"purged_batch_incoming_rows" BIGINT DEFAULT 0,
"triggers_created_count" BIGINT,
"triggers_rebuilt_count" BIGINT,
"triggers_removed_count" BIGINT,
PRIMARY KEY ("node_id", "host_name", "start_time", "end_time")
)
2018-09-26 10:42:26,824 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: INSERT INTO "facets540xts"."dbo"."sym_node_host_stats_" ("node_id","host_name","start_time","end_time","restarted","nodes_pulled","total_nodes_pull_time","nodes_pushed","total_nodes_push_time","nodes_rejected","nodes_registered","nodes_loaded","nodes_disabled","purged_data_rows","purged_data_event_rows","purged_batch_outgoing_rows","purged_batch_incoming_rows","triggers_created_count","triggers_rebuilt_count","triggers_removed_count") SELECT "node_id","host_name","start_time","end_time","restarted","nodes_pulled","total_nodes_pull_time","nodes_pushed","total_nodes_push_time","nodes_rejected","nodes_registered","nodes_loaded","nodes_disabled","purged_data_rows","purged_data_event_rows","purged_batch_outgoing_rows","purged_batch_incoming_rows","triggers_created_count","triggers_rebuilt_count","triggers_removed_count" FROM "facets540xts"."dbo"."sym_node_host_stats"
2018-09-26 10:42:26,824 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2018-09-26 10:42:26,855 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name = 'sym_node_host_stats')
BEGIN
DECLARE @tn33d71ac7_166168bb2cc__7fe4 nvarchar(256), @cn33d71ac7_166168bb2cc__7fe3 nvarchar(256)
DECLARE refcursor CURSOR FOR
SELECT object_name(objs.parent_obj) tablename, objs.name constraintname
FROM sysobjects objs
WHERE objs.xtype in ('C','D','F','UQ') AND object_name(objs.parent_obj) = 'sym_node_host_stats' OPEN refcursor
FETCH NEXT FROM refcursor INTO @tn33d71ac7_166168bb2cc__7fe4, @cn33d71ac7_166168bb2cc__7fe3
WHILE @@FETCH_STATUS = 0
BEGIN
EXEC ('ALTER TABLE '+@tn33d71ac7_166168bb2cc__7fe4+' DROP CONSTRAINT '+@cn33d71ac7_166168bb2cc__7fe3)
FETCH NEXT FROM refcursor INTO @tn33d71ac7_166168bb2cc__7fe4, @cn33d71ac7_166168bb2cc__7fe3
END
CLOSE refcursor
DEALLOCATE refcursor
DROP TABLE "sym_node_host_stats"
END
2018-09-26 10:42:26,855 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2018-09-26 10:42:26,871 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: CREATE TABLE "sym_node_host_stats"(
"node_id" VARCHAR(50) NOT NULL,
"host_name" VARCHAR(60) NOT NULL,
"start_time" DATETIME2 NOT NULL,
"end_time" DATETIME2 NOT NULL,
"restarted" BIGINT DEFAULT 0 NOT NULL,
"nodes_pulled" BIGINT DEFAULT 0,
"total_nodes_pull_time" BIGINT DEFAULT 0,
"nodes_pushed" BIGINT DEFAULT 0,
"total_nodes_push_time" BIGINT DEFAULT 0,
"nodes_rejected" BIGINT DEFAULT 0,
"nodes_registered" BIGINT DEFAULT 0,
"nodes_loaded" BIGINT DEFAULT 0,
"nodes_disabled" BIGINT DEFAULT 0,
"purged_data_rows" BIGINT DEFAULT 0,
"purged_data_event_rows" BIGINT DEFAULT 0,
"purged_batch_outgoing_rows" BIGINT DEFAULT 0,
"purged_batch_incoming_rows" BIGINT DEFAULT 0,
"triggers_created_count" BIGINT,
"triggers_rebuilt_count" BIGINT,
"triggers_removed_count" BIGINT,
PRIMARY KEY ("node_id", "host_name", "start_time", "end_time")
)
2018-09-26 10:42:26,871 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: INSERT INTO "sym_node_host_stats" ("node_id","host_name","start_time","end_time","restarted","nodes_pulled","total_nodes_pull_time","nodes_pushed","total_nodes_push_time","nodes_rejected","nodes_registered","nodes_loaded","nodes_disabled","purged_data_rows","purged_data_event_rows","purged_batch_outgoing_rows","purged_batch_incoming_rows","triggers_created_count","triggers_rebuilt_count","triggers_removed_count") SELECT "node_id","host_name","start_time","end_time","restarted","nodes_pulled","total_nodes_pull_time","nodes_pushed","total_nodes_push_time","nodes_rejected","nodes_registered","nodes_loaded","nodes_disabled","purged_data_rows","purged_data_event_rows","purged_batch_outgoing_rows","purged_batch_incoming_rows","triggers_created_count","triggers_rebuilt_count","triggers_removed_count" FROM "facets540xts"."dbo"."sym_node_host_stats_"
2018-09-26 10:42:26,871 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2018-09-26 10:42:26,902 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name = 'sym_node_host_stats_')
BEGIN
DECLARE @tn33d71ac7_166168bb2cc__7fe2 nvarchar(256), @cn33d71ac7_166168bb2cc__7fe1 nvarchar(256)
DECLARE refcursor CURSOR FOR
SELECT object_name(objs.parent_obj) tablename, objs.name constraintname
FROM sysobjects objs
WHERE objs.xtype in ('C','D','F','UQ') AND object_name(objs.parent_obj) = 'sym_node_host_stats_' OPEN refcursor
FETCH NEXT FROM refcursor INTO @tn33d71ac7_166168bb2cc__7fe2, @cn33d71ac7_166168bb2cc__7fe1
WHILE @@FETCH_STATUS = 0
BEGIN
EXEC ('ALTER TABLE '+@tn33d71ac7_166168bb2cc__7fe2+' DROP CONSTRAINT '+@cn33d71ac7_166168bb2cc__7fe1)
FETCH NEXT FROM refcursor INTO @tn33d71ac7_166168bb2cc__7fe2, @cn33d71ac7_166168bb2cc__7fe1
END
CLOSE refcursor
DEALLOCATE refcursor
DROP TABLE "sym_node_host_stats_"
END
2018-09-26 10:42:26,902 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_node_security" ALTER COLUMN "registration_time" DATETIME2
2018-09-26 10:42:26,902 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_node_security" ALTER COLUMN "initial_load_time" DATETIME2
2018-09-26 10:42:26,918 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_node_security" ALTER COLUMN "rev_initial_load_time" DATETIME2
2018-09-26 10:42:26,918 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_monitor" ALTER COLUMN "create_time" DATETIME2
2018-09-26 10:42:26,918 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_monitor" ALTER COLUMN "last_update_time" DATETIME2
2018-09-26 10:42:26,918 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2018-09-26 10:42:26,934 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name = 'sym_monitor_event_')
BEGIN
DECLARE @tn33d71ac7_166168bb2cc__7fde nvarchar(256), @cn33d71ac7_166168bb2cc__7fdd nvarchar(256)
DECLARE refcursor CURSOR FOR
SELECT object_name(objs.parent_obj) tablename, objs.name constraintname
FROM sysobjects objs
WHERE objs.xtype in ('C','D','F','UQ') AND object_name(objs.parent_obj) = 'sym_monitor_event_' OPEN refcursor
FETCH NEXT FROM refcursor INTO @tn33d71ac7_166168bb2cc__7fde, @cn33d71ac7_166168bb2cc__7fdd
WHILE @@FETCH_STATUS = 0
BEGIN
EXEC ('ALTER TABLE '+@tn33d71ac7_166168bb2cc__7fde+' DROP CONSTRAINT '+@cn33d71ac7_166168bb2cc__7fdd)
FETCH NEXT FROM refcursor INTO @tn33d71ac7_166168bb2cc__7fde, @cn33d71ac7_166168bb2cc__7fdd
END
CLOSE refcursor
DEALLOCATE refcursor
DROP TABLE "sym_monitor_event_"
END
2018-09-26 10:42:26,934 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2018-09-26 10:42:26,934 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: CREATE TABLE "facets540xts"."dbo"."sym_monitor_event_"(
"monitor_id" VARCHAR(128) NOT NULL,
"node_id" VARCHAR(50) NOT NULL,
"event_time" VARCHAR(27) NOT NULL,
"host_name" VARCHAR(60),
"type" VARCHAR(50) NOT NULL,
"threshold" BIGINT DEFAULT 0 NOT NULL,
"event_value" BIGINT DEFAULT 0 NOT NULL,
"event_count" INT DEFAULT 0 NOT NULL,
"severity_level" INT DEFAULT 0 NOT NULL,
"is_resolved" SMALLINT DEFAULT 0 NOT NULL,
"is_notified" SMALLINT DEFAULT 0 NOT NULL,
"details" TEXT,
"last_update_time" VARCHAR(27),
PRIMARY KEY ("monitor_id", "node_id", "event_time")
)
2018-09-26 10:42:26,934 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: INSERT INTO "facets540xts"."dbo"."sym_monitor_event_" ("monitor_id","node_id","event_time","host_name","type","threshold","event_value","event_count","severity_level","is_resolved","is_notified","details","last_update_time") SELECT "monitor_id","node_id","event_time","host_name","type","threshold","event_value","event_count","severity_level","is_resolved","is_notified","details","last_update_time" FROM "facets540xts"."dbo"."sym_monitor_event"
2018-09-26 10:42:26,934 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2018-09-26 10:42:26,965 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name = 'sym_monitor_event')
BEGIN
DECLARE @tn33d71ac7_166168bb2cc__7fdc nvarchar(256), @cn33d71ac7_166168bb2cc__7fdb nvarchar(256)
DECLARE refcursor CURSOR FOR
SELECT object_name(objs.parent_obj) tablename, objs.name constraintname
FROM sysobjects objs
WHERE objs.xtype in ('C','D','F','UQ') AND object_name(objs.parent_obj) = 'sym_monitor_event' OPEN refcursor
FETCH NEXT FROM refcursor INTO @tn33d71ac7_166168bb2cc__7fdc, @cn33d71ac7_166168bb2cc__7fdb
WHILE @@FETCH_STATUS = 0
BEGIN
EXEC ('ALTER TABLE '+@tn33d71ac7_166168bb2cc__7fdc+' DROP CONSTRAINT '+@cn33d71ac7_166168bb2cc__7fdb)
FETCH NEXT FROM refcursor INTO @tn33d71ac7_166168bb2cc__7fdc, @cn33d71ac7_166168bb2cc__7fdb
END
CLOSE refcursor
DEALLOCATE refcursor
DROP TABLE "sym_monitor_event"
END
2018-09-26 10:42:26,965 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2018-09-26 10:42:26,965 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: CREATE TABLE "sym_monitor_event"(
"monitor_id" VARCHAR(128) NOT NULL,
"node_id" VARCHAR(50) NOT NULL,
"event_time" DATETIME2 NOT NULL,
"host_name" VARCHAR(60),
"type" VARCHAR(50) NOT NULL,
"threshold" BIGINT DEFAULT 0 NOT NULL,
"event_value" BIGINT DEFAULT 0 NOT NULL,
"event_count" INT DEFAULT 0 NOT NULL,
"severity_level" INT DEFAULT 0 NOT NULL,
"is_resolved" SMALLINT DEFAULT 0 NOT NULL,
"is_notified" SMALLINT DEFAULT 0 NOT NULL,
"details" TEXT,
"last_update_time" DATETIME2,
PRIMARY KEY ("monitor_id", "node_id", "event_time")
)
2018-09-26 10:42:26,980 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: INSERT INTO "sym_monitor_event" ("monitor_id","node_id","event_time","host_name","type","threshold","event_value","event_count","severity_level","is_resolved","is_notified","details","last_update_time") SELECT "monitor_id","node_id","event_time","host_name","type","threshold","event_value","event_count","severity_level","is_resolved","is_notified","details","last_update_time" FROM "facets540xts"."dbo"."sym_monitor_event_"
2018-09-26 10:42:26,980 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2018-09-26 10:42:27,012 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name = 'sym_monitor_event_')
BEGIN
DECLARE @tn33d71ac7_166168bb2cc__7fda nvarchar(256), @cn33d71ac7_166168bb2cc__7fd9 nvarchar(256)
DECLARE refcursor CURSOR FOR
SELECT object_name(objs.parent_obj) tablename, objs.name constraintname
FROM sysobjects objs
WHERE objs.xtype in ('C','D','F','UQ') AND object_name(objs.parent_obj) = 'sym_monitor_event_' OPEN refcursor
FETCH NEXT FROM refcursor INTO @tn33d71ac7_166168bb2cc__7fda, @cn33d71ac7_166168bb2cc__7fd9
WHILE @@FETCH_STATUS = 0
BEGIN
EXEC ('ALTER TABLE '+@tn33d71ac7_166168bb2cc__7fda+' DROP CONSTRAINT '+@cn33d71ac7_166168bb2cc__7fd9)
FETCH NEXT FROM refcursor INTO @tn33d71ac7_166168bb2cc__7fda, @cn33d71ac7_166168bb2cc__7fd9
END
CLOSE refcursor
DEALLOCATE refcursor
DROP TABLE "sym_monitor_event_"
END
2018-09-26 10:42:27,012 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_notification" ALTER COLUMN "create_time" DATETIME2
2018-09-26 10:42:27,012 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_notification" ALTER COLUMN "last_update_time" DATETIME2
2018-09-26 10:42:27,012 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_outgoing_batch" ALTER COLUMN "last_update_time" DATETIME2
2018-09-26 10:42:27,012 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_outgoing_batch" ALTER COLUMN "create_time" DATETIME2
2018-09-26 10:42:27,027 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_outgoing_batch" ALTER COLUMN "extract_start_time" DATETIME2
2018-09-26 10:42:27,027 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_outgoing_batch" ALTER COLUMN "transfer_start_time" DATETIME2
2018-09-26 10:42:27,027 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_outgoing_batch" ALTER COLUMN "load_start_time" DATETIME2
2018-09-26 10:42:27,027 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_parameter" ALTER COLUMN "create_time" DATETIME2
2018-09-26 10:42:27,027 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_parameter" ALTER COLUMN "last_update_time" DATETIME2
2018-09-26 10:42:27,027 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2018-09-26 10:42:27,043 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name = 'sym_registration_request_')
BEGIN
DECLARE @tn33d71ac7_166168bb2cc__7fd6 nvarchar(256), @cn33d71ac7_166168bb2cc__7fd5 nvarchar(256)
DECLARE refcursor CURSOR FOR
SELECT object_name(objs.parent_obj) tablename, objs.name constraintname
FROM sysobjects objs
WHERE objs.xtype in ('C','D','F','UQ') AND object_name(objs.parent_obj) = 'sym_registration_request_' OPEN refcursor
FETCH NEXT FROM refcursor INTO @tn33d71ac7_166168bb2cc__7fd6, @cn33d71ac7_166168bb2cc__7fd5
WHILE @@FETCH_STATUS = 0
BEGIN
EXEC ('ALTER TABLE '+@tn33d71ac7_166168bb2cc__7fd6+' DROP CONSTRAINT '+@cn33d71ac7_166168bb2cc__7fd5)
FETCH NEXT FROM refcursor INTO @tn33d71ac7_166168bb2cc__7fd6, @cn33d71ac7_166168bb2cc__7fd5
END
CLOSE refcursor
DEALLOCATE refcursor
DROP TABLE "sym_registration_request_"
END
2018-09-26 10:42:27,043 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2018-09-26 10:42:27,043 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: CREATE TABLE "facets540xts"."dbo"."sym_registration_request_"(
"node_group_id" VARCHAR(50) NOT NULL,
"external_id" VARCHAR(255) NOT NULL,
"status" CHAR(2) NOT NULL,
"host_name" VARCHAR(60) NOT NULL,
"ip_address" VARCHAR(50) NOT NULL,
"attempt_count" INT DEFAULT 0,
"registered_node_id" VARCHAR(50),
"error_message" TEXT,
"create_time" VARCHAR(27) NOT NULL,
"last_update_by" VARCHAR(50),
"last_update_time" VARCHAR(27) NOT NULL,
PRIMARY KEY ("node_group_id", "external_id", "create_time")
)
2018-09-26 10:42:27,059 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: INSERT INTO "facets540xts"."dbo"."sym_registration_request_" ("node_group_id","external_id","status","host_name","ip_address","attempt_count","registered_node_id","error_message","create_time","last_update_by","last_update_time") SELECT "node_group_id","external_id","status","host_name","ip_address","attempt_count","registered_node_id","error_message","create_time","last_update_by","last_update_time" FROM "facets540xts"."dbo"."sym_registration_request"
2018-09-26 10:42:27,059 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2018-09-26 10:42:27,074 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name = 'sym_registration_request')
BEGIN
DECLARE @tn33d71ac7_166168bb2cc__7fd4 nvarchar(256), @cn33d71ac7_166168bb2cc__7fd3 nvarchar(256)
DECLARE refcursor CURSOR FOR
SELECT object_name(objs.parent_obj) tablename, objs.name constraintname
FROM sysobjects objs
WHERE objs.xtype in ('C','D','F','UQ') AND object_name(objs.parent_obj) = 'sym_registration_request' OPEN refcursor
FETCH NEXT FROM refcursor INTO @tn33d71ac7_166168bb2cc__7fd4, @cn33d71ac7_166168bb2cc__7fd3
WHILE @@FETCH_STATUS = 0
BEGIN
EXEC ('ALTER TABLE '+@tn33d71ac7_166168bb2cc__7fd4+' DROP CONSTRAINT '+@cn33d71ac7_166168bb2cc__7fd3)
FETCH NEXT FROM refcursor INTO @tn33d71ac7_166168bb2cc__7fd4, @cn33d71ac7_166168bb2cc__7fd3
END
CLOSE refcursor
DEALLOCATE refcursor
DROP TABLE "sym_registration_request"
END
2018-09-26 10:42:27,074 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2018-09-26 10:42:27,074 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: CREATE TABLE "sym_registration_request"(
"node_group_id" VARCHAR(50) NOT NULL,
"external_id" VARCHAR(255) NOT NULL,
"status" CHAR(2) NOT NULL,
"host_name" VARCHAR(60) NOT NULL,
"ip_address" VARCHAR(50) NOT NULL,
"attempt_count" INT DEFAULT 0,
"registered_node_id" VARCHAR(50),
"error_message" TEXT,
"create_time" DATETIME2 NOT NULL,
"last_update_by" VARCHAR(50),
"last_update_time" DATETIME2 NOT NULL,
PRIMARY KEY ("node_group_id", "external_id", "create_time")
)
2018-09-26 10:42:27,090 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: CREATE INDEX "sym_idx_reg_req_1" ON "sym_registration_request" ("node_group_id", "external_id", "status", "host_name", "ip_address")
2018-09-26 10:42:27,090 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: CREATE INDEX "sym_idx_reg_req_2" ON "sym_registration_request" ("status")
2018-09-26 10:42:27,090 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: INSERT INTO "sym_registration_request" ("node_group_id","external_id","status","host_name","ip_address","attempt_count","registered_node_id","error_message","create_time","last_update_by","last_update_time") SELECT "node_group_id","external_id","status","host_name","ip_address","attempt_count","registered_node_id","error_message","create_time","last_update_by","last_update_time" FROM "facets540xts"."dbo"."sym_registration_request_"
2018-09-26 10:42:27,090 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2018-09-26 10:42:27,105 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name = 'sym_registration_request_')
BEGIN
DECLARE @tn33d71ac7_166168bb2cc__7fd2 nvarchar(256), @cn33d71ac7_166168bb2cc__7fd1 nvarchar(256)
DECLARE refcursor CURSOR FOR
SELECT object_name(objs.parent_obj) tablename, objs.name constraintname
FROM sysobjects objs
WHERE objs.xtype in ('C','D','F','UQ') AND object_name(objs.parent_obj) = 'sym_registration_request_' OPEN refcursor
FETCH NEXT FROM refcursor INTO @tn33d71ac7_166168bb2cc__7fd2, @cn33d71ac7_166168bb2cc__7fd1
WHILE @@FETCH_STATUS = 0
BEGIN
EXEC ('ALTER TABLE '+@tn33d71ac7_166168bb2cc__7fd2+' DROP CONSTRAINT '+@cn33d71ac7_166168bb2cc__7fd1)
FETCH NEXT FROM refcursor INTO @tn33d71ac7_166168bb2cc__7fd2, @cn33d71ac7_166168bb2cc__7fd1
END
CLOSE refcursor
DEALLOCATE refcursor
DROP TABLE "sym_registration_request_"
END
2018-09-26 10:42:27,105 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_router" ALTER COLUMN "create_time" DATETIME2 NOT NULL
2018-09-26 10:42:27,105 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_router" ALTER COLUMN "last_update_time" DATETIME2 NOT NULL
2018-09-26 10:42:27,121 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_sequence" ALTER COLUMN "create_time" DATETIME2
2018-09-26 10:42:27,121 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_sequence" ALTER COLUMN "last_update_time" DATETIME2 NOT NULL
2018-09-26 10:42:27,121 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2018-09-26 10:42:27,121 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name = 'sym_table_reload_request_')
BEGIN
DECLARE @tn33d71ac7_166168bb2cc__7fce nvarchar(256), @cn33d71ac7_166168bb2cc__7fcd nvarchar(256)
DECLARE refcursor CURSOR FOR
SELECT object_name(objs.parent_obj) tablename, objs.name constraintname
FROM sysobjects objs
WHERE objs.xtype in ('C','D','F','UQ') AND object_name(objs.parent_obj) = 'sym_table_reload_request_' OPEN refcursor
FETCH NEXT FROM refcursor INTO @tn33d71ac7_166168bb2cc__7fce, @cn33d71ac7_166168bb2cc__7fcd
WHILE @@FETCH_STATUS = 0
BEGIN
EXEC ('ALTER TABLE '+@tn33d71ac7_166168bb2cc__7fce+' DROP CONSTRAINT '+@cn33d71ac7_166168bb2cc__7fcd)
FETCH NEXT FROM refcursor INTO @tn33d71ac7_166168bb2cc__7fce, @cn33d71ac7_166168bb2cc__7fcd
END
CLOSE refcursor
DEALLOCATE refcursor
DROP TABLE "sym_table_reload_request_"
END
2018-09-26 10:42:27,121 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2018-09-26 10:42:27,137 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: CREATE TABLE "facets540xts"."dbo"."sym_table_reload_request_"(
"target_node_id" VARCHAR(50) NOT NULL,
"source_node_id" VARCHAR(50) NOT NULL,
"trigger_id" VARCHAR(128) NOT NULL,
"router_id" VARCHAR(50) NOT NULL,
"create_time" VARCHAR(27) NOT NULL,
"create_table" SMALLINT DEFAULT 0 NOT NULL,
"delete_first" SMALLINT DEFAULT 0 NOT NULL,
"reload_select" TEXT,
"before_custom_sql" TEXT,
"reload_time" VARCHAR(27),
"load_id" BIGINT,
"processed" SMALLINT DEFAULT 0 NOT NULL,
"channel_id" VARCHAR(128),
"last_update_by" VARCHAR(50),
"last_update_time" VARCHAR(27) NOT NULL,
PRIMARY KEY ("target_node_id", "source_node_id", "trigger_id", "router_id", "create_time")
)
2018-09-26 10:42:27,137 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: INSERT INTO "facets540xts"."dbo"."sym_table_reload_request_" ("target_node_id","source_node_id","trigger_id","router_id","create_time","create_table","delete_first","reload_select","before_custom_sql","reload_time","load_id","processed","channel_id","last_update_by","last_update_time") SELECT "target_node_id","source_node_id","trigger_id","router_id","create_time","create_table","delete_first","reload_select","before_custom_sql","reload_time","load_id","processed","channel_id","last_update_by","last_update_time" FROM "facets540xts"."dbo"."sym_table_reload_request"
2018-09-26 10:42:27,137 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2018-09-26 10:42:27,152 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name = 'sym_table_reload_request')
BEGIN
DECLARE @tn33d71ac7_166168bb2cc__7fcc nvarchar(256), @cn33d71ac7_166168bb2cc__7fcb nvarchar(256)
DECLARE refcursor CURSOR FOR
SELECT object_name(objs.parent_obj) tablename, objs.name constraintname
FROM sysobjects objs
WHERE objs.xtype in ('C','D','F','UQ') AND object_name(objs.parent_obj) = 'sym_table_reload_request' OPEN refcursor
FETCH NEXT FROM refcursor INTO @tn33d71ac7_166168bb2cc__7fcc, @cn33d71ac7_166168bb2cc__7fcb
WHILE @@FETCH_STATUS = 0
BEGIN
EXEC ('ALTER TABLE '+@tn33d71ac7_166168bb2cc__7fcc+' DROP CONSTRAINT '+@cn33d71ac7_166168bb2cc__7fcb)
FETCH NEXT FROM refcursor INTO @tn33d71ac7_166168bb2cc__7fcc, @cn33d71ac7_166168bb2cc__7fcb
END
CLOSE refcursor
DEALLOCATE refcursor
DROP TABLE "sym_table_reload_request"
END
2018-09-26 10:42:27,168 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2018-09-26 10:42:27,168 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: CREATE TABLE "sym_table_reload_request"(
"target_node_id" VARCHAR(50) NOT NULL,
"source_node_id" VARCHAR(50) NOT NULL,
"trigger_id" VARCHAR(128) NOT NULL,
"router_id" VARCHAR(50) NOT NULL,
"create_time" DATETIME2 NOT NULL,
"create_table" SMALLINT DEFAULT 0 NOT NULL,
"delete_first" SMALLINT DEFAULT 0 NOT NULL,
"reload_select" TEXT,
"before_custom_sql" TEXT,
"reload_time" DATETIME2,
"load_id" BIGINT,
"processed" SMALLINT DEFAULT 0 NOT NULL,
"channel_id" VARCHAR(128),
"last_update_by" VARCHAR(50),
"last_update_time" DATETIME2 NOT NULL,
PRIMARY KEY ("target_node_id", "source_node_id", "trigger_id", "router_id", "create_time")
)
2018-09-26 10:42:27,168 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: INSERT INTO "sym_table_reload_request" ("target_node_id","source_node_id","trigger_id","router_id","create_time","create_table","delete_first","reload_select","before_custom_sql","reload_time","load_id","processed","channel_id","last_update_by","last_update_time") SELECT "target_node_id","source_node_id","trigger_id","router_id","create_time","create_table","delete_first","reload_select","before_custom_sql","reload_time","load_id","processed","channel_id","last_update_by","last_update_time" FROM "facets540xts"."dbo"."sym_table_reload_request_"
2018-09-26 10:42:27,184 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2018-09-26 10:42:27,199 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name = 'sym_table_reload_request_')
BEGIN
DECLARE @tn33d71ac7_166168bb2cc__7fca nvarchar(256), @cn33d71ac7_166168bb2cc__7fc9 nvarchar(256)
DECLARE refcursor CURSOR FOR
SELECT object_name(objs.parent_obj) tablename, objs.name constraintname
FROM sysobjects objs
WHERE objs.xtype in ('C','D','F','UQ') AND object_name(objs.parent_obj) = 'sym_table_reload_request_' OPEN refcursor
FETCH NEXT FROM refcursor INTO @tn33d71ac7_166168bb2cc__7fca, @cn33d71ac7_166168bb2cc__7fc9
WHILE @@FETCH_STATUS = 0
BEGIN
EXEC ('ALTER TABLE '+@tn33d71ac7_166168bb2cc__7fca+' DROP CONSTRAINT '+@cn33d71ac7_166168bb2cc__7fc9)
FETCH NEXT FROM refcursor INTO @tn33d71ac7_166168bb2cc__7fca, @cn33d71ac7_166168bb2cc__7fc9
END
CLOSE refcursor
DEALLOCATE refcursor
DROP TABLE "sym_table_reload_request_"
END
2018-09-26 10:42:27,199 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_transform_table" ALTER COLUMN "create_time" DATETIME2
2018-09-26 10:42:27,199 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_transform_table" ALTER COLUMN "last_update_time" DATETIME2
2018-09-26 10:42:27,199 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_transform_column" ALTER COLUMN "create_time" DATETIME2
2018-09-26 10:42:27,215 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_transform_column" ALTER COLUMN "last_update_time" DATETIME2
2018-09-26 10:42:27,215 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_trigger" ALTER COLUMN "create_time" DATETIME2 NOT NULL
2018-09-26 10:42:27,215 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_trigger" ALTER COLUMN "last_update_time" DATETIME2 NOT NULL
2018-09-26 10:42:27,215 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_trigger_hist" ALTER COLUMN "create_time" DATETIME2 NOT NULL
2018-09-26 10:42:27,215 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_trigger_hist" ALTER COLUMN "inactive_time" DATETIME2
2018-09-26 10:42:27,215 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_trigger_router" ALTER COLUMN "create_time" DATETIME2 NOT NULL
2018-09-26 10:42:27,215 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_trigger_router" ALTER COLUMN "last_update_time" DATETIME2 NOT NULL
2018-09-26 10:42:27,215 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_trigger_router_grouplet" ALTER COLUMN "create_time" DATETIME2 NOT NULL
2018-09-26 10:42:27,215 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_trigger_router_grouplet" ALTER COLUMN "last_update_time" DATETIME2 NOT NULL
2018-09-26 10:42:27,230 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: ALTER TABLE "sym_conflict"
ADD CONSTRAINT "sym_fk_cf_2_grp_lnk" FOREIGN KEY ("source_node_group_id", "target_node_group_id") REFERENCES "sym_node_group_link" ("source_node_group_id", "target_node_group_id")
2018-09-26 10:42:27,230 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: ALTER TABLE "sym_file_trigger_router"
ADD CONSTRAINT "sym_fk_ftr_2_ftrg" FOREIGN KEY ("trigger_id") REFERENCES "sym_file_trigger" ("trigger_id")
2018-09-26 10:42:27,230 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: ALTER TABLE "sym_file_trigger_router"
ADD CONSTRAINT "sym_fk_ftr_2_rtr" FOREIGN KEY ("router_id") REFERENCES "sym_router" ("router_id")
2018-09-26 10:42:27,230 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: ALTER TABLE "sym_grouplet_link"
ADD CONSTRAINT "sym_fk_gpltlnk_2_gplt" FOREIGN KEY ("grouplet_id") REFERENCES "sym_grouplet" ("grouplet_id")
2018-09-26 10:42:27,230 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: ALTER TABLE "sym_node_group_link"
ADD CONSTRAINT "sym_fk_lnk_2_grp_src" FOREIGN KEY ("source_node_group_id") REFERENCES "sym_node_group" ("node_group_id")
2018-09-26 10:42:27,230 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: ALTER TABLE "sym_node_group_link"
ADD CONSTRAINT "sym_fk_lnk_2_grp_tgt" FOREIGN KEY ("target_node_group_id") REFERENCES "sym_node_group" ("node_group_id")
2018-09-26 10:42:27,246 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: ALTER TABLE "sym_node_security"
ADD CONSTRAINT "sym_fk_sec_2_node" FOREIGN KEY ("node_id") REFERENCES "sym_node" ("node_id")
2018-09-26 10:42:27,246 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: ALTER TABLE "sym_router"
ADD CONSTRAINT "sym_fk_rt_2_grp_lnk" FOREIGN KEY ("source_node_group_id", "target_node_group_id") REFERENCES "sym_node_group_link" ("source_node_group_id", "target_node_group_id")
2018-09-26 10:42:27,246 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: ALTER TABLE "sym_transform_table"
ADD CONSTRAINT "sym_fk_tt_2_grp_lnk" FOREIGN KEY ("source_node_group_id", "target_node_group_id") REFERENCES "sym_node_group_link" ("source_node_group_id", "target_node_group_id")
2018-09-26 10:42:27,246 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: ALTER TABLE "sym_trigger"
ADD CONSTRAINT "sym_fk_trg_2_chnl" FOREIGN KEY ("channel_id") REFERENCES "sym_channel" ("channel_id")
2018-09-26 10:42:27,246 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: ALTER TABLE "sym_trigger"
ADD CONSTRAINT "sym_fk_trg_2_rld_chnl" FOREIGN KEY ("reload_channel_id") REFERENCES "sym_channel" ("channel_id")
2018-09-26 10:42:27,246 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: ALTER TABLE "sym_trigger_router"
ADD CONSTRAINT "sym_fk_tr_2_trg" FOREIGN KEY ("trigger_id") REFERENCES "sym_trigger" ("trigger_id")
2018-09-26 10:42:27,262 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: ALTER TABLE "sym_trigger_router"
ADD CONSTRAINT "sym_fk_tr_2_rtr" FOREIGN KEY ("router_id") REFERENCES "sym_router" ("router_id")
2018-09-26 10:42:27,262 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: ALTER TABLE "sym_trigger_router_grouplet"
ADD CONSTRAINT "sym_fk_trgplt_2_gplt" FOREIGN KEY ("grouplet_id") REFERENCES "sym_grouplet" ("grouplet_id")
2018-09-26 10:42:27,262 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: ALTER TABLE "sym_trigger_router_grouplet"
ADD CONSTRAINT "sym_fk_trgplt_2_tr" FOREIGN KEY ("trigger_id", "router_id") REFERENCES "sym_trigger_router" ("trigger_id", "router_id")
2018-09-26 10:42:27,262 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: CREATE INDEX "sym_idx_ib_time_status" ON "facets540xts"."dbo"."sym_incoming_batch" ("create_time", "status")
2018-09-26 10:42:27,277 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: CREATE INDEX "sym_idx_nd_hst_chnl_sts" ON "facets540xts"."dbo"."sym_node_host_channel_stats" ("node_id", "start_time", "end_time")
2018-09-26 10:42:27,277 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: CREATE INDEX "sym_idx_nd_hst_job" ON "facets540xts"."dbo"."sym_node_host_job_stats" ("node_id", "start_time", "end_time")
2018-09-26 10:42:27,277 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: CREATE INDEX "sym_idx_nd_hst_sts" ON "facets540xts"."dbo"."sym_node_host_stats" ("node_id", "start_time", "end_time")
2018-09-26 10:42:27,277 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] DDL applied: CREATE INDEX "sym_idx_trigg_hist_1" ON "facets540xts"."dbo"."sym_trigger_hist" ("trigger_id", "inactive_time")
2018-09-26 10:42:27,277 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] Done with auto update of SymmetricDS tables
2018-09-26 10:42:27,293 INFO [store-001][MsSqlSymmetricDialect][symmetric-engine-startup-2] Updating indexes to prevent lock escalation
2018-09-26 10:42:27,355 INFO [store-001][ConfigurationService][symmetric-engine-startup-2] Auto-configuring config channel
2018-09-26 10:42:27,402 INFO [store-001][ConfigurationService][symmetric-engine-startup-2] Auto-configuring reload channel
2018-09-26 10:42:27,402 INFO [store-001][ConfigurationService][symmetric-engine-startup-2] Auto-configuring monitor channel
2018-09-26 10:42:27,402 INFO [store-001][ConfigurationService][symmetric-engine-startup-2] Auto-configuring heartbeat channel
2018-09-26 10:42:27,402 INFO [store-001][ConfigurationService][symmetric-engine-startup-2] Auto-configuring default channel
2018-09-26 10:42:27,418 INFO [store-001][ConfigurationService][symmetric-engine-startup-2] Auto-configuring dynamic channel
2018-09-26 10:42:27,465 INFO [store-001][AbstractSymmetricEngine][symmetric-engine-startup-2] Done initializing SymmetricDS database
2018-09-26 10:42:27,465 INFO [store-001][AbstractSymmetricEngine][symmetric-engine-startup-2] SymmetricDS database version : null
2018-09-26 10:42:27,465 INFO [store-001][AbstractSymmetricEngine][symmetric-engine-startup-2] SymmetricDS software version : 3.9.13
2018-09-26 10:42:27,480 INFO [store-001][AbstractSymmetricEngine][symmetric-engine-startup-2] Starting unregistered node [group=store, externalId=001]
2018-09-26 10:42:27,512 INFO [store-001][RouterJob][symmetric-engine-startup-2] Starting Routing on periodic schedule: every 5000ms with the first run at Wed Sep 26 10:42:34 CDT 2018
2018-09-26 10:42:27,527 INFO [store-001][PushJob][symmetric-engine-startup-2] Starting Push on periodic schedule: every 10000ms with the first run at Wed Sep 26 10:42:34 CDT 2018
2018-09-26 10:42:27,527 ERROR [store-001][AbstractSymmetricEngine][symmetric-engine-startup-2] An error occurred while starting SymmetricDS StackTraceKey.init [IllegalArgumentException:322018706]
java.lang.IllegalArgumentException: Cron expression must consist of 6 fields (found 1 in "10000 ")
at org.springframework.scheduling.support.CronSequenceGenerator.parse(CronSequenceGenerator.java:271)
at org.springframework.scheduling.support.CronSequenceGenerator.<init>(CronSequenceGenerator.java:96)
at org.springframework.scheduling.support.CronSequenceGenerator.<init>(CronSequenceGenerator.java:83)
at org.springframework.scheduling.support.CronTrigger.<init>(CronTrigger.java:44)
at org.jumpmind.symmetric.job.AbstractJob.start(AbstractJob.java:112)
at org.jumpmind.symmetric.job.JobManager.startJobs(JobManager.java:117)
at org.jumpmind.symmetric.AbstractSymmetricEngine.start(AbstractSymmetricEngine.java:690)
at org.jumpmind.symmetric.AbstractSymmetricEngine.start(AbstractSymmetricEngine.java:634)
at org.jumpmind.symmetric.ClientSymmetricEngine.start(ClientSymmetricEngine.java:277)
at org.jumpmind.symmetric.web.SymmetricEngineHolder$EngineStarter.run(SymmetricEngineHolder.java:600)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
2018-09-26 10:42:27,559 INFO [store-001][AbstractSymmetricEngine][symmetric-engine-startup-2] Stopping SymmetricDS externalId=001 version=3.9.13 database=Microsoft SQL Server
2018-09-26 10:42:27,559 INFO [store-001][RouterJob][symmetric-engine-startup-2] The 'Routing' job has been cancelled
2018-09-26 10:42:27,559 INFO [store-001][PushJob][symmetric-engine-startup-2] The 'Push' job has been cancelled
2018-09-26 10:42:27,559 INFO [store-001][AbstractSymmetricEngine][symmetric-engine-startup-2]
2018-09-26 10:42:28,965 INFO [corp-000][AbstractSymmetricEngine][symmetric-engine-startup-1] Done initializing SymmetricDS database
2018-09-26 10:42:28,965 INFO [corp-000][AbstractSymmetricEngine][symmetric-engine-startup-1] SymmetricDS database version : 3.9.13
2018-09-26 10:42:28,965 INFO [corp-000][AbstractSymmetricEngine][symmetric-engine-startup-1] SymmetricDS software version : 3.9.13
2018-09-26 10:42:29,043 INFO [corp-000][AbstractSymmetricEngine][symmetric-engine-startup-1] Starting registered node [group=corp, id=000, nodeId=000]
2018-09-26 10:42:29,043 INFO [corp-000][ClusterService][symmetric-engine-startup-1] This node picked a server id of APSET4305
2018-09-26 10:42:29,043 INFO [corp-000][TriggerRouterService][symmetric-engine-startup-1] Synchronizing triggers
2018-09-26 10:42:35,230 INFO [corp-000][TriggerRouterService][symmetric-engine-startup-1] Done synchronizing triggers
2018-09-26 10:42:35,262 INFO [corp-000][RouterJob][symmetric-engine-startup-1] Starting Routing on periodic schedule: every 10000ms with the first run at Wed Sep 26 10:42:45 CDT 2018
2018-09-26 10:42:35,262 INFO [corp-000][PushJob][symmetric-engine-startup-1] Starting Push on periodic schedule: every 60000ms with the first run at Wed Sep 26 10:42:45 CDT 2018
2018-09-26 10:42:35,262 INFO [corp-000][PullJob][symmetric-engine-startup-1] Starting Pull on periodic schedule: every 60000ms with the first run at Wed Sep 26 10:42:45 CDT 2018
2018-09-26 10:42:35,262 INFO [corp-000][JobManager][symmetric-engine-startup-1] Job Offline Push not configured for auto start
2018-09-26 10:42:35,262 INFO [corp-000][JobManager][symmetric-engine-startup-1] Job Offline Pull not configured for auto start
2018-09-26 10:42:35,262 INFO [corp-000][OutgoingPurgeJob][symmetric-engine-startup-1] Starting job 'Purge Outgoing' with cron expression: '0 0 0 * * '
2018-09-26 10:42:35,262 INFO [corp-000][IncomingPurgeJob][symmetric-engine-startup-1] Starting job 'Purge Incoming' with cron expression: '0 0 0 * * '
2018-09-26 10:42:35,277 INFO [corp-000][StatisticFlushJob][symmetric-engine-startup-1] Starting job 'Stat Flush' with cron expression: '0 0/5 * * * '
2018-09-26 10:42:35,277 INFO [corp-000][SyncTriggersJob][symmetric-engine-startup-1] Starting job 'SyncTriggers' with cron expression: '0 0 0 * * '
2018-09-26 10:42:35,277 INFO [corp-000][HeartbeatJob][symmetric-engine-startup-1] Starting Heartbeat on periodic schedule: every 900000ms with the first run at Wed Sep 26 10:42:45 CDT 2018
2018-09-26 10:42:35,277 INFO [corp-000][WatchdogJob][symmetric-engine-startup-1] Starting Watchdog on periodic schedule: every 3600000ms with the first run at Wed Sep 26 10:42:45 CDT 2018
2018-09-26 10:42:35,277 INFO [corp-000][StageManagementJob][symmetric-engine-startup-1] Starting job 'Stage Management' with cron expression: '0 0 * * * *'
2018-09-26 10:42:35,277 INFO [corp-000][JobManager][symmetric-engine-startup-1] Job Refresh Cache not configured for auto start
2018-09-26 10:42:35,277 INFO [corp-000][JobManager][symmetric-engine-startup-1] Job File Sync Tracker not configured for auto start
2018-09-26 10:42:35,277 INFO [corp-000][JobManager][symmetric-engine-startup-1] Job File Sync Pull not configured for auto start
2018-09-26 10:42:35,277 INFO [corp-000][JobManager][symmetric-engine-startup-1] Job File Sync Push not configured for auto start
2018-09-26 10:42:35,277 INFO [corp-000][InitialLoadExtractorJob][symmetric-engine-startup-1] Starting Initial Load Extract on periodic schedule: every 10000ms with the first run at Wed Sep 26 10:42:45 CDT 2018
2018-09-26 10:42:35,277 INFO [corp-000][MonitorJob][symmetric-engine-startup-1] Starting Monitor on periodic schedule: every 60000ms with the first run at Wed Sep 26 10:42:45 CDT 2018
2018-09-26 10:42:35,277 INFO [corp-000][JobManager][symmetric-engine-startup-1] Job Report Status not configured for auto start
2018-09-26 10:42:35,277 INFO [corp-000][AbstractSymmetricEngine][symmetric-engine-startup-1] SymmetricDS Node STARTED:
nodeId=000
groupId=corp
type=server
subType=null
name=corp-000
softwareVersion=3.9.13
databaseName=Adaptive Server Enterprise
databaseVersion=15.5
driverName=jConnect (TM) for JDBC (TM)
driverVersion=jConnect (TM) for JDBC(TM)/7.00(Build 26502)/P/EBF17993/JDK16/Thu Jun 3 3:09:09 2010
uptime=0 sec.
2018-09-26 10:42:45,168 INFO [corp-000][NodeCommunicationService][corp-000-job-3] pull will use 10 threads
2018-09-26 10:42:45,324 INFO [corp-000][DataGapFastDetector][corp-000-job-1] Full gap analysis is running
2018-09-26 10:42:45,387 INFO [corp-000][DataGapFastDetector][corp-000-job-1] Querying data in gaps from database took 63 ms
2018-09-26 10:42:45,387 INFO [corp-000][DataGapFastDetector][corp-000-job-1] Full gap analysis is done after 63 ms
2018-09-26 10:42:45,527 INFO [corp-000][RouterService][corp-000-job-1] The 'heartbeat' channel is NOT in common batch mode
2018-09-26 10:42:45,980 INFO [corp-000][RouterService][corp-000-job-1] Routed 2 data events in 656 ms
2018-09-26 10:42:56,183 INFO [corp-000][DataGapFastDetector][corp-000-job-10] Full gap analysis is running
2018-09-26 10:42:56,262 INFO [corp-000][DataGapFastDetector][corp-000-job-10] Querying data in gaps from database took 79 ms
2018-09-26 10:42:56,262 INFO [corp-000][DataGapFastDetector][corp-000-job-10] Full gap analysis is done after 79 ms
2018-09-26 10:43:06,480 INFO [corp-000][DataGapFastDetector][corp-000-job-11] Full gap analysis is running
2018-09-26 10:43:06,543 INFO [corp-000][DataGapFastDetector][corp-000-job-11] Querying data in gaps from database took 63 ms
2018-09-26 10:43:06,558 INFO [corp-000][DataGapFastDetector][corp-000-job-11] Full gap analysis is done after 78 ms
2018-09-26 10:43:16,746 INFO [corp-000][DataGapFastDetector][corp-000-job-13] Full gap analysis is running
2018-09-26 10:43:16,808 INFO [corp-000][DataGapFastDetector][corp-000-job-13] Querying data in gaps from database took 62 ms
2018-09-26 10:43:16,808 INFO [corp-000][DataGapFastDetector][corp-000-job-13] Full gap analysis is done after 62 ms
2018-09-26 10:43:27,027 INFO [corp-000][DataGapFastDetector][corp-000-job-14] Full gap analysis is running
2018-09-26 10:43:27,090 INFO [corp-000][DataGapFastDetector][corp-000-job-14] Querying data in gaps from database took 63 ms
2018-09-26 10:43:27,090 INFO [corp-000][DataGapFastDetector][corp-000-job-14] Full gap analysis is done after 63 ms
2018-09-26 10:43:37,277 INFO [corp-000][DataGapFastDetector][corp-000-job-3] Full gap analysis is running
2018-09-26 10:43:37,340 INFO [corp-000][DataGapFastDetector][corp-000-job-3] Querying data in gaps from database took 63 ms
2018-09-26 10:43:37,340 INFO [corp-000][DataGapFastDetector][corp-000-job-3] Full gap analysis is done after 63 ms
2018-09-26 10:43:47,543 INFO [corp-000][DataGapFastDetector][corp-000-job-17] Full gap analysis is running
2018-09-26 10:43:47,605 INFO [corp-000][DataGapFastDetector][corp-000-job-17] Querying data in gaps from database took 62 ms
2018-09-26 10:43:47,605 INFO [corp-000][DataGapFastDetector][corp-000-job-17] Full gap analysis is done after 62 ms
2018-09-26 10:43:57,793 INFO [corp-000][DataGapFastDetector][corp-000-job-18] Full gap analysis is running
2018-09-26 10:43:57,871 INFO [corp-000][DataGapFastDetector][corp-000-job-18] Querying data in gaps from database took 78 ms
2018-09-26 10:43:57,871 INFO [corp-000][DataGapFastDetector][corp-000-job-18] Full gap analysis is done after 78 ms
2018-09-26 10:44:08,058 INFO [corp-000][DataGapFastDetector][corp-000-job-19] Full gap analysis is running
2018-09-26 10:44:08,121 INFO [corp-000][DataGapFastDetector][corp-000-job-19] Querying data in gaps from database took 63 ms
2018-09-26 10:44:08,121 INFO [corp-000][DataGapFastDetector][corp-000-job-19] Full gap analysis is done after 63 ms
2018-09-26 10:44:18,308 INFO [corp-000][DataGapFastDetector][corp-000-job-20] Full gap analysis is running
2018-09-26 10:44:18,371 INFO [corp-000][DataGapFastDetector][corp-000-job-20] Querying data in gaps from database took 63 ms
2018-09-26 10:44:18,371 INFO [corp-000][DataGapFastDetector][corp-000-job-20] Full gap analysis is done after 63 ms
2018-09-26 10:44:28,558 INFO [corp-000][DataGapFastDetector][corp-000-job-12] Full gap analysis is running
2018-09-26 10:44:28,621 INFO [corp-000][DataGapFastDetector][corp-000-job-12] Querying data in gaps from database took 63 ms
2018-09-26 10:44:28,621 INFO [corp-000][DataGapFastDetector][corp-000-job-12] Full gap analysis is done after 63 ms
2018-09-26 10:44:38,808 INFO [corp-000][DataGapFastDetector][corp-000-job-5] Full gap analysis is running
2018-09-26 10:44:38,870 INFO [corp-000][DataGapFastDetector][corp-000-job-5] Querying data in gaps from database took 62 ms
2018-09-26 10:44:38,870 INFO [corp-000][DataGapFastDetector][corp-000-job-5] Full gap analysis is done after 62 ms
2018-09-26 10:44:49,058 INFO [corp-000][DataGapFastDetector][corp-000-job-3] Full gap analysis is running
2018-09-26 10:44:49,120 INFO [corp-000][DataGapFastDetector][corp-000-job-3] Querying data in gaps from database took 62 ms
2018-09-26 10:44:49,120 INFO [corp-000][DataGapFastDetector][corp-000-job-3] Full gap analysis is done after 62 ms
2018-09-26 10:44:55,569 INFO [] [AbstractCommandLauncher][main] Option: name=engine, value={corp-000}
2018-09-26 10:44:56,428 INFO [] [SymmetricUtils][main] _ __ _ _____
/ / __ __ __ ___ __ ___ / /()___ / __ | / ___/
_ \ / / / / _ _ \/ _ \/ _ \/// / / / / / / / _ \ / // // / // // / // // / __// / / / / / / / // / ___/ /
/____/ _ ///////////_/ _/ // //_/ /__/ /_/
//
+-----------------------------------------------------------------+
| Copyright (C) 2007-2018 JumpMind, Inc. |
| |
| Licensed under the GNU General Public License version 3. |
| This software comes with ABSOLUTELY NO WARRANTY. |
| See http://www.gnu.org/licenses/gpl.html |
+-----------------------------------------------------------------+
2018-09-26 10:44:56,460 INFO [corp-000][AbstractSymmetricEngine][main] Initializing connection to database
2018-09-26 10:44:56,694 INFO [corp-000][JdbcDatabasePlatformFactory][main] Detected database 'Adaptive Server Enterprise', version '15', protocol 'sybase'
2018-09-26 10:44:56,725 INFO [corp-000][JdbcDatabasePlatformFactory][main] The IDatabasePlatform being used is org.jumpmind.db.platform.ase.AseDatabasePlatform
2018-09-26 10:44:57,006 INFO [corp-000][AseSymmetricDialect][main] The DbDialect being used is org.jumpmind.symmetric.db.ase.AseSymmetricDialect
2018-09-26 10:44:57,116 INFO [corp-000][ExtensionService][main] Found 0 extension points from the database that will be registered
2018-09-26 10:44:57,131 INFO [corp-000][StagingManager][main] The staging directory was initialized at the following location: E:\symmetric-server-3.9.13\tmp\corp-000
2018-09-26 10:44:58,256 INFO [corp-000][ExtensionService][main] Found 0 extension points from the database that will be registered
2018-09-26 10:44:58,256 INFO [corp-000][ClientExtensionService][main] Found 6 extension points from spring that will be registered
2018-09-26 10:44:59,303 INFO [corp-000][DataGapFastDetector][corp-000-job-15] Full gap analysis is running
2018-09-26 10:44:59,366 INFO [corp-000][DataGapFastDetector][corp-000-job-15] Querying data in gaps from database took 63 ms
2018-09-26 10:44:59,366 INFO [corp-000][DataGapFastDetector][corp-000-job-15] Full gap analysis is done after 63 ms
2018-09-26 10:44:59,413 INFO [corp-000][RouterService][corp-000-job-15] The 'config' channel is NOT in common batch mode
2018-09-26 10:44:59,600 INFO [corp-000][ConfigurationChangedDataRouter][corp-000-job-15] About to refresh the cache of node security because new configuration came through the data router
2018-09-26 10:44:59,600 INFO [corp-000][RouterService][corp-000-job-15] Routed 1 data events in 297 ms
2018-09-26 10:45:09,819 INFO [corp-000][DataGapFastDetector][corp-000-job-17] Full gap analysis is running
2018-09-26 10:45:09,944 INFO [corp-000][DataGapFastDetector][corp-000-job-17] Querying data in gaps from database took 78 ms
2018-09-26 10:45:09,944 INFO [corp-000][DataGapFastDetector][corp-000-job-17] Full gap analysis is done after 78 ms
2018-09-26 10:45:20,288 INFO [corp-000][DataGapFastDetector][corp-000-job-18] Full gap analysis is running
2018-09-26 10:45:20,366 INFO [corp-000][DataGapFastDetector][corp-000-job-18] Querying data in gaps from database took 78 ms
2018-09-26 10:45:20,366 INFO [corp-000][DataGapFastDetector][corp-000-job-18] Full gap analysis is done after 78 ms
2018-09-26 10:45:24,227 INFO [] [AbstractCommandLauncher][main] Option: name=engine, value={corp-000}
2018-09-26 10:45:25,055 INFO [] [SymmetricUtils][main] _ __ _ __ _____
/ / __ __ __ ___ __ ___ / / ____() / __ | / /
_ \ / / / / _ _ \/ _ \/ _ \/ __// __/ / __/ / / / / _ \ / // // / // // / // // / // / / / / / / / // / / /
// _ ///////////_/ _/ // //_/ /__/ /_/
/_/
+-----------------------------------------------------------------+
| Copyright (C) 2007-2018 JumpMind, Inc. |
| |
| Licensed under the GNU General Public License version 3. |
| This software comes with ABSOLUTELY NO WARRANTY. |
| See http://www.gnu.org/licenses/gpl.html |
+-----------------------------------------------------------------+
2018-09-26 10:45:25,070 INFO [corp-000][AbstractSymmetricEngine][main] Initializing connection to database
2018-09-26 10:45:25,258 INFO [corp-000][JdbcDatabasePlatformFactory][main] Detected database 'Adaptive Server Enterprise', version '15', protocol 'sybase'
2018-09-26 10:45:25,289 INFO [corp-000][JdbcDatabasePlatformFactory][main] The IDatabasePlatform being used is org.jumpmind.db.platform.ase.AseDatabasePlatform
2018-09-26 10:45:25,539 INFO [corp-000][AseSymmetricDialect][main] The DbDialect being used is org.jumpmind.symmetric.db.ase.AseSymmetricDialect
2018-09-26 10:45:25,664 INFO [corp-000][ExtensionService][main] Found 0 extension points from the database that will be registered
2018-09-26 10:45:25,664 INFO [corp-000][StagingManager][main] The staging directory was initialized at the following location: E:\symmetric-server-3.9.13\tmp\corp-000
2018-09-26 10:45:26,695 INFO [corp-000][ExtensionService][main] Found 0 extension points from the database that will be registered
2018-09-26 10:45:26,695 INFO [corp-000][ClientExtensionService][main] Found 6 extension points from spring that will be registered
2018-09-26 10:45:30,555 INFO [corp-000][DataGapFastDetector][corp-000-job-19] Full gap analysis is running
2018-09-26 10:45:30,617 INFO [corp-000][DataGapFastDetector][corp-000-job-19] Querying data in gaps from database took 62 ms
2018-09-26 10:45:30,617 INFO [corp-000][DataGapFastDetector][corp-000-job-19] Full gap analysis is done after 62 ms
2018-09-26 10:45:30,789 INFO [corp-000][ConfigurationChangedDataRouter][corp-000-job-19] About to refresh the cache of node security because new configuration came through the data router
2018-09-26 10:45:30,805 INFO [corp-000][RouterService][corp-000-job-19] Routed 1 data events in 250 ms
2018-09-26 10:45:41,023 INFO [corp-000][DataGapFastDetector][corp-000-job-20] Full gap analysis is running
2018-09-26 10:45:41,086 INFO [corp-000][DataGapFastDetector][corp-000-job-20] Querying data in gaps from database took 63 ms
2018-09-26 10:45:41,086 INFO [corp-000][DataGapFastDetector][corp-000-job-20] Full gap analysis is done after 63 ms</init></init></init>
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi I am using symmetric-server-3.9.13 to replication data for few tables from sybase to sql server. Was able to successfully create sym tables at source/target side and inserted table name in sym_trigger and sym_trigger_router. But when I execute sym command replication is not happening from sybase to sql server.
Sybase version is Adaptive Server Enterprise/15.5. And SQL server version is 2014.
Please suggest if you have encountered this or if I am missing something. Below are the logs which I am not able to interpret fully but looks like it is going in loop where it goes 'Full gap analysis is done under x ms'
Also there is one line in logs on which I am doubtful which says An error occurred while starting SymmetricDS StackTraceKey.init [IllegalArgumentException:322018706]..
2018-10-05 10:31:07,530 ERROR [store-001] [AbstractSymmetricEngine] [symmetric-engine-startup-2] An error occurred while starting SymmetricDS StackTraceKey.init [IllegalArgumentException:322018706]
java.lang.IllegalArgumentException: Cron expression must consist of 6 fields (found 1 in "10000 ")
Full logs are below:
2018-09-26 10:42:18,902 INFO [startup] [SymmetricUtils] [main]
_ __ _ _____
/ / __ __ __ ___ __ ___ / / ()___ / __ | / ___/
_ \ / / / / _
_ \/ _\/ _ \/ // / / / / / / / _ \/ // // / // // / // // / __// / / / / / / / // / ___/ /
/____/ _ ///////////_/ _/ // //_/ /__/ /_/
//
+-----------------------------------------------------------------+
| Copyright (C) 2007-2018 JumpMind, Inc. |
| |
| Licensed under the GNU General Public License version 3. |
| This software comes with ABSOLUTELY NO WARRANTY. |
| See http://www.gnu.org/licenses/gpl.html |
+-----------------------------------------------------------------+
2018-09-26 10:42:19,027 INFO [startup] [SymmetricWebServer] [main] About to start SymmetricDS web server on host:port 0.0.0.0:31415
2018-09-26 10:42:20,793 INFO [store-001] [AbstractSymmetricEngine] [symmetric-engine-startup-2] Initializing connection to database
2018-09-26 10:42:20,809 INFO [corp-000] [AbstractSymmetricEngine] [symmetric-engine-startup-1] Initializing connection to database
2018-09-26 10:42:21,715 INFO [store-001] [JdbcDatabasePlatformFactory] [symmetric-engine-startup-2] Detected database 'Microsoft SQL Server', version '12', protocol 'jtds'
2018-09-26 10:42:21,840 INFO [store-001] [JdbcDatabasePlatformFactory] [symmetric-engine-startup-2] The IDatabasePlatform being used is org.jumpmind.db.platform.mssql.MsSql2008DatabasePlatform
2018-09-26 10:42:22,246 INFO [corp-000] [JdbcDatabasePlatformFactory] [symmetric-engine-startup-1] Detected database 'Adaptive Server Enterprise', version '15', protocol 'sybase'
2018-09-26 10:42:22,293 INFO [corp-000] [JdbcDatabasePlatformFactory] [symmetric-engine-startup-1] The IDatabasePlatform being used is org.jumpmind.db.platform.ase.AseDatabasePlatform
2018-09-26 10:42:22,559 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] The DbDialect being used is org.jumpmind.symmetric.db.mssql.MsSqlSymmetricDialect
2018-09-26 10:42:22,574 INFO [corp-000] [AseSymmetricDialect] [symmetric-engine-startup-1] The DbDialect being used is org.jumpmind.symmetric.db.ase.AseSymmetricDialect
2018-09-26 10:42:22,746 INFO [store-001] [ExtensionService] [symmetric-engine-startup-2] Found 0 extension points from the database that will be registered
2018-09-26 10:42:22,762 INFO [store-001] [StagingManager] [symmetric-engine-startup-2] The staging directory was initialized at the following location: E:\symmetric-server-3.9.13\tmp\store-001
2018-09-26 10:42:22,777 INFO [corp-000] [ExtensionService] [symmetric-engine-startup-1] Found 0 extension points from the database that will be registered
2018-09-26 10:42:22,809 INFO [corp-000] [StagingManager] [symmetric-engine-startup-1] The staging directory was initialized at the following location: E:\symmetric-server-3.9.13\tmp\corp-000
2018-09-26 10:42:24,902 INFO [store-001] [ExtensionService] [symmetric-engine-startup-2] Found 0 extension points from the database that will be registered
2018-09-26 10:42:24,934 INFO [store-001] [ClientExtensionService] [symmetric-engine-startup-2] Found 7 extension points from spring that will be registered
2018-09-26 10:42:24,949 INFO [store-001] [AbstractSymmetricEngine] [symmetric-engine-startup-2] Initializing SymmetricDS database
2018-09-26 10:42:24,949 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] Checking if SymmetricDS tables need created or altered
2018-09-26 10:42:25,043 INFO [corp-000] [ExtensionService] [symmetric-engine-startup-1] Found 0 extension points from the database that will be registered
2018-09-26 10:42:25,043 INFO [corp-000] [ClientExtensionService] [symmetric-engine-startup-1] Found 7 extension points from spring that will be registered
2018-09-26 10:42:25,043 INFO [corp-000] [AbstractSymmetricEngine] [symmetric-engine-startup-1] Initializing SymmetricDS database
2018-09-26 10:42:25,043 INFO [corp-000] [AseSymmetricDialect] [symmetric-engine-startup-1] Checking if SymmetricDS tables need created or altered
2018-09-26 10:42:25,105 INFO [startup] [SymmetricWebServer] [main] Starting JMX HTTP console on port 31416
2018-09-26 10:42:25,152 INFO [startup] [SymmetricWebServer] [main] Joining the web server main thread
2018-09-26 10:42:26,027 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] There are SymmetricDS tables that needed altered
2018-09-26 10:42:26,027 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2018-09-26 10:42:26,074 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: DROP INDEX "sym_idx_ib_time_status" ON "facets540xts"."dbo"."sym_incoming_batch"
2018-09-26 10:42:26,090 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: DROP INDEX "sym_idx_nd_hst_chnl_sts" ON "facets540xts"."dbo"."sym_node_host_channel_stats"
2018-09-26 10:42:26,090 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: DROP INDEX "sym_idx_nd_hst_job" ON "facets540xts"."dbo"."sym_node_host_job_stats"
2018-09-26 10:42:26,090 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: DROP INDEX "sym_idx_nd_hst_sts" ON "facets540xts"."dbo"."sym_node_host_stats"
2018-09-26 10:42:26,090 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: DROP INDEX "sym_idx_trigg_hist_1" ON "facets540xts"."dbo"."sym_trigger_hist"
2018-09-26 10:42:26,121 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'F' AND name = 'sym_fk_cf_2_grp_lnk')
ALTER TABLE "sym_conflict" DROP CONSTRAINT "sym_fk_cf_2_grp_lnk"
2018-09-26 10:42:26,121 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'F' AND name = 'sym_fk_ftr_2_ftrg')
ALTER TABLE "sym_file_trigger_router" DROP CONSTRAINT "sym_fk_ftr_2_ftrg"
2018-09-26 10:42:26,121 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'F' AND name = 'sym_fk_ftr_2_rtr')
ALTER TABLE "sym_file_trigger_router" DROP CONSTRAINT "sym_fk_ftr_2_rtr"
2018-09-26 10:42:26,137 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'F' AND name = 'sym_fk_gpltlnk_2_gplt')
ALTER TABLE "sym_grouplet_link" DROP CONSTRAINT "sym_fk_gpltlnk_2_gplt"
2018-09-26 10:42:26,137 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'F' AND name = 'sym_fk_lnk_2_grp_src')
ALTER TABLE "sym_node_group_link" DROP CONSTRAINT "sym_fk_lnk_2_grp_src"
2018-09-26 10:42:26,152 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'F' AND name = 'sym_fk_lnk_2_grp_tgt')
ALTER TABLE "sym_node_group_link" DROP CONSTRAINT "sym_fk_lnk_2_grp_tgt"
2018-09-26 10:42:26,152 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'F' AND name = 'sym_fk_sec_2_node')
ALTER TABLE "sym_node_security" DROP CONSTRAINT "sym_fk_sec_2_node"
2018-09-26 10:42:26,152 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'F' AND name = 'sym_fk_rt_2_grp_lnk')
ALTER TABLE "sym_router" DROP CONSTRAINT "sym_fk_rt_2_grp_lnk"
2018-09-26 10:42:26,168 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'F' AND name = 'sym_fk_tt_2_grp_lnk')
ALTER TABLE "sym_transform_table" DROP CONSTRAINT "sym_fk_tt_2_grp_lnk"
2018-09-26 10:42:26,168 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'F' AND name = 'sym_fk_trg_2_chnl')
ALTER TABLE "sym_trigger" DROP CONSTRAINT "sym_fk_trg_2_chnl"
2018-09-26 10:42:26,184 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'F' AND name = 'sym_fk_trg_2_rld_chnl')
ALTER TABLE "sym_trigger" DROP CONSTRAINT "sym_fk_trg_2_rld_chnl"
2018-09-26 10:42:26,184 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'F' AND name = 'sym_fk_tr_2_trg')
ALTER TABLE "sym_trigger_router" DROP CONSTRAINT "sym_fk_tr_2_trg"
2018-09-26 10:42:26,184 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'F' AND name = 'sym_fk_tr_2_rtr')
ALTER TABLE "sym_trigger_router" DROP CONSTRAINT "sym_fk_tr_2_rtr"
2018-09-26 10:42:26,199 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'F' AND name = 'sym_fk_trgplt_2_gplt')
ALTER TABLE "sym_trigger_router_grouplet" DROP CONSTRAINT "sym_fk_trgplt_2_gplt"
2018-09-26 10:42:26,199 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'F' AND name = 'sym_fk_trgplt_2_tr')
ALTER TABLE "sym_trigger_router_grouplet" DROP CONSTRAINT "sym_fk_trgplt_2_tr"
2018-09-26 10:42:26,324 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_channel" ALTER COLUMN "create_time" DATETIME2
2018-09-26 10:42:26,324 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_channel" ALTER COLUMN "last_update_time" DATETIME2
2018-09-26 10:42:26,324 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_conflict" ALTER COLUMN "create_time" DATETIME2 NOT NULL
2018-09-26 10:42:26,324 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_conflict" ALTER COLUMN "last_update_time" DATETIME2 NOT NULL
2018-09-26 10:42:26,324 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_context" ALTER COLUMN "create_time" DATETIME2
2018-09-26 10:42:26,340 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_context" ALTER COLUMN "last_update_time" DATETIME2
2018-09-26 10:42:26,340 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_data" ALTER COLUMN "create_time" DATETIME2
2018-09-26 10:42:26,340 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_data_event" ALTER COLUMN "create_time" DATETIME2
2018-09-26 10:42:26,340 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_data_gap" ALTER COLUMN "create_time" DATETIME2 NOT NULL
2018-09-26 10:42:26,340 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_data_gap" ALTER COLUMN "last_update_time" DATETIME2 NOT NULL
2018-09-26 10:42:26,340 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_extension" ALTER COLUMN "create_time" DATETIME2
2018-09-26 10:42:26,340 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_extension" ALTER COLUMN "last_update_time" DATETIME2
2018-09-26 10:42:26,340 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_extract_request" ALTER COLUMN "last_update_time" DATETIME2
2018-09-26 10:42:26,355 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_extract_request" ALTER COLUMN "create_time" DATETIME2
2018-09-26 10:42:26,355 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_file_snapshot" ALTER COLUMN "last_update_time" DATETIME2 NOT NULL
2018-09-26 10:42:26,355 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_file_snapshot" ALTER COLUMN "create_time" DATETIME2 NOT NULL
2018-09-26 10:42:26,355 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_file_trigger" ALTER COLUMN "create_time" DATETIME2 NOT NULL
2018-09-26 10:42:26,355 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_file_trigger" ALTER COLUMN "last_update_time" DATETIME2 NOT NULL
2018-09-26 10:42:26,355 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_file_trigger_router" ALTER COLUMN "create_time" DATETIME2 NOT NULL
2018-09-26 10:42:26,371 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_file_trigger_router" ALTER COLUMN "last_update_time" DATETIME2 NOT NULL
2018-09-26 10:42:26,371 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_grouplet" ALTER COLUMN "create_time" DATETIME2 NOT NULL
2018-09-26 10:42:26,371 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_grouplet" ALTER COLUMN "last_update_time" DATETIME2 NOT NULL
2018-09-26 10:42:26,371 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_grouplet_link" ALTER COLUMN "create_time" DATETIME2 NOT NULL
2018-09-26 10:42:26,371 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_grouplet_link" ALTER COLUMN "last_update_time" DATETIME2 NOT NULL
2018-09-26 10:42:26,371 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_incoming_batch" ALTER COLUMN "last_update_time" DATETIME2
2018-09-26 10:42:26,387 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_incoming_batch" ALTER COLUMN "create_time" DATETIME2
2018-09-26 10:42:26,387 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_incoming_error" ALTER COLUMN "create_time" DATETIME2
2018-09-26 10:42:26,402 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_incoming_error" ALTER COLUMN "last_update_time" DATETIME2 NOT NULL
2018-09-26 10:42:26,402 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_job" ALTER COLUMN "create_time" DATETIME2
2018-09-26 10:42:26,402 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_job" ALTER COLUMN "last_update_time" DATETIME2
2018-09-26 10:42:26,402 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_load_filter" ALTER COLUMN "create_time" DATETIME2 NOT NULL
2018-09-26 10:42:26,402 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_load_filter" ALTER COLUMN "last_update_time" DATETIME2 NOT NULL
2018-09-26 10:42:26,418 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_lock" ALTER COLUMN "lock_time" DATETIME2
2018-09-26 10:42:26,418 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_lock" ALTER COLUMN "last_lock_time" DATETIME2
2018-09-26 10:42:26,418 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_node" ALTER COLUMN "heartbeat_time" DATETIME2
2018-09-26 10:42:26,434 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_node_communication" ALTER COLUMN "lock_time" DATETIME2
2018-09-26 10:42:26,434 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_node_communication" ALTER COLUMN "last_lock_time" DATETIME2
2018-09-26 10:42:26,434 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_node_channel_ctl" ALTER COLUMN "last_extract_time" DATETIME2
2018-09-26 10:42:26,434 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_node_group" ALTER COLUMN "create_time" DATETIME2
2018-09-26 10:42:26,434 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_node_group" ALTER COLUMN "last_update_time" DATETIME2
2018-09-26 10:42:26,434 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2018-09-26 10:42:26,449 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name = 'sym_node_group_channel_wnd')
BEGIN
DECLARE @tn33d71ac7_166168bb2cc__7ffe nvarchar(256), @cn33d71ac7_166168bb2cc__7ffd nvarchar(256)
DECLARE refcursor CURSOR FOR
SELECT object_name(objs.parent_obj) tablename, objs.name constraintname
FROM sysobjects objs
WHERE objs.xtype in ('C','D','F','UQ') AND object_name(objs.parent_obj) = 'sym_node_group_channel_wnd_' OPEN refcursor
FETCH NEXT FROM refcursor INTO @tn33d71ac7_166168bb2cc__7ffe, @cn33d71ac7_166168bb2cc__7ffd
WHILE @@FETCH_STATUS = 0
BEGIN
EXEC ('ALTER TABLE '+@tn33d71ac7_166168bb2cc__7ffe+' DROP CONSTRAINT '+@cn33d71ac7_166168bb2cc__7ffd)
FETCH NEXT FROM refcursor INTO @tn33d71ac7_166168bb2cc__7ffe, @cn33d71ac7_166168bb2cc__7ffd
END
CLOSE refcursor
DEALLOCATE refcursor
DROP TABLE "sym_node_group_channel_wnd_"
END
2018-09-26 10:42:26,449 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2018-09-26 10:42:26,449 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: CREATE TABLE "facets540xts"."dbo"."sym_node_group_channel_wnd_"(
"node_group_id" VARCHAR(50) NOT NULL,
"channel_id" VARCHAR(128) NOT NULL,
"start_time" VARCHAR(27) NOT NULL,
"end_time" VARCHAR(27) NOT NULL,
"enabled" SMALLINT DEFAULT 0 NOT NULL,
PRIMARY KEY ("node_group_id", "channel_id", "start_time", "end_time")
)
2018-09-26 10:42:26,465 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: INSERT INTO "facets540xts"."dbo"."sym_node_group_channel_wnd_" ("node_group_id","channel_id","start_time","end_time","enabled") SELECT "node_group_id","channel_id","start_time","end_time","enabled" FROM "facets540xts"."dbo"."sym_node_group_channel_wnd"
2018-09-26 10:42:26,465 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2018-09-26 10:42:26,480 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name = 'sym_node_group_channel_wnd')
BEGIN
DECLARE @tn33d71ac7_166168bb2cc__7ffc nvarchar(256), @cn33d71ac7_166168bb2cc__7ffb nvarchar(256)
DECLARE refcursor CURSOR FOR
SELECT object_name(objs.parent_obj) tablename, objs.name constraintname
FROM sysobjects objs
WHERE objs.xtype in ('C','D','F','UQ') AND object_name(objs.parent_obj) = 'sym_node_group_channel_wnd' OPEN refcursor
FETCH NEXT FROM refcursor INTO @tn33d71ac7_166168bb2cc__7ffc, @cn33d71ac7_166168bb2cc__7ffb
WHILE @@FETCH_STATUS = 0
BEGIN
EXEC ('ALTER TABLE '+@tn33d71ac7_166168bb2cc__7ffc+' DROP CONSTRAINT '+@cn33d71ac7_166168bb2cc__7ffb)
FETCH NEXT FROM refcursor INTO @tn33d71ac7_166168bb2cc__7ffc, @cn33d71ac7_166168bb2cc__7ffb
END
CLOSE refcursor
DEALLOCATE refcursor
DROP TABLE "sym_node_group_channel_wnd"
END
2018-09-26 10:42:26,480 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2018-09-26 10:42:26,480 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: CREATE TABLE "sym_node_group_channel_wnd"(
"node_group_id" VARCHAR(50) NOT NULL,
"channel_id" VARCHAR(128) NOT NULL,
"start_time" DATETIME2 NOT NULL,
"end_time" DATETIME2 NOT NULL,
"enabled" SMALLINT DEFAULT 0 NOT NULL,
PRIMARY KEY ("node_group_id", "channel_id", "start_time", "end_time")
)
2018-09-26 10:42:26,496 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: INSERT INTO "sym_node_group_channel_wnd" ("node_group_id","channel_id","start_time","end_time","enabled") SELECT "node_group_id","channel_id","start_time","end_time","enabled" FROM "facets540xts"."dbo"."sym_node_group_channel_wnd_"
2018-09-26 10:42:26,496 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2018-09-26 10:42:26,512 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name = 'sym_node_group_channel_wnd_')
BEGIN
DECLARE @tn33d71ac7_166168bb2cc__7ffa nvarchar(256), @cn33d71ac7_166168bb2cc__7ff9 nvarchar(256)
DECLARE refcursor CURSOR FOR
SELECT object_name(objs.parent_obj) tablename, objs.name constraintname
FROM sysobjects objs
WHERE objs.xtype in ('C','D','F','UQ') AND object_name(objs.parent_obj) = 'sym_node_group_channel_wnd_' OPEN refcursor
FETCH NEXT FROM refcursor INTO @tn33d71ac7_166168bb2cc__7ffa, @cn33d71ac7_166168bb2cc__7ff9
WHILE @@FETCH_STATUS = 0
BEGIN
EXEC ('ALTER TABLE '+@tn33d71ac7_166168bb2cc__7ffa+' DROP CONSTRAINT '+@cn33d71ac7_166168bb2cc__7ff9)
FETCH NEXT FROM refcursor INTO @tn33d71ac7_166168bb2cc__7ffa, @cn33d71ac7_166168bb2cc__7ff9
END
CLOSE refcursor
DEALLOCATE refcursor
DROP TABLE "sym_node_group_channel_wnd_"
END
2018-09-26 10:42:26,512 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_node_group_link" ALTER COLUMN "create_time" DATETIME2
2018-09-26 10:42:26,512 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_node_group_link" ALTER COLUMN "last_update_time" DATETIME2
2018-09-26 10:42:26,527 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_node_host" ALTER COLUMN "heartbeat_time" DATETIME2
2018-09-26 10:42:26,527 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_node_host" ALTER COLUMN "last_restart_time" DATETIME2 NOT NULL
2018-09-26 10:42:26,527 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_node_host" ALTER COLUMN "create_time" DATETIME2 NOT NULL
2018-09-26 10:42:26,527 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2018-09-26 10:42:26,543 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name = 'sym_node_host_channel_stats_')
BEGIN
DECLARE @tn33d71ac7_166168bb2cc__7ff6 nvarchar(256), @cn33d71ac7_166168bb2cc__7ff5 nvarchar(256)
DECLARE refcursor CURSOR FOR
SELECT object_name(objs.parent_obj) tablename, objs.name constraintname
FROM sysobjects objs
WHERE objs.xtype in ('C','D','F','UQ') AND object_name(objs.parent_obj) = 'sym_node_host_channel_stats_' OPEN refcursor
FETCH NEXT FROM refcursor INTO @tn33d71ac7_166168bb2cc__7ff6, @cn33d71ac7_166168bb2cc__7ff5
WHILE @@FETCH_STATUS = 0
BEGIN
EXEC ('ALTER TABLE '+@tn33d71ac7_166168bb2cc__7ff6+' DROP CONSTRAINT '+@cn33d71ac7_166168bb2cc__7ff5)
FETCH NEXT FROM refcursor INTO @tn33d71ac7_166168bb2cc__7ff6, @cn33d71ac7_166168bb2cc__7ff5
END
CLOSE refcursor
DEALLOCATE refcursor
DROP TABLE "sym_node_host_channel_stats_"
END
2018-09-26 10:42:26,543 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2018-09-26 10:42:26,543 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: CREATE TABLE "facets540xts"."dbo"."sym_node_host_channel_stats_"(
"node_id" VARCHAR(50) NOT NULL,
"host_name" VARCHAR(60) NOT NULL,
"channel_id" VARCHAR(128) NOT NULL,
"start_time" VARCHAR(27) NOT NULL,
"end_time" VARCHAR(27) NOT NULL,
"data_routed" BIGINT DEFAULT 0,
"data_unrouted" BIGINT DEFAULT 0,
"data_event_inserted" BIGINT DEFAULT 0,
"data_extracted" BIGINT DEFAULT 0,
"data_bytes_extracted" BIGINT DEFAULT 0,
"data_extracted_errors" BIGINT DEFAULT 0,
"data_bytes_sent" BIGINT DEFAULT 0,
"data_sent" BIGINT DEFAULT 0,
"data_sent_errors" BIGINT DEFAULT 0,
"data_loaded" BIGINT DEFAULT 0,
"data_bytes_loaded" BIGINT DEFAULT 0,
"data_loaded_errors" BIGINT DEFAULT 0,
PRIMARY KEY ("node_id", "host_name", "channel_id", "start_time", "end_time")
)
2018-09-26 10:42:26,543 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: INSERT INTO "facets540xts"."dbo"."sym_node_host_channel_stats_" ("node_id","host_name","channel_id","start_time","end_time","data_routed","data_unrouted","data_event_inserted","data_extracted","data_bytes_extracted","data_extracted_errors","data_bytes_sent","data_sent","data_sent_errors","data_loaded","data_bytes_loaded","data_loaded_errors") SELECT "node_id","host_name","channel_id","start_time","end_time","data_routed","data_unrouted","data_event_inserted","data_extracted","data_bytes_extracted","data_extracted_errors","data_bytes_sent","data_sent","data_sent_errors","data_loaded","data_bytes_loaded","data_loaded_errors" FROM "facets540xts"."dbo"."sym_node_host_channel_stats"
2018-09-26 10:42:26,559 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2018-09-26 10:42:26,605 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name = 'sym_node_host_channel_stats')
BEGIN
DECLARE @tn33d71ac7_166168bb2cc__7ff4 nvarchar(256), @cn33d71ac7_166168bb2cc__7ff3 nvarchar(256)
DECLARE refcursor CURSOR FOR
SELECT object_name(objs.parent_obj) tablename, objs.name constraintname
FROM sysobjects objs
WHERE objs.xtype in ('C','D','F','UQ') AND object_name(objs.parent_obj) = 'sym_node_host_channel_stats' OPEN refcursor
FETCH NEXT FROM refcursor INTO @tn33d71ac7_166168bb2cc__7ff4, @cn33d71ac7_166168bb2cc__7ff3
WHILE @@FETCH_STATUS = 0
BEGIN
EXEC ('ALTER TABLE '+@tn33d71ac7_166168bb2cc__7ff4+' DROP CONSTRAINT '+@cn33d71ac7_166168bb2cc__7ff3)
FETCH NEXT FROM refcursor INTO @tn33d71ac7_166168bb2cc__7ff4, @cn33d71ac7_166168bb2cc__7ff3
END
CLOSE refcursor
DEALLOCATE refcursor
DROP TABLE "sym_node_host_channel_stats"
END
2018-09-26 10:42:26,605 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2018-09-26 10:42:26,605 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: CREATE TABLE "sym_node_host_channel_stats"(
"node_id" VARCHAR(50) NOT NULL,
"host_name" VARCHAR(60) NOT NULL,
"channel_id" VARCHAR(128) NOT NULL,
"start_time" DATETIME2 NOT NULL,
"end_time" DATETIME2 NOT NULL,
"data_routed" BIGINT DEFAULT 0,
"data_unrouted" BIGINT DEFAULT 0,
"data_event_inserted" BIGINT DEFAULT 0,
"data_extracted" BIGINT DEFAULT 0,
"data_bytes_extracted" BIGINT DEFAULT 0,
"data_extracted_errors" BIGINT DEFAULT 0,
"data_bytes_sent" BIGINT DEFAULT 0,
"data_sent" BIGINT DEFAULT 0,
"data_sent_errors" BIGINT DEFAULT 0,
"data_loaded" BIGINT DEFAULT 0,
"data_bytes_loaded" BIGINT DEFAULT 0,
"data_loaded_errors" BIGINT DEFAULT 0,
PRIMARY KEY ("node_id", "host_name", "channel_id", "start_time", "end_time")
)
2018-09-26 10:42:26,621 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: INSERT INTO "sym_node_host_channel_stats" ("node_id","host_name","channel_id","start_time","end_time","data_routed","data_unrouted","data_event_inserted","data_extracted","data_bytes_extracted","data_extracted_errors","data_bytes_sent","data_sent","data_sent_errors","data_loaded","data_bytes_loaded","data_loaded_errors") SELECT "node_id","host_name","channel_id","start_time","end_time","data_routed","data_unrouted","data_event_inserted","data_extracted","data_bytes_extracted","data_extracted_errors","data_bytes_sent","data_sent","data_sent_errors","data_loaded","data_bytes_loaded","data_loaded_errors" FROM "facets540xts"."dbo"."sym_node_host_channel_stats_"
2018-09-26 10:42:26,621 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2018-09-26 10:42:26,715 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name = 'sym_node_host_channel_stats_')
BEGIN
DECLARE @tn33d71ac7_166168bb2cc__7ff2 nvarchar(256), @cn33d71ac7_166168bb2cc__7ff1 nvarchar(256)
DECLARE refcursor CURSOR FOR
SELECT object_name(objs.parent_obj) tablename, objs.name constraintname
FROM sysobjects objs
WHERE objs.xtype in ('C','D','F','UQ') AND object_name(objs.parent_obj) = 'sym_node_host_channel_stats_' OPEN refcursor
FETCH NEXT FROM refcursor INTO @tn33d71ac7_166168bb2cc__7ff2, @cn33d71ac7_166168bb2cc__7ff1
WHILE @@FETCH_STATUS = 0
BEGIN
EXEC ('ALTER TABLE '+@tn33d71ac7_166168bb2cc__7ff2+' DROP CONSTRAINT '+@cn33d71ac7_166168bb2cc__7ff1)
FETCH NEXT FROM refcursor INTO @tn33d71ac7_166168bb2cc__7ff2, @cn33d71ac7_166168bb2cc__7ff1
END
CLOSE refcursor
DEALLOCATE refcursor
DROP TABLE "sym_node_host_channel_stats_"
END
2018-09-26 10:42:26,715 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2018-09-26 10:42:26,730 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name = 'sym_node_host_job_stats_')
BEGIN
DECLARE @tn33d71ac7_166168bb2cc__7fee nvarchar(256), @cn33d71ac7_166168bb2cc__7fed nvarchar(256)
DECLARE refcursor CURSOR FOR
SELECT object_name(objs.parent_obj) tablename, objs.name constraintname
FROM sysobjects objs
WHERE objs.xtype in ('C','D','F','UQ') AND object_name(objs.parent_obj) = 'sym_node_host_job_stats_' OPEN refcursor
FETCH NEXT FROM refcursor INTO @tn33d71ac7_166168bb2cc__7fee, @cn33d71ac7_166168bb2cc__7fed
WHILE @@FETCH_STATUS = 0
BEGIN
EXEC ('ALTER TABLE '+@tn33d71ac7_166168bb2cc__7fee+' DROP CONSTRAINT '+@cn33d71ac7_166168bb2cc__7fed)
FETCH NEXT FROM refcursor INTO @tn33d71ac7_166168bb2cc__7fee, @cn33d71ac7_166168bb2cc__7fed
END
CLOSE refcursor
DEALLOCATE refcursor
DROP TABLE "sym_node_host_job_stats_"
END
2018-09-26 10:42:26,730 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2018-09-26 10:42:26,746 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: CREATE TABLE "facets540xts"."dbo"."sym_node_host_job_stats_"(
"node_id" VARCHAR(50) NOT NULL,
"host_name" VARCHAR(60) NOT NULL,
"job_name" VARCHAR(50) NOT NULL,
"start_time" VARCHAR(27) NOT NULL,
"end_time" VARCHAR(27) NOT NULL,
"processed_count" BIGINT DEFAULT 0,
"target_node_id" VARCHAR(50),
"target_node_count" INT DEFAULT 0,
PRIMARY KEY ("node_id", "host_name", "job_name", "start_time", "end_time")
)
2018-09-26 10:42:26,746 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: INSERT INTO "facets540xts"."dbo"."sym_node_host_job_stats_" ("node_id","host_name","job_name","start_time","end_time","processed_count","target_node_id","target_node_count") SELECT "node_id","host_name","job_name","start_time","end_time","processed_count","target_node_id","target_node_count" FROM "facets540xts"."dbo"."sym_node_host_job_stats"
2018-09-26 10:42:26,746 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2018-09-26 10:42:26,762 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name = 'sym_node_host_job_stats')
BEGIN
DECLARE @tn33d71ac7_166168bb2cc__7fec nvarchar(256), @cn33d71ac7_166168bb2cc__7feb nvarchar(256)
DECLARE refcursor CURSOR FOR
SELECT object_name(objs.parent_obj) tablename, objs.name constraintname
FROM sysobjects objs
WHERE objs.xtype in ('C','D','F','UQ') AND object_name(objs.parent_obj) = 'sym_node_host_job_stats' OPEN refcursor
FETCH NEXT FROM refcursor INTO @tn33d71ac7_166168bb2cc__7fec, @cn33d71ac7_166168bb2cc__7feb
WHILE @@FETCH_STATUS = 0
BEGIN
EXEC ('ALTER TABLE '+@tn33d71ac7_166168bb2cc__7fec+' DROP CONSTRAINT '+@cn33d71ac7_166168bb2cc__7feb)
FETCH NEXT FROM refcursor INTO @tn33d71ac7_166168bb2cc__7fec, @cn33d71ac7_166168bb2cc__7feb
END
CLOSE refcursor
DEALLOCATE refcursor
DROP TABLE "sym_node_host_job_stats"
END
2018-09-26 10:42:26,762 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2018-09-26 10:42:26,777 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: CREATE TABLE "sym_node_host_job_stats"(
"node_id" VARCHAR(50) NOT NULL,
"host_name" VARCHAR(60) NOT NULL,
"job_name" VARCHAR(50) NOT NULL,
"start_time" DATETIME2 NOT NULL,
"end_time" DATETIME2 NOT NULL,
"processed_count" BIGINT DEFAULT 0,
"target_node_id" VARCHAR(50),
"target_node_count" INT DEFAULT 0,
PRIMARY KEY ("node_id", "host_name", "job_name", "start_time", "end_time")
)
2018-09-26 10:42:26,777 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: INSERT INTO "sym_node_host_job_stats" ("node_id","host_name","job_name","start_time","end_time","processed_count","target_node_id","target_node_count") SELECT "node_id","host_name","job_name","start_time","end_time","processed_count","target_node_id","target_node_count" FROM "facets540xts"."dbo"."sym_node_host_job_stats_"
2018-09-26 10:42:26,777 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2018-09-26 10:42:26,793 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name = 'sym_node_host_job_stats_')
BEGIN
DECLARE @tn33d71ac7_166168bb2cc__7fea nvarchar(256), @cn33d71ac7_166168bb2cc__7fe9 nvarchar(256)
DECLARE refcursor CURSOR FOR
SELECT object_name(objs.parent_obj) tablename, objs.name constraintname
FROM sysobjects objs
WHERE objs.xtype in ('C','D','F','UQ') AND object_name(objs.parent_obj) = 'sym_node_host_job_stats_' OPEN refcursor
FETCH NEXT FROM refcursor INTO @tn33d71ac7_166168bb2cc__7fea, @cn33d71ac7_166168bb2cc__7fe9
WHILE @@FETCH_STATUS = 0
BEGIN
EXEC ('ALTER TABLE '+@tn33d71ac7_166168bb2cc__7fea+' DROP CONSTRAINT '+@cn33d71ac7_166168bb2cc__7fe9)
FETCH NEXT FROM refcursor INTO @tn33d71ac7_166168bb2cc__7fea, @cn33d71ac7_166168bb2cc__7fe9
END
CLOSE refcursor
DEALLOCATE refcursor
DROP TABLE "sym_node_host_job_stats_"
END
2018-09-26 10:42:26,793 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2018-09-26 10:42:26,809 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name = 'sym_node_host_stats_')
BEGIN
DECLARE @tn33d71ac7_166168bb2cc__7fe6 nvarchar(256), @cn33d71ac7_166168bb2cc__7fe5 nvarchar(256)
DECLARE refcursor CURSOR FOR
SELECT object_name(objs.parent_obj) tablename, objs.name constraintname
FROM sysobjects objs
WHERE objs.xtype in ('C','D','F','UQ') AND object_name(objs.parent_obj) = 'sym_node_host_stats_' OPEN refcursor
FETCH NEXT FROM refcursor INTO @tn33d71ac7_166168bb2cc__7fe6, @cn33d71ac7_166168bb2cc__7fe5
WHILE @@FETCH_STATUS = 0
BEGIN
EXEC ('ALTER TABLE '+@tn33d71ac7_166168bb2cc__7fe6+' DROP CONSTRAINT '+@cn33d71ac7_166168bb2cc__7fe5)
FETCH NEXT FROM refcursor INTO @tn33d71ac7_166168bb2cc__7fe6, @cn33d71ac7_166168bb2cc__7fe5
END
CLOSE refcursor
DEALLOCATE refcursor
DROP TABLE "sym_node_host_stats_"
END
2018-09-26 10:42:26,809 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2018-09-26 10:42:26,824 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: CREATE TABLE "facets540xts"."dbo"."sym_node_host_stats_"(
"node_id" VARCHAR(50) NOT NULL,
"host_name" VARCHAR(60) NOT NULL,
"start_time" VARCHAR(27) NOT NULL,
"end_time" VARCHAR(27) NOT NULL,
"restarted" BIGINT DEFAULT 0 NOT NULL,
"nodes_pulled" BIGINT DEFAULT 0,
"total_nodes_pull_time" BIGINT DEFAULT 0,
"nodes_pushed" BIGINT DEFAULT 0,
"total_nodes_push_time" BIGINT DEFAULT 0,
"nodes_rejected" BIGINT DEFAULT 0,
"nodes_registered" BIGINT DEFAULT 0,
"nodes_loaded" BIGINT DEFAULT 0,
"nodes_disabled" BIGINT DEFAULT 0,
"purged_data_rows" BIGINT DEFAULT 0,
"purged_data_event_rows" BIGINT DEFAULT 0,
"purged_batch_outgoing_rows" BIGINT DEFAULT 0,
"purged_batch_incoming_rows" BIGINT DEFAULT 0,
"triggers_created_count" BIGINT,
"triggers_rebuilt_count" BIGINT,
"triggers_removed_count" BIGINT,
PRIMARY KEY ("node_id", "host_name", "start_time", "end_time")
)
2018-09-26 10:42:26,824 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: INSERT INTO "facets540xts"."dbo"."sym_node_host_stats_" ("node_id","host_name","start_time","end_time","restarted","nodes_pulled","total_nodes_pull_time","nodes_pushed","total_nodes_push_time","nodes_rejected","nodes_registered","nodes_loaded","nodes_disabled","purged_data_rows","purged_data_event_rows","purged_batch_outgoing_rows","purged_batch_incoming_rows","triggers_created_count","triggers_rebuilt_count","triggers_removed_count") SELECT "node_id","host_name","start_time","end_time","restarted","nodes_pulled","total_nodes_pull_time","nodes_pushed","total_nodes_push_time","nodes_rejected","nodes_registered","nodes_loaded","nodes_disabled","purged_data_rows","purged_data_event_rows","purged_batch_outgoing_rows","purged_batch_incoming_rows","triggers_created_count","triggers_rebuilt_count","triggers_removed_count" FROM "facets540xts"."dbo"."sym_node_host_stats"
2018-09-26 10:42:26,824 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2018-09-26 10:42:26,855 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name = 'sym_node_host_stats')
BEGIN
DECLARE @tn33d71ac7_166168bb2cc__7fe4 nvarchar(256), @cn33d71ac7_166168bb2cc__7fe3 nvarchar(256)
DECLARE refcursor CURSOR FOR
SELECT object_name(objs.parent_obj) tablename, objs.name constraintname
FROM sysobjects objs
WHERE objs.xtype in ('C','D','F','UQ') AND object_name(objs.parent_obj) = 'sym_node_host_stats' OPEN refcursor
FETCH NEXT FROM refcursor INTO @tn33d71ac7_166168bb2cc__7fe4, @cn33d71ac7_166168bb2cc__7fe3
WHILE @@FETCH_STATUS = 0
BEGIN
EXEC ('ALTER TABLE '+@tn33d71ac7_166168bb2cc__7fe4+' DROP CONSTRAINT '+@cn33d71ac7_166168bb2cc__7fe3)
FETCH NEXT FROM refcursor INTO @tn33d71ac7_166168bb2cc__7fe4, @cn33d71ac7_166168bb2cc__7fe3
END
CLOSE refcursor
DEALLOCATE refcursor
DROP TABLE "sym_node_host_stats"
END
2018-09-26 10:42:26,855 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2018-09-26 10:42:26,871 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: CREATE TABLE "sym_node_host_stats"(
"node_id" VARCHAR(50) NOT NULL,
"host_name" VARCHAR(60) NOT NULL,
"start_time" DATETIME2 NOT NULL,
"end_time" DATETIME2 NOT NULL,
"restarted" BIGINT DEFAULT 0 NOT NULL,
"nodes_pulled" BIGINT DEFAULT 0,
"total_nodes_pull_time" BIGINT DEFAULT 0,
"nodes_pushed" BIGINT DEFAULT 0,
"total_nodes_push_time" BIGINT DEFAULT 0,
"nodes_rejected" BIGINT DEFAULT 0,
"nodes_registered" BIGINT DEFAULT 0,
"nodes_loaded" BIGINT DEFAULT 0,
"nodes_disabled" BIGINT DEFAULT 0,
"purged_data_rows" BIGINT DEFAULT 0,
"purged_data_event_rows" BIGINT DEFAULT 0,
"purged_batch_outgoing_rows" BIGINT DEFAULT 0,
"purged_batch_incoming_rows" BIGINT DEFAULT 0,
"triggers_created_count" BIGINT,
"triggers_rebuilt_count" BIGINT,
"triggers_removed_count" BIGINT,
PRIMARY KEY ("node_id", "host_name", "start_time", "end_time")
)
2018-09-26 10:42:26,871 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: INSERT INTO "sym_node_host_stats" ("node_id","host_name","start_time","end_time","restarted","nodes_pulled","total_nodes_pull_time","nodes_pushed","total_nodes_push_time","nodes_rejected","nodes_registered","nodes_loaded","nodes_disabled","purged_data_rows","purged_data_event_rows","purged_batch_outgoing_rows","purged_batch_incoming_rows","triggers_created_count","triggers_rebuilt_count","triggers_removed_count") SELECT "node_id","host_name","start_time","end_time","restarted","nodes_pulled","total_nodes_pull_time","nodes_pushed","total_nodes_push_time","nodes_rejected","nodes_registered","nodes_loaded","nodes_disabled","purged_data_rows","purged_data_event_rows","purged_batch_outgoing_rows","purged_batch_incoming_rows","triggers_created_count","triggers_rebuilt_count","triggers_removed_count" FROM "facets540xts"."dbo"."sym_node_host_stats_"
2018-09-26 10:42:26,871 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2018-09-26 10:42:26,902 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name = 'sym_node_host_stats_')
BEGIN
DECLARE @tn33d71ac7_166168bb2cc__7fe2 nvarchar(256), @cn33d71ac7_166168bb2cc__7fe1 nvarchar(256)
DECLARE refcursor CURSOR FOR
SELECT object_name(objs.parent_obj) tablename, objs.name constraintname
FROM sysobjects objs
WHERE objs.xtype in ('C','D','F','UQ') AND object_name(objs.parent_obj) = 'sym_node_host_stats_' OPEN refcursor
FETCH NEXT FROM refcursor INTO @tn33d71ac7_166168bb2cc__7fe2, @cn33d71ac7_166168bb2cc__7fe1
WHILE @@FETCH_STATUS = 0
BEGIN
EXEC ('ALTER TABLE '+@tn33d71ac7_166168bb2cc__7fe2+' DROP CONSTRAINT '+@cn33d71ac7_166168bb2cc__7fe1)
FETCH NEXT FROM refcursor INTO @tn33d71ac7_166168bb2cc__7fe2, @cn33d71ac7_166168bb2cc__7fe1
END
CLOSE refcursor
DEALLOCATE refcursor
DROP TABLE "sym_node_host_stats_"
END
2018-09-26 10:42:26,902 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_node_security" ALTER COLUMN "registration_time" DATETIME2
2018-09-26 10:42:26,902 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_node_security" ALTER COLUMN "initial_load_time" DATETIME2
2018-09-26 10:42:26,918 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_node_security" ALTER COLUMN "rev_initial_load_time" DATETIME2
2018-09-26 10:42:26,918 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_monitor" ALTER COLUMN "create_time" DATETIME2
2018-09-26 10:42:26,918 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_monitor" ALTER COLUMN "last_update_time" DATETIME2
2018-09-26 10:42:26,918 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2018-09-26 10:42:26,934 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name = 'sym_monitor_event_')
BEGIN
DECLARE @tn33d71ac7_166168bb2cc__7fde nvarchar(256), @cn33d71ac7_166168bb2cc__7fdd nvarchar(256)
DECLARE refcursor CURSOR FOR
SELECT object_name(objs.parent_obj) tablename, objs.name constraintname
FROM sysobjects objs
WHERE objs.xtype in ('C','D','F','UQ') AND object_name(objs.parent_obj) = 'sym_monitor_event_' OPEN refcursor
FETCH NEXT FROM refcursor INTO @tn33d71ac7_166168bb2cc__7fde, @cn33d71ac7_166168bb2cc__7fdd
WHILE @@FETCH_STATUS = 0
BEGIN
EXEC ('ALTER TABLE '+@tn33d71ac7_166168bb2cc__7fde+' DROP CONSTRAINT '+@cn33d71ac7_166168bb2cc__7fdd)
FETCH NEXT FROM refcursor INTO @tn33d71ac7_166168bb2cc__7fde, @cn33d71ac7_166168bb2cc__7fdd
END
CLOSE refcursor
DEALLOCATE refcursor
DROP TABLE "sym_monitor_event_"
END
2018-09-26 10:42:26,934 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2018-09-26 10:42:26,934 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: CREATE TABLE "facets540xts"."dbo"."sym_monitor_event_"(
"monitor_id" VARCHAR(128) NOT NULL,
"node_id" VARCHAR(50) NOT NULL,
"event_time" VARCHAR(27) NOT NULL,
"host_name" VARCHAR(60),
"type" VARCHAR(50) NOT NULL,
"threshold" BIGINT DEFAULT 0 NOT NULL,
"event_value" BIGINT DEFAULT 0 NOT NULL,
"event_count" INT DEFAULT 0 NOT NULL,
"severity_level" INT DEFAULT 0 NOT NULL,
"is_resolved" SMALLINT DEFAULT 0 NOT NULL,
"is_notified" SMALLINT DEFAULT 0 NOT NULL,
"details" TEXT,
"last_update_time" VARCHAR(27),
PRIMARY KEY ("monitor_id", "node_id", "event_time")
)
2018-09-26 10:42:26,934 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: INSERT INTO "facets540xts"."dbo"."sym_monitor_event_" ("monitor_id","node_id","event_time","host_name","type","threshold","event_value","event_count","severity_level","is_resolved","is_notified","details","last_update_time") SELECT "monitor_id","node_id","event_time","host_name","type","threshold","event_value","event_count","severity_level","is_resolved","is_notified","details","last_update_time" FROM "facets540xts"."dbo"."sym_monitor_event"
2018-09-26 10:42:26,934 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2018-09-26 10:42:26,965 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name = 'sym_monitor_event')
BEGIN
DECLARE @tn33d71ac7_166168bb2cc__7fdc nvarchar(256), @cn33d71ac7_166168bb2cc__7fdb nvarchar(256)
DECLARE refcursor CURSOR FOR
SELECT object_name(objs.parent_obj) tablename, objs.name constraintname
FROM sysobjects objs
WHERE objs.xtype in ('C','D','F','UQ') AND object_name(objs.parent_obj) = 'sym_monitor_event' OPEN refcursor
FETCH NEXT FROM refcursor INTO @tn33d71ac7_166168bb2cc__7fdc, @cn33d71ac7_166168bb2cc__7fdb
WHILE @@FETCH_STATUS = 0
BEGIN
EXEC ('ALTER TABLE '+@tn33d71ac7_166168bb2cc__7fdc+' DROP CONSTRAINT '+@cn33d71ac7_166168bb2cc__7fdb)
FETCH NEXT FROM refcursor INTO @tn33d71ac7_166168bb2cc__7fdc, @cn33d71ac7_166168bb2cc__7fdb
END
CLOSE refcursor
DEALLOCATE refcursor
DROP TABLE "sym_monitor_event"
END
2018-09-26 10:42:26,965 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2018-09-26 10:42:26,965 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: CREATE TABLE "sym_monitor_event"(
"monitor_id" VARCHAR(128) NOT NULL,
"node_id" VARCHAR(50) NOT NULL,
"event_time" DATETIME2 NOT NULL,
"host_name" VARCHAR(60),
"type" VARCHAR(50) NOT NULL,
"threshold" BIGINT DEFAULT 0 NOT NULL,
"event_value" BIGINT DEFAULT 0 NOT NULL,
"event_count" INT DEFAULT 0 NOT NULL,
"severity_level" INT DEFAULT 0 NOT NULL,
"is_resolved" SMALLINT DEFAULT 0 NOT NULL,
"is_notified" SMALLINT DEFAULT 0 NOT NULL,
"details" TEXT,
"last_update_time" DATETIME2,
PRIMARY KEY ("monitor_id", "node_id", "event_time")
)
2018-09-26 10:42:26,980 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: INSERT INTO "sym_monitor_event" ("monitor_id","node_id","event_time","host_name","type","threshold","event_value","event_count","severity_level","is_resolved","is_notified","details","last_update_time") SELECT "monitor_id","node_id","event_time","host_name","type","threshold","event_value","event_count","severity_level","is_resolved","is_notified","details","last_update_time" FROM "facets540xts"."dbo"."sym_monitor_event_"
2018-09-26 10:42:26,980 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2018-09-26 10:42:27,012 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name = 'sym_monitor_event_')
BEGIN
DECLARE @tn33d71ac7_166168bb2cc__7fda nvarchar(256), @cn33d71ac7_166168bb2cc__7fd9 nvarchar(256)
DECLARE refcursor CURSOR FOR
SELECT object_name(objs.parent_obj) tablename, objs.name constraintname
FROM sysobjects objs
WHERE objs.xtype in ('C','D','F','UQ') AND object_name(objs.parent_obj) = 'sym_monitor_event_' OPEN refcursor
FETCH NEXT FROM refcursor INTO @tn33d71ac7_166168bb2cc__7fda, @cn33d71ac7_166168bb2cc__7fd9
WHILE @@FETCH_STATUS = 0
BEGIN
EXEC ('ALTER TABLE '+@tn33d71ac7_166168bb2cc__7fda+' DROP CONSTRAINT '+@cn33d71ac7_166168bb2cc__7fd9)
FETCH NEXT FROM refcursor INTO @tn33d71ac7_166168bb2cc__7fda, @cn33d71ac7_166168bb2cc__7fd9
END
CLOSE refcursor
DEALLOCATE refcursor
DROP TABLE "sym_monitor_event_"
END
2018-09-26 10:42:27,012 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_notification" ALTER COLUMN "create_time" DATETIME2
2018-09-26 10:42:27,012 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_notification" ALTER COLUMN "last_update_time" DATETIME2
2018-09-26 10:42:27,012 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_outgoing_batch" ALTER COLUMN "last_update_time" DATETIME2
2018-09-26 10:42:27,012 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_outgoing_batch" ALTER COLUMN "create_time" DATETIME2
2018-09-26 10:42:27,027 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_outgoing_batch" ALTER COLUMN "extract_start_time" DATETIME2
2018-09-26 10:42:27,027 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_outgoing_batch" ALTER COLUMN "transfer_start_time" DATETIME2
2018-09-26 10:42:27,027 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_outgoing_batch" ALTER COLUMN "load_start_time" DATETIME2
2018-09-26 10:42:27,027 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_parameter" ALTER COLUMN "create_time" DATETIME2
2018-09-26 10:42:27,027 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_parameter" ALTER COLUMN "last_update_time" DATETIME2
2018-09-26 10:42:27,027 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2018-09-26 10:42:27,043 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name = 'sym_registration_request_')
BEGIN
DECLARE @tn33d71ac7_166168bb2cc__7fd6 nvarchar(256), @cn33d71ac7_166168bb2cc__7fd5 nvarchar(256)
DECLARE refcursor CURSOR FOR
SELECT object_name(objs.parent_obj) tablename, objs.name constraintname
FROM sysobjects objs
WHERE objs.xtype in ('C','D','F','UQ') AND object_name(objs.parent_obj) = 'sym_registration_request_' OPEN refcursor
FETCH NEXT FROM refcursor INTO @tn33d71ac7_166168bb2cc__7fd6, @cn33d71ac7_166168bb2cc__7fd5
WHILE @@FETCH_STATUS = 0
BEGIN
EXEC ('ALTER TABLE '+@tn33d71ac7_166168bb2cc__7fd6+' DROP CONSTRAINT '+@cn33d71ac7_166168bb2cc__7fd5)
FETCH NEXT FROM refcursor INTO @tn33d71ac7_166168bb2cc__7fd6, @cn33d71ac7_166168bb2cc__7fd5
END
CLOSE refcursor
DEALLOCATE refcursor
DROP TABLE "sym_registration_request_"
END
2018-09-26 10:42:27,043 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2018-09-26 10:42:27,043 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: CREATE TABLE "facets540xts"."dbo"."sym_registration_request_"(
"node_group_id" VARCHAR(50) NOT NULL,
"external_id" VARCHAR(255) NOT NULL,
"status" CHAR(2) NOT NULL,
"host_name" VARCHAR(60) NOT NULL,
"ip_address" VARCHAR(50) NOT NULL,
"attempt_count" INT DEFAULT 0,
"registered_node_id" VARCHAR(50),
"error_message" TEXT,
"create_time" VARCHAR(27) NOT NULL,
"last_update_by" VARCHAR(50),
"last_update_time" VARCHAR(27) NOT NULL,
PRIMARY KEY ("node_group_id", "external_id", "create_time")
)
2018-09-26 10:42:27,059 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: INSERT INTO "facets540xts"."dbo"."sym_registration_request_" ("node_group_id","external_id","status","host_name","ip_address","attempt_count","registered_node_id","error_message","create_time","last_update_by","last_update_time") SELECT "node_group_id","external_id","status","host_name","ip_address","attempt_count","registered_node_id","error_message","create_time","last_update_by","last_update_time" FROM "facets540xts"."dbo"."sym_registration_request"
2018-09-26 10:42:27,059 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2018-09-26 10:42:27,074 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name = 'sym_registration_request')
BEGIN
DECLARE @tn33d71ac7_166168bb2cc__7fd4 nvarchar(256), @cn33d71ac7_166168bb2cc__7fd3 nvarchar(256)
DECLARE refcursor CURSOR FOR
SELECT object_name(objs.parent_obj) tablename, objs.name constraintname
FROM sysobjects objs
WHERE objs.xtype in ('C','D','F','UQ') AND object_name(objs.parent_obj) = 'sym_registration_request' OPEN refcursor
FETCH NEXT FROM refcursor INTO @tn33d71ac7_166168bb2cc__7fd4, @cn33d71ac7_166168bb2cc__7fd3
WHILE @@FETCH_STATUS = 0
BEGIN
EXEC ('ALTER TABLE '+@tn33d71ac7_166168bb2cc__7fd4+' DROP CONSTRAINT '+@cn33d71ac7_166168bb2cc__7fd3)
FETCH NEXT FROM refcursor INTO @tn33d71ac7_166168bb2cc__7fd4, @cn33d71ac7_166168bb2cc__7fd3
END
CLOSE refcursor
DEALLOCATE refcursor
DROP TABLE "sym_registration_request"
END
2018-09-26 10:42:27,074 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2018-09-26 10:42:27,074 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: CREATE TABLE "sym_registration_request"(
"node_group_id" VARCHAR(50) NOT NULL,
"external_id" VARCHAR(255) NOT NULL,
"status" CHAR(2) NOT NULL,
"host_name" VARCHAR(60) NOT NULL,
"ip_address" VARCHAR(50) NOT NULL,
"attempt_count" INT DEFAULT 0,
"registered_node_id" VARCHAR(50),
"error_message" TEXT,
"create_time" DATETIME2 NOT NULL,
"last_update_by" VARCHAR(50),
"last_update_time" DATETIME2 NOT NULL,
PRIMARY KEY ("node_group_id", "external_id", "create_time")
)
2018-09-26 10:42:27,090 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: CREATE INDEX "sym_idx_reg_req_1" ON "sym_registration_request" ("node_group_id", "external_id", "status", "host_name", "ip_address")
2018-09-26 10:42:27,090 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: CREATE INDEX "sym_idx_reg_req_2" ON "sym_registration_request" ("status")
2018-09-26 10:42:27,090 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: INSERT INTO "sym_registration_request" ("node_group_id","external_id","status","host_name","ip_address","attempt_count","registered_node_id","error_message","create_time","last_update_by","last_update_time") SELECT "node_group_id","external_id","status","host_name","ip_address","attempt_count","registered_node_id","error_message","create_time","last_update_by","last_update_time" FROM "facets540xts"."dbo"."sym_registration_request_"
2018-09-26 10:42:27,090 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2018-09-26 10:42:27,105 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name = 'sym_registration_request_')
BEGIN
DECLARE @tn33d71ac7_166168bb2cc__7fd2 nvarchar(256), @cn33d71ac7_166168bb2cc__7fd1 nvarchar(256)
DECLARE refcursor CURSOR FOR
SELECT object_name(objs.parent_obj) tablename, objs.name constraintname
FROM sysobjects objs
WHERE objs.xtype in ('C','D','F','UQ') AND object_name(objs.parent_obj) = 'sym_registration_request_' OPEN refcursor
FETCH NEXT FROM refcursor INTO @tn33d71ac7_166168bb2cc__7fd2, @cn33d71ac7_166168bb2cc__7fd1
WHILE @@FETCH_STATUS = 0
BEGIN
EXEC ('ALTER TABLE '+@tn33d71ac7_166168bb2cc__7fd2+' DROP CONSTRAINT '+@cn33d71ac7_166168bb2cc__7fd1)
FETCH NEXT FROM refcursor INTO @tn33d71ac7_166168bb2cc__7fd2, @cn33d71ac7_166168bb2cc__7fd1
END
CLOSE refcursor
DEALLOCATE refcursor
DROP TABLE "sym_registration_request_"
END
2018-09-26 10:42:27,105 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_router" ALTER COLUMN "create_time" DATETIME2 NOT NULL
2018-09-26 10:42:27,105 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_router" ALTER COLUMN "last_update_time" DATETIME2 NOT NULL
2018-09-26 10:42:27,121 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_sequence" ALTER COLUMN "create_time" DATETIME2
2018-09-26 10:42:27,121 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_sequence" ALTER COLUMN "last_update_time" DATETIME2 NOT NULL
2018-09-26 10:42:27,121 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2018-09-26 10:42:27,121 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name = 'sym_table_reload_request_')
BEGIN
DECLARE @tn33d71ac7_166168bb2cc__7fce nvarchar(256), @cn33d71ac7_166168bb2cc__7fcd nvarchar(256)
DECLARE refcursor CURSOR FOR
SELECT object_name(objs.parent_obj) tablename, objs.name constraintname
FROM sysobjects objs
WHERE objs.xtype in ('C','D','F','UQ') AND object_name(objs.parent_obj) = 'sym_table_reload_request_' OPEN refcursor
FETCH NEXT FROM refcursor INTO @tn33d71ac7_166168bb2cc__7fce, @cn33d71ac7_166168bb2cc__7fcd
WHILE @@FETCH_STATUS = 0
BEGIN
EXEC ('ALTER TABLE '+@tn33d71ac7_166168bb2cc__7fce+' DROP CONSTRAINT '+@cn33d71ac7_166168bb2cc__7fcd)
FETCH NEXT FROM refcursor INTO @tn33d71ac7_166168bb2cc__7fce, @cn33d71ac7_166168bb2cc__7fcd
END
CLOSE refcursor
DEALLOCATE refcursor
DROP TABLE "sym_table_reload_request_"
END
2018-09-26 10:42:27,121 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2018-09-26 10:42:27,137 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: CREATE TABLE "facets540xts"."dbo"."sym_table_reload_request_"(
"target_node_id" VARCHAR(50) NOT NULL,
"source_node_id" VARCHAR(50) NOT NULL,
"trigger_id" VARCHAR(128) NOT NULL,
"router_id" VARCHAR(50) NOT NULL,
"create_time" VARCHAR(27) NOT NULL,
"create_table" SMALLINT DEFAULT 0 NOT NULL,
"delete_first" SMALLINT DEFAULT 0 NOT NULL,
"reload_select" TEXT,
"before_custom_sql" TEXT,
"reload_time" VARCHAR(27),
"load_id" BIGINT,
"processed" SMALLINT DEFAULT 0 NOT NULL,
"channel_id" VARCHAR(128),
"last_update_by" VARCHAR(50),
"last_update_time" VARCHAR(27) NOT NULL,
PRIMARY KEY ("target_node_id", "source_node_id", "trigger_id", "router_id", "create_time")
)
2018-09-26 10:42:27,137 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: INSERT INTO "facets540xts"."dbo"."sym_table_reload_request_" ("target_node_id","source_node_id","trigger_id","router_id","create_time","create_table","delete_first","reload_select","before_custom_sql","reload_time","load_id","processed","channel_id","last_update_by","last_update_time") SELECT "target_node_id","source_node_id","trigger_id","router_id","create_time","create_table","delete_first","reload_select","before_custom_sql","reload_time","load_id","processed","channel_id","last_update_by","last_update_time" FROM "facets540xts"."dbo"."sym_table_reload_request"
2018-09-26 10:42:27,137 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2018-09-26 10:42:27,152 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name = 'sym_table_reload_request')
BEGIN
DECLARE @tn33d71ac7_166168bb2cc__7fcc nvarchar(256), @cn33d71ac7_166168bb2cc__7fcb nvarchar(256)
DECLARE refcursor CURSOR FOR
SELECT object_name(objs.parent_obj) tablename, objs.name constraintname
FROM sysobjects objs
WHERE objs.xtype in ('C','D','F','UQ') AND object_name(objs.parent_obj) = 'sym_table_reload_request' OPEN refcursor
FETCH NEXT FROM refcursor INTO @tn33d71ac7_166168bb2cc__7fcc, @cn33d71ac7_166168bb2cc__7fcb
WHILE @@FETCH_STATUS = 0
BEGIN
EXEC ('ALTER TABLE '+@tn33d71ac7_166168bb2cc__7fcc+' DROP CONSTRAINT '+@cn33d71ac7_166168bb2cc__7fcb)
FETCH NEXT FROM refcursor INTO @tn33d71ac7_166168bb2cc__7fcc, @cn33d71ac7_166168bb2cc__7fcb
END
CLOSE refcursor
DEALLOCATE refcursor
DROP TABLE "sym_table_reload_request"
END
2018-09-26 10:42:27,168 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2018-09-26 10:42:27,168 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: CREATE TABLE "sym_table_reload_request"(
"target_node_id" VARCHAR(50) NOT NULL,
"source_node_id" VARCHAR(50) NOT NULL,
"trigger_id" VARCHAR(128) NOT NULL,
"router_id" VARCHAR(50) NOT NULL,
"create_time" DATETIME2 NOT NULL,
"create_table" SMALLINT DEFAULT 0 NOT NULL,
"delete_first" SMALLINT DEFAULT 0 NOT NULL,
"reload_select" TEXT,
"before_custom_sql" TEXT,
"reload_time" DATETIME2,
"load_id" BIGINT,
"processed" SMALLINT DEFAULT 0 NOT NULL,
"channel_id" VARCHAR(128),
"last_update_by" VARCHAR(50),
"last_update_time" DATETIME2 NOT NULL,
PRIMARY KEY ("target_node_id", "source_node_id", "trigger_id", "router_id", "create_time")
)
2018-09-26 10:42:27,168 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: INSERT INTO "sym_table_reload_request" ("target_node_id","source_node_id","trigger_id","router_id","create_time","create_table","delete_first","reload_select","before_custom_sql","reload_time","load_id","processed","channel_id","last_update_by","last_update_time") SELECT "target_node_id","source_node_id","trigger_id","router_id","create_time","create_table","delete_first","reload_select","before_custom_sql","reload_time","load_id","processed","channel_id","last_update_by","last_update_time" FROM "facets540xts"."dbo"."sym_table_reload_request_"
2018-09-26 10:42:27,184 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: SET quoted_identifier on
2018-09-26 10:42:27,199 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name = 'sym_table_reload_request_')
BEGIN
DECLARE @tn33d71ac7_166168bb2cc__7fca nvarchar(256), @cn33d71ac7_166168bb2cc__7fc9 nvarchar(256)
DECLARE refcursor CURSOR FOR
SELECT object_name(objs.parent_obj) tablename, objs.name constraintname
FROM sysobjects objs
WHERE objs.xtype in ('C','D','F','UQ') AND object_name(objs.parent_obj) = 'sym_table_reload_request_' OPEN refcursor
FETCH NEXT FROM refcursor INTO @tn33d71ac7_166168bb2cc__7fca, @cn33d71ac7_166168bb2cc__7fc9
WHILE @@FETCH_STATUS = 0
BEGIN
EXEC ('ALTER TABLE '+@tn33d71ac7_166168bb2cc__7fca+' DROP CONSTRAINT '+@cn33d71ac7_166168bb2cc__7fc9)
FETCH NEXT FROM refcursor INTO @tn33d71ac7_166168bb2cc__7fca, @cn33d71ac7_166168bb2cc__7fc9
END
CLOSE refcursor
DEALLOCATE refcursor
DROP TABLE "sym_table_reload_request_"
END
2018-09-26 10:42:27,199 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_transform_table" ALTER COLUMN "create_time" DATETIME2
2018-09-26 10:42:27,199 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_transform_table" ALTER COLUMN "last_update_time" DATETIME2
2018-09-26 10:42:27,199 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_transform_column" ALTER COLUMN "create_time" DATETIME2
2018-09-26 10:42:27,215 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_transform_column" ALTER COLUMN "last_update_time" DATETIME2
2018-09-26 10:42:27,215 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_trigger" ALTER COLUMN "create_time" DATETIME2 NOT NULL
2018-09-26 10:42:27,215 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_trigger" ALTER COLUMN "last_update_time" DATETIME2 NOT NULL
2018-09-26 10:42:27,215 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_trigger_hist" ALTER COLUMN "create_time" DATETIME2 NOT NULL
2018-09-26 10:42:27,215 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_trigger_hist" ALTER COLUMN "inactive_time" DATETIME2
2018-09-26 10:42:27,215 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_trigger_router" ALTER COLUMN "create_time" DATETIME2 NOT NULL
2018-09-26 10:42:27,215 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_trigger_router" ALTER COLUMN "last_update_time" DATETIME2 NOT NULL
2018-09-26 10:42:27,215 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_trigger_router_grouplet" ALTER COLUMN "create_time" DATETIME2 NOT NULL
2018-09-26 10:42:27,215 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "facets540xts"."dbo"."sym_trigger_router_grouplet" ALTER COLUMN "last_update_time" DATETIME2 NOT NULL
2018-09-26 10:42:27,230 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "sym_conflict"
ADD CONSTRAINT "sym_fk_cf_2_grp_lnk" FOREIGN KEY ("source_node_group_id", "target_node_group_id") REFERENCES "sym_node_group_link" ("source_node_group_id", "target_node_group_id")
2018-09-26 10:42:27,230 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "sym_file_trigger_router"
ADD CONSTRAINT "sym_fk_ftr_2_ftrg" FOREIGN KEY ("trigger_id") REFERENCES "sym_file_trigger" ("trigger_id")
2018-09-26 10:42:27,230 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "sym_file_trigger_router"
ADD CONSTRAINT "sym_fk_ftr_2_rtr" FOREIGN KEY ("router_id") REFERENCES "sym_router" ("router_id")
2018-09-26 10:42:27,230 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "sym_grouplet_link"
ADD CONSTRAINT "sym_fk_gpltlnk_2_gplt" FOREIGN KEY ("grouplet_id") REFERENCES "sym_grouplet" ("grouplet_id")
2018-09-26 10:42:27,230 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "sym_node_group_link"
ADD CONSTRAINT "sym_fk_lnk_2_grp_src" FOREIGN KEY ("source_node_group_id") REFERENCES "sym_node_group" ("node_group_id")
2018-09-26 10:42:27,230 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "sym_node_group_link"
ADD CONSTRAINT "sym_fk_lnk_2_grp_tgt" FOREIGN KEY ("target_node_group_id") REFERENCES "sym_node_group" ("node_group_id")
2018-09-26 10:42:27,246 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "sym_node_security"
ADD CONSTRAINT "sym_fk_sec_2_node" FOREIGN KEY ("node_id") REFERENCES "sym_node" ("node_id")
2018-09-26 10:42:27,246 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "sym_router"
ADD CONSTRAINT "sym_fk_rt_2_grp_lnk" FOREIGN KEY ("source_node_group_id", "target_node_group_id") REFERENCES "sym_node_group_link" ("source_node_group_id", "target_node_group_id")
2018-09-26 10:42:27,246 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "sym_transform_table"
ADD CONSTRAINT "sym_fk_tt_2_grp_lnk" FOREIGN KEY ("source_node_group_id", "target_node_group_id") REFERENCES "sym_node_group_link" ("source_node_group_id", "target_node_group_id")
2018-09-26 10:42:27,246 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "sym_trigger"
ADD CONSTRAINT "sym_fk_trg_2_chnl" FOREIGN KEY ("channel_id") REFERENCES "sym_channel" ("channel_id")
2018-09-26 10:42:27,246 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "sym_trigger"
ADD CONSTRAINT "sym_fk_trg_2_rld_chnl" FOREIGN KEY ("reload_channel_id") REFERENCES "sym_channel" ("channel_id")
2018-09-26 10:42:27,246 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "sym_trigger_router"
ADD CONSTRAINT "sym_fk_tr_2_trg" FOREIGN KEY ("trigger_id") REFERENCES "sym_trigger" ("trigger_id")
2018-09-26 10:42:27,262 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "sym_trigger_router"
ADD CONSTRAINT "sym_fk_tr_2_rtr" FOREIGN KEY ("router_id") REFERENCES "sym_router" ("router_id")
2018-09-26 10:42:27,262 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "sym_trigger_router_grouplet"
ADD CONSTRAINT "sym_fk_trgplt_2_gplt" FOREIGN KEY ("grouplet_id") REFERENCES "sym_grouplet" ("grouplet_id")
2018-09-26 10:42:27,262 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: ALTER TABLE "sym_trigger_router_grouplet"
ADD CONSTRAINT "sym_fk_trgplt_2_tr" FOREIGN KEY ("trigger_id", "router_id") REFERENCES "sym_trigger_router" ("trigger_id", "router_id")
2018-09-26 10:42:27,262 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: CREATE INDEX "sym_idx_ib_time_status" ON "facets540xts"."dbo"."sym_incoming_batch" ("create_time", "status")
2018-09-26 10:42:27,277 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: CREATE INDEX "sym_idx_nd_hst_chnl_sts" ON "facets540xts"."dbo"."sym_node_host_channel_stats" ("node_id", "start_time", "end_time")
2018-09-26 10:42:27,277 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: CREATE INDEX "sym_idx_nd_hst_job" ON "facets540xts"."dbo"."sym_node_host_job_stats" ("node_id", "start_time", "end_time")
2018-09-26 10:42:27,277 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: CREATE INDEX "sym_idx_nd_hst_sts" ON "facets540xts"."dbo"."sym_node_host_stats" ("node_id", "start_time", "end_time")
2018-09-26 10:42:27,277 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] DDL applied: CREATE INDEX "sym_idx_trigg_hist_1" ON "facets540xts"."dbo"."sym_trigger_hist" ("trigger_id", "inactive_time")
2018-09-26 10:42:27,277 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] Done with auto update of SymmetricDS tables
2018-09-26 10:42:27,293 INFO [store-001] [MsSqlSymmetricDialect] [symmetric-engine-startup-2] Updating indexes to prevent lock escalation
2018-09-26 10:42:27,355 INFO [store-001] [ConfigurationService] [symmetric-engine-startup-2] Auto-configuring config channel
2018-09-26 10:42:27,402 INFO [store-001] [ConfigurationService] [symmetric-engine-startup-2] Auto-configuring reload channel
2018-09-26 10:42:27,402 INFO [store-001] [ConfigurationService] [symmetric-engine-startup-2] Auto-configuring monitor channel
2018-09-26 10:42:27,402 INFO [store-001] [ConfigurationService] [symmetric-engine-startup-2] Auto-configuring heartbeat channel
2018-09-26 10:42:27,402 INFO [store-001] [ConfigurationService] [symmetric-engine-startup-2] Auto-configuring default channel
2018-09-26 10:42:27,418 INFO [store-001] [ConfigurationService] [symmetric-engine-startup-2] Auto-configuring dynamic channel
2018-09-26 10:42:27,465 INFO [store-001] [AbstractSymmetricEngine] [symmetric-engine-startup-2] Done initializing SymmetricDS database
2018-09-26 10:42:27,465 INFO [store-001] [AbstractSymmetricEngine] [symmetric-engine-startup-2] SymmetricDS database version : null
2018-09-26 10:42:27,465 INFO [store-001] [AbstractSymmetricEngine] [symmetric-engine-startup-2] SymmetricDS software version : 3.9.13
2018-09-26 10:42:27,480 INFO [store-001] [AbstractSymmetricEngine] [symmetric-engine-startup-2] Starting unregistered node [group=store, externalId=001]
2018-09-26 10:42:27,512 INFO [store-001] [RouterJob] [symmetric-engine-startup-2] Starting Routing on periodic schedule: every 5000ms with the first run at Wed Sep 26 10:42:34 CDT 2018
2018-09-26 10:42:27,527 INFO [store-001] [PushJob] [symmetric-engine-startup-2] Starting Push on periodic schedule: every 10000ms with the first run at Wed Sep 26 10:42:34 CDT 2018
2018-09-26 10:42:27,527 ERROR [store-001] [AbstractSymmetricEngine] [symmetric-engine-startup-2] An error occurred while starting SymmetricDS StackTraceKey.init [IllegalArgumentException:322018706]
java.lang.IllegalArgumentException: Cron expression must consist of 6 fields (found 1 in "10000 ")
at org.springframework.scheduling.support.CronSequenceGenerator.parse(CronSequenceGenerator.java:271)
at org.springframework.scheduling.support.CronSequenceGenerator.<init>(CronSequenceGenerator.java:96)
at org.springframework.scheduling.support.CronSequenceGenerator.<init>(CronSequenceGenerator.java:83)
at org.springframework.scheduling.support.CronTrigger.<init>(CronTrigger.java:44)
at org.jumpmind.symmetric.job.AbstractJob.start(AbstractJob.java:112)
at org.jumpmind.symmetric.job.JobManager.startJobs(JobManager.java:117)
at org.jumpmind.symmetric.AbstractSymmetricEngine.start(AbstractSymmetricEngine.java:690)
at org.jumpmind.symmetric.AbstractSymmetricEngine.start(AbstractSymmetricEngine.java:634)
at org.jumpmind.symmetric.ClientSymmetricEngine.start(ClientSymmetricEngine.java:277)
at org.jumpmind.symmetric.web.SymmetricEngineHolder$EngineStarter.run(SymmetricEngineHolder.java:600)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
2018-09-26 10:42:27,559 INFO [store-001] [AbstractSymmetricEngine] [symmetric-engine-startup-2] Stopping SymmetricDS externalId=001 version=3.9.13 database=Microsoft SQL Server
2018-09-26 10:42:27,559 INFO [store-001] [RouterJob] [symmetric-engine-startup-2] The 'Routing' job has been cancelled
2018-09-26 10:42:27,559 INFO [store-001] [PushJob] [symmetric-engine-startup-2] The 'Push' job has been cancelled
2018-09-26 10:42:27,559 INFO [store-001] [AbstractSymmetricEngine] [symmetric-engine-startup-2]
2018-09-26 10:42:28,965 INFO [corp-000] [AbstractSymmetricEngine] [symmetric-engine-startup-1] Done initializing SymmetricDS database
2018-09-26 10:42:28,965 INFO [corp-000] [AbstractSymmetricEngine] [symmetric-engine-startup-1] SymmetricDS database version : 3.9.13
2018-09-26 10:42:28,965 INFO [corp-000] [AbstractSymmetricEngine] [symmetric-engine-startup-1] SymmetricDS software version : 3.9.13
2018-09-26 10:42:29,043 INFO [corp-000] [AbstractSymmetricEngine] [symmetric-engine-startup-1] Starting registered node [group=corp, id=000, nodeId=000]
2018-09-26 10:42:29,043 INFO [corp-000] [ClusterService] [symmetric-engine-startup-1] This node picked a server id of APSET4305
2018-09-26 10:42:29,043 INFO [corp-000] [TriggerRouterService] [symmetric-engine-startup-1] Synchronizing triggers
2018-09-26 10:42:35,230 INFO [corp-000] [TriggerRouterService] [symmetric-engine-startup-1] Done synchronizing triggers
2018-09-26 10:42:35,262 INFO [corp-000] [RouterJob] [symmetric-engine-startup-1] Starting Routing on periodic schedule: every 10000ms with the first run at Wed Sep 26 10:42:45 CDT 2018
2018-09-26 10:42:35,262 INFO [corp-000] [PushJob] [symmetric-engine-startup-1] Starting Push on periodic schedule: every 60000ms with the first run at Wed Sep 26 10:42:45 CDT 2018
2018-09-26 10:42:35,262 INFO [corp-000] [PullJob] [symmetric-engine-startup-1] Starting Pull on periodic schedule: every 60000ms with the first run at Wed Sep 26 10:42:45 CDT 2018
2018-09-26 10:42:35,262 INFO [corp-000] [JobManager] [symmetric-engine-startup-1] Job Offline Push not configured for auto start
2018-09-26 10:42:35,262 INFO [corp-000] [JobManager] [symmetric-engine-startup-1] Job Offline Pull not configured for auto start
2018-09-26 10:42:35,262 INFO [corp-000] [OutgoingPurgeJob] [symmetric-engine-startup-1] Starting job 'Purge Outgoing' with cron expression: '0 0 0 * * '
2018-09-26 10:42:35,262 INFO [corp-000] [IncomingPurgeJob] [symmetric-engine-startup-1] Starting job 'Purge Incoming' with cron expression: '0 0 0 * * '
2018-09-26 10:42:35,277 INFO [corp-000] [StatisticFlushJob] [symmetric-engine-startup-1] Starting job 'Stat Flush' with cron expression: '0 0/5 * * * '
2018-09-26 10:42:35,277 INFO [corp-000] [SyncTriggersJob] [symmetric-engine-startup-1] Starting job 'SyncTriggers' with cron expression: '0 0 0 * * '
2018-09-26 10:42:35,277 INFO [corp-000] [HeartbeatJob] [symmetric-engine-startup-1] Starting Heartbeat on periodic schedule: every 900000ms with the first run at Wed Sep 26 10:42:45 CDT 2018
2018-09-26 10:42:35,277 INFO [corp-000] [WatchdogJob] [symmetric-engine-startup-1] Starting Watchdog on periodic schedule: every 3600000ms with the first run at Wed Sep 26 10:42:45 CDT 2018
2018-09-26 10:42:35,277 INFO [corp-000] [StageManagementJob] [symmetric-engine-startup-1] Starting job 'Stage Management' with cron expression: '0 0 * * * *'
2018-09-26 10:42:35,277 INFO [corp-000] [JobManager] [symmetric-engine-startup-1] Job Refresh Cache not configured for auto start
2018-09-26 10:42:35,277 INFO [corp-000] [JobManager] [symmetric-engine-startup-1] Job File Sync Tracker not configured for auto start
2018-09-26 10:42:35,277 INFO [corp-000] [JobManager] [symmetric-engine-startup-1] Job File Sync Pull not configured for auto start
2018-09-26 10:42:35,277 INFO [corp-000] [JobManager] [symmetric-engine-startup-1] Job File Sync Push not configured for auto start
2018-09-26 10:42:35,277 INFO [corp-000] [InitialLoadExtractorJob] [symmetric-engine-startup-1] Starting Initial Load Extract on periodic schedule: every 10000ms with the first run at Wed Sep 26 10:42:45 CDT 2018
2018-09-26 10:42:35,277 INFO [corp-000] [MonitorJob] [symmetric-engine-startup-1] Starting Monitor on periodic schedule: every 60000ms with the first run at Wed Sep 26 10:42:45 CDT 2018
2018-09-26 10:42:35,277 INFO [corp-000] [JobManager] [symmetric-engine-startup-1] Job Report Status not configured for auto start
2018-09-26 10:42:35,277 INFO [corp-000] [AbstractSymmetricEngine] [symmetric-engine-startup-1] SymmetricDS Node STARTED:
nodeId=000
groupId=corp
type=server
subType=null
name=corp-000
softwareVersion=3.9.13
databaseName=Adaptive Server Enterprise
databaseVersion=15.5
driverName=jConnect (TM) for JDBC (TM)
driverVersion=jConnect (TM) for JDBC(TM)/7.00(Build 26502)/P/EBF17993/JDK16/Thu Jun 3 3:09:09 2010
uptime=0 sec.
2018-09-26 10:42:45,168 INFO [corp-000] [NodeCommunicationService] [corp-000-job-3] pull will use 10 threads
2018-09-26 10:42:45,324 INFO [corp-000] [DataGapFastDetector] [corp-000-job-1] Full gap analysis is running
2018-09-26 10:42:45,387 INFO [corp-000] [DataGapFastDetector] [corp-000-job-1] Querying data in gaps from database took 63 ms
2018-09-26 10:42:45,387 INFO [corp-000] [DataGapFastDetector] [corp-000-job-1] Full gap analysis is done after 63 ms
2018-09-26 10:42:45,527 INFO [corp-000] [RouterService] [corp-000-job-1] The 'heartbeat' channel is NOT in common batch mode
2018-09-26 10:42:45,980 INFO [corp-000] [RouterService] [corp-000-job-1] Routed 2 data events in 656 ms
2018-09-26 10:42:56,183 INFO [corp-000] [DataGapFastDetector] [corp-000-job-10] Full gap analysis is running
2018-09-26 10:42:56,262 INFO [corp-000] [DataGapFastDetector] [corp-000-job-10] Querying data in gaps from database took 79 ms
2018-09-26 10:42:56,262 INFO [corp-000] [DataGapFastDetector] [corp-000-job-10] Full gap analysis is done after 79 ms
2018-09-26 10:43:06,480 INFO [corp-000] [DataGapFastDetector] [corp-000-job-11] Full gap analysis is running
2018-09-26 10:43:06,543 INFO [corp-000] [DataGapFastDetector] [corp-000-job-11] Querying data in gaps from database took 63 ms
2018-09-26 10:43:06,558 INFO [corp-000] [DataGapFastDetector] [corp-000-job-11] Full gap analysis is done after 78 ms
2018-09-26 10:43:16,746 INFO [corp-000] [DataGapFastDetector] [corp-000-job-13] Full gap analysis is running
2018-09-26 10:43:16,808 INFO [corp-000] [DataGapFastDetector] [corp-000-job-13] Querying data in gaps from database took 62 ms
2018-09-26 10:43:16,808 INFO [corp-000] [DataGapFastDetector] [corp-000-job-13] Full gap analysis is done after 62 ms
2018-09-26 10:43:27,027 INFO [corp-000] [DataGapFastDetector] [corp-000-job-14] Full gap analysis is running
2018-09-26 10:43:27,090 INFO [corp-000] [DataGapFastDetector] [corp-000-job-14] Querying data in gaps from database took 63 ms
2018-09-26 10:43:27,090 INFO [corp-000] [DataGapFastDetector] [corp-000-job-14] Full gap analysis is done after 63 ms
2018-09-26 10:43:37,277 INFO [corp-000] [DataGapFastDetector] [corp-000-job-3] Full gap analysis is running
2018-09-26 10:43:37,340 INFO [corp-000] [DataGapFastDetector] [corp-000-job-3] Querying data in gaps from database took 63 ms
2018-09-26 10:43:37,340 INFO [corp-000] [DataGapFastDetector] [corp-000-job-3] Full gap analysis is done after 63 ms
2018-09-26 10:43:47,543 INFO [corp-000] [DataGapFastDetector] [corp-000-job-17] Full gap analysis is running
2018-09-26 10:43:47,605 INFO [corp-000] [DataGapFastDetector] [corp-000-job-17] Querying data in gaps from database took 62 ms
2018-09-26 10:43:47,605 INFO [corp-000] [DataGapFastDetector] [corp-000-job-17] Full gap analysis is done after 62 ms
2018-09-26 10:43:57,793 INFO [corp-000] [DataGapFastDetector] [corp-000-job-18] Full gap analysis is running
2018-09-26 10:43:57,871 INFO [corp-000] [DataGapFastDetector] [corp-000-job-18] Querying data in gaps from database took 78 ms
2018-09-26 10:43:57,871 INFO [corp-000] [DataGapFastDetector] [corp-000-job-18] Full gap analysis is done after 78 ms
2018-09-26 10:44:08,058 INFO [corp-000] [DataGapFastDetector] [corp-000-job-19] Full gap analysis is running
2018-09-26 10:44:08,121 INFO [corp-000] [DataGapFastDetector] [corp-000-job-19] Querying data in gaps from database took 63 ms
2018-09-26 10:44:08,121 INFO [corp-000] [DataGapFastDetector] [corp-000-job-19] Full gap analysis is done after 63 ms
2018-09-26 10:44:18,308 INFO [corp-000] [DataGapFastDetector] [corp-000-job-20] Full gap analysis is running
2018-09-26 10:44:18,371 INFO [corp-000] [DataGapFastDetector] [corp-000-job-20] Querying data in gaps from database took 63 ms
2018-09-26 10:44:18,371 INFO [corp-000] [DataGapFastDetector] [corp-000-job-20] Full gap analysis is done after 63 ms
2018-09-26 10:44:28,558 INFO [corp-000] [DataGapFastDetector] [corp-000-job-12] Full gap analysis is running
2018-09-26 10:44:28,621 INFO [corp-000] [DataGapFastDetector] [corp-000-job-12] Querying data in gaps from database took 63 ms
2018-09-26 10:44:28,621 INFO [corp-000] [DataGapFastDetector] [corp-000-job-12] Full gap analysis is done after 63 ms
2018-09-26 10:44:38,808 INFO [corp-000] [DataGapFastDetector] [corp-000-job-5] Full gap analysis is running
2018-09-26 10:44:38,870 INFO [corp-000] [DataGapFastDetector] [corp-000-job-5] Querying data in gaps from database took 62 ms
2018-09-26 10:44:38,870 INFO [corp-000] [DataGapFastDetector] [corp-000-job-5] Full gap analysis is done after 62 ms
2018-09-26 10:44:49,058 INFO [corp-000] [DataGapFastDetector] [corp-000-job-3] Full gap analysis is running
2018-09-26 10:44:49,120 INFO [corp-000] [DataGapFastDetector] [corp-000-job-3] Querying data in gaps from database took 62 ms
2018-09-26 10:44:49,120 INFO [corp-000] [DataGapFastDetector] [corp-000-job-3] Full gap analysis is done after 62 ms
2018-09-26 10:44:55,569 INFO [] [AbstractCommandLauncher] [main] Option: name=engine, value={corp-000}
2018-09-26 10:44:56,428 INFO [] [SymmetricUtils] [main]
_ __ _ _____
/ / __ __ __ ___ __ ___ / / ()___ / __ | / ___/
_ \ / / / / _
_ \/ _\/ _ \/ // / / / / / / / _ \/ // // / // // / // // / __// / / / / / / / // / ___/ /
/____/ _ ///////////_/ _/ // //_/ /__/ /_/
//
+-----------------------------------------------------------------+
| Copyright (C) 2007-2018 JumpMind, Inc. |
| |
| Licensed under the GNU General Public License version 3. |
| This software comes with ABSOLUTELY NO WARRANTY. |
| See http://www.gnu.org/licenses/gpl.html |
+-----------------------------------------------------------------+
2018-09-26 10:44:56,460 INFO [corp-000] [AbstractSymmetricEngine] [main] Initializing connection to database
2018-09-26 10:44:56,694 INFO [corp-000] [JdbcDatabasePlatformFactory] [main] Detected database 'Adaptive Server Enterprise', version '15', protocol 'sybase'
2018-09-26 10:44:56,725 INFO [corp-000] [JdbcDatabasePlatformFactory] [main] The IDatabasePlatform being used is org.jumpmind.db.platform.ase.AseDatabasePlatform
2018-09-26 10:44:57,006 INFO [corp-000] [AseSymmetricDialect] [main] The DbDialect being used is org.jumpmind.symmetric.db.ase.AseSymmetricDialect
2018-09-26 10:44:57,116 INFO [corp-000] [ExtensionService] [main] Found 0 extension points from the database that will be registered
2018-09-26 10:44:57,131 INFO [corp-000] [StagingManager] [main] The staging directory was initialized at the following location: E:\symmetric-server-3.9.13\tmp\corp-000
2018-09-26 10:44:58,256 INFO [corp-000] [ExtensionService] [main] Found 0 extension points from the database that will be registered
2018-09-26 10:44:58,256 INFO [corp-000] [ClientExtensionService] [main] Found 6 extension points from spring that will be registered
2018-09-26 10:44:59,303 INFO [corp-000] [DataGapFastDetector] [corp-000-job-15] Full gap analysis is running
2018-09-26 10:44:59,366 INFO [corp-000] [DataGapFastDetector] [corp-000-job-15] Querying data in gaps from database took 63 ms
2018-09-26 10:44:59,366 INFO [corp-000] [DataGapFastDetector] [corp-000-job-15] Full gap analysis is done after 63 ms
2018-09-26 10:44:59,413 INFO [corp-000] [RouterService] [corp-000-job-15] The 'config' channel is NOT in common batch mode
2018-09-26 10:44:59,600 INFO [corp-000] [ConfigurationChangedDataRouter] [corp-000-job-15] About to refresh the cache of node security because new configuration came through the data router
2018-09-26 10:44:59,600 INFO [corp-000] [RouterService] [corp-000-job-15] Routed 1 data events in 297 ms
2018-09-26 10:45:09,819 INFO [corp-000] [DataGapFastDetector] [corp-000-job-17] Full gap analysis is running
2018-09-26 10:45:09,944 INFO [corp-000] [DataGapFastDetector] [corp-000-job-17] Querying data in gaps from database took 78 ms
2018-09-26 10:45:09,944 INFO [corp-000] [DataGapFastDetector] [corp-000-job-17] Full gap analysis is done after 78 ms
2018-09-26 10:45:20,288 INFO [corp-000] [DataGapFastDetector] [corp-000-job-18] Full gap analysis is running
2018-09-26 10:45:20,366 INFO [corp-000] [DataGapFastDetector] [corp-000-job-18] Querying data in gaps from database took 78 ms
2018-09-26 10:45:20,366 INFO [corp-000] [DataGapFastDetector] [corp-000-job-18] Full gap analysis is done after 78 ms
2018-09-26 10:45:24,227 INFO [] [AbstractCommandLauncher] [main] Option: name=engine, value={corp-000}
2018-09-26 10:45:25,055 INFO [] [SymmetricUtils] [main]
_ __ _ __ _____
/ / __ __ __ ___ __ ___ / / ____() / __ | / /
_ \ / / / / _
_ \/ _\/ _ \/ __// __/ / __/ / / / / _ \/ // // / // // / // // / // / / / / / / / // / / /
// _ ///////////_/ _/ // //_/ /__/ /_/
/_/
+-----------------------------------------------------------------+
| Copyright (C) 2007-2018 JumpMind, Inc. |
| |
| Licensed under the GNU General Public License version 3. |
| This software comes with ABSOLUTELY NO WARRANTY. |
| See http://www.gnu.org/licenses/gpl.html |
+-----------------------------------------------------------------+
2018-09-26 10:45:25,070 INFO [corp-000] [AbstractSymmetricEngine] [main] Initializing connection to database
2018-09-26 10:45:25,258 INFO [corp-000] [JdbcDatabasePlatformFactory] [main] Detected database 'Adaptive Server Enterprise', version '15', protocol 'sybase'
2018-09-26 10:45:25,289 INFO [corp-000] [JdbcDatabasePlatformFactory] [main] The IDatabasePlatform being used is org.jumpmind.db.platform.ase.AseDatabasePlatform
2018-09-26 10:45:25,539 INFO [corp-000] [AseSymmetricDialect] [main] The DbDialect being used is org.jumpmind.symmetric.db.ase.AseSymmetricDialect
2018-09-26 10:45:25,664 INFO [corp-000] [ExtensionService] [main] Found 0 extension points from the database that will be registered
2018-09-26 10:45:25,664 INFO [corp-000] [StagingManager] [main] The staging directory was initialized at the following location: E:\symmetric-server-3.9.13\tmp\corp-000
2018-09-26 10:45:26,695 INFO [corp-000] [ExtensionService] [main] Found 0 extension points from the database that will be registered
2018-09-26 10:45:26,695 INFO [corp-000] [ClientExtensionService] [main] Found 6 extension points from spring that will be registered
2018-09-26 10:45:30,555 INFO [corp-000] [DataGapFastDetector] [corp-000-job-19] Full gap analysis is running
2018-09-26 10:45:30,617 INFO [corp-000] [DataGapFastDetector] [corp-000-job-19] Querying data in gaps from database took 62 ms
2018-09-26 10:45:30,617 INFO [corp-000] [DataGapFastDetector] [corp-000-job-19] Full gap analysis is done after 62 ms
2018-09-26 10:45:30,789 INFO [corp-000] [ConfigurationChangedDataRouter] [corp-000-job-19] About to refresh the cache of node security because new configuration came through the data router
2018-09-26 10:45:30,805 INFO [corp-000] [RouterService] [corp-000-job-19] Routed 1 data events in 250 ms
2018-09-26 10:45:41,023 INFO [corp-000] [DataGapFastDetector] [corp-000-job-20] Full gap analysis is running
2018-09-26 10:45:41,086 INFO [corp-000] [DataGapFastDetector] [corp-000-job-20] Querying data in gaps from database took 63 ms
2018-09-26 10:45:41,086 INFO [corp-000] [DataGapFastDetector] [corp-000-job-20] Full gap analysis is done after 63 ms</init></init></init>