On Tue, Sep 24, 2019 at 5:28 PM Vladimir Ryabtsev <greatvovan@gmail.com> wrote:
> bt_index_check() shows this:
>
> 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
That's slightly inconvenient, because it's an internal page -- there
is no heap TID that you can use to look at the row in the table
directly. You're going to have to look at the index page directly, and
try to make sense of pageinspect's hex representation of the data.
The following will show details of the pair of tuples that are in the
wrong order here:
CREATE EXTENSION pageinspect;
SELECT * FROM bt_page_items('vocabulary_phrase_key', 29915) WHERE
itemoffset in (116, 117);
What does that look like?
I think that the problem here is likely to have something to do with
OS collations -- this isn't a Postgres bug in all likelihood.
--
Peter Geoghegan