[ https://issues.apache.org/jira/browse/DERBY-7047?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17013832#comment-17013832 ]
Richard N. Hillegas commented on DERBY-7047: -------------------------------------------- My apologies for not noticing this issue sooner. I can only speculate about what might be causing this problem. Casting exceptions can surface if on-disk structures are out of sync with the current, running code. As a wild guess, I would try re-generating the statistics for that table. See http://db.apache.org/derby/docs/10.14/ref/rrefupdatestatsproc.html > derby classCastException during SELECT statement > ------------------------------------------------ > > Key: DERBY-7047 > URL: https://issues.apache.org/jira/browse/DERBY-7047 > Project: Derby > Issue Type: Bug > Components: SQL, Store > Affects Versions: 10.14.2.0 > Reporter: Yoaz > Priority: Major > > 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) -- This message was sent by Atlassian Jira (v8.3.4#803005)