invalid memory alloc request size from pg_stat_activity?

Поиск
Список
Период
Сортировка
От James Tomson
Тема invalid memory alloc request size from pg_stat_activity?
Дата
Msg-id 1CFDCCD6-B268-48D8-85C8-400D2790B2C3@pushd.com
обсуждение исходный текст
Ответы 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>)
Список 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 по дате отправления:

Предыдущее
От: Francisco Olarte
Дата:
Сообщение: Re: identity not working with inherited table
Следующее
От: PG Bug reporting form
Дата:
Сообщение: BUG #15792: Dependency remains on foreign key constraint when child detached from declarative partition.