ERROR: item order invariant violated for index "vocabulary_phrase_key"
DETAIL: Lower index tid=(29915,116) (points to index tid=(97262,1)) higher index tid=(29915,117) (points to index tid=(118496,1)) page lsn=5A8/6AA20EC8.
SQL state: XX002
--
Vladimir
вт, 24 сент. 2019 г. в 14:04, Peter Geoghegan <pg@bowt.ie>: > > On Tue, Sep 24, 2019 at 1:55 PM Vladimir Ryabtsev <greatvovan@gmail.com> wrote: > I would try running contrib/amcheck, which should be able to confirm > index corruption, and give you a specific complaint. You may then be > able to inspect the exact index page with the problem using > contrib/pageinspect. Something like this ought to do it on Postgres > 10: > > CREATE EXTENSION IF NOT EXISTS amcheck > SELECT bt_index_check('vocabulary_phrase_key'); >