Re: PostgreSQL logs filling up file system due to duplicate key error

From: Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
To: Selva manickaraja <mavles78(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: PostgreSQL logs filling up file system due to duplicate key error
Date: 2011-05-28 13:23:57
Message-ID: 5C68D2EA-F5DD-4C5B-A5C2-5A5F1DF4A358@elevated-dev.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

--
Scott Ribe
scott_ribe(at)elevated-dev(dot)com
http://www.elevated-dev.com/
(303) 722-0567 voice

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Jesper Krogh 2011-05-28 13:49:44 Re: PostgreSQL logs filling up file system due to duplicate key error
Previous Message Selva manickaraja 2011-05-28 13:19:28 PostgreSQL logs filling up file system due to duplicate key error