You notice deleted jobs remain.
You notice Sentry jobs accumulating on the jobs page. Normally there is only one Sentry job as Sentry cleans up after itself.
You find messages of the following form in the commander.log
WARNING: This solution involves running queries in your Database. It is recommended that only DBA's or users with experience running queries use these solutions.
The following solution can be done when ElectricFlow is running.
- Find the results of this SQL query:
- The query result would look something like this:
- Any number that appears in both columns is a duplicate and one of the two entries has to be removed. Pick one of the entries and use SQL to delete the duplicates. The following SQL code deletes the duplicates in the above example:
There appears to be a race condition - more prevalent when ElectricFlow is restarted - that enters duplicate jobIds into the database.