Skip to content

Hourly partman.run_maintenance(); failing. #717

Closed
@Santoshkumar00723

Description

I have 2 schemas (Ex: TEST & TEST1) with different partition tables with same table names. When disabled automatic_maintenance for TEST1 schema tables TEST schema partitions worked as expected.

Post enabling automatic_maintenance for TEST schema it's failing with below error message and partman.run_maintenance(); failing for TEST1 schema tables also.

Could you please let me know what is the change I have to make in part_config or any other changes.

2024-12-06 17:30:18 GMT [380514-2] ERROR: Given parent table not found in system catalogs: test.order_line
CONTEXT: PL/pgSQL function show_partitions(text,text,boolean) line 49 at RAISE
SQL statement "SELECT partition_tablename FROM partman.show_partitions(v_row.parent_table, p_include_default := true) LIMIT 1"
PL/pgSQL function partman.run_maintenance(text,boolean,boolean) line 162 at SQL statement
SQL statement "SELECT partman.run_maintenance('test.order_line', p_jobmon := 't', p_analyze := 'f')"
PL/pgSQL function partman.run_maintenance_proc(integer,boolean,boolean) line 42 at EXECUTE
SQL statement "CALL partman.run_maintenance_proc(p_wait => 0, p_analyze => false, p_jobmon => true)"
DETAIL:
HINT:
2024-12-06 17:30:18 GMT [380514-3] CONTEXT: PL/pgSQL function partman.run_maintenance(text,boolean,boolean) line 437 at RAISE
SQL statement "SELECT partman.run_maintenance('test.order_line', p_jobmon := 't', p_analyze := 'f')"
PL/pgSQL function partman.run_maintenance_proc(integer,boolean,boolean) line 42 at EXECUTE
SQL statement "CALL partman.run_maintenance_proc(p_wait => 0, p_analyze => false, p_jobmon => true)"
2024-12-06 17:30:18 GMT [2881064-16] LOG: background worker "pg_partman background worker" (PID 380514) exited with exit code 1

Metadata

Assignees

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions