Hi!
ERROR: item order invariant violated for index "desktop_baas_liigid_idx"
DETAIL: Lower index tid=(3,15) (points to index tid=(16,4098)) higher index tid=(3,16) (points to index tid=(17,4098)) page
lsn=292/630C0CE8.
SQL state: XX002
Uh huh ... and I'll bet the same test on the source server is just fine?
I don't find it surprising in the least that different platforms have
different ideas on fine points like how to sort a leading underscore.
Those things just aren't that well standardized.
This column is not used for locale specific data.
Running
alter table desktop alter baas type char(8) collate ucs_basic
fixes the issue.
Is this fix reasonable ?
What other issues may occur ?
Can base backup created in windows using pg_basecakup used in Linux without such fix?
Andrus.
