jumpserverv28.8 升级 v3.6.1 报数据库错误

Applying acls.0006_commandfilteracl_commandgroup...2023-08-22 15:17:57 Perform migrate failed, exit

Traceback (most recent call last):

File "/usr/local/lib/python3.9/site-packages/django/db/backends/utils.py", line 84, in _execute

return self.cursor.execute(sql, params)

File "/usr/local/lib/python3.9/site-packages/django/db/backends/mysql/base.py", line 73, in execute

return self.cursor.execute(query, args)

File "/usr/local/lib/python3.9/site-packages/MySQLdb/cursors.py", line 206, in execute

res = self._query(query)

File "/usr/local/lib/python3.9/site-packages/MySQLdb/cursors.py", line 319, in _query

db.query(q)

File "/usr/local/lib/python3.9/site-packages/MySQLdb/connections.py", line 254, in query

_mysql.connection.query(self, query)

MySQLdb._exceptions.OperationalError: (1005, 'Can\'t create table `jumpserver`.`acls_commandfilteracl_reviewers` (errno: 150 "Foreign key constraint is incorrectly formed")')

The above exception was the direct cause of the following exception:

是下载了 3.6.1 的离线安装包,然后执行 ./jmsctl.sh upgrade 出现的
然后登录数据库配置了 SET FOREIGN_KEY_CHECKS=0; 也不行,求助大佬呀

V2和V3版本差异较大,参考下官方升级指导稳定哈。JumpServer v3.0 升级指南 - FIT2CLOUD 知识库