Re: foreign key locks

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: foreign key locks
Дата
Msg-id 1341011531-sup-1642@alvh.no-ip.org
обсуждение исходный текст
Ответ на Re: foreign key locks  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Ответы 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>)
Список 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 по дате отправления:

Предыдущее
От: Daniel Farina
Дата:
Сообщение: Re: Posix Shared Mem patch
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: foreign key locks