9.6rc1 Background worker starting multiple times

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

Responses

Browse pgsql-bugs by date

  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