Graphql page data missing in production mode

[zanedev]

Hi, I have a Gatsby site that I upgraded from an older version v2 to latest v5.9.0 and a page template graphql query started missing data in production that it has in development mode. It has some of the data but not all of it. This only happens in production mode, in development the data is all there as expected.

I can verify this by running gatsby build and gatsby serve locally and the data is missing, and its also missing in the vercel deployment. Has anyone seen this before?

Here is my graphql page query in src/templates/school.js that works in development mode fine. In production mode school has data but students and projects is an empty array.

export const query = graphql`
  query SchoolTemplateQuery($id: String!) {
    school: sanitySchool(id: { eq: $id }) {
      ...School
      seoImage {
        asset {
          ... on SanityImageAsset {
            _id
            url
            gatsbyImageData(width: 1024, placeholder: NONE, layout: FIXED)
          }
        }
      }
      seoKeywords
      seo {
        focus_keyword
        meta_description
        seo_title
      }
      gallery {
        ...GlobalSection
      }
      majors {
        title
      }
    }
    students: allSanityStudent(
      filter: {
        school: { id: { eq: $id } }
        slug: { current: { ne: null } }
        hiddenProfile: { ne: true }
        publishedAt: { ne: null }
      }
    ) {
      nodes {
        ...StudentPreview
      }
    }
    projects: allSanityProject(
      filter: { school: { id: { eq: $id } }, slug: { current: { ne: null } }, publishedAt: { ne: null } }
    ) {
      nodes {
        ...ProjectPreview
      }
    }
  }
`;

This page is created from gatsby node exports.createPages:

async function createSchoolPages(graphql, actions, reporter) {
  const { createPage } = actions;
  const result = await graphql(`
    {
      schools: allSanitySchool(filter: { slug: { current: { ne: null } } }) {
        edges {
          node {
            id
            slug {
              current
            }
          }
        }
      }
    }
  `);

  if (result.errors) throw result.errors;

  const schoolEdges = (result.data.schools || {}).edges || [];

  schoolEdges.forEach((edge) => {
    const id = edge.node.id;
    const slug = edge.node.slug.current;
    const path = `/schools/${slug}/`;

    reporter.info(`Creating school page: ${path}`);

    createPage({
      path,
      component: require.resolve('./src/templates/school.js'),
      context: { id },
    });
  });
}

In development the console log of data/students (note there is data):

In production the console log of data/students (note there is no data):

[zanedev]

I want to add that I am not mutating any data so DETECT_NODE_MUTATIONS isn't helping

[zanedev]

This is a bit urgent for a site launch as usual.. can someone point me to where in the gatsby source to debug this?

[zanedev]

Closing this, turns out there was another env pointing to a different dataset for the build command :(