From: Antonin Houska <ah@cybertec.at>
To: Toshi Harada <harada.toshi@po.ntt-tx.co.jp>
Cc: pgsql-hackers@postgresql.org
Subject: Re: "WIP: Data at rest encryption" patch and, 2 phase commit.
Date: Wed, 25 Jul 2018 13:54:22 +0200
Message-ID: <11824.1532519662@localhost> (raw)
In-Reply-To: <201807230637.w6N6bDnQ028675@ccmail04.silk.ntt-tx.co.jp>
References: <1248.1530086523@localhost>
<201807230637.w6N6bDnQ028675@ccmail04.silk.ntt-tx.co.jp>
Toshi Harada <harada.toshi@po.ntt-tx.co.jp> wrote:
> Hi.
>
> I applied the patch "WIP: Data at rest encryption" to PostgreSQL 11 - beta 2 and I'm working on it.
>
> When this patch is applied, the following problem occurs.
>
> * An error occurs when CHECKPOINT is executed during two-phase commit.
> * After an error occurs, if you stop PostgreSQL, it will never start again.
>
> (1) First, execute PREPARE TRANSACTION.
>
> postgres=# BEGIN;
> BEGIN
> postgres=# PREPARE TRANSACTION 'foo';
> PREPARE TRANSACTION
> postgres=#
>
> (2) Execute the CHECKPOINT command from another terminal.
> CHEKPOINT command fails.
>
> postgres=# CHECKPOINT;
> ERROR: checkpoint request failed
> HINT: Consult recent messages in the server log for details.
> postgres=#
The patch version I posted in
https://www.postgresql.org/message-id/11678.1532519255%40localhost
fixes an issue (unitialized pointer) that caused failure here, but it was
SEGFAULT rather than ERROR. And the scope of the bug was broader than just
CHECKPOINT.
Can you please test it again with the new version of the patch?
Anyway, thanks for your reports!
--
Antonin Houska
Cybertec Schönig & Schönig GmbH
Gröhrmühlgasse 26, A-2700 Wiener Neustadt
Web: https://www.cybertec-postgresql.com
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: ah@cybertec.at, harada.toshi@po.ntt-tx.co.jp
Subject: Re: "WIP: Data at rest encryption" patch and, 2 phase commit.
In-Reply-To: <11824.1532519662@localhost>
* 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