javascript - 每次失败之前Mocha mysql knex : Can't take lock to run migrations

Question

这是我的测试设置代码

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

Answer 1

事实证明，由于 mysql，beforeEach 钩子(Hook)花费了很长时间。

使用 this.timeout 为我解决了这个问题!

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