From: | Keith Fiske <keith(at)omniti(dot)com> |
---|---|
To: | "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org> |
Subject: | 9.6rc1 Background worker starting multiple times |
Date: | 2016-09-15 22:17:07 |
Message-ID: | CAG1_KcBqvS5dqqKdZYDUf+EX3VqQMfnEFMfkO6cHS9dZ79im=w@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Running into an issue with pg_partman's (version 2.6.0) background worker
process with 9.6rc1.
https://github.com/keithf4/pg_partman/tree/master/test/test_bgw
Noticed the issue when a user ran the pgtap tests against it and I'm seeing
the same thing as well. It's working fine with 9.4 and 9.5. Looking in the
postgresql logs it seems to be trying to start the initial background
worker process multiple times and then one of them fails to start properly
which then causes issues when maintenance tries to run. I've attached the
postgresql log file from when 9.5 starts up
(95_postgresql-2016-09-15_180306.log) and things are working normally and
another log file from 9.6 (96_postgresql-2016-09-15_180131.log) that shows
the odd startup behavior
--
Keith Fiske
Database Administrator
OmniTI Computer Consulting, Inc.
http://www.keithf4.com
Attachment | Content-Type | Size |
---|---|---|
95_postgresql-2016-09-15_180306.log | text/x-log | 17.7 KB |
96_postgresql-2016-09-15_180131.log | text/x-log | 19.9 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | vbv256 | 2016-09-16 06:27:35 | BUG #14325: backup restore inherited constraint |
Previous Message | Huan Ruan | 2016-09-15 08:58:51 | Re: BUG #14319: Logical decoding dropping statements in subtransactions |