It seems that the `test_find_not_should_ignore_path` test has some dependency on side-effects from other tests. 

For example it failed here:

https://github.com/apache/airflow/pull/10983/checks?check_run_id=1127304894#step:6:1043

```
>       self.assertEqual(detected_files, should_not_ignore_files)
E       AssertionError: Items in the second set but not the first:
E       'test_load.py'
E       'test_load_sub1.py'
```

And re-running it in a clean system works just fine in the same combination of python/db.

**What you expected to happen**:

The test should clean up /restore everything it needs before running or a test that makes side-effects is found and fixed. 

For now I am moving the test to "heisentests with appropriate note.".

airflow/utils/file.py
"""This function is deprecated. Please use `tempfile.TemporaryDirectory`"""
    import warnings
    from tempfile import TemporaryDirectory as TmpDir
    warnings.warn(
        "This function is deprecated. Please use `tempfile.TemporaryDirectory`",
        DeprecationWarning, stacklevel=2
    )
    return TmpDir(*args, **kwargs)
def mkdirs(path, mode):
    """
    Creates the directory specified by path, creating intermediate directories
    as necessary. If directory already exists, this is a no-op.
    :param path: The directory to create
    :type path: str
    :param mode: The mode to give to the directory e.g. 0o755, ignores umask
    :type mode: int
    """
    import warnings
    warnings.warn(
        f"This function is deprecated. Please use `pathlib.Path({path}).mkdir`",
        DeprecationWarning, stacklevel=2
    )
    Path(path).mkdir(mode=mode, parents=True, exist_ok=True)
ZIP_REGEX = re.compile(r'((.*\.zip){})?(.*)'.format(re.escape(os.sep)))
def correct_maybe_zipped(fileloc):