From: Tom Lane <tgl@sss.pgh.pa.us>
To: Andres Freund <andres@anarazel.de>
Cc: garrett@rave.io
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: Re: BUG #17704: Monitoring Queries trigger 'Signal 7: Bus Error' After Creating Hash Partitioned Table
Date: Thu, 01 Dec 2022 17:37:39 -0500
Message-ID: <1721828.1669934259@sss.pgh.pa.us> (raw)
In-Reply-To: <6A41AC1A-18D8-4678-975D-2438722F08FC@anarazel.de>
References: <17704-601ac10a659e8855@postgresql.org>
<6A41AC1A-18D8-4678-975D-2438722F08FC@anarazel.de>
Andres Freund <andres@anarazel.de> writes:
> On December 1, 2022 1:23:06 PM PST, PG Bug reporting form <noreply@postgresql.org> wrote:
>> Today I rolled out a new hash partitioned table with 1024 partitions to our
>> production DB (PostgreSQL 14.6 (Ubuntu 14.6-1.pgdg22.04+1) on
>> aarch64-unknown-linux-gnu, compiled by gcc (Ubuntu 11.3.0-1ubuntu1~22.04)
>> 11.3.0, 64-bit). Previously we had been using pganalyze2 and pgmetrics with
>> no issue. Starting with the deployment of the new partitioned table anytime
>> pgmetrics or pganalyze2 would run we would get a SIGBUS and postgresql would
>> crash.
> Unfortunately that's not pointing anywhere obvious. We'll need a backtrace for the crash at least.
Indeed.
> I'm on my phone rn, so no link. But there's an article on the wiki with information about collecting a backtrace.
https://wiki.postgresql.org/wiki/Generating_a_stack_trace_of_a_PostgreSQL_backend
regards, tom lane
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-bugs@postgresql.org
Cc: tgl@sss.pgh.pa.us, andres@anarazel.de, garrett@rave.io, pgsql-bugs@lists.postgresql.org
Subject: Re: Re: BUG #17704: Monitoring Queries trigger 'Signal 7: Bus Error' After Creating Hash Partitioned Table
In-Reply-To: <1721828.1669934259@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