"WIP: Data at rest encryption" patch and, PostgreSQL 11-beta3

From: Toshi Harada <harada(dot)toshi(at)po(dot)ntt-tx(dot)co(dot)jp>
To: Antonin Houska <ah(at)cybertec(dot)at>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: "WIP: Data at rest encryption" patch and, PostgreSQL 11-beta3
Date: 2018-08-13 05:56:33
Message-ID: 201808130557.w7D5vTM3024861@ccmail04.silk.ntt-tx.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi.

If "data-at-rest-encryption-wip-2018.07.25.patch" is applied to PostgreSQL 11-beta3 released last week,
patch execution will fail as follows.

----
patching file src/backend/replication/logical/reorderbuffer.c
Hunk #9 FAILED at 2464.

1 out of 7 hunks FAILED -- saving rejects to file src/bin/pg_rewind/pg_rewind.c.rej

1 out of 6 hunks FAILED -- saving rejects to file src/bin/pg_upgrade/controldata.c.rej
----

(See the attached file for the entire patch log)

Antonin Houska <ah(at)cybertec(dot)at> wrote:
> 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;
> > 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 Schonig & Schonig GmbH
> Grohrmuhlgasse 26, A-2700 Wiener Neustadt
> Web: https://www.cybertec-postgresql.com
>

Attachment Content-Type Size
PG11-beta3+0725patch.log application/octet-stream 8.1 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Antonin Houska 2018-08-13 06:06:01 Re: "WIP: Data at rest encryption" patch and, PostgreSQL 11-beta3
Previous Message Fabien COELHO 2018-08-13 05:05:10 Re: Allowing printf("%m") only where it actually works