[pgpool-general: 1267] unsubscribe
hb at 101-factory.eu
hb at 101-factory.eu
Sun Dec 30 17:55:07 JST 2012
Met vriendelijke groet,
Henk Bronk
101-Factory B.V.
ICT-Security, CSIRT, Cybercrime prevention;
Consultancy, Project management, 2nd Opinion
M +31 (0)6 549 44 610
E hb at 101-factory.eu
W www.101-factory.eu
PGP F3437D34
Sent from my mob. device
On 30 dec. 2012, at 04:00, pgpool-general-request at pgpool.net wrote:
> Send pgpool-general mailing list submissions to
> pgpool-general at pgpool.net
>
> To subscribe or unsubscribe via the World Wide Web, visit
> http://www.sraoss.jp/mailman/listinfo/pgpool-general
> or, via email, send a message with subject or body 'help' to
> pgpool-general-request at pgpool.net
>
> You can reach the person managing the list at
> pgpool-general-owner at pgpool.net
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of pgpool-general digest..."
>
>
> Today's Topics:
>
> 1. [pgpool-general: 1264] Connections stuck in CLOSE_WAIT
> (Philip Hofstetter)
> 2. [pgpool-general: 1265] database detach and I don't understand
> why (Flemming Harms)
> 3. [pgpool-general: 1266] Re: database detach and I don't
> understand why (Flemming Harms)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Sat, 29 Dec 2012 12:12:39 +0100
> From: Philip Hofstetter <phofstetter at sensational.ch>
> To: "pgpool-general at pgpool.net" <pgpool-general at pgpool.net>
> Subject: [pgpool-general: 1264] Connections stuck in CLOSE_WAIT
> Message-ID:
> <CAGKNXQGLCkQWpkdziAWOVow89qox6WW5rbv_JvwL66MLOmoEGw at mail.gmail.com>
> Content-Type: text/plain; charset=UTF-8
>
> Hi,
>
> I have recently updated pgpool from 3.2.1 to the latest HEAD in the
> 3_2_STABLE branch (mainly for
> 22e045e2f362bb007a72ef1651ed2da897e3aa86) . Since then, I notice that
> sometimes connections to pgpool are stuck in a half-closed state which
> also causes pgpool to keep the connections to the backend postgres
> boxes open.
>
> The connections from the application to pgpool are stuck in CLOSE_WAIT state.
>
> Any idea what may be causing this, and more importantly, how to stop it?
>
> The problem with this is that the pgpool process keeps the connection
> open and doesn't accept new connections which will cause it to use up
> all slots quite quickly at which point it can't be connected to any
> more.
>
> I can forcibly close the connection on the postgres end
> (pg_terminate_backend()), but I've had instances where pgpool thought
> this was an abnormal termination and subsequently marked the node as
> failed.
>
> Philip
>
> --
> Sensational AG
> Giessh?belstrasse 62c, Postfach 1966, 8021 Z?rich
> Tel. +41 43 544 09 60, Mobile +41 79 341 01 99
> info at sensational.ch, http://www.sensational.ch
>
>
> ------------------------------
>
> Message: 2
> Date: Sat, 29 Dec 2012 17:56:24 +0100
> From: Flemming Harms <flemming.harms at gmail.com>
> To: pgpool-general at pgpool.net
> Subject: [pgpool-general: 1265] database detach and I don't understand
> why
> Message-ID:
> <CAFP3+ynLTv+2K4J1cr98SMgham-qVfXRFGFev++CsrwxveJ8VA at mail.gmail.com>
> Content-Type: text/plain; charset=ISO-8859-1
>
> Hello,
>
> We have been using pgpool2 for sometime now and been happy with it,
> but lately it suddenly start to detach the database on one of the
> nodes on 2 node cluster. I have been investigated this for a while and
> I can't understand why pgpool2 thinks is should detach.
>
> We are using pgpool version 3.0.4-1 with postgresql version
> 8.4.8-0squeeze2 our application server is JBossAS 5 including (jboss
> messaging 1.4.8-SP2). The application server only communicate through
> pgpool so we are sure that no other processes are working around
> pgpool
>
> We are pretty sure the databases are not different from the beginning
> and it's new records that are created. We post 3 messages on 2
> different jms queues and 3 clients that consumes the messages. When
> jboss messaging component want to remove the messages because it
> delivered to all the clients, pgpool detach the database because it
> get a different response from node 1 when it want to delete the
> message.... which I don't understand how that's possible
>
> I really will appreciate some help to understand what is going on and
> why it detach the database
>
> Thanks!
>
> br,
> Flemming
>
> the log_line_prefix = '%t %p %v %x' for the postgresql
>
> You can find the log files by following the links below for pgpool2
> debug log and postgresql log from both servers
>
> jboss-detach-190.sql(postgresql log) >
> http://ubuntuone.com/6Ku56EoHI7FAXAyC1p1prQ
> jboss-detach-191.sql(postgresql log) >
> http://ubuntuone.com/0ICbQCiowqDgKe7LglMxSV
> pgpool.conf > http://ubuntuone.com/3BhoRnr3ACifYhi2QqSbat
> pgppool-191-log > http://ubuntuone.com/1g8ExrevBeRUj92XS5WjyZ7
>
>
> ------------------------------
>
> Message: 3
> Date: Sat, 29 Dec 2012 18:09:30 +0100
> From: Flemming Harms <flemming.harms at gmail.com>
> To: pgpool-general at pgpool.net
> Subject: [pgpool-general: 1266] Re: database detach and I don't
> understand why
> Message-ID:
> <CAFP3+ynVmHxX44bx1bTdVH75ukMTqZ60bwUyoOdfJpEuGKGBsA at mail.gmail.com>
> Content-Type: text/plain; charset=ISO-8859-1
>
> sorry one of the links didn't work for the pgpool
>
> pgppool-191.log > http://ubuntuone.com/1g8ExrevBeRUj92XS5WjyZ
>
> 2012/12/29 Flemming Harms <flemming.harms at gmail.com>:
>> Hello,
>>
>> We have been using pgpool2 for sometime now and been happy with it,
>> but lately it suddenly start to detach the database on one of the
>> nodes on 2 node cluster. I have been investigated this for a while and
>> I can't understand why pgpool2 thinks is should detach.
>>
>> We are using pgpool version 3.0.4-1 with postgresql version
>> 8.4.8-0squeeze2 our application server is JBossAS 5 including (jboss
>> messaging 1.4.8-SP2). The application server only communicate through
>> pgpool so we are sure that no other processes are working around
>> pgpool
>>
>> We are pretty sure the databases are not different from the beginning
>> and it's new records that are created. We post 3 messages on 2
>> different jms queues and 3 clients that consumes the messages. When
>> jboss messaging component want to remove the messages because it
>> delivered to all the clients, pgpool detach the database because it
>> get a different response from node 1 when it want to delete the
>> message.... which I don't understand how that's possible
>>
>> I really will appreciate some help to understand what is going on and
>> why it detach the database
>>
>> Thanks!
>>
>> br,
>> Flemming
>>
>> the log_line_prefix = '%t %p %v %x' for the postgresql
>>
>> You can find the log files by following the links below for pgpool2
>> debug log and postgresql log from both servers
>>
>> jboss-detach-190.sql(postgresql log) >
>> http://ubuntuone.com/6Ku56EoHI7FAXAyC1p1prQ
>> jboss-detach-191.sql(postgresql log) >
>> http://ubuntuone.com/0ICbQCiowqDgKe7LglMxSV
>> pgpool.conf > http://ubuntuone.com/3BhoRnr3ACifYhi2QqSbat
>> pgppool-191-log > http://ubuntuone.com/1g8ExrevBeRUj92XS5WjyZ7
>
>
> ------------------------------
>
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general
>
>
> End of pgpool-general Digest, Vol 14, Issue 23
> **********************************************
More information about the pgpool-general
mailing list