Sequelize
ctbinzi
爱折腾的程序猿
展开
-
记录一次 Deadlock found when trying to get lock; try restarting transaction 错误
在MySql插入数据的时候遇到 Deadlock found when trying to get lock 错误,日志如下SequelizeDatabaseError: Deadlock found when trying to get lock; try restarting transaction at Query.formatError (/www/server/node_modules/sequelize/lib/dialects/mysql/query.js:244:16)原创 2020-09-20 08:14:38 · 7587 阅读 · 0 评论 -
Sequelize使用findAndCountAll、belongsTo、hasMany、include、count、sum、group进行多表关联统计查询问题小结
场景回顾数据库:Mysql5Sequelize版本:5.21.5我们有两个表,分别为 用户表(user)和文章表(article),建立Sequelize模型如下User.jsmodule.exports = function (sequelize, DataTypes) { return sequelize.define('user', { id: { // 编...原创 2020-04-13 10:18:47 · 11175 阅读 · 1 评论