windows上安装kafka eable 1.2.6,启动都正常了,但是登陆时候遇到 SQLErrorCodes loaded: [DB2, Derby, H2, HSQL, Informix, MS-SQL, MySQL, Oracle, PostgreSQL, Sybase, Hana]数据库问题,捣鼓了半天还是没解决,创建对应的表也试过不行,有没有大神知道该如何解决?
安装参考文档:https://www.cnblogs.com/smartloli/p/9371904.html
我安装kafka eagle版本前,核对了kafka和zookeeper都安装并运行正常,由于我在本机localhost搭建的试用版本,因此kafka集群就1个,且为1台broker,并建了几个topic,配置基本差不多:
由于我本地配置的是mysql,因此配置里我改成了如下jdbc:
按照安装参考文档,我只是创建了ke数据库,但里面没有表,在运行后,通过http://localhost:8048/ke 登陆界面登陆进去就报了如下错误:
tomcat控制台里也相应出现了如下错误信息
再登陆一遍就会报更详细的错误信息如下:(请问有没有大神知道该如何解决?)
Caused by: org.springframework.jdbc.BadSqlGrammarException:
Error querying database. Cause: java.sql.SQLSyntaxErrorException: Table ‘ke.ke_clusters’ doesn’t exist
The error may exist in org/smartloli/kafka/eagle/web/dao/AlertDao.xml
The error may involve defaultParameterMap
The error occurred while setting parameters
SQL: select * from ke_clusters
Cause: java.sql.SQLSyntaxErrorException: Table ‘ke.ke_clusters’ doesn’t exist
; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: Table ‘ke.ke_clusters’ doesn’t exist
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:231)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73)
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:73)
at org.mybatis.spring.SqlSessionTemplate
S
q
l
S
e
s
s
i
o
n
I
n
t
e
r
c
e
p
t
o
r
.
i
n
v
o
k
e
(
S
q
l
S
e
s
s
i
o
n
T
e
m
p
l
a
t
e
.
j
a
v
a
:
371
)
a
t
c
o
m
.
s
u
n
.
p
r
o
x
y
.
SqlSessionInterceptor.invoke(SqlSessionTemplate.java:371) at com.sun.proxy.
SqlSessionInterceptor.invoke(SqlSessionTemplate.java:371)atcom.sun.proxy.Proxy12.selectList(Unknown Source)
at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:198)
at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:119)
at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:63)
at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:52)
at com.sun.proxy.
P
r
o
x
y
17.
h
i
s
t
o
r
y
s
(
U
n
k
n
o
w
n
S
o
u
r
c
e
)
a
t
o
r
g
.
s
m
a
r
t
l
o
l
i
.
k
a
f
k
a
.
e
a
g
l
e
.
w
e
b
.
s
e
r
v
i
c
e
.
i
m
p
l
.
A
l
e
r
t
S
e
r
v
i
c
e
I
m
p
l
.
h
i
s
t
o
r
y
s
(
A
l
e
r
t
S
e
r
v
i
c
e
I
m
p
l
.
j
a
v
a
:
168
)
a
t
o
r
g
.
s
m
a
r
t
l
o
l
i
.
k
a
f
k
a
.
e
a
g
l
e
.
w
e
b
.
q
u
a
r
t
z
.
A
l
e
r
t
Q
u
a
r
t
z
Proxy17.historys(Unknown Source) at org.smartloli.kafka.eagle.web.service.impl.AlertServiceImpl.historys(AlertServiceImpl.java:168) at org.smartloli.kafka.eagle.web.quartz.AlertQuartz
Proxy17.historys(UnknownSource)atorg.smartloli.kafka.eagle.web.service.impl.AlertServiceImpl.historys(AlertServiceImpl.java:168)atorg.smartloli.kafka.eagle.web.quartz.AlertQuartzCluster.cluster(AlertQuartz.java:247)
at org.smartloli.kafka.eagle.web.quartz.AlertQuartz.alertJobQuartz(AlertQuartz.java:78)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.springframework.util.MethodInvoker.invoke(MethodInvoker.java:269)
at org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean
M
e
t
h
o
d
I
n
v
o
k
i
n
g
J
o
b
.
e
x
e
c
u
t
e
I
n
t
e
r
n
a
l
(
M
e
t
h
o
d
I
n
v
o
k
i
n
g
J
o
b
D
e
t
a
i
l
F
a
c
t
o
r
y
B
e
a
n
.
j
a
v
a
:
257
)
.
.
.
3
m
o
r
e
C
a
u
s
e
d
b
y
:
j
a
v
a
.
s
q
l
.
S
Q
L
S
y
n
t
a
x
E
r
r
o
r
E
x
c
e
p
t
i
o
n
:
T
a
b
l
e
′
k
e
.
k
e
c
l
u
s
t
e
r
s
′
d
o
e
s
n
′
t
e
x
i
s
t
a
t
c
o
m
.
m
y
s
q
l
.
c
j
.
j
d
b
c
.
e
x
c
e
p
t
i
o
n
s
.
S
Q
L
E
r
r
o
r
.
c
r
e
a
t
e
S
Q
L
E
x
c
e
p
t
i
o
n
(
S
Q
L
E
r
r
o
r
.
j
a
v
a
:
120
)
a
t
c
o
m
.
m
y
s
q
l
.
c
j
.
j
d
b
c
.
e
x
c
e
p
t
i
o
n
s
.
S
Q
L
E
r
r
o
r
.
c
r
e
a
t
e
S
Q
L
E
x
c
e
p
t
i
o
n
(
S
Q
L
E
r
r
o
r
.
j
a
v
a
:
97
)
a
t
c
o
m
.
m
y
s
q
l
.
c
j
.
j
d
b
c
.
e
x
c
e
p
t
i
o
n
s
.
S
Q
L
E
x
c
e
p
t
i
o
n
s
M
a
p
p
i
n
g
.
t
r
a
n
s
l
a
t
e
E
x
c
e
p
t
i
o
n
(
S
Q
L
E
x
c
e
p
t
i
o
n
s
M
a
p
p
i
n
g
.
j
a
v
a
:
122
)
a
t
c
o
m
.
m
y
s
q
l
.
c
j
.
j
d
b
c
.
C
l
i
e
n
t
P
r
e
p
a
r
e
d
S
t
a
t
e
m
e
n
t
.
e
x
e
c
u
t
e
I
n
t
e
r
n
a
l
(
C
l
i
e
n
t
P
r
e
p
a
r
e
d
S
t
a
t
e
m
e
n
t
.
j
a
v
a
:
974
)
a
t
c
o
m
.
m
y
s
q
l
.
c
j
.
j
d
b
c
.
C
l
i
e
n
t
P
r
e
p
a
r
e
d
S
t
a
t
e
m
e
n
t
.
e
x
e
c
u
t
e
(
C
l
i
e
n
t
P
r
e
p
a
r
e
d
S
t
a
t
e
m
e
n
t
.
j
a
v
a
:
391
)
a
t
c
o
m
.
a
l
i
b
a
b
a
.
d
r
u
i
d
.
f
i
l
t
e
r
.
F
i
l
t
e
r
C
h
a
i
n
I
m
p
l
.
p
r
e
p
a
r
e
d
S
t
a
t
e
m
e
n
t
e
x
e
c
u
t
e
(
F
i
l
t
e
r
C
h
a
i
n
I
m
p
l
.
j
a
v
a
:
2931
)
a
t
c
o
m
.
a
l
i
b
a
b
a
.
d
r
u
i
d
.
f
i
l
t
e
r
.
F
i
l
t
e
r
E
v
e
n
t
A
d
a
p
t
e
r
.
p
r
e
p
a
r
e
d
S
t
a
t
e
m
e
n
t
e
x
e
c
u
t
e
(
F
i
l
t
e
r
E
v
e
n
t
A
d
a
p
t
e
r
.
j
a
v
a
:
440
)
a
t
c
o
m
.
a
l
i
b
a
b
a
.
d
r
u
i
d
.
f
i
l
t
e
r
.
F
i
l
t
e
r
C
h
a
i
n
I
m
p
l
.
p
r
e
p
a
r
e
d
S
t
a
t
e
m
e
n
t
e
x
e
c
u
t
e
(
F
i
l
t
e
r
C
h
a
i
n
I
m
p
l
.
j
a
v
a
:
2929
)
a
t
c
o
m
.
a
l
i
b
a
b
a
.
d
r
u
i
d
.
p
r
o
x
y
.
j
d
b
c
.
P
r
e
p
a
r
e
d
S
t
a
t
e
m
e
n
t
P
r
o
x
y
I
m
p
l
.
e
x
e
c
u
t
e
(
P
r
e
p
a
r
e
d
S
t
a
t
e
m
e
n
t
P
r
o
x
y
I
m
p
l
.
j
a
v
a
:
131
)
a
t
c
o
m
.
a
l
i
b
a
b
a
.
d
r
u
i
d
.
p
o
o
l
.
D
r
u
i
d
P
o
o
l
e
d
P
r
e
p
a
r
e
d
S
t
a
t
e
m
e
n
t
.
e
x
e
c
u
t
e
(
D
r
u
i
d
P
o
o
l
e
d
P
r
e
p
a
r
e
d
S
t
a
t
e
m
e
n
t
.
j
a
v
a
:
493
)
a
t
o
r
g
.
a
p
a
c
h
e
.
i
b
a
t
i
s
.
e
x
e
c
u
t
o
r
.
s
t
a
t
e
m
e
n
t
.
P
r
e
p
a
r
e
d
S
t
a
t
e
m
e
n
t
H
a
n
d
l
e
r
.
q
u
e
r
y
(
P
r
e
p
a
r
e
d
S
t
a
t
e
m
e
n
t
H
a
n
d
l
e
r
.
j
a
v
a
:
59
)
a
t
o
r
g
.
a
p
a
c
h
e
.
i
b
a
t
i
s
.
e
x
e
c
u
t
o
r
.
s
t
a
t
e
m
e
n
t
.
R
o
u
t
i
n
g
S
t
a
t
e
m
e
n
t
H
a
n
d
l
e
r
.
q
u
e
r
y
(
R
o
u
t
i
n
g
S
t
a
t
e
m
e
n
t
H
a
n
d
l
e
r
.
j
a
v
a
:
73
)
a
t
o
r
g
.
a
p
a
c
h
e
.
i
b
a
t
i
s
.
e
x
e
c
u
t
o
r
.
S
i
m
p
l
e
E
x
e
c
u
t
o
r
.
d
o
Q
u
e
r
y
(
S
i
m
p
l
e
E
x
e
c
u
t
o
r
.
j
a
v
a
:
60
)
a
t
o
r
g
.
a
p
a
c
h
e
.
i
b
a
t
i
s
.
e
x
e
c
u
t
o
r
.
B
a
s
e
E
x
e
c
u
t
o
r
.
q
u
e
r
y
F
r
o
m
D
a
t
a
b
a
s
e
(
B
a
s
e
E
x
e
c
u
t
o
r
.
j
a
v
a
:
267
)
a
t
o
r
g
.
a
p
a
c
h
e
.
i
b
a
t
i
s
.
e
x
e
c
u
t
o
r
.
B
a
s
e
E
x
e
c
u
t
o
r
.
q
u
e
r
y
(
B
a
s
e
E
x
e
c
u
t
o
r
.
j
a
v
a
:
137
)
a
t
o
r
g
.
a
p
a
c
h
e
.
i
b
a
t
i
s
.
e
x
e
c
u
t
o
r
.
C
a
c
h
i
n
g
E
x
e
c
u
t
o
r
.
q
u
e
r
y
(
C
a
c
h
i
n
g
E
x
e
c
u
t
o
r
.
j
a
v
a
:
96
)
a
t
o
r
g
.
a
p
a
c
h
e
.
i
b
a
t
i
s
.
e
x
e
c
u
t
o
r
.
C
a
c
h
i
n
g
E
x
e
c
u
t
o
r
.
q
u
e
r
y
(
C
a
c
h
i
n
g
E
x
e
c
u
t
o
r
.
j
a
v
a
:
77
)
a
t
o
r
g
.
a
p
a
c
h
e
.
i
b
a
t
i
s
.
s
e
s
s
i
o
n
.
d
e
f
a
u
l
t
s
.
D
e
f
a
u
l
t
S
q
l
S
e
s
s
i
o
n
.
s
e
l
e
c
t
L
i
s
t
(
D
e
f
a
u
l
t
S
q
l
S
e
s
s
i
o
n
.
j
a
v
a
:
108
)
a
t
o
r
g
.
a
p
a
c
h
e
.
i
b
a
t
i
s
.
s
e
s
s
i
o
n
.
d
e
f
a
u
l
t
s
.
D
e
f
a
u
l
t
S
q
l
S
e
s
s
i
o
n
.
s
e
l
e
c
t
L
i
s
t
(
D
e
f
a
u
l
t
S
q
l
S
e
s
s
i
o
n
.
j
a
v
a
:
102
)
a
t
s
u
n
.
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
s
u
n
.
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
(
N
a
t
i
v
e
M
e
t
h
o
d
A
c
c
e
s
s
o
r
I
m
p
l
.
j
a
v
a
:
62
)
a
t
s
u
n
.
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
(
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
.
j
a
v
a
:
43
)
a
t
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
(
M
e
t
h
o
d
.
j
a
v
a
:
498
)
a
t
o
r
g
.
m
y
b
a
t
i
s
.
s
p
r
i
n
g
.
S
q
l
S
e
s
s
i
o
n
T
e
m
p
l
a
t
e
MethodInvokingJob.executeInternal(MethodInvokingJobDetailFactoryBean.java:257) ... 3 more Caused by: java.sql.SQLSyntaxErrorException: Table 'ke.ke_clusters' doesn't exist at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:974) at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:391) at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:2931) at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_execute(FilterEventAdapter.java:440) at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:2929) at com.alibaba.druid.proxy.jdbc.PreparedStatementProxyImpl.execute(PreparedStatementProxyImpl.java:131) at com.alibaba.druid.pool.DruidPooledPreparedStatement.execute(DruidPooledPreparedStatement.java:493) at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:59) at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:73) at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:60) at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:267) at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:137) at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:96) at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:77) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:108) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:102) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.mybatis.spring.SqlSessionTemplate
MethodInvokingJob.executeInternal(MethodInvokingJobDetailFactoryBean.java:257)...3moreCausedby:java.sql.SQLSyntaxErrorException:Table′ke.keclusters′doesn′texistatcom.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)atcom.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)atcom.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)atcom.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:974)atcom.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:391)atcom.alibaba.druid.filter.FilterChainImpl.preparedStatementexecute(FilterChainImpl.java:2931)atcom.alibaba.druid.filter.FilterEventAdapter.preparedStatementexecute(FilterEventAdapter.java:440)atcom.alibaba.druid.filter.FilterChainImpl.preparedStatementexecute(FilterChainImpl.java:2929)atcom.alibaba.druid.proxy.jdbc.PreparedStatementProxyImpl.execute(PreparedStatementProxyImpl.java:131)atcom.alibaba.druid.pool.DruidPooledPreparedStatement.execute(DruidPooledPreparedStatement.java:493)atorg.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:59)atorg.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:73)atorg.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:60)atorg.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:267)atorg.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:137)atorg.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:96)atorg.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:77)atorg.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:108)atorg.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:102)atsun.reflect.NativeMethodAccessorImpl.invoke0(NativeMethod)atsun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)atsun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)atjava.lang.reflect.Method.invoke(Method.java:498)atorg.mybatis.spring.SqlSessionTemplateSqlSessionInterceptor.invoke(SqlSessionTemplate.java:358)
… 18 more
[2018-12-20 13:50:01] Mx4jServiceImpl.org.springframework.scheduling.quartz.SchedulerFactoryBean#1_Worker-1 - ERROR - JMX service url[BJI065-L0508155.Geely.Auto:-1] create has error,msg is Failed to retrieve RMIServer stub: javax.naming.ServiceUnavailableException [Root exception is java.rmi.ConnectException: Connection refused to host: BJI065-L0508155.Geely.Auto; nested exception is:
java.net.ConnectException: Connection refused: connect]
[2018-12-20 13:50:02] Mx4jServiceImpl.org.springframework.scheduling.quartz.SchedulerFactoryBean#1_Worker-1 - ERROR - JMX service url[BJI065-L0508155.Geely.Auto:-1] create has error,msg is Failed to retrieve RMIServer stub: javax.naming.ServiceUnavailableException [Root exception is java.rmi.ConnectException: Connection refused to host: BJI065-L0508155.Geely.Auto; nested exception is:
java.net.ConnectException: Connection refused: connect]
[2018-12-20 13:50:03] Mx4jServiceImpl.org.springframework.scheduling.quartz.SchedulerFactoryBean#1_Worker-1 - ERROR - JMX service url[BJI065-L0508155.Geely.Auto:-1] create has error,msg is Failed to retrieve RMIServer stub: javax.naming.ServiceUnavailableException [Root exception is java.rmi.ConnectException: Connection refused to host: BJI065-L0508155.Geely.Auto; nested exception is:
java.net.ConnectException: Connection refused: connect]
[2018-12-20 13:50:04] Mx4jServiceImpl.org.springframework.scheduling.quartz.SchedulerFactoryBean#1_Worker-1 - ERROR - JMX service url[BJI065-L0508155.Geely.Auto:-1] create has error,msg is Failed to retrieve RMIServer stub: javax.naming.ServiceUnavailableException [Root exception is java.rmi.ConnectException: Connection refused to host: BJI065-L0508155.Geely.Auto; nested exception is:
java.net.ConnectException: Connection refused: connect]
[2018-12-20 13:50:05] Mx4jServiceImpl.org.springframework.scheduling.quartz.SchedulerFactoryBean#1_Worker-1 - ERROR - JMX service url[BJI065-L0508155.Geely.Auto:-1] create has error,msg is Failed to retrieve RMIServer stub: javax.naming.ServiceUnavailableException [Root exception is java.rmi.ConnectException: Connection refused to host: BJI065-L0508155.Geely.Auto; nested exception is:
java.net.ConnectException: Connection refused: connect]
[2018-12-20 13:50:16] Mx4jServiceImpl.org.springframework.scheduling.quartz.SchedulerFactoryBean#1_Worker-1 - ERROR - JMX service url[BJI065-L0508155.Geely.Auto:-1] create has error,msg is Failed to retrieve RMIServer stub: javax.naming.ServiceUnavailableException [Root exception is java.rmi.ConnectException: Connection refused to host: BJI065-L0508155.Geely.Auto; nested exception is:
java.net.ConnectException: Connection refused: connect]
[2018-12-20 13:50:17] Mx4jServiceImpl.org.springframework.scheduling.quartz.SchedulerFactoryBean#1_Worker-1 - ERROR - JMX service url[BJI065-L0508155.Geely.Auto:-1] create has error,msg is Failed to retrieve RMIServer stub: javax.naming.ServiceUnavailableException [Root exception is java.rmi.ConnectException: Connection refused to host: BJI065-L0508155.Geely.Auto; nested exception is:
java.net.ConnectException: Connection refused: connect]
[2018-12-20 13:50:18] Mx4jServiceImpl.org.springframework.scheduling.quartz.SchedulerFactoryBean#1_Worker-1 - ERROR - JMX service url[BJI065-L0508155.Geely.Auto:-1] create has error,msg is Failed to retrieve RMIServer stub: javax.naming.ServiceUnavailableException [Root exception is java.rmi.ConnectException: Connection refused to host: BJI065-L0508155.Geely.Auto; nested exception is:
java.net.ConnectException: Connection refused: connect]
[2018-12-20 13:50:19] Mx4jServiceImpl.org.springframework.scheduling.quartz.SchedulerFactoryBean#1_Worker-1 - ERROR - JMX service url[BJI065-L0508155.Geely.Auto:-1] create has error,msg is Failed to retrieve RMIServer stub: javax.naming.ServiceUnavailableException [Root exception is java.rmi.ConnectException: Connection refused to host: BJI065-L0508155.Geely.Auto; nested exception is:
java.net.ConnectException: Connection refused: connect]
[2018-12-20 13:50:20] Mx4jServiceImpl.org.springframework.scheduling.quartz.SchedulerFactoryBean#1_Worker-1 - ERROR - JMX service url[BJI065-L0508155.Geely.Auto:-1] create has error,msg is Failed to retrieve RMIServer stub: javax.naming.ServiceUnavailableException [Root exception is java.rmi.ConnectException: Connection refused to host: BJI065-L0508155.Geely.Auto; nested exception is:
java.net.ConnectException: Connection refused: connect]
[2018-12-20 13:50:21] Mx4jServiceImpl.org.springframework.scheduling.quartz.SchedulerFactoryBean#1_Worker-1 - ERROR - JMX service url[BJI065-L0508155.Geely.Auto:-1] create has error,msg is Failed to retrieve RMIServer stub: javax.naming.ServiceUnavailableException [Root exception is java.rmi.ConnectException: Connection refused to host: BJI065-L0508155.Geely.Auto; nested exception is:
java.net.ConnectException: Connection refused: connect]
[2018-12-20 13:50:21] MBeanQuartz.org.springframework.scheduling.quartz.SchedulerFactoryBean#1_Worker-1 - ERROR - Collector mbean data has error,msg is
Error updating database. Cause: java.sql.SQLSyntaxErrorException: Table ‘ke.ke_metrics’ doesn’t exist
The error may involve org.smartloli.kafka.eagle.web.dao.MBeanDao.insert-Inline
The error occurred while setting parameters
SQL: insert into ke_metrics(cluster
,broker
,type
,key
,value
,timespan
,tm
) values (?,?,?,?,?,?,?) , (?,?,?,?,?,?,?) , (?,?,?,?,?,?,?) , (?,?,?,?,?,?,?) , (?,?,?,?,?,?,?) , (?,?,?,?,?,?,?) , (?,?,?,?,?,?,?) , (?,?,?,?,?,?,?) , (?,?,?,?,?,?,?) , (?,?,?,?,?,?,?) , (?,?,?,?,?,?,?)
Cause: java.sql.SQLSyntaxErrorException: Table ‘ke.ke_metrics’ doesn’t exist
; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: Table ‘ke.ke_metrics’ doesn’t exist
[2018-12-20 13:50:21] ZKMetricsUtils.org.springframework.scheduling.quartz.SchedulerFactoryBean#1_Worker-1 - ERROR - Collector tcps has error, msg is Cannot run program “/bin/sh”: CreateProcess error=2, 系统找不到指定的文件。
[2018-12-20 13:50:21] ZKMetricsUtils.org.springframework.scheduling.quartz.SchedulerFactoryBean#1_Worker-1 - ERROR - Collector tcps has error, msg is Cannot run program “/bin/sh”: CreateProcess error=2, 系统找不到指定的文件。
[2018-12-20 13:50:21] ZKMetricsUtils.org.springframework.scheduling.quartz.SchedulerFactoryBean#1_Worker-1 - ERROR - Collector tcps has error, msg is Cannot run program “/bin/sh”: CreateProcess error=2, 系统找不到指定的文件。
[2018-12-20 13:50:21] ZKMetricsUtils.org.springframework.scheduling.quartz.SchedulerFactoryBean#1_Worker-1 - ERROR - Collector tcps has error, msg is Cannot run program “/bin/sh”: CreateProcess error=2, 系统找不到指定的文件。
[2018-12-20 13:50:21] MBeanQuartz.org.springframework.scheduling.quartz.SchedulerFactoryBean#1_Worker-1 - ERROR - Collector zookeeper data has error,msg is
Error updating database. Cause: java.sql.SQLSyntaxErrorException: Table ‘ke.ke_metrics’ doesn’t exist
The error may involve org.smartloli.kafka.eagle.web.dao.MBeanDao.insert-Inline
The error occurred while setting parameters
SQL: insert into ke_metrics(cluster
,broker
,type
,key
,value
,timespan
,tm
) values (?,?,?,?,?,?,?) , (?,?,?,?,?,?,?) , (?,?,?,?,?,?,?) , (?,?,?,?,?,?,?)
Cause: java.sql.SQLSyntaxErrorException: Table ‘ke.ke_metrics’ doesn’t exist
; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: Table ‘ke.ke_metrics’ doesn’t exist
请问有没有大神知道该如何解决?