[MARMOTTA-68] LDCache with DBpedia causes resource leakage

• Type: Bug
• Status: Closed
• Priority: Blocker
• Resolution: Fixed
• Affects Version/s: 2.6
• Fix Version/s: 2.6
• Component/s: KiWi Triple Store, LDCache
• Assignee: Sebastian Schaffert
• Reporter: Jakob Frank
• Created: 11/Feb/13 16:24
• Updated: 01/Mar/13 16:57
• Resolved: 11/Feb/13 19:54

Description

Lucy-Demo causes serious errors with LDCache:

• Database error (maybe because of a literal that could not be persisted: wrong/invalid type?)
• Resource leakage (c3po-Connection Pool is blocking)

(try lucy-demo step by step - will fail after core creation)

17:09:29.772 WARN - [Rio error] '6266109739761216' is not a valid value for datatype http://www.w3.org/2001/XMLSchema#int (104, 104)
17:09:30.022 WARN - [Rio error] '7087689151009' is not a valid value for datatype http://www.w3.org/2001/XMLSchema#int (113, 101)
17:15:14.889 ERROR - Could not persist rdf-statement (http://dbpedia.org/resource/Foundation_(novel) http://www.w3.org/1999/02/22-rdf-syntax-ns#type http://umbel.org/umbel/rc/Book_CW)
org.h2.jdbc.JdbcSQLException: Referential integrity constraint violation: "CONSTRAINT_EBA: PUBLIC.TRIPLES FOREIGN KEY(OBJECT) REFERENCES PUBLIC.NODES(ID) (74)"; SQL statement:
INSERT INTO triples (id,subject,predicate,object,context,inferred,createdAt) VALUES (?,?,?,?,?,?,?) [23506-170]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:329) ~[h2-1.3.170.jar:1.3.170]
at org.h2.message.DbException.get(DbException.java:169) ~[h2-1.3.170.jar:1.3.170]
at org.h2.message.DbException.get(DbException.java:146) ~[h2-1.3.170.jar:1.3.170]
at org.h2.constraint.ConstraintReferential.checkRowOwnTable(ConstraintReferential.java:361) ~[h2-1.3.170.jar:1.3.170]
at org.h2.constraint.ConstraintReferential.checkRow(ConstraintReferential.java:303) ~[h2-1.3.170.jar:1.3.170]
at org.h2.table.Table.fireConstraints(Table.java:870) ~[h2-1.3.170.jar:1.3.170]
at org.h2.table.Table.fireAfterRow(Table.java:887) ~[h2-1.3.170.jar:1.3.170]
at org.h2.command.dml.Insert.insertRows(Insert.java:126) ~[h2-1.3.170.jar:1.3.170]
at org.h2.command.dml.Insert.update(Insert.java:84) ~[h2-1.3.170.jar:1.3.170]
at org.h2.command.CommandContainer.update(CommandContainer.java:75) ~[h2-1.3.170.jar:1.3.170]
at org.h2.command.Command.executeUpdate(Command.java:230) ~[h2-1.3.170.jar:1.3.170]
at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:156) ~[h2-1.3.170.jar:1.3.170]
at org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:142) ~[h2-1.3.170.jar:1.3.170]
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105) ~[c3p0-0.9.1.2.jar:0.9.1.2]
at org.apache.marmotta.kiwi.persistence.KiWiConnection.storeTriple(KiWiConnection.java:897) ~[classes/:na]
at org.apache.marmotta.kiwi.sail.KiWiSailConnection.addStatementInternal(KiWiSailConnection.java:177) [classes/:na]
at org.apache.marmotta.kiwi.sail.KiWiSailConnection.addStatementInternal(KiWiSailConnection.java:111) [classes/:na]
at org.openrdf.sail.helpers.SailConnectionBase.addStatement(SailConnectionBase.java:418) [sesame-sail-api-2.7.0-beta1.jar:na]
at org.openrdf.sail.helpers.SailConnectionWrapper.addStatement(SailConnectionWrapper.java:127) [sesame-sail-api-2.7.0-beta1.jar:na]
at org.openrdf.sail.helpers.SailConnectionWrapper.addStatement(SailConnectionWrapper.java:127) [sesame-sail-api-2.7.0-beta1.jar:na]
at org.apache.marmotta.kiwi.contextaware.ContextAwareSailConnection.addStatement(ContextAwareSailConnection.java:50) ~[classes/:na]
at org.openrdf.repository.sail.SailRepositoryConnection.addWithoutCommit(SailRepositoryConnection.java:270) ~[sesame-repository-sail-2.7.0-beta1.jar:na]
at org.openrdf.repository.base.RepositoryConnectionBase.addWithoutCommit(RepositoryConnectionBase.java:631) ~[sesame-repository-api-2.7.0-beta1.jar:na]
at org.openrdf.repository.base.RepositoryConnectionBase.add(RepositoryConnectionBase.java:528) ~[sesame-repository-api-2.7.0-beta1.jar:na]
at org.apache.marmotta.ldcache.services.LDCache.refreshResource(LDCache.java:197) ~[classes/:na]
at org.apache.marmotta.ldcache.sail.KiWiLinkedDataSailConnection.getStatements(KiWiLinkedDataSailConnection.java:61) ~[classes/:na]
at org.openrdf.repository.sail.SailRepositoryConnection.getStatements(SailRepositoryConnection.java:204) ~[sesame-repository-sail-2.7.0-beta1.jar:na]
at at.newmedialab.ldpath.backend.sesame.AbstractSesameBackend.listObjectsInternal(AbstractSesameBackend.java:251) ~[classes/:na]
at at.newmedialab.ldpath.backend.sesame.SesameConnectionBackend.listObjects(SesameConnectionBackend.java:41) ~[classes/:na]
at at.newmedialab.ldpath.backend.sesame.SesameConnectionBackend.listObjects(SesameConnectionBackend.java:13) ~[classes/:na]
at at.newmedialab.ldpath.model.selectors.PropertySelector.select(PropertySelector.java:58) ~[ldpath-core-2.6.0-SNAPSHOT.jar:na]
at at.newmedialab.ldpath.model.selectors.TestingSelector.select(TestingSelector.java:69) ~[ldpath-core-2.6.0-SNAPSHOT.jar:na]
at at.newmedialab.ldpath.model.selectors.PathSelector.select(PathSelector.java:71) ~[ldpath-core-2.6.0-SNAPSHOT.jar:na]
at at.newmedialab.ldpath.model.fields.FieldMapping.getValues(FieldMapping.java:124) ~[ldpath-core-2.6.0-SNAPSHOT.jar:na]
at at.newmedialab.lmf.search.services.indexing.SolrIndexingServiceImpl.indexResource(SolrIndexingServiceImpl.java:536) ~[classes/:na]
at at.newmedialab.lmf.search.services.indexing.SolrIndexingServiceImpl.access$900(SolrIndexingServiceImpl.java:65) ~[classes/:na]
at at.newmedialab.lmf.search.services.indexing.SolrIndexingServiceImpl$SolrIndexer.run(SolrIndexingServiceImpl.java:688) ~[classes/:na]