ERROR: invalid memory alloc request size <a_big_number_here>

[Matteo Beccati <php(at)beccati(dot)com>]

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