[pgpool-hackers: 536] Re: Bugs with PgPool 3.3.3.1 _ PostgreSQL 9.3.4 configuration

[Burgess, Freddie]

The log file attachment came from the master server running streaming replication.

Now, we are having major issues with pgpool. We have a cluster of processing VM's that connected thru the pgpool VM to the master/slave servers. These processing VM's serve up pages to our UI via Hibernate queries. If we disconnect these processing server connections and bounce pgpool, then all of the processing server connections are reestablished with no issues, but if we bounce any one of the processing VM servers while pgpool is up and then try to reconnect, we cannot. The processing servers just hang indefinitely. 

When I checked the connected sessions, there was about forty sessions connected to the pgpool VM. We have max_connections on the master/slave databases set to 100, and we you can see from our pgpool.conf setting that we should be allowing 128 connections.

I'm not sure what is going on, but we had to re-route the processing server connections directly to the master database server, so that our mission-critical app will work,

Are there any special setting that you are aware of when running pgpool with Hibernate and PostgreSQL 9.3.4 and PostGIS 2.1.1

thanks


________________________________________
From: Yugo Nagata [nagata at sraoss.co.jp]
Sent: Tuesday, May 27, 2014 4:45 AM
To: Burgess, Freddie
Cc: pgpool-hackers at pgpool.net
Subject: Re: [pgpool-hackers: 529] Bugs with PgPool 3.3.3.1 _ PostgreSQL 9.3.4 configuration

Hi,

On Wed, 21 May 2014 19:06:46 +0000
"Burgess, Freddie" <FBurgess at Radiantblue.com> wrote:

> We installed installer-pg93-3.3.3.tar.gz and we are running into two major problems.
>
> 1.)  The pgpoolAdmin URL http://<serverIP>/pgpoolAdmin/login.php<http://<ServerIP>/pgpoolAdmin/login.php> interface locks up everyday, and has to be bounced every morning.

The pgpoolAdmin problem soule be answered by Anzai.

> 2.) On the master database log we are getting the error: portal "pgpool_error_portal" does not exist

Could you please show me pgpool.conf, and full log messages of both pgpool and backends?

>
> Any assistance will be greatly appreciated.
>
> thanks
>


--
Yugo Nagata <nagata at sraoss.co.jp>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Logfile-2014-05-21_000000.log
Type: application/octet-stream
Size: 232 bytes
Desc: Logfile-2014-05-21_000000.log
URL: <http://www.sraoss.jp/pipermail/pgpool-hackers/attachments/20140527/08e3c49b/attachment-0002.obj>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pgpool.conf
Type: application/octet-stream
Size: 31686 bytes
Desc: pgpool.conf
URL: <http://www.sraoss.jp/pipermail/pgpool-hackers/attachments/20140527/08e3c49b/attachment-0003.obj>