Re: pgpool ABORT + no transaction warning

From: Tatsuo Ishii <ishii(at)sraoss(dot)co(dot)jp>
To: tfo(at)sitening(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: pgpool ABORT + no transaction warning
Date: 2006-04-01 14:01:28
Message-ID: 20060401.230128.91316374.t-ishii@sraoss.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> A while back, I posted about seeing a number of warnings from pgpool:
>
> http://archives.postgresql.org/pgsql-admin/2005-03/msg00305.php
>
> A typical pair of statements in my postgres logs looks like this:
>
> WARNING: there is no transaction in progress
> STATEMENT: ABORT
>
> Tatsuo Ishii declared that these were harmless, and I took (and still
> take) his word for it.
>
> At some point in the past with my old configuration (postgres 8.1.3 /
> pgpool 2.5.1) I did something that prevented the warnings from
> showing up. On a system running postgres 8.1.3, I recently upgraded
> pgpool from 2.5.1 to 3.0.1. When I upgraded pgpool, I began seeing
> the warnings again after a long window of not having seen them. My
> configuration files for pgpool and postgres didn't change during the
> upgrade, so I'm wondering what I might've been doing to avoid
> polluting my logs with them previously and why they are showing up
> again.
>
> pgpool itself seems to be working fine after the upgrade, so as long
> as the warnings are harmless, it's not a big deal, but I'd like a
> clean method of preventing log noise if one exists.

Could you tell me how to reproduce the problem?
--
Tatsuo Ishii
SRA OSS, Inc. Japan

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Nirmalya Lahiri 2006-04-01 15:08:52 Re: encryption/decryption
Previous Message Qingqing Zhou 2006-04-01 12:34:21 Re: [GENERAL] PANIC: heap_update_redo: no block