Обсуждение: BUG #6035: server crash when executing recursive query (trying to allocate 16 Exabyte memory)

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

"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