Duplicate column name 'DELETE_TS_NN'

I use Jmix to help my client to develop an App. The app can start without any problem in my local env and my DEV server.

When my client starts the App, an error as follows appears.
image

Jmix: 1.2.3
Database: MySQL 8.0.26
Add on added.

  • Data Tool
  • Quartz

My solution at the moment is to disable liquibase and generate the SQL scripts according to my database and send the scripts to the client.

1 Like

Look into DATABASECHANGELOG table on the production server and check what changelogs were executed.

Now we have separate the liquibase changelogs into a separate repository. The changelogs were generated from ab existing jmix database.

It is very likely to be caused by the MySQL being case-sensitive. We met others issues related to MySQL being case-sensitive and after we recreated the databases, all the issues have gone. As now we are using an approach of separating the liquibase into a repository. I am not sure if the database were case-insensitive, we may not have met the error when starting the Jmix application.