[pgpool-general: 5914] Re: Query got stuck when running Vacuum
ishii at sraoss.co.jp
Fri Feb 9 08:25:06 JST 2018
> Hi all,
> We saw that one of our queries got stuck with idle in transaction. The log showed the following message
> terminating connection due to conflict with recovery
> User query might have needed to see row versions that must be removed.
> Probably vacuum ran at the same time and that what caused it.
> I saw in pgpool FAQ that "hot_standby_feedback = on" can be used.
> Will this ensure that no queries will get stuck because of vacuum?
> Will setting the parameter to true cause more traffic between the two nodes or slow down things?
> Why pgpool does not pass this error instead of having the query stuck?
Well, pgpool stuck is different story from recovery conflict. Up to
now there have been several commits that fix stuck problems. So what
your pgpool version exactly?
SRA OSS, Inc. Japan
More information about the pgpool-general