[jira] [Created] (FINERACT-1271) Migration Script Issues at the time of server startups(with 2FA enabled)

["bharath gowda (Jira)" <ji...@apache.org>]

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)