db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Torsten Heftrich-Zoth (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-2074) Several times exception from derby implementation was thrown (were unable to eproduce and check if it caused by any our work)
Date Tue, 16 Jun 2009 09:51:07 GMT

    [ https://issues.apache.org/jira/browse/DERBY-2074?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12720021#action_12720021
] 

Torsten Heftrich-Zoth commented on DERBY-2074:
----------------------------------------------

We experience this error on some installations at our customers. The error occurs only directly
after starting the software during initialization. Problem is that it's not always reproducible,
only about every third startup. Now I am able to reproduce it on a test system at our site
as well. Is there a possibility for me to activate some logging or using a debug version of
derby to shed some light on the problem?  The error also occurs with one database only. This
DB has a size of about 100MB. The statement that is causing the problem is always the same.
It is joining two large tables, but the output of the statement would be no row at all. Currently
we are using 10.5.1.1, but we had the same error with 10.3.

> Several times exception from derby implementation was thrown (were unable to eproduce
and check if it caused by any our work)
> -----------------------------------------------------------------------------------------------------------------------------
>
>                 Key: DERBY-2074
>                 URL: https://issues.apache.org/jira/browse/DERBY-2074
>             Project: Derby
>          Issue Type: Bug
>          Components: Store
>    Affects Versions: 10.1.3.1
>         Environment: WinXP Professional, Java 1.5.0_06
>            Reporter: Kovylin Alexandr
>            Priority: Minor
>
> 12:34:45,323 ERROR [pool-1-thread-3] history.helpers.HistoryDataAccessHelper - failed
to read measurements, filter = (fromTime=Mon Nov 06 12:34:00 MSK 2006, toTime=Mon Nov 13 12:34:00
MSK 2006, , properties=2-6-2-value) org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback;
uncategorized SQLException for SQL [SELECT COUNT(DISTINCT sshis.measurement_time) FROM sshis_property_measurement
sshis INNER JOIN sstmp_filter_3 filtertbl ON sshis.property_id = filtertbl.property_id WHERE
sshis.measurement_time >= ? AND sshis.measurement_time < ?]; SQL state [XJ001]; error
code [0]; Java exception:':
>  java.lang.NullPointerException'.; nested exception is
> org.apache.derby.impl.jdbc.EmbedSQLException: Java exception: ': java.lang.NullPointerException'.
> java.lang.NullPointerException
>         at java.util.Hashtable.put(Unknown Source)
>         at org.apache.derby.impl.store.access.RAMAccessManager.registerAccessMethod(Unknown
Source)
>         at org.apache.derby.impl.store.access.RAMAccessManager.findMethodFactoryByImpl(Unknown
Source)
>         at org.apache.derby.impl.store.access.RAMTransaction.createSort(UnknownSource)
>         at org.apache.derby.impl.sql.execute.DistinctScalarAggregateResultSet.loadSorter(Unknown
Source)
>         at org.apache.derby.impl.sql.execute.DistinctScalarAggregateResultSet.openCore(Unknown
Source)
>         at org.apache.derby.impl.sql.execute.ProjectRestrictResultSet.openCore(Unknown
Source)
>         at org.apache.derby.impl.sql.execute.BasicNoPutResultSetImpl.open(Unknown Source)
>         at org.apache.derby.impl.sql.GenericPreparedStatement.execute(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.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:535)
>         at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:476)
>         at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:528)
>         at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:561)
>         at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:579)
>         at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:589)
>         at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:619)
>         at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:629)
>         at org.springframework.jdbc.core.JdbcTemplate.queryForInt(JdbcTemplate.java:656)
>         at com.meshnetics.wsn.ctrl.dispatcher.services.history.helpers.MeasurementsSaveGetHelper.getMeasurements(MeasurementsSaveGetHelper.java:81)
>         at com.meshnetics.wsn.ctrl.dispatcher.services.history.helpers.HistoryDataAccessHelper$7.doInTransaction(HistoryDataAccessHelper.java:315)
>         at com.meshnetics.wsn.ctrl.dispatcher.services.history.helpers.HistoryDataAccessHelper$7.doInTransaction(HistoryDataAccessHelper.java:314)
>         at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:117)
>         at com.meshnetics.wsn.ctrl.dispatcher.services.history.helpers.HistoryDataAccessHelper.getMeasurements(HistoryDataAccessHelper.java:313)
>         at com.meshnetics.wsn.ctrl.dispatcher.services.history.asyncread.MeasurementsReadTask.executeTask(MeasurementsReadTask.java:127)
>         at com.meshnetics.wsn.ctrl.dispatcher.services.history.asyncread.MeasurementsReadTask.run(MeasurementsReadTask.java:97)
>         at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
>         at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
>         at java.util.concurrent.FutureTask.run(Unknown Source)
>         at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
>         at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
>         at java.lang.Thread.run(Unknown Source)

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message