From: | Jeremy Schneider <schnjere(at)amazon(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, neeraj kumar <neeru(dot)cse(at)gmail(dot)com> |
Cc: | <pgsql-admin(at)postgresql(dot)org>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Query on pg_stat_activity table got stuck |
Date: | 2019-05-09 19:46:32 |
Message-ID: | e99f759e-4d18-d297-9e1a-639c7379faf2@amazon.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-general |
On 5/8/19 14:58, Tom Lane wrote:
> neeraj kumar <neeru(dot)cse(at)gmail(dot)com> writes:
>> Yes we use SSL to connect to DB.
>
> Hm. I'm suspicious that one of the functions that fetch data for
> an SSL connection threw an error. In particular, it doesn't look
> to be hard at all to make X509_NAME_to_cstring fall over --- an
> encoding conversion failure would do it, even without any stretchy
> assumptions about OOM this early in backend start. Have you got
> any SSL certificates floating around with non-ASCII subject name
> or issuer name?
Crazy timing. We just had a report come in from a database in the RDS
fleet that's hitting this same issue. It was one of the Aurora systems,
but there wasn't anything Aurora-specific that I could see in the
relevant bits of code.
Seems to me that at a minimum, this loop shouldn't go on forever. Even
having an arbitrary, crazy high, hard-coded number of attempts before
failure (like a million) would be better than spinning on the CPU
forever - which is what we are seeing.
Would be even cooler to detect and correct a broken slot in
PgBackendStatus... if I have a good idea I'll post/try it. :)
-Jeremy
--
Jeremy Schneider
Database Engineer
Amazon Web Services
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2019-05-09 20:00:52 | Re: Query on pg_stat_activity table got stuck |
Previous Message | Rui DeSousa | 2019-05-09 14:16:53 | Re: postgres wal log configuration question |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2019-05-09 20:00:52 | Re: Query on pg_stat_activity table got stuck |
Previous Message | Stephen Frost | 2019-05-09 19:24:44 | Re: integrate Postgres Users Authentication with our own LDAP Server |