mocha mysql knex每次失败前:不能使用锁来运行迁移

tcomlyy6  于 2021-06-25  发布在  Mysql
关注(0)|答案(2)|浏览(471)

这是我的测试设置代码

const knex = require('../db').knex

beforeEach(() => knex.migrate.rollback()
  .then(() => knex.migrate.latest())
  .then(() => knex.seed.run())
)

afterEach(() => knex.migrate.rollback()
  .then(() => {})
)

获取以下错误

Knex:warning - Can't take lock to run migrations: Migration table is already locked
Knex:warning - If you are sure migrations are not running you can release the lock manually by deleting all the rows from migrations lock table: knex_migrations_lock
Unhandled rejection MigrationLocked: Migration table is already locked

      1) "before each" hook for "is not allowed"
Knex:warning - Can't take lock to run migrations: Migration table is already locked
Knex:warning - If you are sure migrations are not running you can release the lock manually by deleting all the rows from migrations lock table: knex_migrations_lock
      2) "after each" hook for "is not allowed"

这里是 db.js ```
const Knex = require('knex')
const Bookshelf = require('bookshelf')
const config = require('config')

var bookshelf = null
var knex = null

exports.init = () => {
knex = Knex(config.get('database'))
if (process.env.NODE_ENV !== 'test') {
knex.migrate.latest()
}

bookshelf = Bookshelf(knex)
bookshelf.plugin('registry')
bookshelf.plugin('pagination')
bookshelf.plugin('bookshelf-camelcase')
bookshelf.plugin('visibility')

exports.bookshelf = bookshelf
exports.knex = knex

}
`mocha.opts`
--ui bdd
--slow 70
--growl
--recursive
--reporter spec

wgx48brx

wgx48brx1#

请删除迁移锁定表中的所有行,然后重试。可能一些迁移已经崩溃,留下了锁定。
你也不需要做回调。仅仅从之前/之后返回承诺就足够了:

const knex = require('../db').knex

beforeEach(() => knex.migrate.rollback()
  .then(() => knex.migrate.latest())
  .then(() => knex.seed.run())
)

afterEach(() => knex.migrate.rollback())

编辑:
您的db init正在运行 knex.migrate.latest() 而不是等到它完成后再返回函数。

exports.init = () => {
  knex = Knex(config.get('database'))
  if (process.env.NODE_ENV !== 'test') {
    // this starts running migrations and execution continues without waiting that this is ready 
    knex.migrate.latest() 
  }

  bookshelf = Bookshelf(knex)
  bookshelf.plugin('registry')
  bookshelf.plugin('pagination')
  bookshelf.plugin('bookshelf-camelcase')
  bookshelf.plugin('visibility')

  exports.bookshelf = bookshelf
  exports.knex = knex
}
cyej8jka

cyej8jka2#

结果发现 beforeEach 因为mysql,hook花了很长时间。
使用 this.timeout 帮我解决了!

beforeEach(async function () {
  this.timeout(60 * 1000)
  await knex.migrate.rollback()
  await knex.migrate.latest()
  return knex.seed.run()
})

相关问题