Philip Durbin 🚀 (Jan 24 2024 at 15:05): Philip Durbin 🚀 (Jan 24 2024 at 15:05):Errors like this are normal on mvn docker:run, right?
ERROR: relation "externaltooltype" already exists
STATEMENT: CREATE TABLE EXTERNALTOOLTYPE (ID SERIAL NOT NULL, TYPE VARCHAR(255) NOT NULL, EXTERNALTOOL_ID BIGINT NOT NULL, PRIMARY KEY (ID))
ERROR: relation "index_externaltooltype_externaltool_id" already exists
STATEMENT: CREATE INDEX INDEX_EXTERNALTOOLTYPE_externaltool_id ON EXTERNALTOOLTYPE (externaltool_id)
Screenshot-2024-01-24-at-10.02.58-AM.png
Philip Durbin 🚀 (Jan 24 2024 at 15:15):Here's me trying to reassure @Leonhard Maylein in 2015 that similar errors are normal: https://groups.google.com/g/dataverse-community/c/-ITgVIkxdEY/m/oW1tIVe9CQAJ
Philip Durbin 🚀 (Jan 24 2024 at 15:16):'That is to say, those exceptions are expected. I believe the "CREATE INDEX" and "INSERT INTO SEQUENCE" exceptions are normal as well. I know they scary, but I think they all have to do with the fact that we let Glassfish create database tables when the war file is deployed. I'm not sure how we would avoid this.' (but Payara instead of Glassfish these days)
Philip Durbin 🚀 (Jan 25 2024 at 15:28):As discussed in the container meeting just now, this is unfortunately normal. I'll move this topic out of #containers since it isn't specific to them.
Philip Durbin 🚀 (Feb 08 2024 at 15:20):I'm just mentioning create-tables so I can find this topic again. We just talked about it again in the container meeting: https://docs.google.com/document/d/1yiuwS9Ig4qXnQeN1utPt75MUko6M_wRLHIfrCWQM_ZQ/edit?usp=sharing
Oliver Bertuch (Feb 08 2024 at 15:26):This topic was mentioned during the CT WG call today again. There might be an easier fix than we expected to create that baseline before we shut down the "create-tables" JPA setting: https://documentation.red-gate.com/fd/baseline-migrations-184127465.html
Philip Durbin 🚀 (Feb 08 2024 at 15:30):Huh... baseline migrations. Yes, this sounds like what we need. Thanks!
Philip Durbin 🚀 (Feb 08 2024 at 15:30):@Juan Pablo Tosca Villanueva check this out ^^
Philip Durbin 🚀 (Feb 08 2024 at 15:30):"Over the lifetime of a project, many database objects may be created and destroyed across many migrations which leaves behind a lengthy history of migrations that need to be applied in order to bring a new environment up to speed.
Instead, you might wish to add a single, cumulative migration that represents the state of your database after all of those migrations have been applied without disrupting existing environments.
Flyway gives you a way to achieve this using Baseline Migrations."
Oliver Bertuch (Feb 08 2024 at 15:41):JIm thinks this is a Teams/Enterprise feature...
Oliver Bertuch (Feb 08 2024 at 15:42):I'd say we should create a little test project and try if we can apply such migrations if we figure out how to create them
Oliver Bertuch (Feb 08 2024 at 15:42):There might be a chance that the creation is simplified by using a Teams license
Philip Durbin 🚀 (Feb 08 2024 at 15:43):Sure, sounds like a good experiment. Bummer if it's truly a proprietary feature. I love open source.
Oliver Bertuch (Feb 08 2024 at 15:43):But maybe the community version can still apply them... These migrations only apply to new deployments anyway, so it is just a matter of if the community edition will pick up the latest Bx_.sql script
Oliver Bertuch (Feb 08 2024 at 15:44):If all of that does not help: for our use case it might be fine to use the "beforeMigrate" callback!
Oliver Bertuch (Feb 08 2024 at 15:44):All we want is create the tables etc. Our script can check if they are already available
Oliver Bertuch (Feb 08 2024 at 15:45):IMHO this isn't that complicated to do!
Philip Durbin 🚀 (Feb 08 2024 at 15:45):I mean, the use case described above makes total sense. Hundreds of migrations? Time for a new baseline!
Oliver Bertuch (Feb 08 2024 at 15:46):Absolutely!
Oliver Bertuch (Feb 08 2024 at 15:46):All of this is worth a try and shouldn't be too hard to do
Philip Durbin 🚀 (Feb 08 2024 at 15:46):Good tech hours fodder, I'd say.
Oliver Bertuch (Feb 08 2024 at 15:47):Maybe after creating a little sample project to try out what's possible
Philip Durbin 🚀 (Feb 08 2024 at 15:47):We could add a lil' database to https://github.com/IQSS/dataverse-people
Last updated: Oct 30 2025 at 05:14 UTC