可以检查jira 日志
tail -f /var/atlassian/application-data/jira/log/*.log /opt/atlassian/jira/logs/*
看到类似 JQUARTZ_JOB_LISTENERS 表没有的提示信息
参考该日志,找到对应表的create 语句,https://gist.github.com/bearcatsandor/b69e59a35e6ce92fbf618b4e97170214
或者将jira日志设置为debug 模式,找到创建失败的表语句,到mysql cli 执行,排除错误
去mysql 命令行创建相应的表,估计会创建不成功,主要是字段长度*字符编码占用字符数 > MySQL 字段允许最大长度冲突,可以改小字段的字符数以创建成功,然后重启jira即可
例如
CREATE TABLE JQUARTZ_JOB_LISTENERS (JOB_NAME VARCHAR(200) NOT NULL, JOB_GROUP VARCHAR(200) NOT NULL, JOB_LISTENER VARCHAR(200) NOT NULL, CONSTRAINT PK_JQUARTZ_JOB_LISTENERS PRIMARY KEY (JOB_NAME, JOB_GROUP, JOB_LISTENER));
ERROR 1071 (42000): Specified key was too long; max key length is 1536 bytes
把字段长度改小以避免该错误,或者选着合适的编码
CREATE TABLE JQUARTZ_JOB_LISTENERS (JOB_NAME VARCHAR(100) NOT NULL, JOB_GROUP VARCHAR(100) NOT NULL, JOB_LISTENER VARCHAR(100) NOT NULL, CONSTRAINT PK_JQUARTZ_JOB_LISTENERS PRIMARY KEY (JOB_NAME, JOB_GROUP, JOB_LISTENER));
后续日志会有下面提示,好像不影响使用,暂时没想到好的解决办法
/opt/atlassian/jira/logs/catalina.out: ALTER TABLE JQUARTZ_JOB_LISTENERS MODIFY JOB_LISTENER VARCHAR(200)
/opt/atlassian/jira/logs/catalina.out:2024-03-28 23:53:40,880 JIRA-Bootstrap ERROR [o.o.c.entity.jdbc.DatabaseUtil] Could not widen column "JOB_LISTENER" in table "JQUARTZ_JOB_LISTENERS" to size: VARCHAR(200).
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.