Fastify+Mongoose中Populate数组字段失败返回500错误

问题场景 #

使用Fastify和Mongoose开发时，尝试为Meeting模型关联的Trainee数组字段执行populate操作以获取trainee.name，但操作失败触发500错误并进入try-catch的catch分支；移除populate后，接口可正常返回待审批会议数据。

错误根源 #

控制器中populate配置的path参数为单数trainee，但Meeting模型里定义的关联字段是复数trainees，Mongoose无法找到对应字段，导致populate操作抛出异常。

修正后的控制器代码 #

将populate的path改为trainees即可解决问题：

const getPendingApprovalMeetings = async (
  request: any,
  reply: FastifyReply,
) => {
  const { coachId }: { coachId: string } = request.user;
  const { page, limit }: { page: number; limit: number } = request.query;
  let coach: CoachType | null;
  try {
    coach = await Coach.findById(coachId);
  } catch (err: Error | any) {
    logger.error(`can't get coach by his id: ${err.message} - ${coachId}`);
    return await reply
      .status(500)
      .send('Getting meetings failed, please try again.');
  }

  if (!coach) {
    logger.error(`didn't find coach by his id - ${coachId}`);
    return await reply
      .status(404)
      .send('Could not find coach for provided id.');
  }

  let pendingApprovalMeetings = [];
  try {
    pendingApprovalMeetings = await Meeting.find(
      {
        _id: { $in: coach.meetings },
        status: 'Waiting for approval',
      },
      {},
      {
        skip: (page - 1) * limit,
        limit,
      },
    )
      .populate({
        path: 'trainees', // 修正为复数字段名
        select: 'name',
      })
  } catch (err: Error | any) {
    logger.error(`can't get pending approval meetings - ${coachId}`, err);
    return await reply
      .status(500)
      .send('Getting pending approval meetings failed, please try again.');
  }

  return await reply.status(200).send({
    meetings: pendingApprovalMeetings,
  });
};

额外调试建议 #

• 在catch分支中打印完整的错误堆栈信息，能更快定位字段不匹配这类基础问题
• 确认Mongoose模型的字段名与populate的path参数严格一致，包括单复数、大小写
• 检查Trainee模型是否已正确注册到Mongoose实例中，避免因模型未加载导致的关联失败

内容的提问来源于stack exchange，提问作者steve123