From: | Mitu Verma <mitu(dot)verma(at)ericsson(dot)com> |
---|---|
To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | duplicate key value violates unique constraint "pg_class_relname_nsp_index" |
Date: | 2015-05-27 08:19:14 |
Message-ID: | 84BC7AB0D621A74893EC9C9E151293B0226AD107@ESESSMB207.ericsson.se |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
HI,
Following error is continuously seen with the postgreSQL database which we are using at customer site.
Current Errors observed: ./fm_db_VoiceReprocessing1/data/pg_log/postgresql-04.log:2015-04-04 01:00:16 CESTERROR: duplicate key value violates unique constraint "pg_class_relname_nsp_index"
Any pointers on why these errors are coming? What is the meaning of duplicate key value violates unique constraint "pg_class_relname_nsp_index"
If it is due to some index corruption or duplicate index? Please help.
Following tables are used frequently in our case
CREATE TABLE AuditTrailLogEntry
(
event int2,
inNodeID VARCHAR(80),
inNodeName VARCHAR(80),
sourceID VARCHAR(300),
inTime TIMESTAMP, -- YYYY/MM/DD HH:MM:SS.mmm
outNodeID VARCHAR(80),
outNodeName VARCHAR(80),
destinationID VARCHAR(300),
outTime TIMESTAMP, -- YYYY/MM/DD HH:MM:SS.mmm
bytes bigint,
cdrs bigint,
tableIndex bigint, -- Unique key
noOfSubfilesInFile bigint,
recordSequenceNumberList VARCHAR(1000),
primary key (tableindex)
) TABLESPACE MMDATA; -
CREATE TABLE EventLogEntry
(
tableIndex int4, -- Unique key
object VARCHAR(80),
method VARCHAR(80),
bgwUser VARCHAR(80),
time CHAR(23), -- YYYY/MM/DD HH:MM:SS.mmm
realUser VARCHAR(80),
host VARCHAR(80),
application VARCHAR(80)
) TABLESPACE MMDATA;
Regards
Mitu
From | Date | Subject | |
---|---|---|---|
Next Message | Albe Laurenz | 2015-05-27 08:51:09 | Re: Can we simulate Oracle Flashback with pg_export_snapshot()? |
Previous Message | Medhavi Mahansaria | 2015-05-27 05:52:21 | Re: Reg: BULK COLLECT |