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

[Videanu Adrian]

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 :
http://www.pgpool.net/mantisbt/view.php?id=14
the issue was solved... 

any ideea ? 

Regards,

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


http://gurjeet.singh.im/






-- 
Gurjeet Singh

http://gurjeet.singh.im/




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

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