You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@marmotta.apache.org by "Sebastian Schaffert (JIRA)" <ji...@apache.org> on 2013/09/10 11:57:51 UTC
[jira] [Resolved] (MARMOTTA-284) Database Error during SPARQL
Update
[ https://issues.apache.org/jira/browse/MARMOTTA-284?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Sebastian Schaffert resolved MARMOTTA-284.
------------------------------------------
Resolution: Fixed
> 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
> Fix For: 3.1-incubating
>
>
> 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
--
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