[pgpool-general: 1477] Re: pgpool-II 3.2.3 - Is it the expected behavior

[David TECHER]

Hi,

Could you give me more info so I can try to reproduce this issue?

Thanks.



________________________________
 De : David TECHER <davidtecher at yahoo.fr>
À : Lonni J Friedman <netllama at gmail.com> 
Cc : "pgpool-general at pgpool.net" <pgpool-general at pgpool.net> 
Envoyé le : Vendredi 8 mars 2013 11h15
Objet : [pgpool-general: 1472] Re: pgpool-II 3.2.3 - Is it the expected behavior
 

Hi,

Thanks for your reply.

In order to be sure that there is no misunderstanding  I did a new test:

- I added a new slave to streaming replication
- I added this new slave to pgpool
- I started pgpool.
- I waited for a few minutes.
- I stopped the new slave (pg_ctl stop)
- I tried to connect using pgpool but it didn't work. (pgpool didn"t allow any connection  for the master and not the the first slave)

I am testing pgpool since a couple of weeks and perhaps there is  a mistake in my configuration file

Attached are my new pgpool.conf file and pgpool-II.log file.

Thanks








________________________________
 De : Lonni J Friedman <netllama at gmail.com>
À : David TECHER <davidtecher at yahoo.fr> 
Cc : "pgpool-general at pgpool.net" <pgpool-general at pgpool.net> 
Envoyé le : Jeudi 7 mars 2013 15h45
Objet : Re: [pgpool-general: 1466] pgpool-II 3.2.3 - Is it the expected behavior
 
This sounds like an old bug which was fixed in 3.2.3.  If you're still
able to reproduce this with 3.2.3, you'll likely need to provide the
pgpool log that includes the problem.

On Thu, Mar 7, 2013 at 3:52 AM, David TECHER <davidtecher at yahoo.fr> wrote:
> Hi,
>
> I am PostgreSQL DBA and I am currently testing pgpool-II 3.2.3 with
> streaming replication ( 1 master and 1 slave)
>
> I opened a ticket to our PostgreSQL provider. Our PostgreSQL provider
> (EnterpriseDB) told us that
>
> The issue which we have found in this build is when load_balance mode is on
> and slave is down, pgpool stops giving connection to the master as well.
> Work is currently on for fixing the above issue and also merging the fixes
> in the newer releases like 3.2.2. and 3.2.3.
>
> Our provider sent me the pgpool binaries for 3.2.0 version. Since I wanted
> to be sure that there is the same issue with 3.2.3 version.
> So I built pgpool 3.2.3 against PostgreSQL Plus Advanced Server 9.1.
>
> At work using a dedicated VM for the test, I did a few tests.
 Indeed when
> the slave is down pgpool is not able to connect to the master.
>
> Is it the expected behavior even if for PostgreSQL 9.1 (Open Source
> Version)?
>
> Thanks for letting me know.
>
> Attached is my  pgpool.conf file.
>
> Jean David TECHER



_______________________________________________
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/20130310/28558d79/attachment.html>