报错背景:
CDH未关闭的情况下,Linux断电,导致cloudera-scm-server无法启动。
报错现象:
输入启动命令之后:/opt/cm-5.15.1/etc/init.d/cloudera-scm-server start,
cloudera-scm-server 会启动,但是几秒中之后就会死掉,显示:cloudera-scm-server 已死,但 pid 文件存在。
于是查看日志文件:vim /opt/cm-5.15.1/log/cloudera-scm-server/cloudera-scm-server.log,
复制代码
org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘com.cloudera.server.cmf.TrialState’: Cannot resolve reference to bean ‘entityManagerFactoryBean’ while setting constructor argument; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘entityManagerFactoryBean’: FactoryBean threw exception on object creation; nested exception is javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: Could not open connection
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:328)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:106)
at org.springframework.beans.factory.support.ConstructorResolver.resolveConstructorArguments(ConstructorResolver.java:616)
at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:148)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1003)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:907)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:485)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
at org.springframework.beans.factory.support.AbstractBeanFactory
1.
g
e
t
O
b
j
e
c
t
(
A
b
s
t
r
a
c
t
B
e
a
n
F
a
c
t
o
r
y
.
j
a
v
a
:
293
)
a
t
o
r
g
.
s
p
r
i
n
g
f
r
a
m
e
w
o
r
k
.
b
e
a
n
s
.
f
a
c
t
o
r
y
.
s
u
p
p
o
r
t
.
D
e
f
a
u
l
t
S
i
n
g
l
e
t
o
n
B
e
a
n
R
e
g
i
s
t
r
y
.
g
e
t
S
i
n
g
l
e
t
o
n
(
D
e
f
a
u
l
t
S
i
n
g
l
e
t
o
n
B
e
a
n
R
e
g
i
s
t
r
y
.
j
a
v
a
:
222
)
a
t
o
r
g
.
s
p
r
i
n
g
f
r
a
m
e
w
o
r
k
.
b
e
a
n
s
.
f
a
c
t
o
r
y
.
s
u
p
p
o
r
t
.
A
b
s
t
r
a
c
t
B
e
a
n
F
a
c
t
o
r
y
.
d
o
G
e
t
B
e
a
n
(
A
b
s
t
r
a
c
t
B
e
a
n
F
a
c
t
o
r
y
.
j
a
v
a
:
290
)
a
t
o
r
g
.
s
p
r
i
n
g
f
r
a
m
e
w
o
r
k
.
b
e
a
n
s
.
f
a
c
t
o
r
y
.
s
u
p
p
o
r
t
.
A
b
s
t
r
a
c
t
B
e
a
n
F
a
c
t
o
r
y
.
g
e
t
B
e
a
n
(
A
b
s
t
r
a
c
t
B
e
a
n
F
a
c
t
o
r
y
.
j
a
v
a
:
192
)
a
t
o
r
g
.
s
p
r
i
n
g
f
r
a
m
e
w
o
r
k
.
b
e
a
n
s
.
f
a
c
t
o
r
y
.
s
u
p
p
o
r
t
.
D
e
f
a
u
l
t
L
i
s
t
a
b
l
e
B
e
a
n
F
a
c
t
o
r
y
.
p
r
e
I
n
s
t
a
n
t
i
a
t
e
S
i
n
g
l
e
t
o
n
s
(
D
e
f
a
u
l
t
L
i
s
t
a
b
l
e
B
e
a
n
F
a
c
t
o
r
y
.
j
a
v
a
:
585
)
a
t
o
r
g
.
s
p
r
i
n
g
f
r
a
m
e
w
o
r
k
.
c
o
n
t
e
x
t
.
s
u
p
p
o
r
t
.
A
b
s
t
r
a
c
t
A
p
p
l
i
c
a
t
i
o
n
C
o
n
t
e
x
t
.
f
i
n
i
s
h
B
e
a
n
F
a
c
t
o
r
y
I
n
i
t
i
a
l
i
z
a
t
i
o
n
(
A
b
s
t
r
a
c
t
A
p
p
l
i
c
a
t
i
o
n
C
o
n
t
e
x
t
.
j
a
v
a
:
895
)
a
t
o
r
g
.
s
p
r
i
n
g
f
r
a
m
e
w
o
r
k
.
c
o
n
t
e
x
t
.
s
u
p
p
o
r
t
.
A
b
s
t
r
a
c
t
A
p
p
l
i
c
a
t
i
o
n
C
o
n
t
e
x
t
.
r
e
f
r
e
s
h
(
A
b
s
t
r
a
c
t
A
p
p
l
i
c
a
t
i
o
n
C
o
n
t
e
x
t
.
j
a
v
a
:
425
)
a
t
c
o
m
.
c
l
o
u
d
e
r
a
.
s
e
r
v
e
r
.
c
m
f
.
M
a
i
n
.
b
o
o
t
s
t
r
a
p
S
p
r
i
n
g
C
o
n
t
e
x
t
(
M
a
i
n
.
j
a
v
a
:
393
)
a
t
c
o
m
.
c
l
o
u
d
e
r
a
.
s
e
r
v
e
r
.
c
m
f
.
M
a
i
n
.
<
i
n
i
t
>
(
M
a
i
n
.
j
a
v
a
:
243
)
a
t
c
o
m
.
c
l
o
u
d
e
r
a
.
s
e
r
v
e
r
.
c
m
f
.
M
a
i
n
.
m
a
i
n
(
M
a
i
n
.
j
a
v
a
:
216
)
C
a
u
s
e
d
b
y
:
o
r
g
.
s
p
r
i
n
g
f
r
a
m
e
w
o
r
k
.
b
e
a
n
s
.
f
a
c
t
o
r
y
.
B
e
a
n
C
r
e
a
t
i
o
n
E
x
c
e
p
t
i
o
n
:
E
r
r
o
r
c
r
e
a
t
i
n
g
b
e
a
n
w
i
t
h
n
a
m
e
′
e
n
t
i
t
y
M
a
n
a
g
e
r
F
a
c
t
o
r
y
B
e
a
n
′
:
F
a
c
t
o
r
y
B
e
a
n
t
h
r
e
w
e
x
c
e
p
t
i
o
n
o
n
o
b
j
e
c
t
c
r
e
a
t
i
o
n
;
n
e
s
t
e
d
e
x
c
e
p
t
i
o
n
i
s
j
a
v
a
x
.
p
e
r
s
i
s
t
e
n
c
e
.
P
e
r
s
i
s
t
e
n
c
e
E
x
c
e
p
t
i
o
n
:
o
r
g
.
h
i
b
e
r
n
a
t
e
.
e
x
c
e
p
t
i
o
n
.
G
e
n
e
r
i
c
J
D
B
C
E
x
c
e
p
t
i
o
n
:
C
o
u
l
d
n
o
t
o
p
e
n
c
o
n
n
e
c
t
i
o
n
a
t
o
r
g
.
s
p
r
i
n
g
f
r
a
m
e
w
o
r
k
.
b
e
a
n
s
.
f
a
c
t
o
r
y
.
s
u
p
p
o
r
t
.
F
a
c
t
o
r
y
B
e
a
n
R
e
g
i
s
t
r
y
S
u
p
p
o
r
t
.
d
o
G
e
t
O
b
j
e
c
t
F
r
o
m
F
a
c
t
o
r
y
B
e
a
n
(
F
a
c
t
o
r
y
B
e
a
n
R
e
g
i
s
t
r
y
S
u
p
p
o
r
t
.
j
a
v
a
:
149
)
a
t
o
r
g
.
s
p
r
i
n
g
f
r
a
m
e
w
o
r
k
.
b
e
a
n
s
.
f
a
c
t
o
r
y
.
s
u
p
p
o
r
t
.
F
a
c
t
o
r
y
B
e
a
n
R
e
g
i
s
t
r
y
S
u
p
p
o
r
t
.
g
e
t
O
b
j
e
c
t
F
r
o
m
F
a
c
t
o
r
y
B
e
a
n
(
F
a
c
t
o
r
y
B
e
a
n
R
e
g
i
s
t
r
y
S
u
p
p
o
r
t
.
j
a
v
a
:
102
)
a
t
o
r
g
.
s
p
r
i
n
g
f
r
a
m
e
w
o
r
k
.
b
e
a
n
s
.
f
a
c
t
o
r
y
.
s
u
p
p
o
r
t
.
A
b
s
t
r
a
c
t
B
e
a
n
F
a
c
t
o
r
y
.
g
e
t
O
b
j
e
c
t
F
o
r
B
e
a
n
I
n
s
t
a
n
c
e
(
A
b
s
t
r
a
c
t
B
e
a
n
F
a
c
t
o
r
y
.
j
a
v
a
:
1440
)
a
t
o
r
g
.
s
p
r
i
n
g
f
r
a
m
e
w
o
r
k
.
b
e
a
n
s
.
f
a
c
t
o
r
y
.
s
u
p
p
o
r
t
.
A
b
s
t
r
a
c
t
B
e
a
n
F
a
c
t
o
r
y
.
d
o
G
e
t
B
e
a
n
(
A
b
s
t
r
a
c
t
B
e
a
n
F
a
c
t
o
r
y
.
j
a
v
a
:
247
)
a
t
o
r
g
.
s
p
r
i
n
g
f
r
a
m
e
w
o
r
k
.
b
e
a
n
s
.
f
a
c
t
o
r
y
.
s
u
p
p
o
r
t
.
A
b
s
t
r
a
c
t
B
e
a
n
F
a
c
t
o
r
y
.
g
e
t
B
e
a
n
(
A
b
s
t
r
a
c
t
B
e
a
n
F
a
c
t
o
r
y
.
j
a
v
a
:
192
)
a
t
o
r
g
.
s
p
r
i
n
g
f
r
a
m
e
w
o
r
k
.
b
e
a
n
s
.
f
a
c
t
o
r
y
.
s
u
p
p
o
r
t
.
B
e
a
n
D
e
f
i
n
i
t
i
o
n
V
a
l
u
e
R
e
s
o
l
v
e
r
.
r
e
s
o
l
v
e
R
e
f
e
r
e
n
c
e
(
B
e
a
n
D
e
f
i
n
i
t
i
o
n
V
a
l
u
e
R
e
s
o
l
v
e
r
.
j
a
v
a
:
322
)
.
.
.
17
m
o
r
e
C
a
u
s
e
d
b
y
:
j
a
v
a
x
.
p
e
r
s
i
s
t
e
n
c
e
.
P
e
r
s
i
s
t
e
n
c
e
E
x
c
e
p
t
i
o
n
:
o
r
g
.
h
i
b
e
r
n
a
t
e
.
e
x
c
e
p
t
i
o
n
.
G
e
n
e
r
i
c
J
D
B
C
E
x
c
e
p
t
i
o
n
:
C
o
u
l
d
n
o
t
o
p
e
n
c
o
n
n
e
c
t
i
o
n
a
t
o
r
g
.
h
i
b
e
r
n
a
t
e
.
e
j
b
.
A
b
s
t
r
a
c
t
E
n
t
i
t
y
M
a
n
a
g
e
r
I
m
p
l
.
c
o
n
v
e
r
t
(
A
b
s
t
r
a
c
t
E
n
t
i
t
y
M
a
n
a
g
e
r
I
m
p
l
.
j
a
v
a
:
1387
)
a
t
o
r
g
.
h
i
b
e
r
n
a
t
e
.
e
j
b
.
A
b
s
t
r
a
c
t
E
n
t
i
t
y
M
a
n
a
g
e
r
I
m
p
l
.
c
o
n
v
e
r
t
(
A
b
s
t
r
a
c
t
E
n
t
i
t
y
M
a
n
a
g
e
r
I
m
p
l
.
j
a
v
a
:
1310
)
a
t
o
r
g
.
h
i
b
e
r
n
a
t
e
.
e
j
b
.
A
b
s
t
r
a
c
t
E
n
t
i
t
y
M
a
n
a
g
e
r
I
m
p
l
.
t
h
r
o
w
P
e
r
s
i
s
t
e
n
c
e
E
x
c
e
p
t
i
o
n
(
A
b
s
t
r
a
c
t
E
n
t
i
t
y
M
a
n
a
g
e
r
I
m
p
l
.
j
a
v
a
:
1397
)
a
t
o
r
g
.
h
i
b
e
r
n
a
t
e
.
e
j
b
.
T
r
a
n
s
a
c
t
i
o
n
I
m
p
l
.
b
e
g
i
n
(
T
r
a
n
s
a
c
t
i
o
n
I
m
p
l
.
j
a
v
a
:
62
)
a
t
c
o
m
.
c
l
o
u
d
e
r
a
.
e
n
t
e
r
p
r
i
s
e
.
A
b
s
t
r
a
c
t
W
r
a
p
p
e
d
E
n
t
i
t
y
M
a
n
a
g
e
r
.
b
e
g
i
n
F
o
r
R
o
l
l
b
a
c
k
A
n
d
R
e
a
d
o
n
l
y
(
A
b
s
t
r
a
c
t
W
r
a
p
p
e
d
E
n
t
i
t
y
M
a
n
a
g
e
r
.
j
a
v
a
:
89
)
a
t
c
o
m
.
c
l
o
u
d
e
r
a
.
e
n
t
e
r
p
r
i
s
e
.
d
b
u
t
i
l
.
D
b
U
t
i
l
.
i
s
I
n
n
o
D
b
E
n
a
b
l
e
d
(
D
b
U
t
i
l
.
j
a
v
a
:
554
)
a
t
c
o
m
.
c
l
o
u
d
e
r
a
.
s
e
r
v
e
r
.
c
m
f
.
b
o
o
t
s
t
r
a
p
.
E
n
t
i
t
y
M
a
n
a
g
e
r
F
a
c
t
o
r
y
B
e
a
n
.
c
h
e
c
k
M
y
s
q
l
T
a
b
l
e
E
n
g
i
n
e
T
y
p
e
(
E
n
t
i
t
y
M
a
n
a
g
e
r
F
a
c
t
o
r
y
B
e
a
n
.
j
a
v
a
:
139
)
a
t
c
o
m
.
c
l
o
u
d
e
r
a
.
s
e
r
v
e
r
.
c
m
f
.
b
o
o
t
s
t
r
a
p
.
E
n
t
i
t
y
M
a
n
a
g
e
r
F
a
c
t
o
r
y
B
e
a
n
.
g
e
t
O
b
j
e
c
t
(
E
n
t
i
t
y
M
a
n
a
g
e
r
F
a
c
t
o
r
y
B
e
a
n
.
j
a
v
a
:
122
)
a
t
c
o
m
.
c
l
o
u
d
e
r
a
.
s
e
r
v
e
r
.
c
m
f
.
b
o
o
t
s
t
r
a
p
.
E
n
t
i
t
y
M
a
n
a
g
e
r
F
a
c
t
o
r
y
B
e
a
n
.
g
e
t
O
b
j
e
c
t
(
E
n
t
i
t
y
M
a
n
a
g
e
r
F
a
c
t
o
r
y
B
e
a
n
.
j
a
v
a
:
65
)
a
t
o
r
g
.
s
p
r
i
n
g
f
r
a
m
e
w
o
r
k
.
b
e
a
n
s
.
f
a
c
t
o
r
y
.
s
u
p
p
o
r
t
.
F
a
c
t
o
r
y
B
e
a
n
R
e
g
i
s
t
r
y
S
u
p
p
o
r
t
.
d
o
G
e
t
O
b
j
e
c
t
F
r
o
m
F
a
c
t
o
r
y
B
e
a
n
(
F
a
c
t
o
r
y
B
e
a
n
R
e
g
i
s
t
r
y
S
u
p
p
o
r
t
.
j
a
v
a
:
142
)
.
.
.
22
m
o
r
e
C
a
u
s
e
d
b
y
:
o
r
g
.
h
i
b
e
r
n
a
t
e
.
e
x
c
e
p
t
i
o
n
.
G
e
n
e
r
i
c
J
D
B
C
E
x
c
e
p
t
i
o
n
:
C
o
u
l
d
n
o
t
o
p
e
n
c
o
n
n
e
c
t
i
o
n
a
t
o
r
g
.
h
i
b
e
r
n
a
t
e
.
e
x
c
e
p
t
i
o
n
.
i
n
t
e
r
n
a
l
.
S
t
a
n
d
a
r
d
S
Q
L
E
x
c
e
p
t
i
o
n
C
o
n
v
e
r
t
e
r
.
c
o
n
v
e
r
t
(
S
t
a
n
d
a
r
d
S
Q
L
E
x
c
e
p
t
i
o
n
C
o
n
v
e
r
t
e
r
.
j
a
v
a
:
54
)
a
t
o
r
g
.
h
i
b
e
r
n
a
t
e
.
e
n
g
i
n
e
.
j
d
b
c
.
s
p
i
.
S
q
l
E
x
c
e
p
t
i
o
n
H
e
l
p
e
r
.
c
o
n
v
e
r
t
(
S
q
l
E
x
c
e
p
t
i
o
n
H
e
l
p
e
r
.
j
a
v
a
:
125
)
a
t
o
r
g
.
h
i
b
e
r
n
a
t
e
.
e
n
g
i
n
e
.
j
d
b
c
.
s
p
i
.
S
q
l
E
x
c
e
p
t
i
o
n
H
e
l
p
e
r
.
c
o
n
v
e
r
t
(
S
q
l
E
x
c
e
p
t
i
o
n
H
e
l
p
e
r
.
j
a
v
a
:
110
)
a
t
o
r
g
.
h
i
b
e
r
n
a
t
e
.
e
n
g
i
n
e
.
j
d
b
c
.
i
n
t
e
r
n
a
l
.
L
o
g
i
c
a
l
C
o
n
n
e
c
t
i
o
n
I
m
p
l
.
o
b
t
a
i
n
C
o
n
n
e
c
t
i
o
n
(
L
o
g
i
c
a
l
C
o
n
n
e
c
t
i
o
n
I
m
p
l
.
j
a
v
a
:
221
)
a
t
o
r
g
.
h
i
b
e
r
n
a
t
e
.
e
n
g
i
n
e
.
j
d
b
c
.
i
n
t
e
r
n
a
l
.
L
o
g
i
c
a
l
C
o
n
n
e
c
t
i
o
n
I
m
p
l
.
g
e
t
C
o
n
n
e
c
t
i
o
n
(
L
o
g
i
c
a
l
C
o
n
n
e
c
t
i
o
n
I
m
p
l
.
j
a
v
a
:
157
)
a
t
o
r
g
.
h
i
b
e
r
n
a
t
e
.
e
n
g
i
n
e
.
t
r
a
n
s
a
c
t
i
o
n
.
i
n
t
e
r
n
a
l
.
j
d
b
c
.
J
d
b
c
T
r
a
n
s
a
c
t
i
o
n
.
d
o
B
e
g
i
n
(
J
d
b
c
T
r
a
n
s
a
c
t
i
o
n
.
j
a
v
a
:
67
)
a
t
o
r
g
.
h
i
b
e
r
n
a
t
e
.
e
n
g
i
n
e
.
t
r
a
n
s
a
c
t
i
o
n
.
s
p
i
.
A
b
s
t
r
a
c
t
T
r
a
n
s
a
c
t
i
o
n
I
m
p
l
.
b
e
g
i
n
(
A
b
s
t
r
a
c
t
T
r
a
n
s
a
c
t
i
o
n
I
m
p
l
.
j
a
v
a
:
160
)
a
t
o
r
g
.
h
i
b
e
r
n
a
t
e
.
i
n
t
e
r
n
a
l
.
S
e
s
s
i
o
n
I
m
p
l
.
b
e
g
i
n
T
r
a
n
s
a
c
t
i
o
n
(
S
e
s
s
i
o
n
I
m
p
l
.
j
a
v
a
:
1426
)
a
t
o
r
g
.
h
i
b
e
r
n
a
t
e
.
e
j
b
.
T
r
a
n
s
a
c
t
i
o
n
I
m
p
l
.
b
e
g
i
n
(
T
r
a
n
s
a
c
t
i
o
n
I
m
p
l
.
j
a
v
a
:
59
)
.
.
.
28
m
o
r
e
C
a
u
s
e
d
b
y
:
j
a
v
a
.
s
q
l
.
S
Q
L
E
x
c
e
p
t
i
o
n
:
C
o
n
n
e
c
t
i
o
n
s
c
o
u
l
d
n
o
t
b
e
a
c
q
u
i
r
e
d
f
r
o
m
t
h
e
u
n
d
e
r
l
y
i
n
g
d
a
t
a
b
a
s
e
!
a
t
c
o
m
.
m
c
h
a
n
g
e
.
v
2.
s
q
l
.
S
q
l
U
t
i
l
s
.
t
o
S
Q
L
E
x
c
e
p
t
i
o
n
(
S
q
l
U
t
i
l
s
.
j
a
v
a
:
118
)
a
t
c
o
m
.
m
c
h
a
n
g
e
.
v
2.
c
3
p
0.
i
m
p
l
.
C
3
P
0
P
o
o
l
e
d
C
o
n
n
e
c
t
i
o
n
P
o
o
l
.
c
h
e
c
k
o
u
t
P
o
o
l
e
d
C
o
n
n
e
c
t
i
o
n
(
C
3
P
0
P
o
o
l
e
d
C
o
n
n
e
c
t
i
o
n
P
o
o
l
.
j
a
v
a
:
692
)
a
t
c
o
m
.
m
c
h
a
n
g
e
.
v
2.
c
3
p
0.
i
m
p
l
.
A
b
s
t
r
a
c
t
P
o
o
l
B
a
c
k
e
d
D
a
t
a
S
o
u
r
c
e
.
g
e
t
C
o
n
n
e
c
t
i
o
n
(
A
b
s
t
r
a
c
t
P
o
o
l
B
a
c
k
e
d
D
a
t
a
S
o
u
r
c
e
.
j
a
v
a
:
140
)
a
t
o
r
g
.
h
i
b
e
r
n
a
t
e
.
s
e
r
v
i
c
e
.
j
d
b
c
.
c
o
n
n
e
c
t
i
o
n
s
.
i
n
t
e
r
n
a
l
.
C
3
P
0
C
o
n
n
e
c
t
i
o
n
P
r
o
v
i
d
e
r
.
g
e
t
C
o
n
n
e
c
t
i
o
n
(
C
3
P
0
C
o
n
n
e
c
t
i
o
n
P
r
o
v
i
d
e
r
.
j
a
v
a
:
84
)
a
t
o
r
g
.
h
i
b
e
r
n
a
t
e
.
i
n
t
e
r
n
a
l
.
A
b
s
t
r
a
c
t
S
e
s
s
i
o
n
I
m
p
l
1.getObject(AbstractBeanFactory.java:293) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:290) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:192) at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:585) at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:895) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:425) at com.cloudera.server.cmf.Main.bootstrapSpringContext(Main.java:393) at com.cloudera.server.cmf.Main.<init>(Main.java:243) at com.cloudera.server.cmf.Main.main(Main.java:216) Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'entityManagerFactoryBean': FactoryBean threw exception on object creation; nested exception is javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: Could not open connection at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.doGetObjectFromFactoryBean(FactoryBeanRegistrySupport.java:149) at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.getObjectFromFactoryBean(FactoryBeanRegistrySupport.java:102) at org.springframework.beans.factory.support.AbstractBeanFactory.getObjectForBeanInstance(AbstractBeanFactory.java:1440) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:247) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:192) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:322) ... 17 more Caused by: javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: Could not open connection at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1387) at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1310) at org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:1397) at org.hibernate.ejb.TransactionImpl.begin(TransactionImpl.java:62) at com.cloudera.enterprise.AbstractWrappedEntityManager.beginForRollbackAndReadonly(AbstractWrappedEntityManager.java:89) at com.cloudera.enterprise.dbutil.DbUtil.isInnoDbEnabled(DbUtil.java:554) at com.cloudera.server.cmf.bootstrap.EntityManagerFactoryBean.checkMysqlTableEngineType(EntityManagerFactoryBean.java:139) at com.cloudera.server.cmf.bootstrap.EntityManagerFactoryBean.getObject(EntityManagerFactoryBean.java:122) at com.cloudera.server.cmf.bootstrap.EntityManagerFactoryBean.getObject(EntityManagerFactoryBean.java:65) at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.doGetObjectFromFactoryBean(FactoryBeanRegistrySupport.java:142) ... 22 more Caused by: org.hibernate.exception.GenericJDBCException: Could not open connection at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:54) at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125) at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110) at org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.obtainConnection(LogicalConnectionImpl.java:221) at org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.getConnection(LogicalConnectionImpl.java:157) at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doBegin(JdbcTransaction.java:67) at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.begin(AbstractTransactionImpl.java:160) at org.hibernate.internal.SessionImpl.beginTransaction(SessionImpl.java:1426) at org.hibernate.ejb.TransactionImpl.begin(TransactionImpl.java:59) ... 28 more Caused by: java.sql.SQLException: Connections could not be acquired from the underlying database! at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:118) at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:692) at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:140) at org.hibernate.service.jdbc.connections.internal.C3P0ConnectionProvider.getConnection(C3P0ConnectionProvider.java:84) at org.hibernate.internal.AbstractSessionImpl
1.getObject(AbstractBeanFactory.java:293)atorg.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)atorg.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:290)atorg.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:192)atorg.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:585)atorg.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:895)atorg.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:425)atcom.cloudera.server.cmf.Main.bootstrapSpringContext(Main.java:393)atcom.cloudera.server.cmf.Main.<init>(Main.java:243)atcom.cloudera.server.cmf.Main.main(Main.java:216)Causedby:org.springframework.beans.factory.BeanCreationException:Errorcreatingbeanwithname′entityManagerFactoryBean′:FactoryBeanthrewexceptiononobjectcreation;nestedexceptionisjavax.persistence.PersistenceException:org.hibernate.exception.GenericJDBCException:Couldnotopenconnectionatorg.springframework.beans.factory.support.FactoryBeanRegistrySupport.doGetObjectFromFactoryBean(FactoryBeanRegistrySupport.java:149)atorg.springframework.beans.factory.support.FactoryBeanRegistrySupport.getObjectFromFactoryBean(FactoryBeanRegistrySupport.java:102)atorg.springframework.beans.factory.support.AbstractBeanFactory.getObjectForBeanInstance(AbstractBeanFactory.java:1440)atorg.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:247)atorg.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:192)atorg.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:322)...17moreCausedby:javax.persistence.PersistenceException:org.hibernate.exception.GenericJDBCException:Couldnotopenconnectionatorg.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1387)atorg.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1310)atorg.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:1397)atorg.hibernate.ejb.TransactionImpl.begin(TransactionImpl.java:62)atcom.cloudera.enterprise.AbstractWrappedEntityManager.beginForRollbackAndReadonly(AbstractWrappedEntityManager.java:89)atcom.cloudera.enterprise.dbutil.DbUtil.isInnoDbEnabled(DbUtil.java:554)atcom.cloudera.server.cmf.bootstrap.EntityManagerFactoryBean.checkMysqlTableEngineType(EntityManagerFactoryBean.java:139)atcom.cloudera.server.cmf.bootstrap.EntityManagerFactoryBean.getObject(EntityManagerFactoryBean.java:122)atcom.cloudera.server.cmf.bootstrap.EntityManagerFactoryBean.getObject(EntityManagerFactoryBean.java:65)atorg.springframework.beans.factory.support.FactoryBeanRegistrySupport.doGetObjectFromFactoryBean(FactoryBeanRegistrySupport.java:142)...22moreCausedby:org.hibernate.exception.GenericJDBCException:Couldnotopenconnectionatorg.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:54)atorg.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125)atorg.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110)atorg.hibernate.engine.jdbc.internal.LogicalConnectionImpl.obtainConnection(LogicalConnectionImpl.java:221)atorg.hibernate.engine.jdbc.internal.LogicalConnectionImpl.getConnection(LogicalConnectionImpl.java:157)atorg.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doBegin(JdbcTransaction.java:67)atorg.hibernate.engine.transaction.spi.AbstractTransactionImpl.begin(AbstractTransactionImpl.java:160)atorg.hibernate.internal.SessionImpl.beginTransaction(SessionImpl.java:1426)atorg.hibernate.ejb.TransactionImpl.begin(TransactionImpl.java:59)...28moreCausedby:java.sql.SQLException:Connectionscouldnotbeacquiredfromtheunderlyingdatabase!atcom.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:118)atcom.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:692)atcom.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:140)atorg.hibernate.service.jdbc.connections.internal.C3P0ConnectionProvider.getConnection(C3P0ConnectionProvider.java:84)atorg.hibernate.internal.AbstractSessionImplNonContextualJdbcConnectionAccess.obtainConnection(AbstractSessionImpl.java:292)
at org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.obtainConnection(LogicalConnectionImpl.java:214)
… 33 more
Caused by: com.mchange.v2.resourcepool.CannotAcquireResourceException: A ResourcePool could not acquire a resource from its primary factory or source.
at com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicResourcePool.java:1469)
at com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java:644)
at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:554)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutAndMarkConnectionInUse(C3P0PooledConnectionPool.java:758)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:685)
… 37 more
Caused by: java.sql.SQLException: Access denied for user ‘scm’@‘master’ (using password: YES)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:965)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3978)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3914)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:871)
at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1714)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1224)
at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2199)
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2230)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2025)
at com.mysql.jdbc.ConnectionImpl.(ConnectionImpl.java:778)
at com.mysql.jdbc.JDBC4Connection.(JDBC4Connection.java:47)
at sun.reflect.GeneratedConstructorAccessor5.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:386)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:330)
at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:175)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:220)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:206)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:203)
at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1138)
at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1125)
at com.mchange.v2.resourcepool.BasicResourcePool.access
700
(
B
a
s
i
c
R
e
s
o
u
r
c
e
P
o
o
l
.
j
a
v
a
:
44
)
a
t
c
o
m
.
m
c
h
a
n
g
e
.
v
2.
r
e
s
o
u
r
c
e
p
o
o
l
.
B
a
s
i
c
R
e
s
o
u
r
c
e
P
o
o
l
700(BasicResourcePool.java:44) at com.mchange.v2.resourcepool.BasicResourcePool
700(BasicResourcePool.java:44)atcom.mchange.v2.resourcepool.BasicResourcePoolScatteredAcquireTask.run(BasicResourcePool.java:1870)
at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:696)
复制代码
报错原因:
日志里面写的很清楚,
原因:Access denied for user ‘scm’@‘master’ (using password: YES)
翻译:用户“scm”@“主机”拒绝访问(使用密码:是)
为什么会拒绝访问呢?一头雾水啊!!!
分析以下,拒绝访问可能是没有权限访问,或者MySQL数据库没有启动。
首先排除MySQL数据库没有启动的原因,接下来就是寻找没有访问权限的原因了。
根据百度的结果,大部分造成此种结果的原因是没有提供MySQL的远程访问权限。
但是我很确定当时我已经设置了MySQL数据库开放远程访问权限。
走投无路,只能死马当作活马医了,重新开放权限。
报错解决:
[root@master sources]# mysql -uroot -proot
复制代码
mysql> use mysql;
mysql> select host,user,password from user;
mysql> update user set password=password(‘root’) where user=‘root’;
mysql> grant all privileges on . to ‘root’@‘master’ identified by ‘root’; --‘root’@'%'中 %代表所有主机
复制代码
但是执行到上面这一步的时候又报错:
Access denied for user ‘root’@‘master’ (using password: YES)
这次我是彻底懵逼了,为了解决权限的错误执行的命令竟然报出权限的错误。
在网上找了很长时间也没有找到解决方案,于是我只能重装数据库了。
重装完成数据库之后,再次执行赋予远程登录的权限就成功了。
复制代码
mysql> use mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> select host,user,password from user;
±----------±-----±------------------------------------------+
| host | user | password |
±----------±-----±------------------------------------------+
| localhost | root | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B |
| master | root | *D2338747885A51AACEED4A7276143CB759A5B844 |
| 127.0.0.1 | root | *D2338747885A51AACEED4A7276143CB759A5B844 |
| ::1 | root | *D2338747885A51AACEED4A7276143CB759A5B844 |
±----------±-----±------------------------------------------+
4 rows in set (0.00 sec)
mysql> update user set password=password(‘root’) where user=‘root’;
Query OK, 3 rows affected (0.00 sec)
Rows matched: 4 Changed: 3 Warnings: 0
mysql> grant all privileges on . to ‘root’@‘master’ identified by ‘root’;
Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql> exit
Bye
复制代码
然后再执行数据库初始化
/opt/cm-5.15.1/share/cmf/schema/scm_prepare_database.sh mysql cm -hmaster -uroot -proot --scm-host master scm scm scm
参数分别是: 数据库类型 数据库名称 -h数据库主机名 -u数据库用户名 -p数据库密码–scm-host cmserver主机名 scm scm scm
主节点:通过/bigdata/cm-5.15.1/etc/init.d/cloudera-scm-server start启动服务端
[root@master /]# /opt/cm-5.15.1/etc/init.d/cloudera-scm-server start
这个时候cloudera-scm-server就不会挂掉了