[DERBY-7047] derby classCastException during SELECT statement

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 10.14.2.0
• Component/s: SQL, Store
• Urgency: Normal
• Bug behavior facts: Seen in production
• Assignee: Unassigned
• Reporter: Yoaz
• Created: 03/Jul/19 07:39
• Updated: 12/Jan/20 18:22

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)