[FLINK-19754] Cannot have more than one execute() or executeAsync() call in a single environment.

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Not A Problem
• Affects Version/s: 1.11.2
• Component/s: Table SQL / API
• Assignee: Unassigned
• Reporter: little-tomato
• Created: 22/Oct/20 00:43
• Updated: 12/Nov/21 09:15
• Resolved: 29/Apr/21 15:32

Description

I run this code on my Standalone Cluster. When i submit the job,the error log is as follows:

2020-10-20 11:53:42,969 WARN org.apache.flink.client.deployment.application.DetachedApplicationRunner [] - Could not execute application: 
 org.apache.flink.client.program.ProgramInvocationException: The main method caused an error: Cannot have more than one execute() or executeAsync() call in a single environment.
 at org.apache.flink.client.program.PackagedProgram.callMainMethod(PackagedProgram.java:302) ~[flink-clients_2.12-1.11.0.jar:1.11.0]
 at org.apache.flink.client.program.PackagedProgram.invokeInteractiveModeForExecution(PackagedProgram.java:198) ~[flink-clients_2.12-1.11.0.jar:1.11.0]
 at org.apache.flink.client.ClientUtils.executeProgram(ClientUtils.java:149) ~[flink-clients_2.12-1.11.0.jar:1.11.0]
 at org.apache.flink.client.deployment.application.DetachedApplicationRunner.tryExecuteJobs(DetachedApplicationRunner.java:78) ~[flink-clients_2.12-1.11.0.jar:1.11.0]
 at org.apache.flink.client.deployment.application.DetachedApplicationRunner.run(DetachedApplicationRunner.java:67) ~[flink-clients_2.12-1.11.0.jar:1.11.0]
 at org.apache.flink.runtime.webmonitor.handlers.JarRunHandler.lambda$handleRequest$0(JarRunHandler.java:100) ~[flink-dist_2.12-1.11.2.jar:1.11.2]
 at java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1590) [?:1.8.0_221]
 at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) [?:1.8.0_221]
 at java.util.concurrent.FutureTask.run(FutureTask.java:266) [?:1.8.0_221]
 at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180) [?:1.8.0_221]
 at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293) [?:1.8.0_221]
 at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_221]
 at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_221]
 at java.lang.Thread.run(Thread.java:748) [?:1.8.0_221]
 Caused by: org.apache.flink.util.FlinkRuntimeException: Cannot have more than one execute() or executeAsync() call in a single environment.
 at org.apache.flink.client.program.StreamContextEnvironment.validateAllowedExecution(StreamContextEnvironment.java:139) ~[flink-clients_2.12-1.11.0.jar:1.11.0]
 at org.apache.flink.client.program.StreamContextEnvironment.executeAsync(StreamContextEnvironment.java:127) ~[flink-clients_2.12-1.11.0.jar:1.11.0]
 at org.apache.flink.client.program.StreamContextEnvironment.execute(StreamContextEnvironment.java:76) ~[flink-clients_2.12-1.11.0.jar:1.11.0]
 at org.apache.flink.streaming.api.environment.StreamExecutionEnvironment.execute(StreamExecutionEnvironment.java:1697) ~[flink-dist_2.12-1.11.2.jar:1.11.2]
 at cn.cuiot.dmp.ruleengine.job.RuleEngineJob.main(RuleEngineJob.java:556) ~[?:?]
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_221]
 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_221]
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_221]
 at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_221]
 at org.apache.flink.client.program.PackagedProgram.callMainMethod(PackagedProgram.java:288) ~[flink-clients_2.12-1.11.0.jar:1.11.0]

my code is:

final StreamExecutionEnvironment env = StreamExecutionEnvironment.getExecutionEnvironment();
 EnvironmentSettings bsSettings = EnvironmentSettings.newInstance().useBlinkPlanner().inStreamingMode().build();
 StreamTableEnvironment tEnv = StreamTableEnvironment.create(env, bsSettings);
 ...
 FlinkKafkaConsumer<String> myConsumer = new FlinkKafkaConsumer<String>("kafkatopic", new SimpleStringSchema(), properties);
 myConsumer.setStartFromLatest();

DataStream<String> kafkaDataStream = env.addSource(myConsumer);

SingleOutputStreamOperator<MessageInfo> sourceStream = kafkaDataStream
 .map(new MapFunction<String, MessageInfo>()

{ ... }

);

DataStream<Row> dataStreamRow = sourceStream.map(new MyMapFunction()).filter(new RuleDataProccessFunction()).map(new MapFunction<MessageInfo, Row>()

{ private static final long serialVersionUID = 1L; @Override public Row map(MessageInfo value) throws Exception \\{ ... }

}).returns(new RowTypeInfo(rowTypeArr, fieldArr));

tEnv.registerFunction("test",new TestFunction());
 Table table = tEnv.fromDataStream(dataStreamRow, fieldStr);
 tEnv.createTemporaryView("mytable", table);

String ddl = "CREATE TABLE user_log_1155 ...from kafka topic:user_log_1155";
 tEnv.executeSql(ddl);

String ddl1 = "CREATE TABLE user_test_1155 ...from kafka topic:user_test_1155";
 tEnv.executeSql(ddl);

StatementSet stmtSet = tEnv.createStatementSet();
 stmtSet.addInsertSql("INSERT INTO user_log_1155 SELECT xxx from mytable");
 stmtSet.addInsertSql("INSERT INTO user_test_1155 SELECT xxx from mytable");
 stmtSet.execute();
 env.execute(requestPrm.getString("xxx"));

Issue Links

• is related to: FLINK-23161 Cannot have more than one execute() or executeAsync() call in a single environment.