在NextJS中使用Sequelize时DELETE操作触发两次sync()是否正常？

在NextJS环境中使用Sequelize框架时，执行DELETE操作发现sequelize.sync()被触发两次，日志重复输出‘Database & tables created!’提示信息。尝试修改ORM查询语句（调整findOne与destroy调用方式）及响应返回形式（改用new Response替代Response.json），问题仍未解决，咨询该现象是否正常。

sequelize.ts #

import { Sequelize } from 'sequelize-typescript';
import { Person } from './models/person';
import * as _mariadb from 'mariadb';

export const sequelize = new Sequelize({
  dialect: 'mariadb',
  dialectModule: _mariadb,
  database: 'nextjs',
  username: 'root',
  password: 'xyz',
  models: [Person]
});

sequelize.sync()
  .then(() => {
    console.log('Database & tables created!');
  })
  .catch(error => console.error('Sequelize initialization error:', error));

routes.ts #

import { Person } from "@/app/database/models/person";
import { sequelize } from "@/app/database/sequelize";


export async function GET(_request: Request, {params}: {params: {id: string}})
{
    await sequelize.authenticate(); // 不加这句会报错：ModelNotInitializedError: Model not initialized: Member "findOne" cannot be called. "Person" needs to be added to a Sequelize instance.
    const testData = await Person.findOne({where: {id: parseInt(params.id)}});
    return Response.json(testData); // 原代码中`veri`为笔误，修正为`testData`
}

export async function DELETE(request: Request, {params}: {params: {id: string}})
{
    const index = await Person.findOne({where: {id: parseInt(params.id)}});
    const testData = index?.username;
    index?.destroy();
    return Response.json(testData);
}

Executing (default): SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_NAME = 'Person' AND TABLE_SCHEMA = 'nextjs'
Executing (default): SELECT 1+1 AS result
Executing (default): SHOW INDEX FROM `Person` FROM `nextjs`
Executing (default): SELECT `id`, `username`, `password`, `createdAt`, `updatedAt` FROM `Person` AS `Person` WHERE `Person`.`id` = 5;
Database & tables created!
Executing (default): DELETE FROM `Person` WHERE `id` = 5
 DELETE /comments/5 200 in 284ms
Executing (default): SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_NAME = 'Person' AND TABLE_SCHEMA = 'nextjs'
Executing (default): SHOW INDEX FROM `Person` FROM `nextjs`
Database & tables created!

这个现象不属于正常情况，核心原因是NextJS的模块加载机制导致sequelize.sync()被重复执行。

问题根源 #

NextJS在开发模式下（next dev）启用热重载，每次路由请求或代码变动时可能重新加载模块；而你直接在sequelize.ts的模块顶层执行sequelize.sync()，会导致每次该模块被导入（比如routes.ts请求时导入）都触发同步操作，最终出现重复日志。

解决方案 #

1. 封装同步逻辑，确保仅执行一次
   修改sequelize.ts，添加标志位控制sync()只运行一次：

   import { Sequelize } from 'sequelize-typescript';
   import { Person } from './models/person';
   import * as _mariadb from 'mariadb';
   
   export const sequelize = new Sequelize({
     dialect: 'mariadb',
     dialectModule: _mariadb,
     database: 'nextjs',
     username: 'root',
     password: 'xyz',
     models: [Person]
   });
   
   let syncCompleted = false;
   
   async function initSequelize() {
     if (!syncCompleted) {
       try {
         await sequelize.sync();
         console.log('Database & tables created!');
         syncCompleted = true;
       } catch (error) {
         console.error('Sequelize initialization error:', error);
       }
     }
   }
   
   initSequelize();
   

2. 移除冗余的认证操作
   GET路由中的await sequelize.authenticate()属于冗余代码，sequelize.sync()已经包含数据库连接验证逻辑，删除该语句可减少不必要的数据库请求。

3. 生产环境建议
   生产环境不要依赖sequelize.sync()自动建表，改用Sequelize迁移工具（sequelize-cli）管理数据库结构，避免意外修改表结构。

额外提示 #

原代码GET函数中Response.json(veri)存在变量未定义的笔误，需修正为Response.json(testData)，否则会触发运行时错误。

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