Skip to content

Partman stops all management operations if a table doesn't exist #47

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Closed
pgporada opened this issue May 20, 2022 · 1 comment · Fixed by #54
Closed

Partman stops all management operations if a table doesn't exist #47

pgporada opened this issue May 20, 2022 · 1 comment · Fixed by #54

Comments

@pgporada
Copy link
Member

pgporada commented May 20, 2022

I detected this after running the alter table and partman startup command in #46.

-- The job identifier is 496805.
May 20 19:55:17 mydb partition-manager[642828]: 2022-05-20 19:55:17,509 - all_configured_tables_are_compatible - ERROR - Cannot proceed: Table orderToAuthz2_new_20220419 ['Unable to read information for orderToAuthz2_new_20220419']
May 20 19:55:17 mydb systemd[1]: partition-manager.service: Succeeded.
-- Subject: Unit succeeded

The partman error text output leads me to believe that partman will fail to perform actually useful operations since this table no longer exists in my database. This could lead to a table overrun issues and we'd have to re-migrate tables again.

@jcjones
Copy link
Collaborator

jcjones commented May 24, 2022

all_configured_tables_are_compatible is only checked for the migrate command, not for maintain, so it should only affect operator-hands-on operations, not automated ones. Still, we should fix this.

jcjones added a commit that referenced this issue May 26, 2022
Fixes #47

We shouldn't abort early if the config isn't perfect, we should operate
on what we can.
jcjones added a commit that referenced this issue May 26, 2022
Fixes #47

We shouldn't abort early if the config isn't perfect, we should operate
on what we can.
jcjones added a commit that referenced this issue May 28, 2022
Fixes #47

We shouldn't abort early if the config isn't perfect, we should operate
on what we can.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
2 participants