pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedUnable To Establish Connections
6+ messages / 2 participants
[nested] [flat]
* Unable To Establish Connections
@ 2011-05-17 09:22 Sam Stearns <samtstearns@gmail.com>
0 siblings, 2 replies; 6+ messages in thread
From: Sam Stearns @ 2011-05-17 09:22 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Unable To Establish Connections
@ 2011-05-17 22:52 Sam Stearns <samtstearns@gmail.com>
parent: Sam Stearns <samtstearns@gmail.com>
1 sibling, 0 replies; 6+ messages in thread
From: Sam Stearns @ 2011-05-17 22:52 UTC (permalink / raw)
To: pgsql-admin
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@gmail.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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Unable To Establish Connections
@ 2011-05-17 22:52 Sam Stearns <samtstearns@gmail.com>
parent: Sam Stearns <samtstearns@gmail.com>
1 sibling, 1 reply; 6+ messages in thread
From: Sam Stearns @ 2011-05-17 22:52 UTC (permalink / raw)
To: pgsql-admin
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@gmail.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
>
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Unable To Establish Connections
@ 2011-05-17 23:08 Tim <elatllat@gmail.com>
parent: Sam Stearns <samtstearns@gmail.com>
0 siblings, 1 reply; 6+ messages in thread
From: Tim @ 2011-05-17 23:08 UTC (permalink / raw)
To: Sam Stearns <samtstearns@gmail.com>; +Cc: pgsql-admin
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@gmail.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@gmail.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@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Unable To Establish Connections
@ 2011-05-18 00:41 Sam Stearns <samtstearns@gmail.com>
parent: Tim <elatllat@gmail.com>
0 siblings, 1 reply; 6+ messages in thread
From: Sam Stearns @ 2011-05-18 00:41 UTC (permalink / raw)
To: Tim <elatllat@gmail.com>; +Cc: pgsql-admin
Thanks, Tim.
I've turned up logging some more.
On Wed, May 18, 2011 at 8:38 AM, Tim <elatllat@gmail.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@gmail.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@gmail.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@postgresql.org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-admin
>
>
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Unable To Establish Connections
@ 2011-05-18 22:54 Sam Stearns <samtstearns@gmail.com>
parent: Sam Stearns <samtstearns@gmail.com>
0 siblings, 0 replies; 6+ messages in thread
From: Sam Stearns @ 2011-05-18 22:54 UTC (permalink / raw)
To: Tim <elatllat@gmail.com>; +Cc: pgsql-admin
Future reference:
Problem was caused by primary DNS resolver suffering from degraded
performance. Server experienced a software issue with BIND, the
software that performs DNS resolution.
On Wed, May 18, 2011 at 10:11 AM, Sam Stearns <samtstearns@gmail.com> wrote:
> Thanks, Tim.
>
> I've turned up logging some more.
>
> On Wed, May 18, 2011 at 8:38 AM, Tim <elatllat@gmail.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@gmail.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@gmail.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@postgresql.org)
>>> To make changes to your subscription:
>>> http://www.postgresql.org/mailpref/pgsql-admin
>>
>>
>
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2011-05-18 22:54 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2011-05-17 09:22 Unable To Establish Connections Sam Stearns <samtstearns@gmail.com>
2011-05-17 22:52 ` Sam Stearns <samtstearns@gmail.com>
2011-05-17 22:52 ` Sam Stearns <samtstearns@gmail.com>
2011-05-17 23:08 ` Tim <elatllat@gmail.com>
2011-05-18 00:41 ` Sam Stearns <samtstearns@gmail.com>
2011-05-18 22:54 ` Sam Stearns <samtstearns@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox