Can't restart statistics collection and autovacuum

From: Ignacio Colmenero <ignacio(dot)colmenero(at)abracontrols(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Can't restart statistics collection and autovacuum
Date: 2014-03-14 18:26:36
Message-ID: 532349DC.4030903@abracontrols.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi Guys.
Yesterday, the database server was rebooted and database wasn't shut
down properly.
When it went back online, the following messages showed up:
2014-03-13 08:46:08 UTC LOG: 08006: test message did not get through
on socket for statistics collector
2014-03-13 08:46:08 UTC LOCATION: pgstat_init, pgstat.c:463
2014-03-13 08:46:08 UTC LOG: 00000: disabling statistics collector
for lack of working socket
2014-03-13 08:46:08 UTC LOCATION: pgstat_init, pgstat.c:521
2014-03-13 08:46:08 UTC WARNING: 01000: autovacuum not started
because of misconfiguration
2014-03-13 08:46:08 UTC HINT: Enable the "track_counts" option.
2014-03-13 08:46:08 UTC LOCATION: autovac_init, autovacuum.c:2809
2014-03-13 08:46:08 UTC LOG: 00000: database system was interrupted;
last known up at 2014-03-13 08:41:49 UTC

I enabled the track_counts option, but when I checked it, it still shows
as "off".
I have 2 questions:
1. Any ideas how to fix this? I've googled it and check this list and
tried everything so far with no results.
2. Any link to a script I may post on rc6.d to avoid this mishap in the
future?

PostgreSQL version is 9.1.3
OS: Ubuntu 11.10 (GNU/Linux 3.0.0-12-virtual x86_64)
--

/Ignacio Colmenero/
Database Analyst
Abra Controls Inc.
P# (403) 775-2237
ignacio(dot)colmenero(at)abracontrols(dot)com
<mailto:ignacio(dot)colmenero(at)abracontrols(dot)com>

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2014-03-14 19:13:24 Re: Can't restart statistics collection and autovacuum
Previous Message Daryl Foster 2014-03-14 16:58:55 Re: Cannot insert to 'path' field using EclipseLink