Обсуждение: pgsql: Fix bug that could try to freeze running multixacts.
Fix bug that could try to freeze running multixacts. Commits 801c2dc7 and 801c2dc7 made it possible for vacuum to try to freeze a multixact that is still running. That was prevented by a check, but raised an error. Repair. Back-patch all the way. Author: Nathan Bossart, Jeremy Schneider Reported-by: Jeremy Schneider Reviewed-by: Jim Nasby, Thomas Munro Discussion: https://postgr.es/m/DAFB8AFF-2F05-4E33-AD7F-FF8B0F760C17%40amazon.com Branch ------ master Details ------- https://git.postgresql.org/pg/commitdiff/6bda2af039d45d9a136ddc04e2242163177ab5ad Modified Files -------------- src/backend/commands/vacuum.c | 10 ++++++++-- 1 file changed, 8 insertions(+), 2 deletions(-)
On 2019-Oct-16, Thomas Munro wrote: > Fix bug that could try to freeze running multixacts. > > Commits 801c2dc7 and 801c2dc7 made it possible for vacuum to > try to freeze a multixact that is still running. Hmm, is that one commit or two commits that are the same? -- Álvaro Herrera https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
On Thu, Oct 17, 2019 at 7:36 PM Alvaro Herrera <alvherre@2ndquadrant.com> wrote: > On 2019-Oct-16, Thomas Munro wrote: > > Fix bug that could try to freeze running multixacts. > > > > Commits 801c2dc7 and 801c2dc7 made it possible for vacuum to > > try to freeze a multixact that is still running. > > Hmm, is that one commit or two commits that are the same? The second one was supposed to be 53bb309d2d5 but I must have fumbled a copy-and-paste. I hope that someone looking for that in the future will find their way to the email that gives the commit hashes, namely https://www.postgresql.org/message-id/CA%2BhUKGLXna28c_skfJFtCMc3BDrVbSn%2BEK_kLgFE%3DACPKdGnTA%40mail.gmail.com .