X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 6B169534CE for ; Thu, 24 Mar 2005 21:21:16 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 70706-08 for ; Thu, 24 Mar 2005 21:21:13 +0000 (GMT) Received: from titan.internal (dsl093-203-229.ind1.dsl.speakeasy.net [66.93.203.229]) by svr1.postgresql.org (Postfix) with ESMTP id B09E9534CC for ; Thu, 24 Mar 2005 21:21:10 +0000 (GMT) Received: from [10.0.1.102] (helo=[10.0.1.102] ident=kris) by titan.internal with asmtp (Exim 4.34 #1 (Debian)) id 1DEZlN-0007Et-75; Thu, 24 Mar 2005 16:21:09 -0500 Message-ID: <42432F48.8060103@musicrebellion.com> Date: Thu, 24 Mar 2005 16:21:12 -0500 From: Kris Kiger User-Agent: Mozilla Thunderbird 0.9 (X11/20041103) X-Accept-Language: en-us, en MIME-Version: 1.0 To: "Pgsql-Admin (E-mail)" Subject: Very worried about this Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.05 tagged_above=0 required=5 tests=FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200503/405 X-Sequence-Number: 16903 I have a table that looks like this: Table "public.hd" Column | Type | Modifiers -------------------+-----------------------------+------------------------------------------------------------------------- d_id | integer | not null default nextval('public.hd_d_id_seq'::text) h_id | integer | not null src | text | p_q | integer | not null default 1 c_id | integer | not null insert_time | timestamp without time zone | default now() Indexes: "hd_pkey" PRIMARY KEY, btree (d_id) "hd_idx" btree (h_id, c_id) _Log output:_ [2005-03-24 15:33:25 EST - 13882 - dbname - 4052774] LOG: statement: INSERT INTO hd (c_id, h_id, p_q) VALUES ((SELECT c_id FROM c WHERE e_id = 'tester1'), (SELECT h_id FROM h JOIN c USING (c_id) WHERE e_id = 'tester1' AND h.active AND NOT p_c),10); [2005-03-24 15:33:25 EST - 13882 - dbname - 4052774] ERROR: duplicate key violates unique constraint "hd_pkey" These inserts are being executed ever 1.5 seconds on this database. This error does not happen often and appears to happen randomly. No other inserts are being executed on this table except this one. From our current tests 99% of the inserts go through, with the exception of these few. Honestly, I don't see how this could be caused from something on my end. The primary key value is being determined by a default, so everything should be handled within the database. I'm using postgres 8.0.1. Any ideas? Thanks for the assist! Kris