liquibase.exception.DatabaseException

Error executing SQL DROP INDEX liquibaseb.idx_person_lastname2: Caused By: Error executing SQL DROP INDEX liquibaseb.idx_person_lastname2: Caused By: ORA-01418: specified index does not exist

Samebug tips0

There are no available Samebug tips for this exception. If you know how to solve this issue, help other users by writing a short tip.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web366

  • via JIRA by Damian Golda, 1 year ago
    Error executing SQL DROP INDEX liquibaseb.idx_person_lastname2: Caused By: Error executing SQL DROP INDEX liquibaseb.idx_person_lastname2: Caused By: ORA-01418: specified index does not exist
  • via JIRA by Damian Golda, 1 year ago
    Error executing SQL DROP INDEX liquibaseb.idx_person_lastname2: Caused By: Error executing SQL DROP INDEX liquibaseb.idx_person_lastname2: Caused By: ORA-01418: specified index does not exist
  • Error executing SQL DROP INDEX `subscription_id` ON `FEEDENTRYSTATUSES`: Cannot drop index 'subscription_id': needed in a foreign key constra\ int: Caused By: Error executing SQL DROP INDEX `subscription_id` ON `FEEDENTRYSTATUSES`: Cannot
  • Stack trace

    • liquibase.exception.DatabaseException: Error executing SQL DROP INDEX liquibaseb.idx_person_lastname2: Caused By: Error executing SQL DROP INDEX liquibaseb.idx_person_lastname2: Caused By: ORA-01418: specified index does not exist at liquibase.changelog.ChangeSet.execute(ChangeSet.java:235) at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:25) at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:39) at liquibase.Liquibase.update(Liquibase.java:112) at liquibase.dbtest.AbstractSimpleChangeLogRunnerTest.runCompleteChangeLog(AbstractSimpleChangeLogRunnerTest.java:128) at liquibase.dbtest.AbstractSimpleChangeLogRunnerTest.testRunChangeLog(AbstractSimpleChangeLogRunnerTest.java:118) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at junit.framework.TestCase.runTest(TestCase.java:164) at junit.framework.TestCase.runBare(TestCase.java:130) at junit.framework.TestResult$1.protect(TestResult.java:110) at junit.framework.TestResult.runProtected(TestResult.java:128) at junit.framework.TestResult.run(TestResult.java:113) at junit.framework.TestCase.run(TestCase.java:120) at junit.framework.TestSuite.runTest(TestSuite.java:228) at junit.framework.TestSuite.run(TestSuite.java:223) at org.junit.internal.runners.OldTestClassRunner.run(OldTestClassRunner.java:35) at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:46) at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:467) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:683) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:390) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:197) Caused by: liquibase.exception.DatabaseException: Error executing SQL DROP INDEX liquibaseb.idx_person_lastname2 at liquibase.executor.core.jdbc.JdbcExecutor.execute(JdbcExecutor.java:58) at liquibase.executor.core.jdbc.JdbcExecutor.execute(JdbcExecutor.java:88) at liquibase.database.AbstractDatabase.execute(AbstractDatabase.java:894) at liquibase.database.AbstractDatabase.executeStatements(AbstractDatabase.java:881) at liquibase.changelog.ChangeSet.execute(ChangeSet.java:211) ... 24 more Caused by: java.sql.SQLException: ORA-01418: specified index does not exist at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207) at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:946) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1160) at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1679) at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1645) at liquibase.executor.core.jdbc.JdbcExecutor$1ExecuteStatementCallback.doInStatement(JdbcExecutor.java:79) at liquibase.executor.core.jdbc.JdbcExecutor.execute(JdbcExecutor.java:51) ... 28 more

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    Unknown user
    Once, 3 months ago
    Unknown user
    Once, 9 months ago
    Unknown user
    Once, 9 months ago
    Unknown user
    Once, 10 months ago
    Unknown user
    Once, 10 months ago
    76 more bugmates