Details
-
Bug
-
Status: Open
-
Minor
-
Resolution: Unresolved
-
None
-
None
-
None
Description
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