Re: pgpool ABORT + no transaction warning

Поиск
Список
Период
Сортировка
От Tatsuo Ishii
Тема Re: pgpool ABORT + no transaction warning
Дата
Msg-id 20060401.230128.91316374.t-ishii@sraoss.co.jp
обсуждение исходный текст
Ответ на pgpool ABORT + no transaction warning  ("Thomas F. O'Connell" <tfo@sitening.com>)
Список 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

В списке pgsql-general по дате отправления:

Предыдущее
От: "Nikolay Samokhvalov"
Дата:
Сообщение: PostgreSQL makes me lie
Следующее
От: Nirmalya Lahiri
Дата:
Сообщение: Re: encryption/decryption