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

[Tatsuo Ishii]

Do you know how to reproduce the problem?
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

> 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