[Pgpool-general] pcp_attach_node problem?

[Daniel.Crespo at l-3com.com]

Sorry for the delay, I haven't had enough time.

> 1. Show us the logs. Full logs, but only the relevant parts (got tons
> of things to read every day here). :)

I'll try it again with full logs to give them to you guys

> 2. Check whether PostgreSQL is having some problem of some sort before
> blaming it on pgpool-II. Can you run the same queries on both nodes
> and get the same results?

PostgreSQL is not having any problems. It's not a query problem. When I
install the latest CVS head, what I showed to you is what happens.
However, when I uninstall it and install the 2.1 released version, it
doesn't happen anymore. The problem with this 2.1 release is that it
doesn't keep the connection when a node is detached or attached (if I
have an already opened connection and do attach/detach node, it locks. I
must disconnect and reconnect in order to keep doing queries). Another
problem is that I need the insert lock newly introduced to automatically
apply on serial fields tables.

> 3. Check permissions in both bg_hba.conf files.
No problem with this.

> 4. Have you considered using version 8.3.5 of PostgreSQL and see how
> it goes? Or at least, the last revision of the 8.1 branch.
No. I can not update PostgreSQL. I'm using 8.2.1.

When I have the logs, I'll post them for sure. Thanks!

Daniel


> -----Original Message-----
> From: pgpool-general-bounces at pgfoundry.org 
> [mailto:pgpool-general-bounces at pgfoundry.org] On Behalf Of 
> Jaume Sabater
> Sent: Friday, January 09, 2009 2:32 AM
> To: pgpool-general at pgfoundry.org
> Subject: Re: [Pgpool-general] pcp_attach_node problem?
> 
> On Thu, Jan 8, 2009 at 10:14 PM,  <Daniel.Crespo at l-3com.com> wrote:
> 
> >        And issue a SQL Select command on a table, like:
> >            postgres=# select * from pg_stat_activity ;
> >
> >    It returns:
> >    postgres=# select 1;
> >    server closed the connection unexpectedly
> >        This probably means the server terminated abnormally
> >        before or while processing the request.
> >    The connection to the server was lost. Attempting reset: 
> Succeeded.
> >
> >    postgres=# select 1;
> 
> Some ideas:
> 
> 1. Show us the logs. Full logs, but only the relevant parts (got tons
> of things to read every day here). :)
> 2. Check whether PostgreSQL is having some problem of some sort before
> blaming it on pgpool-II. Can you run the same queries on both nodes
> and get the same results?
> 3. Check permissions in both bg_hba.conf files.
> 4. Have you considered using version 8.3.5 of PostgreSQL and see how
> it goes? Or at least, the last revision of the 8.1 branch.
> 
> -- 
> Jaume Sabater
> http://linuxsilo.net/
> 
> "Ubi sapientas ibi libertas"
> _______________________________________________
> Pgpool-general mailing list
> Pgpool-general at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pgpool-general
>