[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