[pgpool-general: 4429] Re: Too Many open files
Tatsuo Ishii
ishii at postgresql.org
Wed Feb 10 08:45:05 JST 2016
> I'm noticing this error daily in pgpool.log
>
> 2016-02-09 13:15:52: pid 26658: ERROR: failed to accept user connection
> 2016-02-09 13:15:52: pid 26658: DETAIL: accept on socket failed with error : "Too many open files"
> 2016-02-09 13:15:52: pid 26658: FATAL: unable to get session context
>
> I did a google search which found bug fix for this error in versions 3.3.4, 3.2.9, 3.1.12, and 3.0.16
>
> I'm using verions pgpool-II 3.4.0 which you would think this bug would not be in the version.
>
> Server Ubuntu 14.4
> PostgreSQL 9.4.5
>
>
> Wolfgang Schwurack
> Database/System Administrator
> Utah Education Network
> 801-587-9444
> wolf at uen.org
Googling "Too many open files pgpool" and found this, which I did not
get response from the reporter.
> Subject: [pgpool-general: 1058] Re: Too many open files
> From: Tatsuo Ishii <ishii at postgresql.org>
> To: wolf at uen.org
> Cc: pgpool-general at pgpool.net
> Date: Mon, 01 Oct 2012 17:33:27 +0900 (JST)
> Sender: pgpool-general-bounces at pgpool.net
> X-Mailer: Mew version 6.3 on Emacs 23.3 / Mule 6.0 (花散里)
>
> Seems excerption from pgpool log.
> Full error message, please.
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> English: http://www.sraoss.co.jp/index_en.php
> Japanese: http://www.sraoss.co.jp
>
> > I'm getting
> > 'pipe open error:Too many open files'
> > 'gethostbyname() failed: Host name lookup failure host: pgool-con2
> >
> > Same error on standby pgpool host but - failure host: pgpool-con1
> >
> > Is there a parameter setting I need to change?
> >
> > Hosts = Ubuntu
> > Postgresql - 9.2.1
> > Pgpool-II = 3.2
> >
> > 0___ Wolfgang Schwurack
> > c/ /'_ DBA/SA
> > (*) \(*) University of Utah/UEN
> > Tel: (801) 587-9444
> > email: wolf at uen.org
> >
>
More information about the pgpool-general
mailing list