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

BUG #3520: insert causing error "invalid memory alloc request size 2147483648"

From: "Brodie Thiesfield" <brofield2(at)jellycan(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #3520: insert causing error "invalid memory alloc request size 2147483648"
Date: 2007-08-07 03:41:07
Message-ID: 200708070341.l773f7WS038481@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      3520
Logged by:          Brodie Thiesfield
Email address:      brofield2(at)jellycan(dot)com
PostgreSQL version: 8.2.4
Operating system:   Windows XP SP2
Description:        insert causing error "invalid memory alloc request size
2147483648"
Details: 

See SQL script and output at:
http://jellycan.com/etc/postgres-bug.zip

STEPS TO REPRODUCE

See attached file postgre-bug.sql
Execute with "psql dbname < postgre.bug"

Note that this testcase has been reduced as much as appears possible.
Changes to the script will cause the error to go away (e.g. reducing the
number of strings, removing the analyse statements). The error will also
disappear if the data is dumped/loaded with pg_dump and the INSERT statement
executed.

OUTPUT

(at time of final INSERT)
ERROR:  XX000: invalid memory alloc request size 2147483648
LOCATION:  MemoryContextAlloc, mcxt.c:504

See attached file postgre-bug.out

OUTPUT EXPECTED

No error (same SQL works fine in sqlite and MS SQL).

INSTALLATION

>psql --version
psql (PostgreSQL) 8.2.4

Upgrade installation from 8.2.2 using installer, default options.
Error also existed in version 8.2.2
Running on Windows XP SP2 (Japanese)

Responses

pgsql-bugs by date

Next:From: Gregory StarkDate: 2007-08-07 08:40:22
Subject: Re: RE : RE : BUG #3519: Postgres takes the wrong query plan resulting in performance issues
Previous:From: Tom LaneDate: 2007-08-07 01:30:53
Subject: Re: RE : RE : BUG #3519: Postgres takes the wrong query plan resulting in performance issues

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