Postgres Pro
Downloads
Home   >   mailing lists

Re: Avoiding deadlock errors in CREATE INDEX CONCURRENTLY - Mailing list pgsql-hackers

From Goel, Dhruv
Subject Re: Avoiding deadlock errors in CREATE INDEX CONCURRENTLY
Date
Msg-id 9BA3CF6C-4448-4413-A125-18A29FDB759B@amazon.com
Whole thread Raw
In response to Re: Avoiding deadlock errors in CREATE INDEX CONCURRENTLY  (Thomas Munro <thomas.munro@gmail.com>)
Responses Re: Avoiding deadlock errors in CREATE INDEX CONCURRENTLY
List pgsql-hackers
Tree view
Hi,

Thank you Thomas.

On Jul 7, 2019, at 3:15 PM, Thomas Munro <thomas.munro@gmail.com> wrote:

On Mon, Jul 8, 2019 at 9:51 AM Thomas Munro <thomas.munro@gmail.com> wrote:
I noticed that check-world passed several times with this patch
applied, but the most recent CI run failed in multiple-cic:

+error in steps s2i s1i: ERROR:  cache lookup failed for index 26303

https://travis-ci.org/postgresql-cfbot/postgresql/builds/555472214

And in another run, this time on Windows, create_index failed:

https://ci.appveyor.com/project/postgresql-cfbot/postgresql/build/1.0.46455

--
Thomas Munro
https://enterprisedb.com
I have attached the revised patch. I ran check-world multiple times on my machine and it seems to succeed now. Do you mind kicking-off the CI build with the latest patch?
Attachment

pgsql-hackers by date:

Previous
From: Alexander Korotkov
Date:
Subject: Re: [PATCH] Incremental sort (was: PoC: Partial sort)
Next
From: Alexander Korotkov
Date:
Subject: Re: [PATCH] Incremental sort (was: PoC: Partial sort)