You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Richard N. Hillegas (Jira)" <ji...@apache.org> on 2020/01/12 18:23:00 UTC
[jira] [Commented] (DERBY-7047) derby classCastException during
SELECT statement
[ 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)