ERROR: invalid memory alloc request size - Mailing list pgsql-hackers

From Matteo Beccati
Subject ERROR: invalid memory alloc request size
Date
Msg-id 436096F2.3060108@beccati.com
Whole thread Raw
Responses Re: ERROR: invalid memory alloc request size
List pgsql-hackers
Hi,

I'm using 8.1beta4 on a development server for a rather db-intensive 
application. This application has a multiprocess daemon which was 
working fairly well in past. After some recent changes I started having 
deadlock problems. While investigating to remove what was causing them I 
removed some FOR UPDATE clauses (added on 8.0 to prevent other deadlock 
situations), hoping that the newly added FK share locks would better 
handle the concurrent access. In fact the deadlock errors went away, but 
I suddenly started getting some of these:

ERROR:  invalid memory alloc request size 4291419108
CONTEXT:  SQL statement "SELECT 1 FROM ONLY "public"."gw_users" x WHERE 
"u_id" = $1 FOR SHARE OF x"        SQL statement "INSERT INTO gw_log_credits (log_id, u_id, 
credit) SELECT currval('gw_log_log_id_seq'), u_id, SUM(credit) FROM 
gw_objects_credits WHERE o_id =  $1  GROUP BY u_id"        PL/pgSQL function "t_gw_outgoing_a_u" line 8 at SQL
statement       SQL statement "UPDATE gw_outgoing SET ok = 't', response =  $1  WHERE o_id =  $2 "        PL/pgSQL
function"gw_queue_ok" line 30 at SQL statement
 
2

where 4291419108 is a big random number. Please let me know if you need 
other details.


Best regards
--
Matteo Beccati
http://phpadsnew.com
http://phppgads.com


pgsql-hackers by date:

Previous
From: jtv@xs4all.nl
Date:
Subject: Re: Differences in UTF8 between 8.0 and 8.1
Next
From: Martijn van Oosterhout
Date:
Subject: Re: Having trouble startin off with the code..