Re: foreign key locks

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: foreign key locks
Дата
Msg-id 4FEAB90A0200002500048B7D@gw.wicourts.gov
обсуждение исходный текст
Ответ на foreign key locks  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Ответы Re: foreign key locks  (Alvaro Herrera <alvherre@commandprompt.com>)
Re: foreign key locks  (Alvaro Herrera <alvherre@commandprompt.com>)
Список pgsql-hackers
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.)

Using that patch, pg_upgrade completes, but pg_dumpall fails:


Upgrade Complete
----------------
Optimizer statistics are not transferred by pg_upgrade so,
once you start the new server, consider running:
    analyze_new_cluster.sh

Running this script will delete the old cluster's data files:
    delete_old_cluster.sh
+ 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
pg_dump: The command was: COPY public.hslot (slotname, hubname,
slotno, slotlink) TO stdout;
pg_dumpall: pg_dump failed on database "regression", exiting
+ pg_dumpall2_status=1
+ pg_ctl -m fast stop
waiting for server to shut down.... done
server stopped
+ [ -n 1 ]
+ echo pg_dumpall of post-upgrade database cluster failed
pg_dumpall of post-upgrade database cluster failed
+ exit 1
make[2]: *** [check] Error 1
make[2]: Leaving directory `/home/kevin/pg/master/contrib/pg_upgrade'
make[1]: *** [check-pg_upgrade-recurse] Error 2
make[1]: Leaving directory `/home/kevin/pg/master/contrib'
make: *** [check-world-contrib-recurse] Error 2


Did I merge it wrong?

-Kevin



Вложения

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Ants Aasma
Дата:
Сообщение: Re: [PATCH] Lazy hashaggregate when no aggregation is needed
Следующее
От: Robert Haas
Дата:
Сообщение: Re: [v9.3] Row-Level Security