yaoquanxin opened a new issue, #8165:
URL: https://github.com/apache/seatunnel/issues/8165

   ### 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
   
   做的操作:
   
   python脚本调度config_file,去做简易的轮训(大批量数据导入,我先生成多个配置按时间顺序的配置文件,然后轮训配置文件)
   
    sh /bigdata/seatunnel/bin/seatunnel.sh --config 
/bigdata/seatunnel/job/{config_file}
       import os
   import time
   import subprocess
   from datetime import datetime
   
   def run_seatunnel_job(config_file):
       """
       运行 seatunnel.sh 脚本,传入配置文件
       """
       command = f"sh /bigdata/seatunnel/bin/seatunnel.sh --config 
/bigdata/seatunnel/job/{config_file}"
       
       # 打印生成的命令
       print(f"Generated command: {command}")
       
       try:
           # 执行命令
           subprocess.run(command, shell=True, check=True)
           print(f"Successfully triggered job for {config_file}")
       except subprocess.CalledProcessError as e:
           print(f"Error occurred while running {config_file}: {e}")
   
   def get_sorted_config_files(job_directory):
       """
       获取 job 目录中的所有 .conf 配置文件,并按日期排序
       """
       config_files = []
       for filename in os.listdir(job_directory):
           if filename.endswith('.conf'):
               # 提取文件中的日期部分并解析
               try:
                   date_str = filename.split('_')[2]  # 例如 '2019-01-01' 
从文件名中提取日期
                   start_date = datetime.strptime(date_str, '%Y-%m-%d')
                   config_files.append((start_date, filename))
               except Exception as e:
                   print(f"Skipping invalid file: {filename}, error: {e}")
       
       # 按日期升序排序
       config_files.sort(key=lambda x: x[0])
       
       # 返回排序后的文件名列表
       return [filename for _, filename in config_files]
   
   def monitor_and_trigger_jobs(job_directory, interval=3600):
       """
       轮询 job 目录,每次只读取一个配置文件并触发任务
       """
       config_files = get_sorted_config_files(job_directory)
       
       while config_files:
           # 获取最小日期的配置文件
           current_config_file = config_files.pop(0)
           
           print(f"Triggering job for {current_config_file}...")
           run_seatunnel_job(current_config_file)
           
           # 等待 1 小时(3600 秒)
           print(f"Sleeping for {interval} seconds...\n")
           time.sleep(interval)
   
   if __name__ == "__main__":
       # 监控目录和触发时间间隔
       job_directory = '/bigdata/seatunnel/job'
       monitor_and_trigger_jobs(job_directory)
   
    
   
   
   报错日志:
        Caused by: java.lang.NullPointerException
                at 
org.apache.seatunnel.connectors.seatunnel.starrocks.catalog.StarRocksCatalog.tableExists(StarRocksCatalog.java:478)
                at 
org.apache.seatunnel.api.sink.DefaultSaveModeHandler.tableExists(DefaultSaveModeHandler.java:138)
                at 
org.apache.seatunnel.api.sink.DefaultSaveModeHandler.createSchemaWhenNotExist(DefaultSaveModeHandler.java:107)
                at 
org.apache.seatunnel.api.sink.DefaultSaveModeHandler.handleSchemaSaveMode(DefaultSaveModeHandler.java:69)
                at 
org.apache.seatunnel.api.sink.SaveModeHandler.handleSaveMode(SaveModeHandler.java:38)
                at 
org.apache.seatunnel.api.sink.SaveModeExecuteWrapper.execute(SaveModeExecuteWrapper.java:36)
                at 
org.apache.seatunnel.engine.server.master.JobMaster.handleSaveMode(JobMaster.java:375)
                ... 19 more
                Suppressed: java.lang.NullPointerException
                        at 
org.apache.seatunnel.connectors.seatunnel.starrocks.catalog.StarRocksCatalog.close(StarRocksCatalog.java:435)
                        at 
org.apache.seatunnel.api.sink.DefaultSaveModeHandler.close(DefaultSaveModeHandler.java:229)
                        at 
org.apache.seatunnel.engine.server.master.JobMaster.handleSaveMode(JobMaster.java:374)
                        ... 19 more
        
                at 
com.hazelcast.spi.impl.AbstractInvocationFuture.wrapInCompletionException(AbstractInvocationFuture.java:1347)
                at 
com.hazelcast.spi.impl.AbstractInvocationFuture.cascadeException(AbstractInvocationFuture.java:1340)
                at 
com.hazelcast.spi.impl.AbstractInvocationFuture.access$200(AbstractInvocationFuture.java:65)
                at 
com.hazelcast.spi.impl.AbstractInvocationFuture$ApplyNode.execute(AbstractInvocationFuture.java:1478)
                at 
com.hazelcast.spi.impl.AbstractInvocationFuture.unblockOtherNode(AbstractInvocationFuture.java:797)
                at 
com.hazelcast.spi.impl.AbstractInvocationFuture.unblockAll(AbstractInvocationFuture.java:759)
                at 
com.hazelcast.spi.impl.AbstractInvocationFuture.complete0(AbstractInvocationFuture.java:1235)
                at 
com.hazelcast.spi.impl.AbstractInvocationFuture.completeExceptionallyInternal(AbstractInvocationFuture.java:1223)
                at 
com.hazelcast.spi.impl.AbstractInvocationFuture.completeExceptionally(AbstractInvocationFuture.java:709)
                at 
com.hazelcast.client.impl.spi.impl.ClientInvocation.completeExceptionally(ClientInvocation.java:294)
                at 
com.hazelcast.client.impl.spi.impl.ClientInvocation.notifyExceptionWithOwnedPermission(ClientInvocation.java:321)
                at 
com.hazelcast.client.impl.spi.impl.ClientInvocation.notifyException(ClientInvocation.java:304)
                at 
com.hazelcast.client.impl.spi.impl.ClientResponseHandlerSupplier.handleResponse(ClientResponseHandlerSupplier.java:164)
                at 
com.hazelcast.client.impl.spi.impl.ClientResponseHandlerSupplier.process(ClientResponseHandlerSupplier.java:141)
                at 
com.hazelcast.client.impl.spi.impl.ClientResponseHandlerSupplier.access$300(ClientResponseHandlerSupplier.java:60)
                at 
com.hazelcast.client.impl.spi.impl.ClientResponseHandlerSupplier$DynamicResponseHandler.accept(ClientResponseHandlerSupplier.java:251)
                at 
com.hazelcast.client.impl.spi.impl.ClientResponseHandlerSupplier$DynamicResponseHandler.accept(ClientResponseHandlerSupplier.java:243)
                at 
com.hazelcast.client.impl.connection.tcp.TcpClientConnection.handleClientMessage(TcpClientConnection.java:245)
                at 
com.hazelcast.client.impl.protocol.util.ClientMessageDecoder.handleMessage(ClientMessageDecoder.java:135)
                at 
com.hazelcast.client.impl.protocol.util.ClientMessageDecoder.onRead(ClientMessageDecoder.java:89)
                at 
com.hazelcast.internal.networking.nio.NioInboundPipeline.process(NioInboundPipeline.java:136)
                at 
com.hazelcast.internal.networking.nio.NioThread.processSelectionKey(NioThread.java:383)
                at 
com.hazelcast.internal.networking.nio.NioThread.processSelectionKeys(NioThread.java:368)
                at 
com.hazelcast.internal.networking.nio.NioThread.selectLoop(NioThread.java:294)
                at 
com.hazelcast.internal.networking.nio.NioThread.executeRun(NioThread.java:249)
                at 
com.hazelcast.internal.util.executor.HazelcastManagedThread.run(HazelcastManagedThread.java:102)
        Caused by: org.apache.seatunnel.engine.common.exception.JobException: 
org.apache.seatunnel.common.exception.SeaTunnelRuntimeException: 
ErrorCode:[API-09], ErrorDescription:[Handle save mode failed]
                at 
org.apache.seatunnel.engine.server.master.JobMaster.handleSaveMode(JobMaster.java:377)
                at 
java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:183)
                at 
java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
                at 
java.base/java.util.stream.ReferencePipeline$2$1.accept(ReferencePipeline.java:177)
                at 
java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
                at 
java.base/java.util.Iterator.forEachRemaining(Iterator.java:133)
                at 
java.base/java.util.Spliterators$IteratorSpliterator.forEachRemaining(Spliterators.java:1801)
                at 
java.base/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:484)
                at 
java.base/java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:474)
                at 
java.base/java.util.stream.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:150)
                at 
java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:173)
                at 
java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
                at 
java.base/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:497)
                at 
org.apache.seatunnel.engine.server.master.JobMaster.init(JobMaster.java:242)
                at 
org.apache.seatunnel.engine.server.CoordinatorService.lambda$submitJob$4(CoordinatorService.java:499)
                at 
java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515)
                at 
java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
                at 
java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
                at 
java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
                at java.base/java.lang.Thread.run(Thread.java:829)
        Caused by: java.lang.NullPointerException
                at 
org.apache.seatunnel.connectors.seatunnel.starrocks.catalog.StarRocksCatalog.tableExists(StarRocksCatalog.java:478)
                at 
org.apache.seatunnel.api.sink.DefaultSaveModeHandler.tableExists(DefaultSaveModeHandler.java:138)
                at 
org.apache.seatunnel.api.sink.DefaultSaveModeHandler.createSchemaWhenNotExist(DefaultSaveModeHandler.java:107)
                at 
org.apache.seatunnel.api.sink.DefaultSaveModeHandler.handleSchemaSaveMode(DefaultSaveModeHandler.java:69)
                at 
org.apache.seatunnel.api.sink.SaveModeHandler.handleSaveMode(SaveModeHandler.java:38)
                at 
org.apache.seatunnel.api.sink.SaveModeExecuteWrapper.execute(SaveModeExecuteWrapper.java:36)
                at 
org.apache.seatunnel.engine.server.master.JobMaster.handleSaveMode(JobMaster.java:375)
                ... 19 more
                Suppressed: java.lang.NullPointerException
                        at 
org.apache.seatunnel.connectors.seatunnel.starrocks.catalog.StarRocksCatalog.close(StarRocksCatalog.java:435)
                        at 
org.apache.seatunnel.api.sink.DefaultSaveModeHandler.close(DefaultSaveModeHandler.java:229)
                        at 
org.apache.seatunnel.engine.server.master.JobMaster.handleSaveMode(JobMaster.java:374)
                        ... 19 more
        
                at 
org.apache.seatunnel.engine.server.CoordinatorService.lambda$submitJob$4(CoordinatorService.java:506)
                at 
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515)
                at java.util.concurrent.FutureTask.run(FutureTask.java:264)
                at 
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
                at 
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
                at java.lang.Thread.run(Thread.java:829)
         
        2024-11-28 16:02:48,534 ERROR [o.a.s.c.s.SeaTunnel           ] [main] - 
        
===============================================================================
        
        
        
        Exception in thread "main" 
org.apache.seatunnel.core.starter.exception.CommandExecuteException: SeaTunnel 
job executed failed
                at 
org.apache.seatunnel.core.starter.seatunnel.command.ClientExecuteCommand.execute(ClientExecuteCommand.java:213)
                at 
org.apache.seatunnel.core.starter.SeaTunnel.run(SeaTunnel.java:40)
                at 
org.apache.seatunnel.core.starter.seatunnel.SeaTunnelClient.main(SeaTunnelClient.java:34)
        Caused by: java.util.concurrent.CompletionException: 
org.apache.seatunnel.engine.common.exception.JobException: 
org.apache.seatunnel.common.exception.SeaTunnelRuntimeException: 
ErrorCode:[API-09], ErrorDescription:[Handle save mode failed]
                at 
org.apache.seatunnel.engine.server.master.JobMaster.handleSaveMode(JobMaster.java:377)
                at 
java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:183)
                at 
java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
                at 
java.base/java.util.stream.ReferencePipeline$2$1.accept(ReferencePipeline.java:177)
                at 
java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
                at 
java.base/java.util.Iterator.forEachRemaining(Iterator.java:133)
                at 
java.base/java.util.Spliterators$IteratorSpliterator.forEachRemaining(Spliterators.java:1801)
                at 
java.base/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:484)
                at 
java.base/java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:474)
                at 
java.base/java.util.stream.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:150)
                at 
java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:173)
                at 
java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
                at 
java.base/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:497)
                at 
org.apache.seatunnel.engine.server.master.JobMaster.init(JobMaster.java:242)
                at 
org.apache.seatunnel.engine.server.CoordinatorService.lambda$submitJob$4(CoordinatorService.java:499)
                at 
java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515)
                at 
java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
                at 
java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
                at 
java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
                at java.base/java.lang.Thread.run(Thread.java:829)
        Caused by: java.lang.NullPointerException
                at 
org.apache.seatunnel.connectors.seatunnel.starrocks.catalog.StarRocksCatalog.tableExists(StarRocksCatalog.java:478)
                at 
org.apache.seatunnel.api.sink.DefaultSaveModeHandler.tableExists(DefaultSaveModeHandler.java:138)
                at 
org.apache.seatunnel.api.sink.DefaultSaveModeHandler.createSchemaWhenNotExist(DefaultSaveModeHandler.java:107)
                at 
org.apache.seatunnel.api.sink.DefaultSaveModeHandler.handleSchemaSaveMode(DefaultSaveModeHandler.java:69)
                at 
org.apache.seatunnel.api.sink.SaveModeHandler.handleSaveMode(SaveModeHandler.java:38)
                at 
org.apache.seatunnel.api.sink.SaveModeExecuteWrapper.execute(SaveModeExecuteWrapper.java:36)
                at 
org.apache.seatunnel.engine.server.master.JobMaster.handleSaveMode(JobMaster.java:375)
                ... 19 more
                Suppressed: java.lang.NullPointerException
                        at 
org.apache.seatunnel.connectors.seatunnel.starrocks.catalog.StarRocksCatalog.close(StarRocksCatalog.java:435)
                        at 
org.apache.seatunnel.api.sink.DefaultSaveModeHandler.close(DefaultSaveModeHandler.java:229)
                        at 
org.apache.seatunnel.engine.server.master.JobMaster.handleSaveMode(JobMaster.java:374)
                        ... 19 more
        
                at 
com.hazelcast.spi.impl.AbstractInvocationFuture.wrapInCompletionException(AbstractInvocationFuture.java:1347)
                at 
com.hazelcast.spi.impl.AbstractInvocationFuture.cascadeException(AbstractInvocationFuture.java:1340)
                at 
com.hazelcast.spi.impl.AbstractInvocationFuture.access$200(AbstractInvocationFuture.java:65)
                at 
com.hazelcast.spi.impl.AbstractInvocationFuture$ApplyNode.execute(AbstractInvocationFuture.java:1478)
                at 
com.hazelcast.spi.impl.AbstractInvocationFuture.unblockOtherNode(AbstractInvocationFuture.java:797)
                at 
com.hazelcast.spi.impl.AbstractInvocationFuture.unblockAll(AbstractInvocationFuture.java:759)
                at 
com.hazelcast.spi.impl.AbstractInvocationFuture.complete0(AbstractInvocationFuture.java:1235)
                at 
com.hazelcast.spi.impl.AbstractInvocationFuture.completeExceptionallyInternal(AbstractInvocationFuture.java:1223)
                at 
com.hazelcast.spi.impl.AbstractInvocationFuture.completeExceptionally(AbstractInvocationFuture.java:709)
                at 
com.hazelcast.client.impl.spi.impl.ClientInvocation.completeExceptionally(ClientInvocation.java:294)
                at 
com.hazelcast.client.impl.spi.impl.ClientInvocation.notifyExceptionWithOwnedPermission(ClientInvocation.java:321)
                at 
com.hazelcast.client.impl.spi.impl.ClientInvocation.notifyException(ClientInvocation.java:304)
                at 
com.hazelcast.client.impl.spi.impl.ClientResponseHandlerSupplier.handleResponse(ClientResponseHandlerSupplier.java:164)
                at 
com.hazelcast.client.impl.spi.impl.ClientResponseHandlerSupplier.process(ClientResponseHandlerSupplier.java:141)
                at 
com.hazelcast.client.impl.spi.impl.ClientResponseHandlerSupplier.access$300(ClientResponseHandlerSupplier.java:60)
                at 
com.hazelcast.client.impl.spi.impl.ClientResponseHandlerSupplier$DynamicResponseHandler.accept(ClientResponseHandlerSupplier.java:251)
                at 
com.hazelcast.client.impl.spi.impl.ClientResponseHandlerSupplier$DynamicResponseHandler.accept(ClientResponseHandlerSupplier.java:243)
                at 
com.hazelcast.client.impl.connection.tcp.TcpClientConnection.handleClientMessage(TcpClientConnection.java:245)
                at 
com.hazelcast.client.impl.protocol.util.ClientMessageDecoder.handleMessage(ClientMessageDecoder.java:135)
                at 
com.hazelcast.client.impl.protocol.util.ClientMessageDecoder.onRead(ClientMessageDecoder.java:89)
                at 
com.hazelcast.internal.networking.nio.NioInboundPipeline.process(NioInboundPipeline.java:136)
                at 
com.hazelcast.internal.networking.nio.NioThread.processSelectionKey(NioThread.java:383)
                at 
com.hazelcast.internal.networking.nio.NioThread.processSelectionKeys(NioThread.java:368)
                at 
com.hazelcast.internal.networking.nio.NioThread.selectLoop(NioThread.java:294)
                at 
com.hazelcast.internal.networking.nio.NioThread.executeRun(NioThread.java:249)
                at 
com.hazelcast.internal.util.executor.HazelcastManagedThread.run(HazelcastManagedThread.java:102)
        Caused by: org.apache.seatunnel.engine.common.exception.JobException: 
org.apache.seatunnel.common.exception.SeaTunnelRuntimeException: 
ErrorCode:[API-09], ErrorDescription:[Handle save mode failed]
                at 
org.apache.seatunnel.engine.server.master.JobMaster.handleSaveMode(JobMaster.java:377)
                at 
java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:183)
                at 
java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
                at 
java.base/java.util.stream.ReferencePipeline$2$1.accept(ReferencePipeline.java:177)
                at 
java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
                at 
java.base/java.util.Iterator.forEachRemaining(Iterator.java:133)
                at 
java.base/java.util.Spliterators$IteratorSpliterator.forEachRemaining(Spliterators.java:1801)
                at 
java.base/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:484)
                at 
java.base/java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:474)
                at 
java.base/java.util.stream.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:150)
                at 
java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:173)
                at 
java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
                at 
java.base/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:497)
                at 
org.apache.seatunnel.engine.server.master.JobMaster.init(JobMaster.java:242)
                at 
org.apache.seatunnel.engine.server.CoordinatorService.lambda$submitJob$4(CoordinatorService.java:499)
                at 
java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515)
                at 
java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
                at 
java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
                at 
java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
                at java.base/java.lang.Thread.run(Thread.java:829)
        Caused by: java.lang.NullPointerException
                at 
org.apache.seatunnel.connectors.seatunnel.starrocks.catalog.StarRocksCatalog.tableExists(StarRocksCatalog.java:478)
                at 
org.apache.seatunnel.api.sink.DefaultSaveModeHandler.tableExists(DefaultSaveModeHandler.java:138)
                at 
org.apache.seatunnel.api.sink.DefaultSaveModeHandler.createSchemaWhenNotExist(DefaultSaveModeHandler.java:107)
                at 
org.apache.seatunnel.api.sink.DefaultSaveModeHandler.handleSchemaSaveMode(DefaultSaveModeHandler.java:69)
                at 
org.apache.seatunnel.api.sink.SaveModeHandler.handleSaveMode(SaveModeHandler.java:38)
                at 
org.apache.seatunnel.api.sink.SaveModeExecuteWrapper.execute(SaveModeExecuteWrapper.java:36)
                at 
org.apache.seatunnel.engine.server.master.JobMaster.handleSaveMode(JobMaster.java:375)
                ... 19 more
                Suppressed: java.lang.NullPointerException
                        at 
org.apache.seatunnel.connectors.seatunnel.starrocks.catalog.StarRocksCatalog.close(StarRocksCatalog.java:435)
                        at 
org.apache.seatunnel.api.sink.DefaultSaveModeHandler.close(DefaultSaveModeHandler.java:229)
                        at 
org.apache.seatunnel.engine.server.master.JobMaster.handleSaveMode(JobMaster.java:374)
                        ... 19 more
        
                at 
org.apache.seatunnel.engine.server.CoordinatorService.lambda$submitJob$4(CoordinatorService.java:506)
                at 
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515)
                at java.util.concurrent.FutureTask.run(FutureTask.java:264)
                at 
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
                at 
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
                at java.lang.Thread.run(Thread.java:829)
                
   
   
   
   ### SeaTunnel Version
   
   2.3.8
   
   ### SeaTunnel Config
   
   ```conf
   env {
     parallelism = 4
     job.mode = "BATCH"
   }
   
   source {
       Jdbc {
           url = "jdbc:postgresql://xxx/smartretail-tenant"
           driver = "org.postgresql.Driver"
           user = "yqx"
       
           query  = "select * from bb_supplier_goods_pss where book_date >= 
'2019-01-01' AND book_date <= '2019-01-15'"
           partition_column = "category_id"
           partition_num = 5
       }
   }
   
   transform {}
   
   sink {
     starrocks {
       nodeUrls = ["1xxx"]
       base-url = "jdbcxxx/"
       username = root
   
       table = "ods_ctk_smartretail_tenant_bb_supplier_goods_pss"
       batch_max_rows = 8000
     }
   }
   ```
   
   
   ### Running Command
   
   ```shell
   sh /bigdata/seatunnel/bin/seatunnel.sh --config 
/bigdata/seatunnel/job/{config_file}
   ```
   
   
   ### Error Exception
   
   ```log
   Caused by: java.lang.NullPointerException
                at 
org.apache.seatunnel.connectors.seatunnel.starrocks.catalog.StarRocksCatalog.tableExists(StarRocksCatalog.java:478)
                at 
org.apache.seatunnel.api.sink.DefaultSaveModeHandler.tableExists(DefaultSaveModeHandler.java:138)
                at 
org.apache.seatunnel.api.sink.DefaultSaveModeHandler.createSchemaWhenNotExist(DefaultSaveModeHandler.java:107)
                at 
org.apache.seatunnel.api.sink.DefaultSaveModeHandler.handleSchemaSaveMode(DefaultSaveModeHandler.java:69)
                at 
org.apache.seatunnel.api.sink.SaveModeHandler.handleSaveMode(SaveModeHandler.java:38)
                at 
org.apache.seatunnel.api.sink.SaveModeExecuteWrapper.execute(SaveModeExecuteWrapper.java:36)
                at 
org.apache.seatunnel.engine.server.master.JobMaster.handleSaveMode(JobMaster.java:375)
                ... 19 more
                Suppressed: java.lang.NullPointerException
                        at 
org.apache.seatunnel.connectors.seatunnel.starrocks.catalog.StarRocksCatalog.close(StarRocksCatalog.java:435)
                        at 
org.apache.seatunnel.api.sink.DefaultSaveModeHandler.close(DefaultSaveModeHandler.java:229)
                        at 
org.apache.seatunnel.engine.server.master.JobMaster.handleSaveMode(JobMaster.java:374)
                        ... 19 more
        
                at 
com.hazelcast.spi.impl.AbstractInvocationFuture.wrapInCompletionException(AbstractInvocationFuture.java:1347)
                at 
com.hazelcast.spi.impl.AbstractInvocationFuture.cascadeException(AbstractInvocationFuture.java:1340)
                at 
com.hazelcast.spi.impl.AbstractInvocationFuture.access$200(AbstractInvocationFuture.java:65)
                at 
com.hazelcast.spi.impl.AbstractInvocationFuture$ApplyNode.execute(AbstractInvocationFuture.java:1478)
                at 
com.hazelcast.spi.impl.AbstractInvocationFuture.unblockOtherNode(AbstractInvocationFuture.java:797)
                at 
com.hazelcast.spi.impl.AbstractInvocationFuture.unblockAll(AbstractInvocationFuture.java:759)
                at 
com.hazelcast.spi.impl.AbstractInvocationFuture.complete0(AbstractInvocationFuture.java:1235)
                at 
com.hazelcast.spi.impl.AbstractInvocationFuture.completeExceptionallyInternal(AbstractInvocationFuture.java:1223)
                at 
com.hazelcast.spi.impl.AbstractInvocationFuture.completeExceptionally(AbstractInvocationFuture.java:709)
                at 
com.hazelcast.client.impl.spi.impl.ClientInvocation.completeExceptionally(ClientInvocation.java:294)
                at 
com.hazelcast.client.impl.spi.impl.ClientInvocation.notifyExceptionWithOwnedPermission(ClientInvocation.java:321)
                at 
com.hazelcast.client.impl.spi.impl.ClientInvocation.notifyException(ClientInvocation.java:304)
                at 
com.hazelcast.client.impl.spi.impl.ClientResponseHandlerSupplier.handleResponse(ClientResponseHandlerSupplier.java:164)
                at 
com.hazelcast.client.impl.spi.impl.ClientResponseHandlerSupplier.process(ClientResponseHandlerSupplier.java:141)
                at 
com.hazelcast.client.impl.spi.impl.ClientResponseHandlerSupplier.access$300(ClientResponseHandlerSupplier.java:60)
                at 
com.hazelcast.client.impl.spi.impl.ClientResponseHandlerSupplier$DynamicResponseHandler.accept(ClientResponseHandlerSupplier.java:251)
                at 
com.hazelcast.client.impl.spi.impl.ClientResponseHandlerSupplier$DynamicResponseHandler.accept(ClientResponseHandlerSupplier.java:243)
                at 
com.hazelcast.client.impl.connection.tcp.TcpClientConnection.handleClientMessage(TcpClientConnection.java:245)
                at 
com.hazelcast.client.impl.protocol.util.ClientMessageDecoder.handleMessage(ClientMessageDecoder.java:135)
                at 
com.hazelcast.client.impl.protocol.util.ClientMessageDecoder.onRead(ClientMessageDecoder.java:89)
                at 
com.hazelcast.internal.networking.nio.NioInboundPipeline.process(NioInboundPipeline.java:136)
                at 
com.hazelcast.internal.networking.nio.NioThread.processSelectionKey(NioThread.java:383)
                at 
com.hazelcast.internal.networking.nio.NioThread.processSelectionKeys(NioThread.java:368)
                at 
com.hazelcast.internal.networking.nio.NioThread.selectLoop(NioThread.java:294)
                at 
com.hazelcast.internal.networking.nio.NioThread.executeRun(NioThread.java:249)
                at 
com.hazelcast.internal.util.executor.HazelcastManagedThread.run(HazelcastManagedThread.java:102)
        Caused by: org.apache.seatunnel.engine.common.exception.JobException: 
org.apache.seatunnel.common.exception.SeaTunnelRuntimeException: 
ErrorCode:[API-09], ErrorDescription:[Handle save mode failed]
                at 
org.apache.seatunnel.engine.server.master.JobMaster.handleSaveMode(JobMaster.java:377)
                at 
java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:183)
                at 
java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
                at 
java.base/java.util.stream.ReferencePipeline$2$1.accept(ReferencePipeline.java:177)
                at 
java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
                at 
java.base/java.util.Iterator.forEachRemaining(Iterator.java:133)
                at 
java.base/java.util.Spliterators$IteratorSpliterator.forEachRemaining(Spliterators.java:1801)
                at 
java.base/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:484)
                at 
java.base/java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:474)
                at 
java.base/java.util.stream.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:150)
                at 
java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:173)
                at 
java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
                at 
java.base/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:497)
                at 
org.apache.seatunnel.engine.server.master.JobMaster.init(JobMaster.java:242)
                at 
org.apache.seatunnel.engine.server.CoordinatorService.lambda$submitJob$4(CoordinatorService.java:499)
                at 
java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515)
                at 
java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
                at 
java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
                at 
java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
                at java.base/java.lang.Thread.run(Thread.java:829)
        Caused by: java.lang.NullPointerException
                at 
org.apache.seatunnel.connectors.seatunnel.starrocks.catalog.StarRocksCatalog.tableExists(StarRocksCatalog.java:478)
                at 
org.apache.seatunnel.api.sink.DefaultSaveModeHandler.tableExists(DefaultSaveModeHandler.java:138)
                at 
org.apache.seatunnel.api.sink.DefaultSaveModeHandler.createSchemaWhenNotExist(DefaultSaveModeHandler.java:107)
                at 
org.apache.seatunnel.api.sink.DefaultSaveModeHandler.handleSchemaSaveMode(DefaultSaveModeHandler.java:69)
                at 
org.apache.seatunnel.api.sink.SaveModeHandler.handleSaveMode(SaveModeHandler.java:38)
                at 
org.apache.seatunnel.api.sink.SaveModeExecuteWrapper.execute(SaveModeExecuteWrapper.java:36)
                at 
org.apache.seatunnel.engine.server.master.JobMaster.handleSaveMode(JobMaster.java:375)
                ... 19 more
                Suppressed: java.lang.NullPointerException
                        at 
org.apache.seatunnel.connectors.seatunnel.starrocks.catalog.StarRocksCatalog.close(StarRocksCatalog.java:435)
                        at 
org.apache.seatunnel.api.sink.DefaultSaveModeHandler.close(DefaultSaveModeHandler.java:229)
                        at 
org.apache.seatunnel.engine.server.master.JobMaster.handleSaveMode(JobMaster.java:374)
                        ... 19 more
        
                at 
org.apache.seatunnel.engine.server.CoordinatorService.lambda$submitJob$4(CoordinatorService.java:506)
                at 
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515)
                at java.util.concurrent.FutureTask.run(FutureTask.java:264)
                at 
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
                at 
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
                at java.lang.Thread.run(Thread.java:829)
         
        2024-11-28 16:02:48,534 ERROR [o.a.s.c.s.SeaTunnel           ] [main] - 
        
===============================================================================
        
        
        
        Exception in thread "main" 
org.apache.seatunnel.core.starter.exception.CommandExecuteException: SeaTunnel 
job executed failed
                at 
org.apache.seatunnel.core.starter.seatunnel.command.ClientExecuteCommand.execute(ClientExecuteCommand.java:213)
                at 
org.apache.seatunnel.core.starter.SeaTunnel.run(SeaTunnel.java:40)
                at 
org.apache.seatunnel.core.starter.seatunnel.SeaTunnelClient.main(SeaTunnelClient.java:34)
        Caused by: java.util.concurrent.CompletionException: 
org.apache.seatunnel.engine.common.exception.JobException: 
org.apache.seatunnel.common.exception.SeaTunnelRuntimeException: 
ErrorCode:[API-09], ErrorDescription:[Handle save mode failed]
                at 
org.apache.seatunnel.engine.server.master.JobMaster.handleSaveMode(JobMaster.java:377)
                at 
java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:183)
                at 
java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
                at 
java.base/java.util.stream.ReferencePipeline$2$1.accept(ReferencePipeline.java:177)
                at 
java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
                at 
java.base/java.util.Iterator.forEachRemaining(Iterator.java:133)
                at 
java.base/java.util.Spliterators$IteratorSpliterator.forEachRemaining(Spliterators.java:1801)
                at 
java.base/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:484)
                at 
java.base/java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:474)
                at 
java.base/java.util.stream.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:150)
                at 
java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:173)
                at 
java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
                at 
java.base/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:497)
                at 
org.apache.seatunnel.engine.server.master.JobMaster.init(JobMaster.java:242)
                at 
org.apache.seatunnel.engine.server.CoordinatorService.lambda$submitJob$4(CoordinatorService.java:499)
                at 
java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515)
                at 
java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
                at 
java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
                at 
java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
                at java.base/java.lang.Thread.run(Thread.java:829)
        Caused by: java.lang.NullPointerException
                at 
org.apache.seatunnel.connectors.seatunnel.starrocks.catalog.StarRocksCatalog.tableExists(StarRocksCatalog.java:478)
                at 
org.apache.seatunnel.api.sink.DefaultSaveModeHandler.tableExists(DefaultSaveModeHandler.java:138)
                at 
org.apache.seatunnel.api.sink.DefaultSaveModeHandler.createSchemaWhenNotExist(DefaultSaveModeHandler.java:107)
                at 
org.apache.seatunnel.api.sink.DefaultSaveModeHandler.handleSchemaSaveMode(DefaultSaveModeHandler.java:69)
                at 
org.apache.seatunnel.api.sink.SaveModeHandler.handleSaveMode(SaveModeHandler.java:38)
                at 
org.apache.seatunnel.api.sink.SaveModeExecuteWrapper.execute(SaveModeExecuteWrapper.java:36)
                at 
org.apache.seatunnel.engine.server.master.JobMaster.handleSaveMode(JobMaster.java:375)
                ... 19 more
                Suppressed: java.lang.NullPointerException
                        at 
org.apache.seatunnel.connectors.seatunnel.starrocks.catalog.StarRocksCatalog.close(StarRocksCatalog.java:435)
                        at 
org.apache.seatunnel.api.sink.DefaultSaveModeHandler.close(DefaultSaveModeHandler.java:229)
                        at 
org.apache.seatunnel.engine.server.master.JobMaster.handleSaveMode(JobMaster.java:374)
                        ... 19 more
        
                at 
com.hazelcast.spi.impl.AbstractInvocationFuture.wrapInCompletionException(AbstractInvocationFuture.java:1347)
                at 
com.hazelcast.spi.impl.AbstractInvocationFuture.cascadeException(AbstractInvocationFuture.java:1340)
                at 
com.hazelcast.spi.impl.AbstractInvocationFuture.access$200(AbstractInvocationFuture.java:65)
                at 
com.hazelcast.spi.impl.AbstractInvocationFuture$ApplyNode.execute(AbstractInvocationFuture.java:1478)
                at 
com.hazelcast.spi.impl.AbstractInvocationFuture.unblockOtherNode(AbstractInvocationFuture.java:797)
                at 
com.hazelcast.spi.impl.AbstractInvocationFuture.unblockAll(AbstractInvocationFuture.java:759)
                at 
com.hazelcast.spi.impl.AbstractInvocationFuture.complete0(AbstractInvocationFuture.java:1235)
                at 
com.hazelcast.spi.impl.AbstractInvocationFuture.completeExceptionallyInternal(AbstractInvocationFuture.java:1223)
                at 
com.hazelcast.spi.impl.AbstractInvocationFuture.completeExceptionally(AbstractInvocationFuture.java:709)
                at 
com.hazelcast.client.impl.spi.impl.ClientInvocation.completeExceptionally(ClientInvocation.java:294)
                at 
com.hazelcast.client.impl.spi.impl.ClientInvocation.notifyExceptionWithOwnedPermission(ClientInvocation.java:321)
                at 
com.hazelcast.client.impl.spi.impl.ClientInvocation.notifyException(ClientInvocation.java:304)
                at 
com.hazelcast.client.impl.spi.impl.ClientResponseHandlerSupplier.handleResponse(ClientResponseHandlerSupplier.java:164)
                at 
com.hazelcast.client.impl.spi.impl.ClientResponseHandlerSupplier.process(ClientResponseHandlerSupplier.java:141)
                at 
com.hazelcast.client.impl.spi.impl.ClientResponseHandlerSupplier.access$300(ClientResponseHandlerSupplier.java:60)
                at 
com.hazelcast.client.impl.spi.impl.ClientResponseHandlerSupplier$DynamicResponseHandler.accept(ClientResponseHandlerSupplier.java:251)
                at 
com.hazelcast.client.impl.spi.impl.ClientResponseHandlerSupplier$DynamicResponseHandler.accept(ClientResponseHandlerSupplier.java:243)
                at 
com.hazelcast.client.impl.connection.tcp.TcpClientConnection.handleClientMessage(TcpClientConnection.java:245)
                at 
com.hazelcast.client.impl.protocol.util.ClientMessageDecoder.handleMessage(ClientMessageDecoder.java:135)
                at 
com.hazelcast.client.impl.protocol.util.ClientMessageDecoder.onRead(ClientMessageDecoder.java:89)
                at 
com.hazelcast.internal.networking.nio.NioInboundPipeline.process(NioInboundPipeline.java:136)
                at 
com.hazelcast.internal.networking.nio.NioThread.processSelectionKey(NioThread.java:383)
                at 
com.hazelcast.internal.networking.nio.NioThread.processSelectionKeys(NioThread.java:368)
                at 
com.hazelcast.internal.networking.nio.NioThread.selectLoop(NioThread.java:294)
                at 
com.hazelcast.internal.networking.nio.NioThread.executeRun(NioThread.java:249)
                at 
com.hazelcast.internal.util.executor.HazelcastManagedThread.run(HazelcastManagedThread.java:102)
        Caused by: org.apache.seatunnel.engine.common.exception.JobException: 
org.apache.seatunnel.common.exception.SeaTunnelRuntimeException: 
ErrorCode:[API-09], ErrorDescription:[Handle save mode failed]
                at 
org.apache.seatunnel.engine.server.master.JobMaster.handleSaveMode(JobMaster.java:377)
                at 
java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:183)
                at 
java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
                at 
java.base/java.util.stream.ReferencePipeline$2$1.accept(ReferencePipeline.java:177)
                at 
java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
                at 
java.base/java.util.Iterator.forEachRemaining(Iterator.java:133)
                at 
java.base/java.util.Spliterators$IteratorSpliterator.forEachRemaining(Spliterators.java:1801)
                at 
java.base/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:484)
                at 
java.base/java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:474)
                at 
java.base/java.util.stream.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:150)
                at 
java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:173)
                at 
java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
                at 
java.base/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:497)
                at 
org.apache.seatunnel.engine.server.master.JobMaster.init(JobMaster.java:242)
                at 
org.apache.seatunnel.engine.server.CoordinatorService.lambda$submitJob$4(CoordinatorService.java:499)
                at 
java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515)
                at 
java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
                at 
java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
                at 
java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
                at java.base/java.lang.Thread.run(Thread.java:829)
        Caused by: java.lang.NullPointerException
                at 
org.apache.seatunnel.connectors.seatunnel.starrocks.catalog.StarRocksCatalog.tableExists(StarRocksCatalog.java:478)
                at 
org.apache.seatunnel.api.sink.DefaultSaveModeHandler.tableExists(DefaultSaveModeHandler.java:138)
                at 
org.apache.seatunnel.api.sink.DefaultSaveModeHandler.createSchemaWhenNotExist(DefaultSaveModeHandler.java:107)
                at 
org.apache.seatunnel.api.sink.DefaultSaveModeHandler.handleSchemaSaveMode(DefaultSaveModeHandler.java:69)
                at 
org.apache.seatunnel.api.sink.SaveModeHandler.handleSaveMode(SaveModeHandler.java:38)
                at 
org.apache.seatunnel.api.sink.SaveModeExecuteWrapper.execute(SaveModeExecuteWrapper.java:36)
                at 
org.apache.seatunnel.engine.server.master.JobMaster.handleSaveMode(JobMaster.java:375)
                ... 19 more
                Suppressed: java.lang.NullPointerException
                        at 
org.apache.seatunnel.connectors.seatunnel.starrocks.catalog.StarRocksCatalog.close(StarRocksCatalog.java:435)
                        at 
org.apache.seatunnel.api.sink.DefaultSaveModeHandler.close(DefaultSaveModeHandler.java:229)
                        at 
org.apache.seatunnel.engine.server.master.JobMaster.handleSaveMode(JobMaster.java:374)
                        ... 19 more
        
                at 
org.apache.seatunnel.engine.server.CoordinatorService.lambda$submitJob$4(CoordinatorService.java:506)
                at 
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515)
                at java.util.concurrent.FutureTask.run(FutureTask.java:264)
                at 
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
                at 
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
                at java.lang.Thread.run(Thread.java:829)
   ```
   
   
   ### Zeta or Flink or Spark Version
   
   _No response_
   
   ### Java or Scala Version
   
   open jdk 11
   
   ### Screenshots
   
   null
   
   ### 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]


Reply via email to