| Lists: | pgsql-general |
|---|
| From: | bricklen <bricklen(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | PD_ALL_VISIBLE flag was incorrectly set in relation "pg_statistic" |
| Date: | 2011-01-31 22:55:34 |
| Message-ID: | AANLkTikDOruwTScrV-pTz2AWKzztp7UzDFxTke72gG6v@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
We just had a slew of the following messages in our log. How concerned
should I be at this point? I have no idea what triggered it.
Version:
PostgreSQL 9.0.2 on x86_64-unknown-linux-gnu, compiled by GCC gcc
(GCC) 4.1.2 20080704 (Red Hat 4.1.2-48), 64-bit
2011-01-31 14:16:13 PST [32767]: [1-1] (user=) (rhost=) WARNING:
PD_ALL_VISIBLE flag was incorrectly set in relation "pg_statistic"
page 22
2011-01-31 14:16:13 PST [32767]: [2-1] (user=) (rhost=) WARNING:
PD_ALL_VISIBLE flag was incorrectly set in relation "pg_statistic"
page 656
2011-01-31 14:16:13 PST [32767]: [3-1] (user=) (rhost=) WARNING:
PD_ALL_VISIBLE flag was incorrectly set in relation "pg_statistic"
page 678
2011-01-31 14:41:44 PST [4208]: [1-1] (user=) (rhost=) WARNING:
PD_ALL_VISIBLE flag was incorrectly set in relation "pg_statistic"
page 99
2011-01-31 14:41:44 PST [4208]: [2-1] (user=) (rhost=) WARNING:
PD_ALL_VISIBLE flag was incorrectly set in relation "pg_statistic"
page 223
2011-01-31 14:41:44 PST [4208]: [3-1] (user=) (rhost=) WARNING:
PD_ALL_VISIBLE flag was incorrectly set in relation "pg_statistic"
page 224
2011-01-31 14:41:44 PST [4208]: [4-1] (user=) (rhost=) WARNING:
PD_ALL_VISIBLE flag was incorrectly set in relation "pg_statistic"
page 247
2011-01-31 14:41:44 PST [4208]: [5-1] (user=) (rhost=) WARNING:
PD_ALL_VISIBLE flag was incorrectly set in relation "pg_statistic"
page 248
2011-01-31 14:41:44 PST [4208]: [6-1] (user=) (rhost=) WARNING:
PD_ALL_VISIBLE flag was incorrectly set in relation "pg_statistic"
page 250
2011-01-31 14:41:44 PST [4208]: [7-1] (user=) (rhost=) WARNING:
PD_ALL_VISIBLE flag was incorrectly set in relation "pg_statistic"
page 251
2011-01-31 14:41:44 PST [4208]: [8-1] (user=) (rhost=) WARNING:
PD_ALL_VISIBLE flag was incorrectly set in relation "pg_statistic"
page 252
2011-01-31 14:41:44 PST [4208]: [9-1] (user=) (rhost=) WARNING:
PD_ALL_VISIBLE flag was incorrectly set in relation "pg_statistic"
page 253
| From: | bricklen <bricklen(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: PD_ALL_VISIBLE flag was incorrectly set in relation "pg_statistic" |
| Date: | 2011-02-01 16:16:07 |
| Message-ID: | AANLkTikW0SUJmv7MU1GjCK0D4Ddjyd0EuqAMvD=vSpJE@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
On Mon, Jan 31, 2011 at 2:55 PM, bricklen <bricklen(at)gmail(dot)com> wrote:
> We just had a slew of the following messages in our log. How concerned
> should I be at this point? I have no idea what triggered it.
>
> Version:
> PostgreSQL 9.0.2 on x86_64-unknown-linux-gnu, compiled by GCC gcc
> (GCC) 4.1.2 20080704 (Red Hat 4.1.2-48), 64-bit
>
> 2011-01-31 14:16:13 PST [32767]: [1-1] (user=) (rhost=) WARNING:
> PD_ALL_VISIBLE flag was incorrectly set in relation "pg_statistic"
> page 22
...
Are there any other details I can provide to help diagnose this issue?
It is a production server, so I'd like to rule out the likelihood of
corruption etc if possible. There were about 3400 entries related to
that message yesterday, referencing two tables (pg_statistics and a
user table). The messages haven't reoccurred, and I've run a couple of
cluster-wide vacuum analyzes to see if I could shake anything else
out.
Cheers,
Bricklen