[
https://issues.apache.org/jira/browse/FINERACT-1930?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Hitesh Prajapati updated FINERACT-1930:
---------------------------------------
Description:
The migration script 0016_changed_unique_constraint_of_ref_no.xml failed while
migrating from fineract 1.6.0 to 1.8.4
=====
This is due to mismatch of unique constraint name.
This is because the fineract 1.6.0 schema has the unique constraint in
m_savings_account_transaction table with name 'transaction_ref_no' as per
V391__add_transaction_ref_column.sql.
But migration script - 0016_changed_unique_constraint_of_ref_no.xml - is using
the name 'ref_no'
{code:java}
// code placeholder
... 97 common frames omitted
Caused by: org.springframework.beans.factory.BeanCreationException: Error
creating bean with name 'tenantDatabaseUpgradeService' defined in URL
[jar:file:/D:/Work/HerringBank/source/fineract_herringbank/fineract-provider/build/libs/fineract-provider-1.8.5-f41a1210.jar!/BOOT-INF/classes!/org/apache/fineract/infrastructure/core/service/migration/TenantDatabaseUpgradeService.class]:
Invocation of init method failed; nested exception is
java.lang.RuntimeException: Error while migrating the schema
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1804)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:620)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542)
at
org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335)
at
org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234)
at
org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:333)
at
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208)
at
org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:322)
at
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208)
at
org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:330)
... 105 common frames omitted
Caused by: java.lang.RuntimeException: Error while migrating the schema
at
org.apache.fineract.infrastructure.core.service.migration.TenantDatabaseUpgradeService.afterPropertiesSet(TenantDatabaseUpgradeService.java:82)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1863)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1800)
... 114 common frames omitted
Caused by: liquibase.exception.LiquibaseException:
liquibase.exception.MigrationFailedException: Migration failed for change set
db/changelog/tenant/parts/0016_changed_unique_constraint_of_ref_no.xml::1::fineract:
Reason: liquibase.exception.DatabaseException: (conn=11) Can't DROP INDEX
`ref_no`; check that it exists [Failed SQL: (1091) ALTER TABLE
fineract_test.m_savings_account_transaction DROP KEY ref_no]
at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:126)
at liquibase.Liquibase.lambda$null$0(Liquibase.java:262)
at liquibase.Scope.lambda$child$0(Scope.java:180)
at liquibase.Scope.child(Scope.java:189)
at liquibase.Scope.child(Scope.java:179)
at liquibase.Scope.child(Scope.java:158)
at liquibase.Scope.child(Scope.java:243)
at liquibase.Liquibase.lambda$update$1(Liquibase.java:261)
at liquibase.Scope.lambda$child$0(Scope.java:180)
at liquibase.Scope.child(Scope.java:189)
at liquibase.Scope.child(Scope.java:179)
at liquibase.Scope.child(Scope.java:158)
at liquibase.Liquibase.runInScope(Liquibase.java:2400)
at liquibase.Liquibase.update(Liquibase.java:208)
at liquibase.Liquibase.update(Liquibase.java:194)
at
liquibase.integration.spring.SpringLiquibase.performUpdate(SpringLiquibase.java:314)
at
liquibase.integration.spring.SpringLiquibase.afterPropertiesSet(SpringLiquibase.java:269)
at
org.apache.fineract.infrastructure.core.service.migration.TenantDatabaseUpgradeService.upgradeIndividualTenant(TenantDatabaseUpgradeService.java:129)
at
org.apache.fineract.infrastructure.core.service.migration.TenantDatabaseUpgradeService.upgradeIndividualTenants(TenantDatabaseUpgradeService.java:114)
at
org.apache.fineract.infrastructure.core.service.migration.TenantDatabaseUpgradeService.afterPropertiesSet(TenantDatabaseUpgradeService.java:80)
... 116 common frames omitted
Caused by: liquibase.exception.MigrationFailedException: Migration failed for
change set
db/changelog/tenant/parts/0016_changed_unique_constraint_of_ref_no.xml::1::fineract:
Reason: liquibase.exception.DatabaseException: (conn=11) Can't DROP INDEX
`ref_no`; check that it exists [Failed SQL: (1091) ALTER TABLE
fineract_test.m_savings_account_transaction DROP KEY ref_no]
at liquibase.changelog.ChangeSet.execute(ChangeSet.java:701)
at
liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:56)
at
liquibase.changelog.ChangeLogIterator$2.lambda$null$0(ChangeLogIterator.java:113)
at liquibase.Scope.lambda$child$0(Scope.java:180)
at liquibase.Scope.child(Scope.java:189)
at liquibase.Scope.child(Scope.java:179)
at liquibase.Scope.child(Scope.java:158)
at
liquibase.changelog.ChangeLogIterator$2.lambda$run$1(ChangeLogIterator.java:112)
at liquibase.Scope.lambda$child$0(Scope.java:180)
at liquibase.Scope.child(Scope.java:189)
at liquibase.Scope.child(Scope.java:179)
at liquibase.Scope.child(Scope.java:158)
at liquibase.Scope.child(Scope.java:243)
at
liquibase.changelog.ChangeLogIterator$2.run(ChangeLogIterator.java:93)
at liquibase.Scope.lambda$child$0(Scope.java:180)
at liquibase.Scope.child(Scope.java:189)
at liquibase.Scope.child(Scope.java:179)
at liquibase.Scope.child(Scope.java:158)
at liquibase.Scope.child(Scope.java:243)
at liquibase.Scope.child(Scope.java:247)
at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:65)
... 135 common frames omitted
Caused by: liquibase.exception.DatabaseException: (conn=11) Can't DROP INDEX
`ref_no`; check that it exists [Failed SQL: (1091) ALTER TABLE
fineract_test.m_savings_account_transaction DROP KEY ref_no]
at
liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:434)
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:77)
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:160)
at
liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1304)
at
liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1286)
at liquibase.changelog.ChangeSet.execute(ChangeSet.java:666)
... 155 common frames omitted
Caused by: java.sql.SQLSyntaxErrorException: (conn=11) Can't DROP INDEX
`ref_no`; check that it exists
at
org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:62)
at
org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:158)
at
org.mariadb.jdbc.MariaDbStatement.executeExceptionEpilogue(MariaDbStatement.java:262)
at
org.mariadb.jdbc.MariaDbStatement.executeInternal(MariaDbStatement.java:362)
at org.mariadb.jdbc.MariaDbStatement.execute(MariaDbStatement.java:500)
at com.zaxxer.hikari.pool.ProxyStatement.execute(ProxyStatement.java:94)
at
com.zaxxer.hikari.pool.HikariProxyStatement.execute(HikariProxyStatement.java)
at
liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:430)
... 160 common frames omitted
Caused by: org.mariadb.jdbc.internal.util.exceptions.MariaDbSqlException: Can't
DROP INDEX `ref_no`; check that it exists
at
org.mariadb.jdbc.internal.util.exceptions.MariaDbSqlException.of(MariaDbSqlException.java:34)
at
org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.exceptionWithQuery(AbstractQueryProtocol.java:194)
at
org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:262)
at
org.mariadb.jdbc.MariaDbStatement.executeInternal(MariaDbStatement.java:356)
... 164 common frames omitted
Caused by: java.sql.SQLException: Can't DROP INDEX `ref_no`; check that it
exists
at
org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readErrorPacket(AbstractQueryProtocol.java:1695)
at
org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1557)
at
org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:1520)
at
org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:256)
... 165 common frames omitted {code}
was:
The migration script 0016_changed_unique_constraint_of_ref_no.xml failed while
migrating from fineract 1.6.0 to 1.8.4
=====
This is due to mismatch of unique constraint name.
In V391__add_transaction_ref_column.sql, the unique constraint defined is
'transaction_ref_no'
But migration script - 0016_changed_unique_constraint_of_ref_no.xml - is using
the name 'ref_no'
{code:java}
// code placeholder
... 97 common frames omitted
Caused by: org.springframework.beans.factory.BeanCreationException: Error
creating bean with name 'tenantDatabaseUpgradeService' defined in URL
[jar:file:/D:/Work/HerringBank/source/fineract_herringbank/fineract-provider/build/libs/fineract-provider-1.8.5-f41a1210.jar!/BOOT-INF/classes!/org/apache/fineract/infrastructure/core/service/migration/TenantDatabaseUpgradeService.class]:
Invocation of init method failed; nested exception is
java.lang.RuntimeException: Error while migrating the schema
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1804)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:620)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542)
at
org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335)
at
org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234)
at
org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:333)
at
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208)
at
org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:322)
at
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208)
at
org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:330)
... 105 common frames omitted
Caused by: java.lang.RuntimeException: Error while migrating the schema
at
org.apache.fineract.infrastructure.core.service.migration.TenantDatabaseUpgradeService.afterPropertiesSet(TenantDatabaseUpgradeService.java:82)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1863)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1800)
... 114 common frames omitted
Caused by: liquibase.exception.LiquibaseException:
liquibase.exception.MigrationFailedException: Migration failed for change set
db/changelog/tenant/parts/0016_changed_unique_constraint_of_ref_no.xml::1::fineract:
Reason: liquibase.exception.DatabaseException: (conn=11) Can't DROP INDEX
`ref_no`; check that it exists [Failed SQL: (1091) ALTER TABLE
fineract_test.m_savings_account_transaction DROP KEY ref_no]
at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:126)
at liquibase.Liquibase.lambda$null$0(Liquibase.java:262)
at liquibase.Scope.lambda$child$0(Scope.java:180)
at liquibase.Scope.child(Scope.java:189)
at liquibase.Scope.child(Scope.java:179)
at liquibase.Scope.child(Scope.java:158)
at liquibase.Scope.child(Scope.java:243)
at liquibase.Liquibase.lambda$update$1(Liquibase.java:261)
at liquibase.Scope.lambda$child$0(Scope.java:180)
at liquibase.Scope.child(Scope.java:189)
at liquibase.Scope.child(Scope.java:179)
at liquibase.Scope.child(Scope.java:158)
at liquibase.Liquibase.runInScope(Liquibase.java:2400)
at liquibase.Liquibase.update(Liquibase.java:208)
at liquibase.Liquibase.update(Liquibase.java:194)
at
liquibase.integration.spring.SpringLiquibase.performUpdate(SpringLiquibase.java:314)
at
liquibase.integration.spring.SpringLiquibase.afterPropertiesSet(SpringLiquibase.java:269)
at
org.apache.fineract.infrastructure.core.service.migration.TenantDatabaseUpgradeService.upgradeIndividualTenant(TenantDatabaseUpgradeService.java:129)
at
org.apache.fineract.infrastructure.core.service.migration.TenantDatabaseUpgradeService.upgradeIndividualTenants(TenantDatabaseUpgradeService.java:114)
at
org.apache.fineract.infrastructure.core.service.migration.TenantDatabaseUpgradeService.afterPropertiesSet(TenantDatabaseUpgradeService.java:80)
... 116 common frames omitted
Caused by: liquibase.exception.MigrationFailedException: Migration failed for
change set
db/changelog/tenant/parts/0016_changed_unique_constraint_of_ref_no.xml::1::fineract:
Reason: liquibase.exception.DatabaseException: (conn=11) Can't DROP INDEX
`ref_no`; check that it exists [Failed SQL: (1091) ALTER TABLE
fineract_test.m_savings_account_transaction DROP KEY ref_no]
at liquibase.changelog.ChangeSet.execute(ChangeSet.java:701)
at
liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:56)
at
liquibase.changelog.ChangeLogIterator$2.lambda$null$0(ChangeLogIterator.java:113)
at liquibase.Scope.lambda$child$0(Scope.java:180)
at liquibase.Scope.child(Scope.java:189)
at liquibase.Scope.child(Scope.java:179)
at liquibase.Scope.child(Scope.java:158)
at
liquibase.changelog.ChangeLogIterator$2.lambda$run$1(ChangeLogIterator.java:112)
at liquibase.Scope.lambda$child$0(Scope.java:180)
at liquibase.Scope.child(Scope.java:189)
at liquibase.Scope.child(Scope.java:179)
at liquibase.Scope.child(Scope.java:158)
at liquibase.Scope.child(Scope.java:243)
at
liquibase.changelog.ChangeLogIterator$2.run(ChangeLogIterator.java:93)
at liquibase.Scope.lambda$child$0(Scope.java:180)
at liquibase.Scope.child(Scope.java:189)
at liquibase.Scope.child(Scope.java:179)
at liquibase.Scope.child(Scope.java:158)
at liquibase.Scope.child(Scope.java:243)
at liquibase.Scope.child(Scope.java:247)
at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:65)
... 135 common frames omitted
Caused by: liquibase.exception.DatabaseException: (conn=11) Can't DROP INDEX
`ref_no`; check that it exists [Failed SQL: (1091) ALTER TABLE
fineract_test.m_savings_account_transaction DROP KEY ref_no]
at
liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:434)
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:77)
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:160)
at
liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1304)
at
liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1286)
at liquibase.changelog.ChangeSet.execute(ChangeSet.java:666)
... 155 common frames omitted
Caused by: java.sql.SQLSyntaxErrorException: (conn=11) Can't DROP INDEX
`ref_no`; check that it exists
at
org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:62)
at
org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:158)
at
org.mariadb.jdbc.MariaDbStatement.executeExceptionEpilogue(MariaDbStatement.java:262)
at
org.mariadb.jdbc.MariaDbStatement.executeInternal(MariaDbStatement.java:362)
at org.mariadb.jdbc.MariaDbStatement.execute(MariaDbStatement.java:500)
at com.zaxxer.hikari.pool.ProxyStatement.execute(ProxyStatement.java:94)
at
com.zaxxer.hikari.pool.HikariProxyStatement.execute(HikariProxyStatement.java)
at
liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:430)
... 160 common frames omitted
Caused by: org.mariadb.jdbc.internal.util.exceptions.MariaDbSqlException: Can't
DROP INDEX `ref_no`; check that it exists
at
org.mariadb.jdbc.internal.util.exceptions.MariaDbSqlException.of(MariaDbSqlException.java:34)
at
org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.exceptionWithQuery(AbstractQueryProtocol.java:194)
at
org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:262)
at
org.mariadb.jdbc.MariaDbStatement.executeInternal(MariaDbStatement.java:356)
... 164 common frames omitted
Caused by: java.sql.SQLException: Can't DROP INDEX `ref_no`; check that it
exists
at
org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readErrorPacket(AbstractQueryProtocol.java:1695)
at
org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1557)
at
org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:1520)
at
org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:256)
... 165 common frames omitted {code}
> Migration issue - upgrade from fineract 1.6.0
> ----------------------------------------------
>
> Key: FINERACT-1930
> URL: https://issues.apache.org/jira/browse/FINERACT-1930
> Project: Apache Fineract
> Issue Type: Bug
> Components: Migration Scripts
> Reporter: Hitesh Prajapati
> Priority: Minor
>
> The migration script 0016_changed_unique_constraint_of_ref_no.xml failed
> while migrating from fineract 1.6.0 to 1.8.4
>
> =====
> This is due to mismatch of unique constraint name.
> This is because the fineract 1.6.0 schema has the unique constraint in
> m_savings_account_transaction table with name 'transaction_ref_no' as per
> V391__add_transaction_ref_column.sql.
> But migration script - 0016_changed_unique_constraint_of_ref_no.xml - is
> using the name 'ref_no'
>
> {code:java}
> // code placeholder
> ... 97 common frames omitted
> Caused by: org.springframework.beans.factory.BeanCreationException: Error
> creating bean with name 'tenantDatabaseUpgradeService' defined in URL
> [jar:file:/D:/Work/HerringBank/source/fineract_herringbank/fineract-provider/build/libs/fineract-provider-1.8.5-f41a1210.jar!/BOOT-INF/classes!/org/apache/fineract/infrastructure/core/service/migration/TenantDatabaseUpgradeService.class]:
> Invocation of init method failed; nested exception is
> java.lang.RuntimeException: Error while migrating the schema
> at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1804)
> at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:620)
> at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542)
> at
> org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335)
> at
> org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234)
> at
> org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:333)
> at
> org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208)
> at
> org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:322)
> at
> org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208)
> at
> org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:330)
> ... 105 common frames omitted
> Caused by: java.lang.RuntimeException: Error while migrating the schema
> at
> org.apache.fineract.infrastructure.core.service.migration.TenantDatabaseUpgradeService.afterPropertiesSet(TenantDatabaseUpgradeService.java:82)
> at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1863)
> at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1800)
> ... 114 common frames omitted
> Caused by: liquibase.exception.LiquibaseException:
> liquibase.exception.MigrationFailedException: Migration failed for change set
> db/changelog/tenant/parts/0016_changed_unique_constraint_of_ref_no.xml::1::fineract:
> Reason: liquibase.exception.DatabaseException: (conn=11) Can't DROP
> INDEX `ref_no`; check that it exists [Failed SQL: (1091) ALTER TABLE
> fineract_test.m_savings_account_transaction DROP KEY ref_no]
> at
> liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:126)
> at liquibase.Liquibase.lambda$null$0(Liquibase.java:262)
> at liquibase.Scope.lambda$child$0(Scope.java:180)
> at liquibase.Scope.child(Scope.java:189)
> at liquibase.Scope.child(Scope.java:179)
> at liquibase.Scope.child(Scope.java:158)
> at liquibase.Scope.child(Scope.java:243)
> at liquibase.Liquibase.lambda$update$1(Liquibase.java:261)
> at liquibase.Scope.lambda$child$0(Scope.java:180)
> at liquibase.Scope.child(Scope.java:189)
> at liquibase.Scope.child(Scope.java:179)
> at liquibase.Scope.child(Scope.java:158)
> at liquibase.Liquibase.runInScope(Liquibase.java:2400)
> at liquibase.Liquibase.update(Liquibase.java:208)
> at liquibase.Liquibase.update(Liquibase.java:194)
> at
> liquibase.integration.spring.SpringLiquibase.performUpdate(SpringLiquibase.java:314)
> at
> liquibase.integration.spring.SpringLiquibase.afterPropertiesSet(SpringLiquibase.java:269)
> at
> org.apache.fineract.infrastructure.core.service.migration.TenantDatabaseUpgradeService.upgradeIndividualTenant(TenantDatabaseUpgradeService.java:129)
> at
> org.apache.fineract.infrastructure.core.service.migration.TenantDatabaseUpgradeService.upgradeIndividualTenants(TenantDatabaseUpgradeService.java:114)
> at
> org.apache.fineract.infrastructure.core.service.migration.TenantDatabaseUpgradeService.afterPropertiesSet(TenantDatabaseUpgradeService.java:80)
> ... 116 common frames omitted
> Caused by: liquibase.exception.MigrationFailedException: Migration failed for
> change set
> db/changelog/tenant/parts/0016_changed_unique_constraint_of_ref_no.xml::1::fineract:
> Reason: liquibase.exception.DatabaseException: (conn=11) Can't DROP
> INDEX `ref_no`; check that it exists [Failed SQL: (1091) ALTER TABLE
> fineract_test.m_savings_account_transaction DROP KEY ref_no]
> at liquibase.changelog.ChangeSet.execute(ChangeSet.java:701)
> at
> liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:56)
> at
> liquibase.changelog.ChangeLogIterator$2.lambda$null$0(ChangeLogIterator.java:113)
> at liquibase.Scope.lambda$child$0(Scope.java:180)
> at liquibase.Scope.child(Scope.java:189)
> at liquibase.Scope.child(Scope.java:179)
> at liquibase.Scope.child(Scope.java:158)
> at
> liquibase.changelog.ChangeLogIterator$2.lambda$run$1(ChangeLogIterator.java:112)
> at liquibase.Scope.lambda$child$0(Scope.java:180)
> at liquibase.Scope.child(Scope.java:189)
> at liquibase.Scope.child(Scope.java:179)
> at liquibase.Scope.child(Scope.java:158)
> at liquibase.Scope.child(Scope.java:243)
> at
> liquibase.changelog.ChangeLogIterator$2.run(ChangeLogIterator.java:93)
> at liquibase.Scope.lambda$child$0(Scope.java:180)
> at liquibase.Scope.child(Scope.java:189)
> at liquibase.Scope.child(Scope.java:179)
> at liquibase.Scope.child(Scope.java:158)
> at liquibase.Scope.child(Scope.java:243)
> at liquibase.Scope.child(Scope.java:247)
> at
> liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:65)
> ... 135 common frames omitted
> Caused by: liquibase.exception.DatabaseException: (conn=11) Can't DROP INDEX
> `ref_no`; check that it exists [Failed SQL: (1091) ALTER TABLE
> fineract_test.m_savings_account_transaction DROP KEY ref_no]
> at
> liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:434)
> at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:77)
> at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:160)
> at
> liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1304)
> at
> liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1286)
> at liquibase.changelog.ChangeSet.execute(ChangeSet.java:666)
> ... 155 common frames omitted
> Caused by: java.sql.SQLSyntaxErrorException: (conn=11) Can't DROP INDEX
> `ref_no`; check that it exists
> at
> org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:62)
> at
> org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:158)
> at
> org.mariadb.jdbc.MariaDbStatement.executeExceptionEpilogue(MariaDbStatement.java:262)
> at
> org.mariadb.jdbc.MariaDbStatement.executeInternal(MariaDbStatement.java:362)
> at
> org.mariadb.jdbc.MariaDbStatement.execute(MariaDbStatement.java:500)
> at
> com.zaxxer.hikari.pool.ProxyStatement.execute(ProxyStatement.java:94)
> at
> com.zaxxer.hikari.pool.HikariProxyStatement.execute(HikariProxyStatement.java)
> at
> liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:430)
> ... 160 common frames omitted
> Caused by: org.mariadb.jdbc.internal.util.exceptions.MariaDbSqlException:
> Can't DROP INDEX `ref_no`; check that it exists
> at
> org.mariadb.jdbc.internal.util.exceptions.MariaDbSqlException.of(MariaDbSqlException.java:34)
> at
> org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.exceptionWithQuery(AbstractQueryProtocol.java:194)
> at
> org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:262)
> at
> org.mariadb.jdbc.MariaDbStatement.executeInternal(MariaDbStatement.java:356)
> ... 164 common frames omitted
> Caused by: java.sql.SQLException: Can't DROP INDEX `ref_no`; check that it
> exists
> at
> org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readErrorPacket(AbstractQueryProtocol.java:1695)
> at
> org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1557)
> at
> org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:1520)
> at
> org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:256)
> ... 165 common frames omitted {code}
>
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
