Groups > linux.debian.bugs.dist > #1070488

Bug#993848: postgresql-13: A SELECT query with cursor can cause segmentation fault

From	Christoph Berg <myon@debian.org>
Newsgroups	linux.debian.bugs.dist
Subject	Bug#993848: postgresql-13: A SELECT query with cursor can cause segmentation fault
Date	2021-09-09 14:30 +0200
Message-ID	<CVrlL-7p8-1@gated-at.bofh.it> (permalink)
References	(4 earlier) <CVrlL-7p8-3@gated-at.bofh.it> <CVrlL-7p8-5@gated-at.bofh.it> <CVrlL-7p8-7@gated-at.bofh.it> <CUEO5-1TK-1@gated-at.bofh.it> <CVrlL-7p8-7@gated-at.bofh.it>
Organization	linux.* mail to news gateway

Show all headers | View raw

Control: reopen -1

Re: Tomas Barton
> Sorry to bring this up again. I've tried to reproduce the issue on a
> postgresql-13 cluster that wasn't affected by this bug.

Oh, that's a real issue then, reopening. I can confirm the crash here:

2021-09-09 14:18:33.448 CEST [1538480] LOG:  server process (PID 1540244) was terminated by signal 11: Segmentation fault
2021-09-09 14:18:33.448 CEST [1538480] DETAIL:  Failed process was running: COMMIT;

> The bug appears to be introduced in 13.4-1.pgdg100+1 while
> 13.3-1.pgdg100+1 works
> fine.
> Also affects 12.8-1.pgdg100+1
> 
> Steps to reproduce:
> 
> pg_createcluster 13 main
> createdb testdb
> psql -d testdb -f postgresql-segfault.sql
> 
> where the SQL is here:
> https://gist.github.com/deric/b3e82a8ace7fb92935984c2f30361f5c
> 
> Should I cross post this to pgsql-pkg-debian@postgresql.org? I don't wanna
> spam too many mailing lists.

Post it to pgsql-bugs@postgresql.org, either directly or via the bug
submission form on the website. (Bonus points for inlining the gist.)

(I can forward it for you, if you like.)

Christoph

Back to linux.debian.bugs.dist | Previous | Next — Previous in thread | Find similar | Unroll thread

Thread

Bug#993848: postgresql-13: A SELECT query with cursor can cause segmentation fault Tomas Barton <barton.tomas@gmail.com> - 2021-09-07 10:40 +0200
  Bug#993848: postgresql-13: A SELECT query with cursor can cause segmentation fault Christoph Berg <myon@debian.org> - 2021-09-07 14:20 +0200
    Bug#993848: postgresql-13: A SELECT query with cursor can cause segmentation fault Tomas Barton <barton.tomas@gmail.com> - 2021-09-07 18:10 +0200
      Bug#993848: postgresql-13: A SELECT query with cursor can cause segmentation fault Tomas Barton <barton.tomas@gmail.com> - 2021-09-08 11:50 +0200
  Bug#993848: postgresql-13: A SELECT query with cursor can cause segmentation fault Christoph Berg <myon@debian.org> - 2021-09-09 14:30 +0200

csiph-web