[CT-1476] [Bug] 1.1.latest test fails

### Is this a new bug in dbt-core?

- [X] I believe this is a new bug in dbt-core
- [X] I have searched the existing issues, and I could not find an existing issue for this bug

### Current Behavior

When backporting recently I started hitting errors in the `1.1.latest` branch unrelated to my change.

There is an error with a deprecation test, but only on the logging jobs. The test passes for the integration test runs.

Additionally, I can get the tests to fail locally when running the entire file but the test passes if I run the specific file.

I don't know what started to make this fail.

### Expected Behavior

Tests pass

### Steps To Reproduce

See #6218 for example of failing tests

### Relevant log output

_No response_

### Environment

```markdown
- OS:
- Python:
- dbt:
```

### Which database adapter are you using with dbt?

_No response_

### Additional Context

_No response_