Re: Unable To Establish Connections

From: Sam Stearns <samtstearns(at)gmail(dot)com>
To: Tim <elatllat(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Unable To Establish Connections
Date: 2011-05-18 00:41:15
Message-ID: BANLkTinQcvvGp0HUUBJ1AEvpkVmuZ_JghQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Thanks, Tim.

I've turned up logging some more.

On Wed, May 18, 2011 at 8:38 AM, Tim <elatllat(at)gmail(dot)com> wrote:
> First google hit said this:
>
> "It seems (not sure) to occur when user retypes password fast.
> Maybe in this case ODBC driver gets old connection somehow from driver
> manager."
>
> also
> "It looks to me like the ODBC driver is failing to follow the protocol.
> It shouldn't respond with an 'X' if it doesn't have a password, just
> disconnect."
> I would start logging traffic so you have more to go on next time it
> happens.
>
> On Tue, May 17, 2011 at 6:52 PM, Sam Stearns <samtstearns(at)gmail(dot)com> wrote:
>>
>> Anyone have any ideas on this?  We're an ISP.  I was thinking of the
>> possibility of a hack attempt.
>>
>> On Tue, May 17, 2011 at 6:52 PM, Sam Stearns <samtstearns(at)gmail(dot)com>
>> wrote:
>> > Howdy,
>> >
>> > Environment:
>> >
>> > Postgres 8.2.3
>> > Solaris 10
>> >
>> > We were unable to make a remote postgres connection for ~2 hours this
>> > afternoon.  Receiving the following message in the postgres log every
>> > 30 seconds:
>> >
>> > LOG:  expected password response, got message type 88
>> >
>> > Connection limit is 300.  17 active connections at the time.  Bounced
>> > postgres successfully but the above error message was still being
>> > logged.  About 20 minutes later the error message stopped and
>> > connections started to re-establish.
>> >
>> > Any ideas?
>> >
>> > Thank you,
>> >
>> > Sam
>> >
>>
>> --
>> Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-admin
>
>

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Syed Khan 2011-05-18 01:20:26 shutdown procedure warm standby
Previous Message Tim 2011-05-17 23:08:06 Re: Unable To Establish Connections