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

["Adam Saghy (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/FINERACT-1271?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Adam Saghy closed FINERACT-1271.
--------------------------------
    Resolution: Won't Fix

> 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
>            Priority: Minor
>
> 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.20.10#820010)