From: | Вавржин Игорь <igor(dot)vavrjin(at)gmail(dot)com> |
---|---|
To: | pgsql-ru-general(at)postgresql(dot)org |
Subject: | deadlock при drop index concurrently |
Date: | 2017-03-23 09:45:48 |
Message-ID: | CAHGBwKi2zPt1=6gsYaFArYXnBDZ4cobjg_OLtZu4h4f=aTix5A@mail.gmail.com |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-ru-general |
Вот что видим в логах:
Mar 23 15:45:07 mdb postgres[26481]: [177-1]
user=pgsql,db=geo,client=10.77.255.13 ERROR: deadlock detected
Mar 23 15:45:07 mdb postgres[26481]: [177-2]
user=pgsql,db=geo,client=10.77.255.13 DETAIL: Process 26481 waits for
ShareLock on virtual transaction 8/29343079; blocked by process 15087.
Mar 23 15:45:07 mdb postgres[26481]: [177-3] Process 15087 waits for
AccessExclusiveLock on relation 24694 of database 17701; blocked by process
26481.
Mar 23 15:45:07 mdb postgres[26481]: [177-4] Process 26481: DROP
INDEX CONCURRENTLY IF EXISTS geo_11_2gis_get_route_platform_ids_from_json
Mar 23 15:45:07 mdb postgres[26481]: [177-5]
Mar 23 15:45:07 mdb postgres[26481]: [177-6] Process 15087: LOCK
TABLE geo_11 IN ACCESS EXCLUSIVE MODE
Mar 23 15:45:07 mdb postgres[26481]: [177-7]
user=pgsql,db=geo,client=10.77.255.13 HINT: See server log for query
details.
Mar 23 15:45:07 mdb postgres[26481]: [177-8]
user=pgsql,db=geo,client=10.77.255.13 STATEMENT: DROP INDEX CONCURRENTLY
IF EXISTS geo_11_2gis_get_route_platform_ids_from_json
Mar 23 15:45:07 mdb postgres[26481]: [177-9]
кто-нибудь может объяснить откуда мог взяться при указании конкурентности
дедлок?
версия postgres 9.4.4
--
С уважением,
Вавржин Игорь
From | Date | Subject | |
---|---|---|---|
Next Message | Dmitry E. Oboukhov | 2017-03-23 10:04:34 | сделать ALTER TABLE varchar в TEXT |
Previous Message | Dmitry E. Oboukhov | 2017-03-19 15:00:02 | Re: Re: [pgsql-ru-general] сменить пароли/доступы к БД без даунтайма |