Re:
| От | Vladimir Ryabtsev |
|---|---|
| Тема | Re: |
| Дата | |
| Msg-id | CAMqTPq=KcrkzYqQCcMvry_sm+w7ms8TsyRqc1n5hujWTpgRKSA@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: (Peter Geoghegan <pg@bowt.ie>) |
| Ответы |
Re:
|
| Список | pgsql-bugs |
Peter, thank you for you response.
bt_index_check() shows this:
ERROR: item order invariant violated for index "vocabulary_phrase_key"
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.
вт, 24 сент. 2019 г. в 14:04, Peter Geoghegan <pg@bowt.ie>:
>
> On Tue, Sep 24, 2019 at 1:55 PM Vladimir Ryabtsev <greatvovan@gmail.com> wrote:
> I would try running contrib/amcheck, which should be able to confirm
> index corruption, and give you a specific complaint. You may then be
> able to inspect the exact index page with the problem using
> contrib/pageinspect. Something like this ought to do it on Postgres
> 10:
>
> CREATE EXTENSION IF NOT EXISTS amcheck
> SELECT bt_index_check('vocabulary_phrase_key');
>
SQL state: XX002
--
--
Vladimir
вт, 24 сент. 2019 г. в 14:04, Peter Geoghegan <pg@bowt.ie>:
>
> On Tue, Sep 24, 2019 at 1:55 PM Vladimir Ryabtsev <greatvovan@gmail.com> wrote:
> I would try running contrib/amcheck, which should be able to confirm
> index corruption, and give you a specific complaint. You may then be
> able to inspect the exact index page with the problem using
> contrib/pageinspect. Something like this ought to do it on Postgres
> 10:
>
> CREATE EXTENSION IF NOT EXISTS amcheck
> SELECT bt_index_check('vocabulary_phrase_key');
>
В списке pgsql-bugs по дате отправления: