[Spacewalk-list] IntegrityError: duplicate key value violates unique constraint

[Maxime VEROONE]

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-bounces at redhat.com [mailto:spacewalk-list-bounces at redhat.com] De la part de Marcin Figura
Envoyé : mercredi 25 mai 2016 21:18
À : spacewalk-list at 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.

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20160526/d70370af/attachment.htm>