bharath gowda created FINERACT-1271:
---------------------------------------
Summary: Migration Script Issues at the time of server
startups(with 2FA enabled)
Key: FINERACT-1271
URL: https://issues.apache.org/jira/browse/FINERACT-1271
Project: Apache Fineract
Issue Type: Bug
Components: Migration Scripts
Reporter: bharath gowda
Have noticed that when we start a server with Fineract 2FA enabled.
1 New flyway scripts with type as 'DELETE' will be added to the Databases
fineract_tenants and fineract_defaults.
which are as follows
1. this is into the schema table of fineract_tenants DB
|6|5|add schema connection
parameters|DELETE|V5__add_schema_connection_parameters.sql|-152366073|root|########|0|1|
2. this is into the schema table of fineract_defaults DB
|379|363|mnote indexing for
performance|DELETE|V363__mnote_indexing_for_performance.sql|829953313|root|30-11-2020
20:34|0|1|
(Note that V5 and V363 scripts are already executed previously with type as
'SQL' and present in the system)
Now, when we restart the server, the system will again try to execute the query
in the scripts 'V363' and 'V5' and it fails as already the update/insert had
happened before. because of this, the server startup will be a failure and we
cannot log in to the application.
Ex : error
Caused by: org.flywaydb.core.internal.sqlscript.FlywaySqlScriptException:
Caused by: org.flywaydb.core.internal.sqlscript.FlywaySqlScriptException:
Migration V5__add_schema_connection_parameters.sql
failed---------------------------------------------------------SQL State :
42S21Error Code : 1060Message : Duplicate column name
'schema_connection_parameters'Location :
sql/migrations/list_db/V5__add_schema_connection_parameters.sql
Kindly add a comment if any additional details/clarifications are required
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
