testing cvs HEAD - HS/SR - missing file
От
Erik Rijkers
Тема
testing cvs HEAD - HS/SR - missing file
Дата
Msg-id
4ee6cfe90680c39ca47cecf4f91bfee8.squirrel@webmail.xs4all.nl
Ответ на
Re: Review: listagg aggregate (Kevin Grittner)
Список
Дерево обсуждения
Review: listagg aggregate David E. Wheeler <david@kineticode.com>
Re: Review: listagg aggregate Simon Riggs <simon@2ndQuadrant.com>
Re: Review: listagg aggregate Pavel Stehule <pavel.stehule@gmail.com>
Re: Review: listagg aggregate Tom Lane <tgl@sss.pgh.pa.us>
Re: Review: listagg aggregate Pavel Stehule <pavel.stehule@gmail.com>
Re: Review: listagg aggregate Pavel Stehule <pavel.stehule@gmail.com>
Re: Review: listagg aggregate "David E. Wheeler" <david@kineticode.com>
Re: Review: listagg aggregate Pavel Stehule <pavel.stehule@gmail.com>
Re: Review: listagg aggregate Scott Bailey <artacus@comcast.net>
Re: Review: listagg aggregate Peter Eisentraut <peter_e@gmx.net>
Re: Review: listagg aggregate Pavel Stehule <pavel.stehule@gmail.com>
Re: Review: listagg aggregate Tom Lane <tgl@sss.pgh.pa.us>
Re: Review: listagg aggregate Pavel Stehule <pavel.stehule@gmail.com>
Re: Review: listagg aggregate "David E. Wheeler" <david@kineticode.com>
Re: Review: listagg aggregate Pavel Stehule <pavel.stehule@gmail.com>
Re: Review: listagg aggregate Pavel Stehule <pavel.stehule@gmail.com>
Re: Review: listagg aggregate "David E. Wheeler" <david@kineticode.com>
Re: Review: listagg aggregate Pavel Stehule <pavel.stehule@gmail.com>
Re: Review: listagg aggregate "David E. Wheeler" <david@kineticode.com>
Re: Review: listagg aggregate Takahiro Itagaki <itagaki.takahiro@oss.ntt.co.jp>
Re: Review: listagg aggregate Pavel Stehule <pavel.stehule@gmail.com>
Re: Review: listagg aggregate Robert Haas <robertmhaas@gmail.com>
Re: Review: listagg aggregate Pavel Stehule <pavel.stehule@gmail.com>
Re: Review: listagg aggregate "David E. Wheeler" <david@kineticode.com>
Re: Review: listagg aggregate Pavel Stehule <pavel.stehule@gmail.com>
Re: Review: listagg aggregate Pavel Stehule <pavel.stehule@gmail.com>
Re: Review: listagg aggregate Takahiro Itagaki <itagaki.takahiro@oss.ntt.co.jp>
Re: Review: listagg aggregate Robert Haas <robertmhaas@gmail.com>
Re: Review: listagg aggregate Pavel Stehule <pavel.stehule@gmail.com>
Re: Review: listagg aggregate Robert Haas <robertmhaas@gmail.com>
Re: Review: listagg aggregate Tom Lane <tgl@sss.pgh.pa.us>
Re: Review: listagg aggregate Greg Stark <stark@mit.edu>
Re: Review: listagg aggregate Robert Haas <robertmhaas@gmail.com>
Re: Review: listagg aggregate Pavel Stehule <pavel.stehule@gmail.com>
Re: Review: listagg aggregate Tom Lane <tgl@sss.pgh.pa.us>
Re: Review: listagg aggregate Pavel Stehule <pavel.stehule@gmail.com>
Re: Review: listagg aggregate Tom Lane <tgl@sss.pgh.pa.us>
Re: Review: listagg aggregate Pavel Stehule <pavel.stehule@gmail.com>
Re: Review: listagg aggregate Robert Haas <robertmhaas@gmail.com>
Re: Review: listagg aggregate Takahiro Itagaki <itagaki.takahiro@oss.ntt.co.jp>
Re: Review: listagg aggregate Pavel Stehule <pavel.stehule@gmail.com>
Re: Review: listagg aggregate Thom Brown <thombrown@gmail.com>
Re: Review: listagg aggregate Pavel Stehule <pavel.stehule@gmail.com>
Re: Review: listagg aggregate Thom Brown <thombrown@gmail.com>
Re: Review: listagg aggregate Robert Haas <robertmhaas@gmail.com>
Re: Review: listagg aggregate "David E. Wheeler" <david@kineticode.com>
Re: Review: listagg aggregate Robert Haas <robertmhaas@gmail.com>
Re: Review: listagg aggregate "David E. Wheeler" <david@kineticode.com>
Re: Review: listagg aggregate Pavel Stehule <pavel.stehule@gmail.com>
Re: Review: listagg aggregate Hitoshi Harada <umi.tanuki@gmail.com>
Re: Review: listagg aggregate Pavel Stehule <pavel.stehule@gmail.com>
Re: Review: listagg aggregate Marko Tiikkaja <marko.tiikkaja@cs.helsinki.fi>
Re: Review: listagg aggregate "David E. Wheeler" <david@kineticode.com>
Re: Review: listagg aggregate Tom Lane <tgl@sss.pgh.pa.us>
Re: Review: listagg aggregate "David E. Wheeler" <david@kineticode.com>
Re: Review: listagg aggregate Robert Haas <robertmhaas@gmail.com>
Re: Review: listagg aggregate Pavel Stehule <pavel.stehule@gmail.com>
Re: Review: listagg aggregate "David E. Wheeler" <david@kineticode.com>
Re: Review: listagg aggregate Peter Eisentraut <peter_e@gmx.net>
Re: Review: listagg aggregate "David E. Wheeler" <david@kineticode.com>
Re: Review: listagg aggregate Tom Lane <tgl@sss.pgh.pa.us>
Re: Review: listagg aggregate Robert Haas <robertmhaas@gmail.com>
Re: Review: listagg aggregate Tom Lane <tgl@sss.pgh.pa.us>
Re: Review: listagg aggregate Robert Haas <robertmhaas@gmail.com>
Re: Review: listagg aggregate "David E. Wheeler" <david@kineticode.com>
Re: Review: listagg aggregate Tom Lane <tgl@sss.pgh.pa.us>
Re: Review: listagg aggregate Alastair Turner <bell@ctrlf5.co.za>
Re: Review: listagg aggregate Alastair Turner <bell@ctrlf5.co.za>
Re: Review: listagg aggregate Tom Lane <tgl@sss.pgh.pa.us>
Re: Review: listagg aggregate "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
testing cvs HEAD - HS/SR - missing file "Erik Rijkers" <er@xs4all.nl>
Re: testing cvs HEAD - HS/SR - missing file Fujii Masao <masao.fujii@gmail.com>
Re: testing cvs HEAD - HS/SR - missing file Fujii Masao <masao.fujii@gmail.com>
Re: testing cvs HEAD - HS/SR - missing file Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: testing cvs HEAD - HS/SR - missing file Fujii Masao <masao.fujii@gmail.com>
Re: testing cvs HEAD - HS/SR - missing file Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: testing cvs HEAD - HS/SR - missing file Fujii Masao <masao.fujii@gmail.com>
Re: testing cvs HEAD - HS/SR - missing file Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: testing cvs HEAD - HS/SR - missing file "Erik Rijkers" <er@xs4all.nl>
Re: testing cvs HEAD - HS/SR - missing file Fujii Masao <masao.fujii@gmail.com>
Re: testing cvs HEAD - HS/SR - missing file "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: Review: listagg aggregate Robert Haas <robertmhaas@gmail.com>
Re: Review: listagg aggregate Pavel Stehule <pavel.stehule@gmail.com>
I don't know if it has anything to do with HS/SR, I haven't tried it on a single CVS vanilla installation (yet). To test with HS/SR, I've setup three 9.0devel instances (cvs as of today) on a single machine, one as a primary, and two as slaves. I used the instructions in http://wiki.postgresql.org/wiki/Streaming_Replication and ./configure --prefix=/var/data1/pg_stuff/pg_installations/pgsql.sr_primary \ --with-pgport=6565 --quiet --enable-depend --with-openssl --with-perl \ --with-libxml --with-libxslt These seem to work/replicate well. Now, when restoring a 700MB dump (made with a 9.0devel pg_dump + pg_restore) into the primary, errors like the following occur, on all three instances: FATAL: could not open file "pg_xlog/0000000100000001000000FF" (log file 1, segment 255): No such file or directory So, there are three logfiles: pgsql.sr_primary/logfile pgsql.sr_slavery/logfile pgsql.sr_slave02/logfile $ grep -E 'FATAL|ERROR' pgsql.sr_*/logfile pgsql.sr_primary/logfile:ERROR: canceling autovacuum task pgsql.sr_primary/logfile:ERROR: canceling autovacuum task pgsql.sr_primary/logfile:FATAL: could not open file "pg_xlog/0000000100000001000000FF" (log file 1, segment 255): No such file or directory pgsql.sr_primary/logfile:FATAL: could not open file "pg_xlog/0000000100000001000000FF" (log file 1, segment 255): No such file or directory pgsql.sr_primary/logfile:ERROR: canceling autovacuum task pgsql.sr_primary/logfile:ERROR: canceling autovacuum task pgsql.sr_slave02/logfile:ERROR: could not read xlog records: FATAL: could not open file "pg_xlog/0000000100000001000000FF" (log file 1, segment 255): No such file or directory pgsql.sr_slavery/logfile:ERROR: could not read xlog records: FATAL: could not open file "pg_xlog/0000000100000001000000FF" (log file 1, segment 255): No such file or directory This has happened several times, always 'segment' 255, 'log file' 1, 3 or 4. hth, Erik Rijkers
В списке pgsql-hackers по дате отправления