authority indexes can fail on Postgres 9.3.0
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Evergreen |
Fix Released
|
Critical
|
Unassigned |
Bug Description
We have observed that running a REINDEX TABLE on authority.
evergreen=# select count(*) from authority.
count
-------
8
(1 row)
evergreen=# reindex table authority.
ERROR: could not read block 0 in file "base/16385/82148": read only 0 of 8192 bytes
CONTEXT: SQL statement "SELECT control_set FROM authority.
PL/pgSQL function authority.
The by_heading* indexes on authority.
Steps were taken to confirm that this wasn't simply index corruption specific to the test database, including dropping and recreating the by_heading* indexes, dropping and recreating both the normal_heading() functions and the indexes, and starting with a completely fresh 9.3 cluster. In all cases, 'reindex table authority.
This problem is not observed with Postgres 9.1 and 9.2. Preliminary testing on our end suggests that converting the indexes to either hash or GIST avoids whatever seems to be wrong with the BTREE version of the indexes.
This is most probably a PostgreSQL bug, but I'm opening an Evergreen LP as well.
Evergreen 2.3, 2.4, and 2.5
PostgreSQL 9.3.0
Debian Wheezy
tags: | added: postgresql |
tags: | added: authority |
Changed in evergreen: | |
assignee: | nobody → Mike Rylander (mrylander) |
tags: | added: 2.6-rc-blocker |
Changed in evergreen: | |
status: | Fix Committed → Fix Released |
Galen,
I can confirm the issue on a server running a recent version of master.
Evergreen master
PostgreSQL 9.3.1
Ubuntu 12.04 LTS