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
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 |