invalid memory alloc request size from pg_stat_activity? - Mailing list pgsql-bugs

From James Tomson
Subject invalid memory alloc request size from pg_stat_activity?
Date
Msg-id 1CFDCCD6-B268-48D8-85C8-400D2790B2C3@pushd.com
Whole thread Raw
Responses Re: invalid memory alloc request size from pg_stat_activity?  (Euler Taveira <euler@timbira.com.br>)
Re: invalid memory alloc request size from pg_stat_activity?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Hello,

We're upgrading from postgresql 9.6 to 10.6 and everything is working fine, but any query against pg_stat_activity
resultsin ERROR:  invalid memory alloc request size 1652113408 

e.g:

ourdb=> SELECT pid, state, age(query_start, clock_timestamp()), usename, query FROM pg_stat_activity WHERE query !=
'<IDLE>'AND state != 'idle' ORDER BY age limit 100; 
ERROR:  invalid memory alloc request size 1652113408

Maybe this has to do with us setting track_activity_query_size=102400? Is there a known safe maximum for that, or could
therebe some other problem? 

Thanks,
James


pgsql-bugs by date:

Previous
From: Francisco Olarte
Date:
Subject: Re: identity not working with inherited table
Next
From: PG Bug reporting form
Date:
Subject: BUG #15792: Dependency remains on foreign key constraint when child detached from declarative partition.