amazon-web-services - Sequelize Serverless 离线迁移出错
问题描述
使用此命令sls offline start --httpPort 12012 -s local
,服务器在本地环境上成功启动。
但是这个命令结果是错误的sls offline migrations --httpPort 12012 -s local
Serverless Error ---------------------------------------
"migrations" is not a valid sub command. Run "serverless offline" to see a more helpful error message for this command.
Get Support --------------------------------------------
Docs: docs.serverless.com
Bugs: github.com/serverless/serverless/issues
Issues: forum.serverless.com
Your Environment Information ---------------------------
Operating System: linux
Node Version: 14.4.0
Framework Version: 1.75.1
Plugin Version: 3.6.16
SDK Version: 2.3.1
Components Version: 2.32.0
如果我运行serverless migrations up
会发生错误。
Serverless: Setting up connections...
Serverless: Looking for pending migrations...
Executing (default): CREATE TABLE IF NOT EXISTS `SequelizeMeta` (`name` VARCHAR(255) NOT NULL UNIQUE , PRIMARY KEY (`name`)) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_unicode_ci;
Executing (default): SHOW INDEX FROM `SequelizeMeta`
Executing (default): SELECT `name` FROM `SequelizeMeta` AS `SequelizeMeta` ORDER BY `SequelizeMeta`.`name` ASC;
Serverless: Applying pending migrations...
Executing (default): CREATE TABLE IF NOT EXISTS `SequelizeMeta` (`name` VARCHAR(255) NOT NULL UNIQUE , PRIMARY KEY (`name`)) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_unicode_ci;
Executing (default): SHOW INDEX FROM `SequelizeMeta`
Executing (default): SELECT `name` FROM `SequelizeMeta` AS `SequelizeMeta` ORDER BY `SequelizeMeta`.`name` ASC;
Executing (default): CREATE TABLE IF NOT EXISTS `SequelizeMeta` (`name` VARCHAR(255) NOT NULL UNIQUE , PRIMARY KEY (`name`)) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_unicode_ci;
Executing (default): SHOW INDEX FROM `SequelizeMeta`
Executing (default): SELECT `name` FROM `SequelizeMeta` AS `SequelizeMeta` ORDER BY `SequelizeMeta`.`name` ASC;
Serverless: Error while applying migrations
Serverless: Looking for migration that has problems...
Executing (default): CREATE TABLE IF NOT EXISTS `SequelizeMeta` (`name` VARCHAR(255) NOT NULL UNIQUE , PRIMARY KEY (`name`)) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_unicode_ci;
Executing (default): SHOW INDEX FROM `SequelizeMeta`
Executing (default): SELECT `name` FROM `SequelizeMeta` AS `SequelizeMeta` ORDER BY `SequelizeMeta`.`name` ASC;
Serverless: Something wrong with 20200728165728-init.js
目前,通过使用有时会锁定表的 sequelize sync 来更新 DB。
import Sequelize from 'sequelize';
import mysql2 from 'mysql2';
const db = new Sequelize(
process.env.DB_NAME,
process.env.DB_USERNAME,
process.env.DB_PASSWORD,
{
omitNull: true,
dialect: process.env.DB_DIALECT,
dialectModule: mysql2,
dialectOptions: {
supportBigNumbers: true
},
host: process.env.DB_HOST,
});
let synced = false;
const getSequelize = () => {
if (!synced) {
db.sync({ alter: true })
.then(() => {
console.log(`Database & tables synchronised!`)
});
synced = true;
}
return db;
}
export default getSequelize();
这些是包含在配置文件中的插件
plugins:
- serverless-webpack
- serverless-offline
- serverless-pseudo-parameters
- serverless-prune-plugin
- serverless-sequelize-migrations
解决方案
看起来你拼错了migrations
?
错误消息说:
"migratins" is not a valid sub command. Run "serverless offline" to see a more helpful error message for this command.
推荐阅读
- python - VSCode:调试配置中的 Python 路径无效
- r - dplyr - 总结中的条件语句
- spring - Spring Cloud Stream 配置问题
- java - JavaFX 子场景集填充
- c# - 在 Unity 中从 Android Studio 读取意图
- python - 如何在 Rasa X 中发出带有超链接的动态消息?
- javascript - Regex (in Javascript) Alpha 加空格,最多 20 个字符,无特殊字符,必须唯一
- c# - 调用方法的调用者时使用实例状态的上下文属性
- powershell - 如何将 Get-SBFarmStatus 的输出放入易于访问的对象中?
- node.js - 如何处理多个数据库调用的事务回滚(调用 firebase 和 mongoDB Atlas)?