SmartDataAnalytics / jena-sparql-api

A collection of Jena-extensions for hiding SPARQL-complexity from the application layer
Other
57 stars 14 forks source link

cache JDBC connection lost after some time #1

Closed jimkont closed 11 years ago

jimkont commented 11 years ago

I run many queries with the same endpoint and after some time or repeated queries (1-2 hours) I get the following exception

java.lang.RuntimeException: org.h2.jdbc.JdbcSQLException: Connection is broken: "unexpected status 67108864" [90067-158] at org.aksw.jena_sparql_api.cache.extra.CacheCoreH2.lookup(CacheCoreH2.java:193) at org.aksw.jena_sparql_api.cache.extra.CacheCoreExCompressor.lookup(CacheCoreExCompressor.java:44)
at org.aksw.jena_sparql_api.cache.extra.CacheExImpl.lookup(CacheExImpl.java:95) at org.aksw.jena_sparql_api.cache.core.QueryExecutionCacheEx.doCacheResultSet(QueryExecutionCacheEx.java:43) at org.aksw.jena_sparql_api.cache.core.QueryExecutionCacheEx.execSelect(QueryExecutionCacheEx.java:168) at org.aksw.jena_sparql_api.pagination.core.ResultSetPaginated.prefetch(ResultSetPaginated.java:96)
at org.aksw.jena_sparql_api.pagination.core.ResultSetPaginated.prefetch(ResultSetPaginated.java:47)
at org.aksw.commons.collections.PrefetchIterator.preparePrefetch(PrefetchIterator.java:35) at org.aksw.commons.collections.PrefetchIterator.getCurrent(PrefetchIterator.java:51) at org.aksw.commons.collections.PrefetchIterator.hasNext(PrefetchIterator.java:58) at org.aksw.jena_sparql_api.pagination.core.QueryExecutionIterated.execSelect(QueryExecutionIterated.java:78) at org.aksw.databugger.TestExecutor.getCountNumber(TestExecutor.java:78) at org.aksw.databugger.TestExecutor.executeTestsCounts(TestExecutor.java:44) at org.aksw.databugger.Databugger.main(Databugger.java:132) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at org.codehaus.mojo.exec.ExecJavaMojo$1.run(ExecJavaMojo.java:297) at java.lang.Thread.run(Thread.java:724) Caused by: org.h2.jdbc.JdbcSQLException: Connection is broken: "unexpected status 67108864" [90067-158] at org.h2.message.DbException.getJdbcSQLException(DbException.java:329) at org.h2.message.DbException.get(DbException.java:169) at org.h2.message.DbException.get(DbException.java:146) at org.h2.engine.SessionRemote.done(SessionRemote.java:553) at org.h2.command.CommandRemote.executeQuery(CommandRemote.java:151) at org.h2.jdbc.JdbcPreparedStatement.executeQuery(JdbcPreparedStatement.java:96) at org.aksw.jena_sparql_api.cache.extra.SqlUtils.execute(SqlUtils.java:93) at org.aksw.jena_sparql_api.cache.extra.SqlDaoBase.executeQuery(SqlDaoBase.java:100) at org.aksw.jena_sparql_api.cache.extra.CacheCoreH2._lookup(CacheCoreH2.java:203) at org.aksw.jena_sparql_api.cache.extra.CacheCoreH2.lookup(CacheCoreH2.java:191) ... 19 more

jimkont commented 11 years ago

fixed with https://github.com/AKSW/jena-sparql-api/commit/5dda0ac9357b106a2bb1b17d89535cdc0ea2627b