Re: problem about reindex

Поиск
Список
Период
Сортировка
От Julien Rouhaud
Тема Re: problem about reindex
Дата
Msg-id CAOBaU_YgN52=LjUBTxGpsYUSF-Pceoz6tWPycj9gbZTp_UR_-Q@mail.gmail.com
обсуждение исходный текст
Ответ на problem about reindex  (liam saffioti <liam.saffiotti@gmail.com>)
Ответы Re: problem about reindex  (liam saffioti <liam.saffiotti@gmail.com>)
Список pgsql-admin
Hi,

On Wed, Sep 22, 2021 at 7:19 PM liam saffioti <liam.saffiotti@gmail.com> wrote:
>
> I'm using PostgreSQL 12.7 on RHEL 8.4. I have a table that has 3132 rows. I faced an interesting case when I run this
query.
>
> select * from enterprise.private_room where name = 'mannheis';
>  id | name | user_id | create_time | sub_package_id | password | tenant_id
> ----+------+---------+-------------+----------------+----------+-----------
> (0 rows)
>
> But the table has this row:
>
> select * from enterprise.private_room where lower(name) = 'mannheis';
>
>  id   |        name         |               user_id                |        create_time         | sub_package_id |
password| tenant_id
 
>
-------+---------------------+--------------------------------------+----------------------------+----------------+----------+-----------
>  67182 | mannheis             | f4e14cbe-f8e2-4c04-85cf-30271cc08526 | 2020-06-15 14:35:51     |         101361 |
    |         3
 
>
> I got the same result with this query : select * from enterprise.private_room where trim(name) = 'mannheis';
>
> After doing reindex the table, the problem was solved. But I don't understand why this problem occurs.

It means that your index was corrupted, and your REINDEX fixed it.
Given that it's an index on a collatable datatype, one reason for the
initial corruption would be an upgrade of your operating system
library providing the collation (glibc or icu, depending on your
index) without a subsequent REINDEX of all your indexes depending on a
collatable datatype.  Have you upgraded your system's collation
library since the initial creation of this index?



В списке pgsql-admin по дате отправления:

Предыдущее
От: liam saffioti
Дата:
Сообщение: problem about reindex
Следующее
От: liam saffioti
Дата:
Сообщение: Re: problem about reindex