Skip site navigation (1) Skip section navigation (2)

Re: Timeout error on pgstat

From: "Anibal David Acosta" <aa(at)devshock(dot)com>
To: "'Craig Ringer'" <ringerc(at)ringerc(dot)id(dot)au>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Timeout error on pgstat
Date: 2012-08-02 15:29:11
Message-ID: 009801cd70c3$92f277f0$b8d767d0$ (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
Maybe this can contribute…

When I run a query over this table XXX, and immediately try to cancel the
query, the cancel never completes.

I found that this situation was fixed in last release (9.0.8)

·         Ensure sequential scans check for query cancel reasonably often
(Merlin Moncure)

A scan encountering many consecutive pages that contain no live tuples would
not respond to interrupts meanwhile


Maybe in the autovacuum happen something similar?




De: Anibal David Acosta [mailto:aa(at)devshock(dot)com] 
Enviado el: jueves, 02 de agosto de 2012 10:52 a.m.
Para: 'Craig Ringer'
CC: 'pgsql-admin(at)postgresql(dot)org'
Asunto: RE: [ADMIN] Timeout error on pgstat


Craig, those lines appear between pgstat timeout

ERROR:  canceling autovacuum task

CONTEXT:  automatic vacuum of table "XXX"


The table XXX is a table with about 200 insert p/ second. No update or


The problem apparently is just with this table because there are others
autovacuum running and working fin over others tables


The only difference is that this table XXX has about 5millions  of insert
daily and all those 5millons are deleted in the night (cleanup process).





De: Craig Ringer [mailto:ringerc(at)ringerc(dot)id(dot)au] 
Enviado el: miércoles, 01 de agosto de 2012 10:01 p.m.
Para: Anibal David Acosta
CC: pgsql-admin(at)postgresql(dot)org
Asunto: Re: [ADMIN] Timeout error on pgstat


On 08/02/2012 04:27 AM, Anibal David Acosta wrote:

I have a lot (maybe 1 every 10 seconds) of this error WARNING:  pgstat wait

A quick search suggests this can be due to excessive I/O. However, this

sounds very similar to your issue. I'm wondering if there's a bug lurking in
there somewhere.

In the pg_stat_activity show an autovacuum process over a very used table
that runs about 1 hour and then this vacuum is cancelled (according to log)

Was there any context to the `cancelling autovacuum task' message?

 I have Postgres 9.0.3 on a windows 2008 R2 running for about 1 year in same
conditions, but this error is occurring about 1 week ago.


The current 9.0 release is 9.0.8, so you're missing a bunch of bug fixes.

Consider updating. You don't need to do a dump and reload or use pg_upgrade,
since it's only a minor version update. Stop the DB, install the new
binaries, start the DB.

However, I don't see any fixes related to the stats writer in the relnotes
from the 9.0 series.

Craig Ringer

In response to

pgsql-admin by date

Next:From: Kevin GrittnerDate: 2012-08-02 16:08:56
Subject: Re: VACUUM ANALYZE block the whole database
Previous:From: Anibal David AcostaDate: 2012-08-02 14:51:54
Subject: Re: Timeout error on pgstat

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group