[MARMOTTA-284] Database Error during SPARQL Update

• Type: Bug
• Status: Closed
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: 3.0-incubating
• Fix Version/s: 3.1-incubating
• Component/s: KiWi Triple Store
• Assignee: Sebastian Schaffert
• Reporter: Jakob Frank
• Created: 21/Aug/13 13:20
• Updated: 03/Oct/13 13:38
• Resolved: 10/Sep/13 09:56

Description

Found this in the logfile (wrong format for the date?):

15:11:29.278 ERROR o.a.m.kiwi.sail.KiWiSailConnection - Could not persist rdf-statement (http://localhost:8080/resource/TeLItTFu http://purl.org/dc/terms/modified "2013-08-21T15:11:19"^^<http://www.w3.org/2001/XMLSchema#dateTime>)
org.postgresql.util.PSQLException: ERROR: insert or update on table "triples" violates foreign key constraint "triples_object_fkey"
Detail: Key (object)=(1711802) is not present in table "nodes".
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2157) ~[postgresql-9.2-1002-jdbc4.jar:na]
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1886) ~[postgresql-9.2-1002-jdbc4.jar:na]
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) ~[postgresql-9.2-1002-jdbc4.jar:na]
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:555) ~[postgresql-9.2-1002-jdbc4.jar:na]
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:417) ~[postgresql-9.2-1002-jdbc4.jar:na]
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:363) ~[postgresql-9.2-1002-jdbc4.jar:na]
at sun.reflect.GeneratedMethodAccessor69.invoke(Unknown Source) ~[na:na]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.6.0_27]
at java.lang.reflect.Method.invoke(Method.java:616) ~[na:1.6.0_27]
at org.apache.tomcat.jdbc.pool.interceptor.AbstractQueryReport$StatementProxy.invoke(AbstractQueryReport.java:235) ~[tomcat-jdbc-7.0.3
7.jar:na]
at sun.proxy.$Proxy130.executeUpdate(Unknown Source) ~[na:na]
at org.apache.marmotta.kiwi.persistence.KiWiConnection.storeTriple(KiWiConnection.java:946) ~[kiwi-triplestore-3.0.0-incubating.jar:3.
0.0-incubating]
at org.apache.marmotta.kiwi.sail.KiWiSailConnection.addStatementInternal(KiWiSailConnection.java:168) [kiwi-triplestore-3.0.0-incubati
ng.jar:3.0.0-incubating]
at org.apache.marmotta.kiwi.sail.KiWiSailConnection.addStatementInternal(KiWiSailConnection.java:114) [kiwi-triplestore-3.0.0-incubati
ng.jar:3.0.0-incubating]
at org.openrdf.sail.helpers.SailConnectionBase.addStatement(SailConnectionBase.java:441) [sesame-sail-api-2.7.0-beta2.jar:na]
at org.openrdf.sail.helpers.SailConnectionBase.endUpdate(SailConnectionBase.java:548) [sesame-sail-api-2.7.0-beta2.jar:na]
at org.openrdf.sail.helpers.SailConnectionWrapper.endUpdate(SailConnectionWrapper.java:169) [sesame-sail-api-2.7.0-beta2.jar:na]
at org.openrdf.sail.helpers.SailConnectionWrapper.endUpdate(SailConnectionWrapper.java:169) [sesame-sail-api-2.7.0-beta2.jar:na]
at org.openrdf.repository.sail.helpers.SailUpdateExecutor.executeUpdate(SailUpdateExecutor.java:157) [sesame-repository-sail-2.7.0-bet
a2.jar:na]
at org.openrdf.repository.sail.SailUpdate.execute(SailUpdate.java:91) [sesame-repository-sail-2.7.0-beta2.jar:na]
at org.apache.marmotta.platform.sparql.services.sparql.SparqlServiceImpl.update(SparqlServiceImpl.java:290) [marmotta-sparql-3.0.0-inc
ubating.jar:3.0.0-incubating]
at org.apache.marmotta.platform.sparql.services.sparql.SparqlServiceImpl$Proxy$$$_WeldClientProxy.update(SparqlServiceImpl$Proxy$$$_WeldClientProxy.java) [marmotta-sparql-3.0.0-incubating.jar:3.0.0-incubating]
at org.apache.marmotta.platform.sparql.webservices.SparqlWebService.updatePostDirectly(SparqlWebService.java:405) [marmotta-sparql-3.0.0-incubating.jar:3.0.0-incubating]
at org.apache.marmotta.platform.sparql.webservices.SparqlWebService$Proxy$$$_WeldClientProxy.updatePostDirectly(SparqlWebService$Proxy$$$_WeldClientProxy.java) [marmotta-sparql-3.0.0-incubating.jar:3.0.0-incubating]
at sun.reflect.GeneratedMethodAccessor153.invoke(Unknown Source) ~[na:na]
...
15:11:29.676 WARN o.openrdf.repository.sail.SailUpdate - exception during update execution:
org.openrdf.sail.SailException: database error while storing statement
at org.apache.marmotta.kiwi.sail.KiWiSailConnection.addStatementInternal(KiWiSailConnection.java:187) ~[kiwi-triplestore-3.0.0-incubating.jar:3.0.0-incubating]
at org.apache.marmotta.kiwi.sail.KiWiSailConnection.addStatementInternal(KiWiSailConnection.java:114) ~[kiwi-triplestore-3.0.0-incubating.jar:3.0.0-incubating]
at org.openrdf.sail.helpers.SailConnectionBase.addStatement(SailConnectionBase.java:441) ~[sesame-sail-api-2.7.0-beta2.jar:na]
at org.openrdf.sail.helpers.SailConnectionBase.endUpdate(SailConnectionBase.java:548) ~[sesame-sail-api-2.7.0-beta2.jar:na]
at org.openrdf.sail.helpers.SailConnectionWrapper.endUpdate(SailConnectionWrapper.java:169) ~[sesame-sail-api-2.7.0-beta2.jar:na]
at org.openrdf.sail.helpers.SailConnectionWrapper.endUpdate(SailConnectionWrapper.java:169) ~[sesame-sail-api-2.7.0-beta2.jar:na]
at org.openrdf.repository.sail.helpers.SailUpdateExecutor.executeUpdate(SailUpdateExecutor.java:157) ~[sesame-repository-sail-2.7.0-beta2.jar:na]
at org.openrdf.repository.sail.SailUpdate.execute(SailUpdate.java:91) ~[sesame-repository-sail-2.7.0-beta2.jar:na]
at org.apache.marmotta.platform.sparql.services.sparql.SparqlServiceImpl.update(SparqlServiceImpl.java:290) [marmotta-sparql-3.0.0-incubating.jar:3.0.0-incubating]
at org.apache.marmotta.platform.sparql.services.sparql.SparqlServiceImpl$Proxy$$$_WeldClientProxy.update(SparqlServiceImpl$Proxy$$$_WeldClientProxy.java) [marmotta-sparql-3.0.0-incubating.jar:3.0.0-incubating]
at org.apache.marmotta.platform.sparql.webservices.SparqlWebService.updatePostDirectly(SparqlWebService.java:405) [marmotta-sparql-3.0.0-incubating.jar:3.0.0-incubating]
at org.apache.marmotta.platform.sparql.webservices.SparqlWebService$Proxy$$$_WeldClientProxy.updatePostDirectly(SparqlWebService$Proxy$$$_WeldClientProxy.java) [marmotta-sparql-3.0.0-incubating.jar:3.0.0-incubating]
at sun.reflect.GeneratedMethodAccessor153.invoke(Unknown Source) ~[na:na]
...
Caused by: org.postgresql.util.PSQLException: ERROR: insert or update on table "triples" violates foreign key constraint "triples_object_fkey"
Detail: Key (object)=(1711802) is not present in table "nodes".
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2157) ~[postgresql-9.2-1002-jdbc4.jar:na]
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1886) ~[postgresql-9.2-1002-jdbc4.jar:na]
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) ~[postgresql-9.2-1002-jdbc4.jar:na]
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:555) ~[postgresql-9.2-1002-jdbc4.jar:na]
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:417) ~[postgresql-9.2-1002-jdbc4.jar:na]
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:363) ~[postgresql-9.2-1002-jdbc4.jar:na]
at sun.reflect.GeneratedMethodAccessor69.invoke(Unknown Source) ~[na:na]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.6.0_27]
at java.lang.reflect.Method.invoke(Method.java:616) ~[na:1.6.0_27]
at org.apache.tomcat.jdbc.pool.interceptor.AbstractQueryReport$StatementProxy.invoke(AbstractQueryReport.java:235) ~[tomcat-jdbc-7.0.37.jar:na]
at sun.proxy.$Proxy130.executeUpdate(Unknown Source) ~[na:na]
at org.apache.marmotta.kiwi.persistence.KiWiConnection.storeTriple(KiWiConnection.java:946) ~[kiwi-triplestore-3.0.0-incubating.jar:3.0.0-incubating]
at org.apache.marmotta.kiwi.sail.KiWiSailConnection.addStatementInternal(KiWiSailConnection.java:168) ~[kiwi-triplestore-3.0.0-incubating.jar:3.0.0-incubating]
... 70 common frames omitted