Re:Re: backend process was crashed when using zabbix monitor

"梁博" <[email protected]> Tue, 1 Jan 2019 09:38:22 +0800
Newsgroups gmane.comp.db.postgresql.sql
Message-ID <[email protected]>
&gt;I have a question for 梁博: Does pgpool happen to be involved here? That
&gt;was a factor in the bug report back in April. It's not impossible that
&gt;it's part of the problem here, too.

Pgpool is not used in our system(pgbouncer is used in our system).ZABBIX monitoring is deployed locally.

------------------ 原始邮件 ------------------
发件人:&nbsp;"Peter Geoghegan" <[email protected]&gt;;
发送时间:&nbsp;2019年1月1日(星期二) 9:27
收件人:&nbsp;"Tom Lane" <[email protected]&gt;;
抄送:&nbsp;"梁博" <[email protected]&gt;;"pgsql-sql" <[email protected]&gt;;
主题:&nbsp;Re: backend process was crashed when using zabbix monitor



On Fri, Dec 28, 2018 at 7:36 AM Tom Lane <[email protected]&gt; wrote:
&gt; It would be worth updating to current (9.6.11) just on general principles.
&gt; I'm too lazy to check the release notes to see whether we fixed any
&gt; memory-stomp bugs since 9.6.8, but we've certainly fixed many bugs since
&gt; then.

My guess is the same as it was back in April: tuplestore and/or one of
its callers gets confused about some aspect of resource management,
leading to a double-free.

Last time it was also a view that expands to a function call
(pg_buffercache, rather than pg_stat_statements).

I have a question for 梁博: Does pgpool happen to be involved here? That
was a factor in the bug report back in April. It's not impossible that
it's part of the problem here, too.

-- 
Peter Geoghegan