Red Hat Bugzilla – Bug 1344708
Duplicate key on "katello_content_facet_errata_eid_caid" when Satellite 6.2 was put under load
Last modified: 2016-12-12 12:11:46 EST
Reproducer: Create several processes that register content hosts (subscription-manager register with an activation key with some content associated) in parallel. 2016-06-10 10:50:29 CEST ERROR: duplicate key value violates unique constraint +"katello_content_facet_errata_eid_caid" 2016-06-10 10:50:29 CEST DETAIL: Key (erratum_id, content_facet_id)=(18, 122) already exists. 2016-06-10 10:50:29 CEST STATEMENT: INSERT INTO katello_content_facet_errata (erratum_id, +content_facet_id) VALUES (18, 122),.... 2016-06-10 10:50:29 CEST ERROR: current transaction is aborted, commands ignored until end of +transaction block 2016-06-10 10:50:29 CEST STATEMENT: DELETE FROM "katello_content_facet_errata" WHERE +"katello_content_facet_errata"."content_facet_id" = 122 2016-06-10 10:56:40 CEST ERROR: duplicate key value violates unique constraint +"katello_content_facet_errata_eid_caid" 2016-06-10 10:56:40 CEST DETAIL: Key (erratum_id, content_facet_id)=(9, 131) already exists. 2016-06-10 10:56:40 CEST STATEMENT: INSERT INTO katello_content_facet_errata (erratum_id, +content_facet_id) VALUES ... 2016-06-10 10:56:40 CEST ERROR: current transaction is aborted, commands ignored until end of +transaction block 2016-06-10 10:56:40 CEST STATEMENT: DELETE FROM "katello_content_facet_errata" WHERE +"katello_content_facet_errata"."content_facet_id" = 131 2016-06-10 11:05:13 CEST ERROR: duplicate key value violates unique constraint +"katello_content_facet_errata_eid_caid" 2016-06-10 11:05:13 CEST DETAIL: Key (erratum_id, content_facet_id)=(10, 149) already exists. 2016-06-10 11:05:13 CEST STATEMENT: INSERT INTO katello_content_facet_errata (erratum_id, +content_facet_id) VALUES ... 2016-06-10 11:05:13 CEST ERROR: current transaction is aborted, commands ignored until end of +transaction block 2016-06-10 11:05:13 CEST STATEMENT: DELETE FROM "katello_content_facet_errata" WHERE +"katello_content_facet_errata"."content_facet_id" = 149 2016-06-10 11:09:21 CEST ERROR: duplicate key value violates unique constraint +"katello_content_facet_errata_eid_caid" 2016-06-10 11:09:21 CEST DETAIL: Key (erratum_id, content_facet_id)=(1566, 147) already exists. 2016-06-10 11:09:21 CEST STATEMENT: INSERT INTO katello_content_facet_errata (erratum_id, +content_facet_id) VALUES (1566, 147), (2298, 147), (424, 147), (2828, 147), (2903, 147), (637, +147), (3931, 147), (4011, 147), (4340, 147) 2016-06-10 11:09:21 CEST ERROR: current transaction is aborted, commands ignored until end of +transaction block 2016-06-10 11:09:21 CEST STATEMENT: DELETE FROM "katello_content_facet_errata" WHERE +"katello_content_facet_errata"."content_facet_id" = 147 # rpm -q satellite katello foreman satellite-6.2.0-14.2.el7sat.noarch katello-3.0.0-6.el7sat.noarch foreman-1.11.0.34-1.el7sat.noarch Debug tarball (Foreman core team permissions needed to download it): http://debugs.theforeman.org/foreman-debug-0Qsen.tar.xz I am able to randomly reproduce on my own box, takes hours to hit with about 100 clients registering.
Note: You may need to configure PassengerMinInstances 2 in /etc/httpd/conf.d/05-foreman-ssl.conf in order to have at least two processes that interfere each other.
Created redmine issue http://projects.theforeman.org/issues/15407 from this bug
Upstream bug component is WebUI
WORKAROUND: cat >>/etc/httpd/conf.d/passenger.conf <<EOPS # Allow only one Foreman and one Puppet Master process <IfModule mod_passenger.c> PassengerMaxPoolSize 2 </IfModule> EOPS This limits number of processes one each, this will slow down processing of requests tho.
Moving to POST since upstream bug http://projects.theforeman.org/issues/15407 has been closed
*** Bug 1334393 has been marked as a duplicate of this bug. ***
VERIFIED on satellite-6.2.5-1.0.el7sat.noarch I used the docker containers (with katello-agent trigerring registration to the satellite). with ~200 hosts registering pretty much at the same time and was unable to hit the issue. (for the previous version of satellite, this was replicable even with <10 containers).
Since the problem described in this bug report should be resolved in a recent advisory, it has been closed with a resolution of ERRATA. For information on the advisory, and where to find the updated files, follow the link below. If the solution does not work for you, open a new bug report. https://access.redhat.com/errata/RHBA-2016:2940