Next.js App deployed on Vercel Return staled data when get Mongo documents count

[wangf1]

Summary

I have a simple Next.js application that exposes a REST API to get the count of Mongo documents. It works fine locally, but when deployed on Vercel, it always returns stale count numbers. Redeploying the application refreshes the count. While fetching document content works correctly, the count always shows outdated data.

I’m unsure where the count might be cached. Additionally, when I add console.log statements for debugging, I can't view the logs in the Vercel Dashboard (as reported in this GitHub discussion).

Can anyone provide any insights or clues about this issue? Thank you1
Below is the related code:

//shortModel.ts
import { Short } from "@/common/types/short/shortTypes";
import mongoose, { Document, ObjectId, Schema } from "mongoose";

interface ShortDocument extends Document<ObjectId>, Omit<Short, "_id"> {}

const ShortSchema: Schema = new Schema({
  date: { type: Date, required: true },
  tags: { type: [String], required: true },
  content: { type: String, required: true },
  isPinned: { type: Boolean },
  thumbUps: { type: Number },
  thumbDowns: { type: Number },
});

const ShortDAO =
  mongoose.models.Short || mongoose.model<ShortDocument>("Short", ShortSchema);

export default ShortDAO;


// shortService.ts
const getShortsCount = async () => {
  await connectToMongoDb();
  console.log("ShortService: getShortsCount...");
  const count = await ShortDAO.countDocuments();
  console.log(`ShortService: getShortsCount: ${count}`);
  return count;
};

//shortController.ts
const getShortsCount = async () => {
  try {
    console.log("ShortController: getShortsCount...");
    const shortsCount = await shortService.getShortsCount();
    console.log(`ShortController: getShortsCount: ${shortsCount}`);
    return Response.json(shortsCount);
  } catch (error) {
    console.log(error);
    return new Response("Error fetching shorts count", {
      status: 500,
    });
  }
};


//API route.ts
import shortController from "@/backend/short/shortController";

export async function GET(): Promise<Response> {
  return shortController.getShortsCount();
}

Additional information

No response

Example

No response

[wangf1]

After I click Vecel Dashboard -> Settings -> Data Cache -> Purge Everything, the document count can be refresh to correct value.
But how can I disble cache for geting document count?

[medlnb]

bros talking to him self