Re: CREATE INDEX CONCURRENTLY: Error: ERROR: canceling statement due to lock timeout

From: Sergei Kornilov <sk(at)zsrv(dot)org>
To: Dmitry E(dot) Oboukhov <unera(at)debian(dot)org>, "pgsql-ru-general(at)postgresql(dot)org" <pgsql-ru-general(at)postgresql(dot)org>
Subject: Re: CREATE INDEX CONCURRENTLY: Error: ERROR: canceling statement due to lock timeout
Date: 2020-04-30 13:20:05
Message-ID: 514541588252560@mail.yandex.ru
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-ru-general

Привет

> Error: ERROR: canceling statement due to lock timeout

Это выводится только при срабатывании настройки lock_timeout.
Поставьте его в set lock_timeout to 0; в этой сессии.

regards, Sergei

In response to

Browse pgsql-ru-general by date

  From Date Subject
Next Message ns 2020-08-19 19:35:10 UPDATE WHERE SELECT по париционированным таблицам
Previous Message Dmitry E. Oboukhov 2020-04-30 12:41:16 CREATE INDEX CONCURRENTLY: Error: ERROR: canceling statement due to lock timeout