PackageTests/NewBuild/T3827 fails on MacOS on GHC 8.10.7

Affected:
- macOS with GHC >= 8.10.7
- Linux with GHC = 9.0.1, 9.2.1

PackageTests/NewBuild/T3827 fails in CI on MacOS on GHC 8.10.7:

```
[1 of 1] Compiling P ( P.hs, /Users/runner/work/cabal/cabal/cabal-testsuite/PackageTests/NewBuild/T3827/cabal.dist/work/dist/build/x86_64-osx/ghc-8.10.7/p-1.0/build/P.p_o )

P.hs:1:8: error:
Error: Could not find module ‘Prelude’
Perhaps you haven't installed the profiling libraries for package ‘base-4.14.3.0’?
Use -v (or `:set -v` in ghci) to see a list of the files searched for.
|
1 | module P where
| ^
CallStack (from HasCallStack):
withMetadata, called at src/Distribution/Simple/Utils.hs:374:14 in Cabal-3.7.0.0-inplace:Distribution.Simple.Utils
-----BEGIN CABAL OUTPUT-----
Error: cabal: Failed to build p-1.0-inplace.
Failed to build q-1.0 because it depends on q-1.0 which itself failed to build.
-----END CABAL OUTPUT-----

*** unexpected failure for PackageTests/NewBuild/T3827/cabal.test.hs
```

https://github.com/haskell/cabal/runs/5412517972?check_suite_focus=true

It looks like a profiling build of base isn't available, might be a CI environment issue?