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

[Marcin Figura]

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/20160525/13b3af83/attachment.htm>