Re: duplicate key value violates unique constraint "pg_class_relname_nsp_index" - Mailing list 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