[
https://issues.apache.org/jira/browse/TIKA-4100?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17744698#comment-17744698
]
ASF GitHub Bot commented on TIKA-4100:
--------------------------------------
tballison opened a new pull request, #1245:
URL: https://github.com/apache/tika/pull/1245
<!--
Licensed to the Apache Software Foundation (ASF) under one
or more contributor license agreements. See the NOTICE file
distributed with this work for additional information
regarding copyright ownership. The ASF licenses this file
to you under the Apache License, Version 2.0 (the
"License"); you may not use this file except in compliance
with the License. You may obtain a copy of the License at
http://www.apache.org/licenses/LICENSE-2.0
Unless required by applicable law or agreed to in writing,
software distributed under the License is distributed on an
"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
KIND, either express or implied. See the License for the
specific language governing permissions and limitations
under the License.
-->
Thanks for your contribution to [Apache Tika](https://tika.apache.org/)!
Your help is appreciated!
Before opening the pull request, please verify that
* there is an open issue on the [Tika issue
tracker](https://issues.apache.org/jira/projects/TIKA) which describes the
problem or the improvement. We cannot accept pull requests without an issue
because the change wouldn't be listed in the release notes.
* the issue ID (`TIKA-XXXX`)
- is referenced in the title of the pull request
- and placed in front of your commit messages surrounded by square
brackets (`[TIKA-XXXX] Issue or pull request title`)
* commits are squashed into a single one (or few commits for larger changes)
* Tika is successfully built and unit tests pass by running `mvn clean test`
* there should be no conflicts when merging the pull request branch into the
*recent* `main` branch. If there are conflicts, please try to rebase the pull
request branch on top of a freshly pulled `main` branch
* if you add new module that downstream users will depend upon add it to
relevant group in `tika-bom/pom.xml`.
We will be able to faster integrate your pull request if these conditions
are met. If you have any questions how to fix your problem or about using Tika
in general, please sign up for the [Tika mailing
list](http://tika.apache.org/mail-lists.html). Thanks!
> 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)
