alibaba / alibaba/druid

Jboss7连Oracle11g数据库,开启PScache配置,执行quartz就会报错数组越界错误

Open
#2,003 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
Java
Stars
28.2k
Forks
8.6k
PR merge metrics
No merged PRs in 30d

Description

Jboss7连Oracle11g数据库,开启PScache配置,执行quartz就会报错数组越界错误,帮忙看看
22:30:45,850 严重 [org.quartz.core.ErrorLogger] (scheduler_QuartzSchedulerThread) An error occurred while scanning for the next triggers to fire.: org.quartz.JobPersistenceException: Couldn't acquire next trigger: Error [See nested exception: java.sql.SQLException: Error]
at org.quartz.impl.jdbcjobstore.JobStoreSupport.acquireNextTrigger(JobStoreSupport.java:2840) [org.quartz_2.1.5.jar:2.1.5]
at org.quartz.impl.jdbcjobstore.JobStoreSupport$41.execute(JobStoreSupport.java:2755) [org.quartz_2.1.5.jar:2.1.5]
at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3811) [org.quartz_2.1.5.jar:2.1.5]
at org.quartz.impl.jdbcjobstore.JobStoreSupport.acquireNextTriggers(JobStoreSupport.java:2751) [org.quartz_2.1.5.jar:2.1.5]
at org.quartz.core.QuartzSchedulerThread.run(QuartzSchedulerThread.java:264) [org.quartz_2.1.5.jar:2.1.5]
Caused by: java.sql.SQLException: Error
at com.alibaba.druid.pool.DruidDataSource.handleConnectionException(DruidDataSource.java:1399)
at com.alibaba.druid.pool.DruidPooledConnection.handleException(DruidPooledConnection.java:136)
at com.alibaba.druid.pool.DruidPooledStatement.checkException(DruidPooledStatement.java:71)
at com.alibaba.druid.pool.DruidPooledPreparedStatement.executeQuery(DruidPooledPreparedStatement.java:239)
at com.ls.pf.base.common.persistence.manager.WrapperStatement.executeQuery(WrapperStatement.java:256) [com.ls.pf.base.common.persistence_1.0.0.jar:]
at org.quartz.impl.jdbcjobstore.StdJDBCDelegate.selectTriggerToAcquire(StdJDBCDelegate.java:2571) [org.quartz_2.1.5.jar:2.1.5]
at org.quartz.impl.jdbcjobstore.JobStoreSupport.acquireNextTrigger(JobStoreSupport.java:2781) [org.quartz_2.1.5.jar:2.1.5]
... 4 more
Caused by: java.lang.ArrayIndexOutOfBoundsException: 9
at oracle.jdbc.driver.T4CVarcharAccessor.saveDataFromOldDefineBuffers(T4CVarcharAccessor.java:358)
at oracle.jdbc.driver.T4CPreparedStatement.saveDefineBuffersIfRequired(T4CPreparedStatement.java:541)
at oracle.jdbc.driver.OracleStatement.prepareAccessors(OracleStatement.java:971)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1122)
at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:959)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1234)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3417)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3461)
at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_executeQuery(FilterChainImpl.java:2830)
at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_executeQuery(FilterEventAdapter.java:467)
at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_executeQuery(FilterChainImpl.java:2827)
at com.alibaba.druid.proxy.jdbc.PreparedStatementProxyImpl.executeQuery(PreparedStatementProxyImpl.java:182)
at com.alibaba.druid.pool.DruidPooledPreparedStatement.executeQuery(DruidPooledPreparedStatement.java:228)

Contributor guide

Open the contributing guide

Research direction

Start with the stack-trace entry points org.quartz.impl.jdbcjobstore.StdJDBCDelegate.selectTriggerToAcquire and com.ls.pf.base.common.persistence.manager.WrapperStatement.executeQuery, then inspect the Oracle JDBC and Druid calls around the ArrayIndexOutOfBoundsException. Reproduce with JBoss7, Oracle11g, PScache enabled, and Quartz; done means trigger scanning no longer raises the reported exception.

Written by the indexing model from the issue text.

Assessment

Tech stack
java
Domain
database
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.