Mailing List Archives

Public Access

 		[Computer Systems Lab]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [Condor-users] Condor Quill Problem

Not only that, I see almost every thing is going wrong. the log is full of like these error:

STATEMENT:  INSERT INTO ClusterAds_Horizontal (scheddname, cluster_id) VALUES ('serv07.hep.phy.cam.ac.uk', '204173')
ERROR:  duplicate key value violates unique constraint "procads_vertical_pkey"
STATEMENT:  INSERT INTO ProcAds_Vertical (scheddname, cluster_id, proc_id, attr, val) VALUES ('serv07.hep.phy.cam.ac.uk', '203320', '0', 'OrigMaxHosts', '1')
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 "procads_vertical_pkey"
STATEMENT:  INSERT INTO ProcAds_Vertical (scheddname, cluster_id, proc_id, attr, val) VALUES ('serv07.hep.phy.cam.ac.uk', '203320', '0', 'CurrentHosts', '0')
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 "procads_vertical_pkey"
STATEMENT:  INSERT INTO ProcAds_Vertical (scheddname, cluster_id, proc_id, attr, val) VALUES ('serv07.hep.phy.cam.ac.uk', '203320', '0', 'CurrentHosts', '0')
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 "procads_vertical_pkey"
STATEMENT:  INSERT INTO ProcAds_Vertical (scheddname, cluster_id, proc_id, attr, val) VALUES ('serv07.hep.phy.cam.ac.uk', '203320', '0', 'LastJobStatus', '2')
ERROR:  duplicate key value violates unique constraint "clusterads_horizontal_pkey"
-Santanu


On 10/01/11 16:37, Santanu Das wrote:
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