[
https://issues.apache.org/jira/browse/MARMOTTA-152?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13603247#comment-13603247
]
Sebastian Schaffert commented on MARMOTTA-152:
----------------------------------------------
Actually the query is funny. It should rather look like:
DELETE FROM triples WHERE deleted = true AND NOT EXISTS ((SELECT triple_id FROM
versions_removed WHERE triple_id = triples.id) UNION (SELECT triple_id FROM
versions_added WHERE triple_id = triples.id))
Did you disable versioning after importing triples?
> 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
