View Issue Details

Related ChangesetsJump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0004786SymmetricDSBugpublic2021-01-26 08:352021-02-25 21:33
Reporterkraynopp Assigned Toelong  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.12.6 
Target Version3.12.7Fixed in Version3.12.7 
Summary0004786: Force trigger regenerate does not work properly
DescriptionExecuting ./symadmin sync-triggers -f removes all triggers instead of re-create. Tested in oracle and postgres. Version 3.12.5 works right.
TagsNo tags attached.

Relationships

related to 0004410 closedelong SymmetricDS Pro "Reconnect" to database for SymmetricDS installation fails with security exception 

Activities

josh-a-hicks

2021-01-27 18:29

developer   ~0001884

This command will remove them and then recreate them. Is it possible it is unable to recreate because of an error? Can you send the log when this occurs?

kraynopp

2021-01-28 06:04

reporter   ~0001885

Yes, of couse.

Log for SymmetricDS version 3.12.5

./symadmin sync-triggers -f

2021-01-28 08:40:03,135 INFO [] [AbstractCommandLauncher] [main] Option: name=force, value={}
2021-01-28 08:40:04,034 INFO [] [SymmetricUtils] [main]
   _____ __ _ ____ _____
  / ___/ __ _____ __ ___ __ ___ _/ /_ ____(_)___ / __ | / ___/
  \__ \ / / / / _ `_ \/ _ `_ \/ _ \/_ __// __/ / __/ / / / / \__ \
 ___/ // /_/ / // // / // // / __// / / / / / /_ / /_/ / ___/ /
/____/ \__ /_//_//_/_//_//_/\___/ \_/ /_/ /_/\__/ /_____/ /____/
      /____/
+-----------------------------------------------------------------+
| Copyright (C) 2007-2020 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 |
+-----------------------------------------------------------------+
2021-01-28 08:40:04,049 INFO [pgsql-000] [AbstractSymmetricEngine] [main] Initializing connection to database
2021-01-28 08:40:04,244 INFO [pgsql-000] [JdbcDatabasePlatformFactory] [main] Detected database 'postgres95', version '9', protocol 'postgresql'
2021-01-28 08:40:04,268 INFO [pgsql-000] [JdbcDatabasePlatformFactory] [main] The IDatabasePlatform being used is org.jumpmind.db.platform.postgresql.PostgreSql95DatabasePlatform
2021-01-28 08:40:04,402 INFO [pgsql-000] [PostgreSqlSymmetricDialect] [main] The DbDialect being used is org.jumpmind.symmetric.db.postgresql.PostgreSqlSymmetricDialect
2021-01-28 08:40:04,454 INFO [pgsql-000] [ExtensionService] [main] Found 0 extension points from the database that will be registered
2021-01-28 08:40:04,469 INFO [pgsql-000] [StagingManager] [main] The staging directory was initialized at the following location: /opt/symmetric-server-test/tmp/pgsql-000
2021-01-28 08:40:05,378 INFO [pgsql-000] [ExtensionService] [main] Found 0 extension points from the database that will be registered
2021-01-28 08:40:05,378 INFO [pgsql-000] [ClientExtensionService] [main] Found 7 extension points from spring that will be registered
2021-01-28 08:40:05,381 INFO [pgsql-000] [ClusterService] [main] This node picked a server id of sympg
2021-01-28 08:40:05,381 INFO [pgsql-000] [TriggerRouterService] [main] Synchronizing triggers
2021-01-28 08:40:06,328 INFO [pgsql-000] [PostgreSqlSymmetricDialect] [pgsql-000-sync-triggers-1] Creating TST_ON_I_FOR_TST_TRNSFRM_CLMN_PGSQL trigger for symtst.tst_transform_column
2021-01-28 08:40:06,376 INFO [pgsql-000] [PostgreSqlSymmetricDialect] [pgsql-000-sync-triggers-1] Creating TST_ON_U_FOR_TST_TRNSFRM_CLMN_PGSQL trigger for symtst.tst_transform_column
2021-01-28 08:40:06,394 INFO [pgsql-000] [PostgreSqlSymmetricDialect] [pgsql-000-sync-triggers-1] Creating TST_ON_D_FOR_TST_TRNSFRM_CLMN_PGSQL trigger for symtst.tst_transform_column
2021-01-28 08:40:06,460 INFO [pgsql-000] [PostgreSqlSymmetricDialect] [pgsql-000-sync-triggers-1] Creating TST_ON_I_FOR_TST_TRGGR_PGSQL trigger for symtst.tst_trigger
2021-01-28 08:40:06,493 INFO [pgsql-000] [PostgreSqlSymmetricDialect] [pgsql-000-sync-triggers-1] Creating TST_ON_U_FOR_TST_TRGGR_PGSQL trigger for symtst.tst_trigger
2021-01-28 08:40:06,525 INFO [pgsql-000] [PostgreSqlSymmetricDialect] [pgsql-000-sync-triggers-1] Creating TST_ON_D_FOR_TST_TRGGR_PGSQL trigger for symtst.tst_trigger
2021-01-28 08:40:06,581 INFO [pgsql-000] [PostgreSqlSymmetricDialect] [pgsql-000-sync-triggers-1] Creating TST_ON_I_FOR_TST_JB_PGSQL trigger for symtst.tst_job
2021-01-28 08:40:06,593 INFO [pgsql-000] [PostgreSqlSymmetricDialect] [pgsql-000-sync-triggers-1] Creating TST_ON_U_FOR_TST_JB_PGSQL trigger for symtst.tst_job
2021-01-28 08:40:06,608 INFO [pgsql-000] [PostgreSqlSymmetricDialect] [pgsql-000-sync-triggers-1] Creating TST_ON_D_FOR_TST_JB_PGSQL trigger for symtst.tst_job
2021-01-28 08:40:06,658 INFO [pgsql-000] [PostgreSqlSymmetricDialect] [pgsql-000-sync-triggers-1] Creating TST_ON_I_FOR_TST_LD_FLTR_PGSQL trigger for symtst.tst_load_filter
2021-01-28 08:40:06,680 INFO [pgsql-000] [PostgreSqlSymmetricDialect] [pgsql-000-sync-triggers-1] Creating TST_ON_U_FOR_TST_LD_FLTR_PGSQL trigger for symtst.tst_load_filter
2021-01-28 08:40:06,699 INFO [pgsql-000] [PostgreSqlSymmetricDialect] [pgsql-000-sync-triggers-1] Creating TST_ON_D_FOR_TST_LD_FLTR_PGSQL trigger for symtst.tst_load_filter
2021-01-28 08:40:06,744 INFO [pgsql-000] [PostgreSqlSymmetricDialect] [pgsql-000-sync-triggers-1] Creating TST_ON_I_FOR_TST_MNTR_PGSQL trigger for symtst.tst_monitor
2021-01-28 08:40:06,758 INFO [pgsql-000] [PostgreSqlSymmetricDialect] [pgsql-000-sync-triggers-1] Creating TST_ON_U_FOR_TST_MNTR_PGSQL trigger for symtst.tst_monitor
2021-01-28 08:40:06,775 INFO [pgsql-000] [PostgreSqlSymmetricDialect] [pgsql-000-sync-triggers-1] Creating TST_ON_D_FOR_TST_MNTR_PGSQL trigger for symtst.tst_monitor
2021-01-28 08:40:06,821 INFO [pgsql-000] [PostgreSqlSymmetricDialect] [pgsql-000-sync-triggers-1] Creating TST_ON_I_FOR_TST_TBL_RLD_RQST_PGSQL trigger for symtst.tst_table_reload_request
2021-01-28 08:40:06,839 INFO [pgsql-000] [PostgreSqlSymmetricDialect] [pgsql-000-sync-triggers-1] Creating TST_ON_U_FOR_TST_TBL_RLD_RQST_PGSQL trigger for symtst.tst_table_reload_request
2021-01-28 08:40:06,853 INFO [pgsql-000] [PostgreSqlSymmetricDialect] [pgsql-000-sync-triggers-1] Creating TST_ON_D_FOR_TST_TBL_RLD_RQST_PGSQL trigger for symtst.tst_table_reload_request
2021-01-28 08:40:06,904 INFO [pgsql-000] [PostgreSqlSymmetricDialect] [pgsql-000-sync-triggers-1] Creating TST_ON_I_FOR_TST_ND_GRP_CHNNL_WND_PGSQL trigger for symtst.tst_node_group_channel_wnd
2021-01-28 08:40:06,913 INFO [pgsql-000] [PostgreSqlSymmetricDialect] [pgsql-000-sync-triggers-1] Creating TST_ON_U_FOR_TST_ND_GRP_CHNNL_WND_PGSQL trigger for symtst.tst_node_group_channel_wnd
2021-01-28 08:40:06,923 INFO [pgsql-000] [PostgreSqlSymmetricDialect] [pgsql-000-sync-triggers-1] Creating TST_ON_D_FOR_TST_ND_GRP_CHNNL_WND_PGSQL trigger for symtst.tst_node_group_channel_wnd
2021-01-28 08:40:06,970 INFO [pgsql-000] [PostgreSqlSymmetricDialect] [pgsql-000-sync-triggers-1] Creating TST_ON_I_FOR_TST_ND_GRP_PGSQL trigger for symtst.tst_node_group
2021-01-28 08:40:06,985 INFO [pgsql-000] [PostgreSqlSymmetricDialect] [pgsql-000-sync-triggers-1] Creating TST_ON_U_FOR_TST_ND_GRP_PGSQL trigger for symtst.tst_node_group
2021-01-28 08:40:06,996 INFO [pgsql-000] [PostgreSqlSymmetricDialect] [pgsql-000-sync-triggers-1] Creating TST_ON_D_FOR_TST_ND_GRP_PGSQL trigger for symtst.tst_node_group
2021-01-28 08:40:07,047 INFO [pgsql-000] [PostgreSqlSymmetricDialect] [pgsql-000-sync-triggers-1] Creating TST_ON_I_FOR_TST_ND_HST_PGSQL trigger for symtst.tst_node_host
2021-01-28 08:40:07,062 INFO [pgsql-000] [PostgreSqlSymmetricDialect] [pgsql-000-sync-triggers-1] Creating TST_ON_U_FOR_TST_ND_HST_PGSQL trigger for symtst.tst_node_host
2021-01-28 08:40:07,079 INFO [pgsql-000] [PostgreSqlSymmetricDialect] [pgsql-000-sync-triggers-1] Creating TST_ON_D_FOR_TST_ND_HST_PGSQL trigger for symtst.tst_node_host
2021-01-28 08:40:07,122 INFO [pgsql-000] [PostgreSqlSymmetricDialect] [pgsql-000-sync-triggers-1] Creating TST_ON_I_FOR_TST_NTFCTN_PGSQL trigger for symtst.tst_notification
2021-01-28 08:40:07,132 INFO [pgsql-000] [PostgreSqlSymmetricDialect] [pgsql-000-sync-triggers-1] Creating TST_ON_U_FOR_TST_NTFCTN_PGSQL trigger for symtst.tst_notification
2021-01-28 08:40:07,143 INFO [pgsql-000] [PostgreSqlSymmetricDialect] [pgsql-000-sync-triggers-1] Creating TST_ON_D_FOR_TST_NTFCTN_PGSQL trigger for symtst.tst_notification
2021-01-28 08:40:07,183 INFO [pgsql-000] [PostgreSqlSymmetricDialect] [pgsql-000-sync-triggers-1] Creating TST_ON_I_FOR_TST_GRPLT_LNK_PGSQL trigger for symtst.tst_grouplet_link
2021-01-28 08:40:07,195 INFO [pgsql-000] [PostgreSqlSymmetricDialect] [pgsql-000-sync-triggers-1] Creating TST_ON_U_FOR_TST_GRPLT_LNK_PGSQL trigger for symtst.tst_grouplet_link
2021-01-28 08:40:07,208 INFO [pgsql-000] [PostgreSqlSymmetricDialect] [pgsql-000-sync-triggers-1] Creating TST_ON_D_FOR_TST_GRPLT_LNK_PGSQL trigger for symtst.tst_grouplet_link
2021-01-28 08:40:07,279 INFO [pgsql-000] [PostgreSqlSymmetricDialect] [pgsql-000-sync-triggers-1] Creating TST_ON_I_FOR_TST_TRGGR_RTR_GRPLT_PGSQL trigger for symtst.tst_trigger_router_grouplet
2021-01-28 08:40:07,290 INFO [pgsql-000] [PostgreSqlSymmetricDialect] [pgsql-000-sync-triggers-1] Creating TST_ON_U_FOR_TST_TRGGR_RTR_GRPLT_PGSQL trigger for symtst.tst_trigger_router_grouplet
2021-01-28 08:40:07,300 INFO [pgsql-000] [PostgreSqlSymmetricDialect] [pgsql-000-sync-triggers-1] Creating TST_ON_D_FOR_TST_TRGGR_RTR_GRPLT_PGSQL trigger for symtst.tst_trigger_router_grouplet
2021-01-28 08:40:07,338 INFO [pgsql-000] [PostgreSqlSymmetricDialect] [pgsql-000-sync-triggers-1] Creating TST_ON_I_FOR_TST_XTNSN_PGSQL trigger for symtst.tst_extension
2021-01-28 08:40:07,348 INFO [pgsql-000] [PostgreSqlSymmetricDialect] [pgsql-000-sync-triggers-1] Creating TST_ON_U_FOR_TST_XTNSN_PGSQL trigger for symtst.tst_extension
2021-01-28 08:40:07,359 INFO [pgsql-000] [PostgreSqlSymmetricDialect] [pgsql-000-sync-triggers-1] Creating TST_ON_D_FOR_TST_XTNSN_PGSQL trigger for symtst.tst_extension
2021-01-28 08:40:07,404 INFO [pgsql-000] [PostgreSqlSymmetricDialect] [pgsql-000-sync-triggers-1] Creating TST_ON_I_FOR_TST_TRGGR_RTR_PGSQL trigger for symtst.tst_trigger_router
2021-01-28 08:40:07,420 INFO [pgsql-000] [PostgreSqlSymmetricDialect] [pgsql-000-sync-triggers-1] Creating TST_ON_U_FOR_TST_TRGGR_RTR_PGSQL trigger for symtst.tst_trigger_router
2021-01-28 08:40:07,433 INFO [pgsql-000] [PostgreSqlSymmetricDialect] [pgsql-000-sync-triggers-1] Creating TST_ON_D_FOR_TST_TRGGR_RTR_PGSQL trigger for symtst.tst_trigger_router
2021-01-28 08:40:07,461 INFO [pgsql-000] [PostgreSqlSymmetricDialect] [pgsql-000-sync-triggers-1] Creating TST_ON_I_FOR_PGSQL_DT_SYMTST2_TRG_PGSQL trigger for data.symtest2
2021-01-28 08:40:07,477 INFO [pgsql-000] [PostgreSqlSymmetricDialect] [pgsql-000-sync-triggers-1] Creating TST_ON_U_FOR_PGSQL_DT_SYMTST2_TRG_PGSQL trigger for data.symtest2
2021-01-28 08:40:07,487 INFO [pgsql-000] [PostgreSqlSymmetricDialect] [pgsql-000-sync-triggers-1] Creating TST_ON_D_FOR_PGSQL_DT_SYMTST2_TRG_PGSQL trigger for data.symtest2
2021-01-28 08:40:07,540 INFO [pgsql-000] [PostgreSqlSymmetricDialect] [pgsql-000-sync-triggers-1] Creating TST_ON_I_FOR_TST_ND_SCRTY_PGSQL trigger for symtst.tst_node_security
2021-01-28 08:40:07,555 INFO [pgsql-000] [PostgreSqlSymmetricDialect] [pgsql-000-sync-triggers-1] Creating TST_ON_U_FOR_TST_ND_SCRTY_PGSQL trigger for symtst.tst_node_security
2021-01-28 08:40:07,571 INFO [pgsql-000] [PostgreSqlSymmetricDialect] [pgsql-000-sync-triggers-1] Creating TST_ON_D_FOR_TST_ND_SCRTY_PGSQL trigger for symtst.tst_node_security
2021-01-28 08:40:07,653 INFO [pgsql-000] [PostgreSqlSymmetricDialect] [pgsql-000-sync-triggers-1] Creating TST_ON_I_FOR_TST_FL_TRGGR_PGSQL trigger for symtst.tst_file_trigger
2021-01-28 08:40:07,669 INFO [pgsql-000] [PostgreSqlSymmetricDialect] [pgsql-000-sync-triggers-1] Creating TST_ON_U_FOR_TST_FL_TRGGR_PGSQL trigger for symtst.tst_file_trigger
2021-01-28 08:40:07,681 INFO [pgsql-000] [PostgreSqlSymmetricDialect] [pgsql-000-sync-triggers-1] Creating TST_ON_D_FOR_TST_FL_TRGGR_PGSQL trigger for symtst.tst_file_trigger
2021-01-28 08:40:07,728 INFO [pgsql-000] [PostgreSqlSymmetricDialect] [pgsql-000-sync-triggers-1] Creating TST_ON_I_FOR_TST_CHNNL_PGSQL trigger for symtst.tst_channel
2021-01-28 08:40:07,745 INFO [pgsql-000] [PostgreSqlSymmetricDialect] [pgsql-000-sync-triggers-1] Creating TST_ON_U_FOR_TST_CHNNL_PGSQL trigger for symtst.tst_channel
2021-01-28 08:40:07,764 INFO [pgsql-000] [PostgreSqlSymmetricDialect] [pgsql-000-sync-triggers-1] Creating TST_ON_D_FOR_TST_CHNNL_PGSQL trigger for symtst.tst_channel
2021-01-28 08:40:07,807 INFO [pgsql-000] [PostgreSqlSymmetricDialect] [pgsql-000-sync-triggers-1] Creating TST_ON_I_FOR_TST_CNFLCT_PGSQL trigger for symtst.tst_conflict
2021-01-28 08:40:07,824 INFO [pgsql-000] [PostgreSqlSymmetricDialect] [pgsql-000-sync-triggers-1] Creating TST_ON_U_FOR_TST_CNFLCT_PGSQL trigger for symtst.tst_conflict
2021-01-28 08:40:07,839 INFO [pgsql-000] [PostgreSqlSymmetricDialect] [pgsql-000-sync-triggers-1] Creating TST_ON_D_FOR_TST_CNFLCT_PGSQL trigger for symtst.tst_conflict
2021-01-28 08:40:07,883 INFO [pgsql-000] [PostgreSqlSymmetricDialect] [pgsql-000-sync-triggers-1] Creating TST_ON_I_FOR_TST_RTR_PGSQL trigger for symtst.tst_router
2021-01-28 08:40:07,899 INFO [pgsql-000] [PostgreSqlSymmetricDialect] [pgsql-000-sync-triggers-1] Creating TST_ON_U_FOR_TST_RTR_PGSQL trigger for symtst.tst_router
2021-01-28 08:40:07,915 INFO [pgsql-000] [PostgreSqlSymmetricDialect] [pgsql-000-sync-triggers-1] Creating TST_ON_D_FOR_TST_RTR_PGSQL trigger for symtst.tst_router
2021-01-28 08:40:07,942 INFO [pgsql-000] [PostgreSqlSymmetricDialect] [pgsql-000-sync-triggers-1] Creating TST_ON_I_FOR_PGSQL_DT_SYMTST1_TRG_PGSQL trigger for data.symtest1
2021-01-28 08:40:07,951 INFO [pgsql-000] [PostgreSqlSymmetricDialect] [pgsql-000-sync-triggers-1] Creating TST_ON_U_FOR_PGSQL_DT_SYMTST1_TRG_PGSQL trigger for data.symtest1
2021-01-28 08:40:07,961 INFO [pgsql-000] [PostgreSqlSymmetricDialect] [pgsql-000-sync-triggers-1] Creating TST_ON_D_FOR_PGSQL_DT_SYMTST1_TRG_PGSQL trigger for data.symtest1
2021-01-28 08:40:07,999 INFO [pgsql-000] [PostgreSqlSymmetricDialect] [pgsql-000-sync-triggers-1] Creating TST_ON_I_FOR_TST_GRPLT_PGSQL trigger for symtst.tst_grouplet
2021-01-28 08:40:08,013 INFO [pgsql-000] [PostgreSqlSymmetricDialect] [pgsql-000-sync-triggers-1] Creating TST_ON_U_FOR_TST_GRPLT_PGSQL trigger for symtst.tst_grouplet
2021-01-28 08:40:08,022 INFO [pgsql-000] [PostgreSqlSymmetricDialect] [pgsql-000-sync-triggers-1] Creating TST_ON_D_FOR_TST_GRPLT_PGSQL trigger for symtst.tst_grouplet
2021-01-28 08:40:08,075 INFO [pgsql-000] [PostgreSqlSymmetricDialect] [pgsql-000-sync-triggers-1] Creating TST_ON_I_FOR_TST_PRMTR_PGSQL trigger for symtst.tst_parameter
2021-01-28 08:40:08,086 INFO [pgsql-000] [PostgreSqlSymmetricDialect] [pgsql-000-sync-triggers-1] Creating TST_ON_U_FOR_TST_PRMTR_PGSQL trigger for symtst.tst_parameter
2021-01-28 08:40:08,095 INFO [pgsql-000] [PostgreSqlSymmetricDialect] [pgsql-000-sync-triggers-1] Creating TST_ON_D_FOR_TST_PRMTR_PGSQL trigger for symtst.tst_parameter
2021-01-28 08:40:08,145 INFO [pgsql-000] [PostgreSqlSymmetricDialect] [pgsql-000-sync-triggers-1] Creating TST_ON_I_FOR_TST_ND_GRP_LNK_PGSQL trigger for symtst.tst_node_group_link
2021-01-28 08:40:08,164 INFO [pgsql-000] [PostgreSqlSymmetricDialect] [pgsql-000-sync-triggers-1] Creating TST_ON_U_FOR_TST_ND_GRP_LNK_PGSQL trigger for symtst.tst_node_group_link
2021-01-28 08:40:08,179 INFO [pgsql-000] [PostgreSqlSymmetricDialect] [pgsql-000-sync-triggers-1] Creating TST_ON_D_FOR_TST_ND_GRP_LNK_PGSQL trigger for symtst.tst_node_group_link
2021-01-28 08:40:08,229 INFO [pgsql-000] [PostgreSqlSymmetricDialect] [pgsql-000-sync-triggers-1] Creating TST_ON_I_FOR_TST_FL_TRGGR_RTR_PGSQL trigger for symtst.tst_file_trigger_router
2021-01-28 08:40:08,244 INFO [pgsql-000] [PostgreSqlSymmetricDialect] [pgsql-000-sync-triggers-1] Creating TST_ON_U_FOR_TST_FL_TRGGR_RTR_PGSQL trigger for symtst.tst_file_trigger_router
2021-01-28 08:40:08,258 INFO [pgsql-000] [PostgreSqlSymmetricDialect] [pgsql-000-sync-triggers-1] Creating TST_ON_D_FOR_TST_FL_TRGGR_RTR_PGSQL trigger for symtst.tst_file_trigger_router
2021-01-28 08:40:08,310 INFO [pgsql-000] [PostgreSqlSymmetricDialect] [pgsql-000-sync-triggers-1] Creating TST_ON_I_FOR_TST_TRNSFRM_TBL_PGSQL trigger for symtst.tst_transform_table
2021-01-28 08:40:08,325 INFO [pgsql-000] [PostgreSqlSymmetricDialect] [pgsql-000-sync-triggers-1] Creating TST_ON_U_FOR_TST_TRNSFRM_TBL_PGSQL trigger for symtst.tst_transform_table
2021-01-28 08:40:08,344 INFO [pgsql-000] [PostgreSqlSymmetricDialect] [pgsql-000-sync-triggers-1] Creating TST_ON_D_FOR_TST_TRNSFRM_TBL_PGSQL trigger for symtst.tst_transform_table
2021-01-28 08:40:08,395 INFO [pgsql-000] [PostgreSqlSymmetricDialect] [pgsql-000-sync-triggers-1] Creating TST_ON_I_FOR_TST_ND_PGSQL trigger for symtst.tst_node
2021-01-28 08:40:08,411 INFO [pgsql-000] [PostgreSqlSymmetricDialect] [pgsql-000-sync-triggers-1] Creating TST_ON_U_FOR_TST_ND_PGSQL trigger for symtst.tst_node
2021-01-28 08:40:08,430 INFO [pgsql-000] [PostgreSqlSymmetricDialect] [pgsql-000-sync-triggers-1] Creating TST_ON_D_FOR_TST_ND_PGSQL trigger for symtst.tst_node
2021-01-28 08:40:08,442 INFO [pgsql-000] [TriggerRouterService] [main] Done synchronizing triggers

Log for SymmetricDS version 3.12.6 with debug

./symadmin sync-triggers -f --debug

2021-01-28 08:52:03,984 INFO [] [AbstractCommandLauncher] [main] Option: name=force, value={}
2021-01-28 08:52:03,988 INFO [] [AbstractCommandLauncher] [main] Option: name=debug, value={}
2021-01-28 08:52:04,531 INFO [] [SymmetricUtils] [main]
   _____ __ _ ____ _____
  / ___/ __ _____ __ ___ __ ___ _/ /_ ____(_)___ / __ | / ___/
  \__ \ / / / / _ `_ \/ _ `_ \/ _ \/_ __// __/ / __/ / / / / \__ \
 ___/ // /_/ / // // / // // / __// / / / / / /_ / /_/ / ___/ /
/____/ \__ /_//_//_/_//_//_/\___/ \_/ /_/ /_/\__/ /_____/ /____/
      /____/
+-----------------------------------------------------------------+
| Copyright (C) 2007-2021 JumpMind, Inc. |
| |
| Licensed under the GNU General Public License version 3. |
| This software comes with ABSOLUTELY NO WARRANTY. |
| See http://www.gnu.org/licenses/gpl.html |
+-----------------------------------------------------------------+
2021-01-28 08:52:04,547 INFO [pgsql-000] [AbstractSymmetricEngine] [main] Initializing connection to database
2021-01-28 08:52:04,766 INFO [pgsql-000] [JdbcDatabasePlatformFactory] [main] Detected database 'postgres95', version '9', protocol 'postgresql'
2021-01-28 08:52:04,824 INFO [pgsql-000] [JdbcDatabasePlatformFactory] [main] The IDatabasePlatform being used is org.jumpmind.db.platform.postgresql.PostgreSql95DatabasePlatform
2021-01-28 08:52:04,960 INFO [pgsql-000] [PostgreSqlSymmetricDialect] [main] The DbDialect being used is org.jumpmind.symmetric.db.postgresql.PostgreSqlSymmetricDialect
2021-01-28 08:52:05,007 INFO [pgsql-000] [ExtensionService] [main] Found 0 extension points from the database that will be registered
2021-01-28 08:52:05,020 INFO [pgsql-000] [StagingManager] [main] The staging directory was initialized at the following location: /opt/symmetric-server-test/tmp/pgsql-000
2021-01-28 08:52:05,025 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'org.jumpmind.symmetric.util.DefaultNodeIdCreator' of type 'INodeIdCreator'
2021-01-28 08:52:05,027 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'org.jumpmind.symmetric.util.DefaultNodeIdCreator' of type 'IBuiltInExtensionPoint'
2021-01-28 08:52:05,054 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'org.jumpmind.symmetric.job.PushHeartbeatListener' of type 'IHeartbeatListener'
2021-01-28 08:52:05,054 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'org.jumpmind.symmetric.job.PushHeartbeatListener' of type 'IBuiltInExtensionPoint'
2021-01-28 08:52:05,087 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'parameter' of type 'ISingleNewAndOldValueColumnTransform'
2021-01-28 08:52:05,090 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'parameter' of type 'IColumnTransform'
2021-01-28 08:52:05,091 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'parameter' of type 'IBuiltInExtensionPoint'
2021-01-28 08:52:05,092 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'variable' of type 'ISingleNewAndOldValueColumnTransform'
2021-01-28 08:52:05,092 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'variable' of type 'IColumnTransform'
2021-01-28 08:52:05,092 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'variable' of type 'IBuiltInExtensionPoint'
2021-01-28 08:52:05,094 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'lookup' of type 'ISingleNewAndOldValueColumnTransform'
2021-01-28 08:52:05,094 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'lookup' of type 'IColumnTransform'
2021-01-28 08:52:05,095 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'lookup' of type 'IBuiltInExtensionPoint'
2021-01-28 08:52:05,097 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'bsh' of type 'ISingleNewAndOldValueColumnTransform'
2021-01-28 08:52:05,097 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'bsh' of type 'IColumnTransform'
2021-01-28 08:52:05,097 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'bsh' of type 'IBuiltInExtensionPoint'
2021-01-28 08:52:05,098 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'additive' of type 'ISingleValueColumnTransform'
2021-01-28 08:52:05,099 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'additive' of type 'IColumnTransform'
2021-01-28 08:52:05,099 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'additive' of type 'IBuiltInExtensionPoint'
2021-01-28 08:52:05,100 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'java' of type 'ISingleValueColumnTransform'
2021-01-28 08:52:05,100 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'java' of type 'IColumnTransform'
2021-01-28 08:52:05,101 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'java' of type 'IBuiltInExtensionPoint'
2021-01-28 08:52:05,101 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'const' of type 'ISingleNewAndOldValueColumnTransform'
2021-01-28 08:52:05,102 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'const' of type 'IColumnTransform'
2021-01-28 08:52:05,102 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'const' of type 'IBuiltInExtensionPoint'
2021-01-28 08:52:05,108 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'copy' of type 'ISingleNewAndOldValueColumnTransform'
2021-01-28 08:52:05,108 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'copy' of type 'IColumnTransform'
2021-01-28 08:52:05,108 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'copy' of type 'IBuiltInExtensionPoint'
2021-01-28 08:52:05,109 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'identity' of type 'ISingleValueColumnTransform'
2021-01-28 08:52:05,110 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'identity' of type 'IColumnTransform'
2021-01-28 08:52:05,111 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'identity' of type 'IBuiltInExtensionPoint'
2021-01-28 08:52:05,113 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'multiply' of type 'IMultipleValueColumnTransform'
2021-01-28 08:52:05,113 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'multiply' of type 'IColumnTransform'
2021-01-28 08:52:05,113 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'multiply' of type 'IBuiltInExtensionPoint'
2021-01-28 08:52:05,114 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'substr' of type 'ISingleNewAndOldValueColumnTransform'
2021-01-28 08:52:05,114 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'substr' of type 'IColumnTransform'
2021-01-28 08:52:05,115 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'substr' of type 'IBuiltInExtensionPoint'
2021-01-28 08:52:05,115 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'left' of type 'ISingleNewAndOldValueColumnTransform'
2021-01-28 08:52:05,116 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'left' of type 'IColumnTransform'
2021-01-28 08:52:05,117 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'left' of type 'IBuiltInExtensionPoint'
2021-01-28 08:52:05,118 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'trim' of type 'ISingleNewAndOldValueColumnTransform'
2021-01-28 08:52:05,118 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'trim' of type 'IColumnTransform'
2021-01-28 08:52:05,118 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'trim' of type 'IBuiltInExtensionPoint'
2021-01-28 08:52:05,119 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'bleft' of type 'ISingleNewAndOldValueColumnTransform'
2021-01-28 08:52:05,119 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'bleft' of type 'IColumnTransform'
2021-01-28 08:52:05,119 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'bleft' of type 'IBuiltInExtensionPoint'
2021-01-28 08:52:05,121 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'remove' of type 'ISingleValueColumnTransform'
2021-01-28 08:52:05,121 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'remove' of type 'IColumnTransform'
2021-01-28 08:52:05,122 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'remove' of type 'IBuiltInExtensionPoint'
2021-01-28 08:52:05,147 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'math' of type 'ISingleNewAndOldValueColumnTransform'
2021-01-28 08:52:05,152 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'math' of type 'IColumnTransform'
2021-01-28 08:52:05,152 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'math' of type 'IBuiltInExtensionPoint'
2021-01-28 08:52:05,153 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'valueMap' of type 'ISingleNewAndOldValueColumnTransform'
2021-01-28 08:52:05,154 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'valueMap' of type 'IColumnTransform'
2021-01-28 08:52:05,154 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'valueMap' of type 'IBuiltInExtensionPoint'
2021-01-28 08:52:05,156 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'copyIfChanged' of type 'ISingleNewAndOldValueColumnTransform'
2021-01-28 08:52:05,158 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'copyIfChanged' of type 'IColumnTransform'
2021-01-28 08:52:05,159 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'copyIfChanged' of type 'IBuiltInExtensionPoint'
2021-01-28 08:52:05,160 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'columnsToRowsKey' of type 'IMultipleValueColumnTransform'
2021-01-28 08:52:05,160 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'columnsToRowsKey' of type 'IColumnTransform'
2021-01-28 08:52:05,160 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'columnsToRowsKey' of type 'IBuiltInExtensionPoint'
2021-01-28 08:52:05,161 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'columnsToRowsValue' of type 'ISingleValueColumnTransform'
2021-01-28 08:52:05,161 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'columnsToRowsValue' of type 'IColumnTransform'
2021-01-28 08:52:05,163 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'columnsToRowsValue' of type 'IBuiltInExtensionPoint'
2021-01-28 08:52:05,164 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'clarionDateTime' of type 'ISingleNewAndOldValueColumnTransform'
2021-01-28 08:52:05,164 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'clarionDateTime' of type 'IColumnTransform'
2021-01-28 08:52:05,165 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'clarionDateTime' of type 'IBuiltInExtensionPoint'
2021-01-28 08:52:05,166 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'isEmpty' of type 'ISingleNewAndOldValueColumnTransform'
2021-01-28 08:52:05,167 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'isEmpty' of type 'IColumnTransform'
2021-01-28 08:52:05,168 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'isEmpty' of type 'IBuiltInExtensionPoint'
2021-01-28 08:52:05,168 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'isNull' of type 'ISingleNewAndOldValueColumnTransform'
2021-01-28 08:52:05,169 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'isNull' of type 'IColumnTransform'
2021-01-28 08:52:05,169 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'isNull' of type 'IBuiltInExtensionPoint'
2021-01-28 08:52:05,170 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'isBlank' of type 'ISingleNewAndOldValueColumnTransform'
2021-01-28 08:52:05,170 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'isBlank' of type 'IColumnTransform'
2021-01-28 08:52:05,170 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'isBlank' of type 'IBuiltInExtensionPoint'
2021-01-28 08:52:05,171 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'deletedColumns' of type 'ISingleNewAndOldValueColumnTransform'
2021-01-28 08:52:05,172 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'deletedColumns' of type 'IColumnTransform'
2021-01-28 08:52:05,172 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'deletedColumns' of type 'IBuiltInExtensionPoint'
2021-01-28 08:52:05,181 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'org.jumpmind.symmetric.config.TriggerFailureListener' of type 'IBuiltInExtensionPoint'
2021-01-28 08:52:05,182 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'org.jumpmind.symmetric.config.TriggerFailureListener' of type 'ITriggerCreationListener'
2021-01-28 08:52:05,201 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'default' of type 'IBatchAlgorithm'
2021-01-28 08:52:05,202 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'default' of type 'IBuiltInExtensionPoint'
2021-01-28 08:52:05,202 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'nontransactional' of type 'IBatchAlgorithm'
2021-01-28 08:52:05,202 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'nontransactional' of type 'IBuiltInExtensionPoint'
2021-01-28 08:52:05,203 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'transactional' of type 'IBatchAlgorithm'
2021-01-28 08:52:05,204 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'transactional' of type 'IBuiltInExtensionPoint'
2021-01-28 08:52:05,212 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'configurationChanged' of type 'IDataRouter'
2021-01-28 08:52:05,213 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'configurationChanged' of type 'IBuiltInExtensionPoint'
2021-01-28 08:52:05,214 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'bsh' of type 'IBuiltInExtensionPoint'
2021-01-28 08:52:05,215 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'bsh' of type 'IDataRouter'
2021-01-28 08:52:05,216 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'subselect' of type 'IBuiltInExtensionPoint'
2021-01-28 08:52:05,220 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'subselect' of type 'IDataRouter'
2021-01-28 08:52:05,221 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'lookuptable' of type 'IDataRouter'
2021-01-28 08:52:05,221 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'lookuptable' of type 'IBuiltInExtensionPoint'
2021-01-28 08:52:05,222 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'default' of type 'IBuiltInExtensionPoint'
2021-01-28 08:52:05,222 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'default' of type 'IDataRouter'
2021-01-28 08:52:05,223 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'audit' of type 'IBuiltInExtensionPoint'
2021-01-28 08:52:05,223 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'audit' of type 'IDataRouter'
2021-01-28 08:52:05,224 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'column' of type 'IDataRouter'
2021-01-28 08:52:05,225 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'column' of type 'IBuiltInExtensionPoint'
2021-01-28 08:52:05,226 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'filesync' of type 'IBuiltInExtensionPoint'
2021-01-28 08:52:05,226 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'filesync' of type 'IDataRouter'
2021-01-28 08:52:05,227 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'dbf' of type 'IDataRouter'
2021-01-28 08:52:05,228 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'dbf' of type 'IBuiltInExtensionPoint'
2021-01-28 08:52:05,229 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'tps' of type 'IDataRouter'
2021-01-28 08:52:05,230 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'tps' of type 'IBuiltInExtensionPoint'
2021-01-28 08:52:05,230 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'csv' of type 'IDataRouter'
2021-01-28 08:52:05,231 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'csv' of type 'IBuiltInExtensionPoint'
2021-01-28 08:52:05,232 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'convertToReload' of type 'IDataRouter'
2021-01-28 08:52:05,232 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'convertToReload' of type 'IBuiltInExtensionPoint'
2021-01-28 08:52:05,272 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'org.jumpmind.symmetric.load.DefaultDataLoaderFactory' of type 'IDataLoaderFactory'
2021-01-28 08:52:05,272 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'org.jumpmind.symmetric.load.DefaultDataLoaderFactory' of type 'IBuiltInExtensionPoint'
2021-01-28 08:52:05,274 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'org.jumpmind.symmetric.load.ConfigurationChangedDatabaseWriterFilter' of type 'IBuiltInExtensionPoint'
2021-01-28 08:52:05,274 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'org.jumpmind.symmetric.load.ConfigurationChangedDatabaseWriterFilter' of type 'ILoadSyncLifecycleListener'
2021-01-28 08:52:05,275 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'org.jumpmind.symmetric.load.ConfigurationChangedDatabaseWriterFilter' of type 'IDatabaseWriterFilter'
2021-01-28 08:52:05,310 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'org.jumpmind.symmetric.job.DefaultOfflineServerListener' of type 'IOfflineServerListener'
2021-01-28 08:52:05,312 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'org.jumpmind.symmetric.job.DefaultOfflineServerListener' of type 'IBuiltInExtensionPoint'
2021-01-28 08:52:05,313 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'org.jumpmind.symmetric.io.DefaultOfflineClientListener' of type 'IOfflineClientListener'
2021-01-28 08:52:05,317 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'org.jumpmind.symmetric.io.DefaultOfflineClientListener' of type 'IBuiltInExtensionPoint'
2021-01-28 08:52:05,331 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'batchError' of type 'IMonitorType'
2021-01-28 08:52:05,337 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'batchError' of type 'IBuiltInExtensionPoint'
2021-01-28 08:52:05,337 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'batchUnsent' of type 'IMonitorType'
2021-01-28 08:52:05,338 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'batchUnsent' of type 'IBuiltInExtensionPoint'
2021-01-28 08:52:05,338 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'cpu' of type 'IBuiltInExtensionPoint'
2021-01-28 08:52:05,339 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'cpu' of type 'IMonitorType'
2021-01-28 08:52:05,339 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'dataGap' of type 'IMonitorType'
2021-01-28 08:52:05,339 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'dataGap' of type 'IBuiltInExtensionPoint'
2021-01-28 08:52:05,340 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'disk' of type 'IMonitorType'
2021-01-28 08:52:05,340 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'disk' of type 'IBuiltInExtensionPoint'
2021-01-28 08:52:05,340 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'memory' of type 'IBuiltInExtensionPoint'
2021-01-28 08:52:05,341 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'memory' of type 'IMonitorType'
2021-01-28 08:52:05,341 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'dataUnrouted' of type 'IMonitorType'
2021-01-28 08:52:05,341 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'dataUnrouted' of type 'IBuiltInExtensionPoint'
2021-01-28 08:52:05,341 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'log' of type 'IMonitorType'
2021-01-28 08:52:05,344 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'log' of type 'IBuiltInExtensionPoint'
2021-01-28 08:52:05,344 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'offlineNodes' of type 'IMonitorType'
2021-01-28 08:52:05,344 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'offlineNodes' of type 'IBuiltInExtensionPoint'
2021-01-28 08:52:05,345 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'block' of type 'IBuiltInExtensionPoint'
2021-01-28 08:52:05,345 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'block' of type 'IMonitorType'
2021-01-28 08:52:05,346 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'log' of type 'INotificationType'
2021-01-28 08:52:05,348 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'log' of type 'IBuiltInExtensionPoint'
2021-01-28 08:52:05,348 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'email' of type 'INotificationType'
2021-01-28 08:52:05,349 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'email' of type 'IBuiltInExtensionPoint'
2021-01-28 08:52:06,057 INFO [pgsql-000] [ExtensionService] [main] Found 0 extension points from the database that will be registered
2021-01-28 08:52:06,058 INFO [pgsql-000] [ClientExtensionService] [main] Found 7 extension points from spring that will be registered
2021-01-28 08:52:06,058 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'bulkLoaderFactory' of type 'IDataLoaderFactory'
2021-01-28 08:52:06,058 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'bulkLoaderFactory' of type 'IBuiltInExtensionPoint'
2021-01-28 08:52:06,058 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'databaseUpgradeListener' of type 'IDatabaseUpgradeListener'
2021-01-28 08:52:06,058 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'databaseUpgradeListener' of type 'IBuiltInExtensionPoint'
2021-01-28 08:52:06,058 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'hbaseLoaderFactory' of type 'IBuiltInExtensionPoint'
2021-01-28 08:52:06,058 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'hbaseLoaderFactory' of type 'IDataLoaderFactory'
2021-01-28 08:52:06,058 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'mongoLoaderFactory' of type 'IBuiltInExtensionPoint'
2021-01-28 08:52:06,058 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'mongoLoaderFactory' of type 'IDataLoaderFactory'
2021-01-28 08:52:06,058 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'nodeManagementService' of type 'IBuiltInExtensionPoint'
2021-01-28 08:52:06,058 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'parameterManagementService' of type 'IBuiltInExtensionPoint'
2021-01-28 08:52:06,059 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'softwareUpgradeListener' of type 'ISoftwareUpgradeListener'
2021-01-28 08:52:06,059 DEBUG [pgsql-000] [ExtensionService] [main] Registering built-in extension named 'softwareUpgradeListener' of type 'IBuiltInExtensionPoint'
2021-01-28 08:52:06,063 INFO [pgsql-000] [ClusterService] [main] This node picked a server id of sympg
2021-01-28 08:52:06,064 INFO [pgsql-000] [TriggerRouterService] [main] Synchronizing triggers
2021-01-28 08:52:06,198 INFO [pgsql-000] [TriggerRouterService] [pgsql-000-sync-triggers-1] About to remove triggers for inactivated table: tst_transform_column
2021-01-28 08:52:06,272 INFO [pgsql-000] [TriggerRouterService] [pgsql-000-sync-triggers-1] About to remove triggers for inactivated table: tst_trigger
2021-01-28 08:52:06,339 INFO [pgsql-000] [TriggerRouterService] [pgsql-000-sync-triggers-1] About to remove triggers for inactivated table: tst_job
2021-01-28 08:52:06,375 INFO [pgsql-000] [TriggerRouterService] [pgsql-000-sync-triggers-1] About to remove triggers for inactivated table: tst_node_group_link
2021-01-28 08:52:06,412 INFO [pgsql-000] [TriggerRouterService] [pgsql-000-sync-triggers-1] About to remove triggers for inactivated table: tst_file_trigger_router
2021-01-28 08:52:06,449 INFO [pgsql-000] [TriggerRouterService] [pgsql-000-sync-triggers-1] About to remove triggers for inactivated table: tst_load_filter
2021-01-28 08:52:06,489 INFO [pgsql-000] [TriggerRouterService] [pgsql-000-sync-triggers-1] About to remove triggers for inactivated table: tst_monitor
2021-01-28 08:52:06,524 INFO [pgsql-000] [TriggerRouterService] [pgsql-000-sync-triggers-1] About to remove triggers for inactivated table: tst_table_reload_request
2021-01-28 08:52:06,561 INFO [pgsql-000] [TriggerRouterService] [pgsql-000-sync-triggers-1] About to remove triggers for inactivated table: tst_node_group_channel_wnd
2021-01-28 08:52:06,596 INFO [pgsql-000] [TriggerRouterService] [pgsql-000-sync-triggers-1] About to remove triggers for inactivated table: tst_node_group
2021-01-28 08:52:06,629 INFO [pgsql-000] [TriggerRouterService] [pgsql-000-sync-triggers-1] About to remove triggers for inactivated table: tst_node_host
2021-01-28 08:52:06,662 INFO [pgsql-000] [TriggerRouterService] [pgsql-000-sync-triggers-1] About to remove triggers for inactivated table: tst_notification
2021-01-28 08:52:06,696 INFO [pgsql-000] [TriggerRouterService] [pgsql-000-sync-triggers-1] About to remove triggers for inactivated table: tst_grouplet_link
2021-01-28 08:52:06,729 INFO [pgsql-000] [TriggerRouterService] [pgsql-000-sync-triggers-1] About to remove triggers for inactivated table: tst_node_identity
2021-01-28 08:52:06,731 INFO [pgsql-000] [TriggerRouterService] [pgsql-000-sync-triggers-1] About to remove triggers for inactivated table: tst_trigger_router_grouplet
2021-01-28 08:52:06,765 INFO [pgsql-000] [TriggerRouterService] [pgsql-000-sync-triggers-1] About to remove triggers for inactivated table: tst_extension
2021-01-28 08:52:06,804 INFO [pgsql-000] [TriggerRouterService] [pgsql-000-sync-triggers-1] About to remove triggers for inactivated table: tst_trigger_router
2021-01-28 08:52:06,842 INFO [pgsql-000] [TriggerRouterService] [pgsql-000-sync-triggers-1] About to remove triggers for inactivated table: data.symtest2
2021-01-28 08:52:06,883 INFO [pgsql-000] [TriggerRouterService] [pgsql-000-sync-triggers-1] About to remove triggers for inactivated table: tst_node_security
2021-01-28 08:52:06,920 INFO [pgsql-000] [TriggerRouterService] [pgsql-000-sync-triggers-1] About to remove triggers for inactivated table: tst_file_snapshot
2021-01-28 08:52:06,922 INFO [pgsql-000] [TriggerRouterService] [pgsql-000-sync-triggers-1] About to remove triggers for inactivated table: tst_file_trigger
2021-01-28 08:52:06,955 INFO [pgsql-000] [TriggerRouterService] [pgsql-000-sync-triggers-1] About to remove triggers for inactivated table: tst_channel
2021-01-28 08:52:06,987 INFO [pgsql-000] [TriggerRouterService] [pgsql-000-sync-triggers-1] About to remove triggers for inactivated table: tst_conflict
2021-01-28 08:52:07,021 INFO [pgsql-000] [TriggerRouterService] [pgsql-000-sync-triggers-1] About to remove triggers for inactivated table: tst_router
2021-01-28 08:52:07,053 INFO [pgsql-000] [TriggerRouterService] [pgsql-000-sync-triggers-1] About to remove triggers for inactivated table: data.symtest1
2021-01-28 08:52:07,086 INFO [pgsql-000] [TriggerRouterService] [pgsql-000-sync-triggers-1] About to remove triggers for inactivated table: tst_grouplet
2021-01-28 08:52:07,117 INFO [pgsql-000] [TriggerRouterService] [pgsql-000-sync-triggers-1] About to remove triggers for inactivated table: tst_monitor_event
2021-01-28 08:52:07,120 INFO [pgsql-000] [TriggerRouterService] [pgsql-000-sync-triggers-1] About to remove triggers for inactivated table: tst_parameter
2021-01-28 08:52:07,159 INFO [pgsql-000] [TriggerRouterService] [pgsql-000-sync-triggers-1] About to remove triggers for inactivated table: tst_transform_table
2021-01-28 08:52:07,192 INFO [pgsql-000] [TriggerRouterService] [pgsql-000-sync-triggers-1] About to remove triggers for inactivated table: tst_node
2021-01-28 08:52:07,223 INFO [pgsql-000] [TriggerRouterService] [main] Done synchronizing triggers

Executing ./symadmin sync-triggers -f again do nothing.
Executing ./symadmin sync-triggers will create dropped triggers.

Related Changesets

SymmetricDS: 3.12 90a5e044

2021-02-03 19:46:27

admin

Details Diff 		0004786: Force trigger regenerate does not work properly Affected Issues
0004786
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/TriggerRouterService.java Diff File

Issue History

Date Modified Username Field Change
2021-01-26 08:35 kraynopp New Issue
2021-01-27 18:29 josh-a-hicks Note Added: 0001884
2021-01-28 06:04 kraynopp Note Added: 0001885
2021-02-03 19:45 elong Relationship added related to 0004410
2021-02-03 19:47 elong Assigned To => elong
2021-02-03 19:47 elong Status new => resolved
2021-02-03 19:47 elong Resolution open => fixed
2021-02-03 19:47 elong Fixed in Version => 3.12.7
2021-02-03 19:47 elong Target Version => 3.12.7
2021-02-03 20:00 admin Changeset attached => SymmetricDS 3.12 90a5e044
2021-02-25 21:33 admin Status resolved => closed