Uploaded image for project: 'Infinispan'
  1. Infinispan
  2. ISPN-8749

Sybase Drop Index error

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 9.2.0.Final
    • 9.2.0.CR1
    • Loaders and Stores
    • None

    Description

      ERROR: ISPN008011: Error while creating table; used DDL statement: 'DROP INDEX "test_SYBASE_timestamp_index" ON "test_SYBASE"'
      java.sql.SQLException: For DROP INDEX, must give both the table and the index name, in the form tablename.indexname
      
      	at com.sybase.jdbc4.jdbc.SybConnection.getAllExceptions(SybConnection.java:2780)
      	at com.sybase.jdbc4.jdbc.SybStatement.handleSQLE(SybStatement.java:2665)
      	at com.sybase.jdbc4.jdbc.SybStatement.nextResult(SybStatement.java:295)
      	at com.sybase.jdbc4.jdbc.SybStatement.nextResult(SybStatement.java:272)
      	at com.sybase.jdbc4.jdbc.SybStatement.updateLoop(SybStatement.java:2515)
      	at com.sybase.jdbc4.jdbc.SybStatement.executeUpdate(SybStatement.java:2499)
      	at com.sybase.jdbc4.jdbc.SybStatement.executeUpdate(SybStatement.java:577)
      	at org.infinispan.persistence.jdbc.table.management.AbstractTableManager.executeUpdateSql(AbstractTableManager.java:165)
      	at org.infinispan.persistence.jdbc.table.management.AbstractTableManager.dropTimestampIndex(AbstractTableManager.java:189)
      	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:187)
      	at java.util.ArrayList.forEach(ArrayList.java:1249)
      	at org.infinispan.persistence.manager.PersistenceManagerImpl.stop(PersistenceManagerImpl.java:196)
      	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
      	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      	at java.lang.reflect.Method.invoke(Method.java:498)
      	at org.infinispan.commons.util.SecurityActions.lambda$invokeAccessibly$0(SecurityActions.java:79)
      	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)
      	at org.infinispan.factories.AbstractComponentRegistry.internalStop(AbstractComponentRegistry.java:734)
      	at org.infinispan.factories.AbstractComponentRegistry.stop(AbstractComponentRegistry.java:639)
      	at org.infinispan.factories.ComponentRegistry.stop(ComponentRegistry.java:255)
      	at org.infinispan.cache.impl.CacheImpl.performImmediateShutdown(CacheImpl.java:1008)
      	at org.infinispan.cache.impl.CacheImpl.stop(CacheImpl.java:972)
      	at org.infinispan.cache.impl.AbstractDelegatingCache.stop(AbstractDelegatingCache.java:420)
      	at org.infinispan.manager.DefaultCacheManager.terminate(DefaultCacheManager.java:687)
      	at org.infinispan.manager.DefaultCacheManager.stopCaches(DefaultCacheManager.java:727)
      	at org.infinispan.manager.DefaultCacheManager.stop(DefaultCacheManager.java:704)
      	at org.jboss.set.JdbcWriterFromDbProperties.main(JdbcWriterFromDbProperties.java:42)
      
      Feb 01, 2018 5:44:38 PM org.infinispan.factories.AbstractComponentRegistry lambda$internalStop$7
      WARN: 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)
      	at org.infinispan.factories.AbstractComponentRegistry.internalStop(AbstractComponentRegistry.java:734)
      	at org.infinispan.factories.AbstractComponentRegistry.stop(AbstractComponentRegistry.java:639)
      	at org.infinispan.factories.ComponentRegistry.stop(ComponentRegistry.java:255)
      	at org.infinispan.cache.impl.CacheImpl.performImmediateShutdown(CacheImpl.java:1008)
      	at org.infinispan.cache.impl.CacheImpl.stop(CacheImpl.java:972)
      	at org.infinispan.cache.impl.AbstractDelegatingCache.stop(AbstractDelegatingCache.java:420)
      	at org.infinispan.manager.DefaultCacheManager.terminate(DefaultCacheManager.java:687)
      	at org.infinispan.manager.DefaultCacheManager.stopCaches(DefaultCacheManager.java:727)
      	at org.infinispan.manager.DefaultCacheManager.stop(DefaultCacheManager.java:704)
      	at org.jboss.set.JdbcWriterFromDbProperties.main(JdbcWriterFromDbProperties.java:42)
      Caused by: org.infinispan.persistence.spi.PersistenceException: Exceptions occurred while stopping store
      	at org.infinispan.persistence.jdbc.stringbased.JdbcStringBasedStore.stop(JdbcStringBasedStore.java:167)
      	at org.infinispan.persistence.manager.PersistenceManagerImpl.lambda$stop$1(PersistenceManagerImpl.java:187)
      	at java.util.ArrayList.forEach(ArrayList.java:1249)
      	at org.infinispan.persistence.manager.PersistenceManagerImpl.stop(PersistenceManagerImpl.java:196)
      	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
      	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      	at java.lang.reflect.Method.invoke(Method.java:498)
      	at org.infinispan.commons.util.SecurityActions.lambda$invokeAccessibly$0(SecurityActions.java:79)
      	... 18 more
      Caused by: java.sql.SQLException: For DROP INDEX, must give both the table and the index name, in the form tablename.indexname
      
      	at com.sybase.jdbc4.jdbc.SybConnection.getAllExceptions(SybConnection.java:2780)
      	at com.sybase.jdbc4.jdbc.SybStatement.handleSQLE(SybStatement.java:2665)
      	at com.sybase.jdbc4.jdbc.SybStatement.nextResult(SybStatement.java:295)
      	at com.sybase.jdbc4.jdbc.SybStatement.nextResult(SybStatement.java:272)
      	at com.sybase.jdbc4.jdbc.SybStatement.updateLoop(SybStatement.java:2515)
      	at com.sybase.jdbc4.jdbc.SybStatement.executeUpdate(SybStatement.java:2499)
      	at com.sybase.jdbc4.jdbc.SybStatement.executeUpdate(SybStatement.java:577)
      	at org.infinispan.persistence.jdbc.table.management.AbstractTableManager.executeUpdateSql(AbstractTableManager.java:165)
      	at org.infinispan.persistence.jdbc.table.management.AbstractTableManager.dropTimestampIndex(AbstractTableManager.java:189)
      	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)
      	... 26 more
      

      Attachments

        Activity

          People

            remerson@redhat.com Ryan Emerson
            remerson@redhat.com Ryan Emerson
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: