Re: "WIP: Data at rest encryption" patch and, 2 phase commit.

From: Antonin Houska <ah(at)cybertec(dot)at>
To: Toshi Harada <harada(dot)toshi(at)po(dot)ntt-tx(dot)co(dot)jp>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: "WIP: Data at rest encryption" patch and, 2 phase commit.
Date: 2018-07-25 11:54:22
Message-ID: 11824.1532519662@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

Toshi Harada <harada(dot)toshi(at)po(dot)ntt-tx(dot)co(dot)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;
> postgres=# PREPARE TRANSACTION 'foo';
> 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

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

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

In response to


Browse pgsql-hackers by date

  From Date Subject
Next Message Alexander Korotkov 2018-07-25 12:20:59 Re: Locking B-tree leafs immediately in exclusive mode
Previous Message Antonin Houska 2018-07-25 11:47:35 Re: [HACKERS] WIP: Data at rest encryption