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

["little-tomato (Jira)" <ji...@apache.org>]

little-tomato created FLINK-19754:
-------------------------------------

             Summary: Cannot have more than one execute() or executeAsync() call in a single environment.
                 Key: FLINK-19754
                 URL: https://issues.apache.org/jira/browse/FLINK-19754
             Project: Flink
          Issue Type: Bug
          Components: Table SQL / API
    Affects Versions: 1.11.2
         Environment: 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"));
            Reporter: little-tomato


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]



--
This message was sent by Atlassian Jira
(v8.3.4#803005)