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

Started by Daniel Schreiberalmost 15 years ago2 messagesbugs
Jump to latest
#1Daniel Schreiber
daniel.schreiber@ergora.eu

The following bug has been logged online:

Bug reference: 6035
Logged by: Daniel Schreiber
Email address: daniel.schreiber@ergora.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

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Daniel Schreiber (#1)
Re: BUG #6035: server crash when executing recursive query (trying to allocate 16 Exabyte memory)

"Daniel Schreiber" <daniel.schreiber@ergora.eu> writes:

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:

Fixed, thanks for the report!

regards, tom lane