pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedTimeout error on pgstat
6+ messages / 3 participants
[nested] [flat]
* Timeout error on pgstat
@ 2012-08-01 20:27 Anibal David Acosta <aa@devshock.com>
0 siblings, 1 reply; 6+ messages in thread
From: Anibal David Acosta @ 2012-08-01 20:27 UTC (permalink / raw)
To: pgsql-admin
I have a lot (maybe 1 every 10 seconds) of this error WARNING: pgstat wait
timeout
Also this
ERROR: canceling autovacuum task
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)
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.
Thanks!!
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Timeout error on pgstat
@ 2012-08-02 02:00 Craig Ringer <ringerc@ringerc.id.au>
parent: Anibal David Acosta <aa@devshock.com>
0 siblings, 3 replies; 6+ messages in thread
From: Craig Ringer @ 2012-08-02 02:00 UTC (permalink / raw)
To: Anibal David Acosta <aa@devshock.com>; +Cc: pgsql-admin
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 timeout
>
A quick search suggests this can be due to excessive I/O. However, this
thread:
http://postgresql.1045698.n5.nabble.com/pgstat-wait-timeout-td5078125.html
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.
http://www.postgresql.org/docs/current/static/release-9-0-8.html
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
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Timeout error on pgstat
@ 2012-08-02 03:59 Tom Lane <tgl@sss.pgh.pa.us>
parent: Craig Ringer <ringerc@ringerc.id.au>
2 siblings, 0 replies; 6+ messages in thread
From: Tom Lane @ 2012-08-02 03:59 UTC (permalink / raw)
To: Craig Ringer <ringerc@ringerc.id.au>; +Cc: Anibal David Acosta <aa@devshock.com>; pgsql-admin
Craig Ringer <ringerc@ringerc.id.au> writes:
> 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 timeout
>>
> A quick search suggests this can be due to excessive I/O. However, this
> thread:
> http://postgresql.1045698.n5.nabble.com/pgstat-wait-timeout-td5078125.html
> sounds very similar to your issue. I'm wondering if there's a bug
> lurking in there somewhere.
Yeah, a lot of us are wondering that. In principle, only a ridiculously
high load could result in triggering this message, but some people can
reproduce it under what apparently isn't very high load. If we could
identify what's different about their setups, maybe we could figure out
what's going on.
regards, tom lane
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Timeout error on pgstat
@ 2012-08-02 14:51 Anibal David Acosta <aa@devshock.com>
parent: Craig Ringer <ringerc@ringerc.id.au>
2 siblings, 0 replies; 6+ messages in thread
From: Anibal David Acosta @ 2012-08-02 14:51 UTC (permalink / raw)
To: 'Craig Ringer' <ringerc@ringerc.id.au>; +Cc: pgsql-admin
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
delete.
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@ringerc.id.au]
Enviado el: miércoles, 01 de agosto de 2012 10:01 p.m.
Para: Anibal David Acosta
CC: pgsql-admin@postgresql.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
timeout
A quick search suggests this can be due to excessive I/O. However, this
thread:
http://postgresql.1045698.n5.nabble.com/pgstat-wait-timeout-td5078125.html
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.
http://www.postgresql.org/docs/current/static/release-9-0-8.html
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
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Timeout error on pgstat
@ 2012-08-02 15:29 Anibal David Acosta <aa@devshock.com>
parent: Craig Ringer <ringerc@ringerc.id.au>
2 siblings, 0 replies; 6+ messages in thread
From: Anibal David Acosta @ 2012-08-02 15:29 UTC (permalink / raw)
To: 'Craig Ringer' <ringerc@ringerc.id.au>; +Cc: 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@devshock.com]
Enviado el: jueves, 02 de agosto de 2012 10:52 a.m.
Para: 'Craig Ringer'
CC: 'pgsql-admin@postgresql.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
delete.
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@ringerc.id.au]
Enviado el: miércoles, 01 de agosto de 2012 10:01 p.m.
Para: Anibal David Acosta
CC: pgsql-admin@postgresql.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
timeout
A quick search suggests this can be due to excessive I/O. However, this
thread:
http://postgresql.1045698.n5.nabble.com/pgstat-wait-timeout-td5078125.html
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.
http://www.postgresql.org/docs/current/static/release-9-0-8.html
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
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Timeout error on pgstat
@ 2012-08-06 13:49 Anibal David Acosta <aa@devshock.com>
0 siblings, 0 replies; 6+ messages in thread
From: Anibal David Acosta @ 2012-08-06 13:49 UTC (permalink / raw)
To: pgsql-admin
Is probably that the cause of this behavior are many many dead tuples in the
table.?
De: Anibal David Acosta [mailto:aa@devshock.com]
Enviado el: miércoles, 01 de agosto de 2012 04:27 p.m.
Para: pgsql-admin@postgresql.org
Asunto: Timeout error on pgstat
I have a lot (maybe 1 every 10 seconds) of this error WARNING: pgstat wait
timeout
Also this
ERROR: canceling autovacuum task
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)
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.
Thanks!!
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2012-08-06 13:49 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2012-08-01 20:27 Timeout error on pgstat Anibal David Acosta <aa@devshock.com>
2012-08-02 02:00 ` Craig Ringer <ringerc@ringerc.id.au>
2012-08-02 03:59 ` Tom Lane <tgl@sss.pgh.pa.us>
2012-08-02 14:51 ` Anibal David Acosta <aa@devshock.com>
2012-08-02 15:29 ` Anibal David Acosta <aa@devshock.com>
2012-08-06 13:49 Re: Timeout error on pgstat Anibal David Acosta <aa@devshock.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox