[3.0.9] Duplicate entry issue

[Tomszy]

Centreon Web version:2.8.12

Centreon Engine version:1.8.0

Centreon Broker version:3.0.9 on the broker server and every pollers are on 3.0.9 as well now

OS: Oracle Linux 7

Additional environment details :Virtual and we have dedicated broker server with 32 GB RAM and 4 core CPU.

Steps to reproduce the issue: Randomly We are getting Duplicate netry error message in the broker and the cbd sometimes stuck because of these errors. We scheduled a cronjob which is reloading the broker when this error come. This script is checking the log file. But when we reload the broker many services come back to pending status again and again and sometimes 1000+ tests come back to pending status and some poller stuck as well and need to login and restart the centengine.

Here are some things what my collegue found last week: On the broker side

On the mysql side

So it looks the issue with the broker side. Describe the results you expected:

We would like to fix and avoid these errors and we also would like to avoid services come back to pending status.

One more issue: Sometimes when I replace a template on a hosts with another one the old tests are still on the host as well next to the new tests under Monitoring > Status Details > Services. After a centengine restart they are disappearing but when the services come back to pending because of broker issue, these are deleted tests are coming back as well. So it should be a bug.