Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

#3 GenericJDBCException after thesaurus import

open
None
5
2010-05-21
2010-05-21
Anonymous
No

While importing the RVK, I clicked through the overview. After the import finished according to the progress bar, an error popped up, see stacktrace below.

The RVK was imported, afterwards, the database contained 797613 concepts. There are 797612 broader_narrower relations, so that seems to be quite complete. Labels and Notations are also available.

So probably, only the overview functionality was affected by the error, but nevertheless...

Stacktrace:

org.hibernate.exception.GenericJDBCException: could not execute query
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.loader.Loader.doList(Loader.java:2216)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
at org.hibernate.loader.Loader.list(Loader.java:2099)
at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:94)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1569)
at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:283)
at org.semtinel.core.data.hibernate.CoreManagerImpl.getAnnotationSources(CoreManagerImpl.java:222)
at org.semtinel.core.overview.OverviewChildFactory.createKeys(OverviewChildFactory.java:76)
at org.openide.nodes.AsynchChildren.run(AsynchChildren.java:147)
at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572)
at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:997)
Caused by: org.h2.jdbc.JdbcSQLException: Zeitüberschreitung beim Versuch die Tabelle CONCEPTSCHEME zu sperren
Timeout trying to lock table CONCEPTSCHEME; SQL statement:
select this_.id as id13_3_, this_.conceptScheme_id as conceptS3_13_3_, this_.name as name13_3_, conceptsch2_.id as id1_0_, conceptsch2_.topConcept_id as topConcept3_1_0_, conceptsch2_.uri as uri1_0_, conceptimp3_.id as id0_1_, conceptimp3_.conceptScheme_id as conceptS3_0_1_, conceptimp3_.uri as uri0_1_, conceptsch4_.id as id1_2_, conceptsch4_.topConcept_id as topConcept3_1_2_, conceptsch4_.uri as uri1_2_ from AnnotationSource this_ left outer join ConceptScheme conceptsch2_ on this_.conceptScheme_id=conceptsch2_.id left outer join Concept conceptimp3_ on conceptsch2_.topConcept_id=conceptimp3_.id left outer join ConceptScheme conceptsch4_ on conceptimp3_.conceptScheme_id=conceptsch4_.id [50200-107]
at org.h2.message.Message.getSQLException(Message.java:103)
at org.h2.message.Message.getSQLException(Message.java:114)
at org.h2.message.Message.getSQLException(Message.java:77)
at org.h2.table.TableData.doLock(TableData.java:430)
at org.h2.table.TableData.lock(TableData.java:369)
at org.h2.table.TableFilter.lock(TableFilter.java:107)
at org.h2.table.TableFilter.lock(TableFilter.java:109)
at org.h2.command.dml.Select.queryWithoutCache(Select.java:548)
at org.h2.command.dml.Query.query(Query.java:233)
at org.h2.command.CommandContainer.query(CommandContainer.java:81)
at org.h2.command.Command.executeQueryLocal(Command.java:141)
at org.h2.command.Command.executeQuery(Command.java:122)
at org.h2.jdbc.JdbcPreparedStatement.executeQuery(JdbcPreparedStatement.java:96)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1787)
at org.hibernate.loader.Loader.doQuery(Loader.java:674)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
at org.hibernate.loader.Loader.doList(Loader.java:2213)
... 10 more

Discussion

  • Kai Eckert
    Kai Eckert
    2010-05-21

    • assigned_to: nobody --> alexhanschke