Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group