- Notifications
You must be signed in to change notification settings - Fork67
Closed
Labels
Description
Problem description
Добрый день.
При попытке сделать partition_table_concurrently очередной таблице, получаю
SELECT partition_table_concurrently ('swmanagement.sessions_history');ERROR: cannot start ConcurrentPartWorkerDETAIL: 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