[druid-user] Constant Violation Exception(druid_pendingSegments)

Hi All,

Suddenly data ingestion stopped one of the Druid data source out of 25 + datasource.
It is throwing below error error message. Can you please help?

Thanks,
Pathik

Hi Pathik,

com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry might be related to segments being dropped and new data being added for those time ranges. Do you have any drop rules which conflict with entries in the pending segments table?

Best,

Mark

Hi,

Yes we have “drop before by period 3M”
Thanks,
Pathik

Have you defined lateMessageRejectionPeriod? I think that, if lateMessageRejectionPeriod is set to less than 3M, you should be able to work around this issue.

Let us know how it goes. Also, I apologize for not asking this earlier, which version of Druid are you using?

Hi ,

Where I have to set “ lateMessageRejectionPeriod”? From GUI?
I am using 0.22.2 version.
Thanks,
Pathik

Hi ,

I am trying to set Late Message Rejection Period from Tune (page) but getting below error message . I am using P2M.

Thanks,
Pathik