[
https://issues.apache.org/jira/browse/TIKA-4100?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17744734#comment-17744734
]
Hudson commented on TIKA-4100:
------------------------------
FAILURE: Integrated in Jenkins build Tika » tika-main-jdk11 #1163 (See
[https://ci-builds.apache.org/job/Tika/job/tika-main-jdk11/1163/])
TIKA-4100 -- prevent apparent infinite loop in update+select queries in
comparison-reports.xml. Improve logging in "Report" mode of tika-eval-app
(#1245) (github:
[https://github.com/apache/tika/commit/4b564b310383d34ed5c6639c24cf1d70286ac08e])
* (edit) tika-eval/tika-eval-app/src/main/resources/comparison-reports.xml
* (edit)
tika-eval/tika-eval-app/src/main/java/org/apache/tika/eval/app/reports/ResultsReporter.java
* (edit)
tika-eval/tika-eval-app/src/main/java/org/apache/tika/eval/app/reports/Report.java
> Work-around for ~infinite loop in one of the reports in tika-eval Report tool
> -----------------------------------------------------------------------------
>
> Key: TIKA-4100
> URL: https://issues.apache.org/jira/browse/TIKA-4100
> Project: Tika
> Issue Type: Bug
> Reporter: Tim Allison
> Priority: Minor
> Fix For: 2.8.1
>
>
> For some reason, this query is now hanging forever in 2.6.0-2.8.0 on the new
> regression set of files.
>
> {noformat}
> update exceptions_compared ec set
> exc_cnt_a = (
> select count(1) as cnt
> from exceptions_a ea
> join profiles_a pa on ea.id=pa.id
> join profiles_b pb on pb.id=pa.id
> join mimes ma on pa.mime_id=ma.mime_id
> join mimes mb on pb.mime_id=mb.mime_id
> where ma.mime_id= ec.mime_id_a and mb.mime_id=ec.mime_id_b
> group by ma.mime_id, mb.mime_id); {noformat}
> The inner query doesn't take very long... I'm not sure why this is hanging,
> but it is a showstopper.
>
> I'm going to experiment with creating indices on the exceptions_compared and
> the related tables/fields.
>
> If that doesn't work, we may need to create temp tables and join them. :P
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
