View Issue Details

IDProjectCategoryView StatusLast Update
0003680SymmetricDSBugpublic2018-08-20 14:52
Reportermmichalek Assigned Tommichalek  
Status closedResolutionfixed 
Product Version3.9.11 
Target Version3.9.12Fixed in Version3.9.12 
Summary0003680: Interrupted Registration results in node which cannot start because of mismatching instance.uuid
DescriptionUpon opening registration, the registration server will insert a partially filled out sym_node_host row which includes the instance.uuid of the server. During the registration process, this row is pulled down by client (which has a different instance.uuid from the server, unless multi-homed). When registration is interrupted, the client does not heartbeat and overwrite the instance.uuid in sym_node host. When the client node is restarted, it fails to start because the instance uuid don't match.

[store-002] - AbstractSymmetricEngine - An error occurred while starting SymmetricDS
org.jumpmind.symmetric.SymmetricException: *** Node '002' failed to claim exclusive ownership of the SymmetricDS database. *** This is instance id 'turing.local-d51369e8-8825-4686-9dd5-2cf0ee2147a2' but instance id 'turing.local-e6cef56d-53db-4e88-9e5d-2cf0ee2147a2' is already present in sym_node_host. This is caused when 2 copies of SymmetricDS are pointed at the same database, but not clustered. If you are configuring a cluster, set cluster.lock.enabled=true and restart. If you moved your installation or re-installed, run 'delete from sym_node_host where node_id = '002' and restart SymmetricDS.
    at org.jumpmind.symmetric.service.impl.ClusterService.checkSymDbOwnership(
    at org.jumpmind.symmetric.service.impl.ClusterService.init(
    at org.jumpmind.symmetric.AbstractSymmetricEngine.setupDatabase(
    at org.jumpmind.symmetric.AbstractSymmetricEngine.setup(
    at org.jumpmind.symmetric.AbstractSymmetricEngine.start(
    at org.jumpmind.symmetric.AbstractSymmetricEngine.start(
    at org.jumpmind.symmetric.ClientSymmetricEngine.start(
    at org.jumpmind.symmetric.web.SymmetricEngineHolder$
    at java.util.concurrent.ThreadPoolExecutor.runWorker(
    at java.util.concurrent.ThreadPoolExecutor$
[store-002] - AbstractSymmetricEngine - Stopping SymmetricDS externalId=002 version=3.9.11 database=H2

TagsNo tags attached.


There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.9 b2686563

2018-08-16 15:11:18


Details Diff
0003680: Interrupted Registration results in node which cannot start because of mismatching instance.uuid Affected Issues
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/ Diff File

Issue History

Date Modified Username Field Change
2018-08-16 17:44 mmichalek New Issue
2018-08-16 17:44 mmichalek Status new => assigned
2018-08-16 17:44 mmichalek Assigned To => mmichalek
2018-08-16 17:48 mmichalek Project SymmetricDS Pro => SymmetricDS
2018-08-16 19:14 mmichalek Status assigned => resolved
2018-08-16 19:14 mmichalek Resolution open => fixed
2018-08-16 19:14 mmichalek Fixed in Version => 3.9.12
2018-08-16 19:14 mmichalek Target Version => 3.9.12
2018-08-16 20:00 mmichalek Changeset attached => SymmetricDS 3.9 b2686563
2018-08-20 14:52 mmichalek Status resolved => closed