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

   ### 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
   
   
![image](https://github.com/user-attachments/assets/503020c9-6c6f-4280-9bdf-09f4ffd1246d)
   
![image](https://github.com/user-attachments/assets/e61cc440-8e23-4504-9387-55994f1f30b9)
   
   
![image](https://github.com/user-attachments/assets/17fe982c-2a88-4848-8ec0-200fb9d22803)
   web点击执行直接执行插入错误的语句
   
   ### SeaTunnel Version
   
   3.3.6
   
   ### SeaTunnel Config
   
   ```conf
   env {
   "job.mode"=BATCH
   "job.name"="SeaTunnel_Job"
   "savemode.execute.location"=CLUSTER
   }
   source {
   Jdbc {
       "connection_check_timeout_sec"=30
       "use_select_count"="false"
       "skip_analyze"="false"
       "split.size"=8096
       "split.even-distribution.factor.upper-bound"=100
       "split.even-distribution.factor.lower-bound"=0.05
       "split.sample-sharding.threshold"=1000
       "split.inverse-sampling.rate"=1000
       parallelism=1
       "result_table_name"=Table14617227625728
       query="SELECT `id`, `type`, `role_name`, `description`, `create_time`, 
`update_time` FROM `seatunnel`.`role`"
       password="123456"
       
url="jdbc:mysql://127.0.0.1:3380/test1?useUnicode=true&characterEncoding=UTF-8&rewriteBatchedStatements=true"
       driver="com.mysql.cj.jdbc.Driver"
       user=root
   }
   }
   transform {
   }
   sink {
   Jdbc {
       "schema_save_mode"="CREATE_SCHEMA_WHEN_NOT_EXIST"
       "data_save_mode"="APPEND_DATA"
       "connection_check_timeout_sec"=30
       "batch_size"=1000
       "is_exactly_once"="false"
       "max_commit_attempts"=3
       "transaction_timeout_sec"=-1
       "max_retries"="3"
       "auto_commit"="true"
       "support_upsert_by_query_primary_key_exist"="false"
       "multi_table_sink_replica"=1
       "source_table_name"=Table14617227625728
       "generate_sink_sql"=true
       database=test3
       table=role
       password="123456"
       
url="jdbc:mysql://127.0.0.1:3380/test1?useUnicode=true&characterEncoding=UTF-8&rewriteBatchedStatements=true"
       driver="com.mysql.cj.jdbc.Driver"
       user=root
   }
   }
   ```
   
   
   ### Running Command
   
   ```shell
   我点击执行页面的时候结果去执行插入角色表数据的时候直接插入的是用户表的字段了
   ```
   
   
   ### Error Exception
   
   ```log
   seatuuul执行的日志
   2024-08-15 15:23:58,927 INFO  [.p.t.AuthenticationMessageTask] 
[hz.main.priority-generic-operation.thread-0] - [localhost]:5801 [seatunnel] 
[5.1] Received auth from Connection[id=35, /127.0.0.1:5801->/127.0.0.1:37954, 
qualifier=null, endpoint=[127.0.0.1]:37954, 
remoteUuid=b0a39238-e4be-4175-82bd-8ecd40f8864d, alive=true, 
connectionType=JVM, planeIndex=-1], successfully authenticated, clientUuid: 
b0a39238-e4be-4175-82bd-8ecd40f8864d, client name: hz.client_35, client 
version: 5.1
   2024-08-15 15:23:59,035 INFO  [o.a.s.e.s.m.JobMaster         ] 
[seatunnel-coordinator-service-5] - in batch mode, the 'checkpoint.interval' 
configuration of env is missing, so checkpoint will be disabled
   2024-08-15 15:23:59,035 INFO  [o.a.s.e.s.m.JobMaster         ] 
[seatunnel-coordinator-service-5] - Init JobMaster for Job 14627358579200_job 
(876365590837592065)
   2024-08-15 15:23:59,035 INFO  [o.a.s.e.s.m.JobMaster         ] 
[seatunnel-coordinator-service-5] - Job 14627358579200_job (876365590837592065) 
needed jar urls 
[file:/app01/seatuunel/apache-seatunnel-2.3.6/connectors/connector-jdbc-2.3.6.jar]
   2024-08-15 15:23:59,035 INFO  [.c.c.DefaultClassLoaderService] 
[seatunnel-coordinator-service-5] - Create classloader for job 
876365590837592065 with jars 
[file:/app01/seatuunel/apache-seatunnel-2.3.6/connectors/connector-jdbc-2.3.6.jar]
   2024-08-15 15:23:59,076 INFO  [o.a.s.c.s.j.c.m.MySqlCatalog  ] 
[seatunnel-coordinator-service-5] - Failed to get mysql version, fallback to 
default version: V_5_7
   java.lang.UnsupportedOperationException: Unsupported MySQL version: 8.3.0
           at 
org.apache.seatunnel.connectors.seatunnel.jdbc.internal.dialect.mysql.MySqlVersion.parse(MySqlVersion.java:45)
 ~[?:?]
           at 
org.apache.seatunnel.connectors.seatunnel.jdbc.catalog.mysql.MySqlCatalog.resolveVersion(MySqlCatalog.java:211)
 ~[?:?]
           at 
org.apache.seatunnel.connectors.seatunnel.jdbc.catalog.mysql.MySqlCatalog.<init>(MySqlCatalog.java:67)
 ~[?:?]
           at 
org.apache.seatunnel.connectors.seatunnel.jdbc.catalog.mysql.MySqlCatalogFactory.createCatalog(MySqlCatalogFactory.java:53)
 ~[?:?]
           at 
org.apache.seatunnel.api.table.factory.FactoryUtil.lambda$createOptionalCatalog$0(FactoryUtil.java:174)
 ~[seatunnel-starter.jar:2.3.6]
           at java.util.Optional.map(Optional.java:215) ~[?:1.8.0_191]
           at 
org.apache.seatunnel.api.table.factory.FactoryUtil.createOptionalCatalog(FactoryUtil.java:173)
 ~[seatunnel-starter.jar:2.3.6]
           at 
org.apache.seatunnel.connectors.seatunnel.jdbc.utils.JdbcCatalogUtils.findCatalog(JdbcCatalogUtils.java:382)
 ~[?:?]
           at 
org.apache.seatunnel.connectors.seatunnel.jdbc.sink.JdbcSink.getSaveModeHandler(JdbcSink.java:197)
 ~[?:?]
           at 
org.apache.seatunnel.engine.server.master.JobMaster.handleSaveMode(JobMaster.java:370)
 ~[seatunnel-starter.jar:2.3.6]
           at 
org.apache.seatunnel.engine.server.master.JobMaster.handleSaveMode(JobMaster.java:381)
 ~[seatunnel-starter.jar:2.3.6]
           at 
java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:184) 
~[?:1.8.0_191]
           at 
java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:193) 
~[?:1.8.0_191]
           at 
java.util.stream.ReferencePipeline$2$1.accept(ReferencePipeline.java:175) 
~[?:1.8.0_191]
           at 
java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:193) 
~[?:1.8.0_191]
           at java.util.Iterator.forEachRemaining(Iterator.java:116) 
~[?:1.8.0_191]
           at 
java.util.Spliterators$IteratorSpliterator.forEachRemaining(Spliterators.java:1801)
 ~[?:1.8.0_191]
           at 
java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:481) 
~[?:1.8.0_191]
           at 
java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:471) 
~[?:1.8.0_191]
           at 
java.util.stream.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:151) 
~[?:1.8.0_191]
           at 
java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:174)
 ~[?:1.8.0_191]
           at 
java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234) 
~[?:1.8.0_191]
           at 
java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:418) 
~[?:1.8.0_191]
           at 
org.apache.seatunnel.engine.server.master.JobMaster.init(JobMaster.java:240) 
~[seatunnel-starter.jar:2.3.6]
           at 
org.apache.seatunnel.engine.server.CoordinatorService.lambda$submitJob$4(CoordinatorService.java:499)
 ~[seatunnel-starter.jar:2.3.6]
           at 
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) 
~[?:1.8.0_191]
           at java.util.concurrent.FutureTask.run(FutureTask.java:266) 
~[?:1.8.0_191]
           at 
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) 
~[?:1.8.0_191]
           at 
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) 
~[?:1.8.0_191]
           at java.lang.Thread.run(Thread.java:748) [?:1.8.0_191]
   2024-08-15 15:23:59,078 INFO  [.s.c.s.j.c.AbstractJdbcCatalog] 
[seatunnel-coordinator-service-5] - Catalog MySQL established connection to 
jdbc:mysql://127.0.0.1:3380/test1?useUnicode=true&characterEncoding=UTF-8&rewriteBatchedStatements=true
   2024-08-15 15:23:59,080 INFO  [a.s.a.s.SaveModeExecuteWrapper] 
[seatunnel-coordinator-service-5] - Executing save mode for table: test3.role, 
with SchemaSaveMode: CREATE_SCHEMA_WHEN_NOT_EXIST, DataSaveMode: APPEND_DATA 
using Catalog: MySQL
   2024-08-15 15:23:59,097 INFO  [.s.c.s.j.c.AbstractJdbcCatalog] 
[seatunnel-coordinator-service-5] - Catalog MySQL closing
   2024-08-15 15:23:59,102 INFO  [.c.c.DefaultClassLoaderService] 
[seatunnel-coordinator-service-5] - Release classloader for job 
876365590837592065 with jars 
[file:/app01/seatuunel/apache-seatunnel-2.3.6/connectors/connector-jdbc-2.3.6.jar]
   2024-08-15 15:23:59,110 INFO  [.s.e.s.c.CheckpointCoordinator] 
[seatunnel-coordinator-service-5] - Create CheckpointCoordinator for 
job(1@876365590837592065) with plan(CheckpointPlan(pipelineId=1, 
pipelineSubtasks=[TaskLocation{taskGroupLocation=TaskGroupLocation{jobId=876365590837592065,
 pipelineId=1, taskGroupId=30000}, taskID=40000, index=0}, 
TaskLocation{taskGroupLocation=TaskGroupLocation{jobId=876365590837592065, 
pipelineId=1, taskGroupId=30000}, taskID=50000, index=0}, 
TaskLocation{taskGroupLocation=TaskGroupLocation{jobId=876365590837592065, 
pipelineId=1, taskGroupId=1}, taskID=20000, index=0}], 
startingSubtasks=[TaskLocation{taskGroupLocation=TaskGroupLocation{jobId=876365590837592065,
 pipelineId=1, taskGroupId=1}, taskID=20000, index=0}], 
pipelineActions={ActionStateKey(name=ActionStateKey - pipeline-1 
[Source[0]-Jdbc])=1, ActionStateKey(name=ActionStateKey - pipeline-1 
[Sink[0]-Jdbc-MultiTableSink])=1}, 
subtaskActions={TaskLocation{taskGroupLocation=TaskGroupLocation{jo
 bId=876365590837592065, pipelineId=1, taskGroupId=30000}, taskID=40000, 
index=0}=[(ActionStateKey(name=ActionStateKey - pipeline-1 [Source[0]-Jdbc]), 
0)], TaskLocation{taskGroupLocation=TaskGroupLocation{jobId=876365590837592065, 
pipelineId=1, taskGroupId=30000}, taskID=50000, 
index=0}=[(ActionStateKey(name=ActionStateKey - pipeline-1 
[Sink[0]-Jdbc-MultiTableSink]), 0)], 
TaskLocation{taskGroupLocation=TaskGroupLocation{jobId=876365590837592065, 
pipelineId=1, taskGroupId=1}, taskID=20000, 
index=0}=[(ActionStateKey(name=ActionStateKey - pipeline-1 [Source[0]-Jdbc]), 
-1)]}))
   2024-08-15 15:23:59,110 INFO  [o.a.s.e.s.d.p.PhysicalVertex  ] 
[seatunnel-coordinator-service-5] - The task Job 14627358579200_job 
(876365590837592065), Pipeline: [(1/1)], task: [pipeline-1 
[Source[0]-Jdbc]-SourceTask (1/1)] is in state CREATED when init state future
   2024-08-15 15:23:59,110 INFO  [o.a.s.e.s.d.p.PhysicalVertex  ] 
[seatunnel-coordinator-service-5] - The task Job 14627358579200_job 
(876365590837592065), Pipeline: [(1/1)], task: [pipeline-1 
[Source[0]-Jdbc]-SplitEnumerator (1/1)] is in state CREATED when init state 
future
   2024-08-15 15:23:59,110 INFO  [o.a.s.e.s.d.p.PhysicalPlan    ] 
[seatunnel-coordinator-service-5] - Job 14627358579200_job (876365590837592065) 
state process is start
   2024-08-15 15:23:59,111 INFO  [o.a.s.e.s.d.p.PhysicalPlan    ] 
[seatunnel-coordinator-service-5] - Job 14627358579200_job (876365590837592065) 
turned from state CREATED to SCHEDULED.
   2024-08-15 15:23:59,111 INFO  [o.a.s.e.s.d.p.SubPlan         ] 
[seatunnel-coordinator-service-5] - Job 14627358579200_job 
(876365590837592065), Pipeline: [(1/1)] state process is start
   2024-08-15 15:23:59,112 INFO  [o.a.s.e.s.d.p.SubPlan         ] 
[seatunnel-coordinator-service-5] - Job 14627358579200_job 
(876365590837592065), Pipeline: [(1/1)] turned from state CREATED to SCHEDULED.
   2024-08-15 15:23:59,113 INFO  [o.a.s.e.s.d.p.SubPlan         ] 
[seatunnel-coordinator-service-5] - Job 14627358579200_job 
(876365590837592065), Pipeline: [(1/1)] turned from state SCHEDULED to 
DEPLOYING.
   2024-08-15 15:23:59,113 INFO  [o.a.s.e.s.d.p.PhysicalVertex  ] 
[seatunnel-coordinator-service-5] - Job 14627358579200_job 
(876365590837592065), Pipeline: [(1/1)], task: [pipeline-1 
[Source[0]-Jdbc]-SplitEnumerator (1/1)] state process is start
   2024-08-15 15:23:59,114 INFO  [o.a.s.e.s.d.p.PhysicalVertex  ] 
[seatunnel-coordinator-service-5] - Job 14627358579200_job 
(876365590837592065), Pipeline: [(1/1)], task: [pipeline-1 
[Source[0]-Jdbc]-SplitEnumerator (1/1)] turned from state CREATED to DEPLOYING.
   2024-08-15 15:23:59,115 INFO  [o.a.s.e.s.TaskExecutionService] 
[seatunnel-coordinator-service-5] - [localhost]:5801 [seatunnel] [5.1] received 
deploying task executionId [876365022048550913]
   2024-08-15 15:23:59,115 INFO  [.c.c.DefaultClassLoaderService] 
[seatunnel-coordinator-service-5] - Create classloader for job 
876365590837592065 with jars 
[file:/app01/seatuunel/apache-seatunnel-2.3.6/connectors/connector-jdbc-2.3.6.jar]
   2024-08-15 15:23:59,123 INFO  [o.a.s.e.s.TaskExecutionService] 
[seatunnel-coordinator-service-5] - [localhost]:5801 [seatunnel] [5.1] 
deploying task TaskGroupLocation{jobId=876365590837592065, pipelineId=1, 
taskGroupId=1}, executionId [876365022048550913]
   2024-08-15 15:23:59,123 INFO  [o.a.s.e.s.TaskExecutionService] 
[seatunnel-coordinator-service-5] - [localhost]:5801 [seatunnel] [5.1] 
deploying TaskGroup TaskGroupLocation{jobId=876365590837592065, pipelineId=1, 
taskGroupId=1} init success
   2024-08-15 15:23:59,124 INFO  [o.a.s.e.s.TaskExecutionService] 
[seatunnel-coordinator-service-5] - [localhost]:5801 [seatunnel] [5.1] 
deploying TaskGroup TaskGroupLocation{jobId=876365590837592065, pipelineId=1, 
taskGroupId=1} success
   2024-08-15 15:23:59,125 INFO  [.s.t.SourceSplitEnumeratorTask] 
[BlockingWorker-TaskGroupLocation{jobId=876365590837592065, pipelineId=1, 
taskGroupId=1}] - starting seatunnel source split enumerator task, source name: 
pipeline-1 [Source[0]-Jdbc]
   2024-08-15 15:23:59,126 INFO  [o.a.s.e.s.d.p.PhysicalVertex  ] 
[seatunnel-coordinator-service-5] - Job 14627358579200_job 
(876365590837592065), Pipeline: [(1/1)], task: [pipeline-1 
[Source[0]-Jdbc]-SplitEnumerator (1/1)] turned from state DEPLOYING to RUNNING.
   2024-08-15 15:23:59,126 INFO  [o.a.s.e.s.d.p.PhysicalVertex  ] 
[seatunnel-coordinator-service-5] - Job 14627358579200_job 
(876365590837592065), Pipeline: [(1/1)], task: [pipeline-1 
[Source[0]-Jdbc]-SplitEnumerator (1/1)] current state equals target state: 
RUNNING, skip
   2024-08-15 15:23:59,126 INFO  [o.a.s.e.s.d.p.PhysicalVertex  ] 
[seatunnel-coordinator-service-5] - Job 14627358579200_job 
(876365590837592065), Pipeline: [(1/1)], task: [pipeline-1 
[Source[0]-Jdbc]-SourceTask (1/1)] state process is start
   2024-08-15 15:23:59,126 INFO  [o.a.s.e.s.d.p.PhysicalVertex  ] 
[seatunnel-coordinator-service-5] - Job 14627358579200_job 
(876365590837592065), Pipeline: [(1/1)], task: [pipeline-1 
[Source[0]-Jdbc]-SourceTask (1/1)] turned from state CREATED to DEPLOYING.
   2024-08-15 15:23:59,128 INFO  [o.a.s.e.s.TaskExecutionService] 
[seatunnel-coordinator-service-5] - [localhost]:5801 [seatunnel] [5.1] received 
deploying task executionId [876365022048616449]
   2024-08-15 15:23:59,143 INFO  [o.a.s.c.s.j.s.ChunkSplitter   ] 
[hz.main.seaTunnel.task.thread-7] - Switch to dynamic chunk splitter
   2024-08-15 15:23:59,148 INFO  [o.a.s.e.s.TaskExecutionService] 
[seatunnel-coordinator-service-5] - [localhost]:5801 [seatunnel] [5.1] 
deploying task TaskGroupLocation{jobId=876365590837592065, pipelineId=1, 
taskGroupId=30000}, executionId [876365022048616449]
   2024-08-15 15:23:59,148 INFO  [o.a.s.e.s.TaskExecutionService] 
[seatunnel-coordinator-service-5] - [localhost]:5801 [seatunnel] [5.1] 
deploying TaskGroup TaskGroupLocation{jobId=876365590837592065, pipelineId=1, 
taskGroupId=30000} init success
   2024-08-15 15:23:59,156 INFO  [s.e.s.t.TransformSeaTunnelTask] 
[BlockingWorker-TaskGroupLocation{jobId=876365590837592065, pipelineId=1, 
taskGroupId=30000}] - starting seatunnel transform task, index 0
   2024-08-15 15:23:59,156 INFO  [o.a.s.e.s.TaskExecutionService] 
[seatunnel-coordinator-service-5] - [localhost]:5801 [seatunnel] [5.1] 
deploying TaskGroup TaskGroupLocation{jobId=876365590837592065, pipelineId=1, 
taskGroupId=30000} success
   2024-08-15 15:23:59,158 INFO  [o.a.s.c.s.j.s.ChunkSplitter   ] 
[BlockingWorker-TaskGroupLocation{jobId=876365590837592065, pipelineId=1, 
taskGroupId=30000}] - Switch to dynamic chunk splitter
   2024-08-15 15:23:59,160 INFO  [o.a.s.e.s.d.p.PhysicalVertex  ] 
[seatunnel-coordinator-service-5] - Job 14627358579200_job 
(876365590837592065), Pipeline: [(1/1)], task: [pipeline-1 
[Source[0]-Jdbc]-SourceTask (1/1)] turned from state DEPLOYING to RUNNING.
   2024-08-15 15:23:59,160 INFO  [o.a.s.e.s.d.p.PhysicalVertex  ] 
[seatunnel-coordinator-service-5] - Job 14627358579200_job 
(876365590837592065), Pipeline: [(1/1)], task: [pipeline-1 
[Source[0]-Jdbc]-SourceTask (1/1)] current state equals target state: RUNNING, 
skip
   2024-08-15 15:23:59,161 INFO  [o.a.s.e.s.d.p.SubPlan         ] 
[seatunnel-coordinator-service-5] - Job 14627358579200_job 
(876365590837592065), Pipeline: [(1/1)] turned from state DEPLOYING to RUNNING.
   2024-08-15 15:23:59,161 INFO  [o.a.s.e.s.d.p.PhysicalPlan    ] 
[seatunnel-coordinator-service-5] - Job 14627358579200_job (876365590837592065) 
turned from state SCHEDULED to RUNNING.
   2024-08-15 15:23:59,165 INFO  [a.s.a.s.m.MultiTableSinkWriter] 
[hz.main.seaTunnel.task.thread-7] - init multi table sink writer, queue size: 1
   2024-08-15 15:23:59,170 INFO  [.a.s.e.s.t.SourceSeaTunnelTask] 
[BlockingWorker-TaskGroupLocation{jobId=876365590837592065, pipelineId=1, 
taskGroupId=30000}] - starting seatunnel source task, index 0
   2024-08-15 15:23:59,174 INFO  [.s.t.SourceSplitEnumeratorTask] 
[hz.main.seaTunnel.task.thread-7] - received reader register, readerID: 
TaskLocation{taskGroupLocation=TaskGroupLocation{jobId=876365590837592065, 
pipelineId=1, taskGroupId=30000}, taskID=40000, index=0}
   2024-08-15 15:23:59,174 INFO  [.j.s.JdbcSourceSplitEnumerator] 
[hz.main.seaTunnel.task.thread-7] - Register reader 0 to 
JdbcSourceSplitEnumerator.
   2024-08-15 15:23:59,263 INFO  [.s.e.s.c.CheckpointCoordinator] 
[seatunnel-coordinator-service-6] - checkpoint is disabled, because in batch 
mode and 'checkpoint.interval' of env is missing.
   2024-08-15 15:23:59,326 INFO  [.s.t.SourceSplitEnumeratorTask] 
[BlockingWorker-TaskGroupLocation{jobId=876365590837592065, pipelineId=1, 
taskGroupId=1}] - received enough reader, starting enumerator...
   2024-08-15 15:23:59,326 INFO  [.j.s.JdbcSourceSplitEnumerator] 
[BlockingWorker-TaskGroupLocation{jobId=876365590837592065, pipelineId=1, 
taskGroupId=1}] - Starting split enumerator.
   2024-08-15 15:23:59,326 INFO  [.j.s.JdbcSourceSplitEnumerator] 
[BlockingWorker-TaskGroupLocation{jobId=876365590837592065, pipelineId=1, 
taskGroupId=1}] - Splitting table default.default.default.
   2024-08-15 15:23:59,326 INFO  [o.a.s.c.s.j.s.ChunkSplitter   ] 
[BlockingWorker-TaskGroupLocation{jobId=876365590837592065, pipelineId=1, 
taskGroupId=1}] - Start splitting table default.default.default into chunks...
   2024-08-15 15:23:59,327 WARN  [o.a.s.c.s.j.s.ChunkSplitter   ] 
[BlockingWorker-TaskGroupLocation{jobId=876365590837592065, pipelineId=1, 
taskGroupId=1}] - No split key found for table default.default.default
   2024-08-15 15:23:59,328 INFO  [o.a.s.c.s.j.s.ChunkSplitter   ] 
[BlockingWorker-TaskGroupLocation{jobId=876365590837592065, pipelineId=1, 
taskGroupId=1}] - Split table default.default.default into 1 chunks, time cost: 
2ms.
   2024-08-15 15:23:59,328 INFO  [.j.s.JdbcSourceSplitEnumerator] 
[BlockingWorker-TaskGroupLocation{jobId=876365590837592065, pipelineId=1, 
taskGroupId=1}] - Split table default.default.default into 1 splits.
   2024-08-15 15:23:59,329 INFO  [.j.s.JdbcSourceSplitEnumerator] 
[BlockingWorker-TaskGroupLocation{jobId=876365590837592065, pipelineId=1, 
taskGroupId=1}] - No more splits to assign. Sending NoMoreSplitsEvent to reader 
[0].
   2024-08-15 15:24:00,297 INFO  [o.a.s.c.s.j.s.JdbcSourceReader] 
[BlockingWorker-TaskGroupLocation{jobId=876365590837592065, pipelineId=1, 
taskGroupId=30000}] - Closed the bounded jdbc source
   2024-08-15 15:24:00,297 WARN  [o.a.s.s.c.z.h.HikariConfig    ] 
[st-multi-table-sink-writer-1] - HikariPool-5 - idleTimeout has been set but 
has no effect because the pool is operating as a fixed size pool.
   2024-08-15 15:24:00,297 INFO  [o.a.s.s.c.z.h.HikariDataSource] 
[st-multi-table-sink-writer-1] - HikariPool-5 - Starting...
   2024-08-15 15:24:00,320 INFO  [o.a.s.s.c.z.h.HikariDataSource] 
[st-multi-table-sink-writer-1] - HikariPool-5 - Start completed.
   2024-08-15 15:24:00,327 INFO  [.e.FieldNamedPreparedStatement] 
[st-multi-table-sink-writer-1] - PrepareStatement sql is:
   INSERT INTO `test3`.`role` (`id`, `username`, `password`, `status`, `type`, 
`create_time`, `update_time`) VALUES (?, ?, ?, ?, ?, ?, ?)
   
   2024-08-15 15:24:00,332 INFO  [.s.e.s.c.CheckpointCoordinator] 
[seatunnel-coordinator-service-6] - wait checkpoint completed: 
9223372036854775807
   2024-08-15 15:24:00,339 ERROR [o.a.s.c.s.j.i.JdbcOutputFormat] 
[st-multi-table-sink-writer-2] - JDBC executeBatch error, retry times = 0
   java.sql.BatchUpdateException: Unknown column 'username' in 'field list'
           at sun.reflect.GeneratedConstructorAccessor32.newInstance(Unknown 
Source) ~[?:?]
           at 
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
 ~[?:1.8.0_191]
           at java.lang.reflect.Constructor.newInstance(Constructor.java:423) 
~[?:1.8.0_191]
           at com.mysql.cj.util.Util.handleNewInstance(Util.java:192) 
~[mysql-connector-java-8.0.27.jar:8.0.27]
           at com.mysql.cj.util.Util.getInstance(Util.java:167) 
~[mysql-connector-java-8.0.27.jar:8.0.27]
           at com.mysql.cj.util.Util.getInstance(Util.java:174) 
~[mysql-connector-java-8.0.27.jar:8.0.27]
           at 
com.mysql.cj.jdbc.exceptions.SQLError.createBatchUpdateException(SQLError.java:224)
 ~[mysql-connector-java-8.0.27.jar:8.0.27]
           at 
com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchedInserts(ClientPreparedStatement.java:755)
 ~[mysql-connector-java-8.0.27.jar:8.0.27]
           at 
com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchInternal(ClientPreparedStatement.java:426)
 ~[mysql-connector-java-8.0.27.jar:8.0.27]
           at 
com.mysql.cj.jdbc.StatementImpl.executeBatch(StatementImpl.java:800) 
~[mysql-connector-java-8.0.27.jar:8.0.27]
           at 
org.apache.seatunnel.shade.com.zaxxer.hikari.pool.ProxyStatement.executeBatch(ProxyStatement.java:127)
 ~[?:?]
           at 
org.apache.seatunnel.shade.com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeBatch(HikariProxyPreparedStatement.java)
 ~[?:?]
           at 
org.apache.seatunnel.connectors.seatunnel.jdbc.internal.executor.FieldNamedPreparedStatement.executeBatch(FieldNamedPreparedStatement.java:534)
 ~[?:?]
           at 
org.apache.seatunnel.connectors.seatunnel.jdbc.internal.executor.SimpleBatchStatementExecutor.executeBatch(SimpleBatchStatementExecutor.java:51)
 ~[?:?]
           at 
org.apache.seatunnel.connectors.seatunnel.jdbc.internal.executor.BufferedBatchStatementExecutor.executeBatch(BufferedBatchStatementExecutor.java:53)
 ~[?:?]
           at 
org.apache.seatunnel.connectors.seatunnel.jdbc.internal.JdbcOutputFormat.attemptFlush(JdbcOutputFormat.java:172)
 ~[?:?]
           at 
org.apache.seatunnel.connectors.seatunnel.jdbc.internal.JdbcOutputFormat.flush(JdbcOutputFormat.java:136)
 ~[?:?]
           at 
org.apache.seatunnel.connectors.seatunnel.jdbc.sink.JdbcSinkWriter.prepareCommit(JdbcSinkWriter.java:131)
 ~[?:?]
           at 
org.apache.seatunnel.api.sink.multitablesink.MultiTableSinkWriter.lambda$prepareCommit$4(MultiTableSinkWriter.java:217)
 ~[seatunnel-starter.jar:2.3.6]
           at 
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) 
~[?:1.8.0_191]
           at java.util.concurrent.FutureTask.run(FutureTask.java:266) 
~[?:1.8.0_191]
           at 
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) 
~[?:1.8.0_191]
           at 
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) 
~[?:1.8.0_191]
           at java.lang.Thread.run(Thread.java:748) [?:1.8.0_191]
   Caused by: java.sql.SQLSyntaxErrorException: Unknown column 'username' in 
'field list'
           at 
com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120) 
~[mysql-connector-java-8.0.27.jar:8.0.27]
           at 
com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
 ~[mysql-connector-java-8.0.27.jar:8.0.27]
           at 
com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953)
 ~[mysql-connector-java-8.0.27.jar:8.0.27]
           at 
com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1098)
 ~[mysql-connector-java-8.0.27.jar:8.0.27]
           at 
com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1046)
 ~[mysql-connector-java-8.0.27.jar:8.0.27]
           at 
com.mysql.cj.jdbc.ClientPreparedStatement.executeLargeUpdate(ClientPreparedStatement.java:1371)
 ~[mysql-connector-java-8.0.27.jar:8.0.27]
           at 
com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchedInserts(ClientPreparedStatement.java:716)
 ~[mysql-connector-java-8.0.27.jar:8.0.27]
           ... 16 more
   2024-08-15 15:24:00,344 ERROR [o.a.s.c.s.j.i.JdbcOutputFormat] 
[st-multi-table-sink-writer-2] - JDBC executeBatch error, retry times = 1
   java.sql.BatchUpdateException: Unknown column 'username' in 'field list'
           at sun.reflect.GeneratedConstructorAccessor32.newInstance(Unknown 
Source) ~[?:?]
           at 
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
 ~[?:1.8.0_191]
           at java.lang.reflect.Constructor.newInstance(Constructor.java:423) 
~[?:1.8.0_191]
           at com.mysql.cj.util.Util.handleNewInstance(Util.java:192) 
~[mysql-connector-java-8.0.27.jar:8.0.27]
           at com.mysql.cj.util.Util.getInstance(Util.java:167) 
~[mysql-connector-java-8.0.27.jar:8.0.27]
           at com.mysql.cj.util.Util.getInstance(Util.java:174) 
~[mysql-connector-java-8.0.27.jar:8.0.27]
           at 
com.mysql.cj.jdbc.exceptions.SQLError.createBatchUpdateException(SQLError.java:224)
 ~[mysql-connector-java-8.0.27.jar:8.0.27]
           at 
com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchedInserts(ClientPreparedStatement.java:755)
 ~[mysql-connector-java-8.0.27.jar:8.0.27]
           at 
com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchInternal(ClientPreparedStatement.java:426)
 ~[mysql-connector-java-8.0.27.jar:8.0.27]
           at 
com.mysql.cj.jdbc.StatementImpl.executeBatch(StatementImpl.java:800) 
~[mysql-connector-java-8.0.27.jar:8.0.27]
           at 
org.apache.seatunnel.shade.com.zaxxer.hikari.pool.ProxyStatement.executeBatch(ProxyStatement.java:127)
 ~[?:?]
           at 
org.apache.seatunnel.shade.com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeBatch(HikariProxyPreparedStatement.java)
 ~[?:?]
           at 
org.apache.seatunnel.connectors.seatunnel.jdbc.internal.executor.FieldNamedPreparedStatement.executeBatch(FieldNamedPreparedStatement.java:534)
 ~[?:?]
           at 
org.apache.seatunnel.connectors.seatunnel.jdbc.internal.executor.SimpleBatchStatementExecutor.executeBatch(SimpleBatchStatementExecutor.java:51)
 ~[?:?]
           at 
org.apache.seatunnel.connectors.seatunnel.jdbc.internal.executor.BufferedBatchStatementExecutor.executeBatch(BufferedBatchStatementExecutor.java:53)
 ~[?:?]
           at 
org.apache.seatunnel.connectors.seatunnel.jdbc.internal.JdbcOutputFormat.attemptFlush(JdbcOutputFormat.java:172)
 ~[?:?]
           at 
org.apache.seatunnel.connectors.seatunnel.jdbc.internal.JdbcOutputFormat.flush(JdbcOutputFormat.java:136)
 ~[?:?]
           at 
org.apache.seatunnel.connectors.seatunnel.jdbc.sink.JdbcSinkWriter.prepareCommit(JdbcSinkWriter.java:131)
 ~[?:?]
           at 
org.apache.seatunnel.api.sink.multitablesink.MultiTableSinkWriter.lambda$prepareCommit$4(MultiTableSinkWriter.java:217)
 ~[seatunnel-starter.jar:2.3.6]
           at 
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) 
~[?:1.8.0_191]
           at java.util.concurrent.FutureTask.run(FutureTask.java:266) 
~[?:1.8.0_191]
           at 
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) 
~[?:1.8.0_191]
           at 
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) 
~[?:1.8.0_191]
           at java.lang.Thread.run(Thread.java:748) [?:1.8.0_191]
   Caused by: java.sql.SQLSyntaxErrorException: Unknown column 'username' in 
'field list'
           at 
com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120) 
~[mysql-connector-java-8.0.27.jar:8.0.27]
           at 
com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
 ~[mysql-connector-java-8.0.27.jar:8.0.27]
           at 
com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953)
 ~[mysql-connector-java-8.0.27.jar:8.0.27]
           at 
com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1098)
 ~[mysql-connector-java-8.0.27.jar:8.0.27]
           at 
com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1046)
 ~[mysql-connector-java-8.0.27.jar:8.0.27]
           at 
com.mysql.cj.jdbc.ClientPreparedStatement.executeLargeUpdate(ClientPreparedStatement.java:1371)
 ~[mysql-connector-java-8.0.27.jar:8.0.27]
           at 
com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchedInserts(ClientPreparedStatement.java:716)
 ~[mysql-connector-java-8.0.27.jar:8.0.27]
           ... 16 more
   2024-08-15 15:24:01,347 ERROR [o.a.s.c.s.j.i.JdbcOutputFormat] 
[st-multi-table-sink-writer-2] - JDBC executeBatch error, retry times = 2
   java.sql.BatchUpdateException: Unknown column 'username' in 'field list'
           at sun.reflect.GeneratedConstructorAccessor32.newInstance(Unknown 
Source) ~[?:?]
           at 
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
 ~[?:1.8.0_191]
           at java.lang.reflect.Constructor.newInstance(Constructor.java:423) 
~[?:1.8.0_191]
           at com.mysql.cj.util.Util.handleNewInstance(Util.java:192) 
~[mysql-connector-java-8.0.27.jar:8.0.27]
           at com.mysql.cj.util.Util.getInstance(Util.java:167) 
~[mysql-connector-java-8.0.27.jar:8.0.27]
           at com.mysql.cj.util.Util.getInstance(Util.java:174) 
~[mysql-connector-java-8.0.27.jar:8.0.27]
           at 
com.mysql.cj.jdbc.exceptions.SQLError.createBatchUpdateException(SQLError.java:224)
 ~[mysql-connector-java-8.0.27.jar:8.0.27]
           at 
com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchedInserts(ClientPreparedStatement.java:755)
 ~[mysql-connector-java-8.0.27.jar:8.0.27]
           at 
com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchInternal(ClientPreparedStatement.java:426)
 ~[mysql-connector-java-8.0.27.jar:8.0.27]
           at 
com.mysql.cj.jdbc.StatementImpl.executeBatch(StatementImpl.java:800) 
~[mysql-connector-java-8.0.27.jar:8.0.27]
           at 
org.apache.seatunnel.shade.com.zaxxer.hikari.pool.ProxyStatement.executeBatch(ProxyStatement.java:127)
 ~[?:?]
           at 
org.apache.seatunnel.shade.com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeBatch(HikariProxyPreparedStatement.java)
 ~[?:?]
           at 
org.apache.seatunnel.connectors.seatunnel.jdbc.internal.executor.FieldNamedPreparedStatement.executeBatch(FieldNamedPreparedStatement.java:534)
 ~[?:?]
           at 
org.apache.seatunnel.connectors.seatunnel.jdbc.internal.executor.SimpleBatchStatementExecutor.executeBatch(SimpleBatchStatementExecutor.java:51)
 ~[?:?]
           at 
org.apache.seatunnel.connectors.seatunnel.jdbc.internal.executor.BufferedBatchStatementExecutor.executeBatch(BufferedBatchStatementExecutor.java:53)
 ~[?:?]
           at 
org.apache.seatunnel.connectors.seatunnel.jdbc.internal.JdbcOutputFormat.attemptFlush(JdbcOutputFormat.java:172)
 ~[?:?]
           at 
org.apache.seatunnel.connectors.seatunnel.jdbc.internal.JdbcOutputFormat.flush(JdbcOutputFormat.java:136)
 ~[?:?]
           at 
org.apache.seatunnel.connectors.seatunnel.jdbc.sink.JdbcSinkWriter.prepareCommit(JdbcSinkWriter.java:131)
 ~[?:?]
           at 
org.apache.seatunnel.api.sink.multitablesink.MultiTableSinkWriter.lambda$prepareCommit$4(MultiTableSinkWriter.java:217)
 ~[seatunnel-starter.jar:2.3.6]
           at 
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) 
~[?:1.8.0_191]
           at java.util.concurrent.FutureTask.run(FutureTask.java:266) 
~[?:1.8.0_191]
           at 
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) 
~[?:1.8.0_191]
           at 
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) 
~[?:1.8.0_191]
           at java.lang.Thread.run(Thread.java:748) [?:1.8.0_191]
   Caused by: java.sql.SQLSyntaxErrorException: Unknown column 'username' in 
'field list'
           at 
com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120) 
~[mysql-connector-java-8.0.27.jar:8.0.27]
           at 
com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
 ~[mysql-connector-java-8.0.27.jar:8.0.27]
           at 
com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953)
 ~[mysql-connector-java-8.0.27.jar:8.0.27]
           at 
com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1098)
 ~[mysql-connector-java-8.0.27.jar:8.0.27]
           at 
com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1046)
 ~[mysql-connector-java-8.0.27.jar:8.0.27]
           at 
com.mysql.cj.jdbc.ClientPreparedStatement.executeLargeUpdate(ClientPreparedStatement.java:1371)
 ~[mysql-connector-java-8.0.27.jar:8.0.27]
           at 
com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchedInserts(ClientPreparedStatement.java:716)
 ~[mysql-connector-java-8.0.27.jar:8.0.27]
           ... 16 more
   2024-08-15 15:24:03,351 ERROR [o.a.s.c.s.j.i.JdbcOutputFormat] 
[st-multi-table-sink-writer-2] - JDBC executeBatch error, retry times = 3
   java.sql.BatchUpdateException: Unknown column 'username' in 'field list'
           at sun.reflect.GeneratedConstructorAccessor32.newInstance(Unknown 
Source) ~[?:?]
           at 
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
 ~[?:1.8.0_191]
           at java.lang.reflect.Constructor.newInstance(Constructor.java:423) 
~[?:1.8.0_191]
           at com.mysql.cj.util.Util.handleNewInstance(Util.java:192) 
~[mysql-connector-java-8.0.27.jar:8.0.27]
           at com.mysql.cj.util.Util.getInstance(Util.java:167) 
~[mysql-connector-java-8.0.27.jar:8.0.27]
           at com.mysql.cj.util.Util.getInstance(Util.java:174) 
~[mysql-connector-java-8.0.27.jar:8.0.27]
           at 
com.mysql.cj.jdbc.exceptions.SQLError.createBatchUpdateException(SQLError.java:224)
 ~[mysql-connector-java-8.0.27.jar:8.0.27]
           at 
com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchedInserts(ClientPreparedStatement.java:755)
 ~[mysql-connector-java-8.0.27.jar:8.0.27]
           at 
com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchInternal(ClientPreparedStatement.java:426)
 ~[mysql-connector-java-8.0.27.jar:8.0.27]
           at 
com.mysql.cj.jdbc.StatementImpl.executeBatch(StatementImpl.java:800) 
~[mysql-connector-java-8.0.27.jar:8.0.27]
           at 
org.apache.seatunnel.shade.com.zaxxer.hikari.pool.ProxyStatement.executeBatch(ProxyStatement.java:127)
 ~[?:?]
           at 
org.apache.seatunnel.shade.com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeBatch(HikariProxyPreparedStatement.java)
 ~[?:?]
           at 
org.apache.seatunnel.connectors.seatunnel.jdbc.internal.executor.FieldNamedPreparedStatement.executeBatch(FieldNamedPreparedStatement.java:534)
 ~[?:?]
           at 
org.apache.seatunnel.connectors.seatunnel.jdbc.internal.executor.SimpleBatchStatementExecutor.executeBatch(SimpleBatchStatementExecutor.java:51)
 ~[?:?]
           at 
org.apache.seatunnel.connectors.seatunnel.jdbc.internal.executor.BufferedBatchStatementExecutor.executeBatch(BufferedBatchStatementExecutor.java:53)
 ~[?:?]
           at 
org.apache.seatunnel.connectors.seatunnel.jdbc.internal.JdbcOutputFormat.attemptFlush(JdbcOutputFormat.java:172)
 ~[?:?]
           at 
org.apache.seatunnel.connectors.seatunnel.jdbc.internal.JdbcOutputFormat.flush(JdbcOutputFormat.java:136)
 ~[?:?]
           at 
org.apache.seatunnel.connectors.seatunnel.jdbc.sink.JdbcSinkWriter.prepareCommit(JdbcSinkWriter.java:131)
 ~[?:?]
           at 
org.apache.seatunnel.api.sink.multitablesink.MultiTableSinkWriter.lambda$prepareCommit$4(MultiTableSinkWriter.java:217)
 ~[seatunnel-starter.jar:2.3.6]
           at 
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) 
~[?:1.8.0_191]
           at java.util.concurrent.FutureTask.run(FutureTask.java:266) 
~[?:1.8.0_191]
           at 
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) 
~[?:1.8.0_191]
           at 
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) 
~[?:1.8.0_191]
           at java.lang.Thread.run(Thread.java:748) [?:1.8.0_191]
   Caused by: java.sql.SQLSyntaxErrorException: Unknown column 'username' in 
'field list'
           at 
com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120) 
~[mysql-connector-java-8.0.27.jar:8.0.27]
           at 
com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
 ~[mysql-connector-java-8.0.27.jar:8.0.27]
           at 
com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953)
 ~[mysql-connector-java-8.0.27.jar:8.0.27]
           at 
com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1098)
 ~[mysql-connector-java-8.0.27.jar:8.0.27]
           at 
com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1046)
 ~[mysql-connector-java-8.0.27.jar:8.0.27]
           at 
com.mysql.cj.jdbc.ClientPreparedStatement.executeLargeUpdate(ClientPreparedStatement.java:1371)
 ~[mysql-connector-java-8.0.27.jar:8.0.27]
           at 
com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchedInserts(ClientPreparedStatement.java:716)
 ~[mysql-connector-java-8.0.27.jar:8.0.27]
           ... 16 more
   web执行的日志:
   2024-08-15 16:39:44.939 seatunnel host-10-19-11-19 WARN [tr:,sp:] 
[qtp431939256-19] [SeatunnelPermissionServiceImpl.funcPermissionCheck():38] - 
func permission check in seatunnel
   2024-08-15 16:39:44.940 seatunnel host-10-19-11-19 INFO [tr:,sp:] 
[qtp431939256-19] [JobInstanceServiceImpl.createExecuteResource():130] - 
receive createExecuteResource request, userId:2, jobDefineId:14605812455584
   2024-08-15 16:39:45.001 seatunnel host-10-19-11-19 WARN [tr:,sp:] 
[qtp431939256-19] [SeatunnelPermissionServiceImpl.funcPermissionCheck():38] - 
func permission check in seatunnel
   2024-08-15 16:39:45.221 seatunnel host-10-19-11-19 WARN [tr:,sp:] 
[qtp431939256-19] [SeatunnelPermissionServiceImpl.funcPermissionCheck():38] - 
func permission check in seatunnel
   2024-08-15 16:39:45.230 seatunnel host-10-19-11-19 WARN [tr:,sp:] 
[qtp431939256-19] [SeatunnelPermissionServiceImpl.funcPermissionCheck():38] - 
func permission check in seatunnel
   2024-08-15 16:39:45.261 seatunnel host-10-19-11-19 WARN [tr:,sp:] 
[qtp431939256-19] [SeatunnelPermissionServiceImpl.funcPermissionCheck():38] - 
func permission check in seatunnel
   2024-08-15 16:39:45.296 seatunnel host-10-19-11-19 INFO [tr:,sp:] 
[qtp431939256-19] [JobExecutorServiceImpl.writeJobConfigIntoConfFile():96] - 
File created and content written successfully.
   Aug 15, 2024 4:39:45 PM com.hazelcast.internal.config.AbstractConfigLocator
   INFO: Loading 'hazelcast-client.yaml' from the classpath.
   2024-08-15 16:39:45.306 seatunnel host-10-19-11-19 INFO [tr:,sp:] 
[qtp431939256-19] [ClientLoggingService$DefaultLogger.log():104] - hz.client_2 
[seatunnel] [5.1] Running with 2 response threads, dynamic=true
   2024-08-15 16:39:45.308 seatunnel host-10-19-11-19 INFO [tr:,sp:] 
[qtp431939256-19] [ClientLoggingService$DefaultLogger.log():104] - hz.client_2 
[seatunnel] [5.1] HazelcastClient 5.1 (20220228 - 21f20e7) is STARTING
   2024-08-15 16:39:45.309 seatunnel host-10-19-11-19 INFO [tr:,sp:] 
[qtp431939256-19] [ClientLoggingService$DefaultLogger.log():104] - hz.client_2 
[seatunnel] [5.1] HazelcastClient 5.1 (20220228 - 21f20e7) is STARTED
   2024-08-15 16:39:45.310 seatunnel host-10-19-11-19 INFO [tr:,sp:] 
[qtp431939256-19] [ClientLoggingService$DefaultLogger.log():104] - hz.client_2 
[seatunnel] [5.1] Trying to connect to cluster: seatunnel
   2024-08-15 16:39:45.311 seatunnel host-10-19-11-19 INFO [tr:,sp:] 
[qtp431939256-19] [ClientLoggingService$DefaultLogger.log():104] - hz.client_2 
[seatunnel] [5.1] Trying to connect to [localhost]:5801
   2024-08-15 16:39:45.318 seatunnel host-10-19-11-19 INFO [tr:,sp:] 
[qtp431939256-19] [ClientLoggingService$DefaultLogger.log():104] - hz.client_2 
[seatunnel] [5.1] HazelcastClient 5.1 (20220228 - 21f20e7) is CLIENT_CONNECTED
   2024-08-15 16:39:45.318 seatunnel host-10-19-11-19 INFO [tr:,sp:] 
[qtp431939256-19] [ClientLoggingService$DefaultLogger.log():104] - hz.client_2 
[seatunnel] [5.1] Authenticated with server 
[localhost]:5801:e12041c0-446c-4dc9-8f65-af10a4336bab, server version: 5.1, 
local address: /127.0.0.1:33295
   2024-08-15 16:39:45.318 seatunnel host-10-19-11-19 INFO [tr:,sp:] 
[qtp431939256-19] [ClientLoggingService$DefaultLogger.log():104] - hz.client_2 
[seatunnel] [5.1] Diagnostics disabled. To enable add 
-Dhazelcast.diagnostics.enabled=true to the JVM arguments.
   2024-08-15 16:39:45.320 seatunnel host-10-19-11-19 INFO [tr:,sp:] 
[hz.client_2.event-9] [ClientLoggingService$DefaultLogger.log():104] - 
hz.client_2 [seatunnel] [5.1]
   
   Members [1] {
           Member [localhost]:5801 - e12041c0-446c-4dc9-8f65-af10a4336bab
   }
   
   2024-08-15 16:39:45.323 seatunnel host-10-19-11-19 INFO [tr:,sp:] 
[qtp431939256-19] [AbstractLogger.info():69] - Client statistics is enabled 
with period 5 seconds.
   Aug 15, 2024 4:39:45 PM com.hazelcast.internal.config.AbstractConfigLocator
   INFO: Loading 'seatunnel.yaml' from the classpath.
   2024-08-15 16:39:45.330 seatunnel host-10-19-11-19 INFO [tr:,sp:] 
[qtp431939256-19] [AbstractLogger.info():69] - seatunnel.home is 
/app01/seatuunel/apache-seatunnel-web-1.0.0-SNAPSHOT
   Aug 15, 2024 4:39:45 PM com.hazelcast.internal.config.AbstractConfigLocator
   INFO: Loading 'hazelcast.yaml' from the classpath.
   2024-08-15 16:39:45.418 seatunnel host-10-19-11-19 INFO [tr:,sp:] 
[qtp431939256-19] [ConfigBuilder.of():73] - Loading config file from path: 
/app01/seatuunel/apache-seatunnel-web-1.0.0-SNAPSHOT/profile/14605812455584.conf
   2024-08-15 16:39:45.425 seatunnel host-10-19-11-19 INFO [tr:,sp:] 
[qtp431939256-19] [ConfigShadeUtils.<clinit>():64] - Load config shade spi: 
[base64]
   2024-08-15 16:39:45.451 seatunnel host-10-19-11-19 INFO [tr:,sp:] 
[qtp431939256-19] 
[MultipleTableJobConfigParser.fillJobConfigAndCommonJars():303] - add common 
jar in plugins :[]
   2024-08-15 16:39:45.455 seatunnel host-10-19-11-19 INFO [tr:,sp:] 
[qtp431939256-19] [AbstractPluginDiscovery.<init>():113] - Load SeaTunnelSink 
Plugin from /app01/seatuunel/apache-seatunnel-2.3.6/connectors
   2024-08-15 16:39:45.456 seatunnel host-10-19-11-19 INFO [tr:,sp:] 
[qtp431939256-19] [AbstractPluginDiscovery.findPluginJarPath():444] - Discovery 
plugin jar for: PluginIdentifier{engineType='seatunnel', pluginType='source', 
pluginName='Jdbc'} at: 
file:/app01/seatuunel/apache-seatunnel-2.3.6/connectors/connector-jdbc-2.3.6.jar
   2024-08-15 16:39:45.456 seatunnel host-10-19-11-19 INFO [tr:,sp:] 
[qtp431939256-19] [AbstractPluginDiscovery.findPluginJarPath():444] - Discovery 
plugin jar for: PluginIdentifier{engineType='seatunnel', pluginType='sink', 
pluginName='Jdbc'} at: 
file:/app01/seatuunel/apache-seatunnel-2.3.6/connectors/connector-jdbc-2.3.6.jar
   2024-08-15 16:39:45.458 seatunnel host-10-19-11-19 WARN [tr:,sp:] 
[qtp431939256-19] [ConfigUtil.convertValue():64] - Option 'source_table_name' 
is a List, and it is recommended to configure it as ["string1","string2"]; we 
will only use ',' to split the String into a list.
   2024-08-15 16:39:45.459 seatunnel host-10-19-11-19 INFO [tr:,sp:] 
[qtp431939256-19] [MultipleTableJobConfigParser.parse():205] - start generating 
all sources.
   2024-08-15 16:39:45.726 seatunnel host-10-19-11-19 INFO [tr:,sp:] 
[qtp431939256-19] [MySqlCatalog.resolveVersion():213] - Failed to get mysql 
version, fallback to default version: V_5_7
   java.lang.UnsupportedOperationException: Unsupported MySQL version: 8.3.0
           at 
org.apache.seatunnel.connectors.seatunnel.jdbc.internal.dialect.mysql.MySqlVersion.parse(MySqlVersion.java:45)
           at 
org.apache.seatunnel.connectors.seatunnel.jdbc.catalog.mysql.MySqlCatalog.resolveVersion(MySqlCatalog.java:211)
           at 
org.apache.seatunnel.connectors.seatunnel.jdbc.catalog.mysql.MySqlCatalog.<init>(MySqlCatalog.java:67)
           at 
org.apache.seatunnel.connectors.seatunnel.jdbc.catalog.mysql.MySqlCatalogFactory.createCatalog(MySqlCatalogFactory.java:53)
           at 
org.apache.seatunnel.api.table.factory.FactoryUtil.lambda$createOptionalCatalog$0(FactoryUtil.java:175)
           at java.util.Optional.map(Optional.java:215)
           at 
org.apache.seatunnel.api.table.factory.FactoryUtil.createOptionalCatalog(FactoryUtil.java:174)
           at 
org.apache.seatunnel.connectors.seatunnel.jdbc.utils.JdbcCatalogUtils.findCatalog(JdbcCatalogUtils.java:382)
           at 
org.apache.seatunnel.connectors.seatunnel.jdbc.utils.JdbcCatalogUtils.getTables(JdbcCatalogUtils.java:73)
           at 
org.apache.seatunnel.connectors.seatunnel.jdbc.source.JdbcSource.<init>(JdbcSource.java:57)
           at 
org.apache.seatunnel.connectors.seatunnel.jdbc.source.JdbcSourceFactory.lambda$createSource$0(JdbcSourceFactory.java:80)
           at 
org.apache.seatunnel.api.table.factory.FactoryUtil.createAndPrepareSource(FactoryUtil.java:114)
           at 
org.apache.seatunnel.api.table.factory.FactoryUtil.createAndPrepareSource(FactoryUtil.java:74)
           at 
org.apache.seatunnel.engine.core.parse.MultipleTableJobConfigParser.parseSource(MultipleTableJobConfigParser.java:361)
           at 
org.apache.seatunnel.engine.core.parse.MultipleTableJobConfigParser.parse(MultipleTableJobConfigParser.java:209)
           at 
org.apache.seatunnel.engine.client.job.ClientJobExecutionEnvironment.getLogicalDag(ClientJobExecutionEnvironment.java:114)
           at 
org.apache.seatunnel.engine.client.job.ClientJobExecutionEnvironment.execute(ClientJobExecutionEnvironment.java:182)
           at 
org.apache.seatunnel.app.service.impl.JobExecutorServiceImpl.executeJobBySeaTunnel(JobExecutorServiceImpl.java:112)
           at 
org.apache.seatunnel.app.service.impl.JobExecutorServiceImpl.jobExecute(JobExecutorServiceImpl.java:76)
           at 
org.apache.seatunnel.app.controller.JobExecutorController.jobExecutor(JobExecutorController.java:55)
           at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
           at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
           at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
           at java.lang.reflect.Method.invoke(Method.java:498)
           at 
org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
           at 
org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:150)
           at 
org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117)
           at 
org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895)
           at 
org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:808)
           at 
org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
           at 
org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1067)
           at 
org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:963)
           at 
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
           at 
org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:898)
           at javax.servlet.http.HttpServlet.service(HttpServlet.java:497)
           at 
org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
           at javax.servlet.http.HttpServlet.service(HttpServlet.java:584)
           at 
org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:799)
           at 
org.eclipse.jetty.servlet.ServletHandler$ChainEnd.doFilter(ServletHandler.java:1631)
           at 
org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
           at 
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
           at 
org.eclipse.jetty.servlet.FilterHolder.doFilter(FilterHolder.java:193)
           at 
org.eclipse.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1601)
           at 
org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
           at 
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
           at 
org.eclipse.jetty.servlet.FilterHolder.doFilter(FilterHolder.java:193)
           at 
org.eclipse.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1601)
           at 
org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
           at 
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
           at 
org.eclipse.jetty.servlet.FilterHolder.doFilter(FilterHolder.java:193)
           at 
org.eclipse.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1601)
           at 
org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:548)
           at 
org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143)
           at 
org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:600)
           at 
org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127)
           at 
org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:235)
           at 
org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1624)
           at 
org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:233)
           at 
org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1440)
           at 
org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:188)
           at 
org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:501)
           at 
org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1594)
           at 
org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:186)
           at 
org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1355)
           at 
org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
           at 
org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127)
           at org.eclipse.jetty.server.Server.handle(Server.java:516)
           at 
org.eclipse.jetty.server.HttpChannel.lambda$handle$1(HttpChannel.java:487)
           at 
org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:732)
           at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:479)
           at 
org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:277)
           at 
org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:311)
           at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:105)
           at 
org.eclipse.jetty.io.ChannelEndPoint$1.run(ChannelEndPoint.java:104)
           at 
org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:338)
           at 
org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:315)
           at 
org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:173)
           at 
org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:131)
           at 
org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:409)
           at 
org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:883)
           at 
org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:1034)
           at java.lang.Thread.run(Thread.java:748)
   2024-08-15 16:39:45.728 seatunnel host-10-19-11-19 INFO [tr:,sp:] 
[qtp431939256-19] [JdbcCatalogUtils.getTables():76] - Loading catalog tables 
for catalog : class 
org.apache.seatunnel.connectors.seatunnel.jdbc.catalog.mysql.MySqlCatalog
   2024-08-15 16:39:45.728 seatunnel host-10-19-11-19 INFO [tr:,sp:] 
[qtp431939256-19] [AbstractJdbcCatalog.open():130] - Catalog MySQL established 
connection to 
jdbc:mysql://127.0.0.1:3380/test1?useUnicode=true&characterEncoding=UTF-8&rewriteBatchedStatements=true
   2024-08-15 16:39:45.741 seatunnel host-10-19-11-19 INFO [tr:,sp:] 
[qtp431939256-19] [JdbcCatalogUtils.getTables():118] - Loaded 1 catalog tables 
for catalog : class 
org.apache.seatunnel.connectors.seatunnel.jdbc.catalog.mysql.MySqlCatalog
   2024-08-15 16:39:45.742 seatunnel host-10-19-11-19 INFO [tr:,sp:] 
[qtp431939256-19] [AbstractJdbcCatalog.close():144] - Catalog MySQL closing
   2024-08-15 16:39:45.743 seatunnel host-10-19-11-19 INFO [tr:,sp:] 
[qtp431939256-19] [FactoryUtil.createAndPrepareSource():86] - get the 
CatalogTable from source Jdbc: jdbc_catalog.default.default.default
   2024-08-15 16:39:45.756 seatunnel host-10-19-11-19 INFO [tr:,sp:] 
[qtp431939256-19] [AbstractPluginDiscovery.<init>():113] - Load SeaTunnelSource 
Plugin from /app01/seatuunel/apache-seatunnel-2.3.6/connectors
   2024-08-15 16:39:45.757 seatunnel host-10-19-11-19 INFO [tr:,sp:] 
[qtp431939256-19] [AbstractPluginDiscovery.findPluginJarPath():444] - Discovery 
plugin jar for: PluginIdentifier{engineType='seatunnel', pluginType='source', 
pluginName='Jdbc'} at: 
file:/app01/seatuunel/apache-seatunnel-2.3.6/connectors/connector-jdbc-2.3.6.jar
   2024-08-15 16:39:45.760 seatunnel host-10-19-11-19 INFO [tr:,sp:] 
[qtp431939256-19] [MultipleTableJobConfigParser.parse():213] - start generating 
all transforms.
   2024-08-15 16:39:45.762 seatunnel host-10-19-11-19 INFO [tr:,sp:] 
[qtp431939256-19] [MultipleTableJobConfigParser.parse():216] - start generating 
all sinks.
   2024-08-15 16:39:45.763 seatunnel host-10-19-11-19 WARN [tr:,sp:] 
[qtp431939256-19] [ConfigUtil.convertValue():64] - Option 'source_table_name' 
is a List, and it is recommended to configure it as ["string1","string2"]; we 
will only use ',' to split the String into a list.
   2024-08-15 16:39:45.766 seatunnel host-10-19-11-19 INFO [tr:,sp:] 
[qtp431939256-19] [AbstractPluginDiscovery.<init>():113] - Load SeaTunnelSink 
Plugin from /app01/seatuunel/apache-seatunnel-2.3.6/connectors
   2024-08-15 16:39:45.766 seatunnel host-10-19-11-19 INFO [tr:,sp:] 
[qtp431939256-19] [AbstractPluginDiscovery.findPluginJarPath():444] - Discovery 
plugin jar for: PluginIdentifier{engineType='seatunnel', pluginType='sink', 
pluginName='Jdbc'} at: 
file:/app01/seatuunel/apache-seatunnel-2.3.6/connectors/connector-jdbc-2.3.6.jar
   2024-08-15 16:39:45.771 seatunnel host-10-19-11-19 INFO [tr:,sp:] 
[qtp431939256-19] [FactoryUtil.createAndPrepareSink():134] - Create sink 'Jdbc' 
with upstream input catalog-table[database: default, schema: default, table: 
default]
   2024-08-15 16:39:45.830 seatunnel host-10-19-11-19 INFO [tr:,sp:] 
[qtp431939256-19] [AbstractLogger.info():69] - Start submit job, job id: 
876384660119093249, with plugin jar 
[file:/app01/seatuunel/apache-seatunnel-2.3.6/connectors/connector-jdbc-2.3.6.jar]
   2024-08-15 16:39:45.906 seatunnel host-10-19-11-19 INFO [tr:,sp:] 
[qtp431939256-19] [AbstractLogger.info():69] - Submit job finished, job id: 
876384660119093249, job name: 14627940514688_job
   2024-08-15 16:39:45.942 seatunnel host-10-19-11-19 INFO [tr:,sp:] 
[ForkJoinPool.commonPool-worker-3] [JobExecutorServiceImpl.waitJobFinish():144] 
- future.get before
   2024-08-15 16:39:46.020 seatunnel host-10-19-11-19 WARN [tr:,sp:] 
[qtp431939256-18] [SeatunnelPermissionServiceImpl.funcPermissionCheck():38] - 
func permission check in seatunnel
   ```
   
   
   ### Zeta or Flink or Spark Version
   
   _No response_
   
   ### Java or Scala Version
   
   _No response_
   
   ### Screenshots
   
   _No response_
   
   ### Are you willing to submit PR?
   
   - [X] 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