Re: [Condor-users] Condor Quill Problem

[Santanu Das <santanu@xxxxxxxxxxxxxxxxx>]

Just checked the database log, and the Error is there about cluster_id in the ClusterAds_Horizontal:

-bash-3.2$ tail -f postgresql-Mon.log
ERROR:  duplicate key value violates unique constraint "clusterads_horizontal_pkey"
STATEMENT:  INSERT INTO ClusterAds_Horizontal (scheddname, cluster_id) VALUES ('serv07.hep.phy.cam.ac.uk', '204173')
ERROR:  duplicate key value violates unique constraint "clusterads_horizontal_pkey"
STATEMENT:  INSERT INTO ClusterAds_Horizontal (scheddname, cluster_id) VALUES ('serv07.hep.phy.cam.ac.uk', '204173')
ERROR:  duplicate key value violates unique constraint "clusterads_horizontal_pkey"

according to the log, cluster_id is 204173 for every entry. Doesn't look like there is any thing wrong with DB itself - does it?

Cheers,
Santanu



On 10/01/11 16:30, Steven Timm wrote:

On Mon, 10 Jan 2011, Carsten Aulbert wrote:

Hi

On Monday 10 January 2011 17:23:01 Santanu Das wrote:

    01/10 16:19:57 [SQL EXECUTION ERROR2] ERROR:  duplicate key value
violates unique constraint "clusterads_horizontal_pkey"


What does that mean?

This looks like a problem within a SQL table. at least one of the columns is
defined to be a "key" which by definition has to be unique and you have a
double entry there.

I fear you might need to look into the tables manually and see where this
problem is buried...

Carsten

Or, since you have never got anything useful into the DB
yet, just drop the database and follow the instructions to
recreate it again that are in the condor manual.

Steve

_______________________________________________
Condor-users mailing list
To unsubscribe, send a message to condor-users-request@xxxxxxxxxxx with a
subject: Unsubscribe
You can also unsubscribe by visiting
https://lists.cs.wisc.edu/mailman/listinfo/condor-users

The archives can be found at:
https://lists.cs.wisc.edu/archive/condor-users/