Closed
Description
Problem description
Добрый день.
При попытке сделать partition_table_concurrently очередной таблице, получаю
SELECT partition_table_concurrently ('swmanagement.sessions_history');
ERROR: cannot start ConcurrentPartWorker
DETAIL: table is being partitioned now
До этого две другие таблицы успешно прошли пененос данных родительской таблицы.
Таблица сегментирована месяц обратно и ничего в фоне не бежит....
Сделал различные выборки из pathman таблиц:
# select * from pathman_config_params ;
partrel | enable_parent | auto | init_callback | spawn_using_bgw
------------------------------------+---------------+------+--------------------------------+-----------------
swmanagement.sessions_history | t | t | public.pathman_callback(jsonb) | f
...
(8 rows)
# select * from pathman_config;
partrel | expr | parttype | range_interval | cooked_expr
------------------------------------+--------------+----------+----------------+---------------------------------------------------------------------------------------------------------------------------
swmanagement.sessions_history | started_at | 2 | 7 days | {VAR :varno 1 :varattno 16 :vartype 1114 :vartypmod -1 :varcollid 0 :varlevelsup 0 :varnoold 1 :varoattno 16 :location 8}
...
(8 rows)
# select * from pathman_concurrent_part_tasks;
userid | pid | dbid | relid | processed | status
--------+-----+------+-------+-----------+--------
(0 rows)
# select * from pathman_cache_stats;
context | size | used | entries
--------------------------+------+------+---------
maintenance | | | 0
partition dispatch cache | | | 8
partition parents cache | | | 0
partition bounds cache | | | 0
(4 rows)
Environment
extname | extowner | extnamespace | extrelocatable | extversion | extconfig | extcondition
--------------------+----------+--------------+----------------+------------+-----------------+--------------
plpgsql | 10 | 11 | f | 1.0 | |
pg_stat_statements | 10 | 2200 | t | 1.3 | |
postgres_fdw | 10 | 2200 | t | 1.0 | |
pgcrypto | 10 | 2200 | t | 1.2 | |
pg_cron | 10 | 2200 | f | 1.0 | {350179} | {""}
pg_pathman | 10 | 2200 | f | 1.4 | {350199,350210} | {"",""}
PostgreSQL 9.5.10 on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 4.8.4-2ubuntu1~14.04.3) 4.8.4, 64-bit
10409