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

From: "Brodie Thiesfield" <brofield2(at)jellycan(dot)com>
To: "Magnus Hagander" <magnus(at)hagander(dot)net>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #3520: insert causing error "invalid memory alloc request size 2147483648"
Date: 2007-08-07 14:28:17
Message-ID: a6507e6c0708070728i169665b1j6c73eddb9b7fb346@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The database is created in UTF-8.
CREATE DATABASE crossbase WITH OWNER = tserver ENCODING = 'UTF-8';

postgres=# \l
List of databases
Name | Owner | Encoding
-----------+----------+----------
crossbase | tserver | UTF8
crosstest | postgres | UTF8
postgres | postgres | UTF8
template0 | postgres | UTF8
template1 | postgres | UTF8

System locale is Japanese cp932.
lc_collate | Japanese_Japan.932
lc_ctype | Japanese_Japan.932
lc_messages | Japanese_Japan.932
lc_monetary | Japanese_Japan.932
lc_numeric | Japanese_Japan.932
lc_time | Japanese_Japan.932

If there are any other settings you need from show all then it is in
the attached file.

Regards,
Brodie

On 8/7/07, Magnus Hagander <magnus(at)hagander(dot)net> wrote:
> On Tue, Aug 07, 2007 at 03:41:07AM +0000, Brodie Thiesfield wrote:
> >
> > 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
>
> This looks like it could be this bug:
> http://archives.postgresql.org/pgsql-committers/2007-05/msg00088.php
>
> I've been unable to reproduce it on CVS HEAD, which could be why.
>
> What encoding is your database in? Is it also UTF-8?
>
> //Magnus
>

Attachment Content-Type Size
showall.txt text/plain 24.8 KB

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Mouhamadou Dia 2007-08-07 14:31:14 RE : RE : RE : BUG #3519: Postgres takes the wrong query plan resulting in performance issues
Previous Message Mouhamadou Dia 2007-08-07 14:27:55 RE : RE : RE : BUG #3519: Postgres takes the wrong query plan resulting in performance issues