gatsby: Parallel Queries and Temporary Query Result Error

Preliminary Checks

• This issue is not a duplicate. Before opening a new issue, please search existing issues: https://github.com/gatsbyjs/gatsby/issues
• This issue is not a question, feature request, RFC, or anything other than a bug report directly related to Gatsby. Please post those things in GitHub Discussions: https://github.com/gatsbyjs/gatsby/discussions

Description

Our Gatsby application suffers from crashes (100% 10/10) when running gatsby build due to “Parallel Queries” crashing without saying which query is crashing.

And during development runtimes, randomly, when opening different pages, it just crashes most of the time with Error: Couldn't find temp query result for "/en/blog/releases/v16.6.2". (Or similar, with the difference of other page titles).

Note that by removing the newly added content/blog/releases the crash from gatsby build disappears, but the random temp query result issue persists. I have no idea which file is causing it to crash. All those files abide by MDXv2 standards. (Even tho the App uses MDXv1)

Reproduction Link

https://github.com/ovflowd/nodejs.dev/tree/test/gatsby-crashes

Steps to Reproduce

1. Clone, checkout
2. Run gatsby build
3. Crashes

OR

1. Clone, checkout
2. Run gatsby develop
3. Navigate to different blog posts
4. Crashes

Expected Result

1. To not crash?

Actual Result

1. It crashes.

Environment

  System:
    OS: macOS 12.5.1
    CPU: (10) arm64 Apple M1 Max
    Shell: 5.8.1 - /bin/zsh
  Binaries:
    Node: 18.9.0 - /var/folders/kr/dtpb07wj0cl0vp56klz_xc440000gq/T/yarn--1663025110592-0.9226765595115247/node
    Yarn: 1.22.19 - /var/folders/kr/dtpb07wj0cl0vp56klz_xc440000gq/T/yarn--1663025110592-0.9226765595115247/yarn
    npm: 8.19.1 - /opt/homebrew/bin/npm
  Browsers:
    Chrome: 105.0.5195.102
    Firefox: 103.0.2
    Safari: 15.6.1
  npmPackages:
    gatsby: ^4.22.1 => 4.22.1 
    gatsby-link: ^4.22.0 => 4.22.0 
    gatsby-plugin-canonical-urls: ^4.22.0 => 4.22.0 
    gatsby-plugin-catch-links: ^4.22.0 => 4.22.0 
    gatsby-plugin-manifest: ^4.22.0 => 4.22.0 
    gatsby-plugin-mdx: ^3.20.0 => 3.20.0 
    gatsby-plugin-meta-redirect: ^1.1.1 => 1.1.1 
    gatsby-plugin-offline-next: ^5.2.3 => 5.2.3 
    gatsby-plugin-sass: ^5.22.0 => 5.22.0 
    gatsby-plugin-sitemap: ^5.22.0 => 5.22.0 
    gatsby-plugin-svgr: ^3.0.0-beta.0 => 3.0.0-beta.0 
    gatsby-plugin-typescript: ^4.22.0 => 4.22.0 
    gatsby-plugin-webfonts: ^2.2.2 => 2.2.2 
    gatsby-remark-autolink-headers: ^5.22.0 => 5.22.0 
    gatsby-remark-prismjs: ^6.22.0 => 6.22.0 
    gatsby-source-filesystem: ^4.22.0 => 4.22.0 
    gatsby-theme-i18n: ^3.0.0 => 3.0.0 
    gatsby-transformer-yaml: ^4.22.0 => 4.22.0 

Config Flags

FAST_DEV: true