ilsl1007 opened a new issue, #6581: URL: https://github.com/apache/seatunnel/issues/6581
### Search before asking - [X] I had searched in the [issues](https://github.com/apache/seatunnel/issues?q=is%3Aissue+label%3A%22bug%22) and found no similar issues. ### What happened The second call to the submit job API resulted in an error, The error occurred during the second call, which only modified the query's time range. ### SeaTunnel Version 2.3.4 ### SeaTunnel Config ```conf # first call: { "env": { "execution.parallelism": 1, "job.mode": "BATCH" }, "source": [ { "plugin_name": "TDengine", "url": "jdbc:TAOS-RS://192.168.100.1:6041/", "username": "root", "password": "taosdata", "database": "test", "stable": "meters", "lower_bound": "2017-07-14 02:40:00.000", "upper_bound": "2017-07-14 02:40:00.006", "result_table_name": "tdengine_result" } ], "sink": [ { "plugin_name": "TDengine", "url": "jdbc:TAOS-RS://192.168.100.2:6041/", "username": "root", "password": "taosdata", "database": "test", "stable": "meters", "timezone": "UTC" } ] } # second call: { "env": { "execution.parallelism": 1, "job.mode": "BATCH" }, "source": [ { "plugin_name": "TDengine", "url": "jdbc:TAOS-RS://192.168.100.1:6041/", "username": "root", "password": "taosdata", "database": "test", "stable": "meters", "lower_bound": "2017-07-14 02:40:00.006", "upper_bound": "2017-07-14 02:40:00.010", "result_table_name": "tdengine_result" } ], "sink": [ { "plugin_name": "TDengine", "url": "jdbc:TAOS-RS://192.168.100.2:6041/", "username": "root", "password": "taosdata", "database": "test", "stable": "meters", "timezone": "UTC" } ] } ``` ### Running Command ```shell call the rest api url is /hazelcast/rest/maps/submit-job ``` ### Error Exception ```log 2024-03-26 17:45:37,052 INFO [o.a.s.c.s.u.ConfigBuilder ] [hz.main.cached.thread-1] - Loading config file from objectMap 2024-03-26 17:45:37,054 INFO [o.a.s.c.s.u.ConfigBuilder ] [hz.main.cached.thread-1] - Parsed config file: { "env" : { "execution.parallelism" : 1, "job.mode" : "BATCH" }, "source" : [ { "plugin_name" : "TDengine", "url" : "jdbc:TAOS-RS://192.168.100.1:6041/", "username" : "root", "password" : "taosdata", "database" : "test", "stable" : "meters", "lower_bound" : "2017-07-14 02:40:00.006", "upper_bound" : "2017-07-14 02:40:00.010", "result_table_name" : "tdengine_result" } ], "sink" : [ { "plugin_name" : "TDengine", "url" : "jdbc:TAOS-RS://192.168.100.2:6041/", "username" : "root", "password" : "taosdata", "database" : "test", "stable" : "meters", "timezone" : "UTC" } ] } 2024-03-26 17:45:37,055 INFO [.r.RestJobExecutionEnvironment] [hz.main.cached.thread-1] - add common jar in plugins :[] 2024-03-26 17:45:37,057 INFO [.s.p.d.AbstractPluginDiscovery] [hz.main.cached.thread-1] - Load SeaTunnelSink Plugin from /dataext/apache-seatunnel-2.3.4/connectors 2024-03-26 17:45:37,057 INFO [.s.p.d.AbstractPluginDiscovery] [hz.main.cached.thread-1] - Discovery plugin jar for: PluginIdentifier{engineType='seatunnel', pluginType='source', pluginName='TDengine'} at: file:/dataext/apache-seatunnel-2.3.4/connectors/connector-tdengine-2.3.4.jar 2024-03-26 17:45:37,058 INFO [.s.p.d.AbstractPluginDiscovery] [hz.main.cached.thread-1] - Discovery plugin jar for: PluginIdentifier{engineType='seatunnel', pluginType='sink', pluginName='TDengine'} at: file:/dataext/apache-seatunnel-2.3.4/connectors/connector-tdengine-2.3.4.jar 2024-03-26 17:45:37,058 INFO [o.a.s.e.c.p.ConfigParserUtil ] [hz.main.cached.thread-1] - Currently, incorrect configuration of source_table_name and result_table_name options don't affect job running. In the future we will ban incorrect configurations. 2024-03-26 17:45:37,058 WARN [o.a.s.e.c.p.ConfigParserUtil ] [hz.main.cached.thread-1] - This configuration is not recommended. A source/transform(TDengine) is configured with 'result_table_name' option value of 'tdengine_result', but subsequent transform/sink(TDengine) is not configured with 'source_table_name' option. 2024-03-26 17:45:37,059 INFO [p.MultipleTableJobConfigParser] [hz.main.cached.thread-1] - start generating all sources. 2024-03-26 17:45:37,066 INFO [.s.p.d.AbstractPluginDiscovery] [hz.main.cached.thread-1] - Load SeaTunnelSource Plugin from /dataext/apache-seatunnel-2.3.4/connectors 2024-03-26 17:45:37,066 INFO [.s.p.d.AbstractPluginDiscovery] [hz.main.cached.thread-1] - Discovery plugin jar for: PluginIdentifier{engineType='seatunnel', pluginType='source', pluginName='TDengine'} at: file:/dataext/apache-seatunnel-2.3.4/connectors/connector-tdengine-2.3.4.jar 2024-03-26 17:45:37,068 INFO [.s.p.d.AbstractPluginDiscovery] [hz.main.cached.thread-1] - Load plugin: PluginIdentifier{engineType='seatunnel', pluginType='source', pluginName='TDengine'} from classpath 2024-03-26 17:45:37,071 WARN [Log4j2HttpPostCommandProcessor] [hz.main.cached.thread-1] - [localhost]:5801 [seatunnel] [5.1] An error occurred while handling request HttpCommand [HTTP_POST]{uri='/hazelcast/rest/maps/submit-job'}AbstractTextCommand[HTTP_POST]{requestId=1} java.sql.SQLException: No suitable driver found for jdbc:TAOS-RS://192.168.100.1:6041/test?user=root&password=taosdata at java.sql.DriverManager.getConnection(DriverManager.java:689) ~[?:1.8.0_311] at java.sql.DriverManager.getConnection(DriverManager.java:270) ~[?:1.8.0_311] at org.apache.seatunnel.connectors.seatunnel.tdengine.source.TDengineSource.getStableMetadata(TDengineSource.java:138) ~[?:?] at org.apache.seatunnel.connectors.seatunnel.tdengine.source.TDengineSource.prepare(TDengineSource.java:90) ~[?:?] at org.apache.seatunnel.engine.core.parse.JobConfigParser.parseSource(JobConfigParser.java:84) ~[seatunnel-starter.jar:2.3.4] at org.apache.seatunnel.engine.core.parse.MultipleTableJobConfigParser.parseSource(MultipleTableJobConfigParser.java:315) ~[seatunnel-starter.jar:2.3.4] at org.apache.seatunnel.engine.core.parse.MultipleTableJobConfigParser.parse(MultipleTableJobConfigParser.java:181) ~[seatunnel-starter.jar:2.3.4] at org.apache.seatunnel.engine.server.rest.RestJobExecutionEnvironment.getLogicalDag(RestJobExecutionEnvironment.java:76) ~[seatunnel-starter.jar:2.3.4] at org.apache.seatunnel.engine.server.rest.RestJobExecutionEnvironment.build(RestJobExecutionEnvironment.java:99) ~[seatunnel-starter.jar:2.3.4] at org.apache.seatunnel.engine.server.rest.RestHttpPostCommandProcessor.handleSubmitJob(RestHttpPostCommandProcessor.java:136) ~[seatunnel-starter.jar:2.3.4] at org.apache.seatunnel.engine.server.rest.RestHttpPostCommandProcessor.handle(RestHttpPostCommandProcessor.java:82) ~[seatunnel-starter.jar:2.3.4] at org.apache.seatunnel.engine.server.rest.RestHttpPostCommandProcessor.handle(RestHttpPostCommandProcessor.java:60) ~[seatunnel-starter.jar:2.3.4] at com.hazelcast.internal.ascii.TextCommandServiceImpl$CommandExecutor.run(TextCommandServiceImpl.java:402) ~[seatunnel-starter.jar:2.3.4] at com.hazelcast.internal.util.executor.CachedExecutorServiceDelegate$Worker.run(CachedExecutorServiceDelegate.java:217) ~[seatunnel-starter.jar:2.3.4] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[?:1.8.0_311] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[?:1.8.0_311] at java.lang.Thread.run(Thread.java:748) [?:1.8.0_311] at com.hazelcast.internal.util.executor.HazelcastManagedThread.executeRun(HazelcastManagedThread.java:76) ~[seatunnel-starter.jar:2.3.4] at com.hazelcast.internal.util.executor.HazelcastManagedThread.run(HazelcastManagedThread.java:102) ~[seatunnel-starter.jar:2.3.4] ``` ### Zeta or Flink or Spark Version Zeta ### Java or Scala Version java version "1.8.0_311" Java(TM) SE Runtime Environment (build 1.8.0_311-b11) Java HotSpot(TM) 64-Bit Server VM (build 25.311-b11, mixed mode) ### Screenshots first call:  second call:  ### Are you willing to submit PR? - [ ] Yes I am willing to submit a PR! ### Code of Conduct - [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
