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

Re: [GENERAL] bytea size limit?

From: "Albe Laurenz" <laurenz(dot)albe(at)wien(dot)gv(dot)at>
To: "paulo matadr *EXTERN*" <saddoness(at)yahoo(dot)com(dot)br>
Cc: "GENERAL" <pgsql-general(at)postgresql(dot)org>,"admin" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: [GENERAL] bytea size limit?
Date: 2009-01-22 09:26:26
Message-ID: D960CB61B694CF459DCFB4B0128514C202F7644C@exadv11.host.magwien.gv.at (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-general
Please don't top post.

paulo matadr wrote:
>>> My aplication return erro:
>>> 
>>> 2009-01-20 10:22:03,264 INFO  [STDOUT] Caused by: org.postgresql.util.
>>> PSQLException: ERROR: invalid memory alloc request size 1705447581
>>
>> What are you doing in terms of SQL?
>> INSERT, UPDATE, DELETE?
>> 
>> How big are the binary objects involved?
>> 
>> What are the values of the database parameters shared_buffers 
>> and work_mem?
>
> The size of object depend on report  for a user request,
> shared_buffers = 2048MB
> work_mem = 12MB 
> 
> -------
> Server conf
> 16 GB RAM
> Red Hat Enterprise Linux Server release 5
> 
> Using apliccation web based , with Jboss apliccation server on jdbc driver.
> Lets see  scenario :
> Apliccation request a report,if this bigger , hangs .
> No able to select or others report in this table.

You need to find out the SQL statement that triggers the error.

The error you quoted does not come from the JDBC driver, but from the database
server.

I suggest that you set
log_min_messages to ERROR or lower,
log_min_error_statement to ERROR or lower, and
log_statement to all.

Then reproduce the error and look into the log file to find out the
statement that got the error. We can proceed from there.

Yours,
Laurenz Albe

In response to

Responses

pgsql-admin by date

Next:From: paulo matadrDate: 2009-01-22 12:36:21
Subject: Res: [GENERAL] bytea size limit?
Previous:From: Rob NewtonDate: 2009-01-22 02:39:42
Subject: autovacuum and transaction ID wraparound

pgsql-general by date

Next:From: Reg Me PleaseDate: 2009-01-22 09:30:13
Subject: Re: how to specify the locale that psql uses
Previous:From: Raymond O'DonnellDate: 2009-01-22 09:19:15
Subject: Re: autovacuum daemon

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