[pgpool-general: 982] ERROR: portal "" does not exist
videanuadrian at yahoo.com
Wed Sep 12 18:24:34 JST 2012
i use pgpoll II -3.1.4 with postgresql 9.1.4 and i have OTRS on this cluster. I have noticed in otrs logs (and postgresql) errors like this:
ERROR: portal "" does not exist, SQL: 'SELECT id, value_text, value_date, value_int
as described here :
the issue was solved...
any ideea ?
--- On Wed, 9/12/12, Gurjeet Singh <singh.gurjeet at gmail.com> wrote:
From: Gurjeet Singh <singh.gurjeet at gmail.com>
Subject: [pgpool-general: 981] Re: Enabling -D switch of pgpool by default
To: "PGPool-general" <pgpool-general at pgpool.net>, pgpool-hackers at pgpool.net
Date: Wednesday, September 12, 2012, 3:03 AM
Any thoughts on this?
On Thu, Sep 6, 2012 at 9:55 AM, Gurjeet Singh <singh.gurjeet at gmail.com> wrote:
I am considering adding the -D switch by default to the pgpool's initi script, so that pgpool ignores the last known state of a replica when pgpool was shutdown. I have seen situations where a replica goes down, and pgpool sets its state to 3 (CON_DOWN), and even if replica is brought back online, and pgpool restarted (without -D switch), pgpool does not recognize the replica as usable.
Adding -D switch to pgpool startup script solves the problem for me. SO I am wondering if it is a bad idea in some cases to use -D switch by default.
-----Inline Attachment Follows-----
pgpool-general mailing list
pgpool-general at pgpool.net
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the pgpool-general