• State Not Answered
  • Locked Locked
  • Replies 1 reply
  • Subscribers 21 subscribers
  • Views 3228 views
  • Users 0 members are here
Options
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Why do I get many WARN log messages about "key violation inserting event ID's, attempting to recover task"?

john.skinner
over 6 years ago

I'm new to Change Auditor and just wanted to know if this is normal.

These log messages are the dominate make up of my logs. Here is a sample:

2017-12-28 09:04:26.297 [9][WARN][ChangeAuditor.Sys.HPSqlEventIdDataBulkInsertTask`1.Execute(0)] Key violation inserting Event IDs, attempting to recover task: AuditEvent_EventID:fc6dc85b32204d77a996f13a22ae68ca
2017-12-28 09:04:26.375 [9][WARN][ChangeAuditor.Sys.HPSqlEventIdDataBulkInsertTask`1.DetectDuplicateRecords(0)] 980 duplicate events out of 1000 detected in batch AuditEvent_EventID:fc6dc85b32204d77a996f13a22ae68ca. Event IDs are:

5d7ce701-fc23-505d-9d81-c8d515d66d93
5d7ce701-9724-f258-d46d-4e71ad862871
....

2017-12-28 09:04:26.578 [5][WARN][ChangeAuditor.Sys.HPSqlEventIdDataBulkInsertTask`1.Execute(0)] Key violation inserting Event IDs, attempting to recover task: AuditEvent_EventID:2318347c28e14fd88b25aa5ab44d8044
2017-12-28 09:04:26.656 [5][WARN][ChangeAuditor.Sys.HPSqlEventIdDataBulkInsertTask`1.DetectDuplicateRecords(0)] 1000 duplicate events out of 1000 detected in batch AuditEvent_EventID:2318347c28e14fd88b25aa5ab44d8044. Event IDs are:

ffb4e701-02e7-c25b-5505-7ca3cb30965b
ffb4e701-02e7-c25b-6e39-5623bd58d16d
....

2017-12-28 09:04:26.765 [5][WARN][ChangeAuditor.Sys.HPSqlEventIdDataBulkInsertTask`1.Execute(0)] Key violation inserting Event IDs, attempting to recover task: AuditEvent_EventID:54de8e4201574a0692e3ca63ed117938
2017-12-28 09:04:26.843 [5][WARN][ChangeAuditor.Sys.HPSqlEventIdDataBulkInsertTask`1.DetectDuplicateRecords(0)] 962 duplicate events out of 1000 detected in batch AuditEvent_EventID:54de8e4201574a0692e3ca63ed117938. Event IDs are:

01b5e701-7ce3-3a5e-2c53-e44bec645a12
01b5e701-7ce3-3a5e-37b1-c1de6678397d
....

Parents
  • 0 over 6 years ago
    Hi John,

    These messages would only be common if coordinator is having trouble inserting events to database due to either overwhelming event flow (something is flooding the coordinator with noisy events) or SQL timeouts causing some tasks to replay. The warnings themselves are side-effect of the issue. I would suggest to evaluate any audit area where possibly the auditing is producing large amounts of noise or if any SQL timeouts messages are noted in those same logs. If nothing obvious stands out I would suggest to open a Support case to investigate further.

    Regards,
    Chris
Reply
  • 0 over 6 years ago
    Hi John,

    These messages would only be common if coordinator is having trouble inserting events to database due to either overwhelming event flow (something is flooding the coordinator with noisy events) or SQL timeouts causing some tasks to replay. The warnings themselves are side-effect of the issue. I would suggest to evaluate any audit area where possibly the auditing is producing large amounts of noise or if any SQL timeouts messages are noted in those same logs. If nothing obvious stands out I would suggest to open a Support case to investigate further.

    Regards,
    Chris
Children
No Data