Jira (PDB-4312) report_event table can contain duplicates during hashing in migration 67

[Robert Roland (JIRA)]

Title: Message Title

Robert Roland created an issue   PuppetDB / PDB-4312 report_event table can contain duplicates during hashing in migration 67 Issue Type: Bug Assignee: Unassigned Components: PuppetDB Created: 2019/03/18 3:45 PM Priority: Blocker Reporter: Robert Roland During a migration to add a primary key to the resource_events table, the following error occurred: 2019-03-18T14:46:11.220-07:00 ERROR [p.p.s.migrate] Caught SQLException during migration org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "resource_events_transform_pkey" Detail: Key (event_hash)=(\x766eb99a3d40d81416446c565fed3866cf8226f6) already exists. at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2433) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2178) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:306) Investigate if there's an issue with the migration, and add the hash lookup logic from the reports table migration if necessary. Add Comment   This message was sent by Atlassian JIRA (v7.7.1#77002-sha1:e75ca93) -- You received this message because you are subscribed to the Google Groups "Puppet Bugs" group. To unsubscribe from this group and stop receiving emails from it, send an email to puppet-bugs+unsubscr...@googlegroups.com. To post to this group, send email to puppet-bugs@googlegroups.com. Visit this group at https://groups.google.com/group/puppet-bugs. For more options, visit https://groups.google.com/d/optout.