在Windows 11上安装SonarQube 7.6时遇到问题，日志显示由于MySQL 8.0.28中'groups'可能是关键字导致数据库迁移失败。尝试直接执行创建表语句时也遇到相同错误。解决方案是使用更旧版本的MySQL（如5.6.10），并相应地更新SonarQube的数据库连接参数，成功启动SonarQube。
一、安装环境
系统：win11
Mysql版本：8.0.28
sonarqube版本：7.6
二、安装过程中报错信息
日志路径：{安装目录}\sonarqube-7.6\logs\web.log
2022.07.08 18:01:59 INFO web[][o.s.p.ProcessEntryPoint] Starting web
2022.07.08 18:01:59 INFO web[][o.a.t.u.n.NioSelectorPool] Using a shared selector for servlet write/read
2022.07.08 18:02:00 INFO web[][o.e.p.PluginsService] no modules loaded
2022.07.08 18:02:00 INFO web[][o.e.p.PluginsService] loaded plugin [org.elasticsearch.join.ParentJoinPlugin]
2022.07.08 18:02:00 INFO web[][o.e.p.PluginsService] loaded plugin [org.elasticsearch.percolator.PercolatorPlugin]
2022.07.08 18:02:00 INFO web[][o.e.p.PluginsService] loaded plugin [org.elasticsearch.transport.Netty4Plugin]
2022.07.08 18:02:01 INFO web[][o.s.s.e.EsClientProvider] Connected to local Elasticsearch: [127.0.0.1:9001]
2022.07.08 18:02:01 INFO web[][o.s.s.p.LogServerVersion] SonarQube Server / 7.6.0.21501 / d56689a5eb122c06cf87375828085609f5a68323
2022.07.08 18:02:01 INFO web[][o.sonar.db.Database] Create JDBC data source for jdbc:mysql://localhost:3306/sonar?useUnicode=true&characterEncoding=utf8&rewriteBatchedStatements=true&useConfigs=maxPerformance&useSSL=false
2022.07.08 18:02:01 WARN web[][o.s.db.dialect.MySql] MySQL support is deprecated and will be dropped soon.
2022.07.08 18:02:01 INFO web[][o.s.s.p.ServerFileSystemImpl] SonarQube home: D:\software\sonarqube-7.6
2022.07.08 18:02:01 INFO web[][o.s.s.u.SystemPasscodeImpl] System authentication by passcode is disabled
2022.07.08 18:02:01 INFO web[][o.s.s.p.d.m.h.MigrationHistoryTableImpl] Creating table schema_migrations
2022.07.08 18:02:01 INFO web[][o.s.s.p.ServerPluginRepository] Deploy plugin Git / 1.7.0.1491 / 1d54e49a5f952dfb4ccded090f8043a2a62d0372
2022.07.08 18:02:01 INFO web[][o.s.s.p.ServerPluginRepository] Deploy plugin JaCoCo / 1.0.1.143 / 65c55e41e32c114704fd597ccea91fc55becb4ec
2022.07.08 18:02:01 INFO web[][o.s.s.p.ServerPluginRepository] Deploy plugin LDAP / 2.2.0.608 / 79dc3fa4393a29667673c70182f3016288b548b7
2022.07.08 18:02:01 INFO web[][o.s.s.p.ServerPluginRepository] Deploy plugin SonarC# / 7.10.0.7896 / 4e51d150065288432fd1411d29d5aebf2ab7f133
2022.07.08 18:02:01 INFO web[][o.s.s.p.ServerPluginRepository] Deploy plugin SonarCSS / 1.0.3.724 / 3ad5232345519caed38a24c70fb77e91757833bf
2022.07.08 18:02:01 INFO web[][o.s.s.p.ServerPluginRepository] Deploy plugin SonarFlex / 2.4.0.1222 / 68d9cb3b7daccbc4869c4f2b89d09218d26a0829
2022.07.08 18:02:01 INFO web[][o.s.s.p.ServerPluginRepository] Deploy plugin SonarGo / 1.1.0.1612 / 1809c7be6d88396c0a1b8d597b1e9e0ed8d29730
2022.07.08 18:02:01 INFO web[][o.s.s.p.ServerPluginRepository] Deploy plugin SonarHTML / 3.1.0.1615 / 4181edb5eff5605bec82dc0aa15ecd70eaa5857f
2022.07.08 18:02:01 INFO web[][o.s.s.p.ServerPluginRepository] Deploy plugin SonarJS / 5.0.0.6962 / ac2fe7567f3dfeb3295e2e710afd8c06b7760e9d
2022.07.08 18:02:01 INFO web[][o.s.s.p.ServerPluginRepository] Deploy plugin SonarJava / 5.10.1.16922 / 448c4b8fce8d8ac53a9a7a7265d4de1c1ac87a4e
2022.07.08 18:02:01 INFO web[][o.s.s.p.ServerPluginRepository] Deploy plugin SonarKotlin / 1.4.0.155 / f71ae433edd0c1f1dbab3fed4d755ef17aef8573
2022.07.08 18:02:01 INFO web[][o.s.s.p.ServerPluginRepository] Deploy plugin SonarPHP / 2.16.0.4355 / 80c76cb14e9eae6bd982fa6ac8c39b2de1f89b6f
2022.07.08 18:02:01 INFO web[][o.s.s.p.ServerPluginRepository] Deploy plugin SonarPython / 1.11.0.2473 / 3ec86bb66699ff9ccf2c00c84f360210eb3ffd8d
2022.07.08 18:02:01 INFO web[][o.s.s.p.ServerPluginRepository] Deploy plugin SonarRuby / 1.4.0.155 / f71ae433edd0c1f1dbab3fed4d755ef17aef8573
2022.07.08 18:02:01 INFO web[][o.s.s.p.ServerPluginRepository] Deploy plugin SonarScala / 1.4.0.155 / f71ae433edd0c1f1dbab3fed4d755ef17aef8573
2022.07.08 18:02:01 INFO web[][o.s.s.p.ServerPluginRepository] Deploy plugin SonarTS / 1.9.0.3766 / 4a4080b78001a78d758d1d0fa0190fb9496b6f57
2022.07.08 18:02:01 INFO web[][o.s.s.p.ServerPluginRepository] Deploy plugin SonarVB / 7.10.0.7896 / 4e51d150065288432fd1411d29d5aebf2ab7f133
2022.07.08 18:02:01 INFO web[][o.s.s.p.ServerPluginRepository] Deploy plugin SonarXML / 2.0.1.2020 / c5b84004face582d56f110e24c29bf9c6a679e69
2022.07.08 18:02:01 INFO web[][o.s.s.p.ServerPluginRepository] Deploy plugin Svn / 1.9.0.1295 / 942e075773975354e32691a60bfd968065703e04
2022.07.08 18:02:02 INFO web[][o.s.s.p.d.m.AutoDbMigration] Automatically perform DB migration on fresh install
2022.07.08 18:02:02 INFO web[][DbMigrations] Executing DB migrations…
2022.07.08 18:02:02 INFO web[][DbMigrations] #1 ‘Create initial schema’…
2022.07.08 18:02:02 ERROR web[][DbMigrations] #1 ‘Create initial schema’: failure | time=345ms
2022.07.08 18:02:02 ERROR web[][DbMigrations] Executed DB migrations: failure | time=345ms
2022.07.08 18:02:02 ERROR web[][o.s.s.p.Platform] Web server startup failed
java.lang.IllegalStateException: Fail to execute CREATE TABLE groups (id INTEGER NOT NULL AUTO_INCREMENT,name VARCHAR (500) NULL,description VARCHAR (200) NULL,created_at DATETIME NULL,updated_at DATETIME NULL, CONSTRAINT pk_groups PRIMARY KEY (id)) ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_bin
at org.sonar.server.platform.db.migration.step.DdlChange
C
o
n
t
e
x
t
.
e
x
e
c
u
t
e
(
D
d
l
C
h
a
n
g
e
.
j
a
v
a
:
97
)
a
t
o
r
g
.
s
o
n
a
r
.
s
e
r
v
e
r
.
p
l
a
t
f
o
r
m
.
d
b
.
m
i
g
r
a
t
i
o
n
.
s
t
e
p
.
D
d
l
C
h
a
n
g
e
Context.execute(DdlChange.java:97) at org.sonar.server.platform.db.migration.step.DdlChange
Context.execute(DdlChange.java:97)atorg.sonar.server.platform.db.migration.step.DdlChangeContext.execute(DdlChange.java:77)
at org.sonar.server.platform.db.migration.step.DdlChange
C
o
n
t
e
x
t
.
e
x
e
c
u
t
e
(
D
d
l
C
h
a
n
g
e
.
j
a
v
a
:
117
)
a
t
o
r
g
.
s
o
n
a
r
.
s
e
r
v
e
r
.
p
l
a
t
f
o
r
m
.
d
b
.
m
i
g
r
a
t
i
o
n
.
v
e
r
s
i
o
n
.
v
56.
C
r
e
a
t
e
I
n
i
t
i
a
l
S
c
h
e
m
a
.
c
r
e
a
t
e
G
r
o
u
p
s
(
C
r
e
a
t
e
I
n
i
t
i
a
l
S
c
h
e
m
a
.
j
a
v
a
:
578
)
a
t
o
r
g
.
s
o
n
a
r
.
s
e
r
v
e
r
.
p
l
a
t
f
o
r
m
.
d
b
.
m
i
g
r
a
t
i
o
n
.
v
e
r
s
i
o
n
.
v
56.
C
r
e
a
t
e
I
n
i
t
i
a
l
S
c
h
e
m
a
.
e
x
e
c
u
t
e
(
C
r
e
a
t
e
I
n
i
t
i
a
l
S
c
h
e
m
a
.
j
a
v
a
:
63
)
a
t
o
r
g
.
s
o
n
a
r
.
s
e
r
v
e
r
.
p
l
a
t
f
o
r
m
.
d
b
.
m
i
g
r
a
t
i
o
n
.
s
t
e
p
.
D
d
l
C
h
a
n
g
e
.
e
x
e
c
u
t
e
(
D
d
l
C
h
a
n
g
e
.
j
a
v
a
:
45
)
a
t
o
r
g
.
s
o
n
a
r
.
s
e
r
v
e
r
.
p
l
a
t
f
o
r
m
.
d
b
.
m
i
g
r
a
t
i
o
n
.
s
t
e
p
.
M
i
g
r
a
t
i
o
n
S
t
e
p
s
E
x
e
c
u
t
o
r
I
m
p
l
.
e
x
e
c
u
t
e
(
M
i
g
r
a
t
i
o
n
S
t
e
p
s
E
x
e
c
u
t
o
r
I
m
p
l
.
j
a
v
a
:
75
)
a
t
o
r
g
.
s
o
n
a
r
.
s
e
r
v
e
r
.
p
l
a
t
f
o
r
m
.
d
b
.
m
i
g
r
a
t
i
o
n
.
s
t
e
p
.
M
i
g
r
a
t
i
o
n
S
t
e
p
s
E
x
e
c
u
t
o
r
I
m
p
l
.
e
x
e
c
u
t
e
(
M
i
g
r
a
t
i
o
n
S
t
e
p
s
E
x
e
c
u
t
o
r
I
m
p
l
.
j
a
v
a
:
67
)
a
t
j
a
v
a
.
b
a
s
e
/
j
a
v
a
.
l
a
n
g
.
I
t
e
r
a
b
l
e
.
f
o
r
E
a
c
h
(
U
n
k
n
o
w
n
S
o
u
r
c
e
)
a
t
o
r
g
.
s
o
n
a
r
.
s
e
r
v
e
r
.
p
l
a
t
f
o
r
m
.
d
b
.
m
i
g
r
a
t
i
o
n
.
s
t
e
p
.
M
i
g
r
a
t
i
o
n
S
t
e
p
s
E
x
e
c
u
t
o
r
I
m
p
l
.
e
x
e
c
u
t
e
(
M
i
g
r
a
t
i
o
n
S
t
e
p
s
E
x
e
c
u
t
o
r
I
m
p
l
.
j
a
v
a
:
52
)
a
t
o
r
g
.
s
o
n
a
r
.
s
e
r
v
e
r
.
p
l
a
t
f
o
r
m
.
d
b
.
m
i
g
r
a
t
i
o
n
.
e
n
g
i
n
e
.
M
i
g
r
a
t
i
o
n
E
n
g
i
n
e
I
m
p
l
.
e
x
e
c
u
t
e
(
M
i
g
r
a
t
i
o
n
E
n
g
i
n
e
I
m
p
l
.
j
a
v
a
:
68
)
a
t
o
r
g
.
s
o
n
a
r
.
s
e
r
v
e
r
.
p
l
a
t
f
o
r
m
.
d
b
.
m
i
g
r
a
t
i
o
n
.
A
u
t
o
D
b
M
i
g
r
a
t
i
o
n
.
s
t
a
r
t
(
A
u
t
o
D
b
M
i
g
r
a
t
i
o
n
.
j
a
v
a
:
62
)
a
t
j
a
v
a
.
b
a
s
e
/
j
d
k
.
i
n
t
e
r
n
a
l
.
r
e
f
l
e
c
t
.
N
a
t
i
v
e
M
e
t
h
o
d
A
c
c
e
s
s
o
r
I
m
p
l
.
i
n
v
o
k
e
0
(
N
a
t
i
v
e
M
e
t
h
o
d
)
a
t
j
a
v
a
.
b
a
s
e
/
j
d
k
.
i
n
t
e
r
n
a
l
.
r
e
f
l
e
c
t
.
N
a
t
i
v
e
M
e
t
h
o
d
A
c
c
e
s
s
o
r
I
m
p
l
.
i
n
v
o
k
e
(
U
n
k
n
o
w
n
S
o
u
r
c
e
)
a
t
j
a
v
a
.
b
a
s
e
/
j
d
k
.
i
n
t
e
r
n
a
l
.
r
e
f
l
e
c
t
.
D
e
l
e
g
a
t
i
n
g
M
e
t
h
o
d
A
c
c
e
s
s
o
r
I
m
p
l
.
i
n
v
o
k
e
(
U
n
k
n
o
w
n
S
o
u
r
c
e
)
a
t
j
a
v
a
.
b
a
s
e
/
j
a
v
a
.
l
a
n
g
.
r
e
f
l
e
c
t
.
M
e
t
h
o
d
.
i
n
v
o
k
e
(
U
n
k
n
o
w
n
S
o
u
r
c
e
)
a
t
o
r
g
.
p
i
c
o
c
o
n
t
a
i
n
e
r
.
l
i
f
e
c
y
c
l
e
.
R
e
f
l
e
c
t
i
o
n
L
i
f
e
c
y
c
l
e
S
t
r
a
t
e
g
y
.
i
n
v
o
k
e
M
e
t
h
o
d
(
R
e
f
l
e
c
t
i
o
n
L
i
f
e
c
y
c
l
e
S
t
r
a
t
e
g
y
.
j
a
v
a
:
110
)
a
t
o
r
g
.
p
i
c
o
c
o
n
t
a
i
n
e
r
.
l
i
f
e
c
y
c
l
e
.
R
e
f
l
e
c
t
i
o
n
L
i
f
e
c
y
c
l
e
S
t
r
a
t
e
g
y
.
s
t
a
r
t
(
R
e
f
l
e
c
t
i
o
n
L
i
f
e
c
y
c
l
e
S
t
r
a
t
e
g
y
.
j
a
v
a
:
89
)
a
t
o
r
g
.
p
i
c
o
c
o
n
t
a
i
n
e
r
.
i
n
j
e
c
t
o
r
s
.
A
b
s
t
r
a
c
t
I
n
j
e
c
t
i
o
n
F
a
c
t
o
r
y
Context.execute(DdlChange.java:117) at org.sonar.server.platform.db.migration.version.v56.CreateInitialSchema.createGroups(CreateInitialSchema.java:578) at org.sonar.server.platform.db.migration.version.v56.CreateInitialSchema.execute(CreateInitialSchema.java:63) at org.sonar.server.platform.db.migration.step.DdlChange.execute(DdlChange.java:45) at org.sonar.server.platform.db.migration.step.MigrationStepsExecutorImpl.execute(MigrationStepsExecutorImpl.java:75) at org.sonar.server.platform.db.migration.step.MigrationStepsExecutorImpl.execute(MigrationStepsExecutorImpl.java:67) at java.base/java.lang.Iterable.forEach(Unknown Source) at org.sonar.server.platform.db.migration.step.MigrationStepsExecutorImpl.execute(MigrationStepsExecutorImpl.java:52) at org.sonar.server.platform.db.migration.engine.MigrationEngineImpl.execute(MigrationEngineImpl.java:68) at org.sonar.server.platform.db.migration.AutoDbMigration.start(AutoDbMigration.java:62) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.base/java.lang.reflect.Method.invoke(Unknown Source) at org.picocontainer.lifecycle.ReflectionLifecycleStrategy.invokeMethod(ReflectionLifecycleStrategy.java:110) at org.picocontainer.lifecycle.ReflectionLifecycleStrategy.start(ReflectionLifecycleStrategy.java:89) at org.picocontainer.injectors.AbstractInjectionFactory
Context.execute(DdlChange.java:117)atorg.sonar.server.platform.db.migration.version.v56.CreateInitialSchema.createGroups(CreateInitialSchema.java:578)atorg.sonar.server.platform.db.migration.version.v56.CreateInitialSchema.execute(CreateInitialSchema.java:63)atorg.sonar.server.platform.db.migration.step.DdlChange.execute(DdlChange.java:45)atorg.sonar.server.platform.db.migration.step.MigrationStepsExecutorImpl.execute(MigrationStepsExecutorImpl.java:75)atorg.sonar.server.platform.db.migration.step.MigrationStepsExecutorImpl.execute(MigrationStepsExecutorImpl.java:67)atjava.base/java.lang.Iterable.forEach(UnknownSource)atorg.sonar.server.platform.db.migration.step.MigrationStepsExecutorImpl.execute(MigrationStepsExecutorImpl.java:52)atorg.sonar.server.platform.db.migration.engine.MigrationEngineImpl.execute(MigrationEngineImpl.java:68)atorg.sonar.server.platform.db.migration.AutoDbMigration.start(AutoDbMigration.java:62)atjava.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(NativeMethod)atjava.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(UnknownSource)atjava.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(UnknownSource)atjava.base/java.lang.reflect.Method.invoke(UnknownSource)atorg.picocontainer.lifecycle.ReflectionLifecycleStrategy.invokeMethod(ReflectionLifecycleStrategy.java:110)atorg.picocontainer.lifecycle.ReflectionLifecycleStrategy.start(ReflectionLifecycleStrategy.java:89)atorg.picocontainer.injectors.AbstractInjectionFactoryLifecycleAdapter.start(AbstractInjectionFactory.java:84)
at org.picocontainer.behaviors.AbstractBehavior.start(AbstractBehavior.java:169)
at org.picocontainer.behaviors.Stored
R
e
a
l
C
o
m
p
o
n
e
n
t
L
i
f
e
c
y
c
l
e
.
s
t
a
r
t
(
S
t
o
r
e
d
.
j
a
v
a
:
132
)
a
t
o
r
g
.
p
i
c
o
c
o
n
t
a
i
n
e
r
.
b
e
h
a
v
i
o
r
s
.
S
t
o
r
e
d
.
s
t
a
r
t
(
S
t
o
r
e
d
.
j
a
v
a
:
110
)
a
t
o
r
g
.
p
i
c
o
c
o
n
t
a
i
n
e
r
.
D
e
f
a
u
l
t
P
i
c
o
C
o
n
t
a
i
n
e
r
.
p
o
t
e
n
t
i
a
l
l
y
S
t
a
r
t
A
d
a
p
t
e
r
(
D
e
f
a
u
l
t
P
i
c
o
C
o
n
t
a
i
n
e
r
.
j
a
v
a
:
1016
)
a
t
o
r
g
.
p
i
c
o
c
o
n
t
a
i
n
e
r
.
D
e
f
a
u
l
t
P
i
c
o
C
o
n
t
a
i
n
e
r
.
s
t
a
r
t
A
d
a
p
t
e
r
s
(
D
e
f
a
u
l
t
P
i
c
o
C
o
n
t
a
i
n
e
r
.
j
a
v
a
:
1009
)
a
t
o
r
g
.
p
i
c
o
c
o
n
t
a
i
n
e
r
.
D
e
f
a
u
l
t
P
i
c
o
C
o
n
t
a
i
n
e
r
.
s
t
a
r
t
(
D
e
f
a
u
l
t
P
i
c
o
C
o
n
t
a
i
n
e
r
.
j
a
v
a
:
767
)
a
t
o
r
g
.
s
o
n
a
r
.
c
o
r
e
.
p
l
a
t
f
o
r
m
.
C
o
m
p
o
n
e
n
t
C
o
n
t
a
i
n
e
r
.
s
t
a
r
t
C
o
m
p
o
n
e
n
t
s
(
C
o
m
p
o
n
e
n
t
C
o
n
t
a
i
n
e
r
.
j
a
v
a
:
135
)
a
t
o
r
g
.
s
o
n
a
r
.
s
e
r
v
e
r
.
p
l
a
t
f
o
r
m
.
p
l
a
t
f
o
r
m
l
e
v
e
l
.
P
l
a
t
f
o
r
m
L
e
v
e
l
.
s
t
a
r
t
(
P
l
a
t
f
o
r
m
L
e
v
e
l
.
j
a
v
a
:
90
)
a
t
o
r
g
.
s
o
n
a
r
.
s
e
r
v
e
r
.
p
l
a
t
f
o
r
m
.
P
l
a
t
f
o
r
m
.
s
t
a
r
t
(
P
l
a
t
f
o
r
m
.
j
a
v
a
:
211
)
a
t
o
r
g
.
s
o
n
a
r
.
s
e
r
v
e
r
.
p
l
a
t
f
o
r
m
.
P
l
a
t
f
o
r
m
.
s
t
a
r
t
S
a
f
e
M
o
d
e
C
o
n
t
a
i
n
e
r
(
P
l
a
t
f
o
r
m
.
j
a
v
a
:
203
)
a
t
o
r
g
.
s
o
n
a
r
.
s
e
r
v
e
r
.
p
l
a
t
f
o
r
m
.
P
l
a
t
f
o
r
m
.
d
o
S
t
a
r
t
(
P
l
a
t
f
o
r
m
.
j
a
v
a
:
104
)
a
t
o
r
g
.
s
o
n
a
r
.
s
e
r
v
e
r
.
p
l
a
t
f
o
r
m
.
P
l
a
t
f
o
r
m
.
d
o
S
t
a
r
t
(
P
l
a
t
f
o
r
m
.
j
a
v
a
:
95
)
a
t
o
r
g
.
s
o
n
a
r
.
s
e
r
v
e
r
.
p
l
a
t
f
o
r
m
.
w
e
b
.
P
l
a
t
f
o
r
m
S
e
r
v
l
e
t
C
o
n
t
e
x
t
L
i
s
t
e
n
e
r
.
c
o
n
t
e
x
t
I
n
i
t
i
a
l
i
z
e
d
(
P
l
a
t
f
o
r
m
S
e
r
v
l
e
t
C
o
n
t
e
x
t
L
i
s
t
e
n
e
r
.
j
a
v
a
:
46
)
a
t
o
r
g
.
a
p
a
c
h
e
.
c
a
t
a
l
i
n
a
.
c
o
r
e
.
S
t
a
n
d
a
r
d
C
o
n
t
e
x
t
.
l
i
s
t
e
n
e
r
S
t
a
r
t
(
S
t
a
n
d
a
r
d
C
o
n
t
e
x
t
.
j
a
v
a
:
4745
)
a
t
o
r
g
.
a
p
a
c
h
e
.
c
a
t
a
l
i
n
a
.
c
o
r
e
.
S
t
a
n
d
a
r
d
C
o
n
t
e
x
t
.
s
t
a
r
t
I
n
t
e
r
n
a
l
(
S
t
a
n
d
a
r
d
C
o
n
t
e
x
t
.
j
a
v
a
:
5207
)
a
t
o
r
g
.
a
p
a
c
h
e
.
c
a
t
a
l
i
n
a
.
u
t
i
l
.
L
i
f
e
c
y
c
l
e
B
a
s
e
.
s
t
a
r
t
(
L
i
f
e
c
y
c
l
e
B
a
s
e
.
j
a
v
a
:
150
)
a
t
o
r
g
.
a
p
a
c
h
e
.
c
a
t
a
l
i
n
a
.
c
o
r
e
.
C
o
n
t
a
i
n
e
r
B
a
s
e
RealComponentLifecycle.start(Stored.java:132) at org.picocontainer.behaviors.Stored.start(Stored.java:110) at org.picocontainer.DefaultPicoContainer.potentiallyStartAdapter(DefaultPicoContainer.java:1016) at org.picocontainer.DefaultPicoContainer.startAdapters(DefaultPicoContainer.java:1009) at org.picocontainer.DefaultPicoContainer.start(DefaultPicoContainer.java:767) at org.sonar.core.platform.ComponentContainer.startComponents(ComponentContainer.java:135) at org.sonar.server.platform.platformlevel.PlatformLevel.start(PlatformLevel.java:90) at org.sonar.server.platform.Platform.start(Platform.java:211) at org.sonar.server.platform.Platform.startSafeModeContainer(Platform.java:203) at org.sonar.server.platform.Platform.doStart(Platform.java:104) at org.sonar.server.platform.Platform.doStart(Platform.java:95) at org.sonar.server.platform.web.PlatformServletContextListener.contextInitialized(PlatformServletContextListener.java:46) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4745) at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5207) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) at org.apache.catalina.core.ContainerBase
RealComponentLifecycle.start(Stored.java:132)atorg.picocontainer.behaviors.Stored.start(Stored.java:110)atorg.picocontainer.DefaultPicoContainer.potentiallyStartAdapter(DefaultPicoContainer.java:1016)atorg.picocontainer.DefaultPicoContainer.startAdapters(DefaultPicoContainer.java:1009)atorg.picocontainer.DefaultPicoContainer.start(DefaultPicoContainer.java:767)atorg.sonar.core.platform.ComponentContainer.startComponents(ComponentContainer.java:135)atorg.sonar.server.platform.platformlevel.PlatformLevel.start(PlatformLevel.java:90)atorg.sonar.server.platform.Platform.start(Platform.java:211)atorg.sonar.server.platform.Platform.startSafeModeContainer(Platform.java:203)atorg.sonar.server.platform.Platform.doStart(Platform.java:104)atorg.sonar.server.platform.Platform.doStart(Platform.java:95)atorg.sonar.server.platform.web.PlatformServletContextListener.contextInitialized(PlatformServletContextListener.java:46)atorg.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4745)atorg.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5207)atorg.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)atorg.apache.catalina.core.ContainerBaseStartChild.call(ContainerBase.java:1419)
at org.apache.catalina.core.ContainerBase
S
t
a
r
t
C
h
i
l
d
.
c
a
l
l
(
C
o
n
t
a
i
n
e
r
B
a
s
e
.
j
a
v
a
:
1409
)
a
t
j
a
v
a
.
b
a
s
e
/
j
a
v
a
.
u
t
i
l
.
c
o
n
c
u
r
r
e
n
t
.
F
u
t
u
r
e
T
a
s
k
.
r
u
n
(
U
n
k
n
o
w
n
S
o
u
r
c
e
)
a
t
j
a
v
a
.
b
a
s
e
/
j
a
v
a
.
u
t
i
l
.
c
o
n
c
u
r
r
e
n
t
.
T
h
r
e
a
d
P
o
o
l
E
x
e
c
u
t
o
r
.
r
u
n
W
o
r
k
e
r
(
U
n
k
n
o
w
n
S
o
u
r
c
e
)
a
t
j
a
v
a
.
b
a
s
e
/
j
a
v
a
.
u
t
i
l
.
c
o
n
c
u
r
r
e
n
t
.
T
h
r
e
a
d
P
o
o
l
E
x
e
c
u
t
o
r
StartChild.call(ContainerBase.java:1409) at java.base/java.util.concurrent.FutureTask.run(Unknown Source) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.base/java.util.concurrent.ThreadPoolExecutor
StartChild.call(ContainerBase.java:1409)atjava.base/java.util.concurrent.FutureTask.run(UnknownSource)atjava.base/java.util.concurrent.ThreadPoolExecutor.runWorker(UnknownSource)atjava.base/java.util.concurrent.ThreadPoolExecutorWorker.run(Unknown Source)
at java.base/java.lang.Thread.run(Unknown Source)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'groups (id INTEGER NOT NULL AUTO_INCREMENT,name VARCHAR (500) NULL,description V’ at line 1
at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.base/java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
at com.mysql.jdbc.Util.getInstance(Util.java:408)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:944)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3976)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3912)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2530)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2683)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2482)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2440)
at com.mysql.jdbc.StatementImpl.executeInternal(StatementImpl.java:845)
at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:745)
at org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:175)
at org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:175)
at org.sonar.server.platform.db.migration.step.DdlChange$Context.execute(DdlChange.java:82)
… 40 common frames omitted
2022.07.08 18:02:04 WARN web[][o.a.c.u.SessionIdGeneratorBase] Creation of SecureRandom instance for session ID generation using [SHA1PRNG] took [106] milliseconds.
三、原因分析
sonarqube7.6版本中，在安装过程中会自动生成一系列需要用到的表，其中有一个需要用到的表表名是“groups”，8.0.28版本Mysql中，“groups”可能是系统的一个关键字，不能作为表名。我尝试直接使用日志中生成表的语句在MySql数据库执行，报同样错误。当我将表名添加一个字符就可用执行成功。
四、解决办法
1.在sonarqube官网上根据对应的版本选中推荐的数据库以及对应的版本；
2.根据你本地的数据库版本选择对应的sonarqube版本安装
我安装了一个Mysql 5.6.10版本的数据库，然后修改sonarqube数据库链接参数，启动成功。
参考链接：
https://blog.youkuaiyun.com/Mango_Bin/article/details/121584080
https://blog.youkuaiyun.com/NeverFG/article/details/122268043
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
