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.

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

Trouble upgrading to 0.4. #648

Closed
Kulturserver opened this issue Aug 30, 2023 · 6 comments
Closed

Trouble upgrading to 0.4. #648

Kulturserver opened this issue Aug 30, 2023 · 6 comments

Comments

@Kulturserver
Copy link

We tried upgrading from 0.3 to 0.4 with the following steps

  • creating a dump of the Postgresql database mailmandb
  • setting the images mailman-web and mailman-core in docker-compose.yaml from Version 0.3 auf Version 0.4:
    image: maxking/mailman-core:0.4
    image: maxking/mailman-web:0.4
  • then updating postgresql: image: postgres:10.1-alpine
  • deleting the directory /opt/mailman/database
  • calling docker-compose up -d the new containers were received and started
  • now the database dump was imported again

Looking at the log of the mailman-core-container, at the end the following error is shown:
sqlalchemy.exc.NoSuchModuleError: Can't load plugin: sqlalchemy.dialects:postgres

What else is there to do? Any help would be appreciated, thanks!

@maxking
Copy link
Owner

maxking commented Aug 30, 2023

Can you update postgres to postgresql in the DATABASE_URL?

With newer versions of sqlalchemy, I think 'postgres' is no longer valid.

@maxking
Copy link
Owner

maxking commented Aug 30, 2023

Actually, that might not be the case. THe newer release will have that issue and it is still not out.

Can you send output of docker images | grep mailman?

@Kulturserver
Copy link
Author

Sorry for the late reply, we didn't have time to try the update again. Here's the output:

REPOSITORY TAG IMAGE ID CREATED SIZE
maxking/mailman-web 0.4 3f0bc6a75e1e 8 months ago 248MB
maxking/mailman-core 0.4 e435fcfc7d03 8 months ago 204MB
maxking/mailman-web 0.3 9ba9d3d7084d 2 years ago 487MB
maxking/mailman-core 0.3 26c920c0094b 2 years ago 178MB
postgres 9.6-alpine aa87de9a5e0f 5 years ago 39.2MB
postgres 10.1-alpine e6c5e6a76255 5 years ago 38.2MB

@jakicoll
Copy link
Contributor

Did you read the section about upgrading to 0.4 in the NEWS.md?

@almereyda
Copy link

Updating the scheme scheme in DATABASE_URL helped us.

Plus the behaviour seen in

disappeared.

@maxking
Copy link
Owner

maxking commented Jun 8, 2024

Closing this as fixed.

@maxking maxking closed this as completed Jun 8, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

4 participants