[ https://issues.apache.org/jira/browse/FINERACT-1271?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17242582#comment-17242582 ]
Cedric Khin commented on FINERACT-1271: --------------------------------------- I am very confused about this issue to be honest...I'd indeed need more details about how to reproduce the problem Do you think it could be a problem on how I deployed the `{{V5__add_schema_connection_parameters.sql}}` script ? > 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)