[CAMEL-4271] jdbc aggregation repository - recovery taks and cluster issue

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.8.0
• Fix Version/s: 3.15.0
• Component/s: camel-core, camel-sql
• Assignee: Unassigned
• Reporter: Claus Ibsen
• Created: 26/Jul/11 14:36
• Updated: 26/Jan/22 05:55
• Resolved: 26/Jan/22 05:55

Description

If you enable recovery on the aggregator eip when using a persistent repository such as the jdbc, then you may have a race condition when having multiple camel apps running in a cluster. As the aggregate recover task is running on each Camel app (node) in the cluster. So they may potentially all pickup recovery tasks, and execute those, which may cause duplicate messages being recovered.

What is needed is a lock table or some other way to ensure only one recover tasks "wins" and executes.

We may want to enhance the API in camel to facilitate this kind of locking. As with hawtdb you may have a shared file on the SAN and thus have the same racing issue.

Issue Links

• relates to: CAMEL-8010 Race condition in AggregatorProcessor recovery sometimes causes duplicates (still)
• links to: GitHub Pull Request #6812