From: | Michael Paquier <michael(at)paquier(dot)xyz> |
---|---|
To: | Postgres hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
Subject: | Concurrent failure in create_am with buildfarm member conchuela |
Date: | 2020-09-04 02:03:45 |
Message-ID: | 20200904020345.GI19499@paquier.xyz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Amit Kapila | 2020-09-04 02:04:47 | Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions |
Previous Message | Michael Paquier | 2020-09-04 01:51:39 | Re: Refactor ReindexStmt and its "concurrent" boolean |