| 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: | Whole Thread | Raw Message | 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 |
| 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 |