You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@marmotta.apache.org by "Jakob Frank (JIRA)" <ji...@apache.org> on 2013/08/21 15:21:51 UTC
[jira] [Created] (MARMOTTA-284) Database Error during SPARQL Update
Jakob Frank created MARMOTTA-284:
------------------------------------
Summary: Database Error during SPARQL Update
Key: MARMOTTA-284
URL: https://issues.apache.org/jira/browse/MARMOTTA-284
Project: Marmotta
Issue Type: Bug
Components: Triple Store
Affects Versions: 3.0-incubating
Reporter: Jakob Frank
Assignee: Sebastian Schaffert
Priority: Critical
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://p
url.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
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira