Concurrent failure in create_am with buildfarm member conchuela

Started by Michael Paquierover 5 years ago3 messageshackers
Jump to latest
#1Michael Paquier
michael@paquier.xyz

Hi all,

conchuela has just reported the following error:
https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=conchuela&dt=2020-09-03%2023%3A00%3A36

-- Drop access method cascade
 DROP ACCESS METHOD gist2 CASCADE;
 NOTICE:  drop cascades to index grect2ind2
+ERROR:  deadlock detected
+DETAIL:  Process 609175 waits for AccessExclusiveLock on relation 17347 of database 16384; blocked by process 609183.
+Process 609183 waits for RowExclusiveLock on relation 20095 of database 16384; blocked by process 609175.
+HINT:  See server log for query details.

Looking at the logs, 609183 is running an autovacuum analyze:
2020-09-04 01:04:52.895 CEST [609183:6] LOG: automatic analyze of
table "regression.public.tenk2" system usage: CPU: user: 0.03 s,
system: 0.00 s, elapsed: 0.59 s

I have not looked at that stuff much yet.

Thanks,
--
Michael

#2Alvaro Herrera
alvherre@2ndquadrant.com
In reply to: Michael Paquier (#1)
Re: Concurrent failure in create_am with buildfarm member conchuela

Hello,

On 2020-Sep-04, Michael Paquier wrote:

conchuela has just reported the following error:
https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=conchuela&dt=2020-09-03%2023%3A00%3A36

Fixed in d54f99e4154.

Thanks

--
�lvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

#3Michael Paquier
michael@paquier.xyz
In reply to: Alvaro Herrera (#2)
Re: Concurrent failure in create_am with buildfarm member conchuela

On Fri, Sep 04, 2020 at 03:38:32PM -0400, Alvaro Herrera wrote:

Fixed in d54f99e4154.

Yes, thanks. I bumped into the other thread this morning:
/messages/by-id/839004.1599185607@sss.pgh.pa.us
The fix makes sense.
--
Michael