pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Tomas Vondra <tomas.vondra@enterprisedb.com>
To: Greg Stark <stark@mit.edu>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Thomas Munro <thomas.munro@gmail.com>
Cc: Daniel Gustafsson <daniel@yesql.se>
Cc: Stephen Frost <sfrost@snowman.net>
Cc: Alvaro Herrera <alvherre@2ndquadrant.com>
Cc: Andres Freund <andres@anarazel.de>
Cc: David Steele <david@pgmasters.net>
Cc: Dmitry Dolgov <9erthalion6@gmail.com>
Cc: Jakub Wartak <Jakub.Wartak@tomtom.com>
Cc: Tomas Vondra <tomas.vondra@2ndquadrant.com>
Cc: pgsql-hackers <pgsql-hackers@postgresql.org>
Subject: Re: WIP: WAL prefetch (another approach)
Date: Sat, 18 Dec 2021 00:04:00 +0100
Message-ID: <2cdffbfc-9e9b-c1e4-91e4-92b6baa80fe7@enterprisedb.com> (raw)
In-Reply-To: <CAM-w4HOsD0jMhcnfqiUYCdA6MJDDRDkuHBfem_ihLBOATxHn5Q@mail.gmail.com>
References: <CA+hUKGJ1=pOiNjSgXYJnjE3OyRtp8tjMRcON256e5EFpzPpgtA@mail.gmail.com>
	<b971373e-5f05-e691-d83c-c72a4f67167b@enterprisedb.com>
	<CA+hUKGLQqsNBXXZ6uXFi7L9iqx-4ZSuiAvKiPqDtRQs+yFD9ew@mail.gmail.com>
	<CA+hUKGJKDibdw5HzOdgh+tFsA7=wwJ3O6p+qYwbgAD_xkLWA3Q@mail.gmail.com>
	<CAOuzzgrn7iKnFRsB4MHp3UisEQAGgZMbk_ViTN4HV4-Ksq8zCg@mail.gmail.com>
	<CA+hUKGKLakuWXsHuOXYYYyk-CiZKgcqXgzwKb61d9nrpgn5eww@mail.gmail.com>
	<5B6070FF-5869-4A84-88BC-2D04EDCDB858@yesql.se>
	<CA+hUKGJ7OqpdnbSTq5oK=djSeVW2JMnrVPSm8JC-_dbN6Y7bpw@mail.gmail.com>
	<a6915477-c675-7959-28b2-5b8fa60f44fc@enterprisedb.com>
	<CA+hUKG+NRzF7qPdjrJg3OqvfFO-yFCLLTUB9wmVH71zbki3G1Q@mail.gmail.com>
	<477464.1637981215@sss.pgh.pa.us>
	<CAM-w4HO=isS3suLgXV004nZr7nnUm=_1-8PxPo0SJQ92j9+ERQ@mail.gmail.com>
	<1370655.1639767599@sss.pgh.pa.us>
	<CAM-w4HO3vJwW9ZsyUSS095HwzMNc7ZPuSkC7h2rqakixwkRQVQ@mail.gmail.com>
	<1374737.1639770826@sss.pgh.pa.us>
	<CAM-w4HOsD0jMhcnfqiUYCdA6MJDDRDkuHBfem_ihLBOATxHn5Q@mail.gmail.com>

On 12/17/21 23:56, Greg Stark wrote:
> Hm. I seem to have picked a bad checkout. I took the last one before
> the revert (45aa88fe1d4028ea50ba7d26d390223b6ef78acc). Or there's some
> incompatibility with the emulation and the IPC stuff parallel workers
> use.
> 
> 
> 2021-12-17 17:51:51.688 EST [50955] LOG:  background worker "parallel
> worker" (PID 54073) was terminated by signal 10: Bus error
> 2021-12-17 17:51:51.688 EST [50955] DETAIL:  Failed process was
> running: SELECT variance(unique1::int4), sum(unique1::int8),
> regr_count(unique1::float8, unique1::float8)
> FROM (SELECT * FROM tenk1
>        UNION ALL SELECT * FROM tenk1
>        UNION ALL SELECT * FROM tenk1
>        UNION ALL SELECT * FROM tenk1) u;
> 2021-12-17 17:51:51.690 EST [50955] LOG:  terminating any other active
> server processes
> 2021-12-17 17:51:51.748 EST [54078] FATAL:  the database system is in
> recovery mode
> 2021-12-17 17:51:51.761 EST [50955] LOG:  all server processes
> terminated; reinitializing
> 

Interesting. In my experience SIGBUS on PPC tends to be due to incorrect 
alignment, but I'm not sure how that works with the emulation. Can you 
get a backtrace?

regards

-- 
Tomas Vondra
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company





view thread (174+ messages)  latest in thread

Message-ID: <2cdffbfc-9e9b-c1e4-91e4-92b6baa80fe7@enterprisedb.com>
Permalink:  ../2cdffbfc-9e9b-c1e4-91e4-92b6baa80fe7@enterprisedb.com/
Also on:    postgresql.org/message-id/2cdffbfc-9e9b-c1e4-91e4-92b6baa80fe7@enterprisedb.com

 · 

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: tomas.vondra@enterprisedb.com, stark@mit.edu, tgl@sss.pgh.pa.us, thomas.munro@gmail.com, daniel@yesql.se, sfrost@snowman.net, alvherre@2ndquadrant.com, andres@anarazel.de, david@pgmasters.net, 9erthalion6@gmail.com, Jakub.Wartak@tomtom.com, tomas.vondra@2ndquadrant.com
  Subject: Re: WIP: WAL prefetch (another approach)
  In-Reply-To: <2cdffbfc-9e9b-c1e4-91e4-92b6baa80fe7@enterprisedb.com>

* 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