[jira] [Updated] (TIKA-4100) Work-around for ~infinite loop in one of the reports in tika-eval Report tool

["Tim Allison (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/TIKA-4100?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Tim Allison updated TIKA-4100:
------------------------------
    Summary: Work-around for ~infinite loop in one of the reports in tika-eval Report tool  (was: Work-around for ~infinite loop in tika-eval Report tool)

> 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
>
> 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)