Hi, We are facing problem with the recreation of existing indexes when hbm2ddl.auto is set to ‘update’. We have tables with millions of data and it is dropping the existing indexes and creating again (which is taking too long to start the server). Blockquote For example: I can see the following…

This behaviour is expected using ddl-auto=update and luckly it’s configurable. Hibernate contains following key: hibernate.schema_update.unique_constraint_strategy where: DROP_RECREATE_QUIETLY: Default option. Attempt to drop, then (re-)create each unique constraint. Ignore any exceptions being t…

Hi, any news on this? Another link: https://stackoverflow.com/questions/60138525/hibernate-mysql57dialect-why-is-it-trying-to-drop-indexes-on-update Of course using hibernate.hbm2ddl.auto=update is not a good idea in production, but I’m creating (flyway-) update-scripts with the help of org.hibern…

@drahkrub Hi. I noticed the mention in your answer. I haven’t been working for Red Hat since March 2019, hence I don’t have the time to answer questions on this forum. You should ping one of the Hibernate ORM core developers. Cheers!

@vlad Many thanks for your message! And sorry to hear that - bad for Red Hat for sure and hopefully no problem for you. You’ve done a great work - keep it up!

ping @gbadner - do you know the reason for the re-creation of unique indexes? . . .

Hi. We are having exact same issue with recreating only one (of many) unique index every time we run spring boot app with hibernate.hbm2ddl.auto=update property set. We are using Hibernate 5.3.10.Final with PostgreSQLDialect.

Thanks for the reply @BeardOverflow . Shouldn’t its default option be RECREATE_QUIETLY? As it won’t modify the DB unnecessarily. Not sure why the default value is dropping the unique indexes first and then create. Anyway, Thanks :slightly_smiling_face: it clarifies my question.

Hbm2ddl.auto=update recreating existing indexes after drop

Hibernate ORM

drahkrub July 6, 2020, 2:26pm 8

ping @sebersole - do you know the reason for the re-creation of unique indexes? Or does it make more sense to open a jira ticket right away?

Topic		Replies	Views
Unable to create unique index Hibernate ORM	1	141	December 5, 2024
Why my order of execute is wrong? Hibernate ORM	5	7350	November 16, 2018
Hibernate tries to drop existing index Hibernate ORM	0	419	March 17, 2020
Hibernate 5 hbm2ddl.auto=update doesn't work Hibernate ORM	2	4469	November 7, 2018
Hibernate 5.2.14 ddl update tries to recreate tables in Oracle Hibernate ORM	10	7383	June 12, 2018

Hbm2ddl.auto=update recreating existing indexes after drop

Related topics