View Issue Details

Jump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0005709SymmetricDSBugpublic2023-02-27 10:092023-11-08 19:01
Reporterzhujiawen Assigned To 
Prioritynormal 
Status closedResolutionno change required 
Product Version3.14.5 
Summary0005709: Sending an initial load on source node has no effect
DescriptionSending an initial load on source node，can't found initial load log output in symmetric.log(attachment) :
[root@ops-2 symmetric-server-3.14.5]# bin/symadmin --engine cd-001 reload-node 001
Log output will be written to /root/symmetric-server-3.14.5/logs/symmetric.log
[] - AbstractCommandLauncher - Option: name=engine, value={cd-001}
Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.
[] - SymmetricUtils -
   _____ __ _ ____ _____
  / ___/ __ _____ __ ___ __ ___ _/ /_ ____(_)___ / __ | / ___/
  \__ \ / / / / _ `_ \/ _ `_ \/ _ \/_ __// __/ / __/ / / / / \__ \
 ___/ // /_/ / // // / // // / __// / / / / / /_ / /_/ / ___/ /
/____/ \__ /_//_//_/_//_//_/\___/ \_/ /_/ /_/\__/ /_____/ /____/
      /____/
+-----------------------------------------------------------------+
| Copyright (C) 2007-2023 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 |
+-----------------------------------------------------------------+
[cd-001] - ClientSymmetricEngine - Initializing connection to database
[cd-001] - JdbcDatabasePlatformFactory - Detected database 'MySQL', version '5', protocol 'mysql'
[cd-001] - JdbcDatabasePlatformFactory - The IDatabasePlatform being used is org.jumpmind.db.platform.mysql.MySqlDatabasePlatform
[cd-001] - MySqlSymmetricDialect - The DbDialect being used is org.jumpmind.symmetric.db.mysql.MySqlSymmetricDialect
[cd-001] - ExtensionService - Found 0 extension points from the database that will be registered
[cd-001] - StagingManager - The staging directory was initialized at the following location: /root/symmetric-server-3.14.5/tmp/cd-001
[cd-001] - ExtensionService - Found 0 extension points from the database that will be registered
[cd-001] - ClientExtensionService - Found 7 extension points from spring that will be registered
Successfully enabled initial load for node 001
[] - AbstractSymmetricEngine - Stopping SymmetricDS externalId=001 version=3.14.5 database=MySQL

The symmetric.log:

2023-02-27 17:57:47,053 INFO [] [AbstractCommandLauncher] [main] Option: name=engine, value={cd-001}
2023-02-27 17:57:47,667 INFO [] [SymmetricUtils] [main]
   _____ __ _ ____ _____
  / ___/ __ _____ __ ___ __ ___ _/ /_ ____(_)___ / __ | / ___/
  \__ \ / / / / _ `_ \/ _ `_ \/ _ \/_ __// __/ / __/ / / / / \__ \
 ___/ // /_/ / // // / // // / __// / / / / / /_ / /_/ / ___/ /
/____/ \__ /_//_//_/_//_//_/\___/ \_/ /_/ /_/\__/ /_____/ /____/
      /____/
+-----------------------------------------------------------------+
| Copyright (C) 2007-2023 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 |
+-----------------------------------------------------------------+
2023-02-27 17:57:47,682 INFO [cd-001] [ClientSymmetricEngine] [main] Initializing connection to database
2023-02-27 17:57:47,724 INFO [cd-001] [JdbcDatabasePlatformFactory] [main] Detected database 'MySQL', version '5', protocol 'mysql'
2023-02-27 17:57:47,741 INFO [cd-001] [JdbcDatabasePlatformFactory] [main] The IDatabasePlatform being used is org.jumpmind.db.platform.mysql.MySqlDatabasePlatform
2023-02-27 17:57:47,855 INFO [cd-001] [MySqlSymmetricDialect] [main] The DbDialect being used is org.jumpmind.symmetric.db.mysql.MySqlSymmetricDialect
2023-02-27 17:57:47,912 INFO [cd-001] [ExtensionService] [main] Found 0 extension points from the database that will be registered
2023-02-27 17:57:47,921 INFO [cd-001] [StagingManager] [main] The staging directory was initialized at the following location: /root/symmetric-server-3.14.5/tmp/cd-001
2023-02-27 17:57:48,732 INFO [cd-001] [ExtensionService] [main] Found 0 extension points from the database that will be registered
2023-02-27 17:57:48,732 INFO [cd-001] [ClientExtensionService] [main] Found 7 extension points from spring that will be registered
2023-02-27 17:57:48,782 INFO [] [AbstractSymmetricEngine] [Thread-1] Stopping SymmetricDS externalId=001 version=3.14.5 database=MySQL
2023-02-27 17:57:52,335 INFO [cd-001] [ConfigurationChangedHelper] [cd-001-job-4] Clearing cache for node security
2023-02-27 17:57:52,453 INFO [cd-001] [RouterService] [cd-001-job-4] Routed 1 data events in 191 ms
2023-02-27 17:57:52,464 INFO [cd-001] [DataGapFastDetector] [cd-001-job-4] Expired 2 data gap(s) between data_id 116750 and 116752 and between create_time 2023-02-27T17:37:02.247+0800 and 2023-02-27T17:37:47.333+0800
2023-02-27 17:57:52,862 INFO [cd-001] [PushService] [cd-001-push-default-1] Push data sent to cecdat:002:002
2023-02-27 17:57:52,925 INFO [cd-001] [PushService] [cd-001-push-default-1] Pushed data to node cecdat:002:002. 1 data and 1 batches were processed. (sym_node_security)
2023-02-27 18:00:00,019 INFO [ambari-003] [StagingManager] [ambari-003-job-7] Cleaning staging...
2023-02-27 18:00:00,023 INFO [ambari-003] [StagingManager] [ambari-003-job-7] Finished cleaning staging in 0 seconds.
2023-02-27 18:00:00,025 INFO [cd-001] [StagingManager] [cd-001-job-15] Cleaning staging...
2023-02-27 18:00:00,039 INFO [cd-001] [StagingManager] [cd-001-job-15] Cleared 14 cache objects, freed 0 bytes.
2023-02-27 18:00:00,040 INFO [cd-001] [StagingManager] [cd-001-job-15] Finished cleaning staging in 0 seconds.
Steps To ReproduceQuery sym_node_host found two node:
mysql> select * from sym_node_host \G;
*************************** 1. row ***************************
             node_id: 001
           host_name: ops-2.test.cn
         instance_id: ops-2.test.cn-61bb5921-141e-48b0-8801-98c3b631da6b
          ip_address: 172.16.56.120
             os_user: root
             os_name: Linux
             os_arch: amd64
          os_version: 3.10.0-1160.66.1.0.1.an7.x86_64
available_processors: 2
   free_memory_bytes: 157234592
  total_memory_bytes: 325058560
    max_memory_bytes: 954728448
        java_version: 1.8.0_74
         java_vendor: Oracle Corporation
        jdbc_version: mysql-connector-java-8.0.28 (Revision: 7ff2161da3899f379fb3171b6538b191b1c5c7e2)
   symmetric_version: 3.14.5
     timezone_offset: +08:00
      heartbeat_time: 2023-02-27 17:51:59
   last_restart_time: 2023-02-27 15:51:59
         create_time: 2023-02-23 14:28:07
*************************** 2. row ***************************
             node_id: 002
           host_name: ops-1.test.cn
         instance_id: ops-1.test.cn-a0cedab3-4287-41e1-b939-92bd61685fba
          ip_address: 172.16.56.75
             os_user: root
             os_name: Linux
             os_arch: amd64
          os_version: 3.10.0-1160.66.1.0.1.an7.x86_64
available_processors: 2
   free_memory_bytes: 210604584
  total_memory_bytes: 368574464
    max_memory_bytes: 954728448
        java_version: 1.8.0_74
         java_vendor: Oracle Corporation
        jdbc_version: mysql-connector-java-8.0.28 (Revision: 7ff2161da3899f379fb3171b6538b191b1c5c7e2)
   symmetric_version: 3.14.5
     timezone_offset: +08:00
      heartbeat_time: 2023-02-27 17:52:46
   last_restart_time: 2023-02-27 15:52:39
         create_time: 2023-02-23 14:22:30
2 rows in set (0.00 sec)

ERROR:
No query specified
TagsNo tags attached.

Activities

zhujiawen

2023-02-27 10:12

reporter   ~0002266

The source and target node in Bi-Directional synchronization mode:
mysql> select * from sym_trigger_router \G;
*************************** 1. row ***************************
              trigger_id: user_new
               router_id: cec-2-cechea
                 enabled: 1
      initial_load_order: 1
     initial_load_select: NULL
initial_load_delete_stmt: NULL
       ping_back_enabled: 0
             create_time: 2023-02-23 15:48:48
          last_update_by: NULL
        last_update_time: 2023-02-23 15:48:48
             description: NULL
*************************** 2. row ***************************
              trigger_id: user_new
               router_id: cechea-2-cec
                 enabled: 1
      initial_load_order: 1
     initial_load_select:
initial_load_delete_stmt: NULL
       ping_back_enabled: 0
             create_time: 2023-02-22 18:13:34
          last_update_by: NULL
        last_update_time: 2023-02-23 09:52:08
             description: NULL
2 rows in set (0.00 sec)

emiller

2023-03-01 18:58

developer   ~0002272

Currently you're trying to send a load from node 001 to node 001. To send a load from node 001 to node 002, use the following command:

bin/symadmin --engine cd-001 reload-node 002

zhujiawen

2023-03-02 13:04

reporter   ~0002274

@emiller I want send a load from node 002 to node 001 because I used Bi-Directional synchronization mode, use following command :
bin/symadmin --engine cd-001 reload-node 001

node 002 load not sync to node 001

zhujiawen

2023-03-03 03:27

reporter   ~0002280

Whether or not I used reverse initial loads method load node(002) data to server node(001)

jvanmeter

2023-03-08 19:03

developer   ~0002287

Try this:

bin/symadmin --engine cd-002 reload-node 001

zhujiawen

2023-03-09 01:35

reporter   ~0002289

@jvanmeter [root@ops-2 symmetric-server-3.14.5]# bin/symadmin --engine cd-002 reload-node 001
Log output will be written to /root/symmetric-server-3.14.5/logs/symmetric.log
-------------------------------------------------------------------------------
An exception occurred. Please see the following for details:
-------------------------------------------------------------------------------
org.jumpmind.symmetric.SymmetricException: Could not find the properties file for the engine specified: cd-002
        at org.jumpmind.symmetric.AbstractCommandLauncher.configurePropertiesFile(AbstractCommandLauncher.java:210)
        at org.jumpmind.symmetric.AbstractCommandLauncher.execute(AbstractCommandLauncher.java:145)
        at org.jumpmind.symmetric.SymmetricAdmin.main(SymmetricAdmin.java:136)
-------------------------------------------------------------------------------

cquamme

2023-03-15 17:23

developer   ~0002296

You will need to replace cd-002 with your engine name.

zhujiawen

2023-03-16 01:31

reporter   ~0002297

@cquamme My engine is cd-001 , The first time was to execute this command：
bin/symadmin --engine cd-001 reload-node 001

Issue History

Date Modified Username Field Change
2023-02-27 10:09 zhujiawen New Issue
2023-02-27 10:12 zhujiawen Note Added: 0002266
2023-03-01 18:58 emiller Note Added: 0002272
2023-03-01 18:59 emiller Status new => feedback
2023-03-02 13:04 zhujiawen Note Added: 0002274
2023-03-02 13:04 zhujiawen Status feedback => new
2023-03-03 03:27 zhujiawen Note Added: 0002280
2023-03-08 19:03 jvanmeter Assigned To => jvanmeter
2023-03-08 19:03 jvanmeter Status new => feedback
2023-03-08 19:03 jvanmeter Note Added: 0002287
2023-03-09 01:35 zhujiawen Note Added: 0002289
2023-03-09 01:35 zhujiawen Status feedback => assigned
2023-03-15 17:23 cquamme Note Added: 0002296
2023-03-15 17:23 cquamme Status assigned => feedback
2023-03-16 01:31 zhujiawen Note Added: 0002297
2023-03-16 01:31 zhujiawen Status feedback => assigned
2023-11-07 17:14 jvanmeter Assigned To jvanmeter =>
2023-11-08 19:01 emiller Status assigned => closed
2023-11-08 19:01 emiller Resolution open => no change required