Re: BUG #15023: problem with pg_statistic

On 01/21/2018 03:59 AM, PG Bug reporting form wrote:
> The following bug has been logged on the website:
>
> Bug reference: 15023
> Logged by: kurt rudahl
> Email address: ktr(at)goldin-rudahl(dot)com
> PostgreSQL version: Unsupported/Unknown
> Operating system: linux
> Description:
>
> Problem: cannot reindex pg_statistic
> therefore cannot vacuum
>
> Steps to recreate:
> 1. restart postgresql
> 2. psql thaistocks
>
> \set VERBOSITY verbose
> thaistocks=# reindex table pg_statistic;
> ERROR: 23505: could not create unique index
> DETAIL: Table contains duplicated values.
> LOCATION: comparetup_index, tuplesort.c:2163
>
> thaistocks=# select starelid,staattnum from pg_statistic group by
> starelid,staattnum having count(*) > 1;
> starelid | staattnum
> ----------+-----------
> 10723 | 5
> 10728 | 1
> 1260 | 9
> (3 rows)
>

It's really difficult (read: impossible) to help you unless you tell us
more - for example what PostgreSQL version you're running, how did you
get into this situation (e.g. any crashes recently?).

In any case, this seems like a case of data corruption, possibly due to
a bug (not sure which PostgreSQL version you're using) hardware failure
or misconfiguration (e.g. system not handling fsync correctly).

If that's the case, I'd suspect there are other corrupted tables.

regards

--
Tomas Vondra http://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services