Re: foreign key locks - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: foreign key locks
Date
Msg-id 1341011531-sup-1642@alvh.no-ip.org
Whole thread Raw
In response to Re: foreign key locks  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Responses Re: foreign key locks  (Alvaro Herrera <alvherre@commandprompt.com>)
Re: foreign key locks  (Alvaro Herrera <alvherre@commandprompt.com>)
Re: foreign key locks  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-hackers
Excerpts from Kevin Grittner's message of mié jun 27 08:40:58 -0400 2012:
> Alvaro Herrera  wrote:
>
> > here's fklocks v14, which also merges to new master as there were
> > several other conflicts. It passes make installcheck-world now.
>
> Recent commits broke it again, so here's a rebased v15.  (No changes
> other than attempting to merge your work with the pg_controldata and
> pg_resetxlog changes and wrapping that FIXME in a comment.)

Here's v16, merged to latest stuff, before attempting to fix this:

> Using that patch, pg_upgrade completes, but pg_dumpall fails:

> + pg_ctl start -l
> /home/kevin/pg/master/contrib/pg_upgrade/log/postmaster2.log -w
> waiting for server to start.... done
> server started
> + pg_dumpall
> pg_dump: Dumping the contents of table "hslot" failed: PQgetResult()
> failed.
> pg_dump: Error message from server: ERROR:  MultiXactId 115 does no
> longer exist -- apparent wraparound

I was only testing migrating from an old version into patched, not
same-version upgrades.

I think I see what's happening here.

--
Álvaro Herrera <alvherre@commandprompt.com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support


pgsql-hackers by date:

Previous
From: Daniel Farina
Date:
Subject: Re: Posix Shared Mem patch
Next
From: Alvaro Herrera
Date:
Subject: Re: foreign key locks