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/03/15 09:58:12 UTC
[jira] [Commented] (MARMOTTA-152) SQL error while executing garbage
collection on triples table
[ https://issues.apache.org/jira/browse/MARMOTTA-152?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13603242#comment-13603242 ]
Sebastian Schaffert commented on MARMOTTA-152:
----------------------------------------------
Do you have a stack trace? Actually there should be code that takes care of this, i.e. the garbage collector should not delete a triple that is still referenced :)
> SQL error while executing garbage collection on triples table
> -------------------------------------------------------------
>
> Key: MARMOTTA-152
> URL: https://issues.apache.org/jira/browse/MARMOTTA-152
> Project: Marmotta
> Issue Type: Bug
> Components: Triple Store
> Affects Versions: 3.0-incubating
> Environment: Version: 3.0.0-incubating-SNAPSHOT
> Build Date: Do, 14 Mrz 2013 14:57:21 MEZ
> Revision ID: git:ad4f9c
> Reporter: Jakob Frank
> Assignee: Sebastian Schaffert
> Original Estimate: 4h
> Remaining Estimate: 4h
>
> The following warning is reported every hour in the log:
> Mar 15, 2013 5:10:58 AM org.apache.tomcat.jdbc.pool.interceptor.SlowQueryReport reportFailedQuery
> WARNING: Failed Query Report SQL=DELETE FROM triples WHERE deleted = true; time=90 ms;
> 05:10:58.042 WARN - SQL error while executing garbage collection on triples table: ERROR: update or delete on table "triples" violates foreign key constraint "versions_added_triple_id_fkey" on table "versions_added"
> Detail: Key (id)=(5) is still referenced from table "versions_added".
--
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