Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id E224EB5DC3B for ; Sat, 28 May 2011 10:30:47 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 85980-10 for ; Sat, 28 May 2011 13:30:40 +0000 (UTC) X-Greylist: delayed 00:06:40.539008 by SQLgrey-1.7.6 Received: from mail4.sea5.speakeasy.net (mail4.sea5.speakeasy.net [69.17.117.48]) by mail.postgresql.org (Postfix) with ESMTP id 67FD8B5DC38 for ; Sat, 28 May 2011 10:30:40 -0300 (ADT) Received: (qmail 3505 invoked from network); 28 May 2011 13:23:59 -0000 Received: from 25-76-42-72.skybeam.com (HELO [192.168.2.16]) (scott_ribe@killerbytes.com@[72.42.76.25]) (envelope-sender ) by mail4.sea5.speakeasy.net (qmail-ldap-1.03) with AES128-SHA encrypted SMTP for ; 28 May 2011 13:23:59 -0000 Subject: Re: PostgreSQL logs filling up file system due to duplicate key error Mime-Version: 1.0 (Apple Message framework v1084) Content-Type: text/plain; charset=us-ascii From: Scott Ribe In-Reply-To: Date: Sat, 28 May 2011 07:23:57 -0600 Cc: pgsql-admin@postgresql.org Content-Transfer-Encoding: quoted-printable Message-Id: <5C68D2EA-F5DD-4C5B-A5C2-5A5F1DF4A358@elevated-dev.com> References: To: Selva manickaraja X-Mailer: Apple Mail (2.1084) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201105/175 X-Sequence-Number: 37612 On May 28, 2011, at 7:19 AM, Selva manickaraja wrote: > Though we know this is due to an application bug, the db should not be = repeating it non-stop until halting to an end. This is a bug in your application. It puts a connection into an error = state, doesn't rollback, and keeps submitting transactions and failing. --=20 Scott Ribe scott_ribe@elevated-dev.com http://www.elevated-dev.com/ (303) 722-0567 voice