Skip to content
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.

Sign up for GitHub

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

Jump to bottom

Only attempt to create tablespaces if they don't exist #18

Closed
jasonrogena opened this issue Jul 2, 2019 · 1 comment · Fixed by #19
Closed

Only attempt to create tablespaces if they don't exist #18

jasonrogena opened this issue Jul 2, 2019 · 1 comment · Fixed by #19
Assignees
@githengi

Comments

@jasonrogena
Copy link

Avoid creating tablespaces again, if they already exist, to prevent the mybatis migration scripts from failing (not good forcing the scripts to continue if one migration fails).

Since the changelog table is within the opensrp database, while tablespaces live outside this database, we end up in issues if the database is recreated (while the tablespaces still exist).
@jasonrogena
Copy link
Author

This would be a potential issue for deployments that share database servers.

@jasonrogena jasonrogena mentioned this issue Jul 3, 2019
Open
@jasonrogena jasonrogena changed the title Only attempt to crate tablespaces if they don't exist Only attempt to create tablespaces if they don't exist Jul 7, 2019
@githengi githengi mentioned this issue Jul 12, 2019
Merged
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@githengi githengi

Labels
None yet
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

Move table space management from migration scripts opensrp/opensrp-server-configs
2 participants
@jasonrogena @githengi