Hi, see Tuesday’s thread talkign about duplicate keys, answer is there (short answer, remove the packets firefox-45.1.1-1el7 from your mirrors and channels)
De : spacewalk-list-boun...@redhat.com [mailto:spacewalk-list-boun...@redhat.com] De la part de Marcin Figura Envoyé : mercredi 25 mai 2016 21:18 À : spacewalk-list@redhat.com Objet : [Spacewalk-list] IntegrityError: duplicate key value violates unique constraint Hello, Recently , randomly I started receiving from clients tracebacks with Integrity error. I am running spacewalk version 2.4. IntegrityError: duplicate key value violates unique constraint "rhn_cpu_server_id_uq" Sadly I am not DB expert and was only able to find PRIMARY KEY value in posgresql schema. What could triger such a action and its there a fix? Troubleshooting steps? spaceschema=# \d public.rhncpu; Table "public.rhncpu" Column | Type | Modifiers -------------+--------------------------+------------------------ id | numeric | not null server_id | numeric | not null cpu_arch_id | numeric | not null bogomips | character varying(16) | cache | character varying(16) | family | character varying(32) | mhz | character varying(16) | stepping | character varying(16) | flags | character varying(2048) | model | character varying(64) | version | character varying(32) | vendor | character varying(32) | nrcpu | numeric | default 1 nrsocket | numeric | acpiversion | character varying(64) | apic | character varying(32) | apmversion | character varying(32) | chipset | character varying(64) | created | timestamp with time zone | not null default now() modified | timestamp with time zone | not null default now() Indexes: "rhn_cpu_id_pk" PRIMARY KEY, btree (id) "rhn_cpu_server_id_uq" UNIQUE, btree (server_id) Check constraints: "vn_rhncpu_acpiversion" CHECK (acpiversion::text <> ''::text) "vn_rhncpu_apic" CHECK (apic::text <> ''::text) "vn_rhncpu_apmversion" CHECK (apmversion::text <> ''::text) "vn_rhncpu_bogomips" CHECK (bogomips::text <> ''::text) "vn_rhncpu_cache" CHECK (cache::text <> ''::text) "vn_rhncpu_chipset" CHECK (chipset::text <> ''::text) "vn_rhncpu_family" CHECK (family::text <> ''::text) "vn_rhncpu_flags" CHECK (flags::text <> ''::text) "vn_rhncpu_mhz" CHECK (mhz::text <> ''::text) "vn_rhncpu_model" CHECK (model::text <> ''::text) "vn_rhncpu_stepping" CHECK (stepping::text <> ''::text) "vn_rhncpu_vendor" CHECK (vendor::text <> ''::text) "vn_rhncpu_version" CHECK (version::text <> ''::text) Foreign-key constraints: "rhn_cpu_caid_fk" FOREIGN KEY (cpu_arch_id) REFERENCES rhncpuarch(id) "rhn_cpu_server_fk" FOREIGN KEY (server_id) REFERENCES rhnserver(id) Triggers: rhn_cpu_mod_trig BEFORE INSERT OR UPDATE ON rhncpu FOR EACH ROW EXECUTE PROCEDURE rhn_cpu_mod_trig_fun() Mintel Group Limited | 333 West Wacker Drive Suite 1100 | Chicago, Illinois USA 60606 Contact details for our other offices can be found at http://www.mintel.com/office-locations. This email and any attachments may include content that is confidential, privileged or otherwise protected under applicable law. Unauthorized disclosure, copying, distribution or use of the contents is prohibited and may be unlawful. If you have received this email in error, including without appropriate authorization, then please reply to the sender about the error and delete this email and any attachments.
_______________________________________________ Spacewalk-list mailing list Spacewalk-list@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-list
