[infinispan-issues] [JBoss JIRA] (ISPN-9041) Drop Index fails on Oracle DBs

[Pedro Ruivo (JIRA)]

     [ https://issues.jboss.org/browse/ISPN-9041?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Pedro Ruivo updated ISPN-9041:
------------------------------
        Status: Resolved  (was: Pull Request Sent)
    Resolution: Done


> Drop Index fails on Oracle DBs
> ------------------------------
>
>                 Key: ISPN-9041
>                 URL: https://issues.jboss.org/browse/ISPN-9041
>             Project: Infinispan
>          Issue Type: Bug
>          Components: Loaders and Stores
>    Affects Versions: 9.2.1.Final
>            Reporter: Ryan Emerson
>            Assignee: Ryan Emerson
>             Fix For: 9.2.2.Final
>
>
> Drop index fails with:
> {code}
> 15:15:16,217 ERROR (main) [OracleTableManager] ISPN008011: Error while creating table; used DDL statement: 'DROP INDEX "IDX_test_ORACLE11" ON "test_ORACLE11"'
> java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended
> 	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)
> 	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
> 	at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837)
> 	at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445)
> 	at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)
> 	at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523)
> 	at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193)
> 	at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:999)15:15:16,708 DEBUG (main) [JdbcStringBasedStore] Exception while stopping
> org.infinispan.persistence.spi.PersistenceException: java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended
> 	at org.infinispan.persistence.jdbc.table.management.AbstractTableManager.executeUpdateSql(AbstractTableManager.java:168)
> 	at org.infinispan.persistence.jdbc.table.management.AbstractTableManager.dropTimestampIndex(AbstractTableManager.java:192)
> 	at org.infinispan.persistence.jdbc.table.management.AbstractTableManager.dropTable(AbstractTableManager.java:175)
> 	at org.infinispan.persistence.jdbc.table.management.AbstractTableManager.stop(AbstractTableManager.java:77)
> 	at org.infinispan.persistence.jdbc.stringbased.JdbcStringBasedStore.stop(JdbcStringBasedStore.java:145)
> 	at org.infinispan.persistence.manager.PersistenceManagerImpl.lambda$stop$1(PersistenceManagerImpl.java:195)
> 	at java.util.ArrayList.forEach(ArrayList.java:1249)
> 	at org.infinispan.persistence.manager.PersistenceManagerImpl.stop(PersistenceManagerImpl.java:204)15:15:16,710 WARN  (main) [ComponentRegistry] ISPN000189: While stopping a cache or cache manager, one of its components failed to stop
> org.infinispan.commons.CacheException: Unable to invoke method public void org.infinispan.persistence.manager.PersistenceManagerImpl.stop() on object of type PersistenceManagerImpl
> 	at org.infinispan.commons.util.SecurityActions.lambda$invokeAccessibly$0(SecurityActions.java:83)
> 	at org.infinispan.commons.util.SecurityActions.doPrivileged(SecurityActions.java:71)
> 	at org.infinispan.commons.util.SecurityActions.invokeAccessibly(SecurityActions.java:76)
> 	at org.infinispan.commons.util.ReflectionUtil.invokeAccessibly(ReflectionUtil.java:185)
> 	at org.infinispan.factories.AbstractComponentRegistry$PrioritizedMethod.invoke(AbstractComponentRegistry.java:968)
> 	at org.infinispan.factories.AbstractComponentRegistry.lambda$internalStop$7(AbstractComponentRegistry.java:741)
> 	at org.infinispan.factories.SecurityActions.lambda$run$1(SecurityActions.java:72)
> 	at org.infinispan.security.Security.doPrivileged(Security.java:76)
> 	at org.infinispan.factories.SecurityActions.run(SecurityActions.java:71)
> {code}



--
This message was sent by Atlassian JIRA
(v7.5.0#75005)