报错信息:
Exception in thread “main” org.apache.flink.table.api.TableException: Failed to execute sql
at org.apache.flink.table.api.internal.TableEnvironmentImpl.executeQueryOperation(TableEnvironmentImpl.java:810)
at org.apache.flink.table.api.internal.TableEnvironmentImpl.executeInternal(TableEnvironmentImpl.java:1223)
at org.apache.flink.table.api.internal.TableImpl.execute(TableImpl.java:577)
at org.caigou._1_cdc_mysql._2.main(_2.java:1159)
Caused by: org.apache.flink.util.FlinkException: Failed to execute job ‘collect’.
at org.apache.flink.streaming.api.environment.StreamExecutionEnvironment.executeAsync(StreamExecutionEnvironment.java:1970)
at org.apache.flink.table.planner.delegation.ExecutorBase.executeAsync(ExecutorBase.java:55)
at org.apache.flink.table.api.internal.TableEnvironmentImpl.executeQueryOperation(TableEnvironmentImpl.java:793)
… 3 more
Caused by: java.lang.RuntimeException: Error while waiting for job to be initialized
at org.apache.flink.client.ClientUtils.waitUntilJobInitializationFinished(ClientUtils.java:160)
at org.apache.flink.client.program.PerJobMiniClusterFactory.lambda$submitJob
2
(
P
e
r
J
o
b
M
i
n
i
C
l
u
s
t
e
r
F
a
c
t
o
r
y
.
j
a
v
a
:
83
)
a
t
o
r
g
.
a
p
a
c
h
e
.
f
l
i
n
k
.
u
t
i
l
.
f
u
n
c
t
i
o
n
.
F
u
n
c
t
i
o
n
U
t
i
l
s
.
l
a
m
b
d
a
2(PerJobMiniClusterFactory.java:83) at org.apache.flink.util.function.FunctionUtils.lambda
2(PerJobMiniClusterFactory.java:83)atorg.apache.flink.util.function.FunctionUtils.lambdauncheckedFunction
2
(
F
u
n
c
t
i
o
n
U
t
i
l
s
.
j
a
v
a
:
73
)
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
.
C
o
m
p
l
e
t
a
b
l
e
F
u
t
u
r
e
2(FunctionUtils.java:73) at java.base/java.util.concurrent.CompletableFuture
2(FunctionUtils.java:73)atjava.base/java.util.concurrent.CompletableFutureUniApply.tryFire(CompletableFuture.java:646)
at java.base/java.util.concurrent.CompletableFuture
C
o
m
p
l
e
t
i
o
n
.
e
x
e
c
(
C
o
m
p
l
e
t
a
b
l
e
F
u
t
u
r
e
.
j
a
v
a
:
483
)
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
o
r
k
J
o
i
n
T
a
s
k
.
d
o
E
x
e
c
(
F
o
r
k
J
o
i
n
T
a
s
k
.
j
a
v
a
:
373
)
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
o
r
k
J
o
i
n
P
o
o
l
Completion.exec(CompletableFuture.java:483) at java.base/java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:373) at java.base/java.util.concurrent.ForkJoinPool
Completion.exec(CompletableFuture.java:483)atjava.base/java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:373)atjava.base/java.util.concurrent.ForkJoinPoolWorkQueue.topLevelExec(ForkJoinPool.java:1182)
at java.base/java.util.concurrent.ForkJoinPool.scan(ForkJoinPool.java:1655)
at java.base/java.util.concurrent.ForkJoinPool.runWorker(ForkJoinPool.java:1622)
at java.base/java.util.concurrent.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:165)
Caused by: java.util.concurrent.ExecutionException: java.util.concurrent.TimeoutException: Invocation of public default java.util.concurrent.CompletableFuture org.apache.flink.runtime.webmonitor.RestfulGateway.requestJobStatus(org.apache.flink.api.common.JobID,org.apache.flink.api.common.time.Time) timed out.
at java.base/java.util.concurrent.CompletableFuture.reportGet(CompletableFuture.java:396)
at java.base/java.util.concurrent.CompletableFuture.get(CompletableFuture.java:2073)
at org.apache.flink.client.program.PerJobMiniClusterFactory.lambda$null
0
(
P
e
r
J
o
b
M
i
n
i
C
l
u
s
t
e
r
F
a
c
t
o
r
y
.
j
a
v
a
:
89
)
a
t
o
r
g
.
a
p
a
c
h
e
.
f
l
i
n
k
.
c
l
i
e
n
t
.
C
l
i
e
n
t
U
t
i
l
s
.
w
a
i
t
U
n
t
i
l
J
o
b
I
n
i
t
i
a
l
i
z
a
t
i
o
n
F
i
n
i
s
h
e
d
(
C
l
i
e
n
t
U
t
i
l
s
.
j
a
v
a
:
144
)
.
.
.
9
m
o
r
e
C
a
u
s
e
d
b
y
:
j
a
v
a
.
u
t
i
l
.
c
o
n
c
u
r
r
e
n
t
.
T
i
m
e
o
u
t
E
x
c
e
p
t
i
o
n
:
I
n
v
o
c
a
t
i
o
n
o
f
p
u
b
l
i
c
d
e
f
a
u
l
t
j
a
v
a
.
u
t
i
l
.
c
o
n
c
u
r
r
e
n
t
.
C
o
m
p
l
e
t
a
b
l
e
F
u
t
u
r
e
o
r
g
.
a
p
a
c
h
e
.
f
l
i
n
k
.
r
u
n
t
i
m
e
.
w
e
b
m
o
n
i
t
o
r
.
R
e
s
t
f
u
l
G
a
t
e
w
a
y
.
r
e
q
u
e
s
t
J
o
b
S
t
a
t
u
s
(
o
r
g
.
a
p
a
c
h
e
.
f
l
i
n
k
.
a
p
i
.
c
o
m
m
o
n
.
J
o
b
I
D
,
o
r
g
.
a
p
a
c
h
e
.
f
l
i
n
k
.
a
p
i
.
c
o
m
m
o
n
.
t
i
m
e
.
T
i
m
e
)
t
i
m
e
d
o
u
t
.
a
t
j
d
k
.
p
r
o
x
y
2
/
j
d
k
.
p
r
o
x
y
2.
0(PerJobMiniClusterFactory.java:89) at org.apache.flink.client.ClientUtils.waitUntilJobInitializationFinished(ClientUtils.java:144) ... 9 more Caused by: java.util.concurrent.TimeoutException: Invocation of public default java.util.concurrent.CompletableFuture org.apache.flink.runtime.webmonitor.RestfulGateway.requestJobStatus(org.apache.flink.api.common.JobID,org.apache.flink.api.common.time.Time) timed out. at jdk.proxy2/jdk.proxy2.
0(PerJobMiniClusterFactory.java:89)atorg.apache.flink.client.ClientUtils.waitUntilJobInitializationFinished(ClientUtils.java:144)...9moreCausedby:java.util.concurrent.TimeoutException:Invocationofpublicdefaultjava.util.concurrent.CompletableFutureorg.apache.flink.runtime.webmonitor.RestfulGateway.requestJobStatus(org.apache.flink.api.common.JobID,org.apache.flink.api.common.time.Time)timedout.atjdk.proxy2/jdk.proxy2.Proxy175.requestJobStatus(Unknown Source)
at org.apache.flink.runtime.minicluster.MiniCluster.lambda$getJobStatus
6
(
M
i
n
i
C
l
u
s
t
e
r
.
j
a
v
a
:
704
)
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
.
C
o
m
p
l
e
t
a
b
l
e
F
u
t
u
r
e
.
u
n
i
A
p
p
l
y
N
o
w
(
C
o
m
p
l
e
t
a
b
l
e
F
u
t
u
r
e
.
j
a
v
a
:
684
)
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
.
C
o
m
p
l
e
t
a
b
l
e
F
u
t
u
r
e
.
u
n
i
A
p
p
l
y
S
t
a
g
e
(
C
o
m
p
l
e
t
a
b
l
e
F
u
t
u
r
e
.
j
a
v
a
:
662
)
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
.
C
o
m
p
l
e
t
a
b
l
e
F
u
t
u
r
e
.
t
h
e
n
A
p
p
l
y
(
C
o
m
p
l
e
t
a
b
l
e
F
u
t
u
r
e
.
j
a
v
a
:
2168
)
a
t
o
r
g
.
a
p
a
c
h
e
.
f
l
i
n
k
.
r
u
n
t
i
m
e
.
m
i
n
i
c
l
u
s
t
e
r
.
M
i
n
i
C
l
u
s
t
e
r
.
r
u
n
D
i
s
p
a
t
c
h
e
r
C
o
m
m
a
n
d
(
M
i
n
i
C
l
u
s
t
e
r
.
j
a
v
a
:
751
)
a
t
o
r
g
.
a
p
a
c
h
e
.
f
l
i
n
k
.
r
u
n
t
i
m
e
.
m
i
n
i
c
l
u
s
t
e
r
.
M
i
n
i
C
l
u
s
t
e
r
.
g
e
t
J
o
b
S
t
a
t
u
s
(
M
i
n
i
C
l
u
s
t
e
r
.
j
a
v
a
:
703
)
a
t
o
r
g
.
a
p
a
c
h
e
.
f
l
i
n
k
.
c
l
i
e
n
t
.
p
r
o
g
r
a
m
.
P
e
r
J
o
b
M
i
n
i
C
l
u
s
t
e
r
F
a
c
t
o
r
y
.
l
a
m
b
d
a
6(MiniCluster.java:704) at java.base/java.util.concurrent.CompletableFuture.uniApplyNow(CompletableFuture.java:684) at java.base/java.util.concurrent.CompletableFuture.uniApplyStage(CompletableFuture.java:662) at java.base/java.util.concurrent.CompletableFuture.thenApply(CompletableFuture.java:2168) at org.apache.flink.runtime.minicluster.MiniCluster.runDispatcherCommand(MiniCluster.java:751) at org.apache.flink.runtime.minicluster.MiniCluster.getJobStatus(MiniCluster.java:703) at org.apache.flink.client.program.PerJobMiniClusterFactory.lambda
6(MiniCluster.java:704)atjava.base/java.util.concurrent.CompletableFuture.uniApplyNow(CompletableFuture.java:684)atjava.base/java.util.concurrent.CompletableFuture.uniApplyStage(CompletableFuture.java:662)atjava.base/java.util.concurrent.CompletableFuture.thenApply(CompletableFuture.java:2168)atorg.apache.flink.runtime.minicluster.MiniCluster.runDispatcherCommand(MiniCluster.java:751)atorg.apache.flink.runtime.minicluster.MiniCluster.getJobStatus(MiniCluster.java:703)atorg.apache.flink.client.program.PerJobMiniClusterFactory.lambdanullKaTeX parse error: Expected 'EOF', got '#' at position 153: …pc/dispatcher_2#̲673109285]] aft…$anonfun
2.
a
p
p
l
y
(
A
s
k
S
u
p
p
o
r
t
.
s
c
a
l
a
:
635
)
a
t
a
k
k
a
.
p
a
t
t
e
r
n
.
P
r
o
m
i
s
e
A
c
t
o
r
R
e
f
2.apply(AskSupport.scala:635) at akka.pattern.PromiseActorRef
2.apply(AskSupport.scala:635)atakka.pattern.PromiseActorRef$anonfun
2.
a
p
p
l
y
(
A
s
k
S
u
p
p
o
r
t
.
s
c
a
l
a
:
635
)
a
t
a
k
k
a
.
p
a
t
t
e
r
n
.
P
r
o
m
i
s
e
A
c
t
o
r
R
e
f
2.apply(AskSupport.scala:635) at akka.pattern.PromiseActorRef
2.apply(AskSupport.scala:635)atakka.pattern.PromiseActorRef$anonfun
1.
a
p
p
l
y
1.apply
1.applymcV
s
p
(
A
s
k
S
u
p
p
o
r
t
.
s
c
a
l
a
:
648
)
a
t
a
k
k
a
.
a
c
t
o
r
.
S
c
h
e
d
u
l
e
r
sp(AskSupport.scala:648) at akka.actor.Scheduler
sp(AskSupport.scala:648)atakka.actor.Scheduler$anon
4.
r
u
n
(
S
c
h
e
d
u
l
e
r
.
s
c
a
l
a
:
205
)
a
t
s
c
a
l
a
.
c
o
n
c
u
r
r
e
n
t
.
F
u
t
u
r
e
4.run(Scheduler.scala:205) at scala.concurrent.Future
4.run(Scheduler.scala:205)atscala.concurrent.FutureInternalCallbackExecutor
.
u
n
b
a
t
c
h
e
d
E
x
e
c
u
t
e
(
F
u
t
u
r
e
.
s
c
a
l
a
:
601
)
a
t
s
c
a
l
a
.
c
o
n
c
u
r
r
e
n
t
.
B
a
t
c
h
i
n
g
E
x
e
c
u
t
o
r
.unbatchedExecute(Future.scala:601) at scala.concurrent.BatchingExecutor
.unbatchedExecute(Future.scala:601)atscala.concurrent.BatchingExecutorclass.execute(BatchingExecutor.scala:109)
at scala.concurrent.Future
I
n
t
e
r
n
a
l
C
a
l
l
b
a
c
k
E
x
e
c
u
t
o
r
InternalCallbackExecutor
InternalCallbackExecutor.execute(Future.scala:599)
at akka.actor.LightArrayRevolverScheduler
T
a
s
k
H
o
l
d
e
r
.
e
x
e
c
u
t
e
T
a
s
k
(
L
i
g
h
t
A
r
r
a
y
R
e
v
o
l
v
e
r
S
c
h
e
d
u
l
e
r
.
s
c
a
l
a
:
328
)
a
t
a
k
k
a
.
a
c
t
o
r
.
L
i
g
h
t
A
r
r
a
y
R
e
v
o
l
v
e
r
S
c
h
e
d
u
l
e
r
TaskHolder.executeTask(LightArrayRevolverScheduler.scala:328) at akka.actor.LightArrayRevolverScheduler
TaskHolder.executeTask(LightArrayRevolverScheduler.scala:328)atakka.actor.LightArrayRevolverScheduler$anon$4.executeBucket
1
(
L
i
g
h
t
A
r
r
a
y
R
e
v
o
l
v
e
r
S
c
h
e
d
u
l
e
r
.
s
c
a
l
a
:
279
)
a
t
a
k
k
a
.
a
c
t
o
r
.
L
i
g
h
t
A
r
r
a
y
R
e
v
o
l
v
e
r
S
c
h
e
d
u
l
e
r
1(LightArrayRevolverScheduler.scala:279) at akka.actor.LightArrayRevolverScheduler
1(LightArrayRevolverScheduler.scala:279)atakka.actor.LightArrayRevolverScheduler$anon
4.
n
e
x
t
T
i
c
k
(
L
i
g
h
t
A
r
r
a
y
R
e
v
o
l
v
e
r
S
c
h
e
d
u
l
e
r
.
s
c
a
l
a
:
283
)
a
t
a
k
k
a
.
a
c
t
o
r
.
L
i
g
h
t
A
r
r
a
y
R
e
v
o
l
v
e
r
S
c
h
e
d
u
l
e
r
4.nextTick(LightArrayRevolverScheduler.scala:283) at akka.actor.LightArrayRevolverScheduler
4.nextTick(LightArrayRevolverScheduler.scala:283)atakka.actor.LightArrayRevolverScheduler$anon$4.run(LightArrayRevolverScheduler.scala:235)
at java.base/java.lang.Thread.run(Thread.java:840)
解决方案:添加2个配置
Configuration conf = new Configuration();
//设置WebUI绑定的本地端口
conf.setString(RestOptions.BIND_PORT, "8081");
// 设置 akka.ask.timeout 参数为 100s
conf.setString("akka.ask.timeout", "100s");
//创建执行环境
StreamExecutionEnvironment env =
StreamExecutionEnvironment.createLocalEnvironmentWithWebUI(conf);