Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps
 (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <pgsql-ru-general-owner+archive@lists.postgresql.org>)
	id 1jU96v-000690-Eg
	for pgsql-ru-general@arkaria.postgresql.org; Thu, 30 Apr 2020 13:20:17 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.92)
	(envelope-from <pgsql-ru-general-owner+archive@lists.postgresql.org>)
	id 1jU96t-0000Zp-BV
	for pgsql-ru-general@arkaria.postgresql.org; Thu, 30 Apr 2020 13:20:15 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <sk@zsrv.org>)
	id 1jU96t-0000Zi-1b
	for pgsql-ru-general@lists.postgresql.org; Thu, 30 Apr 2020 13:20:15 +0000
Received: from forward500j.mail.yandex.net ([5.45.198.250])
	by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <sk@zsrv.org>)
	id 1jU96p-0005bp-Om
	for pgsql-ru-general@postgresql.org; Thu, 30 Apr 2020 13:20:13 +0000
Received: from mxback1q.mail.yandex.net (mxback1q.mail.yandex.net
 [IPv6:2a02:6b8:c0e:39:0:640:25b3:aea5])
	by forward500j.mail.yandex.net (Yandex) with ESMTP id D63E111C333D;
	Thu, 30 Apr 2020 16:20:06 +0300 (MSK)
Received: from localhost (localhost [::1])
	by mxback1q.mail.yandex.net (mxback/Yandex) with ESMTP id
 twziegjKdc-K6A4xRCm;
	Thu, 30 Apr 2020 16:20:06 +0300
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=zsrv.org; s=mail;
 t=1588252806;
	bh=KRUAEOqTP9byxiWFx+R152xAY9VjL0865R6ifubJ1Kc=;
	h=References:Date:Message-Id:Subject:In-Reply-To:To:From;
	b=LxK7en0bpLbpQ8V9HyN3D7yfeYJEnLI2YbMEmXZ52blU3o1wf1uGJOUHwLtUQh4pv
	 Su79a30CTgpHaa5SWUb8RE6WsWeI56iXtJRgMbTqyG+iZXTmYUTQxtHZjSOGeHLv4H
	 /r2uVCbUq0vMIWOgo52fdSqNFrq37R1A7V4HYSNA=
Authentication-Results: mxback1q.mail.yandex.net; dkim=pass header.i=@zsrv.org
Received: by vla3-6a5326aeb4ee.qloud-c.yandex.net with HTTP;
	Thu, 30 Apr 2020 16:20:05 +0300
From: Sergei Kornilov <sk@zsrv.org>
To: Dmitry E. Oboukhov <unera@debian.org>,
	"pgsql-ru-general@postgresql.org" <pgsql-ru-general@postgresql.org>
In-Reply-To: <60051588250046@mail.yandex.ru>
References: <60051588250046@mail.yandex.ru>
Subject: Re: CREATE INDEX CONCURRENTLY: Error: ERROR:  canceling statement due
 to lock timeout
MIME-Version: 1.0
X-Mailer: Yamail [ http://yandex.ru ] 5.0
Date: Thu, 30 Apr 2020 16:20:05 +0300
Message-Id: <514541588252560@mail.yandex.ru>
Content-Transfer-Encoding: 8bit
Content-Type: text/plain; charset=utf-8
List-Id: <pgsql-ru-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-ru-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-ru-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-ru-general>
Precedence: bulk

Привет

> Error: ERROR: canceling statement due to lock timeout

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

regards, Sergei