[
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
