| From: | Shay Rojansky <roji(at)roji(dot)org> |
|---|---|
| To: | Andres Freund <andres(at)anarazel(dot)de> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Some 9.5beta2 backend processes not terminating properly? |
| Date: | 2015-12-29 13:34:36 |
| Message-ID: | CADT4RqBZ3O3OayZGB7kfLGgNrjyPOQ1RWk=wad3XNqFtEYDFng@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
>
> Could you describe the worklad a bit more? Is this rather concurrent? Do
> you use optimized or debug builds? How long did you wait for the
> backends to die? Is this all over localhost, external ip but local,
> remotely?
>
The workload is a a rather diverse set of integration tests executed with
Npgsql. There's no concurrency whatsoever - tests are executed serially.
The backends stay alive indefinitely, until they are killed. All this is
over localhost with TCP. I can try other scenarios if that'll help.
> > Note that the number of backends that stay stuck after the tests is
> > constant (always 12).
>
> Can you increase the number of backends used in the test? And check
> whether it's still 12?
>
Well, I ran the testsuite twice in parallel, and got... 23 backends stuck
at the end.
> How are your clients disconnecting? Possibly without properly
> disconnecting?
>
That's possible, definitely in some of the test cases.
What I can do is try to isolate things further by playing around with the
tests and trying to see if a more minimal repro can be done - I'll try
doing this later today or tomorrow. If anyone has any other specific tests
or checks I should do let me know.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephen Frost | 2015-12-29 13:35:50 | Re: Additional role attributes && superuser review |
| Previous Message | Andres Freund | 2015-12-29 12:37:02 | Re: Some 9.5beta2 backend processes not terminating properly? |