[
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)
