insert pulp_database.packages exception 11000 E11000 duplicate key error index:

Solution In Progress - Updated -

Issue

  • We found following error in the log.
  • As per the error it seems that the query is trying to add same epoch details which already exists on pulp_database.

/var/log/httpd/error_log

[Mon Aug 22 12:35:05 2016] [error] An update notice is broken, or duplicate, skipping: RHSA-2014:1919
[Mon Aug 22 12:35:05 2016] [error] An update notice is broken, or duplicate, skipping: RHBA-2012:0319
[Mon Aug 22 12:35:05 2016] [error] An update notice is broken, or duplicate, skipping: RHBA-2013:0008
[Mon Aug 22 12:35:05 2016] [error] An update notice is broken, or duplicate, skipping: RHSA-2014:1653
[Mon Aug 22 12:35:05 2016] [error] An update notice is broken, or duplicate, skipping: RHSA-2013:0241
[Mon Aug 22 12:35:05 2016] [error] An update notice is broken, or duplicate, skipping: RHBA-2012:1597
[Mon Aug 22 12:35:05 2016] [error] An update notice is broken, or duplicate, skipping: RHSA-2013:1812
[Mon Aug 22 12:35:05 2016] [error] An update notice is broken, or duplicate, skipping: RHBA-2013:0047
[Mon Aug 22 12:35:05 2016] [error] An update notice is broken, or duplicate, skipping: RHSA-2015:1706
[Mon Aug 22 12:35:05 2016] [error] An update notice is broken, or duplicate, skipping: RHSA-2012:0152

/var/log/mongodb/mongodb.log:

Tue Aug 16 11:01:46 [conn4] query pulp_database.packages ntoreturn:1 reslen:860 nscanned:131739 { $query: { id: "7cb14271-e42a-4a9b-b8df-e16969814107" } }  nreturned:1 658ms
Tue Aug 16 11:01:47 [conn27] query pulp_database.packages ntoreturn:1 reslen:1101 nscanned:101412 { $query: { id: "534bafba-eb6f-428c-9d9c-fad7c90f1f85" } }  nreturned:1 514ms
[...]
Fri Aug 12 07:19:54 [conn3] insert pulp_database.packages exception 11000 E11000 duplicate key error index: pulp_database.packages.$name_-1_epoch_-1_version_-1_release_-1_arch_-1_filename_-1_checksum_-1  dup key: { : "java-1.6.0-openjdk-javadoc", : "1", : "1.6.0.35", : "1.13.7.1.el5_11", : "x86_64", : "java-1.6.0-openjdk-javadoc-1.6.0.35-1.13.7.1.el5_11.x86_64.rpm", : { sha1: "c5f4f9e4ed308a65ca6743f8adfdeab5c1f0291e" } } 158ms
Fri Aug 12 07:20:05 [conn4] insert pulp_database.packages exception 11000 E11000 duplicate key error index: pulp_database.packages.$name_-1_epoch_-1_version_-1_release_-1_arch_-1_filename_-1_checksum_-1  dup key: { : "kernel-debug", : "0", : "3.10.0", : "123.el7", : "x86_64", : "kernel-debug-3.10.0-123.el7.x86_64.rpm", : { sha1: "dfc04264406ff6a439be1b39a83e80b2c434446a" } } 108ms
Fri Aug 12 07:20:21 [conn3] insert pulp_database.packages exception 11000 E11000 duplicate key error index: pulp_database.packages.$name_-1_epoch_-1_version_-1_release_-1_arch_-1_filename_-1_checksum_-1  dup key: { : "openssh", : "0", : "4.3p2", : "72.el5", : "x86_64", : "openssh-4.3p2-72.el5.x86_64.rpm", : { sha1: "32062ffe4112615b275a8de9bcc2d0bbc40127d4" } } 164ms
[...]
[Mon Aug 22 12:35:05 2016] [error] An update notice is broken, or duplicate, skipping: RHBA-2013:0047
[Mon Aug 22 12:35:05 2016] [error] An update notice is broken, or duplicate, skipping: RHSA-2015:1706
[Mon Aug 22 12:35:05 2016] [error] An update notice is broken, or duplicate, skipping: RHSA-2012:0152

Environment

Red Hat Update Infrastructure 2.1

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content