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
