[pgpool-general: 982] ERROR: portal "" does not exist

Videanu Adrian videanuadrian at yahoo.com
Wed Sep 12 18:24:34 JST 2012

Hi all, 
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 ? 


Adrian Videanu

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

Hi All,

    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.

Best regards,

Gurjeet Singh


Gurjeet Singh


-----Inline Attachment Follows-----

pgpool-general mailing list
pgpool-general at pgpool.net
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20120912/e0c01902/attachment.html>

More information about the pgpool-general mailing list