View Issue Details

IDProjectCategoryView StatusLast Update
0004424SymmetricDSImprovementpublic2021-03-12 22:05
Reporterpmarzullo Assigned Topmarzullo  
Status assignedResolutionopen 
Product Version3.10.0 
Target Version3.10.14 
Summary0004424: Log monitor fails to insert because of duplicate key when logs are shared across instances of a node
DescriptionIn a clustered environment, when SymmetricDS is deployed to a servlet container, and the servlet containers write to the same log file (log files are on a shared drive), the execution of the log monitor on each instance of the cluster sees the same error in the log, causing duplicate key errors because the create time of the log entry is part of the primary key.

Two choices that I can think of:

1. Create a new parameter that makes the Log Monitor in cluster mode.
2. Change the insert of sym_monitor_event to a update/insert. Possible loss of real monitor entries because of exact same time of create time.


The monitor job runs on both nodes. The logs are shared. Both nodes can see the same log entry and tries to insert when the query returns no log entry. The query to get the unresolved events is run outside of the monitor lock.

Either the cluster lock should wrap all of the code, or the insertMonitorEvent should be changed to saveMonitorEvent.
Tagslogging, monitoring



2021-03-12 22:05

developer   ~0001896

Can I change the log monitor type to use cluster locking?

Issue History

Date Modified Username Field Change
2020-06-11 13:01 pmarzullo New Issue
2020-06-11 13:01 pmarzullo Status new => assigned
2020-06-11 13:01 pmarzullo Assigned To => pmarzullo
2020-06-11 13:03 pmarzullo Description Updated View Revisions
2020-06-24 20:32 elong Project SymmetricDS Pro => SymmetricDS
2020-06-24 20:33 elong Product Version 3.11.9 => 3.10.0
2020-06-24 20:33 elong Target Version 3.11.10 => 3.10.13
2020-07-06 13:05 pmarzullo Tag Attached: logging
2020-07-06 13:05 pmarzullo Tag Attached: monitoring
2020-11-09 13:43 admin Target Version 3.10.13 => 3.12.6
2020-11-09 13:44 admin Target Version 3.12.6 => 3.10.14
2021-03-12 22:05 pmarzullo Note Added: 0001896