invalid memory alloc request size from pg_stat_activity?

From: James Tomson <james(at)pushd(dot)com>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: Eric Jensen <ej(at)pushd(dot)com>
Subject: invalid memory alloc request size from pg_stat_activity?
Date: 2019-05-06 23:04:18
Message-ID: 1CFDCCD6-B268-48D8-85C8-400D2790B2C3@pushd.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 results in 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 there be some other problem?

Thanks,
James

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message PG Bug reporting form 2019-05-07 00:51:04 BUG #15792: Dependency remains on foreign key constraint when child detached from declarative partition.
Previous Message Francisco Olarte 2019-05-06 19:21:28 Re: identity not working with inherited table