Re: Possible corrupt index?

On 4/17/19 12:42 AM, Zahir Lalani wrote:
>> I am not following above.
>> What is running version 10?
>
> Production is 9.6, others are 10 (as we are testing). Prod has always been fine, its been running for 2 years without a hitch. This issue has only occurred recently

Any changes occur between the time it worked and the time it did not?
Say a crash, change in schema, new data added and so on.

Per below the version 10 servers use en_GB.UTF_8 and the production one
en_US.UTF-8.

Why the difference?

And did the production used to be en_GB.UTF_8?

Have you logged into the production instance using psql and tried the
queries to see if they work?

>
>> Did you restore a dump from a version 10 onto a >version 9.6 machine?
>
> No - as I said, I don’t believe it’s a version issue as its been fine for 2 years.
>
>>
>>> What does:
>>> SHOW lc_collate;
>>
>> en_US.UTF-8
>
>> The above is the same for all the servers?
>
> The upgraded 10 servers are en_GB.UTF_8. The current prod 9.6 is as above
>
>
> Z
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com