citusdata / citusdata/citus

[BUG]alter_old_partitions_set_access_method deadlock

Open
#7,177 2 comments 0 reactions 0 assignees View on GitHub
bug
Dominant language
C
Stars
12.8k
Forks
794
Avg merge
2d 14h
Merged PRs (30d)
31

Description

testdb=# CALL alter_old_partitions_set_access_method(
't_test_base_info', '2023-09-01 00:00:00',
'columnar'
);
NOTICE: converting t_test_base_info_p2023_08_30 with start time 2023-08-30 00:00:00 and end time 2023-08-31 00:00:00
NOTICE: creating a new table for public.t_test_base_info_p2023_08_30
NOTICE: moving the data of public.t_test_base_info_p2023_08_30
ERROR: canceling the transaction since it was involved in a distributed deadlock
CONTEXT: SQL statement "ALTER TABLE IF EXISTS public.t_test_base_info DETACH PARTITION public.t_test_base_info_p2023_08_30;"
SQL statement "SELECT pg_catalog.alter_table_set_access_method(r.partition, new_access_method)"
PL/pgSQL function alter_old_partitions_set_access_method(regclass,timestamp with time zone,name) line 27 at PERFORM

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.