Re: CREATE INDEX CONCURRENTLY does not index prepared xact's data
От | Noah Misch |
---|---|
Тема | Re: CREATE INDEX CONCURRENTLY does not index prepared xact's data |
Дата | |
Msg-id | 20211030191919.GA355663@rfd.leadboat.com обсуждение исходный текст |
Ответ на | Re: CREATE INDEX CONCURRENTLY does not index prepared xact's data (Sandeep Thakkar <sandeep.thakkar@enterprisedb.com>) |
Ответы |
Re: CREATE INDEX CONCURRENTLY does not index prepared xact's data
(Sandeep Thakkar <sandeep.thakkar@enterprisedb.com>)
|
Список | pgsql-bugs |
On Sat, Oct 30, 2021 at 01:44:56PM +0530, Sandeep Thakkar wrote: > On Sat, Oct 30, 2021 at 1:29 PM Sandeep Thakkar <sandeep.thakkar@enterprisedb.com> wrote: > > On Sat, Oct 30, 2021 at 12:56 PM Andrey Borodin <x4mmm@yandex-team.ru> wrote: > >> Some failed runs on this animal indicate SegFault in places changed by > >> bugfix relevant to this thread. Fails were observed only on HEAD, but this > >> may be a result of concurrent nature of possible new bug. If there is a new > >> bug - this would affect upcoming point release. But we do not know for > >> sure. Other animals show no signs of any related SegFault. > >> Can you please run make check phase on this animal on HEAD multiple time > >> (preferably ~hundred times)? If some of this runs fail it's vital to > >> collect backtraces of run. > > > > OK I got it now. I've scheduled "./run_build.pl HEAD" on this animal to > > run multiple times in a day. Unfortunately, I can't run it ~100 times > > because it's a legacy (slow) server and also we run another animal (anole - > > with a different compiler) on the same server. Depending on the time every > > run on HEAD takes, I'll increase the frequency. Hope this helps. > > I've used "--force" option so that it ignores the last running status. > ./run_build.pl --verbose --force HEAD Thanks, but I don't think that gets us closer to having a stack trace for the SIGSEGV. If some run gets a SIGSEGV, the core dump will get unlinked. I'd disable both buildfarm member cron jobs and then run this script (derived from gharial's buildfarm configuration): git clone https://git.postgresql.org/git/postgresql.git cd postgresql git checkout 70bef49 export LD_LIBRARY_PATH='/opt/uuid-1.6.2/inst/lib:/opt/packages/uuid-1.6.2/inst/lib:/opt/packages/krb5-1.11.3/inst/lib/hpux64:/opt/packages/libmemcached-0.46/inst/lib/hpux64:/opt/packages/libevent-2.0.10/inst/lib/hpux64:/opt/packages/expat-2.0.1/inst/lib/hpux64:/opt/packages/gdbm-1.8.3/inst/lib/hpux64:/opt/packages/openldap-2.4.24/inst/lib/hpux64:/opt/packages/proj-4.7.0/inst/lib:/opt/packages/geos-3.2.2/inst/lib:/opt/packages/db-5.1.19/inst/lib/hpux64:/opt/packages/freetype-2.4.4/inst/lib/hpux64:/opt/packages/tcltk-8.5.9/inst/lib/hpux64:/opt/packages/openssl-1.0.0d/inst/lib/hpux64:/opt/packages/editline-2.9/inst/lib/hpux64:/opt/packages/mutt-1.5.21/inst/lib/hpux64:/opt/packages/libidn-1.20/inst/lib/hpux64:/opt/packages/libxslt-1.1.26/inst/lib/hpux64:/opt/packages/libgcrypt-1.4.6/inst/lib/hpux64:/opt/packages/libgpg_error-1.10/inst/lib/hpux64:/opt/packages/libxml2-2.7.8/inst/lib/hpux64:/opt/packages/zlib-1.2.5/inst/lib/hpux64:/opt/packages/grep-2.7/inst/lib/hpux64:/opt/packages/pcre-8.12/inst/lib/hpux64:/opt/packages/ncurses-5.8/inst/lib/hpux64:/opt/packages/termcap-1.3.1/inst/lib/hpux64:/opt/packages/gettext-0.18.1.1/inst/lib/hpux64:/opt/packages/libiconv-1.13.1/inst/lib/hpux64:/opt/packages/sdk-10.2.0.5.0-hpux-ia64/instantclient_10_2/lib' cat >temp.conf <<EOF log_line_prefix = '%m [%p:%l] %q%a ' log_connections = 'true' log_disconnections = 'true' log_statement = 'all' fsync = off force_parallel_mode = regress EOF ./configure --enable-cassert --enable-debug --with-perl --without-readline \ --with-libxml --with-libxslt --with-libs=/opt/packages/zlib-1.2.5/inst/lib/hpux64:/opt/packages/libxslt-1.1.26/inst/lib/hpux64:/opt/packages/libxml2-2.7.8/inst/lib/hpux64 \ --with-includes=/opt/packages/zlib-1.2.5/inst/include:/opt/packages/libxslt-1.1.26/inst/include:/opt/packages/libxml2-2.7.8/inst/include \ --with-pgport=5678 CFLAGS=-mlp64 CC=gcc make while make check TEMP_CONFIG=$PWD/temp.conf NO_LOCALE=1; do :; done # When the loop stops, use the core file to make a stack trace. If it runs # for a week without stopping, give up.
В списке pgsql-bugs по дате отправления:
Предыдущее
От: Peter GeogheganДата:
Сообщение: Re: BUG #17245: Index corruption involving deduplicated entries
Следующее
От: Kamigishi ReiДата:
Сообщение: Re: BUG #17245: Index corruption involving deduplicated entries