View Issue Details

IDProjectCategoryView StatusLast Update
0003305SymmetricDSBugpublic2021-11-04 15:03
Reportermmichalek Assigned Topmarzullo  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.8.0 
Target Version3.11.14Fixed in Version3.11.14 
Summary0003305: Removing a channel can cause errors during push/pull
DescriptionGiven preconditions:
1) cluster.lock.enabled=true
2) Channels set up using queue names other than default.
3) Sync some data on a non-default queue so that rows get created in sym_node_communication.

Now, assign trigger back to the default channel, and remove the non-default channel. The rows pointing at the new queue will hang around in the sym_node_communication and cause errors like this during PUSH/PULL:

2017-11-06 12:47:39,579 ERROR [store-002] [NodeCommunicationService] [store-002-pull-product-5] Failed to execute PULL for node 000 and channel product
java.lang.NullPointerException
    at org.jumpmind.symmetric.service.impl.PullService.execute(PullService.java:117)
    at org.jumpmind.symmetric.service.impl.NodeCommunicationService$1.run(NodeCommunicationService.java:519)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
    at java.lang.Thread.run(Thread.java:745)
2017-11-06 12:47:39,582 ERROR [store-002] [NodeCommunicationService] [store-002-push-product-5] Failed to execute PUSH for node 000 and channel product
java.lang.NullPointerException
    at org.jumpmind.symmetric.service.impl.PushService.execute(PushService.java:145)
    at org.jumpmind.symmetric.service.impl.NodeCommunicationService$1.run(NodeCommunicationService.java:519)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
    at java.lang.Thread.run(Thread.java:745)
Tagsconfiguration

Activities

ivan.konev

2017-11-10 12:14

reporter   ~0001078

Strongly agreed. Got same issue.

ivan.konev

2017-11-10 12:22

reporter   ~0001079

Sure that can be cleaned out manually by purging tables/correcting table with triggers or just disable cluster.lock.enable if not using clustering, anyway clustering gives only failover functionality.

ivan.konev

2017-11-10 13:37

reporter   ~0001080

Additional - does not required removing a channel. Just change queue name back or to something else.

pmarzullo

2020-11-18 21:02

developer   ~0001845

Merged into 3.12.6

pmarzullo

2020-11-18 21:02

developer   ~0001846

Also merged into 3.12.6

Related Changesets

SymmetricDS: 3.11 99553ed5

2020-11-18 20:28:59

pmarzullo

Details Diff
0003305: Removing a channel can cause errors during push/pull Affected Issues
0003305
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/NodeCommunicationService.java Diff File

SymmetricDS: 3.12 1f47b956

2020-11-18 20:28:59

pmarzullo

Details Diff
0003305: Removing a channel can cause errors during push/pull
# Conflicts:
# symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/NodeCommunicationService.java
Affected Issues
0003305
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/NodeCommunicationService.java Diff File

Issue History

Date Modified Username Field Change
2017-11-06 17:57 mmichalek New Issue
2017-11-06 17:57 mmichalek Status new => assigned
2017-11-06 17:57 mmichalek Assigned To => mmichalek
2017-11-10 12:14 ivan.konev Note Added: 0001078
2017-11-10 12:22 ivan.konev Note Added: 0001079
2017-11-10 13:37 ivan.konev Note Added: 0001080
2019-04-24 16:45 elong Tag Attached: configuration
2019-05-22 19:56 elong Assigned To mmichalek => user606
2020-11-18 20:15 pmarzullo Assigned To user606 => pmarzullo
2020-11-18 21:00 pmarzullo Changeset attached => SymmetricDS 3.11 99553ed5
2020-11-18 21:02 pmarzullo Note Added: 0001845
2020-11-18 21:02 pmarzullo Status assigned => resolved
2020-11-18 21:02 pmarzullo Resolution open => fixed
2020-11-18 21:02 pmarzullo Fixed in Version => 3.11.14
2020-11-18 21:02 pmarzullo Note Added: 0001846
2020-11-18 22:00 pmarzullo Changeset attached => SymmetricDS 3.12 1f47b956
2021-11-04 15:03 admin Status resolved => closed
2021-11-04 15:03 admin Target Version => 3.11.14