[BUG]alter_old_partitions_set_access_method deadlock
- 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
Assessment
This issue has not been assessed yet.