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

Removed file format PNG from the database - check python migration script #137

Closed
milanmajchrak opened this issue Apr 8, 2024 · 1 comment

Comments

@milanmajchrak
Copy link
Collaborator

Error:
Flyway migrate wasn't working because of this error:

Message    : ERROR: duplicate key value violates unique constraint "bitstreamformatregistry_short_description_key"
  Detail: Key (short_description)=(PNG) already exists.

Vanilla DSpace add a flyway script where the image/png was updated to PNG V7.6_2023.03.24__Update_PNG_in_bitstream_format_registry.sql and we already have PNG record in the database from the CLARIN-DSpace 5 database, so the DB cannot be updated following the new flyway script.

@milanmajchrak
Copy link
Collaborator Author

This error has occurred only once when we were upgrading from 7.5. to 7.6.1. and there were some data in the database.
It won't happen anymore because the database migrate force command is called before every data import and it prepares the DSpace database with the right image/png shortdescription.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant