Uploaded image for project: 'Red Hat Data Grid'
  1. Red Hat Data Grid
  2. JDG-1564

Multiple issues while testing JDBC library in EAP7 on Sybase 15.7

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major Major
    • JDG 7.2 ER5
    • JDG 7.2 ER3, JDG 7.2 ER4
    • Core
    • None
    • ER5
    • Hide

      Can be provided if requested

      Show
      Can be provided if requested
    • JDG Sprint #10

      Test fails with following exception:

      [java] [0m[33m09:34:10,068 WARN [org.infinispan.factories.ComponentRegistry] (default task-8) 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.eviction.impl.PassivationManagerImpl.passivateAll() throws org.infinispan.persistence.spi.PersistenceException on object of type PassivationManagerImpl
      [java] at org.infinispan.commons.util.ReflectionUtil.invokeAccessibly(ReflectionUtil.java:172)
      ...
      [java] at java.lang.Thread.run(Thread.java:748)
      [java] Caused by: org.infinispan.persistence.spi.PersistenceException: ISPN008034: Error while writing entries in batch to the database:
      [java] at org.infinispan.persistence.jdbc.stringbased.JdbcStringBasedStore.writeBatch(JdbcStringBasedStore.java:224)
      ...
      [java] at org.infinispan.commons.util.ReflectionUtil.invokeAccessibly(ReflectionUtil.java:168)
      [java] ... 157 more
      [java] Caused by: java.sql.SQLException: Error
      [java] at org.jboss.jca.adapters.jdbc.WrappedConnection.checkException(WrappedConnection.java:1972)
      [java] at org.jboss.jca.adapters.jdbc.WrappedStatement.checkException(WrappedStatement.java:1436)
      [java] at org.jboss.jca.adapters.jdbc.WrappedStatement.executeBatch(WrappedStatement.java:1184)
      [java] at org.infinispan.persistence.jdbc.stringbased.JdbcStringBasedStore.writeBatch(JdbcStringBasedStore.java:221)
      [java] ... 175 more
      [java] Suppressed: java.sql.SQLException: JZ0C0: Connection is already closed.
      [java] at com.sybase.jdbc4.jdbc.ErrorMessage.raiseError(ErrorMessage.java:766)
      [java] at com.sybase.jdbc4.jdbc.SybConnection.checkConnection(SybConnection.java:3536)
      [java] at com.sybase.jdbc4.jdbc.SybStatement.close(SybStatement.java:702)
      [java] at com.sybase.jdbc4.jdbc.SybStatement.close(SybStatement.java:685)
      [java] at org.jboss.jca.adapters.jdbc.WrappedStatement.internalClose(WrappedStatement.java:1481)
      [java] at org.jboss.jca.adapters.jdbc.WrappedStatement.close(WrappedStatement.java:178)
      [java] at org.infinispan.persistence.jdbc.stringbased.JdbcStringBasedStore.writeBatch(JdbcStringBasedStore.java:222)
      [java] ... 175 more
      [java] Caused by: java.lang.ClassCastException: java.io.ByteArrayInputStream cannot be cast to com.sybase.jdbc4.jdbc.SybLob
      [java] at com.sybase.jdbc4.tds.TdsParam.prepareForSend(TdsParam.java:230)
      [java] at com.sybase.jdbc4.jdbc.ParamManager.checkParams(ParamManager.java:1180)
      [java] at com.sybase.jdbc4.tds.Tds.sendDynamicExecuteParams(Tds.java:1500)
      [java] at com.sybase.jdbc4.tds.Tds.dynamicExecute(Tds.java:1404)
      [java] at com.sybase.jdbc4.jdbc.SybPreparedStatement.sendQuery(SybPreparedStatement.java:2883)
      [java] at com.sybase.jdbc4.jdbc.SybStatement.sendBatch(SybStatement.java:1923)
      [java] at com.sybase.jdbc4.jdbc.SybStatement.executeBatch(SybStatement.java:1882)
      [java] at com.sybase.jdbc4.jdbc.SybStatement.executeBatch(SybStatement.java:1800)
      [java] at com.sybase.jdbc4.jdbc.SybPreparedStatement.executeBatch(SybPreparedStatement.java:1832)
      [java] at org.jboss.jca.adapters.jdbc.WrappedStatement.executeBatch(WrappedStatement.java:1180)
      [java] ... 176 more

      and eventually is stuck on:

      [java] Feb 15, 2018 9:34:19 AM org.infinispan.manager.DefaultCacheManager getCache
      [java] WARN: ISPN000434: Direct usage of the ___defaultcache name to retrieve the default cache is deprecated
      [java] Feb 15, 2018 9:34:19 AM infinispan.com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource getPoolManager
      [java] INFO: Initializing c3p0 pool... infinispan.com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement -> 3, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionCustomizerClassName -> null, connectionTesterClassName -> infinispan.com.mchange.v2.c3p0.impl.DefaultConnectionTester, contextClassLoaderSource -> caller, dataSourceName -> 1bqozkg9t16p4v6c1ku1xw5|7da635c0, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> com.sybase.jdbc4.jdbc.SybDriver, extensions -> {}, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, forceUseNamedDriverClass -> false, identityToken -> 1bqozkg9t16p4v6c1ku1xw5|7da635c0, idleConnectionTestPeriod -> 0, initialPoolSize -> 3, jdbcUrl -> jdbc:sybase:Tds:sybase-157.hosts.mwqe.eng.bos.redhat.com:5000/dballo11, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 0, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 15, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 3, numHelperThreads -> 3, preferredTestQuery -> null, privilegeSpawnedThreads -> false, properties ->

      {user=******, password=******}

      , propertyCycle -> 0, statementCacheNumDeferredCloseThreads -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, userOverrides -> {}, usesTraditionalReflectiveProxies -> false ]
      [java] Feb 15, 2018 9:34:24 AM org.infinispan.eviction.impl.PassivationManagerImpl passivateAll
      [java] INFO: ISPN000029: Passivating all entries to disk
      Build timed out (after 120 minutes). Marking the build as aborted.

              remerson@redhat.com Ryan Emerson
              zhostasa_jira Zdenek Hostasa (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: