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

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 2.9.0
• Assignee: Unassigned
• Reporter: Tim Allison
• Created: 18/Jul/23 18:23
• Updated: 28/Aug/23 19:25
• Resolved: 19/Jul/23 17:17

Description

For some reason, this query is now hanging forever in 2.6.0-2.8.0 on the new regression set of files.

 

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

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.

Issue Links

• links to: GitHub Pull Request #1245