[
https://issues.apache.org/jira/browse/MARMOTTA-175?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13613194#comment-13613194
]
Raffaele Palmieri commented on MARMOTTA-175:
--------------------------------------------
Ok, in catalina.out I have following lines:
---------------------------------------------------------------------------------------------------------------------------------
10:54:04 AM org.apache.tomcat.jdbc.pool.interceptor.SlowQueryReport
reportFailedQuery
WARNING: Failed Query Report SQL=DELETE FROM triples WHERE deleted = true AND
NOT EXISTS ((SELECT triple_id FROM reasoner_justifications WHERE triple_id =
triples.id) UNION (SELECT triple_id FROM reasoner_just_supp_triples WHERE
triple_id = triples.id) UNION (SELECT triple_id FROM versions_removed WHERE
triple_id = triples.id) UNION (SELECT triple_id FROM versions_added WHERE
triple_id = triples.id)); time=322 ms;
10:54:04.574 WARN - SQL error while executing garbage collection on triples
table: You have an error in your SQL syntax; check the manual that corresponds
to your MySQL server version for the right syntax to use near 'UNION (SELECT
triple_id FROM reasoner_just_supp_triples WHERE triple_id = triple' at line 1
----------------------------------------------------------------------------------------------------------------------------------
>From first log, it seems that query was executed but after gives me that error.
> Garbage collection on triple tables
> -----------------------------------
>
> Key: MARMOTTA-175
> URL: https://issues.apache.org/jira/browse/MARMOTTA-175
> Project: Marmotta
> Issue Type: Bug
> Components: Triple Store
> Affects Versions: 3.1-incubating
> Environment: Centos 6.4 64b - JDK 1.6.0_38 - MySql 5.1.67 - Tomcat
> 7.0.37
> Reporter: Raffaele Palmieri
> Assignee: Sebastian Schaffert
> Priority: Minor
> Labels: garbage, mysql, triplestore
>
> During garbage collection of triple tables in log there is the following line:
> SQL error while executing garbage collection on triples table: You have an
> error in your SQL syntax; check the manual that corresponds to your MySQL
> server version for the right syntax to use near 'UNION (SELECT triple_id FROM
> reasoner_just_supp_triples WHERE triple_id = triple' at line 1
--
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
