Re: foreign key locks
От
Kevin Grittner
Тема
Re: foreign key locks
Дата
Msg-id
4FEAB90A0200002500048B7D@gw.wicourts.gov
Список
Дерево обсуждения
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>
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@2ndquadrant.com>
Re: foreign key locks Alvaro Herrera <alvherre@2ndquadrant.com>
Re: foreign key locks Alvaro Herrera <alvherre@2ndquadrant.com>
Re: foreign key locks Alvaro Herrera <alvherre@2ndquadrant.com>
Re: foreign key locks Andres Freund <andres@2ndquadrant.com>
Re: foreign key locks Alvaro Herrera <alvherre@2ndquadrant.com>
Re: foreign key locks Alvaro Herrera <alvherre@2ndquadrant.com>
Re: foreign key locks Alvaro Herrera <alvherre@2ndquadrant.com>
Re: foreign key locks Noah Misch <noah@leadboat.com>
Re: foreign key locks Andres Freund <andres@2ndquadrant.com>
Re: foreign key locks Alvaro Herrera <alvherre@2ndquadrant.com>
Re: foreign key locks Alvaro Herrera <alvherre@2ndquadrant.com>
Re: foreign key locks Noah Misch <noah@leadboat.com>
Re: foreign key locks Alvaro Herrera <alvherre@2ndquadrant.com>
Re: foreign key locks Andres Freund <andres@2ndquadrant.com>
Re: foreign key locks Noah Misch <noah@leadboat.com>
Re: foreign key locks Andres Freund <andres@2ndquadrant.com>
Re: foreign key locks Noah Misch <noah@leadboat.com>
Re: foreign key locks Andres Freund <andres@2ndquadrant.com>
Re: foreign key locks Noah Misch <noah@leadboat.com>
Re: foreign key locks Andres Freund <andres@2ndquadrant.com>
Re: foreign key locks Andres Freund <andres@2ndquadrant.com>
Re: foreign key locks Alvaro Herrera <alvherre@2ndquadrant.com>
Re: foreign key locks Andres Freund <andres@2ndquadrant.com>
Re: foreign key locks Alvaro Herrera <alvherre@2ndquadrant.com>
Re: foreign key locks Alvaro Herrera <alvherre@2ndquadrant.com>
Re: foreign key locks - EvalPlanQual interactions Andres Freund <andres@2ndquadrant.com>
Re: foreign key locks Andres Freund <andres@2ndquadrant.com>
Re: foreign key locks Simon Riggs <simon@2ndQuadrant.com>
Re: foreign key locks Andres Freund <andres@2ndquadrant.com>
Re: foreign key locks Simon Riggs <simon@2ndQuadrant.com>
Re: foreign key locks Robert Haas <robertmhaas@gmail.com>
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
Дата: