使用此命令,可以在本地环境中成功启动sls offline start --httpPort 12012 -s local
服务器。
但是这个命令的结果是error 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
目前,DB是通过使用sequelize sync来更新的,它有时会锁定表。
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
发布于 2020-07-30 06:28:25
解决方案非常简单,
在serverless.yml
文件中导入插件时,在导入主插件之前导入所有插件是非常重要的。
在本例中,serverless-sequelize-migrations
是在serverless-offline
之后导入的
因此,可行的解决方案是:
plugins:
- serverless-webpack
- serverless-sequelize-migrations
- serverless-offline
- serverless-pseudo-parameters
- serverless-prune-plugin
并使用next命令执行此迁移
serverless migrations up
发布于 2020-07-29 04:06:26
看起来你把migrations
拼错了
错误消息显示:
"migratins" is not a valid sub command. Run "serverless offline" to see a more helpful error message for this command.
https://stackoverflow.com/questions/63141209
复制相似问题