pg.ddx.io pgsql-hackers@postgresql.org mailing list archive help / color / mirror / Atom feed From: Tom Lane <tgl@sss.pgh.pa.us>
To: Andres Freund <andres@anarazel.de>
Cc: Robert Haas <robertmhaas@gmail.com>
Cc: pgsql-hackers@postgresql.org <pgsql-hackers@postgresql.org>
Cc: Amit Kapila <amit.kapila16@gmail.com>
Cc: "hange-folder>?" < <toggle-mailboxes@alap3.anarazel.de>
Subject: Re: Why are we PageInit'ing buffers in RelationAddExtraBlocks()?
Date: Mon, 28 Jan 2019 22:37:53 -0500
Message-ID: <23362.1548733073@sss.pgh.pa.us> (raw )
In-Reply-To: <20190129032336.ghujzbfgda2za6po@alap3.anarazel.de >
References: <20181220005636.cowkudhiu666mhdi@alap3.anarazel.de >
<20181220230411.zzwioucrg7d3ld2m@alap3.anarazel.de >
<20190115204428.kpqmk3ix6cenr7gi@alap3.anarazel.de >
<11587.1547591721@sss.pgh.pa.us >
<20190128213346.ie6zbwiddgnfd37l@alap3.anarazel.de >
<20190128221055.nddkrusu3u5263qo@alap3.anarazel.de >
<20190128222259.zhi7ovzgtkft6em6@alap3.anarazel.de >
<26263.1548716939@sss.pgh.pa.us >
<20190128234933.ioateictsk3qmsuf@alap3.anarazel.de >
<20190129004036.c2cf3fxoescf2rvf@alap3.anarazel.de >
<20190129032336.ghujzbfgda2za6po@alap3.anarazel.de >
Andres Freund <andres@anarazel.de> writes:
> I did that now. I couldn't reproduce it locally, despite a lot of
> runs. Looking at the buildfarm it looks like the failures were,
> excluding handfish which failed without recognizable symptoms before and
> after, on BSD derived platforms (netbsd, freebsd, OX), which certainly
> is interesting.
Isn't it now. Something about the BSD scheduler perhaps? But we've
got four or five different BSD-ish platforms that reported failures,
and it's hard to believe they've all got identical schedulers.
That second handfish failure does match the symptoms elsewhere:
https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=handfish&dt=2019-01-29%2000%3A20%3A22
inline patch 1: /home/filiperosset/dev/client-code-REL_8/HEAD/pgsql.build/src/interfaces/ecpg/test/results/thread-thread.stderr (+1/-0 lines) download inline-1.patch --- /home/filiperosset/dev/client-code-REL_8/HEAD/pgsql.build/src/interfaces/ecpg/test/expected/thread-thread.stderr 2018-10-30 20:11:45.551967381 -0300
+++ /home/filiperosset/dev/client-code-REL_8/HEAD/pgsql.build/src/interfaces/ecpg/test/results/thread-thread.stderr 2019-01-28 22:38:20.614211568 -0200
@@ -0,0 +1,20 @@
+SQL error: page 0 of relation "test_thread" should be empty but is not on line 125
view thread (25+ messages) latest in thread
Message-ID: <23362.1548733073@sss.pgh.pa.us>
Permalink: ../23362.1548733073@sss.pgh.pa.us/
Also on: postgresql.org/message-id/23362.1548733073@sss.pgh.pa.us
copy link · copy postgr.es · copy git am
reply Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: tgl@sss.pgh.pa.us, andres@anarazel.de, robertmhaas@gmail.com, amit.kapila16@gmail.com, toggle-mailboxes@alap3.anarazel.de
Subject: Re: Why are we PageInit'ing buffers in RelationAddExtraBlocks()?
In-Reply-To: <23362.1548733073@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox