What this indicates is that someone, or some thing, is trying to create a table in a schema that already exists. Here is the structure of pg_class_relname_nsp_index: CREATE UNIQUE INDEX pg_class_relname_nsp_index ON pg_class USING btree (relname, relnamespace)
What you should also see in the error log is a line immediately following that error which shows you exactly what the conflict is, but you have not provided that to us. On Wed, May 27, 2015 at 4:19 AM, Mitu Verma <mitu.ve...@ericsson.com> wrote: > 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 > > > -- *Melvin Davidson* I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you.
