Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 0751A6336BF; Tue, 29 Dec 2009 21:54:30 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 25456-01; Wed, 30 Dec 2009 01:54:11 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail.postnewspapers.com.au (202-89-185-120.static.dsl.amnet.net.au [202.89.185.120]) by mail.postgresql.org (Postfix) with ESMTP id CFB7D62E7C2; Tue, 29 Dec 2009 21:54:18 -0400 (AST) Received: from localhost (access [127.0.0.1]) by mail.postnewspapers.com.au (Postfix) with ESMTP id B44941E043A; Wed, 30 Dec 2009 09:54:15 +0800 (WST) X-Virus-Scanned: Debian amavisd-new at postnewspapers.com.au Received: from mail.postnewspapers.com.au ([127.0.0.1]) by localhost (access.postnewspapers.com.au [127.0.0.1]) (amavisd-new, port 10024) with LMTP id b5uBtSTi1Szn; Wed, 30 Dec 2009 09:54:13 +0800 (WST) Received: from [10.1.1.6] (124-169-133-89.dyn.iinet.net.au [124.169.133.89]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (Client CN "Craig Ringer", Issuer "POST Certificate Authority" (verified OK)) by mail.postnewspapers.com.au (Postfix) with ESMTPSA id CE5DD1E0439; Wed, 30 Dec 2009 09:54:13 +0800 (WST) Message-ID: <4B3AB2C3.8010100@postnewspapers.com.au> Date: Wed, 30 Dec 2009 09:54:11 +0800 From: Craig Ringer User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-GB; rv:1.9.1.5) Gecko/20091204 Thunderbird/3.0 MIME-Version: 1.0 To: Premila Devi CC: pgsql-general@postgresql.org, pgsql-sql@postgresql.org Subject: Re: DataBase Problem References: <002701ca88f2$6154efe0$23fecfa0$@dayalan@agbnielsen.com> In-Reply-To: <002701ca88f2$6154efe0$23fecfa0$@dayalan@agbnielsen.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.35 tagged_above=-10 required=5 tests=AWL=0.249, BAYES_00=-2.599 X-Spam-Level: X-Archive-Number: 200912/1152 X-Sequence-Number: 157372 On 30/12/2009 9:49 AM, Premila Devi wrote: > Caused by: _java.sql.SQLException_: Couldn't perform the operation > rollback: You can't perform any operations on this connection. It has > been automatically closed by Proxool for some reason (see logs). "see logs" Look at your proxool logs and see why the connection was closed. The error message its self gives you the next step. I suggest reading this: http://wiki.postgresql.org/wiki/Guide_to_reporting_problems for some hints in case you need to ask a more detailed follow-up. -- Craig Ringer