[JBoss JIRA] (ISPN-8749) Sybase Drop Index error
by Ryan Emerson (JIRA)
[ https://issues.jboss.org/browse/ISPN-8749?page=com.atlassian.jira.plugin.... ]
Ryan Emerson updated ISPN-8749:
-------------------------------
Status: Pull Request Sent (was: Open)
Git Pull Request: https://github.com/infinispan/infinispan/pull/5730
> Sybase Drop Index error
> -----------------------
>
> Key: ISPN-8749
> URL: https://issues.jboss.org/browse/ISPN-8749
> Project: Infinispan
> Issue …
[View More]Type: Bug
> Components: Loaders and Stores
> Affects Versions: 9.2.0.CR1
> Reporter: Ryan Emerson
> Assignee: Ryan Emerson
> Fix For: 9.2.0.Final
>
>
> {code}
> 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
> {code}
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
[View Less]
7 years, 1 month
[JBoss JIRA] (ISPN-8741) ClusteredLockSplitBrainTest fails randomly
by Katia Aresti (JIRA)
[ https://issues.jboss.org/browse/ISPN-8741?page=com.atlassian.jira.plugin.... ]
Katia Aresti updated ISPN-8741:
-------------------------------
Description:
When it works
====
node A acquires the lock
Split brain of [A] [B, C, D]
Meanwhile, node B tries to acquire the lock, which is not free, so the request goes to the pending queue of B.
With the view change listener, B calls unlock for A.
The listener of B is notified that the lock is released.
Retries for B
It works, and A can't …
[View More]do anything else because it's not in the majority partition.
When it fails
====
node A acquires the lock
Split brain of [A] [B, C, D]
Meanwhile, node B tries to acquire the lock, which is not free, so the request goes to the pending queue of B.
With the view change listener, B calls unlock for A.
The listener of B is notified that the lock is released.
Retries for B
It fails, because it says that actually the lock is still with locked by A in node D, but it is available in Node B and C.
Another unlock is retried for Node D, and this works, and still tries to unlock B and C, which fail because now thy are locked by B.
This gets on the limbo and the request is expired by the scheduler.
> ClusteredLockSplitBrainTest fails randomly
> ------------------------------------------
>
> Key: ISPN-8741
> URL: https://issues.jboss.org/browse/ISPN-8741
> Project: Infinispan
> Issue Type: Bug
> Components: Clustered Locks
> Affects Versions: 9.2.0.CR1
> Reporter: Katia Aresti
> Assignee: Katia Aresti
>
> When it works
> ====
> node A acquires the lock
> Split brain of [A] [B, C, D]
> Meanwhile, node B tries to acquire the lock, which is not free, so the request goes to the pending queue of B.
> With the view change listener, B calls unlock for A.
> The listener of B is notified that the lock is released.
> Retries for B
> It works, and A can't do anything else because it's not in the majority partition.
> When it fails
> ====
> node A acquires the lock
> Split brain of [A] [B, C, D]
> Meanwhile, node B tries to acquire the lock, which is not free, so the request goes to the pending queue of B.
> With the view change listener, B calls unlock for A.
> The listener of B is notified that the lock is released.
> Retries for B
> It fails, because it says that actually the lock is still with locked by A in node D, but it is available in Node B and C.
> Another unlock is retried for Node D, and this works, and still tries to unlock B and C, which fail because now thy are locked by B.
> This gets on the limbo and the request is expired by the scheduler.
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
[View Less]
7 years, 1 month