Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id 1CE9FDA629A for ; Wed, 1 Aug 2012 17:27:26 -0300 (ADT) Received: from mail-yw0-f46.google.com ([209.85.213.46]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1SwfVr-0006fD-Uo for pgsql-admin@postgresql.org; Wed, 01 Aug 2012 20:27:25 +0000 Received: by yhmm54 with SMTP id m54so7787873yhm.19 for ; Wed, 01 Aug 2012 13:27:11 -0700 (PDT) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=20120113; h=from:to:subject:date:message-id:mime-version:content-type:x-mailer :thread-index:content-language:x-gm-message-state; bh=tasL4hOMTrsthPhchAP8fo70AhDh/fh6pL17gnXhVcA=; b=DmNXsU0OYsUxFJLpNvodgSwlazqhBLeg5bK9JZX9+u3xiGG08jpt7uJeELtGfugOIf OwkF0KWVvxWewI9Nuh5/V2xKz8wEMKifP32KW10BtwPxTAPt0RDu4rSiWXizHaLapQim 77HxLQGKoA4/7eRHEKaMZDlvHqFW2LxAErlJraz9TbVHPV3KyeHClfozpSfZjDGuyE0l iJgRuKXUrhCtHWDFceosXW/lTJa3Tks5Gw5HqEV5slA7tG3PPbAn9nM7sGk7N9YOS3XR KySFrM8rYArporTuzX6isxjkO07kqNE+GLy0IpfFYQJBwLOKcxHSf4DdGKqDKR61MLA0 5ygg== Received: by 10.236.145.198 with SMTP id p46mr17955481yhj.49.1343852830996; Wed, 01 Aug 2012 13:27:10 -0700 (PDT) Received: from AnibalVAIO ([190.128.222.90]) by mx.google.com with ESMTPS id y66sm7258595yhi.10.2012.08.01.13.27.09 (version=TLSv1/SSLv3 cipher=OTHER); Wed, 01 Aug 2012 13:27:09 -0700 (PDT) From: "Anibal David Acosta" To: Subject: Timeout error on pgstat Date: Wed, 1 Aug 2012 16:27:08 -0400 Message-ID: <00dc01cd7024$07854340$168fc9c0$@devshock.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_00DD_01CD7002.80743F80" X-Mailer: Microsoft Outlook 14.0 Thread-Index: Ac1wI9c06zUgkksFQhS6iq4QmoIHtg== Content-Language: es-py X-Gm-Message-State: ALoCoQkVCD7du67UkIqPsoNnlM28w2h2Tkyfvbu9qyUZFYKJzH8wXWBtQv0g07Er4ChkIYPefhvC X-Pg-Spam-Score: -1.2 (-) X-Archive-Number: 201208/8 X-Sequence-Number: 39829 This is a multipart message in MIME format. ------=_NextPart_000_00DD_01CD7002.80743F80 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit 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!! ------=_NextPart_000_00DD_01CD7002.80743F80 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

I have a lot (ma= ybe 1 every 10 seconds) of this error WARNING: pgstat wait timeout

= Also this

ERROR: canceling autova= cuum 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 (accor= ding 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!!

= ------=_NextPart_000_00DD_01CD7002.80743F80--