9.4.1 segfault while creating hash index on temporary table

From: Artem Ignatyev <cryo28(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: 9.4.1 segfault while creating hash index on temporary table
Date: 2015-05-13 00:32:25
Message-ID: CABHFwMgYWrMyCFwX0vuG2dmWoQJiRrenxtdOLVEqGvHSVQ7G0g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

I am seeing this bug on my CentOS 6.6 PostgreSQL 9.4.1 db server
(installed from rpms of yum.postgresql.org) as well as on postgresql
9.4.1 from Ubuntu 15.04 repository on my personal laptop.

Steps to reproduce:

1. Create any empty database, i.e. echo 'CREATE DATABASE segfault' |
psql -U postgres template1
2. bzcat segfault.sql.bz2 | psql -U postgres segfault

At this point postgres should crash with segmentation fault and start recovery.

If not, drop the database and steps 1 and 2 a couple of times. In my
case I have a crash ratio of close to 100%.

The stacktrace I extracted with gdb from coredump on CentOS 6.6 server
is also attached to this message

FIY:

Postgresql segfaults on the last line of the attached sql script which
creates a hash index on temporary table

Swapping hash with btree works well.

Also, inserting ANALYZE temp_table in between CREATE TEMP TABLE and
CREATE INDEX also prevents segfault.

---
Thank you, Artem

Attachment Content-Type Size
segfault.sql.bz2 application/x-bzip2 968.7 KB
stacktrace application/octet-stream 5.1 KB

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Venkata Balaji N 2015-05-13 02:22:59 Re: BUG #13279: Not able to connect to postgresql server
Previous Message Christian Almeida 2015-05-12 20:15:47 Re: BUG #13275: Version 9.3.6 is not available in Cross distribution packages