Re: Query returns no rows in pg_basebackup cluster

From: "Andrus" <kobruleht2(at)hot(dot)ee>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Adrian Klaver" <adrian(dot)klaver(at)aklaver(dot)com>, "pgsql-general" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Query returns no rows in pg_basebackup cluster
Date: 2020-05-22 15:16:28
Message-ID: AB3D504B61A441A5B825201534E52095@dell2
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi!

>> The sorting rules for this locale must be the same in both platforms.
>> Only locale names are different.
>I think they are less alike than you hoped, because if they were alike,
>you wouldn't be seeing this problem.
>Possibly you could try running contrib/amcheck on the index in question
>and see if it reports any issues.

I tried and it reports error

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

Andrus.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2020-05-22 15:16:34 Re: Query to get name a data type of a view
Previous Message Adrian Klaver 2020-05-22 15:13:54 Re: pg_dump crashes