[
https://issues.apache.org/jira/browse/TIKA-4100?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Tim Allison resolved TIKA-4100.
-------------------------------
Fix Version/s: 2.8.1
Resolution: Fixed
> 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)
