[
https://issues.apache.org/jira/browse/FINERACT-1271?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17242103#comment-17242103
]
Michael Vorburger commented on FINERACT-1271:
---------------------------------------------
[~bgowda] I don't fully understand what's going on here, but FYI the
{{V5__add_schema_connection_parameters.sql}} was added in
https://github.com/apache/fineract/pull/1373 by [~Sugiuro] in FINERACT-1178...
Cédric, would you be interested in having a closer look into the problem that
Bharath is describing here? Bharath, you may need to provide Cédric (if he's
interested to help..) with more details about how he could reliably locally
reproduce the issue you are reporting.
> 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.3.4#803005)
