Tim Allison created TIKA-4100:
---------------------------------
Summary: Work-around for ~infinite loop 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
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)
