Re: backends stuck in "startup"

On Tue, Nov 21, 2017 at 03:45:58PM -0800, Andres Freund wrote:
> On 2017-11-21 18:21:16 -0500, Tom Lane wrote:
> > Justin Pryzby <pryzby(at)telsasoft(dot)com> writes:
> > > As $subject: backends are stuck in startup for minutes at a time. I didn't
> > > strace this time, but I believe last time I saw one was waiting in a futex.
>
> A futex? Hm, that was stock postgres?

Yes, from PGDG:

[pryzbyj(at)TS-DB ~]$ rpm -q postgresql10
postgresql10-10.1-1PGDG.rhel6.x86_64

> How many different databases and roles are you having on that system?

postgres=# SELECT COUNT(1) FROM pg_roles ;
count | 25

postgres=# SELECT COUNT(1) FROM pg_database;
count | 15

> I guess iiiiiii is a sanitized name?

Yes

> Right. I took this to be referring to something before the current
> migration, but I might have overinterpreted things.

We never had any issue during the ~2 years running PG96 on this VM, until
upgrading Monday to PG10.1, and we've now hit it 5+ times.

BTW this is a VM run on a hypervisor managed by our customer:
DMI: VMware, Inc. VMware Virtual Platform/440BX Desktop Reference Platform, BIOS 6.00 06/22/2012

Linux TS-DB 2.6.32-431.el6.x86_64 #1 SMP Fri Nov 22 03:15:09 UTC 2013 x86_64 x86_64 x86_64 GNU/Linux

Justin