Uploaded image for project: 'Apache Fineract'
  1. Apache Fineract
  2. FINERACT-1271

Migration Script Issues at the time of server startups(with 2FA enabled)

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Minor
    • Resolution: Unresolved
    • None
    • None
    • Migration Scripts
    • None

    Description

      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

       

       

      Attachments

        Activity

          People

            Unassigned Unassigned
            bgowda Bharath Gowda
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated: