Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-7047

derby classCastException during SELECT statement

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 10.14.2.0
    • Fix Version/s: None
    • Component/s: SQL, Store
    • Labels:
      None
    • Urgency:
      Normal
    • Bug behavior facts:
      Seen in production

      Description

      we use embedded derby for tests and get a ClassCastException during performing a select statement when multiple threads are executing the following statement.

      seems similar to the following ticket:
      https://issues.apache.org/jira/browse/HIVE-16362

      "SELECT * FROM node_props WHERE node_id = ?"

      our Derby jdbc version is : 

      org.apache.derby:10.14.2.0

       following is our SELECT Statement:

      Caused by: java.sql.SQLException: Java exception: 'org.apache.derby.iapi.services.io.FormatableBitSet cannot be cast to org.apache.derby.iapi.store.access.StaticCompiledOpenConglomInfo: java.lang.ClassCastException'.
      at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
      at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
      at org.apache.derby.impl.jdbc.Util.seeNextException(Unknown Source)
      at org.apache.derby.impl.jdbc.Util.javaException(Unknown Source)
      at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
      at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
      at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
      at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
      at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source)
      at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source)
      at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeQuery(Unknown Source)
      at org.jfrog.storage.JdbcHelper.executeSelect(JdbcHelper.java:184)
      at org.jfrog.storage.JdbcHelper.executeSelect(JdbcHelper.java:152)
      at org.artifactory.storage.db.fs.dao.PropertiesDao.getNodeProperties(PropertiesDao.java:85)
      at org.artifactory.storage.db.fs.service.DbPropertiesServiceImpl.loadProperties(DbPropertiesServiceImpl.java:163)

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              yoaz Yoaz
            • Votes:
              2 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated: