BUG #6035: server crash when executing recursive query (trying to allocate 16 Exabyte memory)

From: "Daniel Schreiber" <daniel(dot)schreiber(at)ergora(dot)eu>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #6035: server crash when executing recursive query (trying to allocate 16 Exabyte memory)
Date: 2011-05-23 10:27:57
Message-ID: 201105231027.p4NARv3m074316@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 6035
Logged by: Daniel Schreiber
Email address: daniel(dot)schreiber(at)ergora(dot)eu
PostgreSQL version: 9.0.4
Operating system: Debian Squeeze
Description: server crash when executing recursive query (trying to
allocate 16 Exabyte memory)
Details:

When I execute the query at
http://www.ergora.eu/data/postgresql/rekursiv_sl.sql on the data at
http://www.ergora.eu/data/postgresql/crashdump.sql.lzma I get unexpected
results:
- on a debian backports postgresql 9.0.4: server crashes, connection drops,
server starts up again. If I do the same on a hot standby server in recovery
mode, the standy crashes an does not startup again.
- on a postgresql compiled from sources with --enable-debug I get ERROR:
invalid memory alloc request size 18446744055163387672

How can I help to analyze the issue?

Thanks,

Daniel

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Bruce Momjian 2011-05-23 12:26:27 Re: [BUGS] BUG #6034: pg_upgrade fails when it should not.
Previous Message Robert Haas 2011-05-23 02:13:50 Re: [BUGS] BUG #6034: pg_upgrade fails when it should not.